Submit Manuscript  

Article Details


A New Relational Database Including Clinical Data and Myocardial Perfusion Imaging Findings in Coronary Artery Disease

[ Vol. 15 , Issue. 7 ]

Author(s):

Rosario Megna*, Mario Petretta, Bruno Alfano, Valeria Cantoni, Roberta Green, Stefania Daniele, Wanda Acampa, Carmela Nappi, Valeria Gaudieri, Roberta Assante, Emilia Zampella, Emanuela Mazziotti, Teresa Mannarino, Pietro Buongiorno and Alberto Cuocolo   Pages 661 - 671 ( 11 )

Abstract:


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.

Keywords:

Database, PostgreSQL, cardiac imaging, single-photon emission computed tomography, myocardial perfusion, coronary artery disease.

Affiliation:

Institute of Biostructure and Bioimaging, National Council of Research, Naples, Department of Translational Medical Sciences, University of Naples Federico II, Naples, Institute of Biostructure and Bioimaging, National Council of Research, Naples, Department of Advanced Biomedical Sciences, University of Naples Federico II, Naples, Department of Advanced Biomedical Sciences, University of Naples Federico II, Naples, Institute of Biostructure and Bioimaging, National Council of Research, Naples, Department of Advanced Biomedical Sciences, University of Naples Federico II, Naples, Department of Advanced Biomedical Sciences, University of Naples Federico II, Naples, Institute of Biostructure and Bioimaging, National Council of Research, Naples, Department of Advanced Biomedical Sciences, University of Naples Federico II, Naples, Department of Advanced Biomedical Sciences, University of Naples Federico II, Naples, Department of Advanced Biomedical Sciences, University of Naples Federico II, Naples, Department of Advanced Biomedical Sciences, University of Naples Federico II, Naples, Department of Advanced Biomedical Sciences, University of Naples Federico II, Naples, Department of Advanced Biomedical Sciences, University of Naples Federico II, Naples

Graphical Abstract:



Read Full-Text article