REQUIREMENTS FOR A DBMS

Friday, February 15, 2008 by Ankit Goyal

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.

Filed under , having  

3 comments:

Unknown said...

wow really exciting great job........

son banga jnr said...

good notes thank you

Susan said...

I felt exceptionally glad while perusing this site. This was truly exceptionally enlightening site for me. I truly preferred it. This was truly a sincere post. Much obliged!. What are some of the cheapest places to travel to in the world? From Asia to Africa and Europe, Things to do 's got budget breakdowns for the cheapest places.