Optimizing queries over multimedia repositories
- 1 June 1996
- journal article
- Published by Association for Computing Machinery (ACM) in ACM SIGMOD Record
- Vol. 25 (2) , 91-102
- https://doi.org/10.1145/235968.233323
Abstract
Repositories of multimedia objects having multiple types of attributes (e.g., image, text) are becoming increasingly common. A selection on these attributes will typically produce not just a set of objects, as in the traditional relational query model ( filtering ), but also a grade of match associated with each object, indicating how well the object matches the selection condition ( ranking ). Also, multimedia repositories may allow access to the attributes of each object only through indexes. We investigate how to optimize the processing of queries over multimedia repositories. A key issue is the choice of the indexes used to search the repository. We define an execution space that is search-minimal, i.e., the set of indexes searched is minimal. Although the general problem of picking an optimal plan in the search-minimal execution space is NP-hard, we solve the problem efficiently when the predicates in the query are independent. We also show that the problem of optimizing queries that ask for a few top-ranked objects can be viewed, in many cases, as that of evaluating selection conditions. Thus, both problems can be viewed together as an extended filtering problem.Keywords
This publication has 14 references indexed in Scilit:
- Nearest neighbor queriesPublished by Association for Computing Machinery (ACM) ,1995
- Optimizing disjunctive queries with expensive predicatesACM SIGMOD Record, 1994
- Beyond uniformity and independencePublished by Association for Computing Machinery (ACM) ,1994
- QBIC project: querying images by content, using color, texture, and shapePublished by SPIE-Intl Soc Optical Eng ,1993
- Extensible database management systemsACM SIGMOD Record, 1990
- On the optimal nesting order for computing N -relational joinsACM Transactions on Database Systems, 1984
- R-treesPublished by Association for Computing Machinery (ACM) ,1984
- An architecture for query optimizationPublished by Association for Computing Machinery (ACM) ,1982
- On searching transposed filesACM Transactions on Database Systems, 1979
- Access path selection in a relational database management systemPublished by Association for Computing Machinery (ACM) ,1979