Name
Abstract | ||
|---|---|---|
A core issue of the decision-making process in the medical field is to support the execution of analytical (OLAP) similarity queries over images in data warehousing environments. In this paper, we focus on this issue. We propose imageDWE, a non-conventional data warehousing environment that enables the storage of intrinsic features taken from medical images in a data warehouse and supports OLAP similarity queries over them. To comply with this goal, we introduce the concept of perceptual layer, which is an abstraction used to represent an image dataset according to a given feature descriptor in order to enable similarity search. Based on this concept, we propose the imageDW, an extended data warehouse with dimension tables specifically designed to support one or more perceptual layers. We also detail how to build an imageDW and how to load image data into it. Furthermore, we show how to process OLAP similarity queries composed of a conventional predicate and a similarity search predicate that encompasses the specification of one or more perceptual layers. Moreover, we introduce an index technique to improve the OLAP query processing over images. We carried out performance tests over a data warehouse environment that consolidated medical images from exams of several modalities. The results demonstrated the feasibility and efficiency of our proposed imageDWE to manage images and to process OLAP similarity queries. The results also demonstrated that the use of the proposed index technique guaranteed a great improvement in query processing. HighlightsWe focus on the manipulation of medical images in a data warehousing.We show how to store intrinsic features from medical images in a data warehouse.We show how to process OLAP similarity queries in an image data warehousing.We propose a new Bitmap-based index to speed up OLAP similarity query processing.Tests demonstrated the feasibility of our proposal to manage real medical images. |
Year | DOI | Venue |
|---|---|---|
2015 | 10.1016/j.compbiomed.2015.08.019 | Computers in Biology and Medicine |
Keywords | Field | DocType |
Data warehousing,Medical database,Medical image,ETL process,OLAP query processing,Similarity search,Indexing,Bitmap index | Data warehouse,Data mining,Bitmap index,Abstraction,Information retrieval,Computer science,Search engine indexing,Bitmap,Online analytical processing,Nearest neighbor search,Speedup | Journal |
Volume | Issue | ISSN |
66 | C | 0010-4825 |
Citations | PageRank | References |
0 | 0.34 | 21 |
Authors | ||
10 | ||
Name | Order | Citations | PageRank |
|---|---|---|---|
| Jefferson Teixeira | 1 | 0 | 0.68 |
| Luana Peixoto Annibal | 2 | 0 | 0.34 |
| Joaquim Cezar Felipe | 3 | 54 | 7.17 |
| Ricardo Rodrigues Ciferri | 4 | 137 | 22.24 |
| Cristina Dutra De Aguiar Ciferri | 5 | 166 | 27.92 |
| TeixeiraJefferson William | 6 | 0 | 0.34 |
| AnnibalLuana Peixoto | 7 | 0 | 0.34 |
| FelipeJoaquim Cezar | 8 | 11 | 0.98 |
| CiferriRicardo Rodrigues | 9 | 7 | 1.60 |
| CiferriCristina Dutra de Aguiar | 10 | 2 | 1.07 |