Results 1 to 10 of about 4,692,588 (180)
Efficient and Provable Multi-Query Optimization [PDF]
ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems, 2017 Complex queries for massive data analysis jobs have become increasingly commonplace. Many such queries contain com- mon subexpressions, either within a single query or among multiple queries submitted as a batch.
Kathuria, Tarun, Sudarshan, S.
core +2 more sources
Neo: A Learned Query Optimizer [PDF]
Proceedings of the VLDB Endowment, 2019 Query optimization is one of the most challenging problems in database systems. Despite the progress made over the past decades, query optimizers remain extremely complex components that require a great deal of hand-tuning for specific workloads and ...
Alizadeh, Mohammad +7 more
core +2 more sources
Sampling-Based Query Re-Optimization [PDF]
SIGMOD Conference, 2016 Despite of decades of work, query optimizers still make mistakes on "difficult" queries because of bad cardinality estimates, often due to the interaction of multiple predicates and correlations in the data.
Bruno N. +5 more
core +2 more sources
DISTRIBUTED QUERY OPTIMIZATION [PDF]
Analele Universităţii Constantin Brâncuşi din Târgu Jiu : Seria Economie, 2010 The need for the distributed systems has been determined by the type of business developed by companies with offices geographically distributed where the specific organizational structure promotes a decentralized business model.
Nicoleta IACOB
doaj +2 more sources
Kepler: Robust Learning for Parametric Query Optimization [PDF]
Proc. ACM Manag. Data, 2023 Most existing parametric query optimization (PQO) techniques rely on traditional query optimizer cost models, which are often inaccurate and result in suboptimal query performance.
Lyric Doshi +7 more
semanticscholar +1 more source
Graph Query Processing Technology Based on Data Warehouse [PDF]
Jisuanji gongcheng, 2023 The maturity of technologies such as vectorization provides an opportunity to realize graph queries based on a data warehouse.However, the existing system does not consider the characteristics of columnar storage and queries and fails to efficiently ...
Jiading GUO, Peng WANG
doaj +1 more source
Answering Complex Logical Queries on Knowledge Graphs via Query Computation Tree Optimization [PDF]
International Conference on Machine Learning, 2022 Answering complex logical queries on incomplete knowledge graphs is a challenging task, and has been widely studied. Embedding-based methods require training on complex queries, and cannot generalize well to out-of-distribution query structures.
Yushi Bai, Xin Lv, Juanzi Li, Lei Hou
semanticscholar +1 more source
Bao: Making Learned Query Optimization Practical [PDF]
SIGMOD Conference, 2020 Recent efforts applying machine learning techniques to query optimization have shown few practical gains due to substantive training overhead, inability to adapt to changes, and poor tail performance.
Ryan Marcus +5 more
semanticscholar +1 more source
A technique for parallel query optimization using MapReduce framework and a semantic-based clustering method [PDF]
PeerJ Computer Science, 2021 Query optimization is the process of identifying the best Query Execution Plan (QEP). The query optimizer produces a close to optimal QEP for the given queries based on the minimum resource usage.
Elham Azhir +4 more
doaj +2 more sources
Data dependencies for query optimization: a survey
The VLDB journal, 2021 Effective query optimization is a core feature of any database management system. While most query optimization techniques make use of simple metadata, such as cardinalities and other basic statistics, other optimization techniques are based on more ...
Jan Kossmann +2 more
semanticscholar +1 more source