Skip to main navigation Skip to search Skip to main content

Frameworks for querying databases using natural language: A literature review - Nlp-to- db querying frameworks

  • Syed Ahmad Chan Bukhari
  • , Hafsa Shareef Dar
  • , M. Ikramullah Lali
  • , Fazel Keshtkar
  • , Khalid Mahmood Malik
  • , Seifedine Kadry
  • St. John's University
  • University of Gujrat
  • University of Education
  • Oakland University
  • Noroff University College

Research output: Contribution to journalReview articlepeer-review

12 Scopus citations

Abstract

A natural language interface is useful for a wide range of users to retrieve their desired information from databases without requiring prior knowledge of database query language such as SQL. The advent of user-friendly technologies, such as speech-enabled interfaces, have revived the use of natural language technology for querying databases; however, the most relevant and last work presenting state of the art was published back in 2013 and does not encompass several advancements. In this paper, the authors have reviewed 47 frameworks that have been developed during the last decade and categorized the SQL and NoSQL-based frameworks. Furthermore, the analysis of these frameworks is presented on the basis of criteria such as supporting language, scheme of heuristic rules, interoperability support, scope of the dataset, and overall performance score. The study concludes that the majority of frameworks focus on translating natural language queries to SQL and translates English language text to queries.

Original languageEnglish
Pages (from-to)21-38
Number of pages18
JournalInternational Journal of Data Warehousing and Mining
Volume17
Issue number2
DOIs
StatePublished - 1 Apr 2021
Externally publishedYes

Keywords

  • Cypher
  • Database
  • NL2DB
  • NLP
  • Natural Language Querying
  • NoSQL
  • SPARQL
  • SQL

Fingerprint

Dive into the research topics of 'Frameworks for querying databases using natural language: A literature review - Nlp-to- db querying frameworks'. Together they form a unique fingerprint.

Cite this