Pragmatic approach to structured data querying via natural language interface

07/02/2018
by   Aliaksei Vertsel, et al.
0

As the use of technology increases and data analysis becomes integral in many businesses, the ability to quickly access and interpret data has become more important than ever. Information retrieval technologies are being utilized by organizations and companies to manage their information systems and processes. Despite information retrieval of a large amount of data being efficient organized in relational databases, a user still needs to master the DB language/schema to completely formulate the queries. This puts a burden on organizations and companies to hire employees that are proficient in DB languages/schemas to formulate queries. To reduce some of the burden on already overstretched data teams, many organizations are looking for tools that allow non-developers to query their databases. Unfortunately, writing a valid SQL query that answers the question a user is trying to ask isn't always easy. Even seemingly simple questions, like "Which start-up companies received more than 200M in funding?" can actually be very hard to answer, let alone convert into a SQL query. How do you define start-up companies? By size, location, duration of time they have been incorporated? This may be fine if a user is working with a database they're already familiar with, but what if users are not familiar with the database. What is needed is a centralized system that can effectively translate natural language queries into specific database queries for different customer database types. There is a number of factors that can dramatically affect the system architecture and the set of algorithms used to translate NL queries into a structured query representation.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
04/02/2018

An End-to-end Neural Natural Language Interface for Databases

The ability to extract insights from new data sets is critical for decis...
research
12/11/2009

Design of Intelligent layer for flexible querying in databases

Computer-based information technologies have been extensively used to he...
research
05/17/2021

A New Framework to Adopt Multidimensional Databases for Organizational Information System Strategies

As information becomes increasingly sizable for organizations to maintai...
research
09/13/2021

SPARQLing Database Queries from Intermediate Question Decompositions

To translate natural language questions into executable database queries...
research
07/28/2019

A Translate-Edit Model for Natural Language Question to SQL Query Generation on Multi-relational Healthcare Data

Electronic health record (EHR) data contains most of the important patie...
research
07/11/2023

SparqLog: A System for Efficient Evaluation of SPARQL 1.1 Queries via Datalog [Experiment, Analysis and Benchmark]

Over the past decade, Knowledge Graphs have received enormous interest b...
research
04/03/2018

VerdictDB: Universalizing Approximate Query Processing

Despite 25 years of research in academia, approximate query processing (...

Please sign up or login with your details

Forgot password? Click here to reset