Extending SQL3 for query language of object-relational multimedia databases

Michael Junke Hu; Miao Chunyan

doi:10.1117/12.321932

16 September 1998 Extending SQL3 for query language of object-relational multimedia databases

Michael Junke Hu, Miao Chunyan

Proceedings Volume 3408, Broadband European Networks and Multimedia Services; (1998) https://doi.org/10.1117/12.321932
Event: SYBEN-Broadband European Networks and Electronic Image Capture and Publishing, 1998, Zurich, Switzerland

Abstract

We have been designing and implementing an object-relational multimedia database. A new data model was first developed, which represents various types of media entities, and temporal/logical relationships among these entities. Thereafter, a three-layer object-relational database infrastructure was proposed in our project, in order to support the proposed data model. In this paper, we concentrate on the search and query mechanisms designated for our database infrastructure. In particular, we discuss a new query language, which is developed as a multimedia extension of SQL3. This query language provides a greater expressive power, not only on simple/complex media entities, but also on various relationships among different entities. Consequently, it supports both content-based and structure-based queries. We are currently implementing the query language in our object- relational multimedia database prototype system based on the Illustrar. The fundamental structure of our query language, as well as main features of Object Manager and Query Manager of our prototype system, are also presented in the paper.

Citation Download Citation

Michael Junke Hu and Miao Chunyan "Extending SQL3 for query language of object-relational multimedia databases", Proc. SPIE 3408, Broadband European Networks and Multimedia Services, (16 September 1998); https://doi.org/10.1117/12.321932

ACCESS THE FULL ARTICLE

INSTITUTIONAL
Select your institution to access the SPIE Digital Library.

SELECT YOUR INSTITUTION

PERSONAL
Sign in with your SPIE account to access your personal subscriptions or to use specific features such as save to my library, sign up for alerts, save searches, etc.

PERSONAL SIGN IN

No SPIE Account? Create one

PURCHASE THIS CONTENT

SUBSCRIBE TO DIGITAL LIBRARY

50 downloads per 1-year subscription

Members: $195

Non-members: $335 ADD TO CART

25 downloads per 1 - year subscription

Members: $145

Non-members: $250 ADD TO CART

PURCHASE SINGLE ARTICLE

Includes PDF, HTML & Video, when available