Page 177 - DCAP104_EXPOSURE_TO_COMPUTER_DISCPLINES

Exposure to Computer Disciplines

Notes
A database management system (DBMS) consists of software that operates
databases, providing storage, access, security, backup and other facilities.

8.2.1 Building Blocks of DBMS

8.2.1.1 Components
(a) DBMS Engine accepts logical requests from various other DBMS subsystems, converts
them into physical equivalents, and actually accesses the database and data dictionary as
they exist on a storage device.
(b) Data Definition Subsystem helps the user create and maintain the data dictionary and
define the structure of the files in a database.
(c) Data Manipulation Subsystem helps the user to add, change, and delete information in a
database and query it for valuable information. Software tools within the data manipulation
subsystem are most often the primary interface between user and the information contained
in a database. It allows the user to specify its logical information requirements.
(d) Application Generation Subsystem contains facilities to help users develop transaction-
intensive applications. It usually requires that the user perform a detailed series of tasks to
process a transaction. It facilitates easy-to-use data entry screens, programming languages,
and interfaces.
(e) Data Administration Subsystem helps users manage the overall database environment by
providing facilities for backup and recovery, security management, query optimization,
concurrency control, and change management.

Figure 8.7: Components of DBMS

DATPROF DATPROF
Integrate ETL-Object Library
Integrate Developer
DATPROF
Meta data Repository
Development
Integrate Runtime
Scheduler
Generated application
Monitor
Explaitation
JAVA
Operating System
CRM
System ERP Oracle
Architecture
(example)
HRM
Data warehouse
Data marts
Data sources
8.2.1.2 Modeling Language
A modeling language is a data modeling language to define the schema of each database hosted
in the DBMS, according to the DBMS database model. Database management systems (DBMS)

170 LOVELY PROFESSIONAL UNIVERSITY