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

Background. When 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. Methods. A 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

Criação e implementação de um banco de dados cirúrgico totalmente informatizado baseado nas ferramentas Google : experiência inicial em cirurgia cardiovascular

Objective: to describe, in a practical and step-by-step manner, the construction of a fully electronic platform for data collection, storage, and analysis, initially proposed for cardiovascular surgery, with interfaces that are reproducible and applicable to other surgical specialties, as well as to present the initial work experience with this instrument in cardiac surgery and the preliminary results obtained after its implementation in a Brazilian tertiary university hospital. Methods: the platform was developed based on Google tools, which are free, easy to use, and widely accessible. From the beginning of this initiative, in May 2015, to the preliminary analysis, in February 2017, data from 271 consecutive patients submitted to cardiovascular surgery were prospectively recorded and preliminarily analyzed. Results: the initiative was implemented with full success, with 100% of patients included and without loss of any variable, in a database composed of more than 500 variables. The most frequent immediate postoperative complications were: atrial fibrillation (22.5%), bronchopneumonia (10.7%), delirium (10.3%), acute renal failure (10%), stroke (5%), and death (7%). Comparing mortality rates in the first and second years of the initiative, a reduction from 10.8% to 4% (p=0.042), respectively, was evidenced. Conclusion: the new proposal of data collection and storage presented in this work was fully feasible and effective. It may be useful to other surgical specialties that wish to develop methods to evaluate success and postoperative complication rates, as well as quality improvement programs.Objetivo: descrever de maneira prática e detalhada a criação de uma plataforma totalmente informatizada para coleta, armazenamento e análise de dados, inicialmente proposta para cirurgia cardiovascular, com interfaces reprodutíveis e aplicáveis a outras especialidades cirúrgicas, bem como, apresentar a experiência inicial de trabalho com esta ferramenta e os resultados preliminares obtidos após sua implementação em um hospital universitário terciário brasileiro. Métodos: a plataforma foi desenvolvida com base nas ferramentas Google, gratuitas, de fácil utilização e amplamente acessíveis. Desde o início desta iniciativa, em maio de 2015, até a análise preliminar, em fevereiro de 2017, dados de 271 pacientes, consecutivos, submetidos à cirurgia cardiovascular foram prospectivamente recordados e analisados. Resultados: a iniciativa foi implementada com pleno sucesso, com 100% dos pacientes incluídos e sem perda de qualquer variável em um banco de dados composto por mais de 500 variáveis. As complicações pós-operatórias imediatas mais frequentes foram: fibrilação atrial (22,5%), broncopneumonia (10,7%), delirium (10,3%), insuficiência renal aguda (10%), acidente vascular encefálico (5%) e morte (7%). Comparando-se as taxas de mortalidade no primeiro e segundo anos da iniciativa, uma redução de 10,8% para 4% (p=0,042), respectivamente, foi evidenciada. Conclusão: a nova proposta de coleta e armazenamento de dados apresentada neste trabalho mostrou-se plenamente factível e efetiva. Por serem gratuitas, de fácil manuseio e universalmente acessíveis, estas ferramentas podem ser úteis a outras especialidades cirúrgicas que desejem desenvolver métodos de avaliação de sucesso e complicações pósoperatórios, bem como, programas de melhoria de qualidade

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

<p><b>Copyright information:</b></p><p>Taken from "Is OpenSDE an alternative for dedicated medical research databases? An example in coronary surgery"</p><p>http://www.biomedcentral.com/1472-6947/7/31</p><p>BMC Medical Informatics and Decision Making 2007;7():31-31.</p><p>Published online 22 Oct 2007</p><p>PMCID:PMC2173886.</p><p></p

Methods to Facilitate the Capture, Use, and Reuse of Structured and Unstructured Clinical Data.

Electronic health records (EHRs) have great potential to improve quality of care and to support clinical and translational research. While EHRs are being increasingly implemented in U.S. hospitals and clinics, their anticipated benefits have been largely unachieved or underachieved. Among many factors, tedious documentation requirements and the lack of effective information retrieval tools to access and reuse data are two key reasons accounting for this deficiency. In this dissertation, I describe my research on developing novel methods to facilitate the capture, use, and reuse of both structured and unstructured clinical data. Specifically, I develop a framework to investigate potential issues in this research topic, with a focus on three significant challenges. The first challenge is structured data entry (SDE), which can be facilitated by four effective strategies based on my systematic review. I further propose a multi-strategy model to guide the development of future SDE applications. In the follow-up study, I focus on workflow integration and evaluate the feasibility of using EHR audit trail logs for clinical workflow analysis. The second challenge is the use of clinical narratives, which can be supported by my innovative information retrieval (IR) technique called “semantically-based query recommendation (SBQR)”. My user experiment shows that SBQR can help improve the perceived performance of a medical IR system, and may work better on search tasks with average difficulty. The third challenge involves reusing EHR data as a reference standard to benchmark the quality of other health-related information. My study assesses the readability of trial descriptions on ClinicalTrials.gov and found that trial descriptions are very hard to read, even harder than clinical notes. My dissertation has several contributions. First, it conducts pioneer studies with innovative methods to improve the capture, use, and reuse of clinical data. Second, my dissertation provides successful examples for investigators who would like to conduct interdisciplinary research in the field of health informatics. Third, the framework of my research can be a great tool to generate future research agenda in clinical documentation and EHRs. I will continue exploring innovative and effective methods to maximize the value of EHRs.PHDInformationUniversity of Michigan, Horace H. Rackham School of Graduate Studieshttp://deepblue.lib.umich.edu/bitstream/2027.42/135845/1/tzuyu_1.pd

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

<p><b>Copyright information:</b></p><p>Taken from "Is OpenSDE an alternative for dedicated medical research databases? An example in coronary surgery"</p><p>http://www.biomedcentral.com/1472-6947/7/31</p><p>BMC Medical Informatics and Decision Making 2007;7():31-31.</p><p>Published online 22 Oct 2007</p><p>PMCID:PMC2173886.</p><p></p>alComplications_PS represents if a complication occurred or not