A New Relational Database Including Clinical Data and Myocardial Perfusion Imaging Findings in Coronary Artery Disease.
Adolescent
Adult
Age Factors
Aged
Aged, 80 and over
Coronary Artery Disease
/ diagnostic imaging
Databases as Topic
Female
Humans
Male
Middle Aged
Myocardial Perfusion Imaging
/ statistics & numerical data
Sex Factors
Tomography, Emission-Computed, Single-Photon
/ statistics & numerical data
Young Adult
Database
PostgreSQL
cardiac imaging
coronary artery disease
myocardial perfusion
single-photon emission computed tomography
Journal
Current medical imaging reviews
Titre abrégé: Curr Med Imaging Rev
Pays: United Arab Emirates
ID NLM: 101272516
Informations de publication
Date de publication:
2019
2019
Historique:
received:
20
12
2017
revised:
28
06
2018
accepted:
12
07
2018
entrez:
4
2
2020
pubmed:
6
2
2020
medline:
23
10
2020
Statut:
ppublish
Résumé
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. 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. 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. The development of a relational database provides a free software tool for the storage and management of data in line with the current standard.
Sections du résumé
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.
Identifiants
pubmed: 32008514
pii: CMIR-EPUB-92215
doi: 10.2174/1573405614666180807110829
doi:
Types de publication
Journal Article
Research Support, Non-U.S. Gov't
Langues
eng
Sous-ensembles de citation
IM
Pagination
661-671Informations de copyright
Copyright© Bentham Science Publishers; For any queries, please email at epub@benthamscience.net.