Function And Service Of Dbms

A DBMS perform several important functions that guarantee integrity and consistancy of the data in the database. Most of these functions are transparent to the end users. There are the following important functions and services provided by the DBMS.
(1).Data Storage Management: It provides a mechanism for management of the permanent storage of data. The internal schema defines how the data should be stored by the storage management mechanism and the storage manager interfaces with the operating system (OS) to access the physical storage.

(2). Data Manipulation Management: A DBMS furnishes users with the ability to retrieve , update, and delete the existing data in the database.It also provides to add new data in the database by using INSERT command.
(3). Data Defination Servicies: The DBMS accepts the data defination such as external schema, the conceptual schema,the internal schema ,and all the associated mapping in source form.
(4). Data Dictionary/System Catalog Management: The DBMS provides the data dictionary or a system catalog function in which descripation of data item are stored and which is accessible to the users.
(5). Database Communication Interface:The end User "s request for database access are transmitted to DBMS in the form of a communication massage and in response the DBMS gives the desire output to the users.
(6). Authorization /Security Management: The DBMS protect the database from an unauthorized access,either international or accedental. It furnishes mechanism to ensure that only authorized users can access the database.
(7). Backup and Recovery Management: The DBMS provides the mechanisams for backing up data periodically and also recovering from different types of failure.This prevent the loss of data.
(8). Concurrency Control Service: Since DBMS supports sharing of data among multiple users, they must provide a mechanism for managing concurrent access to the database.The DBMS ensures that the database kept in the consistant state and integrity of the data is preserved.
(9). Transaction Management: A transaction is a series of database operations, carried out by a single user or application program, which accesses or changes the content sof the database.Therefore a DBMS must provide a mechnisam to ensure either that all the updates corresponding to a given transaction are made or that none of them is made.
(10). Database Access And Application Programming Interface: All DBMS provides interface to enable applications to use DBMS services.They provides data access via structure query language(SQL). The DBMS query language contain two components: (a).DDL and (b).DML .

All these funcations are basically perform by a DBA in the organiztion.Its the duty of DBA to take care of data in the database

About the Author:
CLick Here For More Gmail Tips Tricks and also learn latestFacebook Tricks

Article Originally Published On: http://www.articlesnatch.com

Tags: database

, database management

, data

Related....

Videos...

Recent Computers-and-Technology Articles

Web Page Designers - Making Your Site Unique By: Elijah James | Jun 2nd 2012 - There are two answers to building a website: first, to undertake the project on a do-it-yourself basis and, second, to hire a professional web design service. Each one has its p ...

how to make a website

Read On Hp Laserjet Pro M1217nfw Multi-purpose Printer Overview By: Tyler b riley | Jun 2nd 2012 - When the HP LaserJet Pro M1217nfw Multifunction Printer is acting like a fax, documents is usually sent and obtained from a Computer. It includes a particularly high speed of 33 ...

ink cartridges cheap

Earn Money "�" Using Affiliate Programs By: Marcus Wellington | Jun 2nd 2012 - Who would be happy to adjust in a midget income? And kill the desires which one ought to fulfill? Probably nobody! With the hiking prices of all commodities, and the fragile po ...

refurbished laptops

cheap laptops

Tips To Earn Money Through Social Networking Sites By: Marcus Wellington | Jun 2nd 2012 - Today, a lot of people tend to earn extra money, more than what they get from a full-time job. The reason for this is that the prices of commodities are going high constantly. A ...

refurbished laptops

cheap laptops

All About Brainhost.com Packages By: Hanson Raider | Jun 2nd 2012 - With financial crisis breaking in the world's largest economies, an even faster trend of entities going online emerged. The biggest reason of firms vouching for web presence is ...

hosting from brainhost

Hp Color Lasejet Cm6030 Printer: An Expert's Neutral Feedback By: Tyler b riley | Jun 2nd 2012 - The competent look and feel of records and documents is certainly enhanced using the launch of ImageREt 4800. Images emerge with gloss-coated result that is certainly constant w ...

cheap ink

Captain Cook: Something Unbelievable Is Coming On The Way At Apple By: Linda21 | Jun 2nd 2012 - Local time, in the evening of May 29, Apples CEO Tim Cook, when presenting at the 10th All Things Digital conference sponsored by Wall Street Journal, is quoted by indicating ...

Render Fast Printing Overall Performance Using Epson Workforce 435 By: Tyler b riley | Jun 2nd 2012 - This diversified printing device provides among the many fastest printing rates of speed within the business securing 6.3 ISO pages every minute for black color paper prints and ...

generic ink cartridge for epson

Photography Equipment For Night Shots By: Mark Etinger | Jun 2nd 2012 - The kind of photography equipment you'll need for night shots

compact digital cameras

Weird Facts And Tips About Ipad 2 By: Ahmed Jamil | Jun 2nd 2012 - IPad 2 is amazing gadget with dual processor with high processing speed but not full featured like a laptop or a desktop computer. IPad 2 is hot selling gadget worldwide. By fol ...

Comments

Still can't find what you are looking for? Search for it!

Site Navigation: