Home >>

Functions and Importance of Database Management System (DBMS)


The functions of Database Management System(DBMS) are as follows -

Data Definition - The DBMS must be able to accept data definitions in the source form and convert them to appropriate object form . In other words , the DBMS must include DDL processor or DDL compiler components for each of the various data definition languages (DDLs) .


The functions of Database Management System(DBMS) are as follows -

Data Definition - The DBMS must be able to accept data definitions in the source form and convert them to appropriate object form . In other words , the DBMS must include DDL processor or DDL compiler components for each of the various data definition languages (DDLs) .

Data Manipulation - The DBMS must be able to handle requests to retrieve , update, or delete existing data in the database or to add new data to the database . In other words , the DBMS must include a DML processor or DML compiler component to deal with the data manipulation language (DML) .

Optimization and Execution - DML requests , planned or unplanned , must be processed by the optimizer component whose purpose is to determine an efficient way of implementing the requests . The optimized requests are then executed under the control of the run-time manager .

Data Security and Integrity - The DBMS must monitor user requests and rejects any attempts to violate the security constraints defined by the DBA (Database Administrator) .These tasks can be carried out at compile time or run-time or some mixture of the two .

Data Recovery and Concurrency - The DBMS ,some other related software component , called the transaction manager or transaction processing monitor must enforce certain recovery and concurrency controls .

Data Dictionary - The DBMS must provide a data dictionary function . The data dictionary is a database which contains "data about data" (called meta data or descriptor) . In particular , all of the various schema's and mappings and all of the various security and integrity constraints will be stored in both source and object form , in the dictionary .

Performance - The DBMS should perform all of the tasks identified above as efficiently as possible .


For more of such hot topics read my other posts here :

Visit my new website

POSTED BY jontymagicman On 2011-04-27
Add new comment Report Article

More Articles Specially Recommended for You:

Top 8 List of Lost Cities of The World

LOST CITIES Now-a-days there are many cities which are now not existing. Now the names are not mentioned because they are destroyed or abandoned. S

Written By : jontymagicman
Importance of Punctuations in English Grammar

PUNCTUATIONS Punctuation in Latin sense means a point ‘a punctum’.it is an important branch of English grammer.the use of punctuations gives more c

Written By : jontymagicman
How to Choose Good Keywords For The Seo

Keywords are the terms and phrases that your target market uses when searching the major search engines and directories for the products and services

Written By : jontymagicman
Learn The Search Engine Ranking Criteria

Each search engine has its own unique ranking criteria and its own unique algorithm, or formula, giving different weighting to each of the criteria in

Written By : jontymagicman
Muscle Cars Still Reign Supreme

During the 1950’s and 1960’s the big motor companies were in the middle of a car revolution. The nation was turned upside down with people buying musc

Written By :nikmahajan
Lost Planet 2 Playstation 3 (PS3) Version Confirmed

After lots of speculations, Lost Planet 2 Playstation 3 version is finally confirmed. There is no reason left now to deny Lost Planet 2 for PS3 as

Written By :nikmahajan
Lays Chips HARAAM: Propaganda or Truth?

Some days back I received on SMS and an Email saying that, Lays Chips (Masala Flavor) is HARAAM. On the back of the Lays chips “E631 Fat”

Written By :ubpl
VolksWagen Polo - The Same But Different

Despite the facts that the new VolksWagen Polo resembles the old one and that it is also similar to the VW Golf MkVI it is indeed an all new vehicle.

Written By :nikmahajan
Please Login or Sign up to Comment on the Post

COMMENTS