SDRED: Smart Data Retrieval Engine for Databases

Shahnawaz Ahmad, Syed Rameem Zahra
2018 International Journal of Information Technology and Computer Science  
Today computers are continuously betrothed in almost all domains and organizations. Thus, databases act as the heart for storing and retrieving information that contain huge digital data. However, in order to interact with such databases, it is necessary to have knowledge about the Structured Query Language (SQL), which is difficult for non-expert users to understand and manipulate. So, there is an emergent need to develop a smart and a user friendly computational technique to interact with
more » ... bases. The current work proposed a smart technique that can handle such context. The proposed "Smart Data Retrieval Engine for Databases (SDRED)" provided an environment that allows a nonexpert user to write and to execute the database queries easily. Furthermore, it retrieved the data stored in databases without a prior knowledge of the SQL. SDRED, which enables the non-expert user to write database queries in natural language (such as English) and to convert them to their SQL query equivalents. The current work presented a detailed design and evaluation for the proposed system by executing different database queries in English. The results established that SDRED successfully converted the non-expert user's natural language queries into their equivalent SQL queries, thereby providing an easy and user-friendly environment to interact with databases.
doi:10.5815/ijitcs.2018.06.01 fatcat:5criprppi5gk5lo6om6fvv3g7q