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

K Canfield; M Silva; S Zhaohui; R Manchanda; P Abbott

Home/Archive/PubMed

PubMed · 8563298

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

K Canfield·M Silva·S Zhaohui·R Manchanda·P Abbott

View original source ↗Export metadata ↓

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.

Explore related subjects

Computer Systems Humans Information Storage and Retrieval Medical Records Systems, Computerized Journal Article

Keep this discovery

Explore connections, maps & timelines

BibTeX RIS

K Canfield, M Silva, S Zhaohui, R Manchanda, P Abbott. 1995. Transforms of the computerized patient record data model: from transactions to analytical processing.. https://pubmed.ncbi.nlm.nih.gov/8563298/

Cite the original work for its findings. Save a collection to share your selection of sources.

KEEP EXPLORING

Related citations

PubMed2007

Miniature near-infrared dual-axes confocal microscope utilizing a two-dimensional microelectromechanical systems scanner.

The first, to our knowledge, miniature dual-axes confocal microscope has been developed, with an outer diameter of 10 mm, for subsurface imaging of biological tissues with 5-7 microm resolution. Depth-resolved en face images are obtained at 30 frames per second, with a field of view of 800 x 100 microm, by employing a two-dimensional scanning microelectromechanical systems mirror. Reflectance and fluorescence images are obtained with a laser source at 785 nm, demonstrating the ability to perform real-time optical biopsy.

Computer Systems↗

PubMed2007

Proposal for fulfilling strategic objectives of the U.S. Roadmap for national action on clinical decision support through a service-oriented architecture leveraging HL7 services.

Despite their demonstrated effectiveness, clinical decision support (CDS) systems are not widely used within the U.S. The Roadmap for National Action on Clinical Decision Support, published in June 2006 by the American Medical Informatics Association, identifies six strategic objectives for achieving widespread adoption of effective CDS capabilities. In this manuscript, we propose a Service-Oriented Architecture (SOA) for CDS that facilitates achievement of these six objectives. Within the proposed framework, CDS capabilities are implemented through the orchestration of independent software services whose interfaces are being standardized by Health Level 7 and the Object Management Group through their joint Healthcare Services Specification Project (HSSP). Core services within this framework include the HSSP Decision Support Service, the HSSP Common Terminology Service, and the HSSP Retrieve, Locate, and Update Service. Our experiences, and those of others, indicate that the proposed SOA approach to CDS could enable the widespread adoption of effective CDS within the U.S. health care system.

Computer Systems↗

PubMed2006

Imaging tumour motion for radiotherapy planning using MRI.

Novel technology has made dynamic magnetic resonance imaging (MRI) of lung motion and lung tumour mobility during continuous respiration feasible. This might be beneficial for planning of radiotherapy of lung tumours, especially when using high precision techniques. This paper describes the recent developments to analyze and visualize pulmonary nodules during continuous respiration using MRI. Besides recent dynamic two-dimensional approaches to quantify motion of pulmonary nodules during respiration novel three-dimensional techniques are presented. Beyond good correlation to pulmonary function tests MRI also provides regional information about differences between tumour-bearing and non-tumour bearing lung and the restrictive effects of radiotherapy as well as the compensation by the contralateral lung.

Computer Systems↗