{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,5,14]],"date-time":"2025-05-14T09:50:02Z","timestamp":1747216202448,"version":"3.40.5"},"reference-count":0,"publisher":"IOS Press","isbn-type":[{"type":"electronic","value":"9781643685366"}],"license":[{"start":{"date-parts":[[2024,8,30]],"date-time":"2024-08-30T00:00:00Z","timestamp":1724976000000},"content-version":"unspecified","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by-nc\/4.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2024,8,30]]},"abstract":"<jats:p>Introduction: The secondary use of data in clinical environments offers significant opportunities to enhance medical research and practices. However, extracting data from generic data structures, particularly the Entity-Attribute-Value (EAV) model, remains challenging. This study addresses these challenges by developing a methodological approach to convert EAV-based data into a format more suitable for analysis. Background: The EAV model is widely used in clinical information systems due to its adaptability, but it often complicates data retrieval for research purposes due to its vertical data structure and dynamic schema. Objective: The objective of this study is to develop a methodological approach to address the handling of these generic data structures, Methods: We introduce a five-step methodological approach: 1) understanding the specific clinical processes to determine data collection points and involved roles; 2) analysing the data source to understand the data structure and metadata; 3) reversing a use-case-specific data structure to map the front-end data input to its storage format; 4) analysing the content to identify medical information and establish connections; and 5) managing schema changes to maintain data integrity. Results: Applying this method to the hospital information system has shown that EAV-based data can be converted into a structured format, suitable for research. This conversion reduced data sparsity and improved the manageability of schema changes without affecting other classes of data. Conclusion: The developed approach provides a systematic method for handling complex data relationships and maintaining data integrity in clinical systems using EAV models. This approach facilitates the secondary use of clinical data, enhancing its utility for medical research and practice.<\/jats:p>","DOI":"10.3233\/shti240857","type":"book-chapter","created":{"date-parts":[[2024,9,5]],"date-time":"2024-09-05T09:09:46Z","timestamp":1725527386000},"source":"Crossref","is-referenced-by-count":0,"title":["Challenges in Retrieving Patterns from Generic Data Structures in Clinical Systems \u2013 A Technical Case Report"],"prefix":"10.3233","author":[{"ORCID":"https:\/\/orcid.org\/0009-0004-1543-9769","authenticated-orcid":false,"given":"Richard","family":"Gebler","sequence":"first","affiliation":[{"name":"Institute for Medical Informatics and Biometry, Faculty of Medicine and University Hospital Carl Gustav Carus, Dresden University of Technology, Dresden, Germany"}]},{"given":"Hung Manh","family":"Nguyen","sequence":"additional","affiliation":[{"name":"Institute for Medical Informatics and Biometry, Faculty of Medicine and University Hospital Carl Gustav Carus, Dresden University of Technology, Dresden, Germany"}]},{"given":"Luise","family":"Donat","sequence":"additional","affiliation":[{"name":"Institute for Medical Informatics and Biometry, Faculty of Medicine and University Hospital Carl Gustav Carus, Dresden University of Technology, Dresden, Germany"}]},{"given":"Jens","family":"Helbig","sequence":"additional","affiliation":[{"name":"Data Integration Center, Center for Medical Informatics, University Hospital Carl Gustav Carus, Dresden, Germany"}]},{"given":"Martin","family":"Sedlmayr","sequence":"additional","affiliation":[{"name":"Institute for Medical Informatics and Biometry, Faculty of Medicine and University Hospital Carl Gustav Carus, Dresden University of Technology, Dresden, Germany"}]},{"given":"Miriam","family":"Goldammer","sequence":"additional","affiliation":[{"name":"Institute for Medical Informatics and Biometry, Faculty of Medicine and University Hospital Carl Gustav Carus, Dresden University of Technology, Dresden, Germany"}]},{"given":"Ines","family":"Reinecke","sequence":"additional","affiliation":[{"name":"Institute for Medical Informatics and Biometry, Faculty of Medicine and University Hospital Carl Gustav Carus, Dresden University of Technology, Dresden, Germany"},{"name":"Data Integration Center, Center for Medical Informatics, University Hospital Carl Gustav Carus, Dresden, Germany"}]}],"member":"7437","container-title":["Studies in Health Technology and Informatics","German Medical Data Sciences 2024"],"original-title":[],"link":[{"URL":"https:\/\/ebooks.iospress.nl\/pdf\/doi\/10.3233\/SHTI240857","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2024,9,5]],"date-time":"2024-09-05T09:09:50Z","timestamp":1725527390000},"score":1,"resource":{"primary":{"URL":"https:\/\/ebooks.iospress.nl\/doi\/10.3233\/SHTI240857"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024,8,30]]},"ISBN":["9781643685366"],"references-count":0,"URL":"https:\/\/doi.org\/10.3233\/shti240857","relation":{},"ISSN":["0926-9630","1879-8365"],"issn-type":[{"type":"print","value":"0926-9630"},{"type":"electronic","value":"1879-8365"}],"subject":[],"published":{"date-parts":[[2024,8,30]]}}}