Abstract
Health care institutions are beginning to collect large amounts of clinical data through patient care applications. Clinical data warehouses make these data available for complex analysis across patient records, benefiting administrative reporting, patient care and clinical research. Data gathered for patient care purposes are difficult to manipulate for analytic tasks; the schema presents conceptual difficulties for the analyst, and many queries perform poorly. An extension to SQL is presented that enables the analyst to designate groups of rows. These groups can then be manipulated and aggregated in various ways to solve a number of useful analytic problems. The extended SQL is concise and runs in linear time, while standard SQL requires multiple statements with polynomial performance. The extensions are extremely powerful for performing aggregations on large amounts of data, which is useful in clinical data mining applications.
Full text
PDF
Selected References
These references are in PubMed. This may not be the complete list of references from this article.
- Bellazzi R., Magni P., Larizza C., De Nicolao G., Riva A., Stefanelli M. Mining biomedical time series by combining structural analysis and temporal abstractions. Proc AMIA Symp. 1998:160–164. [PMC free article] [PubMed] [Google Scholar]
- Berndt D. J., Hevner A. R., Studnicki J. CATCH/IT: a data warehouse to support comprehensive assessment for tracking community health. Proc AMIA Symp. 1998:250–254. [PMC free article] [PubMed] [Google Scholar]
- Friedman C., Alderson P. O., Austin J. H., Cimino J. J., Johnson S. B. A general natural-language text processor for clinical radiology. J Am Med Inform Assoc. 1994 Mar-Apr;1(2):161–174. doi: 10.1136/jamia.1994.95236146. [DOI] [PMC free article] [PubMed] [Google Scholar]
- Nadkarni P. M., Brandt C. Data extraction and ad hoc query of an entity-attribute-value database. J Am Med Inform Assoc. 1998 Nov-Dec;5(6):511–527. doi: 10.1136/jamia.1998.0050511. [DOI] [PMC free article] [PubMed] [Google Scholar]
- Nigrin D. J., Kohane I. S. Data mining by clinicians. Proc AMIA Symp. 1998:957–961. [PMC free article] [PubMed] [Google Scholar]
- Prather J. C., Lobach D. F., Goodwin L. K., Hales J. W., Hage M. L., Hammond W. E. Medical data mining: knowledge discovery in a clinical data warehouse. Proc AMIA Annu Fall Symp. 1997:101–105. [PMC free article] [PubMed] [Google Scholar]