SQL Query Translator : An Automated Tool For SQL to Spreadsheet Formulae Conversion
Abstract & Details
Research Area
Computer Engineering
Keywords
spreadsheet formulae
SQL queries
relational algebra
Abstract
Spreadsheet or excel sheet is an efficient way of data analysis and management. It has diverse supplementary features such as, linear structure, visualization, statistics, reporting, periodic web query etc. There is several computation parameters required sufficient analysis. Mostly, user’s not much familiar with the complicated functions of spreadsheet but many times they have basic SQL query knowledge. Spreadsheet can implement all transformation of data in SQL by utilizing SQL formulae. A query compiler is used to translate SQL query into spreadsheet with similar semantics having NULL values. User can define their queries using high-level language which is further executed on plain spreadsheet. Our main is migration of SQL data into spreadsheet format. Result graph visualization is the contribution part of system.
License
This work is licensed under a Creative
Commons
Attribution-ShareAlike 4.0 International License.
Author Information
| # | Name | Institute / Affiliation |
|---|---|---|
| 1 | Priyanka Uday Wani | MET’s Institute of Engineering |
| 2 | Dr. K. V. Metre | MET’s Institute of Engineering |
How to Cite
Use the following formats to cite this article in your research.
APA Style
Wani, Priyanka Uday & Metre, Dr. K. V. (2017). SQL Query Translator : An Automated Tool For SQL to Spreadsheet Formulae Conversion. International Journal of Advance Research and Innovative Ideas In Education, 3(4), 1426-1431.
MLA Style
Wani, Priyanka Uday, and Dr. K. V. Metre. "SQL Query Translator : An Automated Tool For SQL to Spreadsheet Formulae Conversion." International Journal of Advance Research and Innovative Ideas In Education, vol. 3, no. 4, 2017, pp. 1426-1431.
IEEE Style
Priyanka Uday Wani and Dr. K. V. Metre, "SQL Query Translator : An Automated Tool For SQL to Spreadsheet Formulae Conversion," International Journal of Advance Research and Innovative Ideas In Education, vol. 3, no. 4, pp. 1426-1431, 2017.
Vancouver Style
Wani Priyanka Uday, Metre Dr. K. V.. SQL Query Translator : An Automated Tool For SQL to Spreadsheet Formulae Conversion. International Journal of Advance Research and Innovative Ideas In Education. 2017;3(4):1426-1431.
Harvard Style
Wani, Priyanka Uday & Metre, Dr. K. V. (2017) 'SQL Query Translator : An Automated Tool For SQL to Spreadsheet Formulae Conversion', International Journal of Advance Research and Innovative Ideas In Education, 3(4), pp. 1426-1431.
Chicago Style
Wani, Priyanka Uday and Dr. K. V. Metre. "SQL Query Translator : An Automated Tool For SQL to Spreadsheet Formulae Conversion." International Journal of Advance Research and Innovative Ideas In Education 3, no. 4 (2017): 1426-1431.
Turabian Style
Wani, Priyanka Uday and Dr. K. V. Metre. "SQL Query Translator : An Automated Tool For SQL to Spreadsheet Formulae Conversion." International Journal of Advance Research and Innovative Ideas In Education 3, no. 4 (2017): 1426-1431.
Related Research
A Brief Review of Performance Evaluation of Global and Local Image Thresholding Based on Computational Efficiency
Download PDF
Performance Evaluation of Global and Local Image Thresholding Based on Computational Efficiency
Download PDF
Enhancing Handwritten Alpha-Numeral Recognition Using GAN-Based Synthetic Data Generation
Download PDF
Comprehensive Review of Existing Chatbot Systems for Career Assistance, Resume Support, and ATS-Aware Guidance
Download PDF
Development of an AI-Powered Multimodal Web Assistant with Intelligent Resume Building and ATS Enhancement
Download PDF
A Deep Learning-Based Framework for Mood-Oriented Music Recommendation Using Facial Expression Analysis
Download PDF