Database Management System (DBMS)
A database management system (DBMS) is a collection of programs that enables you to store, modify, and extract information from a database. There are many different types of database management systems, ranging from small systems that run on personal computers to huge systems that run on mainframes.
Examples of Database Applications
The following are examples of database applications:
computerized library systems
automated teller machines
flight reservation systems
computerized parts inventory systems
DBMS Organization
From a technical standpoint, database management systems can differ widely. The terms relational, network, flat, and hierarchical all refer to the way a DBMS organizes information internally. The internal organization can affect how quickly and flexibly you can extract information.
Requests for information from a database are made in the form of a query, which is a stylized question. For example, the query
SELECT ALL WHERE NAME = “SMITH” AND AGE > 35
requests all records in which the NAME field is SMITH and the AGE field is greater than 35. The set of rules for constructing queries is known as a query language. Different DBMSs support different query languages, although there is a semi-standardized query language called SQL (structured query language). Sophisticated languages for managing database systems are called fourth-generation languages (or 4GLs for short).
DBMS Formats
The information from a database can be presented in a variety of formats. Most DBMSs include a report writer program that enables you to output data in the form of a report. Many DBMSs also include a graphics component that enables you to output information in the form of graphs and charts.
Read Also:
- Database Server
Database server is the term used to refer to the back-end system of a database application using client/server architecture. The back-end, sometimes called a database server, performs tasks such as data analysis, storage, data manipulation, archiving, and other non-user specific tasks.
- datagram
(dā´t&-gram) (n.) A data packet that is sent over an IP network.
- daughtercard
A printed circuit board that plugs into another circuit board (usually the motherboard). A daughtercard is similar to an expansion board, but it accesses the motherboard components (memory and CPU) directly instead of sending data through the slower expansion bus. A daughtercard is also called a daughterboard. See “What You Need to Know About Motherboards” […]
- day forward
The process of scanning, indexing and storing documents to an imaging system as they are produced or received in the normal course of business. Day forward is a term most often associated with backfile conversion.
- de facto standard
A format, language, or protocol that has become a standard not because it has been approved by a standards organization but because it is widely used and recognized by the industry as being standard. Some examples of de facto standards include: Hayes command set for controlling modems Kermit Communications Protocol Xmodem Communications Protocol Hewlett-Packard Printer […]