Exploiting Access Pattern Characteristics for Join Reordering
With increasing main memory sizes, data processing has significantly shifted from
secondary storage to main memory. However, choosing a good join order is still very …
secondary storage to main memory. However, choosing a good join order is still very …
PostCENN: postgresql with machine learning models for cardinality estimation
In this demo, we present PostCENN, an enhanced PostgreSQL database system with an
end-to-end integration of machine learning (ML) models for cardinality estimation. In …
end-to-end integration of machine learning (ML) models for cardinality estimation. In …
Query cost estimation in graph databases via emphasizing query dependencies by using a neural reasoning network
With the increasing complexity of graph queries, query cost estimation has become a key
challenge in graph databases. Accurate estimation results are critical for database …
challenge in graph databases. Accurate estimation results are critical for database …
Using query semantic and feature transfer fusion to enhance cardinality estimating of property graph queries
Z He, T Gu, J Yu - Displays, 2024 - Elsevier
With the increasing complexity and diversity of query tasks, cardinality estimation has
become one of the most challenging problems in query optimization. In this study, we …
become one of the most challenging problems in query optimization. In this study, we …
PostBOUND: PostgreSQL with Upper Bound SPJ Query Optimization
A variety of query optimization papers have shown the disastrous effect of poor cardinality
estimates on the overall run time for arbitrary select-project-join (SPJ) queries. Especially …
estimates on the overall run time for arbitrary select-project-join (SPJ) queries. Especially …