SET QUESTIONS AND ANSWERS SURE A+
✔✔data control language - ✔✔controls access to data within a database
✔✔Database Management System (DBMS) - ✔✔manipulate and control the data stored
within the database to meet the needs of the user. It controls the ability to create, read,
write, and delete data stored in the database.
✔✔query by example (QBE) - ✔✔query method whereby the user only has to point and
click to choose tables and fields contained in the database
✔✔Structured Query Language (SQL) - ✔✔standard language for the relational
database
✔✔data manipulation - ✔✔allows the user to add and delete rows in a table and to sort,
find, and compare
✔✔data dictionary - ✔✔descriptive list of the names, definitions, and attributes of data
elements to be collected in an IS or database whose purpose is to standardize
definitions and ensure consistent use
✔✔data standards - ✔✔allow us to share data in a uniform way
, ✔✔Data Modeling - ✔✔process of determining the users' information needs and
identifying relationships among the data
✔✔data repository - ✔✔open-structure database (not dedicated to the software of any
particular vendor or data supplier) in which data from multiple ISs are stored so that an
integrated, multidisciplinary view of the data can be achieved in a single source.
Updated in real time
✔✔data warehouse - ✔✔database that makes it possible to access data from multiple
databases and combine the results into a single query and reporting interface. Holds an
abundance of data from many different source systems and are designed for specific
types of analyses, such as patient care or business.
✔✔data mart - ✔✔subset of the data warehouse designed for a single purpose or
specialized use. The data mart performs the same type of analysis as a data
warehouse; however, the scope of the data is narrower.
✔✔Online Analytical Processing (OLAP) - ✔✔data access architecture that allows the
user to retrieve specific information from a large volume of data.
✔✔administrative information systems - ✔✔the first information systems to be used in
healthcare, mainly financial or business-oriented in nature
✔✔Decision Support System (DSS) - ✔✔gathers data from a variety of sources to
assist management and staff in decision-making tasks associated with the nonroutine
and nonrepetitive problems. 109
✔✔Master Patient Index (MPI) - ✔✔permanent record of patients treated at the
healthcare facility.
✔✔patient registration system - ✔✔collects information on patients receiving treatment
✔✔practice management system - ✔✔combines a number of applications required to
manage a physician practice
✔✔materials management system - ✔✔manages the supplies and equipment within the
facility
✔✔facilities management system - ✔✔allows physical plant operations to control the
automated systems within the facility for patient safety and comfort—that is, heating and
air systems, automated key control, and preventive maintenance tasks such as testing
fire extinguishers, elevator inspections, and the care of various equipment used in the
healthcare facility