SQL Server : Database Management System

Database Management System :

A Database Management System (DBMS) is a set of computer programs that controls the creation, maintenance, and the use of a database. It allows organizations to place control of database development in the hands of Database Administrations (DBA's) and other specialists.

A DBMS is a system software package that helps the use of integrated collection of data records and files known as databases. It allows different user application programs to easily access the same database.

DBMS may use any of a variety of database models, such as the Hierarchical model, network model or relational model.

In large systems, a DBMS allows users and other software to store and retrieve data in a structured way. Instead of having to write computer programs to extract information, user can ask simple questions in a query language. Thus, many DBMS packages provide Fourth Generation programming language(4GLs) and other application development features. It helps to specify the logical organization for a database and access and use the information within a database. It provides facilities for controlling data access, enforcing data integrity, managing concurrency, and restoring the database from backups. A DBMS also providing the ability to logically present database information to users.

Database Management Systems offers the following services.

Database Definition :

It is a method of data storage.

Database Maintenance :

It checks whether each record has fields containing all information about one particular item. For example, in an employee table, all information about the employee like name, address, designation, salary, dept-name.

Database Manipulation :

This method helps in viewing and manipulating data.

Database Integrity :

This ensures accuracy of data.