Abstract
In this paper, we present novel multi-criteria query optimization techniques for performing query optimization in databases, such as multimedia and web databases, which rely on imperfect access mechanisms and top-k predicates. We present an optimization model that (1) takes into account different binding patterns associated with query predicates, (2) considers the variations in the expected query result sizes as a function of query execution plans, and (3) considers the expected result qualities of the execution orders. We address the complexity and the well-known NP-complete nature of the query optimization problem by adaptively reducing the granularity of the search space. For this purpose, unlike the data histograms which capture the data distribution, we propose opt-histograms that capture the distribution of sub-query-plan values over many optimization tasks.
Similar content being viewed by others
References
K.S. Candan and W.-S. Li, “On similarity measures for multimedia database applications,” Knowledge and Information Systems, Vol. 3,No. 1, pp. 30–51, 2001.
K.S. Candan, W.-S. Li, and M.L. Priya, “Similarity-based ranking and query processing in multimedia databases,” DKE, Vol. 35,No. 3, pp. 259–298, 2000.
S. Chaudhuri, “An overview of query optimization in relational systems,” Principles of Database Systems, 1998.
S. Chaudhuri and L. Gravano, “Optimizing queries over multimedia repositories,” in SIGMOD 1996, Canada, June 1996, pp. 91–102.
S. Chaudhuri and L. Gravano, “Evaluating top-k selection queries,” in VLDB 1999, 1999, pp. 397–410.
S. Chaudhuri and K. Shim, “Optimization of queries with user-defined predicates,” in VLDB 96, Bombay, India, 1996, pp. 87–98.
D. Chimenti, R. Gamboa, and R. Krishnamurthy, “Towards on open architecture for LDL,” in VLDB 1989, 1989, pp. 195–203.
D. Donjerkovic and R. Ramakrishnan, “Probabilistic optimization of top n queries,” in VLDB 1999, 1999, pp. 411–422.
R. Fagin, “Combining fuzzy information from multiple systems,” in 15th ACM Symposium on Principles of Database Systems, June 1996, pp. 216–226.
R. Fagin, Fuzzy Queries in Multimedia Database Systems, Principles of Database Systems, Seattle, WA, 1998.
D. Florescu, A. Levy, D. Suciu, and I. Manolescu, “Query optimization in the presence of limited access patterns,” in ACM SIGMOD, 1999, pp. 311–322.
J.M. Hellerstein, “Optimization techniques for queries with expensive methods, association of computing machinery,” Transactions on Database Systems,” Vol. 23,No. 2, pp. 113–157, 1998.
L.P. Mahalingam and K.S. Candan, “Query optimization in the presence of top-k predicates,” Multimedia Inform. Systems Workshop, Capri, Italy, Nov. 2001.
Z. Nie and S. Kambhampati, “Joint optimization of cost and coverage of query plans in data integration,” in ACM CIKM, Atlanta, Georgia, Nov. 2001.
M. Ortega et al., “Supporting ranked Boolean similarity queries in MARS,” TKDE, Vol. 10,No. 6, pp. 905–925, 1998.
P.G. Selinger et al., “Access path selection in a relational database management system,” in SIGMOD 1979, 1979, pp. 23–34.
R. Yerneni, C. Li, J.D. Ullman, and H. Garcia-Molina, “Optimizing large join queries in mediation systems,” in ICDT, 1999, pp. 348–364.
V. Zadorozhny, L. Raschid, and M.E. Vidal. “Efficient evaluation of queries in a mediator for WebSources,” to be published in SIGMOD 2002.
Author information
Authors and Affiliations
Rights and permissions
About this article
Cite this article
Mahalingam, L.P., Candan, K.S. Multi-Criteria Query Optimization in the Presence of Result Size and Quality Tradeoffs. Multimedia Tools and Applications 23, 167–183 (2004). https://doi.org/10.1023/B:MTAP.0000031755.50716.2a
Issue Date:
DOI: https://doi.org/10.1023/B:MTAP.0000031755.50716.2a