Please use this identifier to cite or link to this item: http://scholarbank.nus.edu.sg/handle/10635/135468
Title: QUERY FROM EXAMPLES
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.
URI: http://scholarbank.nus.edu.sg/handle/10635/135468
Appears in Collections:Ph.D Theses (Open)

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

OPEN

NoneView/Download

Page view(s)

54
checked on Dec 14, 2018

Download(s)

37
checked on Dec 14, 2018

Google ScholarTM

Check


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