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
Urban Exploration: trespassing or adventure - the stuff you really should know before you urbex

What is Urban Exploration? Urban Exploration or 'Urbexing' is, put simply, an interest in deserted, abandoned and derelict

Written By :10prestoncourt
Sourcing Raffle Prizes and Auction Lots

Holding a raffle or auction is a great way to raise funds for your cause. However, you need to go about it in the right way. Who t

Written By :10prestoncourt
Event Publicity – tried and tested ways to reach the right audience

You don't need to spend lots of money to publicize your event, you just need to follow some tried and tested methods. Establish

Written By :10prestoncourt
How to create eye-catching event flyers

In a world where we are bombarded with information everywhere we go, it is very easy to overlook a neatly typed up event poster. 

Written By :10prestoncourt
Howtoee Review

Howtoee is a new revenue sharing site. It currently pays $5 per article and gives 100% revenue from Google Adsense. The site looks clean but I a

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

COMMENTS