DBMS is the abbreviation for Database Management System. It refers to the technology that is used for creating and managing all the system’s databases. DBMS is basically a software tool that helps in the organization (creation, retrieval, updation, and management) of data and info present in any system’s database.
In this article, we will look more into the Introduction to DBMS according to the GATE Syllabus for (Computer Science Engineering) CSE. We will read ahead to find out more about it.
Table of Contents
What is DBMS?
DBMS or Database Management System is basically a computerised data-keeping system. Here, the users of a system are provided with facilities to perform multiple operations on it. These are either done to manipulate data in the database or manage the database structure itself. The DBMS is primarily categorised according to its data structures or types.
Characteristics of DBMS
- DBMS uses a digital repository that is established on a server for the storage and management of the information.
- It consists of automatic backup as well as recovery procedures.
- DBMS can provide a logical and clear view of the processes that manipulate the data.
- DBMS contains automatic backup and recovery procedures.
- It consists of ACID properties that maintain data in a fairly healthy state whenever a failure occurs.
- DBMS can reduce the overall complex relationship established between data or sets of data.
- DBMS can also support data manipulation and processing.
- It provides data security.
- DBMS can view a database from additional viewpoints as per the user requirements.
Uses of DBMS
Users can employ DBMS to perform the following tasks:
- Data Retrieval: Retrieval of the data from the database that can be used by various apps for various purposes.
- Data Definition: Creation, modification, or removal of the data that defines the database’s organization in the computer system.
- Data Updation: Insertion, modification, or deletion of the real data in or from the database.
- User Administration: Registration and monitoring of users, maintenance of data integrity, monitoring performance, enforcement of data security, concurrency control and recovering useful information corrupted due to unexpected failure.
Pros of DBMS
- Multiple User Interface: DBMS provides users with different types of UI like graphical UI, application program interfaces (API), etc.
- Controls Database Redundancy: DBMS can also control data redundancy since it stores all the information in a single database file, while this recorded data is put in the database.
- Reduce Time: It reduces the time of development and the need for maintenance.
- Data Sharing: Authorised users in an organization can easily share data and info among multiple other users in DBMS.
- Easily Maintenance: DBMS can be easily maintained because of the database system’s centralised nature.
- Backup: DBMS provides users with subsystems of backup and recovery that create an automatic backup of data from the software and hardware failures. It can also even restore the data whenever required.
Cons of DBMS
- Cost of Hardware and Software: We require a high-speed data processor and a fairly large memory size in order to run any DBMS software.
- Size: DBMS occupies large disk space and fairly large memory in order to run efficiently.
- Complexity: Additional complexity and requirements are created by the database systems.
- Higher Impact of Failure: Failure impacts the database a lot because, in a majority of organizations, all the data is usually stored in a single database. Thus, in case the database is damaged as a result of any database corruption or electric failure, then the data can even be lost forever.
DBMS Notes
Normal Forms
Decomposition
Types of Keys
Dependencies
Relational Model
ACID Properties
Transactions
File Organization
ISAM
Anomalies
Codd’s Rules
Data Models
Types of Relationships
Indexing
Hashing
DBMS MCQs
DBMS Related Difference Between Articles
Video on DBMS Complete Revision
Keep learning and stay tuned to get the latest updates on GATE Exam along with GATE Eligibility Criteria, GATE 2023, GATE Admit Card, GATE Syllabus, GATE Previous Year Question Paper, and more.
Also Explore,
