A Logical Spreadsheet Management System
Journal Title: International Journal for Research in Applied Science and Engineering Technology (IJRASET) - Year 2017, Vol 5, Issue 6
Abstract
Separate operators of the relational algebra were implemented in the spreadsheets. The ability to express relational queries and the users of spreadsheets can perform relational data transformations in the spreadsheet itself. End users can still work in the vanilla spreadsheet, benefit from its features like data analysis and visualization, while the complex formulas are generated by a tool that allows to express them in a better suited high-level language and avoids errors. Either they are not yet ready to migrate to a database, or they do not want to migrate at all. They can define their queries using a high-level language and then get their execution plans in a plain vanilla spreadsheet. No sophisticated database system, no spreadsheet plugging or macros are needed. The functions available in spreadsheets impose severe limitations on the algorithms one can implement. spreadsheet can implement, as we demonstrate, Depth-First-Search and Breadth-First-Search on graphs, thereby reaching beyond queries.
Authors and Affiliations
Ramya R, Dinesh P S, Iniya Shree S
Keywords
Related Articles
- EP ID EP24417
- DOI -
- Views 272
- Downloads 8
Deadline Groovy Search
A new approach for the contract search problem, the called Deadline Aware Search (DAS). DAS reacts to the approaching deadline during search. A method of measuring heuristic error on-line and using those errors in a mod...
Vibration Analysis of Cantilever Beam: An Experimental Study
The purpose of this study is to investigate the natural frequencies of a cantilever beam experimentally and validate the result with finite element analysis of the beam. The finite element analysis is performed in MATLA...
Solar Power Supply for Tribal Zone at Zero Billing
This project describes a cost-effective improvement of Electrical Power Generation System by using Solar Energy System for tribal people so that they can use this system as their regular power source and stay disconnect...
slugMixed Convection in MHD Slip Flow of Alumina Water Nanofluid Over a Flat Plate
Heat transfer in magnetohydrodynamic (MHD) slip flow of an incompressible, viscous, electrically conducting, mixed convective and steady alumina-water nanofluid over a flat plate has been analyzed. The governing equatio...
The PolyVernam Cipher
Cryptography encryption is an effective way to achieve the security of data. The encryption is to hide the data in a way that an attacker cannot hack the data. The main purpose of encryption is to hide the data from the...