Database Manager

It is the interface among low-level data, queries and application programs. Databases typically need a large amount of storage space. It is kept on disks, as the main memory of computers has not store this information. Data is moved among disk storage and main memory as needed. Hence the movement of data to and from disk is slow relative to the speed of the control processing unit of computers; it is essential that database system structure data so as to decrease the need to move data between main memory and disk.

A database manager is a program module liable for interfacing with the database file system to the user questions. In addition, the tasks of enforcing constraints to keep the consistency and integrity of the data as well as its security are also done by database manager. Synchronising the concurrent operations performed by concurrent users is under the control of the data manager. It also done backup and recovery operations. Let us summarise now the vital responsibilities of Database manager.

• Interaction with file manager: The raw data is kept on the disk using the file system which is usually given by a conventional operating system. The database manager changes the various DML statements into low-level file system commands. Therefore, the database manager is responsible for the real storing, retrieving and updating of data in the database.
• Integrity enforcement: The data values stored in the database must assure certain types of consistency constraints. For instance, the balance of a bank account may never drop below a prescribed amount (for example, Rs. 1000/-). Likewise the number of holidays per year an employee may be having should not go over 8 days. These constraints must be specified explicitly by the DBA. If such constraints are given, then the database manager can check whether updates to the database result in the violation of any of these constraints and if so appropriate action may be imposed.
• Security enforcement: As talk about above, not every user of the database wants to have access to the entire content of the database. It is the job of the database manager to enforce these security needs.
• Backup and recovery: A computer system like any other electrical or mechanical device is subject to failure. There are a several of causes of such failure, including power failure, disk crash, and software errors. In each of these cases, information regarding the database is lost. It is the liability of database manager to detect such failures and restore the database to a state that existed prior to the occurrence of the failure. This is generally accomplished through the backup and recovery procedures.
• Concurrency control: When various users update the database simultaneously, the consistency of data may no longer be preserved. It is required for the system to control the interaction between the concurrent users, and reaching such a control is one of the responsibilities of database manager.

Posted Date: 3/5/2013 5:15:05 AM | Location : United States

Ask an Expert

Related Discussions:- Database manager, Assignment Help, Ask Question on Database manager, Get Answer, Expert's Help, Database manager Discussions

Write discussion on Database manager
Your posts are moderated

Write your message here..

Related Questions

Explain the cascadeless schedule, Explain the Cascadeless Schedule A ca... Explain the Cascadeless Schedule A cascadeless schedule is one in which for every pair of transactions Ti and Tj like that Tj reads a data item before written by Ti, the commit

Main difference between read-only and update methods, What is the main diff... What is the main difference between read-only and update methods? A read-only method does not affect the values of a variable in an object, whereas an update method may alter t

Enumerate about the high-level transitions result, Show, with the help of a... Show, with the help of an example, that relatively high-level transitions result when system or program is stimulated by the outside events. In diagram below, we can observe i

Data aggregation, Q.   Explain  data aggregatio n and discuss differen... Q.   Explain  data aggregatio n and discuss different design constraints. Sol. Aggregation   One limitation of the E-R model is that it cannot express relationships amon

Define single valued and multivalued attributes, Define single valued and m... Define single valued and multivalued attributes. Single valued attributes: attributes with a single value for a particular entity are known as single valued attributes. Mult

What is bankers algorithm, What is banker's algorithm?  Banker's algori... What is banker's algorithm?  Banker's algorithm is a deadlock avoidance algorithm that is applicable to a resource-allocation system with multiple instances of each resource ty

Develop database academic assignment, Develop Database academic assignment ... Develop Database academic assignment Project Description: For a provided set of instructions in a case study design Entity Relationship Diagram. - Entity Relationship Diag

Determine advantages of merging an association into a class, What are the a... What are the advantages and disadvantages of merging an association into a class?  Advantages: i)  Less number of tables ii) Faster performance due to the fewer tables

design the logic using looping structure, 1. Design the logic, using a loo... 1. Design the logic, using a looping structure, for a program that outputs every even number from 1 through 25 along with its square and cube. 2. Mr. Sanchez owns 12 apartme

Creating views with replace option, Creating views with Replace option : Th... Creating views with Replace option : This option is used to alter the definition of the view without recreating and dropping it or regranting object privileges previously granted o