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 274
- Downloads 8
Hazard Identification and Assessment for Floating, Production, Storage and Offloading Unit in Offshore Oil Industry
Floating Production Storage and Offloading Systems (FPSO) are large vessels or ships often equipped with processing facilities and moored to the location for a shorter or longer period of time. The key feature of the sh...
Comparative Study Between Different Metal Gates Engineered Structures
In this paper, comparative study between different metal gate structures has been presented. Short channel effect acts as barrier for further reduction in size of conventional MOSFETs. So looking for new device structur...
Structural and Thermal Analysis on Hot Runner Nozzle by FEA
Hot-runner systems can provide an array of benefits, including reduced material use, faster cycles, and overall better part quality. Hot runner system is an assembly of heated components used in plastic injection molds...
Twitter Dual Sentiment Analysis (TDSA)
Nowadays, Most of the people's interested area is social medias. They use social medias to know the reviews about various topics and areas. Sentiment analysis is the one of the technology used in social medias to know t...
Generate new identity from fingerprints for privacy protection
We propose here a novel system for privacy protection of fingerprint by merging two fingerprints & generate new identity. In the enrollment phase, two fingerprints are taken from two different fingers of one person. Fro...