Domain 4: Maintain Database

Page 1

DATABASE MANAGEMENT SYSTEM

is a collection of computer programs that controls the creation, maintenance, and use of a database. The DBMS allows different application programs to access the database.

Purpose of a DBMS

is to maintain the data definitions (data dictionary) for all data elements in the database. It also enforces data integrity and security constraints.

DBMS fall into 2 categories: a personal DBMS, which runs on a client; and a server-based DBMS, which runs on a server.

Personal DBMS

is used for small projects such as storing contact information. Most healthcare systems would not use a personal DBMS

Server-based DBMS

Server-based database management system runs on a server computer. It also runs as a separate application from a personal system. This allows the DBMS to run faster and more efficiently than the personal DBMS. It also allows data to be retrieved by multiply end users. Such a database system is essential in an EHR system. It provide support for 24/7 access with large amounts of storage in the terabyte range or higher.