Translation of spanish statistics expressions to SQL
Ismael Esquivel Gámez, María de los Ángeles Marrujo, Omar Pérez García · Research in Computing Science · 2010
Grouping and aggregate data to obtain summarized values from a database is one of the most representative ways of generating information through a computer system. End users when requesting reports of this nature incorporate statistical expressions as total, subtotal, suma, promedio, maximo, minimo, etc. (total, subtotal, sum, average, maximum, minimum, less, more, etc.), like in: ?Cual es el total de salarios pagados a los disenadores? (What is the total wages paid to designers?). This paper presents a system for recognizing the statistics expressions in Spanish, found in natural language queries made to a database and converting them to SQL. It is a module of a natural language interface to database (NLIDB), still developing. The system handles three types of typical Spanish queries involving statistical expressions.