Comparing Oracle and PostgreSQL, Performance and Optimization

Martins, Pedro; Tomé, Paulo; Wanzeller, Cristina; Sá, Filipe; Abbasi, Maryam

doi:10.1007/978-3-030-72651-5_46

Cited by 4 publications

(1 citation statement)

References 12 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Taking the same input, i.e., a query statement, the latter uses the query plan tree [21] generated by the optimizer of a DBMS to estimate the query cardinality. It is worth noting that this method does not require the execution of query statements in the database and is efficient, as DBMS uses traditional estimation methods to obtain plans [22]. Although these plans may be suboptimal, we can use the information embedded in them for cardinality estimation.…”

Section: Introductionmentioning

confidence: 99%

Efficient Cardinality and Cost Estimation with Bidirectional Compressor-based Ensemble Learning

Liang,

Chen,

Zhao

et al. 2023

2023 IEEE International Conference on Data Mining (ICDM)

View full text Add to dashboard Cite

Query optimization is of great importance for the performance of a database, in which cardinality and cost estimation have a pivotal role. To enable accurate cardinality and cost estimation, we propose a novel framework based on bidirectional compressor and ensemble networks called BICE. In particular, we design a feature extractor composed of four sub-encoders, which can extract various types of information in a query plan tree and hybrid learning strategies for encoding. We encode joins based on a graph embedding method and design parallel networks for filters to improve the encoding efficiency. Then we propose a bidirectional LSTM-based compressor to learn the encoding and obtain fixed-length vectors, reducing the learning difficulty of the estimation model. Finally, we propose different data sampling strategies based on Bayesian neural networks and active learning, and an ensemble model is established based on transfer learning, which enables accurate estimation and adaptation to large-scale data queries. Extensive experiments offer insight into the effectiveness and efficiency of the proposed framework.

show abstract

Section: Introductionmentioning

confidence: 99%