Results 301 to 310 of about 4,465,122 (351)
Some of the next articles are maybe not open access.
Making Learned Query Optimization Practical
SIGMOD record, 2022Query optimization has been a challenging problem ever since the relational data model had been proposed. The role of the query optimizer in a database system is to compute an execution plan for a (relational) query expression comprised of physical ...
V. Markl
semanticscholar +1 more source
Designing an Open Framework for Query Optimization and Compilation
Proceedings of the VLDB Endowment, 2022Since its invention, data-centric code generation has been adopted for query compilation by various database systems in academia and industry. These database systems are fast but maximize performance at the expense of developer friendliness, flexibility,
Michael Jungmair +2 more
semanticscholar +1 more source
FiGO: Fine-Grained Query Optimization in Video Analytics
SIGMOD Conference, 2022Video database management systems (VDBMSs) enable automated analysis of videos at scale using computationally-intensive deep learning models. To reduce the computational overhead of these models, researchers have proposed two techniques: (1) leveraging a
Jiashen Cao +4 more
semanticscholar +1 more source
Applicability of Quantum Computing on Database Query Optimization
SIGMOD Conference, 2022We evaluate the applicability of quantum computing on two fundamental query optimization problems, join order optimization and multi query optimization (MQO).
Manuel Schönberger
semanticscholar +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
Bitvector-aware Query Optimization for Decision Support Queries
SIGMOD Conference, 2020Bitvector filtering is an important query processing technique that can significantly reduce the cost of execution, especially for complex decision support queries with multiple joins.
B. Ding +2 more
semanticscholar +1 more source
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
Concurrency and Computation, 2019
As the main factor in the distributed database systems, query optimization is aimed at finding an optimal execution plan to reduce the runtime.
V. Panahi, Nima Jafari Navimipour
semanticscholar +1 more source
As the main factor in the distributed database systems, query optimization is aimed at finding an optimal execution plan to reduce the runtime.
V. Panahi, Nima Jafari Navimipour
semanticscholar +1 more source