What is a Database Management System?
A database management system is an application used to create and access databases. Although single user database management systems exist (Microsoft Access for example) these applications are typically used by businesses and larger organizations. Database management systems are also widely used by Internet applications web servers and e-commerce sites. The Functions of A Database Management System A typical database management system application has several primary functions: • Maintain links to data. The database management system is responsible for establishing a physical connection to the data in the database. Users can be on another computer, in another building or even in another country. As long as the connection is maintained, the database can be manipulated from any location. • Manage access to data. The database management system must control the flow of data to ensure that records are not accidentally garbled. Limiting access to a record to one user at a time is a key requir
A database management system is typically an automation system that assists you in managing your database. Such system is most useful when you have to manage a large database, in different locations. You would need a system that is able to perform various critical tasks such as checking the integrity of your data, updating database in real-time if necessary, as well as backing up important database in a regular manner. Manual database management alone is not adequate for such tasks therefore the use of a database management system comes in.
A database management system (or DBMS) is essentially nothing more than a computerized data-keeping system. Users of the system are given facilities to perform several kinds of operations on such a system for either manipulation of the data in the database or the management of the database structure itself. Database Management Systems (DBMSs) are categorized according to their data structures or types. There are several types of databases that can be used on a mainframe to exploit z/OS: inverted list, hierarchic, network, or relational. Mainframe sites tend to use a hierarchical model when the data structure (not data values) of the data needed for an application is relatively static. For example, a Bill of Material (BOM) database structure always has a high level assembly part number, and several levels of components with subcomponents. The structure usually has a component forecast, cost, and pricing data, and so on. The structure of the data for a BOM application rarely changes, and
A database management system is a suite of software applications that together make it possible for people or businesses to store, modify, and extract information from a database. Sound like something found only in bank vaults? It’s not. You can find database management systems many places in your everyday life.
