Site home page
Get alerts when Linktionary is updated
Book updates and addendums
Get info about the Encyclopedia of Networking and Telecommunicatons, 3rd edition (2001)
Download the electronic version of the Encyclopedia of Networking, 2nd edition (1996). It's free!
Contribute to this site
Electronic licensing info
DBMS (Database Management System)
Note: Many topics at this site are reduced versions of the text in "The Encyclopedia of Networking and Telecommunications." Search results will not be as extensive as a search of the book's CD-ROM.
A DBMS is a software program that typically operates on a database server or mainframe system to manage structured data, accept queries from users, and respond to those queries. A typical DBMS has the following features:
Most DBMS systems are client/server based and operate over networks. The DBMS is an engine that typically runs on a powerful server or cluster of servers, in a SAN (storage area network) environment or mainframe with a high-performance channel to a large data store. The DBMS accepts requests from clients that may require sorting and extracting data. Once the server has processed the request, it returns the information to the client.
There are a variety of back-end database systems, clients, and methods of access. Database middleware products are designed to provide a middle layer of software that hides the differences among databases. ODBC (Open Database Connectivity), originally designed by Microsoft, has been one of the most popular middleware products. The section "Database Connectivity" later in this topic discusses middleware. Also see the topic "Middleware and Messaging."
The common language for accessing most database systems is SQL (Structured Query Language), which is discussed under the main SQL heading, "SQL (Structured Query Language)." Z39.50 is an open ANSI standard that allows database searching and information retrieval among networked systems. See "Z39.50."
Metadata is information that describes data in a database. A raw data file would appear as a mass of letters, numbers, and symbols; but by knowing the format and structure of how that data is stored, you can display the data as records, fields, attributes, and elements with specific rules and properties (i.e., some fields are locked or the data is displayed a certain way). A metadata file provides this knowledge. Recall the Mars spacecraft that burned up in Mars orbit. The company that built the spacecraft was working with acceleration data in English units of pounds of force. NASA entered the data into a computer that assumed metric units called newtons. This was a tragic metadata error, in which the description of the data was misinterpreted. See "Metadata" for more information.
Most databases are operational databases, meaning that data going into the database is used in real time to support the ongoing activities of a business. A point-of-sale business accounting system is an example. As items are sold, the inventory database is updated and the inventory information is made available to the sales staff. The invoicing, order entry, and related systems are also updated.
Data analysts use OLAP (online analytical processing) systems to analyze database information in order to find trends or make business decisions. A data warehouse is a large-scale OLAP and/or data mining system that is specifically designed to extract, summarize, combine, clean up, and process information from a number of data sources-such as the operational databases, legacy (historical) databases, and online subscription databases-for the purpose of analysis. Metadata is especially important in this environment. See "Data Warehousing" for more information.
This topic continues in "The Encyclopedia of Networking and Telecommunications" with a discussion of the following:
Copyright (c) 2001 Tom Sheldon and Big Sur Multimedia.