Introduction to DBMS

Introduction to DBMS gives a concept of management system that controls and manages the database. The database is the collection of related data.

A database is an organized collection of related data and data is a collection of facts and figures that can be processed to produce information.

Database Management System or DBMS in short refers to the technology of storing and retrieving user’s data with utmost efficiency along with appropriate security measures. This tutorial explains the basics of DBMS such as its architecture, data models, data schemas, data independence, E-R model, relation model, relational database design, and storage and file structure, and much more. A database management system stores data in such a way that it becomes easier to retrieve, manipulate, and produce information.

Database

• Structured is controlled by a Relational database management system.
• Unstructured are those who are not in a particular format.

Data are stored in a related form actually in a table. For those data inserted in a table, users need to access them easily when needed. So, there is a management system called the Relational database management system.

DBMS

DBMS is the collection of operations like insertion, updating, and deletion to maintain and manipulate the database as required by the users.

Examples of DBMS:

• SQL server like Microsoft SQL server
• Oracle
• MySQL

The characteristics of DBMS are as follows.

• Provides security and removes redundancy
• Self-describing nature of a database system
• Insulation between programs and data abstraction
• Support of multiple views of the data
• Sharing of data and multiuser transaction processing
• DBMS allows entities and relations among them to form tables.
• It follows the ACID concept (Atomicity, Consistency, Isolation, and Durability).
• DBMS supports a multi-user environment that allows users to access and manipulate data in parallel.

Advantages of DBMS

• DBMS offers a variety of techniques to store & retrieve data
• DBMS serves as an efficient handler to balance the needs of multiple applications using the same data
• Uniform administration procedures for data
• Application programmers are never exposed to details of data representation and storage.
• A DBMS uses various powerful functions to store and retrieve data efficiently.
• Offers Data Integrity and Security
• The DBMS implies integrity constraints to get a high level of protection against prohibited access to data.
• A DBMS schedules concurrent access to the data in such a manner that only one user can access the same data at a time
• Reduced Application Development Time

Disadvantage of DBMS

• The cost of Hardware and Software of a DBMS is quite high which increases the budget of your organization.
• Most database management systems are often complex systems, so training for users to use the DBMS is required.
• In some organizations, all data is integrated into a single database which can be damaged because of electric failure, or the database is corrupted on the storage media.
• DBMS can’t perform sophisticated calculations

If you liked our content HTML Editor, then you may also like ACID properties. Please don’t forget to connect with us through our social media sites. Facebook: Online Notes Nepal, Instagram: @online_notes_nepal, LinkedIn: @onlinenotesnepal, and Twitter:@onlinenotenepal.