scholarly journals Development of web based system for statistical analysis of clinical data

2012 ◽  
Vol 23 (1) ◽  
pp. 191-198 ◽  
Author(s):  
Dal-Ho Kim ◽  
Im-Hee Shin ◽  
Jung-Youn Choe ◽  
Sang-Gyung Kim ◽  
Chun-Woo Park ◽  
...  
2020 ◽  
Author(s):  
Julian Gruendner ◽  
Christian Gulden ◽  
Marvin Kampf ◽  
Sebastian Mate ◽  
Hans-Ulrich Prokosch ◽  
...  

BACKGROUND The harmonization and standardization of digital medical information for research purposes is a challenging and ongoing collaborative effort. Current research data repositories typically require extensive efforts in harmonizing and transforming original clinical data. The Fast Healthcare Interoperability Resources (FHIR) format was designed primarily to represent clinical processes; therefore, it closely resembles the clinical data model and is more widely available across modern electronic health records. However, no common standardized data format is directly suitable for statistical analyses, and data need to be preprocessed before statistical analysis. OBJECTIVE This study aimed to elucidate how FHIR data can be queried directly with a preprocessing service and be used for statistical analyses. METHODS We propose that the binary JavaScript Object Notation format of the PostgreSQL (PSQL) open source database is suitable for not only storing FHIR data, but also extending it with preprocessing and filtering services, which directly transform data stored in FHIR format into prepared data subsets for statistical analysis. We specified an interface for this preprocessor, implemented and deployed it at University Hospital Erlangen-Nürnberg, generated 3 sample data sets, and analyzed the available data. RESULTS We imported real-world patient data from 2016 to 2018 into a standard PSQL database, generating a dataset of approximately 35.5 million FHIR resources, including “Patient,” “Encounter,” “Condition” (diagnoses specified using International Classification of Diseases codes), “Procedure,” and “Observation” (laboratory test results). We then integrated the developed preprocessing service with the PSQL database and the locally installed web-based KETOS analysis platform. Advanced statistical analyses were feasible using the developed framework using 3 clinically relevant scenarios (data-driven establishment of hemoglobin reference intervals, assessment of anemia prevalence in patients with cancer, and investigation of the adverse effects of drugs). CONCLUSIONS This study shows how the standard open source database PSQL can be used to store FHIR data and be integrated with a specifically developed preprocessing and analysis framework. This enables dataset generation with advanced medical criteria and the integration of subsequent statistical analysis. The web-based preprocessing service can be deployed locally at the hospital level, protecting patients’ privacy while being integrated with existing open source data analysis tools currently being developed across Germany.


10.2196/25645 ◽  
2021 ◽  
Vol 9 (4) ◽  
pp. e25645
Author(s):  
Julian Gruendner ◽  
Christian Gulden ◽  
Marvin Kampf ◽  
Sebastian Mate ◽  
Hans-Ulrich Prokosch ◽  
...  

Background The harmonization and standardization of digital medical information for research purposes is a challenging and ongoing collaborative effort. Current research data repositories typically require extensive efforts in harmonizing and transforming original clinical data. The Fast Healthcare Interoperability Resources (FHIR) format was designed primarily to represent clinical processes; therefore, it closely resembles the clinical data model and is more widely available across modern electronic health records. However, no common standardized data format is directly suitable for statistical analyses, and data need to be preprocessed before statistical analysis. Objective This study aimed to elucidate how FHIR data can be queried directly with a preprocessing service and be used for statistical analyses. Methods We propose that the binary JavaScript Object Notation format of the PostgreSQL (PSQL) open source database is suitable for not only storing FHIR data, but also extending it with preprocessing and filtering services, which directly transform data stored in FHIR format into prepared data subsets for statistical analysis. We specified an interface for this preprocessor, implemented and deployed it at University Hospital Erlangen-Nürnberg, generated 3 sample data sets, and analyzed the available data. Results We imported real-world patient data from 2016 to 2018 into a standard PSQL database, generating a dataset of approximately 35.5 million FHIR resources, including “Patient,” “Encounter,” “Condition” (diagnoses specified using International Classification of Diseases codes), “Procedure,” and “Observation” (laboratory test results). We then integrated the developed preprocessing service with the PSQL database and the locally installed web-based KETOS analysis platform. Advanced statistical analyses were feasible using the developed framework using 3 clinically relevant scenarios (data-driven establishment of hemoglobin reference intervals, assessment of anemia prevalence in patients with cancer, and investigation of the adverse effects of drugs). Conclusions This study shows how the standard open source database PSQL can be used to store FHIR data and be integrated with a specifically developed preprocessing and analysis framework. This enables dataset generation with advanced medical criteria and the integration of subsequent statistical analysis. The web-based preprocessing service can be deployed locally at the hospital level, protecting patients’ privacy while being integrated with existing open source data analysis tools currently being developed across Germany.


