DBMS-AN OVERVIEW

DATABASE MANAGEMENT SYSTEM

   The collection of inter-related data and several programs that are used to handle the data is known as Database Management System (DBMS). The main aim of DBMS is to store and efficiently retrieve the data from the database. To manage the data in the database, define the structure for storage of information and provide a proper mechanism for manipulation of information. The database system must also ensure the safety of the information that is stored.

DATABASE SYSTEM APPLICATIONS

    Several applications use a database system. Some of the applications are listed below:

  • Accounting: To maintain the data of employees, salaries, and payroll taxes in the company, students in schools, patients in hospitals, database systems are used.
  • Manufacturing: In factories, database systems are used to manage the supply chain and tracking the production of items.
  • In shopping marts: For maintaining customer, product, and purchase information of items, databases are used.
  • Banking: The database systems are useful in maintaining the customer’s account information, loan details and for maintaining the transactions of credit card history.
  • Universities: DBMS is quite useful in maintaining the student details, course details, and accounting in universities.
  • Reservation systems: To maintain the reservation and schedule information, database systems are used in airways and railways reservation systems
  • Telecommunication: For maintaining the records of the call made and generating the bills, DBMS is useful.

PURPOSE OF DATABASE SYSTEMS

  Earlier database systems are created to manage the commercial data. Data are stored in files. For adding new data or updating the data or deleting the data, various programs are written. Separate applications have to be written for the addition of new data. As time evolves, more files and more applications are required by the system. This typical file processing system is supported by an Operating system. In this system, the data is permanently stored in files. It requires different application programs for extracting or adding new information. Before the introduction of the Database Management System (DBMS), the file processing system was in use.

CHARACTERISTICS OF DATABASE SYSTEMS

  • It represents the aspects of real-world applications.
  • For managing the information systematically.
  • Multiple views for representing the data.
  • Operations such as insertion, deletion, and updating can be done efficiently.
  • A logical relationship between records and data is maintained.

ADVANTAGES OF DATABASE SYSTEMS

  • The data redundancy is removed i.e, there is no duplication of data in DBMS.
  • DBMS allows you to retrieve the desired data in an efficient way.
  • Data isolation can be done in separate tables for convenient usage.
  • A simple query language can be used to access the data.
  • In DBMS, the data integrity is maintained.
  • If some operation is performed on the particular data in one table, then the changes will be reflected on the entire database. So, the atomicity of data is maintained in DBMS.
  • Concurrent access to multiple users is possible in database systems.
  • In DBMS, we can also make the user access only the desired part of the data by restricting the access.

DISADVANTAGES OF DATABASE SYSTEMS                              

  • The complexity of database design is high. And it is also time-consuming.
  • If some failure has occurred in either software or hardware, a large amount of investment is needed to repair it.
  • The entire database may get affected if one part of the database gets affected.
  • For converting the file from a conventional file system to a database system, a large investment is needed to buy the required tools and adopting different techniques.
  • More training is needed for the people who design and maintain the database system.