Open AccessEmpowering Natural Language Interfaces to Databases with Aggregations
Author(s) -
Alexandre Novello,
Marco A. Casanova
Publication year - 2021
Publication title -
journal of information and data management
Language(s) - English
Resource type - Journals
ISSN - 2178-7107
DOI - 10.5753/jidm.2021.1908
Subject(s) - computer science , superlative , interface (matter) , natural language , database , natural language user interface , relational database , natural (archaeology) , natural language processing , information retrieval , artificial intelligence , linguistics , geography , philosophy , archaeology , bubble , maximum bubble pressure method , parallel computing
A Natural Language Interface to Database (NLIDB) refers to a database interface that translates a question asked in natural language into a structured query. Aggregation questions express aggregation functions, such as count, sum, average, minimum and maximum, and optionally a group by clause and a having clause. NLIDBs deliver good results for standard questions but usually do not deal with aggregation questions. The main contribution of this article is a generic module, called GLAMORISE (GeneraL Aggregation MOdule using a RelatIonal databaSE), that extends NLIDBs to cope with aggregation questions. GLAMORISE covers aggregations with ambiguities, timescale differences, aggregations in multiple attributes, the use of superlative adjectives, basic recognition of measurement units, and aggregations in attributes with compound names.