Category: 

What is DBMS?

The database management system 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.
Article Details
  • Written By: Malcolm Tatum
  • Edited By: Bronwyn Harris
  • Last Modified Date: 12 October 2014
  • Copyright Protected:
    2003-2014
    Conjecture Corporation
  • Print this Article
Free Widgets for your Site/Blog
Shrek was the first movie to win an Oscar for best animated feature film.  more...

November 1 ,  1952 :  The US exploded the world's first hydrogen bomb.  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.

Ad

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.

Ad

More from Wisegeek

You might also Like

Discuss this Article

roundup
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?

anon206108
Post 44

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

anon117914
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.

anon75292
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.

anon74258
Post 28

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

anon73021
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.

anon68160
Post 25

what are the applications of database?

anon66512
Post 24

what are the emerging applications of dbms?

anon65803
Post 22

What are the dbms advantages?

anon61425
Post 17

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

anon57631
Post 15

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

DBadmin
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?

anon53918
Post 11

what is the use of a database?

anon53415
Post 10

what are data base objects?

anon52174
Post 9

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

anon39091
Post 8

how do I test the efficiency of a dbms?

anon37643
Post 7

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

anon36265
Post 6

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

anon35636
Post 5

how do I test the efficiency of a dbms?

averagejoe
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

Login

username
password
forgot password?

Register

username
password
confirm
email