-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path36. DBMS
47 lines (24 loc) · 4.6 KB
/
36. DBMS
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
It is the software system that enables users to define, create, maintain and control access to the database.
How DBMS work?
A Database Management System (DBMS) works by providing an interface between the user and the database, allowing users to create, manipulate, and query data without having to worry about the underlying details of how the data is stored and managed. Here's a general overview of how DBMS works:
Data Modeling: DBMS allows users to create a model of the data that will be stored in the database. This includes defining the structure of the data (tables, columns, and relationships between tables) and specifying constraints on the data (such as data types, keys, and referential integrity constraints).
Data Storage: DBMS stores the data in a way that is optimized for efficient access and retrieval. This typically involves breaking the data down into tables, rows, and columns, and storing the data in a format that can be easily searched and indexed.
Data Retrieval: DBMS allows users to query the database to retrieve data that matches specific criteria. This is typically done using Structured Query Language (SQL), a standardized language for interacting with relational databases.
Data Manipulation: DBMS allows users to insert, update, and delete data in the database using SQL or other programming interfaces. This allows users to make changes to the data in the database without having to manually manipulate the underlying data files.
Security and Access Control: DBMS provides security features such as access control, authentication, and authorization to ensure that only authorized users can access and modify the data in the database.
Backup and Recovery: DBMS provides features for backing up and recovering data in case of data loss or system failure. This ensures that data is not lost and can be restored to a previous state if necessary.
Overall, DBMS provides a powerful set of tools for managing and organizing data in a reliable and efficient way. By abstracting away the complexities of data storage and management, DBMS makes it easier for users to work with large amounts of data and build applications that rely on that data.
DBMS and its application:
A Database Management System (DBMS) is a software system that allows users to create, manage, and manipulate databases. Here are some common applications of DBMS:
Customer Relationship Management (CRM): CRM systems use DBMS to store and manage customer data, such as contact information, purchase history, and preferences. DBMS provides a reliable and scalable way to manage large amounts of customer data.
Human Resource Management (HRM): HRM systems use DBMS to store and manage employee data, such as personal information, job history, and payroll information. DBMS allows HR departments to manage large amounts of employee data securely and efficiently.
Financial Management: Financial management systems use DBMS to store and manage financial data, such as transaction records, account balances, and financial statements. DBMS provides a reliable and secure way to manage sensitive financial data.
Inventory Management: Inventory management systems use DBMS to store and manage data about products, suppliers, and orders. DBMS allows businesses to manage large amounts of inventory data efficiently and accurately.
E-commerce: E-commerce applications use DBMS to store and manage data about products, customers, orders, and transactions. DBMS provides a scalable and secure way to manage large amounts of e-commerce data.
In addition to these applications, DBMS can be used in a wide range of other applications, including logistics management, supply chain management, project management, and more. The flexibility and scalability of DBMS make them a popular choice for managing and organizing data in a variety of settings.
DBMS also offers a number of benefits to users, including:
Data consistency: DBMS ensures that data is consistent across the database, reducing the risk of errors and discrepancies.
Data security: DBMS provides security features such as access control, encryption, and backup and recovery to protect data from unauthorized access, theft, and loss.
Data integrity: DBMS enforces data integrity by using constraints and other mechanisms to prevent invalid data from being entered into the database.
Data sharing: DBMS allows multiple users to access and manipulate the database simultaneously, enabling collaboration and data sharing across teams and departments.
Overall, DBMS is an essential tool for managing and organizing data in a wide range of applications and industries, offering users a reliable, scalable, and secure way to store and access data.