NLKBIDB - Natural language and keyword based interface to database

Shah, Axita; Pareek, Jyoti; Patel, Hemal H.; Panchal, Namrata

doi:10.1109/icacci.2013.6637414

Cited by 24 publications

(15 citation statements)

References 9 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Next, it builds the parsers which help understanding user's queries and translate them into SQL-based queries to be executed against the database. Other approach is presented in (Shah, Pareek, Patel, & Panchal, 2013), this work presents an interesting approach called NLKIDB (Natural Language and Keyword Base Interface to Database). This approach tokenizes input query by a lexical analyzer and lexicons are parsed to the syntax analyzer.…”

Section: Natural Language Interfaces To Databases (Nlidb)mentioning

confidence: 98%

“…On the one hand, other relevant works (Damljanović et al, 2013;Franconi et al, 2014;Li & Jagadish, 2014;Llopis & Ferrández, 2013a;Shah et al, 2013) use trees in order to represent the user's question. These approaches try to interpret the question only through keywords contained within it.…”

Section: Natural Language Interfaces To Knowledge Bases (Nlikb)mentioning

confidence: 99%

“…This advantage is supported by the integration of more NLP techniques that allow obtaining more semantic information from the question. Some approaches (Franconi et al, 2014;Li, Li, & Ning, 2015;Shah et al, 2013) parse the question in order to find direct relations among original words contained in the user's question and the vocabulary or elements of the data source. When a question's word is not matched, they point out which word is not recognized and ask the user for information.…”

Section: Natural Language Interfaces To Knowledge Bases (Nlikb)mentioning

confidence: 99%

See 2 more Smart Citations

ONLI: An ontology-based system for querying DBpedia using natural language paradigm

Paredes-Valverde¹,

Rodríguez-García²,

Ruiz‐Martínez³

et al. 2015

Expert Systems with Applications

View full text Add to dashboard Cite

Section: Natural Language Interfaces To Databases (Nlidb)mentioning

confidence: 98%

Section: Natural Language Interfaces To Knowledge Bases (Nlikb)mentioning

confidence: 99%

Section: Natural Language Interfaces To Knowledge Bases (Nlikb)mentioning

confidence: 99%

See 1 more Smart Citation

ONLI: An ontology-based system for querying DBpedia using natural language paradigm

Paredes-Valverde¹,

Rodríguez-García²,

Ruiz‐Martínez³

et al. 2015

Expert Systems with Applications

View full text Add to dashboard Cite

“…Axita Shah , et al [5] proposed new system of natural language and keyword based interface to agricultural database, which gives result for syntactically correct or incorrect queries. NLKBIDB is combined approach of NLIDB and KBIDB.…”

Section: Nlkbidbmentioning

confidence: 99%

Keyword based Marathi Interface to the Database using Natural Language Processing

Patil¹,

Pawar²

2018

IJSRCSE

View full text Add to dashboard Cite

Abstract-Now a day"s a computer plays a vital role in almost all the sectors/application. The available information is stored and retrieved in/from the database. Database Management system (such as SQL, Oracle) allows to handle the database by creation of the database, querying the database, updating database, and administration of databases. So there is need of skilled person (database experts) in order to deal with database management system, but this is not always true. The common people with lack of expertise are there to handle the database, who doesn"t know about the syntax/format of queries to be fire on the database. Also they are more comfortable in their native languages like "Marathi", "Hindi", "Arabic". It is essential to have the database interface in native language (e.g Marathi) so that the non-expert person can also interact with database for storing and extracting the data. In this paper we are proposing the Marathi language interface using Natural Language Processing (NLP) to handle the database. This interface can handle the queries in native language which may be syntactically and semantically incorrect and convert it into correct form.(e.g SQL query).Rest of the paper is organized as follows, Section I contains the introduction of natural language processing , Section II contain the related work of natural language interface to the database system, Section III contain the problem definition and proposed system, Section IV contain the architecture and algorithm of proposed system, section V explain the working of proposed system with example, Section VI give conclusion with future direction.

show abstract

“…Natural language based query interface accept the query sentence and try to understand it by applying lexicon, syntactic and semantic analysis and then converts into SQL. Keyword based interface accepts query type of search engine query which retrieves keyword from the input query and converts into SQL by applying rules from the generated knowledge base [1].…”

Section: Introductionmentioning

confidence: 99%

A Domain and Language Construct based Mapping to Convert Natural Language Query to SQL

Malik¹,

Rishi²

2015

IJCA

View full text Add to dashboard Cite

Database management systems (DBMS) have been widely used for storing and retrieving data. However, databases are often hard to use since their interface is quite rigid in cooperating with users. End user is required to issue SQL query to retrieve information from the database. Thus, a user cannot interact directly because of lack of knowledge about the SQL query form, thus is restricted to available application options. To provide the direct access of user on dataset, some unstructured query processor is required. The present work is an interface that will convert the unstructured text query to structured SQL query. It is an intelligent interface formation between the user and the dataset and defined in three main stages namely Descriptive Database Construction, Unstructured Query Filtration and Mapping Stage. The system provide the robustness in terms to handle the broader range of user queries and is be implemented in java environment on Enterprise Employee Database.

show abstract

NLKBIDB - Natural language and keyword based interface to database

Cited by 24 publications

References 9 publications

ONLI: An ontology-based system for querying DBpedia using natural language paradigm

ONLI: An ontology-based system for querying DBpedia using natural language paradigm

Keyword based Marathi Interface to the Database using Natural Language Processing

A Domain and Language Construct based Mapping to Convert Natural Language Query to SQL

Contact Info

Product

Resources

About