title: Extended SQL for manipulating clinical warehouse data.
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.
authors.affiliation: Department of Medical Informatics, Columbia University, USA.
authors.forename: S B
authors.initials: SB
authors.lastname: Johnson
authors.forename: D
authors.initials: D
authors.lastname: Chatziantoniou
mesh_terms: D019411:Clinical Laboratory Techniques; D003627:Data Interpretation, Statistical; D003628:Database Management Systems; D019992:Databases as Topic / Q000458:organization & administration*; D006302:Health Services Research; D006801:Humans; D016247:Information Storage and Retrieval / Q000379:methods; D016347:Medical Records Systems, Computerized / Q000458:organization & administration*; D011381:Programming Languages