Generic database design for patient management information.

S B Johnson; T Paul; A Khenina

Home/Archive/PubMed

PubMed · 9357581

Generic database design for patient management information.

S B Johnson·T Paul·A Khenina

View original source ↗Export metadata ↓

Abstract

Patient management information tracks general facts about the location of the patient and the providers assigned to care for the patient. The Clinical Data Repository at Columbia Presbyterian Medical Center employs a generic schema to record patient management events. The schema is extremely simple, yet can support several different views of patient information, as required by different applications: a longitudinal view of patient visits, including both inpatient and outpatient encounters; a visit-oriented view, to record facts related to a current encounter; a location-based view to provide a census of a nursing ward; and a provider-based view to give a list of the patients currently being cared for by a given clinician. All of these views can be supported in a highly efficient manner by the use of appropriate indexes.

Explore related subjects

Databases as Topic Hospital Information Systems Humans Medical Records Systems, Computerized Outpatient Clinics, Hospital Patient Care Management Journal Article

Keep this discovery

Explore connections, maps & timelines

BibTeX RIS

S B Johnson, T Paul, A Khenina. 1997. Generic database design for patient management information.. https://pubmed.ncbi.nlm.nih.gov/9357581/

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

KEEP EXPLORING

Related citations

PubMed2007

GI Epidemiology: databases for epidemiological studies.

BACKGROUND: Large databases are being increasingly used for examining the epidemiology and outcomes of digestive and liver disorders. The complexity and rigor of the methods used to conduct these studies are often underestimated. AIMS: For the most commonly used databases, we provide a brief description of the contents, highlight strengths and weakness, and provide links for more detailed information. We also present a systematic approach to utilizing large databases for addressing research questions, highlighting commonly encountered study design issues, as well as strategies for resolving these issues. CONCLUSIONS: 1. Research using large databases requires the same essential skills needed to conduct research studies using other data sources. These include a rigorous study design, expertise in analytic methods, and relevant research questions. 2. The completeness and accuracy of information contained in the database must be assessed. Methods for improving the quality and completeness of this information should be considered. 3. Despite similarities among large databases, gaining insight and experience into the structure and content of each database is essential. Key points *Large databases can be a powerful source of information to examine the clinical epidemiology and outcomes of digestive and liver disorders. * Research using large databases requires the same essential skills needed to conduct research studies using other data sources. These include a rigorous study design, expertise in analytic methods, and relevant research questions. * The completeness and accuracy of information contained in the database must be assessed. Methods for improving the quality and completeness of this information should be considered. * Despite similarities among large databases, gaining insight and experience into the structure and content of each database is essential. * Examples of commonly used large databases are presented with a synopsis of information contained in the database, as well as strengths and limitations of using the database for research.

Databases as Topic↗

PubMed2007

Italian Rett database and biobank.

Rett syndrome is the second most common cause of severe mental retardation in females, with an incidence of approximately 1 out of 10,000 live female births. In addition to the classic form, a number of Rett variants have been described. MECP2 gene mutations are responsible for about 90% of classic cases and for a lower percentage of variant cases. Recently, CDKL5 mutations have been identified in the early onset seizures variant and other atypical Rett patients. While the high percentage of MECP2 mutations in classic patients supports the hypothesis of a single disease gene, the low frequency of mutated variant cases suggests genetic heterogeneity. Since 1998, we have performed clinical evaluation and molecular analysis of a large number of Italian Rett patients. The Italian Rett Syndrome (RTT) database has been developed to share data and samples of our RTT collection with the scientific community (http://www.biobank.unisi.it). This is the first RTT database that has been connected with a biobank. It allows the user to immediately visualize the list of available RTT samples and, using the "Search by" tool, to rapidly select those with specific clinical and molecular features. By contacting bank curators, users can request the samples of interest for their studies. This database encourages collaboration projects with clinicians and researchers from around the world and provides important resources that will help to better define the pathogenic mechanisms underlying Rett syndrome.

Databases as Topic↗

PubMed2007

A database on treating drug addiction with traditional Chinese medicine.

AIMS: Traditional Chinese medicine (TCM) has been used to treat drug addiction for more than 160 years and valuable experiences have been accumulated with regard to patients' detoxification and rehabilitation. The aims of this project were (1) to establish a computerized, bilingual (Chinese-English) database on TCM for drug addiction; (2) to analyse the literature published in this field; and (3) to identify those Chinese herbs commonly used for drug addiction treatment. DESIGN: (1) Paper collection: related papers were collected through electronic databases and hand-searched materials; (2) data computerization: the Microsoft Access program and Delphi language were used as the major data management systems; (3) paper analysis: annual publications from 1989 to 2003 were classified and calculated; and (4) herbal analysis: the frequency of herbs used and herbal function categories were analysed. FINDINGS: (1) A special bilingual database that contained 340 works of professional literature, including 85 patent files on TCM for drug addiction, was established, in which more than 90% of the publications originated from mainland China; (2) the literature classification showed a significant increase in the number of publications on clinical and laboratory researches in this field over the past decade; (3) five functional categorizations of Chinese herbs and the 10 most frequently used Chinese herbs as well as three toxic herbs were identified from more than 200 herbs reported in 150 original research articles and 85 patent files. CONCLUSIONS: For the first time, the published data on TCM in the treatment of drug addiction were analysed systematically by using a new database. The results are invaluable for further laboratory and clinical studies to obtain more direct evidence.

Databases as Topic↗