Generic clinical study data management systems can record data on an arbitrary number of parameters in an arbitrary number of clinical studies without requiring modification of the database schema. They achieve this by using an Entity-Attribute-Value (EAV) model for clinical data. While very flexible for creating transaction-oriented systems for data entry and browsing of individual forms, EAV-modeled data is unsuitable for direct analytical processing, which is the focus of data marts. For this purpose, such data must be extracted and restructured appropriately. This paper describes how such a process, which is non-trivial and highly error prone if performed using non-systematic approaches, can be automated by judicious use of the study metadata-the descriptions of measured parameters and their higher-level grouping. The metadata, in addition to driving the process, is exported along with the data, in order to facilitate its human interpretation.
Download full-text PDF |
Source |
|---|---|
| http://dx.doi.org/10.1016/s1386-5056(02)00047-3 | DOI Listing |
Publication Analysis
Top Keywords
Similar Publications
Background: Liver malignancies present substantial challenges to surgeons due to the extensive hepatic resections required, frequently resulting in posthepatectomy liver failure. Associating liver partition and portal vein ligation for staged hepatectomy (ALPPS) was designed to increase the resectable liver volume, yet it is associated with significant mortality and morbidity rates. Recently, minimally invasive techniques have been incorporated into ALPPS, with the potential to improve the procedure's safety profile whilst maintaining efficacy.
View Article and Find Full Text PDFInfluence of lung function on macro- and micro-structural brain changes in mid- and late-life.
Int J Surg
January 2025
Aging Research Center, Department of Neurobiology, Care Sciences and Society, Karolinska Institutet, Stockholm, Sweden.
Introduction: Lung function has been associated with cognitive decline and dementia, but the extent to which lung function impacts brain structural changes remains unclear. We aimed to investigate the association of lung function with structural macro- and micro-brain changes across mid- and late-life.
Methods: The study included a total of 37 164 neurologic disorder-free participants aged 40-70 years from the UK Biobank, who underwent brain MRI scans 9 years after baseline.
The development and evaluation of nine obesity-based indices for gallstones in U.S. adults.
Int J Surg
January 2025
Department of General Surgery.
Objective: Gallstones have gradually become a highly prevalent digestive disease worldwide. This study aimed to investigate the association of nine different obesity-related indicators (BRI, RFM, BMI, WC, LAP, CMI, VAI, AIP, TyG) with gallstones and to compare their predictive properties for screening gallstones.
Methods: Data for this study were obtained from the National Health and Nutrition Examination Survey (NHANES) for the 2017-2020 cycle, and weighted logistic regression analyses with multi-model adjustment were conducted to explore the association of the nine indicators with gallstones.
Evaluation of nationwide analysis surveillance for methicillin-resistant within Genomic Medicine Sweden.
Microb Genom
January 2025
Department of Laboratory Medicine, Clinical Microbiology, Faculty of Medicine and Health, rebro University, rebro, Sweden.
National epidemiological investigations of microbial infections greatly benefit from the increased information gained by whole-genome sequencing (WGS) in combination with standardized approaches for data sharing and analysis. To evaluate the quality and accuracy of WGS data generated by different laboratories but analysed by joint pipelines to reach a national surveillance approach. A national methicillin-resistant (MRSA) collection of 20 strains was distributed to nine participating laboratories that performed in-house procedures for WGS.
View Article and Find Full Text PDFDeep learning for kidney trauma detection: CT image algorithm performance and external validation: experimental study.
Int J Surg
January 2025
Department of Trauma and Emergency Surgery, Chang Gung Memorial Hospital, Linkou; Chang Gung University, Taoyuan, Taiwan.
Background: Detecting kidney trauma on CT scans can be challenging and is sometimes overlooked. While deep learning (DL) has shown promise in medical imaging, its application to kidney injuries remains underexplored. This study aims to develop and validate a DL algorithm for detecting kidney trauma, using institutional trauma data and the Radiological Society of North America (RSNA) dataset for external validation.
View Article and Find Full Text PDFWant AI Summaries of new PubMed Abstracts delivered to your In-box?
Enter search terms and have AI summaries delivered each week - change queries or unsubscribe any time!