We discuss a new heuristic optimization concept for query evaluation. It is based on the idea of assigning an "optimization potential" as a special weighting factor expressing the quality to all transformation rules present in our term rewriting system. In this way, the idea is a refinement of existing proposals talking about "promise functions", "expected cost factors", and "rule selection". But as will be shown, our ordering of rules is justified in much more detail. The rule ordering is used to decide which rule has to be tried next during rewriting. Thus, minimizing the optimization effort of term rewriting is achieved by minimizing the matching effort. This is an optimization of an optimi...
Abstract. New algorithms for query modifications are proposed. These algorithms involve lexical opti...
Query optimization is of great importance for the performance of databases, especially for the execu...
Query optimization is a computationally intensive process, especially for the complex queries that a...
This report explains the implementation of an algorithm to optimize a QT with heuristic optimization...
Classic query optimization in relational database systems relies on phases (algebraic, physical, cos...
The emergence of very large database systems over the last two decades has raised serious needs for...
Semantic Query Optimisation (SQO) in Relational Database Management Systems (RDMSs) is a query optim...
Since the introduction of cost-based query optimization, the performance-critical role of interestin...
Since the introduction of cost-based query optimization, the performance-critical role of interestin...
Abstract-Almost all applications use database and Information Retrieval system for storing and retri...
Semantic Query Optimisation makes use of the semantic knowledge of a database (rules) to perform que...
This paper describes the Query Rewrite facility of the Starburst extensible database system, a novel...
The term quote semantic query optimization quote (SQO) denotes a methodology whereby queries against...
Relational databases provide the ability to store user-defined functions and predicates which can be...
Sort orders play an important role in query evaluation. Algorithms that rely on sorting are widely u...
Abstract. New algorithms for query modifications are proposed. These algorithms involve lexical opti...
Query optimization is of great importance for the performance of databases, especially for the execu...
Query optimization is a computationally intensive process, especially for the complex queries that a...
This report explains the implementation of an algorithm to optimize a QT with heuristic optimization...
Classic query optimization in relational database systems relies on phases (algebraic, physical, cos...
The emergence of very large database systems over the last two decades has raised serious needs for...
Semantic Query Optimisation (SQO) in Relational Database Management Systems (RDMSs) is a query optim...
Since the introduction of cost-based query optimization, the performance-critical role of interestin...
Since the introduction of cost-based query optimization, the performance-critical role of interestin...
Abstract-Almost all applications use database and Information Retrieval system for storing and retri...
Semantic Query Optimisation makes use of the semantic knowledge of a database (rules) to perform que...
This paper describes the Query Rewrite facility of the Starburst extensible database system, a novel...
The term quote semantic query optimization quote (SQO) denotes a methodology whereby queries against...
Relational databases provide the ability to store user-defined functions and predicates which can be...
Sort orders play an important role in query evaluation. Algorithms that rely on sorting are widely u...
Abstract. New algorithms for query modifications are proposed. These algorithms involve lexical opti...
Query optimization is of great importance for the performance of databases, especially for the execu...
Query optimization is a computationally intensive process, especially for the complex queries that a...