DBMS Concepts

DBMS Tutorial Components of DBMS. Applications of DBMS The difference between file system and DBMS. Types of DBMS DBMS Architecture DBMS Schema Three Schema Architecture. DBMS Languages.

DBMS ER Model

ER model: Entity Relationship Diagram (ERD) Components of ER Model. DBMS Generalization, Specialization and Aggregation.

DBMS Relational Model

Codd’s rule of DBMS Relational DBMS concepts Relational Integrity Constraints DBMS keys Convert ER model into Relational model Difference between DBMS and RDBMS Relational Algebra DBMS Joins

DBMS Normalization

Functional Dependency Inference Rules Multivalued Dependency Normalization in DBMS: 1NF, 2NF, 3NF, BCNF and 4NF

DBMS Transaction

What is Transaction? States of transaction ACID Properties in DBMS Concurrent execution and its problems DBMS schedule DBMS Serializability Conflict Serializability View Serializability Deadlock in DBMS Concurrency control Protocols

Difference

Difference between DFD and ERD

Misc

Advantages of DBMS Disadvantages of DBMS Data Models in DBMS Relational Algebra in DBMS Cardinality in DBMS Entity in DBMS Attributes in DBMS Data Independence in DBMS Primary Key in DBMS Foreign Key in DBMS Candidate Key in DBMS Super Key in DBMS Aggregation in DBMS Hashing in DBMS Generalization in DBMS Specialization in DBMS View in DBMS File Organization in DBMS What Is A Cloud Database What Is A Database Levels Of Locking In DBMS What is RDBMS Fragmentation in Distributed DBMS What is Advanced Database Management System Data Abstraction in DBMS Checkpoint In DBMS B Tree in DBMS BCNF in DBMS Advantages of Threaded Binary Tree in DBMS Advantages of Database Management System in DBMS Enforcing Integrity Constraints in DBMS B-Tree Insertion in DBMS B+ Tree in DBMS Advantages of B-Tree in DBMS Types of Data Abstraction in DBMS Levels of Abstraction in DBMS 3- Tier Architecture in DBMS Anomalies in Database Management System Atomicity in Database Management System Characteristics of DBMS DBMS Examples Difference between Relational and Non-Relational Databases Domain Constraints in DBMS Entity and Entity set in DBMS ER Diagram for Banking System in DBMS ER Diagram for Company Database in DBMS ER Diagram for School Management System in DBMS ER Diagram for Student Management System in DBMS ER Diagram for University Database in DBMS ER Diagram of Company Database in DBMS Er Diagram Symbols and Notations in DBMS How to draw ER-Diagram in DBMS Integrity Constraints in DBMS Red-Black Tree Deletion in DBMS Red-Black Tree Properties in DBMS Red-Black Tree Visualization in DBMS Redundancy in Database Management System Secondary Key in DBMS Structure of DBMS 2-Tier Architecture in DBMS Advantages and Disadvantages of Binary Search Tree Closure of Functional Dependency in DBMS Consistency in Database Management System Durability in Database Management System ER Diagram for Bank Management System in DBMS ER Diagram for College Management System in DBMS ER Diagram for Hotel Management System in DBMS ER Diagram for Online Shopping ER Diagram for Railway Reservation System ER Diagram for Student Management System in DBMS Isolation in DBMS Lossless Join and Dependency Preserving Decomposition in DBMS Non-Key Attributes in DBMS Data Security Requirements in DBMS DBMS functions and Components What is Homogeneous Database? DBMS Functions and Components Advantages and Disadvantages of Distributed Database

Levels of Abstraction in DBMS

Data abstraction is a way to hide unwanted or irrelevant information from the end user in DBMS. It helps in enhancing the security of data, and simplifies database design using different levels. In this article we are going to discuss what are different levels of abstraction in DBMS. Firstly, let’s start with the brief introduction of DBMS.

Introduction to DBMS

