With the help of a diagram defines typical element modules, Database Management System

Assignment Help:

With the help of a diagram defines the typical element modules of a DBMS?

The functional elements of a database system can be widely divided into:
1) Storage manager and 2) query processor

1) Storage manager components include:
(i) Authorization and integrity manager to test integrity constraints and authorized access to data.
(ii) Transaction manager to ensure in which database remains in a consistent state.
(iii) File manager to manage disk storage space.
(iv) Buffer manager is responsible for buffering data.

2) The query processor component includes:
(i) DDL interpreter to interpret DDL statements
(ii) DML compiler that translation DML queries into query evaluation plan for query evaluation engine.
(iii) Query evaluation engine execute low level instructions produced through DML compiler.

2079_Query processor.png


Related Discussions:- With the help of a diagram defines typical element modules

Principles of good e-governance, Question: (a) e-Government implementa...

Question: (a) e-Government implementations normally evolve through a multi-stage process. Describe, using appropriate examples, the stages involved in an e-Government implemen

Er diagram, Draw an ER diagram for company''s database schema

Draw an ER diagram for company''s database schema

Define the basic operations of the relational algebra, Define the basic ope...

Define the basic operations of the relational algebra?     Ans: Basic operators of relational algebra are: 1. Union (∪) - Selects tuples which are in either P or Q or in bot

ER Diagram, Hi I have got an assignment for making an er diagram for market...

Hi I have got an assignment for making an er diagram for market management software can any budy help me?

MS Access 2010 - Form Updates Table, Hi there, Have an issue with my Databa...

Hi there, Have an issue with my Database. I have: TblOrderDetails and FmOrderDetails TblCircuit and FmCircuit Whenever I add data into the Form, it will update the table as expect

Need for client server computing, Need for Client Server Computing- Client/...

Need for Client Server Computing- Client/Server (C/S) architecture includes running the application on multiple machines in which every machine with its component software tackles

Determine candidate and primary key, A video rental company has several bra...

A video rental company has several branches. The data held on each branch is the branch address made up of street, city, state, and zip code, and the telephone number. Ea

What is secondary index, What is Secondary Index While making the index...

What is Secondary Index While making the index, generally the index table is kept in the primary memory (RAM) and the main table, because of its size is keeps in the secondary

Consider relational schema and construct algebra query, Consider the follow...

Consider the following relational schema: PERSON (SS#, NAME, ADDRESS) CAR (REGISTRATION_NUMBER, YEAR, MODEL) ACCIDENT (DATE, DRIVER, CAR_REG_NO) OWNS (SS#, LICENSE) Constru

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