Abstract
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.
Similar content being viewed by others
References
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.
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.
C. Batini, S. Ceri, and S. Navathe, “Conceptual Database Design: An ER Approach,” Benjamin/Cummings, 1992.
D. Beech, “Collections of objects in SQL3,” in VLDB 93, 1993, pp. 244–255.
R. Cattel (Ed.), The Object Database Standard: ODMG—93, Release 1.2, Morgan Kaufman, 1996.
C.J. Date and H. Darwen, “The third manifesto,” ACM SIGMOD Record, Vol. 24, No. 1, 1995.
C. Faloutsos, Searching Multimedia Databases by Content, Kluwer Academic Publishers, 1996.
M. Flickner et al., “Queryby image and video content: The QBIC system,” IEEE Computer, Vol. 28, No. 9, pp. 23–32, 1995.
G. Gonzalez, “Intuitive querying in object oriented databases,” M.S Thesis, Department of Computer Science, University of Texas at El Paso, 1994.
Y. Ioannidis and Y. Lashkari, “Incomplete path expressions and their disambiguation,” in SIGMOD, 1994, pp. 138–149.
M. Kifer, G Lausen, and J. Wu, “Logical foundations of object-oriented and frame-based languages,” Journal of ACM, 1993, to appear.
F. Manola and J. Sutherland, SQL3, in ANSI X3H7 Object Model Features Matrix, http://info.gte.com/ftp/doc/activities/x3h7/bymodel/SQL3.html
S. Marcus and V.S. Subrahmanian, “Foundations of multimedia information systems,” JACM, May 1996.
J. Melton and A. Simon, Understanding the New SQL: A Complete Guide, Morgan Kaufman, 1992.
A. Mendelzon, G. Mihaila, and T. Milo, “Querying the world wide web,” Technical Report. Univ. of Toronto, 1996.
V. Ogle and M. Stonebraker,“Chabot: Retrieval from a relational database of images,” IEEE Computer, Vol. 28, No. 9, pp. 40–48, 1995.
P. Sistla, C. Yu, and R. Haddad, “Reasoning about spatial relationship in picture retrieval systems,” in VLDB 94, Santiago, Chile, 1994.
R. Srihari, “Automatic indexing and content-based retrieval of captioned images,” IEEE Computer, Vol. 28, No. 9, pp. 49–56, 1995.
M. Stonebraker, Object Relational DBMSs, Morgan Kaufmann, 1996.
J. Ullman, Principles of Database and Knowledge-Base Systems, Computer Science Press, Vol. 1, 1988.
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.
Drew Wade, SQL3/OQL Merger, May 1996. http://www.jcc.com/sql_odmg convergence.html
Author information
Authors and Affiliations
Rights and permissions
About this article
Cite this article
Baral, C., Gonzalez, G. & Son, T. Conceptual Modeling and Querying in Multimedia Databases. Multimedia Tools and Applications 7, 37–66 (1998). https://doi.org/10.1023/A:1009670119569
Issue Date:
DOI: https://doi.org/10.1023/A:1009670119569