Page 184 - DCAP104_EXPOSURE_TO_COMPUTER_DISCPLINES

Unit 8: Database System

8.6 Summary Notes

• Database is a system intended to organise, store and retrieve large amounts of data easily.
• DBMS is a tool that is employed in the broad practice of managing databases.

• Distributed database management system (ODBMS) is collection of data which logically
belong to the same system but are spread out over the sites of the computer network.

• A modelling language is a data modelling language to define the scheme of each database
hosted in DBMS.
• Data structures optimized to deal with very large amount of data stored on a permanent
data storage device.

8.7 Keywords

Analytical database: Analysts may do their work directly against a data warehouse or create a
separate analytic database for Online Analytical Processing.
Data definition subsystem: It helps the user create and maintain the data dictionary and define
the structure of the files in a database.

Data structure: Data structures optimized to deal with very large amounts of data stored on a
permanent data storage device.
Data warehouse: Data warehouses archive modern data from operational databases and often
from external sources such as market research firms.
Database: A database is a system intended to organize, store, and retrieve large amounts of
data easily. It consists of an organized collection of data for one or more uses, typically in
digital form.

Distributed database: These are databases of local work-groups and departments at regional
offices, branch offices, manufacturing plants and other work sites.
End-user database: These databases consist of data developed by individual end-users.
Hypermedia databases: The World Wide Web can be thought of as a database, albeit one spread
across millions of independent computing systems.
Microsoft access: It is a relational database management system from Microsoft that combines
the relational Microsoft Jet Database ls.

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.

Object database models: In recent years, the object-oriented paradigm has been applied in
areas such as engineering and spatial databases, telecommunications and in various scientific
domains.

Operational database: These databases store detailed data about the operations of an organization.
Post-relational database models: Products offering a more general data model than the relational
model are sometimes classified as post-relational.
The DBMS: It is a computer software program that is designed as the means of managing all
databases that are currently installed on a system hard drive or network.

LOVELY PROFESSIONAL UNIVERSITY 177