What is
Database Management System?
A Database Management System is a
set of routines that is capable of providing the following basic functions:
»
Add
» Delete
» Update
» Retrieve
A database management system
(DBMS) is computer software designed for the purpose of managing databases.
Typical examples of DBMSs include Oracle, DB2, Microsoft Access, Microsoft SQL
Server, MySQL, 4th Dimension and FileMaker.
The DBMS accepts
requests for data from the application program and instructs the operating
system to transfer the appropriate data.
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 and 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.