title: Methodology of integration of a clinical data warehouse with a clinical information system: the HEGP case.
abstract: Clinical Data Warehouses (CDW) can complement current Clinical Information Systems (CIS) with functions that are not easily implemented by traditional operational database systems. Here, we describe the design and deployment strategy used at the Pompidou University Hospital in southwest Paris. Four realms are described: technological realm, data realm, restitution realm, and administration realm. The corresponding UML use cases and the mapping rules from the shared integrated electronic health records to the five axes of the i2b2 CDW star model are presented. Priority is given to the anonymization and security principles used for the 1.2 million patient records currently stored in the CDW. Exploitation of a CDW by clinicians and investigators can facilitate clinical research, quality evaluations and outcome studies. These indirect benefits are among the reasons for the continuous use of an integrated CIS.
authors.affiliation: Department of Medical Informatics, Georges Pompidou University Hospital, UMR-S 872, Centre de Recherche des Cordeliers, INSERM, Université Paris Descarte, Paris, F-75015 France. eric.zapletal@egp.aphp.fr
authors.forename: Eric
authors.initials: E
authors.lastname: Zapletal
authors.forename: Nicolas
authors.initials: N
authors.lastname: Rodon
authors.forename: Natalia
authors.initials: N
authors.lastname: Grabar
authors.forename: Patrice
authors.initials: P
authors.lastname: Degoulet
mesh_terms: D003628:Database Management Systems / Q000458:organization & administration*; D019033:Delivery of Health Care, Integrated / Q000379:methods*; D057286:Electronic Health Records / Q000458:organization & administration*; D005602:France; D016247:Information Storage and Retrieval / Q000379:methods*; D008498:Medical Record Linkage / Q000379:methods*; D018511:Systems Integration