The data warehouse as a foundation for population-based reference intervals

Am J Clin Pathol. 2003 Nov;120(5):662-70. doi: 10.1309/W8J8-5AG4-WDG6-JGJ9.

Abstract

The volume of data contained in a data warehouse represents a potential resource to provide the basis for detailed and specific reference intervals. Routine chemistry panel testing data were derived from an outreach laboratory patient population of 438,180 people and then screened by multiple data filters to identify a large and demographically diverse reference population. Reference intervals were determined for 4 common analytes: aspartate aminotransferase, alanine aminotransferase, total bilirubin, and alkaline phosphatase. Each derived reference population contained more than 60,000 people with sex- and age-specific subgroups comprising between 495 and 4,949 persons. These intervals are particularly representative of the aging patient population and demonstrate a degree of age and sex diversity not reflected commonly in routine laboratory reference intervals. Warehouse data also can yield other interpretative data, such as percentile ranking of results or disease-specific reference intervals. As the warehouse accumulates data from other disciplines (such as from clinical notes or pharmacy), there is increasing potential for the laboratory to enhance the clinician's ability to diagnose and treat disease.

MeSH terms

  • Adolescent
  • Adult
  • Age Factors
  • Aged
  • Aged, 80 and over
  • Alanine Transaminase / blood
  • Alkaline Phosphatase / blood
  • Aspartate Aminotransferases / blood
  • Bilirubin / blood
  • Blood Chemical Analysis*
  • Database Management Systems*
  • Female
  • Humans
  • Information Centers*
  • Male
  • Middle Aged
  • Reference Values
  • Sex Factors

Substances

  • Aspartate Aminotransferases
  • Alanine Transaminase
  • Alkaline Phosphatase
  • Bilirubin