Querying RDBMS using Natural Language

by Fei Li

Institution: University of Michigan
Year: 2017
Keywords: NLIDB; Natural Language Processing; Database Usability; Semantic Parsing; Computer Science; Engineering
Posted: 02/01/2018
Record ID: 2189449
Full text PDF: http://hdl.handle.net/2027.42/138709


It is often challenging to specify queries against a relational database since SQL requires its users to know the exact schema of the database, the roles of various entities in a query, and the precise join paths to be followed. On the other hand, keyword search is unable to express many desired query semantics. In the real world, people ask questions in natural language, such as English. Theoretically, natural language interfaces for databases (NLIDBs) have many advantages over other widely accepted query interfaces (keyword-based search, form-based interface, and visual query builder). For example, a typical NLIDB would enable naive users to specify complex, ad-hoc query intent without training. Not surprisingly, an NLIDB is regarded by many as the ultimate goal. Despite these advantages, in real world applications, NLIDBs have not been widely adopted. In this dissertation, we investigate the construction of NLIDBs, specifically from the following three aspects: A natural language query is inherently ambiguous and some ambiguities may be too hard for computers to resolve. Can a system collaborate with users to achieve satisfactory reliability without burdening the user too much? The interpretation process can be considered as a mapping from a natural language query to the correct point in the semantic coverage of the NLIDB. Can the mapping process get easier by carefully defining the semantic coverage? Can an NLIDB work when no training examples are available, collect the user behavior data as the training examples and improve itself from real usage? In this dissertation, we provide affirmative answers to the above questions in the form of new query mechanism designed, techniques provided and systems constructed.Advisors/Committee Members: Jagadish, Hosagrahar V (committee member), Mei, Qiaozhu (committee member), Cafarella, Michael John (committee member), Radev, Dragomir Radkov (committee member).