An application of database query translation into spreadsheets
Mayuri V. Sadaphule, Nuzhat F. Shaikh · 2016
Most common end users those who are not professional users finds difficult to specify queries against querying structured databases. The most commonly used applications for data management and analysis is the spreadsheet. Still the spreadsheet computation lacks enough analysis. Combining the concepts of spreadsheets and the database system can result into new formation which can be easily handled by the end users. The main topic of this article is to offer a fully automated method, a tool which constructs spreadsheet implementations of relational data transformations. This paper proposes an automated tool to store the data and translate it into spreadsheet system easily. The tool can be called as a Query-Converter which actually converts the database queries into formula based spreadsheets. It imposes techniques which overcomes the limitations of Database system by spreadsheets for effective Data Modeling Applications. Spreadsheets are also capable of implementing some graph traversing algorithms like BFS and DFS as additional tasks.