Skip to main content
Key Specialties
Cardiology Diabetology Endocrinology Gastroenterology Geriatrics and Gerontology Gynecology and Obstetrics Hematology Infectious Disease Internal Medicine Nephrology Neurology Oncology Pediatrics Respiratory Medicine Rheumatology Surgery
Congress Coverage
2024 ACC Congress 2023 ESMO Congress 2023 EASD Congress 2023 ERS Congress 2023 ESC Congress
Clinical Collections
Advances in Alzheimer’s

Keynote webinar | Spotlight on medication adherence

LIVE: Thursday 27th June 2024, 18:00-19:30 (CEST)
Join our expert panel to discover why you need to understand the drivers of non-adherence in your patients, and how you can optimize medication adherence in your clinics to drastically improve patient outcomes.
ADVANCED SEARCH
Log in
Top
Journal of Imaging Informatics in Medicine
Published in: Journal of Digital Imaging 2/2009

01-04-2009

POSTGRESQL-IE: An Image-handling Extension for PostgreSQL

Authors: Denise Guliato, Ernani V. de Melo, Rangaraj M. Rangayyan, Robson C. Soares

Published in: Journal of Imaging Informatics in Medicine | Issue 2/2009

Login to get access

Abstract

The last decade witnessed a growing interest in research on content-based image retrieval (CBIR) and related areas. Several systems for managing and retrieving images have been proposed, each one tailored to a specific application. Functionalities commonly available in CBIR systems include: storage and management of complex data, development of feature extractors to support similarity queries, development of index structures to speed up image retrieval, and design and implementation of an intuitive graphical user interface tailored to each application. To facilitate the development of new CBIR systems, we propose an image-handling extension to the relational database management system (RDBMS) PostgreSQL. This extension, called PostgreSQL-IE, is independent of the application and provides the advantage of being open source and portable. The proposed system extends the functionalities of the structured query language SQL with new functions that are able to create new feature extraction procedures, new feature vectors as combinations of previously defined features, and new access methods, as well as to compose similarity queries. PostgreSQL-IE makes available a new image data type, which permits the association of various images with a given unique image attribute. This resource makes it possible to combine visual features of different images in the same feature vector. To validate the concepts and resources available in the proposed extended RDBMS, we propose a CBIR system applied to the analysis of mammograms using PostgreSQL-IE.
Appendix
Available only for authorised users
Literature
1.
Datta R, Li J, Wang JZ: Content-based image retrieval—approaches and trends of the new age. In: Proceedings of the ACM International Workshop on Multimedia Information Retrieval, ACM Multimedia, Singapore, November, 2005, pp 253–261
2.
Guliato D, Rangayyan RM, Carvalho JD, Santiago SA: Spiculation-preserving polygonal modeling of contours of breast tumors. In: Proceedings of the 28th Annual International Conference of the IEEE Engineering in Medicine and Biology Society, New York City, NY, September, 2006, pp 2791–2794
3.
Rangayyan RM, Guliato D, Carvalho JD, Santiago SA: Feature extraction from the turning angle function for the classification of breast tumors. In Proceedings of the International Special Topics Conference on Information Technology in Biomedicine—IEEE ITAB2006, Ioannina, Greece, October, 2006 (6 pages on CDROM)
4.
Carvalho JD, Rangayyan RM, Guliato D, Santiago SA: Polygonal modeling of contours using the turning angle function. In 20th IEEE Canadian Conference on Electrical and Computer Engineering, Vancouver, BC, April, 2007, pp 1090–1267
5.
Chen Y, Wang JZ: A region-based fuzzy feature matching approach to content-based image retrieval. IEEE Trans Pattern Anal Mach Intell 24(9):1252–1267, 2002CrossRef
6.
Mudigonda NR, Rangayyan RM, Desautels JEL: Detection of breast masses in mammograms by density slicing and texture flow-field analysis. IEEE Trans Med Imag 20(12):1215–1227, 2001CrossRef
7.
Rangayyan RM, Nguyen TM: Fractal analysis of contours of breast masses in mammograms. J Digit Imaging 20(3):223–237, 2007 (September)PubMedCrossRef
8.
Veltkamp RC, Tanase M: Content-based Image and Video Retrieval, Norwell, MA: Kluwer, 2002
9.
Csillaghy A, Hinterberger H, Benz AO: Content-based image retrieval in astronomy. Inf Retr 3(3):229–241, 2000CrossRef
10.
Painter TH, Dozier J, Roberts DA, Davis RE, Green RO: Retrieval of subpixel snowcovered area and grain size from imaging spectrometer data. Remote Sens Environ 85(1):64–77, 2003CrossRef
11.
Schroder M, Rehrauer H, Seidel K, Datcu M: Interactive learning and probabilistic retrieval in remote sensing images archives. IEEE Trans Geosci Remote Sens 38(5):2288–2298, 2000CrossRef
12.
Wang JZ, Li J, Wiederhold J: SIMPLIcity: semantics sensitive integrated matching for picture libraries. IEEE Trans Pattern Anal Mach Intell 23(9):947–963, 2001CrossRef
13.
Guliato D, Rangayyan RM, Melo EV, Soares RC: A system for content-based image retrieval and analysis of mammograms using PostgreSQL with image-handling extension. In: Proceedings of the Fifth IASTED International Conference on Biomedical Engineering, Innsbruck, Austria, February, 2007, pp 402–408
14.
Alto H, Rangayyan RM, Paranjape RB, Desautels JEL, Bryant H: An indexed atlas of digital mammograms for computer-aided diagnosis of breast cancer. Ann Telecommun 58(5–6):820–835, 2003
15.
Baroni MCN, Rezende HL, Traina-Jr C, and Traina AJM: Queryng complex objects by similarity in SQL*. In: Proceedings of Brazilian Symposium on Databases—SBBD2005, Uberlândia, MG, Brazil, October–November, 2005, pp 1–5
16.
Böhm C, Berchtold S, Keim DA: Searching in high-dimensional spaces—index structures for improving the performance of multimedia databases. ACM Comput Surv 33(3):322–373, 2001CrossRef
17.
Chávez E, Navarro G, Baeza-Yates R, Marroquím J: Searching in metric space. ACM Comput Surv 33(3):273–321, 2001CrossRef
18.
Ciaccia P, Patella M: M-tree: an efficient access method for similarity search in metric spaces. In: Proceedings of International Conference on Very Large Data Bases (VLDB), Athens, Greece, 1997, pp 426–435
19.
Traina Jr, C, Traina AJM, Faloutsos C, Seeger B: Fast indexing and visualization of metric datasets using slim-trees. IEEE Trans Knowl Data Eng 14(2):244–260, 2002CrossRef
20.
Digout C, Nascimento M, Coman A: Similarity search and dimensionality reduction: not all dimensions are equally useful. In: Proceedings of Database Systems for Advanced Applications—9th International Conference, DASFAA 2004, Jeju Island, Korea, March 17–19. Springer, Berlin, Germany, 2004 (also in Lect Notes Comput Sci 2973:831–842)
21.
Kailing K, Kriegel HP, Schönauer S, Seidl T: Efficient similarity search for hierarquical data in large databases. In: Proceedings of Advances in Database Technology—EDBT 2004—9th International Conference on Extending Database Technology, Heraklion, Crete, Greece, March. Springer, Berlin, Germany, 2004 (also in Lect Notes Comput Sci 2992:676–693)
22.
Vieira MR, Chino F, Traina-Jr, C, Traina AJM: Dbm-tree: a metric access method sensitive to local density data. In: Proceedings of Brazilian Symposium on Databases—SBBD2004, Brasilia, DF, Brazil, October, 2004, pp 163–177
23.
Carey MJ, Kossmann D: On saying enough already in SQL. In: Proceedings of the 1997 ACM SIGMOD international conference on Management of data, Tucson, AZ, May, 1997, pp 219–230
24.
Carey MJ, Kossmann D: Reducing the braking distance of an SQL query engine. In: Proceedings of the Conf. on Very Large Data Bases (VLDB), New York City, NY. VLDB Endowment, Saratoga, CA, 1998, pp 158–169
25.
Gao L, Wang M, Wang XS, Padmanabhan S: Expressing and optimizing similarity queries in SQL. In: Proceedings of Conceptual Modeling—ER—23rd International Conference on Conceptual Modeling, Shanghai, China, November. Springer, Berlin, Germany, 2004 (also in Lect Notes Comput Sci 3288:464–478)
26.
Melton J, Eisenberg A: SQL multimedia and application packages (SQL/MM). ACM SIGMOD Record 30(4):97–102, 2001 (December)CrossRef
27.
The POSTGRES Group: The POSTGRES Reference Manual, Berkeley, CA: Computer Science Division, University of California, 1993 (January)
28.
Guliato D, Rangayyan RM, Carvalho JD, Santiago SA: Polygonal modeling of contours of breast tumors with the preservation of spicules. IEEE Trans Biomed Eng 55:14–20, 2008PubMedCrossRef
29.
Melo EV, Guliato D, Rangayyan RM, Soares RS: SISPRIM—Sistema De Pesquisa Com Suporte Para Recupera, cão de imagens por conte’udo. In: Proceedings of WIM2006 - VI Workshop de Inform’atica M’edica, Vila Velha, ES, Brazil, June, 2006.
30.
31.
32.
Informix: Informix Image Foundation DataBlade Module, Users Guide, Version 2.0. 2000 (December)
33.
34.
ISO: ISO/IEC IS 13249-5:2001 SQL/MM, Information Technology Database Languages SQL Multimedia and Application Packages Part 5: Still Image. 2001.
35.
Stolze K: Still image extensions in database systems—a product overview. In: Datenbank-Spektrum, 2002, pp 40–47 (February)
36.
The POSTGRES Group. PostgreSQL 8.0.0 Documentation. 2005
37.
Rangayyan RM, El-Faramawy NM, Desautels JEL, Alim OA: Measures of acutance and shape for classification of breast tumors. IEEE Trans Med Imag 16(6):799–810, 1997CrossRef
38.
Guliato D, Bôaventura RS, Melo EV, Rangayyan RM: AMDI: an indexed atlas of digital mammograms that integrates case studies, e-learning, and research systems via the web. In: Suri JS, Rangayyan RM Eds. Recent Advances in Breast Imaging, Mammography, and Computer-aided Diagnosis of Breast Cancer. Bellingham, WA: SPIE, 2006, pp. 529–555
39.
American College of Radiology: Breast Imaging Reporting and Data System BI-RADS, 4th edition. Reston, VA: American College of Radiology, 2004
40.
41.
Alto H, Rangayyan RM, Desautels JEL: Content-based retrieval and analysis of mammographic masses. J Electron Imaging 14(2):023016, 2005CrossRef
42.
43.
Rangayyan RM, Mudigonda NR, Desautels JEL: Boundary modelling and shape analysis methods for classification of mammographic masses. Med Biol Eng Comput 38:487–496, 2000PubMedCrossRef
44.
45.
Rui Y, Yang TS, Mehrotra S: Content-based Image Retrieval with Relevance Feedback in Mars. In: IEEE International Conference in Image Processing, volume 2, Santa Barbara, CA, 1997, pp 815–818
46.
Rui Y, Yang TS, Ortega M, Mehrotra S: Relevance feedback: a powerful tool in interactivecontent-based image retrieval. IEEE Trans Circuits Syst Video Technol 8(5):644–655, 1998 (September)CrossRef
47.
Triana AJM, Marques J, Traina Jr C. Fighting the semantic gap on CBIR system through new relevance feedback techniques. In: Proceedings of 19th IEEE Symposium on Computer-based Medical Systems (CBMS’06), 2006, pp 881–886
48.
Guliato D, de Melo EV, Bôaventura RS, Janones FR, de Deus V, Rangayyan RM: AMDI: an atlas to integrate case studies, e-learning, and research systems via the Web. In: Proceedings of the IASTED International Conference on Telehealth. Banff, AB, Canada, 2005, pp 69–74
49.
Guliato D, Caetano M, Janones FR, de Deus V, Lima SC, Rangayyan RM, Bôaventura RS, and Marques PMA. AMDI: An indexed atlas of digital mammograms availablevia the Web. In: III Latin American Congress on Biomedical Engineering, IFMBE Proceedings, 5, 2004 (4 pages on CDROM)
Metadata
Title
POSTGRESQL-IE: An Image-handling Extension for PostgreSQL
Authors
Denise Guliato
Ernani V. de Melo
Rangaraj M. Rangayyan
Robson C. Soares
Publication date
01-04-2009
Publisher
Springer-Verlag
Published in
Journal of Imaging Informatics in Medicine / Issue 2/2009
Print ISSN: 2948-2925
Electronic ISSN: 2948-2933
DOI
https://doi.org/10.1007/s10278-007-9097-5

Other articles of this Issue 2/2009

Journal of Digital Imaging 2/2009 Go to the issue

Events

Letter to the Editor re: “The Radiology Digital Dashboard: Effects on Report Turnaround Time.”

OriginalPaper

Development of an Automatic Classification System for Differentiation of Obstructive Lung Disease using HRCT

OriginalPaper

Optimising the Use of Computed Radiography in Pediatric Chest Imaging

OriginalPaper

A Knowledge-Anchored Integrative Image Search and Retrieval System

Letter

Letter to the Editor Re: “Optimizing the Use of Computer Radiography in Pediatric Chest Imaging”

OriginalPaper

A New Family of Distance Functions for Perceptual Similarity Retrieval of Medical Images