preview

a

Satisfactory Essays
DATABASE MANAGEMENT SYSTEM (DBMS) FUNCTIONS
DBMS performs several significant function to assurance the integrity and consistency of the data in the database. Lots of this function is crystal clear to end users, and most can be completed only through the use of DBMS. DBMS include data dictionary management, data storage management, and data transformation security management also multiuser access control.

1. Backup and recovery management. DBMS provides backup and data recovery procedures to make sure the data is safe and assuring the accuracy and consistency of data. Current DBMS provides special functionality that allow the Database Administrator (DBA) to execute special backup and restore procedures. Recovery management handle the recovery of the database after a failure, such as bad sector in the disk or power failure.

2. Security management. DBMS creates a security system that enforces user security and data privacy in the database. Security guideline determine which users are able to access the database, which data item for each user may access, and which data operations such as read, add, delete, or modify that the user may perform.

3. Multiuser access control. DBMS creates complex structures that allow multiuser to access the data. In order to provide data consistency as well as data integrity, DBMS use high degree of algorithms to ensure multiple users can access the database all together without compromising the integrity of the database.

4. Data integrity management. DBMS promotes and enforces integrity rules to wipe out data integrity problems, thus minimising data redundancy and maximising data consistency. The data relationship saved in the data dictionary is used to enforce data integrity. Ensuring data integrit...

... middle of paper ...

...ly structured data” because the data sources do have a structure but all data within a dataset will not contain the same structure.

Example of Unstructured Data:

REFERENCES

Smitha: Distinguih between IRS and DBMS. 2014. smitha: Distinguih between IRS and DBMS. [ONLINE] Available at: http://smithaprahlad.blogspot.com/2006/05/distinguih-between-irs-and-dbms.html. [Accessed 29 April 2014].

Data vs Information - Difference and Comparison | Diffen. 2014. Data vs Information - Difference and Comparison | Diffen. [ONLINE] Available at: http://www.diffen.com/difference/Data_vs_Information. [Accessed 29 April 2014].

Structured Data in a Big Data Environment - For Dummies . 2014. Structured Data in a Big Data Environment - For Dummies. [ONLINE] Available at: http://www.dummies.com/how-to/content/structured-data-in-a-big-data-environment.html. [Accessed 29 April 2014].
Get Access