DBMS is a set of software program that control the organization, storage, management, and retrieval of data in a database.
DBMS programs have five subsystems : DBMS engine, data definition, data manipulation, applications generation, and data administration.
The examples of database management system are Microsoft Access, Oracle, OB2, Microsoft SQL Server and File Maker Pro.
Features of typical DBMS are as follows :
DBMS programs have five subsystems : DBMS engine, data definition, data manipulation, applications generation, and data administration.
The examples of database management system are Microsoft Access, Oracle, OB2, Microsoft SQL Server and File Maker Pro.
Features of typical DBMS are as follows :
- Accepts data input from operators and stores that data for later retrieval.
- Provides query languages for searching, sorting, and other "decision support" activities that help users correlate and make sense of collected data.
- Provides multi user access to data, along with security features that prevent some users from viewing and/or changing certain types of information.
- Provides data integritiy features that prevent more than one user from accessing amd changing the same information simultaneously.
- Provides a data dictionary (metadata) that describes the structure of the database, related files, and record information.
Therefore, in today's world, DBMS is become an importance tool in storage and maintaining of data records for every organization such as hospital, banks, universities and retain stores.
Tiada ulasan:
Catat Ulasan