DB Lec 06

1
Database Systems
Lecture 6
The Database System Database Management Systems

Environment
2
Database Management S
ystems
Today’s agenda
• The Database System Environment
▫ DBMS Component Modules
▫ Database System Utilities
▫ Application Environments
▫ Communications Facilities
3
ystems
DBMS Component Modules

• Top half of figure refers to various users of the database environment and
their interfaces, while the lower half shows the internals of the DBMS
responsible for data storage and transaction processing.
• A higher-level stored data manager module of the DBMS controls access

to DBMS information that is stored on the disk, whether it is part of the
database or the catalog.
• The DDL compiler processes schema definitions specified in the DDL, and
stores descriptions of the schemas (meta-data) in the DBMS catalog.
• The catalog includes information such as names and sizes of files, names and
data-types of data items, storage details, mapping information, constraints
and so on
4
ystems

• The query compiler handles high-level queries that are
entered interactively. (parses and analyzes a query).
•
• Query optimizer is concerned with rearrangement and
possible reordering of operations, elimination of
redundancies and use of correct algorithm.
• The pre-compiler extracts DML commands from an

application program written in a host programming
language. These commands are sent to the DML compiler
for compilation into object code for database access.
• Rest of the program is sent to host language compiler.
5
ystems

• The run-time database processor handles
database accesses at run time; it receives
retrieval or updated operations and carries them
out on the database.
6
ystems
Component of a DBMS
7
ystems

• It is now common to have the client program
that accesses the DBMS running on a separate
computer from the computer on which the
database resides. The former is called the client
computer, and the latter is called the
database server. In some cases, the client
accesses a middle computer, called the
application server, which in turn accesses the
database server.
8
ystems
Database System Utilities

• To perform certain functions such as:
• Loading It is used to load existing files into a database.
Includes data conversion tools.
• Backing up the database periodically on tape.
• Reorganizing database file structures.
• Report generation utilities.
• Performance monitoring utilities.
• Other functions, such as sorting, user monitoring,
data compression, etc.
9
ystems
Other Tools
• Data dictionary / repository:
• Other tools are often available to database designers, users and
DBMS such as CASE tools are used in the design phase of
database systems.
• Another tool that can be quite useful in large organizations is
an expanded data dictionary/repository.
• In addition to storing catalog information about schemas and
constraints, it stores other information such as design
decisions, application program descriptions, user information,
usage standards, etc. (also called information repository)
• Active data dictionary is accessed by DBMS software and
users/DBA.
• Passive data dictionary is accessed by users/DBA only.
10
ystems
Applications Development Environments
• Examples – Power builder (Sybase), JBuilder

(Borland)
• These systems provide an environment for developing

database applications and include facilities that help in
many facets of database systems, including
▫ Database design,
▫ GUI development,
▫ Querying and updating, and
▫ Application program development
11
ystems
Communications Facilities
• Its function is to allow users at locations remote
from the database system site to access the
database through computer terminals,
workstations, or their local personal computers.
• Many commercial database systems have

communication packages that work with the
DBMS. The integrated DBMS and Data
Communication system is called a DB/DC
system.

DB Lec 06

Uploaded by

Copyright:

Available Formats

DB Lec 06

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

DB Lec 06

Uploaded by

Copyright:

Available Formats

1

The Database System Database Management Systems

DBMS Component Modules

• A higher-level stored data manager module of the DBMS controls access

DBMS Component Modules

• The pre-compiler extracts DML commands from an

DBMS Component Modules

DBMS Component Modules

Database System Utilities

Applications Development Environments

• Examples – Power builder (Sybase), JBuilder

• These systems provide an environment for developing

• Many commercial database systems have

You might also like