Database Concepts for the Systems Analyst
Databases
- Database Architecture:
- Many DBMSs don’t require the use of a DDL to construct the database, or a DML to access the database.
- They provide their own tools and commands to perform those tasks. This is especially true of PC-based DBMSs.
- Many DBMSs also include proprietary report writing and inquiry tools to allow users to access and format data without directly using the DML.
- Some DBMSs include a transaction processing monitor (or TP monitor) that manages on-line accesses to the database, and ensures that transactions that impact multiple tables are fully processed as a single unit.