Results 251 to 260 of about 2,495,219 (292)
Some of the next articles are maybe not open access.

Web query optimizer

Proceedings of 16th International Conference on Data Engineering (Cat. No.00CB37073), 2002
We demonstrate a Web Query Optimizer (WQO) within an architecture of mediators and wrappers, for WebSources of limited capability in a wide area environment. The WQO has several innovative features, including a CBR (capability based rewriting) tool, an enhanced randomized relational optimizer extended to a Web environment, and a WebWrapper cost model ...
Vladimir Zadorozhny   +4 more
openaire   +1 more source

Learned Query Optimizers

Foundations and Trends in Databases
This survey presents recent progress on using machine learning techniques to improve query optimizers in database systems. Centering around a generic paradigm of learned query optimizers, this survey covers several lines of effort on rebuilding or aiding important components in query optimizers (i.e., cardinality estimators, cost models, and plan ...
Bolin Ding, Rong Zhu, Jingren Zhou 0001
openaire   +3 more sources

Semantic query optimization for object queries

1995
Semantic query optimization is an approach to query optimization that utilizes semantic knowledge to reformulate a query into one that would generate the same set of answers in a more efficient way. The semantic query optimization becomes more important in OODB systems where object queries are complex due to the presence of object-oriented concepts ...
Young-Whun Lee, Suk I. Yoo
openaire   +1 more source

Parallelizing query optimization

Proceedings of the VLDB Endowment, 2008
Many commercial RDBMSs employ cost-based query optimization exploiting dynamic programming (DP) to efficiently generate the optimal query execution plan. However, optimization time increases rapidly for queries joining more than 10 tables.
Wook-Shin Han   +4 more
openaire   +2 more sources

Multi-Query Optimization

2009
Complex queries are becoming commonplace with the growing use of decision support systems. These complex queries often have a lot of common sub-expressions, either within a single query, or across multiple such queries. The focus of this work is to speed up query execution by exploiting these common subexpressions.
Prasan Roy, S. Sudarshan
openaire   +1 more source

Query Optimization for Database-Returning Queries

Proceedings of the ACM on Management of Data
Recently, the novel concept of database-returning SQL queries (DRQs) was introduced. Instead of a single, (potentially) denormalized result table, DRQs return an entire subdatabase with a single SQL query. This subdatabase represents a subset of the original database, reduced to the relations, tuples, and attributes that contribute
Simon Rink, Jens Dittrich
openaire   +2 more sources

Multiobjective query optimization

Proceedings of the twentieth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems, 2001
The optimization of queries in distributed database systems is known to be subject to delicate trade-offs. For example, the Mariposa database system allows users to specify a desired delay-cost tradeoff (that is, to supply a decreasing function u(d), specifying how much the user is willing to pay in order to receive the query results within time d ...
Christos H. Papadimitriou   +1 more
openaire   +1 more source

An architecture for query optimization

Proceedings of the 1982 ACM SIGMOD international conference on Management of data - SIGMOD '82, 1982
We describe an optimizer for relational queries to databases stored as flat files and Codasyl networks. We include sophisticated manipulations on a broad range of direct access structures (DAS's). To achieve this with minimum additional code, we allow operations like sort, scan, and join to apply to DAS's, and categorize indexes and other DAS's in ...
Arnon Rosenthal, David S. Reiner
openaire   +2 more sources

Optimization of schemaSQL queries

Proceedings 2001 International Database Engineering and Applications Symposium, 2002
We study the optimization of schemaSQL and schemaSQL-like languages. Our starting point is an extended relational algebra which can be used to implement schemaSQL and similar languages. We study transformation (rewrite) rules for the extended algebra which are used in a prototype cost-based optimizer for the rewriting of expressions into more efficient
Keir B. Davis, Fereidoon Sadri
openaire   +2 more sources

Bringing order to query optimization [PDF]

open access: possibleACM SIGMOD Record, 2002
A variety of developments combine to highlight the need for respecting order when manipulating relations. For example, new functionality is being added to SQL to support OLAP-style querying in which order is frequently an important aspect. The set- or multiset-based frameworks for query optimization that are currently being taught to database students ...
Giedrius Slivinskas   +2 more
openaire   +3 more sources

Home - About - Disclaimer - Privacy