Database manager, Database Management System

Assignment Help:

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.

Related Discussions:- Database manager

Design an entity relation model, Funky Festivals Specification Funky Fe...

Funky Festivals Specification Funky Festivals organise music festivals which take place at various venues throughout the UK.  A venue needs to be booked before a Festival can t

Define 2nf normal form, 2NF Normal Form : A relation schema process R i...

2NF Normal Form : A relation schema process R is in 2NF if it is in 1NF and each non-prime attribute A in R is fully functionally related on primary key. Second normal form (2N

Hashing techniques, folding method and mid square method using visual basic...

folding method and mid square method using visual basic

The file based system in dbms, The File Based System File based systems...

The File Based System File based systems are an early attempt to computerise the manual filing system. For example, a manual file can be set up to hold all the correspondence r

Functional dependencies, CAR SALE (Car_id, Option_type, Option_listprice, S...

CAR SALE (Car_id, Option_type, Option_listprice, Sale_date, Option_discountedprice) This relation refers to options installed in cars (e.g., cruise control) that were sold at a de

Introduction to Database Design and Development, Every School has many teac...

Every School has many teachers and many students. Each student is assigned to one school and each teacher works for one school only. Each teacher teaches more than one subject but

How can we classify the operations on classes, How can we Classify the oper...

How can we Classify the operations on classes  This step fundamentally means all three models functional, object and dynamic (studied in last section) must be combined so that

Discuss the different layers of ansi sparc architecture, Q.1 Briefly discus...

Q.1 Briefly discuss the different layers of ANSI SPARC architecture. Ans: The three layers of ANSI SPARC architecture are like this: 1. Internal view is at the lowest leve

Create a er diagram to show customer accounts, Information about a bank is ...

Information about a bank is about customers and their account. Customer has a name, address that consists of house number, area and city, and one or more phone numbers. Account ha

Explain two phase locking protocol, Explain Two phase locking protocol ...

Explain Two phase locking protocol A transaction is consider as to follow the two-phase locking protocol if all locking operations precede the first unlock operation in the tra

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd