Is OpenSDE an alternative for dedicated medical research databases? An example in coronary surgery

BackgroundWhen using a conventional relational database approach to collect and query data in the context of specific clinical studies, a study with a new data set usually requires the design of a new database and entry forms. OpenSDE (SDE = Structured Data Entry) is intended to provide a flexible and intuitive way to create databases and entry forms for the collection of data in a structured format.This study illustrates the use of OpenSDE as a potential alternative to a conventional approach with respect to data modelling, database creation, data entry, and data extraction.MethodsA database and entry forms are created using OpenSDE and MSAccess to support collection of coronary surgery data, based on the Adult Cardiac Surgery Data Set of the Society of Thoracic Surgeons. Data of 52 cases are entered and nine different queries are designed, and executed on both databases.ResultsDesign of the data model and the creation of entry forms were experienced as more intuitive and less labor intensive with OpenSDE. Both resulting databases provided sufficient expressiveness to accommodate the data set. Data entry was more flexible with OpenSDE. Queries produced equal and correct results with comparable effort.ConclusionFor prospective studies involving well-defined and straight forward data sets, OpenSDE deserves to be considered as an alternative to the conventional approach.

[1]  Astrid M. van Ginneken,et al.  Extracting data recorded with OpenSDE: Possibilities and limitations , 2005, Int. J. Medical Informatics.

[2]  A. V. van Ginneken,et al.  Paper Versus Computer: Feasibility of an Electronic Medical Record in General Pediatrics , 2006, Pediatrics.

[3]  Stéphane Bressan,et al.  Introduction to Database Systems , 2005 .

[4]  Cynthia Brandt,et al.  Pivoting approaches for bulk extraction of Entity-Attribute-Value data , 2006, Comput. Methods Programs Biomed..

[5]  Cynthia Brandt,et al.  Application of Information Technology: Metadata-driven Ad Hoc Query of Patient Data: Meeting the Needs of Clinical Studies , 2002, J. Am. Medical Informatics Assoc..

[6]  Perry L. Miller,et al.  Application of Information Technology: Organization of Heterogeneous Scientific Data Using the EAV/CR Representation , 1999, J. Am. Medical Informatics Assoc..

[7]  Hans-Ulrich Prokosch,et al.  A Flexible Repository for Clinical Trial Data Based on an Entity-Attribute-Value Model , 1999, AMIA.

[8]  A. Bogers,et al.  Short-term and 5-year outcome after primary isolated coronary artery bypass graft surgery: results of risk stratification in a bilocation center. , 2002, European journal of cardio-thoracic surgery : official journal of the European Association for Cardio-thoracic Surgery.

[9]  A. V. van Ginneken,et al.  Are Structured Data Structured Identically? , 2005, Methods of Information in Medicine.

[10]  Prakash M. Nadkarni,et al.  Data Extraction and Ad Hoc Query of an Entity– Attribute–Value Database , 2000 .

[11]  Perry L. Miller,et al.  Application of Information Technology: Achieving Evolvable Web-Database Bioscience Applications Using the EAV/CR Framework: Recent Advances , 2003, J. Am. Medical Informatics Assoc..

[12]  Astrid M. van Ginneken,et al.  Bmc Medical Informatics and Decision Making Structured Data Entry for Narrative Data in a Broad Specialty: Patient History and Physical Examination in Pediatrics , 2006 .

[13]  A M van Ginneken,et al.  Considerations for the Representation of Meta-Data for the Support of Structured Data Entry , 2003, Methods of Information in Medicine.

[14]  C. J. Date.  An Introduction to Database Systems , 1975 .

[15]  Astrid M. van Ginneken,et al.  OpenSDE: A strategy for expressive and flexible structured data entry , 2005, Int. J. Medical Informatics.

[16]  Astrid M. van Ginneken,et al.  Technical Brief: OpenSDE: Row Modeling Applied to Generic Structured Data Entry , 2004, J. Am. Medical Informatics Assoc..

[17]  Astrid M. van Ginneken,et al.  A Multi-Disciplinary Approach to a User Interface for Structured Data Entry , 2001, MedInfo.