Accessing and Analyzing Spreadsheets using SQL and NLP
Abstract & Details
Research Area
Computer Engineering
Keywords
Natural Language Processing
Relational Database Management Systems
Spreadsheets
SQL.
Abstract
Spreadsheets are the most widely used database management applications with interactive Graphical User Interface. Almost all the business, industrial or commercial databases are stored using spreadsheets. It has been observed that a spreadsheet can be used as a relational database management system without using any programming language paradigm. Utilizing various operators of relational algebra by using spreadsheet functions it can be achieved. By giving a particular definition of database in SQL, a workbook of spreadsheet with empty datasheets and sheets of formulas for SQL queries can be implemented. All the data manipulations operations such as insertion, deletion, retrieval and modification performed by users can then be handled by spreadsheet functions. But the end-users must be aware of SQL Queries in order to use such a model. In this paper, we approach such problem by carrying out mapping of natural language questions into their associated SQL queries.
License
This work is licensed under a Creative
Commons
Attribution-ShareAlike 4.0 International License.
Author Information
| # | Name | Institute / Affiliation |
|---|---|---|
| 1 | Mr. Pramod B. Deshmukh | D Y Patil College of Engineering, Akurdi, Pune, MH, India |
| 2 | Mrs. Dipalee Chaudhari | D Y Patil College of Engineering, Akurdi, Pune, MH, India |
| 3 | Mr. Navneet Kumar Rajoria | D Y Patil College of Engineering, Akurdi, Pune, MH, India |
| 4 | Mr. Tushar Kamble | D Y Patil College of Engineering, Akurdi, Pune, MH, India |
| 5 | Miss. Tejashree Rokade | D Y Patil College of Engineering, Akurdi, Pune, MH, India |
| 6 | Miss. Manisha Sharma | D Y Patil College of Engineering, Akurdi, Pune, MH, India |
How to Cite
Use the following formats to cite this article in your research.
APA Style
Deshmukh, Mr. Pramod B., Chaudhari, Mrs. Dipalee, Rajoria, Mr. Navneet Kumar, Kamble, Mr. Tushar, Rokade, Miss. Tejashree, & Sharma, Miss. Manisha (2016). Accessing and Analyzing Spreadsheets using SQL and NLP. International Journal of Advance Research and Innovative Ideas In Education, 2(6), 909-912.
MLA Style
Deshmukh, Mr. Pramod B., et al. "Accessing and Analyzing Spreadsheets using SQL and NLP." International Journal of Advance Research and Innovative Ideas In Education, vol. 2, no. 6, 2016, pp. 909-912.
IEEE Style
Mr. Pramod B. Deshmukh, Mrs. Dipalee Chaudhari, Mr. Navneet Kumar Rajoria, Mr. Tushar Kamble, Miss. Tejashree Rokade, and Miss. Manisha Sharma, "Accessing and Analyzing Spreadsheets using SQL and NLP," International Journal of Advance Research and Innovative Ideas In Education, vol. 2, no. 6, pp. 909-912, 2016.
Vancouver Style
Deshmukh Mr. Pramod B., Chaudhari Mrs. Dipalee, Rajoria Mr. Navneet Kumar, Kamble Mr. Tushar, Rokade Miss. Tejashree, Sharma Miss. Manisha. Accessing and Analyzing Spreadsheets using SQL and NLP. International Journal of Advance Research and Innovative Ideas In Education. 2016;2(6):909-912.
Harvard Style
Deshmukh, Mr. Pramod B., Chaudhari, Mrs. Dipalee, Rajoria, Mr. Navneet Kumar, Kamble, Mr. Tushar, Rokade, Miss. Tejashree, & Sharma, Miss. Manisha (2016) 'Accessing and Analyzing Spreadsheets using SQL and NLP', International Journal of Advance Research and Innovative Ideas In Education, 2(6), pp. 909-912.
Chicago Style
Deshmukh, Mr. Pramod B., et al. "Accessing and Analyzing Spreadsheets using SQL and NLP." International Journal of Advance Research and Innovative Ideas In Education 2, no. 6 (2016): 909-912.
Turabian Style
Deshmukh, Mr. Pramod B., et al. "Accessing and Analyzing Spreadsheets using SQL and NLP." International Journal of Advance Research and Innovative Ideas In Education 2, no. 6 (2016): 909-912.
Related Research
Comprehensive Review of Existing Chatbot Systems for Career Assistance, Resume Support, and ATS-Aware Guidance
PDF Unavailable
Development of an AI-Powered Multimodal Web Assistant with Intelligent Resume Building and ATS Enhancement
PDF Unavailable
A Deep Learning-Based Framework for Mood-Oriented Music Recommendation Using Facial Expression Analysis
PDF Unavailable
Survey On : Intelligent Payroll and Human Resource Management Systems: A Systematic Review of Automation, Security, and Analytics
PDF Unavailable
Civic Engagement & Empowerment Platform
PDF Unavailable
Recent Developments in Microneedle Technology and Its Diverse Biomedical Applications
PDF Unavailable
RAG System Development with Pydantic AI ChromaDB & Groq
PDF Unavailable
Machine Learning Based Early Stage Diabetes Detection System
PDF Unavailable
A Survey on Skillsense:AI Career Analyzer App
PDF Unavailable
Employee Performance Portal
PDF Unavailable