What is Database Management System?
Kontributor:
Mochammad Salman Al farisi
What is Data?
Data can be facts related to any object in consideration for Ex:
- Yourname
- Height
- Height
- Age
- Weight
- Etc
What is Database?
Database is a Systematic collection of data. Database can support storage and manipulation of data. Database make data management easy. For the example :
A Whatsapp Call directory would definitely use database to store data pertaining to people.
Oke maybe lets consider with instagram. It needs to store, manipulate and present data related to members, their friends, messages, advertisements, member activities and etc.
So I will provide of examples for usage of database.
A database management system (DBMS)
Is a collection of programs that manages the database structure and control access to the data stored in the database. A database resembles a very well. Oraganized electronic filing cabinet in which powerfull software, known as a database management system, helps manage the cabinet’s content.
Advantage Of The DBMS:
The DBMS serves as the intermediary between the user and database. The database structure itself is stored as a collection of files,and the only way to accsess the data in those files is through the DBMS. The DBMS receives all application requests and translate them info the complex operation required to fulfill those request. The DBMS hides much of database internal complexity from the application program and user.
The different advantage of DBMS are as follows.
1. Improved data sharing
The DBMS helps create an environment in which and user have better access to more and better – manage data. Such access makes it possible for end users to respond quickly to changes in their environment.
2. Improved data security
The more user access the data, the greater the risk of data security breaches. Corporation invest considerable amount of time, effort, and money to ensure that corporate data are use properly. A DBMS provides a framework for better enforcement of data privacy and security police.
3. Better data integration.
Wider access to well-managed data promotes an integrated view of the organization’s operations and a clearer view of the big picture. It becomes much easier to see how actions in one segment of the company affect other segments.
4. Minimized data inconsistency.
Data inconsistency exists when different versions of the same data appear in different places. For example, data inconsistency exists when a company’s sales department stores a sales representative’s name as “Bill Brown” and the company’s personnel department stores that same person’s name as “William G. Brown,” or when the company’s regional sales office shows the price of a product as $45.95 and its national sales office shows the same product’s price as $43.95. The probability of data inconsistency is greatly reduced in a properly designed database.
5. Improved data access.
The DBMS makes it possible to produce quick answers to ad hoc queries. From a database perspective, a query is a specific request issued to the DBMS for data manipulation—for example, to read or update the data. Simply put, a query is a question, and an ad hoc query is a spur-of-the-moment question. The DBMS sends back an answer (called the query result set) to the application.
6.Improved decision making.
Better-managed data and improved data access make it possible to generate better-quality information, on which better decisions are based. The quality of the information generated depends on the quality of the underlying data. Data quality is a comprehensive approach to promoting the accuracy, validity, and timeliness of the data. While the DBMS does not guarantee data quality, it provides a framework to facilitate data quality initiatives.
7.Increased end-user productivity.
The availability of data, combined with the tools that transform data into usable information, empowers end users to make quick, informed decisions that can make the difference between success and failure in the global economy.