Optimizing relational search with embedded neural network
dc.contributor.advisor | Pu, Ken | |
dc.contributor.author | Ma, Limin | |
dc.date.accessioned | 2023-04-24T14:50:11Z | |
dc.date.available | 2023-04-24T14:50:11Z | |
dc.date.issued | 2023-04-01 | |
dc.identifier.uri | https://hdl.handle.net/10155/1595 | |
dc.description.abstract | Our research focuses on a novel method to query relational data. We propose the partial tuple search problem where a user can utilize keyword search to explore complex relational datasets. The challenge of evaluation of partial tuple queries is the performance bottleneck of fuzzy string matching using traditional full-text index structures. We propose a solution to overcome the bottleneck by incorporating horizontally partitioned full-text indexes and an embeddable neural network classifier in the query processing pipeline. The classifier is trained with self-supervision. It learns to optimize the partitioned indexes access pattern to accelerate query performance. Using textual features of user queries, the classifier infers the index access pattern so that fuzzy string matching subqueries are efficiently evaluated. We studied various network architectures and evaluated them against real-world datasets. Our experimental evaluation demonstrates that neural networks successfully learned how to optimize index access patterns for this use case. | en |
dc.description.sponsorship | University of Ontario Institute of Technology | en |
dc.language.iso | en | en |
dc.subject | Neural network | en |
dc.subject | Relational database | en |
dc.subject | Keyword search | en |
dc.subject | Optimization | en |
dc.title | Optimizing relational search with embedded neural network | en |
dc.type | Thesis | en |
dc.degree.level | Master of Science (MSc) | en |
dc.degree.discipline | Computer Science | en |
Files in this item
This item appears in the following Collection(s)
-
Electronic Theses and Dissertations [1478]
Electronic Theses and Dissertations -
Master Theses & Projects [326]
Master Theses & Projects (FSCI)