Skip to main content

SQL/MM Part 5: Still Image -The Standard and Implementation Aspects -

  • Conference paper

Part of the book series: Informatik aktuell ((INFORMAT))

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

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   54.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   69.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Corbis Corporation. Corbis-The Place for Pictures on the Internet, 2000. http://www.corbis.com/.

  2. Heidelberg CPS. Color Manager Manual, 1998. http://www.linocolor.com/colorman/colorman_frames.htm.

  3. W. Equitz. Using Texture for Query by Image Content (QBIC). Research report, IBM Almadén Research Center, San Jose, CA, 1993.

    Google Scholar 

  4. ERDAS. Arc View Image Analysis Extension. White Paper, 1998. http://www.erdas.com/.

  5. 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.

    Article  Google Scholar 

  6. IBM Corporation. DB2 Universal Database Image, Audio, and Video Extenders-Administration and Programming, Version 7, 2000.

    Google Scholar 

  7. IBM Corporation. DB2 Universal Database Spatial Extender-Administration and Programming, Version 7, 2000.

    Google Scholar 

  8. IBM Corporation. DB2 Universal Database Text Extender-Administration and Programming, Version 7, 2000.

    Google Scholar 

  9. IBM Corporation. DB2 Universal Database Version 7: SQL Reference, 2000.

    Google Scholar 

  10. Informix Corporation. Excalibur Image DataBlade Module—User’s Guide, 1999.

    Google Scholar 

  11. ISO/IEC IS 10918-1:1994. Digital Compression and Coding of Continuous-tone Still Images: Requirements and Guidelines, February 1994. J. Mitchell, editor.

    Google Scholar 

  12. 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.

    Google Scholar 

  13. ISO/IEC IS 9075-2:1999. Information Technology-Database Language SQL-Part 2: Foundation (SQL/Foundation), July 1999. J. Melton, editor.

    Google Scholar 

  14. 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.

    Google Scholar 

  15. ISO/IEC FDIS 9075-9:2000. Information Technology—Database Languages SQL-Part 9: SQUMED, September 2000. J. Melton, editor.

    Google Scholar 

  16. Adobe Systems Incorporated and E. Taft. Postscript Language Reference Manual. Addison-Wesley, Reading, MA, 2nd edition, 1990.

    Google Scholar 

  17. 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.

    Google Scholar 

  18. magick@wizards.dupont.com. ImageMagick, 2000. http://www.imagemagick.org/.

  19. Microsoft Corporation. Microsoft SQL Server-Textual Searches on Database Data Using Microsoft SQL Server 7.0, 1998.

    Google Scholar 

  20. J. D. Murray and W. vanRyper. Graphics File Formats. O’Reilly&Associates, Inc., Bonn, Cambridge, 2nd edition, 1996.

    Google Scholar 

  21. 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.

    Article  Google Scholar 

  22. National Aeronautics and Space Administration (NASA). AILS-Ames Imaging Library Server, 2000. http://ails.arc.nasa.gov/.

  23. 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.

    Google Scholar 

  24. A. N. Netravali and B. G. Haskell. Digital Pictures, Representation and Compression. Plenum, New York, 1988.

    Google Scholar 

  25. 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.

    Google Scholar 

  26. Oracle Corporation. OracleSi Visual Information Retrieval-User’s Guide and Reference, 1999.

    Google Scholar 

  27. C. M. Saracco. Universal Database Management-A Guide to Object/Relational Technology. Morgan Kaufmann, San Francisco, CA, 1998.

    Google Scholar 

  28. K. Stolze. SQL/MM Part 5: Still Image—An Introduction. Datenbank Rundbrief, (25), 2000.

    Google Scholar 

  29. K. Stolze. Still Image Extensions in Database Systems-A Product Overview. 2001. in preparation.

    Google Scholar 

  30. 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.

    Google Scholar 

  31. 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.

    Google Scholar 

  32. University of Stuttgart, Germany. Stuttgart Picture Archive, 1995. http://www.uni-Stuttgart.de/External/picinfo/.

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints 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

Publish with us

Policies and ethics