DBMS

Tuesday, February 12, 2008 by Ankit Goyal

DBMS

A database is a very well organized collection of data so as to be able to carry out operations like Insertion, deletion, updation and retrieval. Thus, a database needs to be managed by an appropriate package of software which is called DBMS (Database Management System).

The Primary purpose of a DBMS which is basically a collection of programs is to allow a user to store, update, retrieve data and thus make it easy to maintain and retrieve information from a database. The DBMS relieves the user from knowing how the data is stored physically and complex algorithms used for performing operations on the database. It only concentrates on how the operations are to be performed to retrieve the data from the database.

The DBMS is in charge of access, security, storage and host of other functions for the database system. It does this through a selection of computer programs. This allows it to manage the large, structured sets of data, which makes up the database and provides access to the data for multiple, concurrent users while maintaining the Integrity of the data.

The DBMS provides security facilities in a variety of forms, both to prevent unauthorized access and to prevent authorized users from accessing data concurrently without any inconsistency in the database. To prevent data from unauthorized users from accessing the system it users passwords to identify operators, programs and individual machines and set of privileges assigned to them. These privileges can include the ability to read, write and update data in database.

As we know that, DBMS is a collection of programs which acts as an intermediator between the user and the database. Since databases can be of small size like database maintained in a small organization or huge ones like database of large organizations so there are different types of DBMS ranging from small systems that run on personal computers to huge systems that run on mainframes.

The Various Applications Using DBMS Are: -

• Super Market Product Inventory System

• Stock Trading Systems

• Computerized Library Systems

The various commercially available database Management Systems.

For the small organizations-MS-Access, File Maker Pro, DB Text Works, Superbase etc.

• For the enterprise (client/server) - Oracle, SQL Server, FoxPro, Sybase, DB2, Informix, Paradox, Dbase etc.

Filed under having  

0 comments: