Use of automatic SQL generation interface to enhance transparency and validity of health-data analysis.
Databases
Graphical user-interface
Reproducibility of analysis
Structured query language
Validity of analysis
Journal
Informatics in medicine unlocked
ISSN: 2352-9148
Titre abrégé: Inform Med Unlocked
Pays: England
ID NLM: 101718051
Informations de publication
Date de publication:
2022
2022
Historique:
entrez:
25
7
2022
pubmed:
26
7
2022
medline:
26
7
2022
Statut:
ppublish
Résumé
Analysis of health data typically requires development of queries using structured query language (SQL) by a data-analyst. As the SQL queries are manually created, they are prone to errors. In addition, accurate implementation of the queries depends on effective communication with clinical experts, that further makes the analysis error prone. As a potential resolution, we explore an alternative approach wherein a graphical interface that automatically generates the SQL queries is used to perform the analysis. The latter allows clinical experts to directly perform complex queries on the data, despite their unfamiliarity with SQL syntax. The interface provides an intuitive understanding of the query logic which makes the analysis transparent and comprehensible to the clinical study-staff, thereby enhancing the transparency and validity of the analysis. This study demonstrates the feasibility of using a user-friendly interface that automatically generate SQL for analysis of health data. It outlines challenges that will be useful for designing user-friendly tools to improve transparency and reproducibility of data analysis.
Identifiants
pubmed: 35874460
doi: 10.1016/j.imu.2022.100996
pmc: PMC9306316
mid: NIHMS1823585
pii:
doi:
Types de publication
Journal Article
Langues
eng
Subventions
Organisme : NLM NIH HHS
ID : R00 LM011575
Pays : United States
Organisme : NHGRI NIH HHS
ID : R01 HG009174
Pays : United States
Organisme : NHLBI NIH HHS
ID : R01 HL151643
Pays : United States
Déclaration de conflit d'intérêts
Declaration of competing interest The authors declare that they have no conflict of interest.
Références
J Am Med Inform Assoc. 2017 Mar 1;24(2):398-402
pubmed: 27274012
Circulation. 2021 Feb 2;143(5):507-509
pubmed: 33201729
PLoS One. 2016 Mar 31;11(3):e0152722
pubmed: 27031856
Stud Health Technol Inform. 2017;243:42-46
pubmed: 28883167
Perspect Health Inf Manag. 2005 Sep 06;2:3
pubmed: 18066371
Appl Clin Inform. 2021 Oct;12(5):1041-1048
pubmed: 34758494
J Am Med Inform Assoc. 2009 Sep-Oct;16(5):624-30
pubmed: 19567788
NPJ Digit Med. 2020 Aug 19;3:109
pubmed: 32864472
J Am Med Inform Assoc. 2018 Oct 1;25(10):1331-1338
pubmed: 30085008
BMC Med Inform Decis Mak. 2018 Jul 16;18(1):66
pubmed: 30012140
J Am Med Inform Assoc. 2016 Sep;23(5):909-15
pubmed: 26911824
AMIA Jt Summits Transl Sci Proc. 2019 May 06;2019:370-378
pubmed: 31258990
AMIA Jt Summits Transl Sci Proc. 2017 Jul 26;2017:302-307
pubmed: 28815145
Stud Health Technol Inform. 2021 May 27;281:506-507
pubmed: 34042623
J Am Med Inform Assoc. 2011 May 1;18(3):314-7
pubmed: 21262924
Summit Transl Bioinform. 2009 Mar 01;2009:1-5
pubmed: 21347159
Afr J Lab Med. 2020 Nov 18;9(2):1092
pubmed: 33354531
J Am Med Inform Assoc. 2022 Mar 15;29(4):643-651
pubmed: 34849976
AMIA Jt Summits Transl Sci Proc. 2013 Mar 18;2013:124
pubmed: 24303250
J Alzheimers Dis. 2021;79(2):543-557
pubmed: 33337364
Clin Cardiol. 2020 Jan;43(1):4-13
pubmed: 31725920
Healthc Inform Res. 2017 Oct;23(4):349-354
pubmed: 29181247
AMIA Annu Symp Proc. 2006;:1148
pubmed: 17238767
J Am Med Inform Assoc. 2010 Mar-Apr;17(2):124-30
pubmed: 20190053
J Clin Med Res. 2019 Jun;11(6):458-463
pubmed: 31143314
JAMIA Open. 2018 Oct;1(2):147-152
pubmed: 30474072
Stud Health Technol Inform. 2011;169:887-91
pubmed: 21893874