Transforms of the computerized patient record data model

from transactions to analytical processing.

K. Canfield, M. Silva, S. Zhaohui, R. Manchanda, Patricia Ann 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

Databases
Research

Cite this

@article{251f1200a4454a439d59ede821f164d7,
title = "Transforms of the computerized patient record data model: from transactions to analytical processing.",
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.",
author = "K. Canfield and M. Silva and S. Zhaohui and R. Manchanda and Abbott, {Patricia Ann}",
year = "1995",
language = "English (US)",
pages = "343--346",
journal = "Proceedings / the ... Annual Symposium on Computer Application [sic] in Medical Care. Symposium on Computer Applications in Medical Care",
issn = "0195-4210",

}

TY - JOUR

T1 - Transforms of the computerized patient record data model

T2 - from transactions to analytical processing.

AU - Canfield, K.

AU - Silva, M.

AU - Zhaohui, S.

AU - Manchanda, R.

AU - Abbott, Patricia Ann

PY - 1995

Y1 - 1995

N2 - 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.

AB - 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.

UR - http://www.scopus.com/inward/record.url?scp=0029442876&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=0029442876&partnerID=8YFLogxK

M3 - Article

SP - 343

EP - 346

JO - Proceedings / the ... Annual Symposium on Computer Application [sic] in Medical Care. Symposium on Computer Applications in Medical Care

JF - Proceedings / the ... Annual Symposium on Computer Application [sic] in Medical Care. Symposium on Computer Applications in Medical Care

SN - 0195-4210

ER -