OPPapers.com

Database Management

Database Management
A database management system (DBMS) is computer software designed for the purpose of managing databases. Typical examples of DBMSs include Oracle, IBM's DB2, Microsoft Access, Microsoft SQL Server, MySQL, 4th Dimension and FileMaker. DBMSs are typically used by Database administrators in the creation of Database systems.
DBMS enables the user to store, modify, and extract information from a database. There are many different types of DBMSs, ranging from small systems that run on personal computers to large systems which run on mainframes. Computerized library systems, automated teller machines, flight reservation systems, and computerized inventory systems are some of the examples of the database applications. The DBMS accepts requests for data from the application program and instructs the operating system to transfer the appropriate data. Database software allows users, who are not programmers, the ability to pull data from a specific database, and make that data into user-friendly information.
When a DBMS is used, information systems can be changed much more easily as the organization's information requirements change. New categories of data can be added to the database without disruption to the existing system. Organizations may use one kind of DBMS for daily transaction processing then move the detail onto another computer that uses another DBMS better suited for random inquiries and analysis. Overall systems design decisions are performed by data administrators and systems analysts. Detailed database design is performed by database administrators.
Riordan Manufacturing has three operating entities…Georgia, Michigan and California…plus a joint venture in the People's Republic of China. Basically, the operating entities each have their own Finance & Accounting Systems and they provide input that is consolidated at corporate office in San Jose. The finance & accounting department (F&A) has been unable to achieve anything remotely...