What is database management system(DBMS)
- A database management system (DBMS) is a collection of programs that enables users to create and maintain a database.
- The DBMS is a general-purpose software system that facilitates the processes of defining, constructing, manipulating, and sharing databases among various users and applications.
- Defining a database involves specifying the data types, structures, and constraints of the data to be stored in the database.
- The database definition or descriptive information is also stored by the DBMS in the form of a database catalog or dictionary; it is called meta-data. Constructing the database is the process of storing the data on some storage medium that is controlled by the DBMS.
- Databases and database technology have a major impact on the growing use of computers.
- It is fair to say that databases play a critical role in almost all areas where computers are used, including business, electronic commerce, engineering, medicine, genetics, law, education, and library science.
- A database has the following implicit properties:
- A database represents some aspect of the real world, sometimes called the miniworld or the universe of discourse (UoD). Changes to the miniworld are reflected in the database.
- A database is a logically coherent collection of data with some inherent meaning. A random assortment of data cannot correctly be referred to as a database.
- A database is designed, built, and populated with data for a specific purpose. It has an intended group of users and some preconceived applications in which these users are interested.
Goals of DBMS
The primary goal of a DBMS is to provide a way to store and retrieve database information that is both convenient and efficient
- Manage large bodies of information.
- Provide convenient and efficient ways to store and access information.
- Secure information against system failure or tampering.
- Permit data to be shared among multiple users.
Properties of DBMS
- A Database represents some aspect of the real world. Changes to the real world reflected in the database.
- A Database is a logically coherent collection of data with some inherent meaning.
- A Database is designed and populated with data for a specific purpose.
Need of DBMS
- Before the advent of DBMS, organizations typically stored information using a “File Processing Systems”.
- Database systems are designed to manage large bodies of information.
- In addition to that the database system must ensure the safety of the information stored, despite system crashes or attempts at unauthorized access. If data are to be shared among several users, the system must avoid possible anomalous results.