Database management systems store, edit, and extract information from a database. They are used in ATMs, flight reservations, libraries, personal computers, and spreadsheets. Reports are the final step in the data manipulation process, and the system does the heavy lifting. Multi-user databases allow users to manage all functions without knowing who else is accessing it. Microsoft SQL Server is an example of a multi-user database.
A database management system is a suite of software applications that together enable individuals or businesses to store, edit, and extract information from a database. Does it look like something only found in bank vaults? It is not. You can find these systems in many places in your daily life.
That ATM you take cash from every week is a database management system. When you make flight reservations online, you provide information which is entered into that system. The library from which you or your children consult books also works on one.
On a more personal level, your personal computer may have its own database management system. You may have spreadsheets that contain mountains of data. Whenever you fill a spreadsheet with data and run queries to find and analyze the data in different ways, you enter such a system.
And how do you view the data that is the result of a query? Looking at a report. Most systems have a reporting function which is the last step in the data manipulation process. After all, collecting data without looking at it won’t get you very far.
One of the main functions of the database management system is to do the heavy lifting for you. In other words, you don’t necessarily need to know exactly where all that data is in the system; as long as the system knows where it is, it can provide a report for you to review. This might not matter if you’re just thinking about your computer, but put in a mainframe that contains reams and reams of data, and we’re talking a huge amount of information that can be stored in any number of places within the system central. The result is the same, though: a report you can read, analyze, and act upon.
This functionality also extends to a multi-user database. Such a system in this scenario would allow you as a user to manage all functions within the database without having to know which other users are accessing the same database. A popular example of this type of multi-user database is Microsoft SQL Server.
Protect your devices with Threat Protection by NordVPN