Related Experiment Video
Updated: Aug 4, 2026
11:18
Generation of Comprehensive Thoracic Oncology Database - Tool for Translational Research
Published on: January 23, 2011
Web client and ODBC access to legacy database information: a low cost approach
N W Sanders1, N H Mann, D M Spengler
1Department of Biomedical Engineering, Vanderbilt University, Nashville, TN, USA.
Summary
A new method now provides Vanderbilt
Area of Science:
- Health Informatics
- Orthopaedic Data Management
Background:
- Clinical data for the Department of Orthopaedics was previously confined to a mainframe DB2 database.
- Limited accessibility hindered the use of historical patient data for research and operational insights.
Purpose of the Study:
- To develop a cost-effective method for enhancing access to orthopaedic clinical data.
- To enable on-line access to previously inaccessible historical patient data.
Main Methods:
- Implemented a new system storing departmental data in a SQL database alongside the existing mainframe DB2.
- Enabled data access through any Open Database Connectivity (ODBC) compliant front-end or a web client.
Main Results:
- Achieved on-line access to years of previously inaccessible patient data.
- The solution was implemented with a minimal budget and without dedicated full-time staff.
Conclusions:
- A feasible and economical approach was established for improving clinical data accessibility in an orthopaedic department.
- The new method significantly enhances the utility of historical patient data for departmental use.
Related Concept Videos
01:07Midrange
A somewhat easy to compute quantitative estimate of a data set’s central tendency is its midrange, which is defined as the mean of the minimum and maximum values of an ordered data set.
Simply put, the midrange is half of the data set’s range. Similar to the mean, the midrange is sensitive to the extreme values and hence the prospective outliers. However, unlike the mean, the midrange is not sensitive to all the values of the data set that lie in the middle. Thus, it is prone to outliers and...
Simply put, the midrange is half of the data set’s range. Similar to the mean, the midrange is sensitive to the extreme values and hence the prospective outliers. However, unlike the mean, the midrange is not sensitive to all the values of the data set that lie in the middle. Thus, it is prone to outliers and...
01:24Data Reporting and Recording
Reporting and recording are crucial in data documentation. The timely, thorough, and accurate documentation of facts is essential when recording patient data. Failure to record findings during an assessment or interpretation of a problem will result in loss of information and make the patient document unreliable. The reader is left with general impressions if the information is not specific. A recording is documenting data of the individual's health information in a traceable, secure, and...
01:18Methods of Documentation I: Source-Oriented Records
Source-oriented records, or SOR, are medical record-keeping organized by the data source. The SOR system was first developed in the mid-1900s to organize the growing patient data in hospitals and other healthcare facilities.
In an SOR, each discipline involved in patient care maintains a separate medical record section. This record-keeping method enables easy tracking of patient progress and ensures healthcare staff have access to up-to-date information.
Key Attributes include the following:
In an SOR, each discipline involved in patient care maintains a separate medical record section. This record-keeping method enables easy tracking of patient progress and ensures healthcare staff have access to up-to-date information.
Key Attributes include the following:
01:27Nursing Clinical Information System
Nursing Clinical Information System (NCIS)
A Nursing Clinical Information System (NCIS) is a specialized type of healthcare information system tailored to meet the unique needs of nursing practice. It incorporates the principles of nursing informatics to streamline information management and improve the quality of care delivery.
Critical attributes of NCIS include:
A Nursing Clinical Information System (NCIS) is a specialized type of healthcare information system tailored to meet the unique needs of nursing practice. It incorporates the principles of nursing informatics to streamline information management and improve the quality of care delivery.
Critical attributes of NCIS include:
01:11High-Performance Liquid Chromatography: Introduction
High-performance liquid chromatography(HPLC), formerly referred to as High-pressure liquid chromatography, is a powerful technique used to separate, identify, and quantify components in complex mixtures. The term "high pressure" refers to using high pressure to push the liquid mobile phase through the tightly packed columns.
In HPLC, two phases play a critical role in the separation process:
In HPLC, two phases play a critical role in the separation process:
01:28Capillary Exchange
The cardiovascular system's chief role is to disseminate gases, nutrients, waste, and other substances to the body's cells. Small molecules like gases, lipids, and lipid-soluble substances directly diffuse through capillary wall endothelial cell membranes. Glucose, amino acids, and ions, including sodium, potassium, calcium, and chloride, use transporters for facilitated diffusion via membrane-specific channels. Glucose, ions, and bigger molecules may also pass through intercellular clefts.