Database Management - Desklib

Running Head: DATA MANAGEMENT
DATABASE MANAGEMENT
Name of the Student:
Name of the University:
Author Note:

DATABASE MANAGEMENT1
Table of Contents
Answer to the question 1:...................................................................................................2
Answer to the question 2:...................................................................................................2
Answer to the question 3:...................................................................................................5
Answer to the question 4:...................................................................................................5
Answer to the question 5:...................................................................................................7
Answer to the question 6:...................................................................................................7
Answer to the question 7:...................................................................................................8
Bibliography........................................................................................................................9

DATABASE MANAGEMENT2
Answer to the question 1:
A. The key components of the DBMS architecture may vary with the implementation and
with different vendors. Some of the components may be absent or added according to
the vendor. The most important components of the DBMS are the connection manager,
the security manager, another one is the DDL compiler, and it also contains several
database utilities, one query processor and a storage manager. These are many ways
to interact with the DBMS. The catalog is used to store the DDL statements that create
the data definition. A command line interface is used to execute the interactive queries.
The interaction of the components depends on the task of the database that is being
executed. The connection manager helps in the connection of the database. The setup
can be done locally or over a network, and setting up the database over a network is
more common.
B. The DML compiler is used to compile the data manipulation statements that is being
stated in the DML. DML is the data manipulation language that is used to fetch, or insert
or delete or alter any information in the database. In a procedural DML user specifies
the data that is needed and in what way to access that data. In case of a non-procedural
or also known as declarative DML the user specifies only the data which is needed. The
non-procedural DML is also famous as high level data manipulation language. The
declarative DML is more efficient. Another name for procedural DML is record-at-a-time
DML and the DBMS which uses procedural DML does not have a query processor. The
data is accessed using the memory pointers. The declarative DML is more of a set-at-a-
time DML which can access a set of records at once to provide the application.
C. Some examples of the DBMS utilities are reorganization utility, which reorganizes the
data automatically to provide improved performance. Some other DBMS utilities are
performance monitoring utility, user management utility, and backup and recovery utility.
Some example of DBMS interfaces are web-based interface, command line interface,
stand-alone query language interface, network interface and these provided the
interaction of the DBMS with the database administrators and other parties.