A database management system (DBMS) is a software application that interacts with the user, other applications, and the database itself to capture and analyze the data. A DBMS allows users to create, read, update, and delete (CRUD) data in a database.

Some common functions of a DBMS include:

  • Storing data in a structured format such as tables or objects.
  • Providing a way to search for and retrieve specific data from the databases.
  • Ensuring the integrity and security of the data including controlling access to the data and backing up the data to prevent loss.
  • Providing tools for organizing and analyzing the data such as reporting and data mining.
Levels of Abstraction in DBMS

Fig 1.1: DBMS structure

There are different types of DBMS, ranging from small systems that run on personal computers to large, complex systems that support the data needs of large organizations. Some examples of DBMSs include MySQL, Oracle and Microsoft SQL Server.

Characteristics of DBMS

Some key characteristics of a DBMS include:

  1. Data independence: A DBMS allows the data to be separated from the application that uses it, which means that changes to the data or to the application do not affect each other.
  2. Data security: A DBMS includes features to ensure that the data is protected from unauthorized access or modification.
  3. Data integrity: A DBMS ensure that the data is accurate, consistence and complete. It also provides mechanisms to detect and correct errors in the data.
  4. Data manipulation: A DBMS provides tools and languages for adding, modifying and deleting data in the database.
  5. Data concurrency: A DBMS allows multiple users to access and modify the data simultaneously without conflicts.

Levels of Abstraction in DBMS

In a database management system (DBMS), there are several levels of abstraction that are used to represent and manage data. These levels of abstraction include:

Levels of Abstraction in DBMS

Fig 1.2: Level of Abstraction in DBMS

  1. Physical level: This is the lowest level of abstraction in a DBMS and it deals with the storage and retrieval of data on the physical storage medium such as a hard drive or SSD. The physical level involves the organization of data into structures such as files and indexes and the use of techniques such as file mapping and buffering to optimizing data access.

    At the physical level, the DBMS must manage the allocation of space on the storage medium, which involves dividing the available space into blocks or pages and allocating these blocks or pages to the different data structure that make up the database. The DBMS must also handle issues such as file fragmentation, which occurs when the data is stored in non-contiguous blocks on the storage medium.
  2. Logical level: This level of abstraction deals with the logical representation of the data independent of the physical storage of the data. The logical level defines the structure of the data including the data types, attributes, and relationships between data entities.

    For example, the DBMS might define a “customer” entity with attributes such as “customer_id”, “name” and “address” and a “purchase” entity with attributes such as “purchase_id”, “customer_id” and “purchase_id”, “customer_id” and “purchase_date”. The DBMS would also define the relationship between these two entities such that each customer can have multiple purchases, but each purchase is associated with a single customer.
  3. View level: This level of abstraction deals with the way that the data is presented to the user or application. A view is a virtual table that is created based on a SELECT statement and it can be used to present the data in a particular way, or to hide certain data from the user.

    For example, the DBMS might provide a user interface that allows the user to browse and search the data or it might provide a set of predefined queries that the user can use to retrieve specific subsets of data. The DBMS might also provide tools for importing and exporting data, as well as for creating and modifying the data structure and relationships with in the database.
  4. Conceptual level: This is the highest level of abstraction in a DBMS and it deals with the overall structure and organization of the data in the database. The conceptual level defines the data entities, attributes, and relationships between them and it provides a high level overview of the entire database.

By using these different levels of abstraction, a DBMS can provide a flexible and efficient way to represent and manage data while hiding the complexity of the underlying physical storage and organization of the data.

Conclusion

In conclusion, a database management system (DBMS) is a software application that is used to create, maintain and manage databases. It provides a way to create, modify and access the data in a database as well as to control access to the data in a database as well as to control access to the data and ensure its integrity and security. DBMS has mainly four levels of abstraction, which are Physical level, logical level, view level, and Conceptual level. Each level has its own specification and functionality to manage data.