Implementing a Low-Cost Computer-Based Patient Record
A Controlled Vocabulary Reduces Database Design Complexity
Published in: Journal of the American Medical Informatics Association (New Orleans, LA: Proceedings, Nineteenth Annual Symposium on Computer Applications in Medical Care, 1995), p. 431-435
Posted on RAND.org on January 01, 1995
In order to build a computer-based patient record (CPR) system suitable for use in solo and small group practice settings it is necessary to use development methods that minimize cost. Design complexity is a major source of high cost. Reducing complexity should result in lower development, deployment and maintenance costs as well as higher reliability. We have developed a simplified relational model and have used that model, in conjunction with a controlled vocabulary, to implement a CPR that can capture and store patient examinations and other forms of clinical notes as well as laboratory and other test results. The information can be viewed in a familiar document format and it can accessed for other types of processing using standard Structured Query Language (SQL) techniques. The database, as implemented, uses inexpensive components resulting in a system that is not prohibitively expensive for solo practitioners and small groups. In addition the architecture is scaleable and can accommodate very large numbers of patients and practitioners.
This report is part of the RAND Corporation External publication series. Many RAND studies are published in peer-reviewed scholarly journals, as chapters in commercial books, or as documents published by other organizations.
The RAND Corporation is a nonprofit institution that helps improve policy and decisionmaking through research and analysis. RAND's publications do not necessarily reflect the opinions of its research clients and sponsors.