Transforms of the computerized patient record data model: from transactions to analytical processing.

K. Canfield, M. Silva, S. Zhaohui, R. Manchanda, P. Abbott

Research output: Contribution to journalArticle

Abstract

The design of Computerized Patient Record databases needs to be different depending on whether the focus of the database is transaction processing or analytical processing. Transaction processing includes the operational use of databases for single patient update during clinical encounters. Analytical processing includes cross-patient querying for research or clinical management. These different design needs are defined. A case study is presented for the methodology that transforms transaction databases to analytical ones. The resulting analytical design is argued to be successfully evaluated according to specific criteria of useability and maintainability. This methodology is easily replicated in any relational database environment.

Original languageEnglish (US)
Pages (from-to)343-346
Number of pages4
JournalProceedings / the ... Annual Symposium on Computer Application [sic] in Medical Care. Symposium on Computer Applications in Medical Care
StatePublished - 1995
Externally publishedYes

Fingerprint Dive into the research topics of 'Transforms of the computerized patient record data model: from transactions to analytical processing.'. Together they form a unique fingerprint.

  • Cite this