Webopedia on Google+Webopedia on TwitterWebopedia on FacebookTech Bytes Blog
Main » TERM » D »

DBMS - database management system

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 DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes. 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, DBMSs 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 4GLsfor 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.







    TECH RESOURCES FROM OUR PARTNERS
    DID YOU KNOW?
    5 Best Valentines Day Ideas for Open Source Romantics

    Because nothing says "I Love You" Like an open source app. Read More »

    Guarding your Data against Cyber Attacks

    In this new era of heightened stakes comes an increased need for a comprehensive security strategy. Let's take a look at how cyber-threats have... Read More »

    The Great Data Storage Debate: Is Tape Dead?

    Tape clearly is on the decline. But remember, legacy systems can hang for a shockingly long time. Read More »

    QUICK REFERENCE
    Network Fundamentals Study Guide

    A network is a group of two or more computer systems or devices, linked together to share resources, exchange files and electronic communications.... Read More »

    Computer Architecture Study Guide

    This Webopedia  study guide describes the different parts of a computer system and their relations. Read More »

    Webopedia Polls

    The trend for the past two years has been for shoppers to spend more online during the holiday season. How do you typically shop for holiday... Read More »