Database Management Simplified

Ross Group Inc  MemberzPlus  Blogs  |  News  |  Careers  |  Contact    Twitter CommitDBA LinkedIn CommitDBA

CommitDBA Blogs

See What we are Talking About!

CommitDBA Blog

What Is a Database Management System (DBMS)?

September 14, 2016

A Database Management System (DBMS) like Oracle and SQL Server comprises complex software and software tools designed to logically store data for enterprise applications to access. The DBMS requires a Database Administrator (DBA) to manage a database. The DBMS is composed mainly with three primary elements: the data itself, the database engine, and the database schema.

The database core consists of tablespaces that contain critical data. At a high level, one shouldn’t think of a database as a single document where all your data is stored; instead, think of it as a file folder or a series of file folders that hold numerous files inside them.

The database engine is the complex software component of the DBMS that allows users to create, read, update, and delete (CRUD) data from the database. The database engine is able to work seamlessly while orchestrating online transaction processing (OLTP) in parallel with users querying the database for reporting and analytical purposes.

The database schema is the data structure supported by the DBMS. The schema uses a database language (i.e., SQL, NoSQL, etc.) to establish what data can and cannot be inserted or extracted in the database. There are two primary types of database schemas: logical and physical. A logical database schema communicates the logical constraints that apply to the data with tablespaces for example; while a physical database schema or structure establishes how the data is physically stored on a server.

Today’s Primary Types of DBMS:

  • Relational Database Management System (RDBMS). This is probably the most common of all DBMS environments. The relational DBMS is a system of tables that are linked together through their common relationships/fields. The use of multiple tables and common fields gives the relational DBMS much more versatility for the logical layout of data.
  • NoSQL Database Management Systems (NDBMS). NoSQL provides a mechanism for storage retrieval of data which is modeled in means other than the tabular relations used in an RDBMS.
  • Object-Oriented Database Management System (ODBMS). An Object-Oriented DBMS is a system that allows for the creation and modeling of data in the form of objects. The object-oriented DBMS combines object oriented programming principles with the principles of database management. An object-oriented DBMS can have several advantages over other systems—including over a relational DBMS—but also some disadvantages.

    From database assessments to complete database management, CommitDBA can assist your company today. For more information about how CommitDBA can work for you – give us a call at (844) 220-4272.