logo
logo
Sign in

Everything You Need To Know About the Working of Database Management System (DBMS)

avatar
Pooja salve
Everything You Need To Know About the Working of Database Management System (DBMS)

The working of a Database Management System (DBMS) can be divided into five key stages: data modeling, database design, database implementation, data manipulation, and data analysis.


Data Modeling: The first stage in the working of a DBMS is data modeling. Data modeling is the process of defining the data requirements and creating a conceptual model of the data. The conceptual model is a high-level representation of the data, which describes the relationships between the data elements. Data modeling is typically done using a modeling language, such as Entity-Relationship (ER) modeling or Unified Modeling Language (UML).


Database Design: The second stage in the working of a Database Management System (DBMS) is database design. Database design is the process of translating the conceptual model into a logical model and then into a physical model. The logical model is a detailed representation of the data, which includes the tables, columns, and relationships between the tables. The physical model is the actual implementation of the database, which includes the physical storage structures and access methods. Database design is typically done using a database design tool, such as ERwin or SQL Server Management Studio.


Database Implementation: The third stage in the working of a DBMS is database implementation. Database implementation is the process of creating the physical database and populating it with data. This involves creating the database schema, which includes the tables, columns, constraints, and indexes. It also involves creating the database objects, such as views, stored procedures, and triggers. Database implementation is typically done using a database management tool, such as Oracle or MySQL.


Data Manipulation: The fourth stage in the working of a Database Management System (DBMS) is data manipulation. Data manipulation is the process of adding, modifying, and deleting data in the database. This involves using the Data Manipulation Language (DML) statements, such as SELECT, INSERT, UPDATE, and DELETE, to access and modify the data. Data manipulation is typically done using a user interface, such as a graphical user interface or a command-line interface.


Data Analysis: The fifth and final stage in the working of a DBMS is data analysis. Data analysis is the process of extracting insights and knowledge from the data. This involves using the Data Analysis Language (DAL) statements, such as GROUP BY, HAVING, and JOIN, to analyze the data. Data analysis is typically done using a reporting tool, such as Crystal Reports or SQL Server Reporting Services.

 

Explore More= http://latestcmiblogs.weebly.com/article/database-management-system-dbms-use-indexing-and-caching-techniques-to-optimize-data-retrieval-and-reduce-access-times


collect
0
avatar
Pooja salve
guide
Zupyak is the world’s largest content marketing community, with over 400 000 members and 3 million articles. Explore and get your content discovered.
Read more