Abstract
ISO/IEC 13249 SQL/MM is the effort to standardize SQL extensions. As the name suggests, this project focuses on multi media and application specific packages like text, spatial, and image together with extended search facilities for them. Part 1 is the framework, part 2 the full text standard, part 3 addresses spatial data, and part 5 still images. SQL extensions for data mining applications are handled in part 6. The withdrawn part 4 addressed general purpose facilities. This paper presents the upcoming ISO/IEC 13249-5 SQL/MM Part 5: Still Image standard [ISO00a], its features and functionality. The standard is also discussed critically. A prototypical implementation of the standard, based on IBM’s database system DB2 Universal Database Version 7.1, is presented. The prototype is designed with performance in mind and for standard conformance. Implications from this approach are described here.
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
Corbis Corporation. Corbis-The Place for Pictures on the Internet, 2000. http://www.corbis.com/.
Heidelberg CPS. Color Manager Manual, 1998. http://www.linocolor.com/colorman/colorman_frames.htm.
W. Equitz. Using Texture for Query by Image Content (QBIC). Research report, IBM Almadén Research Center, San Jose, CA, 1993.
ERDAS. Arc View Image Analysis Extension. White Paper, 1998. http://www.erdas.com/.
M. Flickner, H. S. Sawhney, J. Ashley, Q. Huang, B. Dom, M. Gorkani, J. Hafner, D. Lee, D. Petkovic, D. Steele, and P. Yanker. Query by Image and Video Content: The QBIC System. IEEE Computer, 28(9):23–32, 1995.
IBM Corporation. DB2 Universal Database Image, Audio, and Video Extenders-Administration and Programming, Version 7, 2000.
IBM Corporation. DB2 Universal Database Spatial Extender-Administration and Programming, Version 7, 2000.
IBM Corporation. DB2 Universal Database Text Extender-Administration and Programming, Version 7, 2000.
IBM Corporation. DB2 Universal Database Version 7: SQL Reference, 2000.
Informix Corporation. Excalibur Image DataBlade Module—User’s Guide, 1999.
ISO/IEC IS 10918-1:1994. Digital Compression and Coding of Continuous-tone Still Images: Requirements and Guidelines, February 1994. J. Mitchell, editor.
ISO/IEC FDIS 13249-2:1999 SQL/MM SAF-003-SP1. Information Technology-Database Languages SQL-Multimedia and Application Packages-Part 2: Full Text, August 1999. P. Cotton, editor.
ISO/IEC IS 9075-2:1999. Information Technology-Database Language SQL-Part 2: Foundation (SQL/Foundation), July 1999. J. Melton, editor.
ISO/IEC FDIS 13249-5:1999 SQL/MM. Information Technology-Database Languages SQL-Multimedia and Application Packages—Part 5: Still Image, September 2000. M. Ashworth, editor.
ISO/IEC FDIS 9075-9:2000. Information Technology—Database Languages SQL-Part 9: SQUMED, September 2000. J. Melton, editor.
Adobe Systems Incorporated and E. Taft. Postscript Language Reference Manual. Addison-Wesley, Reading, MA, 2nd edition, 1990.
W. Kießling, K. Erber-Urch, W.-T. Balke, T. Birke, and M. Wagner. The HERON Project-Multimedia Database Support for History and Human Sciences. In 28. Annual Conference of the German Computer Society (GI), pages 309–318. Springer Verlag, 1998.
magick@wizards.dupont.com. ImageMagick, 2000. http://www.imagemagick.org/.
Microsoft Corporation. Microsoft SQL Server-Textual Searches on Database Data Using Microsoft SQL Server 7.0, 1998.
J. D. Murray and W. vanRyper. Graphics File Formats. O’Reilly&Associates, Inc., Bonn, Cambridge, 2nd edition, 1996.
M. Miyahara and Y. Yoshida. Mathematical Transform of (RGB) Color Data to Munsell (HVC) Color Data. In Visual Communication and Image Processing, volume 1001, pages 650–657. SPIE, 1988.
National Aeronautics and Space Administration (NASA). AILS-Ames Imaging Library Server, 2000. http://ails.arc.nasa.gov/.
W. Niblack, R. Barber, W. Equitz, M. Flickner, E. Glasman, D. Petkovic, P. Yanker, G. Faloutsos, and G. Taubin. The QBIC Project: Querying Images By Content Using Color, Texture, and Shape. In W. Niblack, editor, SPIE I993, Proceedings SPIE Storage and Retrieval for Image and Video Databases, January 31-February 5, 1993, San Jose, CA, USA, volume 1908, pages 173–187. International Society for Optical Engineering, 1993.
A. N. Netravali and B. G. Haskell. Digital Pictures, Representation and Compression. Plenum, New York, 1988.
A. Natsev, R. Rastogi, and K. Shim. WALRUS: A Similarity Retrieval Algorithm for Image Databases. In A. Delis, C. Faloutsos, and S. Ghandeharizadeh, editors, SIGMOD 1999, Proceedings ACM SIGMOD International Conference on Management of Data, June 1-3, 1999, Philadephia, Pennsylvania, USA, pages 395–406. ACM Press, 1999.
Oracle Corporation. OracleSi Visual Information Retrieval-User’s Guide and Reference, 1999.
C. M. Saracco. Universal Database Management-A Guide to Object/Relational Technology. Morgan Kaufmann, San Francisco, CA, 1998.
K. Stolze. SQL/MM Part 5: Still Image—An Introduction. Datenbank Rundbrief, (25), 2000.
K. Stolze. Still Image Extensions in Database Systems-A Product Overview. 2001. in preparation.
G. Taubin and D. B. Cooper. Recognition and Positioning of Rigid Objects Using Algebraic Moment Invariants. In Geometric Methods on Computer Vision, volume 1570, pages 175–186. SPIE, International Society for Optical Engineering, 1991.
H. Tamura, S. Mori, and T. Yamawaki. Texture Features Corresponding to Visual Perception. In IEEE Transactions on Systems, Man, and Cybernetics, pages 460–473, 1978.
University of Stuttgart, Germany. Stuttgart Picture Archive, 1995. http://www.uni-Stuttgart.de/External/picinfo/.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2001 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Stolze, K. (2001). SQL/MM Part 5: Still Image -The Standard and Implementation Aspects -. In: Heuer, A., Leymann, F., Priebe, D. (eds) Datenbanksysteme in Büro, Technik und Wissenschaft. Informatik aktuell. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-56687-5_26
Download citation
DOI: https://doi.org/10.1007/978-3-642-56687-5_26
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-41707-1
Online ISBN: 978-3-642-56687-5
eBook Packages: Springer Book Archive