Please use this identifier to cite or link to this item:
Authors: LI HAO
Keywords: Database usability, Query, Examples, SQL, Database searching, Data exploration
Issue Date: 30-Jun-2016
Citation: LI HAO (2016-06-30). QUERY FROM EXAMPLES. ScholarBank@NUS Repository.
Abstract: In today's era of Big Data, there is a lot of interest in do-it-yourself data exploration. However, expressing information needs using database systems often require writing queries in a formal language which is a challenging task for non-expert database users. This has motivated several recent research efforts to help database users with query construction. In this thesis, we aim to lower the barrier for data consumers to utilize database technology for data analysis by investigating an example-driven approach to help users with query construction. Our proposal does not require users to be familiar with any query language; instead, it only requires that the user is able to determine whether a given output table is the result of his or her intended query on a given input database. We propose two approaches to solve our example-driven method for query construction. The first approach is a query-based approach that leverages existing research on query reverse engineering to generate a set of candidate queries for iterative pruning with the user's feedback. The second approach is a schema-based approach that first identifies the target query schema via user feedback before pruning the candidate queries for the identified target query schema.
Appears in Collections:Ph.D Theses (Open)

Show full item record
Files in This Item:
File Description SizeFormatAccess SettingsVersion 
LH.pdf1.08 MBAdobe PDF



Page view(s)

checked on Nov 24, 2022


checked on Nov 24, 2022

Google ScholarTM


Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.