Database management system

From WikiMD.org
Jump to navigation Jump to search

Database Management System (DBMS)

A Database Management System (DBMS) is a software system that enables users to define, create, maintain and control access to the database. Pronounced as /ˈdeɪtəˌbeɪs ˈmænɪdʒmənt ˈsɪstəm/.

Etymology

The term "Database Management System" is derived from the English words "Database", "Management", and "System". The term "Database" comes from the word "Data" which means facts and statistics collected together for reference or analysis, and "Base", which means the underlying support or foundation for an idea, argument, or process. "Management" is derived from the Latin word "manus", meaning "hand", and "age", meaning "to lead". "System" comes from the Greek word "systēma", which means "a whole compounded of several parts or members".

Definition

A DBMS is a technology tool that directly supports data management. It provides an interface for the users to create, retrieve, update and manage data in the database. It is a layer between the physical database and the user.

Types of DBMS

There are four major types of DBMS:

  1. Relational database management system (RDBMS)
  2. Hierarchical database management system (HDBMS)
  3. Network database management system (NDBMS)
  4. Object-oriented database management system (OODBMS)

Components of DBMS

A DBMS consists of several components. Each component plays crucial roles in a database management system environment. The major components of DBMS are:

  1. Database Engine
  2. Data Definition Language (DDL)
  3. Data Manipulation Language (DML)
  4. Data Control Language (DCL)
  5. Query Processor
  6. Database Manager

Related Terms

External links

Esculaap.svg

This WikiMD dictionary article is a stub. You can help make it a full article.


Languages: - East Asian 中文, 日本, 한국어, South Asian हिन्दी, Urdu, বাংলা, తెలుగు, தமிழ், ಕನ್ನಡ,
Southeast Asian Indonesian, Vietnamese, Thai, မြန်မာဘာသာ, European español, Deutsch, français, русский, português do Brasil, Italian, polski