Please use this identifier to cite or link to this item:
Title: Deep learning supported database systems (part 1)
Authors: Zhang, Yuhan
Keywords: Engineering::Computer science and engineering::Information systems::Database management
Engineering::Computer science and engineering::Computing methodologies::Image processing and computer vision
Issue Date: 2022
Publisher: Nanyang Technological University
Source: Zhang, Y. (2022). Deep learning supported database systems (part 1). Final Year Project (FYP), Nanyang Technological University, Singapore.
Project: SCSE20-0479
Abstract: In recent years, cardinality estimation in query optimization has been a popular area of research. With better estimation techniques, query optimizers can produce more efficient query plans that are able to directly impact the performance of Database Management Systems (DBMS). In this project, we will be extracting features from the text-based query plans of 5000 random queries on the IMDB dataset. Each of these query plans were generated by PostgreSQL, a widely used DBMS. Subsequently, we will map the extracted features to an RGB image format that can be fed as inputs into a shallow convolutional neural network (CNN). The model is tasked with a regression problem that aims to predict the actual execution time or rows returned by each query. Finally, the outputs of the model will be compared with the outputs generated by the PostgreSQL estimator.
Schools: School of Computer Science and Engineering 
Fulltext Permission: restricted
Fulltext Availability: With Fulltext
Appears in Collections:SCSE Student Reports (FYP/IA/PA/PI)

Files in This Item:
File Description SizeFormat 
  Restricted Access
871.18 kBAdobe PDFView/Open

Page view(s)

Updated on Sep 23, 2023

Download(s) 50

Updated on Sep 23, 2023

Google ScholarTM


Items in DR-NTU are protected by copyright, with all rights reserved, unless otherwise indicated.