Week 11 - Muddy

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.

The DBMS is marketed in many forms. Some of the more popular examples of DBMS solutions include Microsoft Access and Filmmaker. 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. The first is the implementation of a modeling language that serves to define the language of each database that is hosted via the DBMS. Second, data structures also are administered by the DBMS. Data structures are what allow DBMS to interact with the data without causing and 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 log in data, the assignment of access rights and privileges, and the definition of the criteria that must be employed to add data to 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.


http://en.wikipedia.org/wiki/Database_management_system

0 comments:

Newer Post Older Post Home