Hindi Language Interface to Database

IJCSMC, Vol. 3, Issue. 4, April 2014, pg.1179 – 1189 , 2014

We require information in our daily life. One of the major sources of information is database. Almost all applications have need to retrieve information from database which require knowledge of database languages like SQL. To write SQL query one need to have not only knowledge query language but also the physical structure of Database. Therefore everybody is not able to write SQL queries. To override the complexity many researchers have turned out to use Natural Language (NL) i.e Hindi, English, French, Tamil etc. instead of SQL. The idea of using NL has prompted the development of new type of processing method called Natural Language Interface to Database systems (NLIDB). This paper discusses the architecture of mapping the Hindi language query entered by the user into SQL query.

2013

Unlike most user-computer interfaces, a natural language interface allows users to communicate fluently with a computer system with very little preparation. Databases are often hard to use in cooperating with the users because of their rigid interface. A good NLIDB allows a user to enter commands and ask questions in native language and then after interpreting respond to the user in native language. For a large number of applications requiring interaction between humans and the computer systems, it would be convenient to provide the end-user friendly interface. Punjabi language interface to database would proof fruitful to native people of Punjab, as it provides ease to them to use various e-governance applications like Punjab Sewa, Suwidha, Online Public Utility Forms, Online Grievance Cell, Land Records Management System,legacy matters, e-District, agriculture, etc. Punjabi is the mother tongue of more than 110 million people all around the world. According to available information, Punjabi ranks 10th from top out of a total of 6,900 languages recognized internationally by the United Nations. This paper covers a brief overview of the Natural language interface to database, its different components, its advantages, disadvantages, approaches and techniques used. The paper ends with the work done on Punjabi language interface to database and future enhancements that can be done.

The need for Hindi Language interface has become increasingly accurate as native people are using databases for storing the data. Large number of e-governance applications like agriculture, weather forecasting, railways, legacy matters etc use databases. So, to use such database applications with ease, people who are more comfortable with Hindi language, require these applications to accept a simple sentence in Hindi, and process it to generate a SQL query, which is further executed on the database to produce the results. Therefore, any interface in Hindi language will be an asset to these people. This paper discusses the architecture of mapping the Hindi language query entered by the user into SQL query.

International Journal of Scientific Research in Computer Science and Engineering, 2018

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.

Database management systems have been widely used for storing and retrieving data. However, databases are difficult to use and there interface is complex and the same is difficult to access. To make it easy for a user to retrieve data, an interface is developed in which a database can be accessed by a user through querying in Hindi language and to get the result in same language. In order to develop an improved Hindi language graphical user interface to database management system. The proposed system can handle single and multiple columns retrieval queries, selection of whole table, conditional queries (between, in), join queries and queries that include nested, functions and logical operators. Since a user should not be able to update or delete data from database so the user is suggest on selection queries.

Anil M. Bhadgale, Sanhita R. Gavas, Meghana M. Patil & Pinki R. Goyal, 2013

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 data in databases but casual user who doesn‟t have any technical background not able to access data. So this paper proposes system that will convert English statement given by user to all possible intermediate queries so that user can select appropriate intermediate query and then system will generate SQL query from intermediate one. Finally system will fire SQL query on database and gives output to user. When an interpretation error occurs, users often get stuck and cannot recover due to a lack of guidance from the system. To solve this problem, we present a natural language query recommendation framework

In the present computing world, computer based information technologies have been extensively used to help many organizations, private companies, academic and education institutions to manage their processes and information systems. A general information management system that is capable of managing several kinds of data, stored in the database is known as Database Management System (DBMS). Database Management System is a collection of interrelated data and set of programs to access those data. In this paper, we have designed and developed Amharic Language Interface for database, so that user can easily communicate with database without the knowledge of database language like SQL. So, in order to address this issue we have developed an algorithm to efficiently map Amharic language into Structured Query Language (SQL). We divided the algorithm into four parts an algorithm to handle query selection, an algorithm to handle conditional query, an algorithm to handle aggregation and grouping and ordering queries. The algorithm has been implemented in Java and tasted on Human Resource Management (HRM) database containing Employee, Department and Employee on education tables. The experimental result shows that 91% overall accuracy. However, the system shows better performance in single and multiple conditional query, grouping and ordering query and aggregation functions, it doesn't work with Amharic temporal queries. Further improvement will be done to include temporal queries in ANLIDB.

2014 International Conference on Computation of Power, Energy, Information and Communication (ICCPEIC), 2014

Person with no knowledge of database language may find it difficult to access the database. Many systems were developed to access the information from the database using natural language. But these systems are domain-dependent i.e. they were developed for a particular domain. We develop a system called D-HIRD for Hindi language which provides domain-independence. For developing a domain-independent system, we divide our system into two modules: Language processing module and Database module. Language processing module use Hindi Shallow Parser for analyzing and parsing the input query. We introduce a domain-identifier component in database module which identifies the domain by using knowledge base. We use three database domain and 80 queries for each database for testing our system. The system is able to correctly identify the domain from the query and translate it into SQL which is executed on the database and result is provided to the user in Hindi language.

Information is playing an important role in our lives. One of the major sources of information is databases. Databases and database technology are having major impact on the growing use of computers. Almost all IT applications are storing and retrieving information from databases. There are various interfaces available to retrieve data such as form based, natural language and keyword based. Data retrieval from the database requires knowledge of database language like SQL [1]. In this paper we have proposed architecture of a Natural Language and Keyword Based Interface for Database (NLKBIDB) which provides solution for syntactically correct and incorrect natural language input query. Our partial experiment of Lexical Analyzer and Keyword based interface on agriculture survey database solves 53% of syntactically incorrect query which will not be solved by natural language interface resulting in increase of rate of SQL query conversion.

International Journal of Advance Research, Ideas and Innovations in Technology, 2019

In this research, an intelligent system is designed for users to access the database using natural language. It accepts natural language input and then converts it into an SQL query. Using query language for dealing with databases has always been a professional and complex problem. The system currently handles single sentence natural language inputs and concentrates on MySQL database system. The system accommodates aggregate functions, multiple conditions in WHERE clause, join operations, advanced clauses like ORDER BY, GROUP BY and HAVING. The natural language statement goes through various stages of Natural Language Processing like morphological, lexical, syntactic and semantic analysis resulting in SQL query formation. Intelligent Interface is the need for database applications to enhance efficient interaction between user and DBMS. The research focuses on making the system more dynamic. Improvements have been introduced to the system by incorporating preprocessing of text, named entity recognition, building hierarchical relations, semantic similarity and negation handling using dependency graphs.