scholarly journals A Novel Solution for the Aggregation Problem in Natural Language Interface to Databases (NLIDB)

2020 ◽  
Author(s):  
Alexandre Ferreira Novello ◽  
Marco Antonio Casanova

Natural Language Interface to Databases (NLIDB) systems usually do not deal with aggregations, which can be of two types: aggregation functions (such as count, sum, average, minimum, and maximum) and grouping functions (GROUP BY). This paper addresses the creation of a generic module, to be used in NLIDB systems, that allows such systems to perform queries with aggregations, on the condition that the query results the NLIDB returns are or can be transformed into tables. The paper covers aggregations with specificities, such as ambiguities, timescale differences, aggregations in multiple attributes, the use of superlative adjectives, basic unit measure recognition, and aggregations in attributes with compound names.

2021 ◽  
Vol 12 (5) ◽  
Author(s):  
Alexandre F. Novello ◽  
Marco A. Casanova

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.


2021 ◽  
Author(s):  
Marjolein Deryck ◽  
Nuno Comenda ◽  
Bart Coppens ◽  
Joost Vennekens

This paper presents an application that we developed to assist users with the creation of an investment profile for the selection of financial assets. It consists of a natural language interface, an automatic translation to a declarative FO(.) knowledge base, and the IDP reasoning engine with multiple forms of logical inference. The application speeds up the investment profile creation process, and reduces the considerable inherent operational risk linked to the creation of investment profiles


2020 ◽  
Vol 56 (07) ◽  
pp. 40-46
Author(s):  
Khayala Mugamat Mursaliyeva ◽  

The explosion of information and the ever-increasing number of international languages make the modern language situation very difficult. The interaction of languages ultimately leads to the creation of international artificial languages that operate in parallel with the world`s languages. The expansion of interlinguistic issues is a natural consequence of the aggravation of the linguistic landscape of the modern world. The modern interlinguistic dialect, which is defined as a field of linguistics that studies international languages and international languages as a means of communication, deals with the importance of overcoming the barrier.The problem of international artificial languages is widely covered in the writings of I.A.Baudouin de Courtenay, V.P.Qrigorev, N.L.Gudskov, E.K.Drezen, A.D.Dulchenko, M.I.Isayev, S.N.Kuznechov, A.D.Melnikov and many other scientists. Key words:the concept of natural language, the concept of artificial language, the degree of artificiality of language, the authenticity of language


Sign in / Sign up

Export Citation Format

Share Document