Functions of DBMS Flashcards
DBMS stores definitions of the data elements and their relationships (metadata) in a data dictionary.
Dictionary Management
The DBMS uses the data dictionary to look up the required data component structures and relationships which relieves you from coding such complex relationships in each program.
Dictionary Management
One of the DBMS functionality is creating and managing the complex structures required for data storage, thus relieving you from the difficult task of defining and programming the physical data characteristics.
Data Storage Management
The DBMS transforms entered data in to required data structures.
Data Transformation and Presentation
The DBMS creates a security system that enforces user security and data privacy. Security rules determine which users can access the database, which data items each user can access, and which data operations the user can perform.
Security Management
This is especially important in multiuser database systems.
Security Management
To provide data integrity and data consistency, the DBMS uses sophisticated algorithms to ensure that multiple users can access the database concurrently without compromising the integrity of the database.
Multi User Access Control
The DBMS provides backup and data recovery to ensure data safety and integrity. Recovery management deals with the recovery of the database after a failure, such as a bad sector in the disk or a power failure.
Backup and Recovery Management
The DBMS promotes and enforces integrity rules, thus minimizing data redundancy and maximizing data consistency.
Data Integrity Management
The DBMS provides data access through a query language.
Database Access Languages and Application Programming Interfaces
It is a non -procedural language— one that lets the user specify what must be done without having to specify how it is to be done.
Query Language
It is the de facto query language and data access standard supported by the majority of DBMS vendors.
Structured Query Language (SQL)
SQL
Structured Query Language
End users can generate answers to queries by filling in screen forms through their preferred Web browser.
Database Communication Interfaces
