What is DBMS?

Article Details
  • Written By: Malcolm Tatum
  • Edited By: Bronwyn Harris
  • Last Modified Date: 02 June 2020
  • Copyright Protected:
    Conjecture Corporation
  • Print this Article
Free Widgets for your Site/Blog
People with an annual salary of $70,000 or more are 30% more likely to shoplift than those earning $20,000 or less.  more...

June 7 ,  2006 :  Abu Musab al-Zarqawi was killed.  more...

As one of the oldest components associated with computers, the database management system, or DBMS, is a computer software program that is designed as the means of managing all databases that are currently installed on a system hard drive or network. Different types of database management systems exist, with some of them designed for the oversight and proper control of databases that are configured for specific purposes.

As the tool that is employed in the broad practice of managing databases, the DBMS is marketed in many forms. Some of the more popular examples of these solutions include Microsoft Access, FileMaker, DB2, and Oracle. All these products provide for the creation of a series of rights or privileges that can be associated with a specific user. This means that it is possible to designate one or more database administrators who may control each function, as well as provide other users with various levels of administration rights. This flexibility makes the task of using DBMS methods to oversee a system something that can be centrally controlled, or allocated to several different people.

There are four essential elements that are found with just about every example of DBMS currently on the market. The first is the implementation of a modeling language that serves to define the language of each database that is hosted via the system. There are several approaches currently in use, with hierarchical, network, relational, and object examples. Essentially, the modeling language ensures the ability of the databases to communicate with the DBMS and thus operate on the system.

Second, data structures also are administered by the DBMS. Examples of data that are organized by this function are individual profiles or records, files, fields and their definitions, and objects such as visual media. Data structures are what allows these systems to interact with the data without causing damage to the integrity of the data itself.

A third component of DBMS software is the data query language. This element is involved in maintaining the security of the database, by monitoring the use of login data, the assignment of access rights and privileges, and the definition of the criteria that must be employed to add data to the system. The data query language works with the data structures to make sure it is harder to input irrelevant data into any of the databases in use on the system.

Last, a mechanism that allows for transactions is an essential basic for any DBMS. This helps to allow multiple and concurrent access to the database by multiple users, prevents the manipulation of one record by two users at the same time, and preventing the creation of duplicate records.

You might also Like


Discuss this Article

Post 45

First of all, this is pretty cool. Having multiple administrators is very cool. That feature makes it possible to do away with hackers, that infiltrated your network.

@averagejoe: Do you know any websites that I can go to to find more info about DBMS?

Post 44

My name is kirti.. I have specialized in DBMS and SQL/ PLSQL. What type of opportunities are in this field?

Post 38

what are the types of database systems and i want to do a database system on my project and i came up with an idea of doing an information database systems which can be managing orphanage records. is it a good idea? please help.

Post 29

Right now I'm in tybcom and I want to do MBA so joined HIM, but now am confused as to concentrate on what either on cat preparation which is in november or on tybcom which falls in april.

Post 28

i score 75 percentile in cat. where could i get admission?

Post 27

i have finished my MBA and i want to do DBMS (Cognos reporting tool). do i have the option to do this course? Please give me the information.

Post 25

what are the applications of database?

Post 24

what are the emerging applications of dbms?

Post 22

What are the dbms advantages?

Post 17

i want to do an mba. how can i approach it.

Post 15

thanks. may Allah reward you for this. i was dying to know this.

Post 13

How do I connect ms access 2007 database to vb 6? And can you give me an overview of SQL? What about SQL?

Post 11

what is the use of a database?

Post 10

what are data base objects?

Post 9

please show us what are the advantages and disadvantages of DBMS.

Post 8

how do I test the efficiency of a dbms?

Post 7

I want to do my master degree in dbms. what type of opportunities will I have?

Post 6

what is the first step in data verification user access in dbms software?

Post 5

how do I test the efficiency of a dbms?

Post 1

The traditional DBMS was enhanced in the 1970s with the publishing of Codd's papers on relational databases. Out of this the RDBMS was born (i.e., the relational database management system) which was more robust and helpful than its DBMS predecessor. Most databases are actually RDBMSs.

Post your comments

Post Anonymously


forgot password?