Abstract
We introduce the framework for storing and comparing compound objects. The implemented system is based on the RDBMS model, which – unlike other approaches in this area – enables to access the most detailed data about considered objects. It also contains ROLAP cubes designed for specific object classes and appropriately abstracted modules that compute object similarities, referred as comparators. In this paper, we focus on the case study related to images. We show specific examples of fuzzy logic comparators, together with their corresponding SQL statements executed at the level of pixels. We examine several open source database engines by means of their capabilities of storing and querying large amounts of such represented image data. We conclude that the performance of some of them is comparable to standard techniques of image storage and processing, with far better flexibility in defining new similarity criteria and analyzing larger image collections.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Agosta, L.: The Essential Guide to Data Warehousing. Prentice Hall PTR, Englewood Cliffs (2000)
Booch, G., Rumbaugh, J., Jacobson, I.: Unified Modeling Language User Guide, 2nd edn. Addison-Wesley Professional, Reading (2005)
Bovik, A.C. (ed.): Handbook of Image and Video Processing, 2nd edn. Academic Press, London (2005)
Cantu-Paz, E., Cheung, S.S., Kamath, C.: Retrieval of Similar Objects in Simulation Data Using Machine Learning Techniques. In: Proc. of Image Processing: Algorithms and Systems III, SPIE, vol. 5298, pp. 251–258 (2004)
Datta, R., Joshi, D., Li, J., Wang, J.Z.: Image Retrieval: Ideas, Influences, and Trends of the New Age. ACM Comput. Surv. 40(2), 1–60 (2008)
Galindo, J. (ed.): Handbook of Research on Fuzzy Information Processing in Databases. Information Science Reference (2008)
Garcia-Molina, H., Ullman, J.D., Widom, J.: Database Systems: The Complete Book, 2nd edn. Prentice Hall PTR, Englewood Cliffs (2008)
Khotanlou, H., Colliot, O., Atif, J., Bloch, I.: 3D brain tumor segmentation in MRI using fuzzy classification, symmetry analysis and spatially constrained deformable models. Fuzzy Sets Syst. 160(10), 1457–1473 (2009)
Lew, M.S., Sebe, N., Djeraba, C., Jain, R.: Content-based Multimedia Information Retrieval: State of the Art and Challenges. ACM Trans. Multimedia Comput. Commun. Appl. 2(1), 1–19 (2006)
Lorenz, A., Blüm, M., Ermert, H., Senge, T.: Comparison of Different Neuro-Fuzzy Classification Systems for the Detection of Prostate Cancer in Ultrasonic Images. In: Proc. of Ultrasonics Symp., pp. 1201–1204. IEEE, Los Alamitos (1997)
Lyon, D.A.: Image Processing in Java. Prentice Hall PTR, Englewood Cliffs (1999)
Melin, P., Kacprzyk, J., Pedrycz, W. (eds.): Bio-Inspired Hybrid Intelligent Systems for Image Analysis and Pattern Recognition. Springer, Heidelberg (2010)
Pękalska, E., Duin, R.P.W.: The Dissimilarity Representation for Pattern Recognition: Foundations and Applications. World Scientific, Singapore (2005)
Rajan, S.D.: Introduction to Structural Analysis & Design. Wiley, Chichester (2001)
Sarawagi, S.: Information Extraction. Foundations and Trends in Databases 1(3), 261–377 (2008)
Ślęzak, D.: Compound Analytics of Compound Data within RDBMS Framework – Infobright’s Perspective. In: Proc. of FGIT. LNCS, vol. 6485, pp. 39–40. Springer, Heidelberg (2010)
Ślęzak, D., Eastwood, V.: Data Warehouse Technology by Infobright. In: Proc. of SIGMOD, pp. 841–845. ACM, New York (2009)
Smyth, B., Keane, M.T.: Adaptation-guided Retrieval: Questioning the Similarity Assumption in Reasoning. Artif. Intell. 102(2), 249–293 (1998)
Sosnowski, Ł.: Intelligent Data Adjustment using Fuzzy Logic in Data Processing Systems (in Polish). In: Hołubiec, J. (ed.) Systems Analysis in Finances and Management, vol. 11, pp. 214–218 (2009)
Sosnowski, Ł.: Constructing Systems for Compound Object Comparisons (in Polish). In: Hołubiec, J. (ed.) Systems Analysis in Finances and Management, vol. 12, pp. 144–162 (2010)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2010 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Ślęzak, D., Sosnowski, Ł. (2010). SQL-Based Compound Object Comparators: A Case Study of Images Stored in ICE. In: Kim, Th., Kim, HK., Khan, M.K., Kiumi, A., Fang, Wc., Ślęzak, D. (eds) Advances in Software Engineering. ASEA 2010. Communications in Computer and Information Science, vol 117. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-17578-7_30
Download citation
DOI: https://doi.org/10.1007/978-3-642-17578-7_30
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-17577-0
Online ISBN: 978-3-642-17578-7
eBook Packages: Computer ScienceComputer Science (R0)