Multi-criteria query optimization in the presence of result size and quality tradeoffs

Lakshmi Priya Mahalingam, Kasim Candan

Research output: Contribution to journalArticle

3 Citations (Scopus)

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.

Original languageEnglish (US)
Pages (from-to)167-183
Number of pages17
JournalMultimedia Tools and Applications
Volume23
Issue number3
DOIs
StatePublished - Aug 2004

Fingerprint

Multicriteria Optimization
Query Optimization
Trade-offs
Query
Predicate
Histogram
Data Distribution
Granularity
Optimization Model
Imperfect
Search Space
Optimization Techniques
Multimedia
NP-complete problem
Optimization Problem
Optimization

Keywords

  • Multi-criteria optimization
  • Multimedia databases
  • Quality-based optimization
  • Query optimization
  • Similarity-based optimization
  • Top-k retrieval

ASJC Scopus subject areas

  • Electrical and Electronic Engineering
  • Information Systems
  • Computer Graphics and Computer-Aided Design
  • Software
  • Theoretical Computer Science
  • Computational Theory and Mathematics

Cite this

Multi-criteria query optimization in the presence of result size and quality tradeoffs. / Mahalingam, Lakshmi Priya; Candan, Kasim.

In: Multimedia Tools and Applications, Vol. 23, No. 3, 08.2004, p. 167-183.

Research output: Contribution to journalArticle

@article{24b1ff1680cf4e2ab946c54fb377b91b,
title = "Multi-criteria query optimization in the presence of result size and quality tradeoffs",
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.",
keywords = "Multi-criteria optimization, Multimedia databases, Quality-based optimization, Query optimization, Similarity-based optimization, Top-k retrieval",
author = "Mahalingam, {Lakshmi Priya} and Kasim Candan",
year = "2004",
month = "8",
doi = "10.1023/B:MTAP.0000031755.50716.2a",
language = "English (US)",
volume = "23",
pages = "167--183",
journal = "Multimedia Tools and Applications",
issn = "1380-7501",
publisher = "Springer Netherlands",
number = "3",

}

TY - JOUR

T1 - Multi-criteria query optimization in the presence of result size and quality tradeoffs

AU - Mahalingam, Lakshmi Priya

AU - Candan, Kasim

PY - 2004/8

Y1 - 2004/8

N2 - 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.

AB - 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.

KW - Multi-criteria optimization

KW - Multimedia databases

KW - Quality-based optimization

KW - Query optimization

KW - Similarity-based optimization

KW - Top-k retrieval

UR - http://www.scopus.com/inward/record.url?scp=3042748460&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=3042748460&partnerID=8YFLogxK

U2 - 10.1023/B:MTAP.0000031755.50716.2a

DO - 10.1023/B:MTAP.0000031755.50716.2a

M3 - Article

AN - SCOPUS:3042748460

VL - 23

SP - 167

EP - 183

JO - Multimedia Tools and Applications

JF - Multimedia Tools and Applications

SN - 1380-7501

IS - 3

ER -