A New Relational Database Including Clinical Data and Myocardial Perfusion Imaging Findings in Coronary Artery Disease(297 views)(PDF public75 views) Megna R, Petretta M, Alfano B, Cantoni V, Green R, Daniele S, Acampa W, Nappi C, Gaudieri V, Assante R, Zampella E, Mazziotti E, Mannarino T, Buongiorno P, Cuocolo A
Curr Med Imaging Rev (ISSN: 1573-4056linking), 2019; 15(7): 661-671.
Institute of Biostructure and Bioimaging, National Council of Research, Naples, Italy.
Department of Translational Medical Sciences, University of Naples Federico II, Naples, Italy.
Department of Advanced Biomedical Sciences, University of Naples Federico II, Naples, Italy.
References: Not available.
A New Relational Database Including Clinical Data and Myocardial Perfusion Imaging Findings in Coronary Artery Disease
BACKGROUND: The aim of this study was to test a relational database including clinical data and imaging findings in a large cohort of subjects with suspected or known Coronary Artery Disease (CAD) undergoing stress single-photon emission computed tomography (SPECT) myocardial perfusion imaging. METHODS: We developed a relational database including clinical and imaging data of 7995 subjects with suspected or known CAD. The software system was implemented by PostgreSQL 9.2, an open source object-relational database, and managed from remote by pgAdmin III. Data were arranged according to a logic of aggregation and stored in a schema with twelve tables. Statistical software was connected to the database directly downloading data from server to local personal computer. RESULTS: There was no problem or anomaly for database implementation and user connections to the database. The epidemiological analysis performed on data stored in the database demonstrated abnormal SPECT findings in 46% of male subjects and 19% of female subjects. Imaging findings suggest that the use of SPECT imaging in our laboratory is appropriate. CONCLUSION: The development of a relational database provides a free software tool for the storage and management of data in line with the current standard.
A New Relational Database Including Clinical Data and Myocardial Perfusion Imaging Findings in Coronary Artery Disease