Results 1 to 10 of about 4,751,671 (372)
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
core +2 more sources
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
Query optimization for dynamic imputation [PDF]
Proceedings of the VLDB Endowment, 2017 Missing values are common in data analysis and present a usability challenge. Users are forced to pick between removing tuples with missing values or creating a cleaned version of their data by applying a relatively expensive imputation strategy. Our system, ImputeDB, incorporates imputation into a cost-based query optimizer, performing necessary ...
Cambronero, José +3 more
openaire +3 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
XPath Whole Query Optimization [PDF]
Proceedings of the VLDB Endowment, 2010 Previous work reports about SXSI, a fast XPath engine which executes tree automata over compressed XML indexes. Here, reasons are investigated why SXSI is so fast.
Maneth, Sebastian, Nguyen, Kim
core +3 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
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
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