A review of CUDA optimization techniques and tools for structured grid computing

Al-Mouhamed, Mayez; Khan, Ayaz ul Hassan; Mohammad, Nazeeruddin

doi:10.1007/s00607-019-00744-1

Cited by 3 publications

(1 citation statement)

References 34 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…We use PyTorch [32] as the basic framework for deep learning, and the model is trained on CUDA [33]. All experiments are conducted on a machine with AMD CPU R7‐5800X, 32GB Memory, 64G SSD, GeForce RTX 3090 with 24GB and CentOS 6.5 operating system.…”

Section: Methodsmentioning

confidence: 99%

A BiLSTM cardinality estimator in complex database systems based on attention mechanism

Zhou

Yang

Song

et al. 2021

CAAI Trans on Intel Tech

View full text Add to dashboard Cite

An excellent cardinality estimation can make the query optimiser produce a good execution plan. Although there are some studies on cardinality estimation, the prediction results of existing cardinality estimators are inaccurate and the query efficiency cannot be guaranteed as well. In particular, they are difficult to accurately obtain the complex relationships between multiple tables in complex database systems. When dealing with complex queries, the existing cardinality estimators cannot achieve good results. In this study, a novel cardinality estimator is proposed. It uses the core techniques with the BiLSTM network structure and adds the attention mechanism. First, the columns involved in the query statements in the training set are sampled and compressed into bitmaps. Then, the Word2vec model is used to embed the word vectors about the query statements. Finally, the BiLSTM network and attention mechanism are employed to deal with word vectors. The proposed model takes into consideration not only the correlation between tables but also the processing of complex predicates. Extensive experiments and the evaluation of BiLSTM-Attention Cardinality Estimator (BACE) on the IMDB datasets are conducted. The results show that the deep learning model can significantly improve the quality of cardinality estimation, which is a vital role in query optimisation for complex databases.

show abstract

Section: Methodsmentioning

confidence: 99%