Natural Language to SQL: Automated Query Formation Using NLP Techniques

نویسندگان

چکیده

In this era of information world, given any topic, we are able to get relevant data or documents at a mouse click. The flexibility that internet provides is the user friendly language Natural Language search for required topic. Querying and Retrieval has made popular. It implicit business understand what indicating find better opportunities. users using SQL. To effectively Query such systems, Business master Language. But many may not be aware SQL databases some feel difficulty write long Queries. Therefore, it equally important query database very easily. work here presents case study help type in Language, which then converts into statement process against Databases expected result. This proposes QCNER approach extract properties from Query. proposed after application SMOTE technique depicts 92.31 accuracy over existing models. 1

برای دانلود باید عضویت طلایی داشته باشید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

nQuery - A Natural Language Statement to SQL Query Generator

In this research, an intelligent system is designed between the user and the database system which accepts natural language input and then converts it into an SQL query. The research focuses on incorporating complex queries along with simple queries irrespective of the database. The system accommodates aggregate functions, multiple conditions in WHERE clause, advanced clauses like ORDER BY, GRO...

متن کامل

NLP (Natural Language Processing) for NLP (Natural Language Programming)

Natural Language Processing holds great promise for making computer interfaces that are easier to use for people, since people will (hopefully) be able to talk to the computer in their own language, rather than learn a specialized language of computer commands. For programming, however, the necessity of a formal programming language for communicating with a computer has always been taken for gr...

متن کامل

Recursive SQL-like Query language for XML

XML data are data which are not constrained by a schema, XML is fast emerging as a standard for data representation and exchange on the Word Wide Web, the ability to intelligently query XML data becomes increasingly important. In this paper we propose a recursive query language XRQL for querying and restructuring XML data. The expressive power of XRQL is comparable to Fixpoint. XRQL language is...

متن کامل

Efficient Transformation of a Natural Language Query to SQL for Urdu

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 life human language and the answer is given in the same language. This research paper is about NLIDBs for Urdu language. An algorithm is...

متن کامل

From NLP (Natural Language Processing) to MLP (Machine Language Processing)

Natural Language Processing (NLP) in combination with Machine Learning techniques plays an important role in the field of automatic text analysis. Motivated by the successful use of NLP in solving text classification problems in the area of e-Participation and inspired by our prior work in the field of polymorphic shellcode detection we gave classical NLP-processes a trial in the special case o...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

ژورنال

عنوان ژورنال: E3S web of conferences

سال: 2023

ISSN: ['2555-0403', '2267-1242']

DOI: https://doi.org/10.1051/e3sconf/202339101115