Sensi Journal ◽  
2020 ◽  
Vol 6 (2) ◽  
pp. 236-246
Author(s):  
Ilamsyah Ilamsyah ◽  
Yulianto Yulianto ◽  
Tri Vita Febriani

The right and appropriate system of receiving and transferring goods is needed by the company. In the process of receiving and transferring goods from the central warehouse to the branch warehouse at PDAM Tirta Kerta Raharja, Tangerang Regency, which is currently done manually is still ineffective and inaccurate because the Head of Subdivision uses receipt documents, namely PPBP and mutation of goods, namely MPPW in the form of paper as a submission media. The Head of Subdivision enters the data of receipt and mutation of goods manually and requires a relatively long time because at the time of demand for the transfer of goods the Head of Subdivision must check the inventory of goods in the central warehouse first. Therefore, it is necessary to hold a design of information systems for the receipt and transfer of goods from the central warehouse to a web-based branch warehouse that is already database so that it is more effective, efficient and accurate. With the web-based system of receiving and transferring goods that are already datatabed, it can facilitate the Head of Subdivision in inputing data on the receipt and transfer of goods and control of stock inventory so that the Sub Head of Subdivision can do it periodically to make it more effective, efficient and accurate. The method of data collection is done by observing, interviewing and studying literature from various previous studies, while the system analysis method uses the Waterfall method which aims to solve a problem and uses design methods with visual modeling that is object oriented with UML while programming using PHP and MySQL as a database.


2011 ◽  
Vol 25 (6) ◽  
pp. 794-800 ◽  
Author(s):  
Han-Joo Lee ◽  
Katy Goudarzi ◽  
Brian Baldwin ◽  
David Rosenfield ◽  
Michael J. Telch

Author(s):  
Hyung-Jung Kim ◽  
Won-Shik Chu ◽  
Hyuk-Jin Kang ◽  
Sung-Hoon Ahn ◽  
Dong-Soo Kim ◽  
...  

In this paper, web-based design and manufacturing systems are compared with a commercial CAD/CAM system from the point of usability. The web-based systems included in this study were MIcro Machining System (MIMS) and SmartFab. In the MIMS architecture, a 3D model in STL format was read via a web browser, sent to the web server for toolpath planning, and NC codes were generated to be fed back to the designer through the web connection. In the SmartFab system, SolidWorks was used as the design interface with provided modified menus for micro machining. These additional menus were created by SolidWorks API that also provided web-based links to the toolpath planner. In the commercial CAD/CAM case, without using any web connection, SolidWorks or CATIA was used for design, and PowerMill was used as a CAM tool. For each design and manufacturing system, accessibility, user-friendliness, toolpath-reliability, and processing time were compared. Total 91 students tested these systems in undergraduate CAD class, and the feedback showed better performance of the web-based system in accessibility, user-friendliness, and processing time. However, reliability of the web-based system showed necessity of further improvement.


Sign in / Sign up

Export Citation Format

Share Document