Questions and Answers, A+
Surveillance Records
These records are kept and reviewed to maintain health history on employees who
may be exposed to hazardous materials, eliminate causes of exposure and prevent
medical issues from developing. Contribute to worksite health and safety
programs.
Medicare Provider Analysis and Review (MEDPAR)
Acute care and skilled nursing facility claim data on Medicare patients.
National Practitioner Data Bank (NPDB)
Database queried as part of physician credentialing process when applying for
medical staff privileges and every two years afterward. It contains data on medical
malpractice, adverse licensure actions, suspensions, and professional review
actions.
Public Health Databases
Holds data on incidence and prevalence of diseases; survival statistics; high-risk
populations; and tracks trends over time. Data is gathered from medical records,
surveys, and interviews. National Center for Health Statistics (NCHS) is
responsible for these databases.
,National Center for Health Statistics (NCHS)
Operates through the Center for Disease Control (CDC); includes vital statistics
data such as birth, death, marriages, divorces, and fetal deaths.
National Healthcare Survey
Answer key questions of interest to healthcare policy makers, public health
professionals, and researchers. Topics include quality care, resources, safety, and
disparities
Relational
"Most common, can use various data tables with key identifiers. Use when hen you
are looking for relationships among the data. Entity's attributes and relationships.
Reduced data redundancy, shared data, consistency, centralized security. Takes
time to set up.
Flat File
"Single Table. Files, Records, Fields, Characters. Simple, easy to use, inexpensive.
Increased redundancy and inconsistency.
Hierarchical
Tree-like upside down, like organizational chart, every child has only one parent.
Relationships are one-to-many (NO many-to-many)
, Network
Connected by pointers. Child can have multiple parents.
Object-Oriented
handle text, images, audio, video, and other objects. images and other nontext
items are stored as objects with hierarchy and a navigational programming style. an
object can inherit properties from another object.
Mulitdimensional
hybrid between heirarchical and relational. Useful for large amts of data in a short
time.
Transactional
a database management system that has the capability to roll back or undo a
database transaction or operation if it is not completed appropriately.
Data Warehouses
a data warehouse into which all of these different technologies could be loaded,
and a common language standard would be used in order for all of these different
systems to "talk" to each other, to "translate" the data into a common language.
Useful when multiple organizations share information.
Rollup Query