What is DBMS?
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.
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?
My name is kirti.. I have specialized in DBMS and SQL/ PLSQL. What type of opportunities are in this field?
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.
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.
i score 75 percentile in cat. where could i get admission?
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.
what are the applications of database?
what are the emerging applications of dbms?
What are the dbms advantages?
i want to do an mba. how can i approach it.
thanks. may Allah reward you for this. i was dying to know this.
How do I connect ms access 2007 database to vb 6? And can you give me an overview of SQL? What about SQL?
what is the use of a database?
what are data base objects?
please show us what are the advantages and disadvantages of DBMS.
how do I test the efficiency of a dbms?
I want to do my master degree in dbms. what type of opportunities will I have?
what is the first step in data verification user access in dbms software?
how do I test the efficiency of a dbms?
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