2026-05-20T04:01:58Zhttps://repisalud.isciii.es/rest/oai/request
oai:repisalud.isciii.es:20.500.12105/159192025-05-26T14:59:11Zcom_20.500.12105_15322com_20.500.12105_2051com_20.500.12105_2052col_20.500.12105_16938col_20.500.12105_19619
Repisalud author Pedrera-Jiménez, Miguel author García-Barrio, Noelia author Rubio-Mayo, Paula author Tato-Gómez, Alberto author Cruz-Bermúdez, Juan Luis author Bernal-Sobrino, José Luis author Muñoz Carrero, Adolfo author Serrano-Balazote, Pablo funder Ministerio de Economía y Competitividad (España) funder Instituto de Salud Carlos III 2023-04-27T11:02:48Z 2023-04-27T11:02:48Z 2022-12 Methods Inf Med. 2022 Dec;61(S02):e89-e102. 10.1055/s-0042-1757763 2511-705X Methods of information in medicine 36220109 http://hdl.handle.net/20.500.12105/15919 Background: During the COVID-19 pandemic, several methodologies were designed for obtaining electronic health record (EHR)-derived datasets for research. These processes are often based on black boxes, on which clinical researchers are unaware of how the data were recorded, extracted, and transformed. In order to solve this, it is essential that extract, transform, and load (ETL) processes are based on transparent, homogeneous, and formal methodologies, making them understandable, reproducible, and auditable. Objectives: This study aims to design and implement a methodology, according with FAIR Principles, for building ETL processes (focused on data extraction, selection, and transformation) for EHR reuse in a transparent and flexible manner, applicable to any clinical condition and health care organization. Methods: The proposed methodology comprises four stages: (1) analysis of secondary use models and identification of data operations, based on internationally used clinical repositories, case report forms, and aggregated datasets; (2) modeling and formalization of data operations, through the paradigm of the Detailed Clinical Models; (3) agnostic development of data operations, selecting SQL and R as programming languages; and (4) automation of the ETL instantiation, building a formal configuration file with XML. Results: First, four international projects were analyzed to identify 17 operations, necessary to obtain datasets according to the specifications of these projects from the EHR. With this, each of the data operations was formalized, using the ISO 13606 reference model, specifying the valid data types as arguments, inputs and outputs, and their cardinality. Then, an agnostic catalog of data was developed through data-oriented programming languages previously selected. Finally, an automated ETL instantiation process was built from an ETL configuration file formally defined. Conclusions: This study has provided a transparent and flexible solution to the difficulty of making the processes for obtaining EHR-derived data for secondary use understandable, auditable, and reproducible. Moreover, the abstraction carried out in this study means that any previous EHR reuse methodology can incorporate these results into them. eng Electronic health record FAIR Principles Data reusability Real-world data Standards TransformEHRs: a flexible methodology for building transparent ETL processes for EHR reuse research article TElDRU5DSUEgREUgRElTVFJJQlVDScOTTiBOTyBFWENMVVNJVkEKCkFjZXB0YW5kbyBlc3RhIGxpY2VuY2lhLCBVc3RlZCAoZWwgYXV0b3IvZXMgbyBlbCBwcm9waWV0YXJpby9zIGRlIGxvcyBkZXJlY2hvcyBkZSAKYXV0b3IpIGNvbmNlZGUgYSBSRVBJU0FMVUQgZWwgZGVyZWNobyBubyBleGNsdXNpdm8gZGUgcmVwcm9kdWNpciwgY29udmVydGlyLCB5L28gCmRpc3RyaWJ1aXIgc3UgZG9jdW1lbnRvIChpbmNsdXllbmRvIHN1IHJlc3VtZW4pIGEgbml2ZWwgbXVuZGlhbCBlbiBmb3JtYXRvIGRpZ2l0YWwsIAppbmNsdXllbmRvLCBhdWRpbyB5IHbDrWRlbywgYSB0cmF2w6lzIGRlIHN1IHJlcG9zaXRvcmlvIGluc3RpdHVjaW9uYWwuCgpVc3RlZCBhY2VwdGEgcXVlIFJFUElTQUxVRCBwdWVkZSwgc2luIGFsdGVyYXIgc3UgY29udGVuaWRvLCBjb252ZXJ0aXIgc3UgZG9jdW1lbnRvIAphIGN1YWxxdWllciBvdHJvIGZvcm1hdG8gZGlnaXRhbCBkZSBkYXRvcywgYXVkaW8geSB2aWRlbywgY29uIGVsIHByb3DDs3NpdG8gZGUgcXVlIApwdWVkYSBzZXIgYWxvamFkbyBlbiBlbCByZXBvc2l0b3Jpby4gCgpVc3RlZCBlc3TDoSBkZSBhY3VlcmRvIGNvbiBxdWUgUkVQSVNBTFVEIHB1ZWRhIGNvbnNlcnZhciBtw6FzIGRlIHVuYSBjb3BpYSBkZSBlc3RlIApkb2N1bWVudG8gcGFyYSBhc2VndXJhciBzdSBzZWd1cmlkYWQsIHByZXNlcnZhY2nDs24geSBhY2Nlc28uCgpVc3RlZCBkZWNsYXJhIHF1ZSBlbCBkb2N1bWVudG8gZXMgdW4gdHJhYmFqbyBvcmlnaW5hbCwgeSBxdWUgdGllbmUgZWwgZGVyZWNobyBkZSAKb3RvcmdhciBsb3MgZGVyZWNob3MgY29udGVuaWRvcyBlbiBlc3RhIGxpY2VuY2lhLiBUYW1iacOpbiBkZWNsYXJhIHF1ZSBzdSBwZXRpY2nDs24gCm5vIGluZnJpbmdlIGxvcyBkZXJlY2hvcyBkZSBhdXRvciBkZSBuYWRpZS4gCgpTaSBlbCBkb2N1bWVudG8gY29udGllbmUgbWF0ZXJpYWxlcyBwYXJhIGxvcyBxdWUgbm8gc2UgdGllbmVuIGxvcyBkZXJlY2hvcyBkZSBhdXRvciwgClVzdGVkIGRlY2xhcmEgcXVlIGhhIG9idGVuaWRvIGVsIHBlcm1pc28gc2luIHJlc3RyaWNjacOzbiBkZWwgcHJvcGlldGFyaW8gZGUgbG9zIApkZXJlY2hvcyB5IHF1ZSBlbiBkaWNobyBtYXRlcmlhbCwgZXN0w6EgY2xhcmFtZW50ZSBpZGVudGlmaWNhZGEgeSByZWNvbm9jaWRhIHN1IAphdXRvcsOtYSBkZW50cm8gZWwgdGV4dG8gbyBkZWwgY29udGVuaWRvIGRlIGRpY2hvIGRvY3VtZW50by4gCgpTaSBlbCBlbnbDrW8gc2UgYmFzYSBlbiB1biB0cmFiYWpvIHF1ZSBoYSBzaWRvIHBhdHJvY2luYWRvIG8gYXBveWFkbyBwb3IgdW5hIGFnZW5jaWEgCnUgb3JnYW5pemFjacOzbiBkaXN0aW50YSBhIFJFUElTQUxVRCwgdXN0ZWQgYWNlcHRhIHF1ZSBoYSBjdW1wbGlkbyBjb24gZWwgZGVyZWNobyBkZSAKcmV2aXNpw7NuIHkgb3RyYXMgb2JsaWdhY2lvbmVzIHJlcXVlcmlkYXMgcG9yIGNvbnRyYXRvIG8gYWN1ZXJkby4gCgpSRVBJU0FMVUQgaWRlbnRpZmljYXLDoSBjbGFyYW1lbnRlIHN1KHMpIG5vbWJyZShzKSBjb21vIGF1dG9yKHMpIG8gcHJvcGlldGFyaW8ocykgCmRlbCBkb2N1bWVudG8sIHkgbm8gaGFyw6EgbmluZ3VuYSBhbHRlcmFjacOzbiwgZXhjZXB0byBzZWfDum4gbG8gcGVybWl0aWRvIHBvciBlc3RhIApsaWNlbmNpYS4gCg== URL https://repisalud.isciii.es/bitstreams/a3c7ca6c-518e-4592-b838-d7af7c686346/download File MD5 c65fb0780cf94a710f3278396bfaa4e9 2802623 application/pdf TransformEHRsFlexibleMethodology_2022.pdf URL https://repisalud.isciii.es/bitstreams/6caacb96-57c0-4e84-baa4-4c6eb6c05262/download File MD5 bfce154722cb887fa83686882f11f391 60716 text/plain TransformEHRsFlexibleMethodology_2022.pdf.txt