Converting a legacy system database into relational format to enhance query efficiency

J C Prather1, D F Lobach, J W Hales

  • 1Duke University Medical Center, Durham, North Carolina, USA.

Related Concept Videos

Health Information Technology and Healthcare Information System01:30

Health Information Technology and Healthcare Information System

Health Information Technology (HIT)
Health Information Technology, commonly called HIT, integrates advanced information systems and technology in healthcare settings. Its primary functions include:
Data Reporting and Recording01:24

Data Reporting and Recording

Reporting and recording are crucial in data documentation. The timely, thorough, and accurate documentation of facts is essential when recording patient data. Failure to record findings during an assessment or interpretation of a problem will result in loss of information and make the patient document unreliable. The reader is left with general impressions if the information is not specific. A recording is documenting data of the individual's health information in a traceable, secure, and...
Introduction to Scalers01:21

Introduction to Scalers

Many familiar physical quantities can be specified completely by giving a single number and the appropriate unit. For example, "a class period lasts 50 min," or "the gas tank in my car holds 65 L," or "the distance between the two posts is 100 m." A physical quantity that can be specified completely in this manner is called a scalar quantity. The word "scalar" is a synonym for "number." Time, mass, distance, length, volume, temperature, and energy are some examples of scalar quantities.
Scalar...
Purpose of Health Records II01:19

Purpose of Health Records II

Health records serve various essential purposes in the healthcare system. Here are some key purposes:
Column Efficiency: Rate Theory01:12

Column Efficiency: Rate Theory

The rate theory of chromatography provides quantitative insight into the shapes and widths of elution bands. These bands are based on the random-walk mechanism governing molecular migration within a column. The Gaussian profile of chromatographic bands arises from the cumulative effect of random molecular motions as they progress through the column.
During elution, a solute molecule experiences numerous transitions between stationary and mobile phases, exhibiting irregular residence times in...
Impact of Schemas01:30

Impact of Schemas

Schemas are cognitive structures that provide a framework for interpreting and organizing social information. They help individuals navigate complex environments by offering expectations about people, events, and behaviors. Schemas influence attention, encoding, and retrieval processes, thereby shaping the entire trajectory of information processing in social contexts.Attention and Cognitive LoadDuring initial attention, schemas function as filters that prioritize schema-consistent information,...