REQUIREMENTS FOR A DBMS
REQUIREMENTS FOR A DBMS
The various softwares which handle the data in a database i.e. DBMS (like Oracle, FoxPro, SQL Server etc.) should meet the following requirements: -
1. Provide data definition facilities.
• Define Data Definition Language (DDL)
• Provide user accessible catalog (Data Dictionary)
2. Provide facilities for storing, retrieving and updating data.
• Define Data Manipulation Language (DML)
3. Support Multiple View of Data
• End User or application should see only the need data and information required.
4. Provides facilities for specifying Integrity constraints.
• Primary Key Constraints
• Foreign Key Constraints
• More General Constraints
5. Provide facilities for controlling access to data.
• Prevent unauthorized access and update.
6. Allow simultaneous access and update by multiple users.
• Provide concurrency control mechanism.
7. Support Transactions.
• A sequence of operations to be performed as a whole.
• All operations are performed or none.
8. Provide facilities for database recovery.
• Bring database back to consistent state after a failure such as disk failure, faulty program etc.
9. Provide facilities for database maintenance.
• Maintenance operations: unload, reload, mass Insertion and deletion, validation etc.
Leave a Comment