Structured query language extension supports content-based image retrieval

Article

Schemes proposed to support growing interest in content-based image retrieval have generally failed to incorporate the use of structured query language to support similarity queries. Recent research from Brazil provides this ability.

Schemes proposed to support growing interest in content-based image retrieval have generally failed to incorporate the use of structured query language to support similarity queries. Recent research from Brazil provides this ability.

Similarity queries scan databases for objects similar to the reference object. To advance the efficiency of similarity searches, several index structures have been proposed, including M-trees, slim-trees, and Dbm-trees. The Brazilian work, however, is among the first to propose extending structured query language (SQL) to support these queries.

"We propose an image handling extension to the relational database management system known as PostgreSQL, with the aim of providing a tool for the development of content-based image retrieval (CBIR) systems," said Denise Guliato, Ph.D., of the Faculdade de Computação, Universidade Federal de Uberlândia in Minas Gerais.

PostgreSQL with Image-handling Extension, or PostgreSQL-IE, makes use of powerful features available with PostgreSQL to facilitate similarity queries, according to Guliato .

In addition to supporting similarity queries, the proposed system extends SQL with new functions able to create new feature extraction procedures, new feature vectors as combinations of previously defined features, and new access methods, she said.

PostgreSQL-IE makes available a new image data type attribute called PGImage, which permits the user to model a relational scheme by storing various images of different classes in the same attribute, she said.

"This novel approach makes it possible to combine visual features of different images in the same feature vector, which is helpful in developing medical applications where each image attribute is composed of a set of images, such as CT, MRI, or mammography," Guliato said.

A paper to illustrate and validate the power of the resources available in PostgreSQL-IE presents a research system that supports content-based retrieval of mammograms, termed SISPRIM.

"This system allows the user to retrieve information from a mammographic database by combining conventional and visual data, using a friendly graphical web interface," Guliato said.

Currently, PostgreSQL-IE offers two conventional similarity operators (K-nearest neighbor and range), but work has commenced to extend PostgreSQL-IE with two new similarity search procedures based on fuzzy sets to take into account the uncertainty present in medical applications of CBIR, Guliato said.

PostgreSQL-IE is open source, portable, extendable, easy to install, applications-independent, and available for Windows or Linux platforms. The script to install the software is available online.

Newsletter

Stay at the forefront of radiology with the Diagnostic Imaging newsletter, delivering the latest news, clinical insights, and imaging advancements for today’s radiologists.

Recent Videos
SNMMI: Emerging PET Insights on Neuroinflammation with Progressive Apraxia of Speech (PAOS) and Parkinson-Plus Syndrome
Improving Access to Nuclear Imaging: An Interview with SNMMI President Jean-Luc C. Urbain, MD, PhD
SNMMI: 18F-Piflufolastat PSMA PET/CT Offers High PPV for Local PCa Recurrence Regardless of PSA Level
SNMMI: NIH Researcher Discusses Potential of 18F-Fluciclovine for Multiple Myeloma Detection
SNMMI: What Tau PET Findings May Reveal About Modifiable Factors for Alzheimer’s Disease
Emerging Insights on the Use of FES PET for Women with Lobular Breast Cancer
Can Generative AI Reinvent Radiology Reporting?: An Interview with Samir Abboud, MD
Mammography Study Reveals Over Sixfold Higher Risk of Advanced Cancer Presentation with Symptom-Detected Cancers
Combining Advances in Computed Tomography Angiography with AI to Enhance Preventive Care
Study: MRI-Based AI Enhances Detection of Seminal Vesicle Invasion in Prostate Cancer
Related Content
© 2025 MJH Life Sciences

All rights reserved.