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.