Database Management System (DBMS)
A database is a single, large repository of data that is defined once, and used simultaneously by many departments and users. The database is no longer owned by one department but is now a shared corporate resource.
Database Management System is software that enables users to define, create, and maintain the database and provides controlled access to the database. It allows users to define the database, usually through the Database Definition Language. It provides controlled access to the database.
- It provides security (which prevents unauthorized users from accessing the database)
- It provides integrity (which maintains consistency of stored data)
- It provides recovery control (which restores the database)
Examples of DBMS packages are DBASE, RBASE, Access, DataCOM, DB2, Fox pro, Sybase, Oracle, Paradox, SQL Server, IDMS, System 2000, etc.