Case Study of the Medical Decision-Making System ETL Abnormalities Processing Procedure

2012 ◽  
Vol 433-440 ◽  
pp. 894-899
Author(s):  
Hui Chen Tsai ◽  
Kuo Chung Lin ◽  
Ching Long Yeh

The primary purpose of this research is to resolve the problem of ETL operation failure in execution of ETL (Extraction, Transformation and Loading) by the medical decision-making system due to data content, system factors and defective program design, thereby affect online daily operation of the application system and even customer complaint. This research first research and develop how to record in database, whether successful or not, the number of ETL file conversion program (including tool and self-wrote PL/SQL program) execution process, data status, and execution time; followed by designing control mechanism and write Script for voluminous table restoration for automatic execution by the system; afterwards followed by research and develop system automatic execution of restoration to stop only the affected application programs of the table and design a restoration mechanism. Lastly, through verification, this R&D result would correctly restore the data and table required by ETL procedure.

2016 ◽  
Vol 1 (1) ◽  
pp. 238146831667775 ◽  
Author(s):  
Jabez J. Christopher ◽  
Harichandran Khanna Nehemiah ◽  
Kannan Arputharaj ◽  
George L. Moses

2020 ◽  
Author(s):  
Brinnae Bent ◽  
Jessilyn P Dunn

UNSTRUCTURED Recently, companies such as Apple Inc, Fitbit Inc, and Garmin Ltd have released new wearable blood oxygenation measurement technologies. Although the release of these technologies has great potential for generating health-related information, it is important to acknowledge the repercussions of consumer-targeted biometric monitoring technologies (BioMeTs), which in practice, are often used for medical decision making. BioMeTs are bodily connected digital medicine products that process data captured by mobile sensors that use algorithms to generate measures of behavioral and physiological function. These BioMeTs span both general wellness products and medical devices, and consumer-targeted BioMeTs intended for general wellness purposes are not required to undergo a standardized and transparent evaluation process for ensuring their quality and accuracy. The combination of product functionality, marketing, and the circumstances of the global SARS-CoV-2 pandemic have inevitably led to the use of consumer-targeted BioMeTs for reporting health-related measurements to drive medical decision making. In this viewpoint, we urge consumer-targeted BioMeT manufacturers to go beyond the bare minimum requirements described in US Food and Drug Administration guidance when releasing information on wellness BioMeTs. We also explore new methods and incentive systems that may result in a clearer public understanding of the performance and intended use of consumer-targeted BioMeTs.


Sign in / Sign up

Export Citation Format

Share Document