Results 181 to 190 of about 327,421 (217)
A multi-dimensional semantic pseudo-relevance feedback framework for information retrieval. [PDF]
Sci RepPan M +4 more
europepmc +1 more source
A Systematic Review of Event-Matching Methods for Complex Event Detection in Video Streams. [PDF]
Sensors (Basel)Honarparvar S +3 more
europepmc +1 more source
Large Language Model-Based Critical Care Big Data Deployment and Extraction: Descriptive Analysis.
JMIR Med InformYang Z +11 more
europepmc +1 more source
Bringing order to query optimization [PDF]
ACM 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 ...
Slivinskas, G. +2 more
openaire +3 more sources
Some of the next articles are maybe not open access.
Related searches:
Related searches:
ACM SIGMOD Record, 1994
We present a framework which allows the user to access and manipulate data uniformly, regardless of whether it resides in a database or in the file system (or in both). A key issue is the performance of the system. We show that text indexing, combined with newly developed optimization techniques, can be used to provide an efficient high level interface
Tova Milo, Mariano P. Consens
openaire +2 more sources
We present a framework which allows the user to access and manipulate data uniformly, regardless of whether it resides in a database or in the file system (or in both). A key issue is the performance of the system. We show that text indexing, combined with newly developed optimization techniques, can be used to provide an efficient high level interface
Tova Milo, Mariano P. Consens
openaire +2 more sources
The Vertica Query Optimizer: The case for specialized query optimizers
2014 IEEE 30th International Conference on Data Engineering, 2014The Vertica SQL Query Optimizer was written from the ground up for the Vertica Analytic Database. Its design and the tradeoffs we encountered during its implementation argue that the full power of novel database systems can only be realized with a carefully crafted custom Query Optimizer written specifically for the system in which it operates.
Jaimin Mukesh Dave +4 more
openaire +2 more sources
An architecture for query optimization
Proceedings of the 1982 ACM SIGMOD international conference on Management of data - SIGMOD '82, 1982We 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 ...
David Reiner, Arnon Rosenthal
openaire +2 more sources
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.
Sundararajarao Sudarshan, Prasan Roy
openaire +1 more source
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.
Sundararajarao Sudarshan, Prasan Roy
openaire +1 more source
ACM SIGMOD Record, 1996
The strength of commercial query optimizers like DB2 comes from their ability to select an optimal order by generating all equivalent reorderings of binary operators. However, there are no known methods to generate all equivalent reorderings for a SQL query containing joins, outer joins, and groupby aggregations.
Bala Iyer, Piyush Goel
openaire +3 more sources
The strength of commercial query optimizers like DB2 comes from their ability to select an optimal order by generating all equivalent reorderings of binary operators. However, there are no known methods to generate all equivalent reorderings for a SQL query containing joins, outer joins, and groupby aggregations.
Bala Iyer, Piyush Goel
openaire +3 more sources
Query scheduling in multi query optimization
Proceedings 2001 International Database Engineering and Applications Symposium, 2002Complex queries are becoming commonplace, with the growing use of decision support systems. Decision support queries often have a lot of common sub-expressions within each query, and queries are often run as a batch. Multi query optimization aims at exploiting common sub-expressions, to reduce the evaluation cost of queries, by computing them once and ...
Sundar Vishwanathan +2 more
openaire +2 more sources