Notes:
Natural Language and SQL (Structured Query Language) are two different ways to interact with databases. Natural Language is the way humans communicate and express themselves using natural language such as English or Spanish. SQL, on the other hand, is a programming language specifically designed for managing and querying relational databases. While natural language is intuitive and easy for humans to understand, it can be difficult for computers to interpret and process. SQL, on the other hand, is more precise and structured, making it easier for computers to understand and execute commands. Therefore, many applications offer a form-based environment for naive users for accessing databases without being familiar with the database schema or SQL, as a way to bridge the gap between human and computer understanding of data.
A method of querying databases using a natural language interface is proposed, since naive users often struggle with accessing data using formal query languages. There is a difficulty in developing an interface for untrained users to query large databases using natural language. Despite progress in form-based environments for accessing databases, there has been little progress in making the process more accessible to non-technical users. Automatically mapping natural language semantics into programming languages has always been a major and interesting challenge and it is a long-term desire of computer users to minimize the communication gap between computers and humans. There has been growing interest in understanding and answering human language questions since the 1970s and a hot issue in the area of database management is to provide a high-level interface for non-technical users.
Wikipedia:
See also:
NLDB (Natural Language Database)
Aspects of the automatic generation of SQL statements in a natural language query interface N Ott – Information Systems, 1992 – Elsevier Abstract In Natural Language Interfaces to databases it is currently a widely accepted technique to use an intermediate semantic representation of the NL sentences which is more or less based on First Order Predicate Logic, eventually augmented by some … Cited by 13 Related articles All 4 versions Cite
Explaining structured queries in natural language G Koutrika, A Simitsis… – Data Engineering (ICDE), …, 2010 – ieeexplore.ieee.org Abstract Many applications offer a form-based environment for nai¿ ve users for accessing databases without being familiar with the database schema or a structured query language. User interactions are translated to structured queries and executed. However, as a user is … Cited by 15 Related articles All 8 versions Cite
Semantic mapping between natural language questions and SQL queries via syntactic pairing A Giordani, A Moschitti – Natural Language Processing and Information …, 2010 – Springer Abstract. Automatically mapping natural language semantics into pro- gramming languages has always been a major and interesting challenge in Computer Science. In this paper, we approach such problem by carry- ing out mapping at syntactic level and then applying machine … Cited by 10 Related articles All 9 versions Cite
A natural language database interface for sql-tutor S Knowles – 1999 – CiteseerAbstract An investigation into integrating a database Natural Language Processing (NLP) component into the SQL-Tutor Intelligent Tutoring System (ITS) is presented. Tailor-made NLP systems created by a programmer, and NLP systems created automatically by a … Cited by 7 Related articles All 2 versions Cite More
Mapping Natural Language into SQL in a NLIDB A Giordani – Natural Language and Information Systems, 2008 – Springer Abstract. Since the 1970’s, there has been growing interest in understanding and answering human language questions. Despite this, little progress has been made in developing an interface that any untrained user can use to query very large databases using natural language. In … Cited by 6 Related articles All 4 versions Cite
Corpora for Automatically Learning to Map Natural Language Questions into SQL Queries. A Giordani, A Moschitti – LREC, 2010 – disi.unitn.it Abstract Automatically translating natural language into machine-readable instructions is one of major interesting and challenging tasks in Natural Language (NL) Processing. This problem can be addressed by using machine learning algorithms to generate a function … Cited by 5 Related articles All 7 versions Cite More
Issues in translating from natural language to SQL in a domain-independent natural language interface to databases BJJ González, RAP Rangel, HHJ Fraire… – MICAI 2006: Advances …, 2006 – Springer Abstract. This paper deals with a domain-independent natural lan- guage interface to databases (NLIDB) for the Spanish language. This NLIDB had been previously tested for the Northwind and Pubs domains and had attained good performance (86% success rate). However, … Cited by 4 Related articles All 4 versions Cite
SQL Generation for Natural Language Interface L Kovács – Journal of Computer Science and Control Systems, 2009 – wiki.csc.calpoly.edu Abstract-A hot issue in the area of database management is to provide a high level interface for nontechnical users. An important research direction is the application of natural language interface. The paper presents an interface module that converts user’s query given in … Cited by 2 Related articles All 2 versions Cite More
Efficient Transformation of a Natural Language Query to SQL for Urdu R Ahmad, MA Khan, R Ali – Proceedings of the Conference on Language …, 2009 – cle.org.pk Abstract It is a long term desire of the computer users to minimize the communication gap between the computer and a human. Natural Language Interfaces to Databases (NLIDBs) is one of the mechanisms to pull off this goal. In NLIDBs the question is asked in simple daily … Cited by 2 Related articles All 2 versions Cite More
Extending the UML concepts to transform natural language queries with fuzzy semantics into SQL FSC Tseng, CL Chen – Information and Software Technology, 2006 – Elsevier Database applications tend toward getting more versatile and broader to comply with the expansion of various organizations. However, naïve users usually suffer from accessing data arbitrarily by using formal query languages. Therefore, we believe that accessing … Cited by 3 Related articles All 6 versions Cite
Query builder: A natural language interface for structured databases J Little, M de Ga, T Özyer, R Alhajj – Computer and Information Sciences- …, 2004 – Springer … from the linguistic complexity of natural languages to the structure and rigidity of structured query languages. … Query Builder: A Natural Language Interface for Structured Databases … 20 points in teams with at most 60 points?” would have the following corresponding SQL query: … Cited by 4 Related articles All 5 versions Cite
Generating SQL queries using natural language syntactic dependencies and metadata A Giordani, A Moschitti – Natural Language Processing and Information …, 2012 – Springer Abstract. This research concerns with translating natural language questions into SQL queries by exploiting the MySQL framework for both hypothesis construction and thesis verification in the task of question an- swering. We use linguistic dependencies and metadata to build … Cited by 1 Related articles All 5 versions Cite
An evolutionary method for natural language to SQL translation A Afonso, L Brito, O Vale – Simulated Evolution and Learning, 2008 – Springer X. Li et al. (Eds.): SEAL 2008, LNCS 5361, pp. 432–441, 2008. © Springer-Verlag Berlin Heidelberg 2008 … An Evolutionary Method for Natural Language to SQL … Alexandre Afonso1, Leonardo Brito1, and Oto Vale2 … 1 Escola de Engenharia Elétrica e de Computação-UFG 74605- … Cited by 1 Related articles All 4 versions Cite
Applying transformation-based error-driven learning to structured natural language queries A Woodley, S Geva – Cyberworlds, 2005. International …, 2005 – ieeexplore.ieee.org … express both their content and structural requirement, in the form of a structured query. Traditionally, these structured queries have been formatted using formal languages such as XPath … idea of specifying users’ content and structural needs via natural language queries (NLQs). … Cited by 2 Related articles All 7 versions Cite
Sql Generation And Execution From Natural Language Processing S Kaur, RS Bali – researchmanuscripts.com ABSTRACT This paper proposes a method of querying with the databases by means of a natural language interface. This is hot issue in the area of database management is to provide a high level interface for nontechnical users. Normal users are not aware with the … Related articles All 2 versions Cite More
Implementing A Natural Language To Structured Query Language Translator KJ Shannon – 2011 – kevinjshannon.com Since the beginning of computing, humans have been trying to make computers understand each other more completely. Humans have always had difficulties encoding their thoughts and computational problems and in turn, computers have had difficulty understanding the … Related articles Cite
Natural Language To Sql Conversion System AM BHADGALE, SR GAVAS, MM PATIL… – International Journal of …, 2013 – getcited.org ABSTRACT: This project aims at developing a system which will accept English query from user and convert it into SQL. This helps novice user who can easily get required contents without knowing any complex details of SQL languages. We can store huge amount of … All 2 versions Cite More
Using natural language processing in order to create SQL queries M Norouzifard, SH Davarpanah… – … , 2008. ICCCE 2008. …, 2008 – ieeexplore.ieee.org Abstract Using query language for dealing with databases is always a professional and complex problem. This complexity causes the userpsilas usage of data existing in database limits to use definite reports there are in some pre implemented softwares. However, you … Related articles Cite
“Intelligent Query Converter”: A Domain Independent Interface For Conversion Of Natural Language Queries In English To Sql D NEELUNIHALANI, M MOTWANI, S SILAKARI – International journal, 2013 – getcited.org ABSTRACT: Retrieval of information from databases using query language is always a professional and complex problem. This complexity reduces the usage of data existing in the databases. However, the databases will be more useful if a non-professional user can … Cite More
Structural Mapping between Natural Language Questions and SQL Queries A Giordani – 2012 – eprints-phd.biblio.unitn.it A core problem in data mining is to retrieve data in an easy and human friendly way. Automatically translating natural language questions into SQL queries would allow for the design of effective and useful database systems from a user viewpoint. In this thesis, we … Related articles Cite
Paraphrasing SQL to natural language J Ljungberg – RIAO 91: computer aided information retrieval. …, 1991 – cat.inist.fr Résumé/Abstract Restating the meaning of a sentence in other words is a phenomena in natural language (NL) commonly referred to as paraphrasing. This paper deals with the question of paraphrasing a formal expression to natural language. One area where … Cited by 4 Related articles Cite