Generic Data Modeling for Clinical Repositories
Open Access
- 1 September 1996
- journal article
- review article
- Published by Oxford University Press (OUP) in Journal of the American Medical Informatics Association
- Vol. 3 (5) , 328-339
- https://doi.org/10.1136/jamia.1996.97035024
Abstract
Objective: To construct a large-scale clinical repository that accurately captures a detailed understanding of the data vital to the process of health care and that provides highly efficient access to patient information for the users of a clinical information system. Design: Conventional approaches to data modeling encourage the development of a highly specific data schema in order to capture as much information as possible about a given domain. In contrast, current database technology functions most effectively for clinical databases when a generic data schema is used. The technique of “generic data modeling” is presented as a method of reconciling these opposing views of clinical data, using formal operations to transform a detailed schema into a generic one. Results: A complex schema consisting of hundreds of entities and representing a rich set of constraints about the patient care domain is transformed into a generic schema consisting of roughly two dozen tables. The resulting database design is efficient for patient-oriented queries and is highly flexible in adapting to the changing information needs of a health care institution, particularly changes involving the collection of new data elements. Conclusion: Conventional approaches to data modeling can be used to develop rich, complex models of clinical data that are useful for understanding and managing the process of patient care. Generic data modeling techniques can successfully transform a detailed design into an efficient generic design that is flexible enough to meet the needs of an operational clinical information system.Keywords
This publication has 13 references indexed in Scilit:
- Implementing a low-cost computer-based patient record: a controlled vocabulary reduces data base design complexity.1995
- A data model that captures clinical reasoning about patient problems.1995
- A Logical Foundation for Representation of Clinical DataJournal of the American Medical Informatics Association, 1994
- A Schema for Representing Medical Language Applied to Clinical RadiologyJournal of the American Medical Informatics Association, 1994
- Experiments in Concept Modeling for Radiographic Image ReportsJournal of the American Medical Informatics Association, 1994
- Accessing the Columbia Clinical Repository.1994
- A high-level object-oriented model for representing relationships in an electronic medical record.1994
- An information model for medical events.1994
- A powerful macro-model for the computer patient record.1994
- The Data Dictionary – A Controlled Vocabulary for Integrating Clinical Databases and Medical Knowledge BasesMethods of Information in Medicine, 1989