Multimedia Tools and Applications

, Volume 7, Issue 1–2, pp 37–66 | Cite as

Conceptual Modeling and Querying in Multimedia Databases

  • Chitta Baral
  • Graciela Gonzalez
  • Tran Son


In this paper, we discuss some design principles that will aid in the design and querying of multimedia databases. We use an object-relational data model and argue that multimedia objects should normally have a special attribute called ‘core’ which stores the real object itself in contrast to the abstraction which is reflected in the rest of the attributes. We present an extension to the ER Diagram that takes advantage of the ‘core’ notion to facilitate design of multimedia databases. We discuss some desirable features in a query language for multimedia databases: simplifications like the use of path expressions and implicit use of functions (methods) as attributes, and explicit specification of the display layout and format either at the data definition level or query specification level. To materialize this last feature, we propose a display specification extension to SQL (SQL+D) that we have implemented.

ER diagram multimedia database object relational data model modeling the WWW 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    F. Bancilhon and A. Carlson, “Providing rich query functionality—SQL3 discussion paper,” ISO/IEC JTC1/SC21/WG3 DBL LHR, ASC X3H2-95-462, Dec. 95.Google Scholar
  2. 2.
    C. Baal, G. Gonzalez, and T. Son, “A multimedia extension to SQL,” Technical Report, Dept. of Computer Sc., University of Texas at El Paso, 1997.Google Scholar
  3. 3.
    C. Batini, S. Ceri, and S. Navathe, “Conceptual Database Design: An ER Approach,” Benjamin/Cummings, 1992.Google Scholar
  4. 4.
    D. Beech, “Collections of objects in SQL3,” in VLDB 93, 1993, pp. 244–255.Google Scholar
  5. 5.
    R. Cattel (Ed.), The Object Database Standard: ODMG—93, Release 1.2, Morgan Kaufman, 1996.Google Scholar
  6. 6.
    C.J. Date and H. Darwen, “The third manifesto,” ACM SIGMOD Record, Vol. 24, No. 1, 1995.Google Scholar
  7. 7.
    C. Faloutsos, Searching Multimedia Databases by Content, Kluwer Academic Publishers, 1996.Google Scholar
  8. 8.
    M. Flickner et al., “Queryby image and video content: The QBIC system,” IEEE Computer, Vol. 28, No. 9, pp. 23–32, 1995.Google Scholar
  9. 9.
    G. Gonzalez, “Intuitive querying in object oriented databases,” M.S Thesis, Department of Computer Science, University of Texas at El Paso, 1994.Google Scholar
  10. 10.
    Y. Ioannidis and Y. Lashkari, “Incomplete path expressions and their disambiguation,” in SIGMOD, 1994, pp. 138–149.Google Scholar
  11. 11.
    M. Kifer, G Lausen, and J. Wu, “Logical foundations of object-oriented and frame-based languages,” Journal of ACM, 1993, to appear.Google Scholar
  12. 12.
    F. Manola and J. Sutherland, SQL3, in ANSI X3H7 Object Model Features Matrix, Scholar
  13. 13.
    S. Marcus and V.S. Subrahmanian, “Foundations of multimedia information systems,” JACM, May 1996.Google Scholar
  14. 14.
    J. Melton and A. Simon, Understanding the New SQL: A Complete Guide, Morgan Kaufman, 1992.Google Scholar
  15. 15.
    A. Mendelzon, G. Mihaila, and T. Milo, “Querying the world wide web,” Technical Report. Univ. of Toronto, 1996.Google Scholar
  16. 16.
    V. Ogle and M. Stonebraker,“Chabot: Retrieval from a relational database of images,” IEEE Computer, Vol. 28, No. 9, pp. 40–48, 1995.Google Scholar
  17. 17.
    P. Sistla, C. Yu, and R. Haddad, “Reasoning about spatial relationship in picture retrieval systems,” in VLDB 94, Santiago, Chile, 1994.Google Scholar
  18. 18.
    R. Srihari, “Automatic indexing and content-based retrieval of captioned images,” IEEE Computer, Vol. 28, No. 9, pp. 49–56, 1995.Google Scholar
  19. 19.
    M. Stonebraker, Object Relational DBMSs, Morgan Kaufmann, 1996.Google Scholar
  20. 20.
    J. Ullman, Principles of Database and Knowledge-Base Systems, Computer Science Press, Vol. 1, 1988.Google Scholar
  21. 21.
    J. Van den Bussche and G. Vossen, “An extension of path expressions to simplify navigation in object-oriented queries,” in Proc. Deductive and Object Oriented Databases, 1993, pp. 267–283.Google Scholar
  22. 22.
    Drew Wade, SQL3/OQL Merger, May 1996. convergence.htmlGoogle Scholar

Copyright information

© Kluwer Academic Publishers 1998

Authors and Affiliations

  • Chitta Baral
    • 1
  • Graciela Gonzalez
    • 2
  • Tran Son
    • 3
  1. 1.Department of Computer ScienceUniversity of Texas at El PasoEl PasoU.S.A
  2. 2.Department of Computer ScienceUniversity of Texas at El PasoEl PasoU.S.A
  3. 3.Department of Computer ScienceUniversity of Texas at El PasoEl PasoU.S.A

Personalised recommendations