Abstract
The paper presents a relational database management system for managing and querying visual information. In order to accomplish this, the DBMS has implemented the Image data type. In a record of this type, there are stored the binary image and the automatically extracted color and texture characteristics. The color histogram with 166 colors in HSV space represents the image color information. A vector with 12 values represents the texture information obtained by applying Gabor filters. The two characteristics vectors are used for content-based visual query process. Beside this original way for visual information storage, the DBMS has a visual interface for building content-based queries using color, texture or both. Adapted for this type of queries, a Select command is built and executed by the DBMS. This system might by easily used in areas, where medium sized image collections are collected, in an efficient way and with low cost.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
MySQL 5.0 Reference Manual (2009), http://dev.mysql.com/doc/refman/5.0/en/blob.html
SQL Server 2008 Books Online (January 2009), http://msdn.microsoft.com/en-us/library/ms187993.aspx
Oracle Database SQL Reference 10g Release 2 (10.2), http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements001.htm
New interMedia Features in Oracle10g, http://www.oracle.com/technology/products/intermedia/htdocs/imedia_new_features_in_10g.html
Chigrik, A.: SQL Server 2000 vs Oracle 9i (2007), http://www.mssqlcity.com/Articles/Compare/sql_server_vs_oracle.htm
Kratochvil, M.: The Move to Store Image in the Database (2005), http://www.oracle.com/technology/products/intermedia/pdf/why_images_in_database.pdf
Del Bimbo, A.: Visual Information Retrieval. Morgan Kaufmann Publishers, San Francisco (2001)
Smith, J.R.: Integrated Spatial and Feature Image Systems: Retrieval, Compression and Analysis. Ph.D. thesis, Graduate School of Arts and Sciences. Columbia University (1997)
Gevers, T.: Image Search Engines: An Overview. Emerging Topics in Computer Vision. Prentice Hall, Englewood Cliffs (2004)
Stanescu, L., Burdescu, D.D., Brezovan, M., Stoica Spahiu, C., Ion, A.: A New Software Tool For Managing and Querying the Personal Medical Digital Imagery. In: Proceedings of the International Conference on Health Informatics, Porto, Portugal, pp. 199–204 (2009)
Samuel, J.: Query by example (QBE), http://pages.cs.wisc.edu/~dbbook/openAccess/thirdEdition/qbe.pdf
Query by Example, http://en.wikipedia.org/wiki/Query_by_Example
Muller, H., Michoux, N., Bandon, D., Geissbuhler, A.: A Review of Content_based Image Retrieval Systems in Medical Application - Clinical Benefits and Future Directions. Int. J. Med. Inform. 73 (2004)
Khoshafian, S., Baker, A.B.: Multimedia and Imaging Databases. Morgan Kaufmann Publishers, Inc., San Francisco (1996)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2009 Springer-Verlag Berlin Heidelberg
About this chapter
Cite this chapter
Spahiu, C.S., Stanescu, L., Burdescu, D., Brezovan, M. (2009). Visual Interface for Content-based Query in Image Databases. In: Damiani, E., Jeong, J., Howlett, R.J., Jain, L.C. (eds) New Directions in Intelligent Interactive Multimedia Systems and Services - 2. Studies in Computational Intelligence, vol 226. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-02937-0_21
Download citation
DOI: https://doi.org/10.1007/978-3-642-02937-0_21
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-02936-3
Online ISBN: 978-3-642-02937-0
eBook Packages: EngineeringEngineering (R0)