Data Storage and Querying in DBMS
Last Updated : 24 Jul, 2024
Database Management System is the collection of interrelated data/information or a set of programs that manages controls, and accesses the use of data. Through DBMS, users can manage the data efficiently in a database to increase accessibility and productivity. For example – Employee records and telephone Books have all the different contacts saved in a single place very efficiently.
So, a Database System is a software system, having an organized collection of structured information, stored in a computer system. It enables the user to create, maintain, define, and control access to the database.
Uses of DBMS
- To increase productivity through real-time component data.
- For Reducing the data redundancy and inconsistency.
- To enhance the data integrity.
- For Retrieving the data.
- For Data Security.
- For Data Indexing.
For more details, you can read the article Application of DBMS.
The Database System is further divided into two components. They are as follows:
- Data Storage Manager
- Query Manager
Data Storage Manager
Data Storage Manager also known as “Database Control System”, is generally a program that provides an interface between the data/information stored and the queries received. It helps us to maintain the integrity and consistency of the database by applying the constraints. It is a highly flexible and scalable product that provides us with the capability of fully managed storage.
Storage Manager is generally in charge of the interactions with the File Manager, where raw data is stored on the data with the help of the file system. It translates various DML statements into low-level commands.
- Authorization and Integrity Manager: The main purpose of the Authorization and Integrity Manager is to ensure the satisfaction of the integrity constraints and checks the authority of users to access information.
- Transaction Manager: The main purpose of Transaction Manager is to ensure that even after the system failures, the database should remain in a uniform state.
- File Manager: The main purpose of File Manager is to manage the allocation of space on the disk storage.
- Buffer Manager: The main purpose of Buffer Manager is to fetch the data from disk storage into the main memory. The buffer manager is a critical part of the database system since it enables the database to handle data sizes that are much larger than the size of the main memory.
The storage manager implements several data structures as part of the physical system implementation:
- Data files, which store the database itself.
- Data dictionary, which stores metadata about the structure of the database, in particular the schema of the database.
- Indices, which can provide fast access to data items. Like the index in this textbook, a database index provides pointers to those data items that hold a particular value. For example, we could use an index to find the instructor record with a particular ID, or all instructor records with a particular name. Hashing is an alternative to indexing that is faster in some but not all cases.
Query Processor
Query Processor contains the following three components:
- DDL Interpreter: The DDL Interpreter is the Data Definition Language Interpreter which is used to build and modify the structure of your tables and other objects in the table. DDL interpreter, which interprets DDL statements and records the definitions in the data dictionary.
- DML Compiler: DML Compiler is the Data Manipulation Language which is used for adding (inserting), deleting, and modifying (updating) data in a database. or we can say translating the DML statements into query language consists of low-level instructions that only query engines can understand. A query can usually be translated into any of a number of alternative evaluation plans that all give the same result. The DML compiler also performs query optimization; that is, it picks the lowest cost evaluation plan from among the alternatives.
- Query Evaluation Engine: It executes the low-level language instructions, generated by DML Compiler.
Conclusion
In Conclusion, maintaining and obtaining valuable information from massive datasets depends on efficient data storage and querying in DBMS. A strong database system is successfully implemented and maintained with careful attention to data integrity and security, scalability concerns, query optimization, and suitable storage structure design.
Similar Reads
What is a Query in DBMS?
In the field of Database Management Systems (DBMS), a query serves as a fundamental tool for retrieving, manipulating, and managing data stored within a database. Queries act as the bridge between users and databases, enabling them to communicate with the system to extract specific information or pe
5 min read
Database Languages in DBMS
Databases are essential for efficiently storing, managing, and retrieving large volumes of data. They utilize both software and hardware components. The software provides an interface that enables users or applications to interact with the database, while the hardware consists of servers and storage
10 min read
Instance in Database
An instance shows the data or information that is stored in the database at a specific point in time. In this article we will come to know about, what is Instances in databases. We will see two examples related to it as well. But first of all, let us know about some terminologies related to it. Prim
3 min read
Indexing in Databases - Set 1
Indexing is a crucial technique used in databases to optimize data retrieval operations. It improves query performance by minimizing disk I/O operations, thus reducing the time it takes to locate and access data. Essentially, indexing allows the database management system (DBMS) to locate data more
8 min read
Data Models in DBMS
A Data Model in Database Management System (DBMS) is the concept of tools that are developed to summarize the description of the database. Data Models provide us with a transparent picture of data which helps us in creating an actual database. It shows us from the design of the data to its proper im
8 min read
Building a Data Warehouse in DBMS
A Data warehouse is a heterogeneous collection of different data sources organized under unified schema. Builders should take a broad view of the anticipated use of the warehouse while constructing a data warehouse. During the design phase, there is no way to anticipate all possible queries or analy
5 min read
What is Data Abstraction in DBMS?
Data Abstraction is one of the most important concepts in DBMS. Data abstraction is the process of hiding unwanted and irrelevant details from the end user. It helps to store information in such a way that the end user can access data which is necessary, the user will not be able to see what data is
3 min read
Purpose of Database System in DBMS
Nowadays organizations are data-dependent. efficient management and retrieval of information play a crucial role in their success. A database is a collection of data that is organized, which is also called structured data. It can be accessed or stored in a computer system. It can be managed through
3 min read
Codd's Rules in DBMS
Codd's rules are proposed by a computer scientist named Dr. Edgar F. Codd and he also invent the relational model for database management. These rules are made to ensure data integrity, consistency, and usability. This set of rules basically signifies the characteristics and requirements of a relati
3 min read
SQL Query to Select Data from Tables Using Join and Where
In SQL, the JOIN clause combines data from multiple tables based on a common column, while the WHERE clause filters the results based on specific conditions. Together, they allow us to retrieve relevant data efficiently from related tables. This article will guide us in using SQL JOIN and WHERE clau
5 min read