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.
Posts
3 comments:
wow really exciting great job........
good notes thank you
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.
Post a Comment