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 299
- Downloads 8
Harmonic Distortion Elimination for STATCOM Application Using SHE-PWM Cascaded Multilevel Inverter
A novel multilevel selective harmonic elimination pulse-width modulation (MSHE–PWM) technique for transformer static synchronous compensator STATCOM system using cascaded H-bridge inverter (CHI) is proposed. MSHE–PWM me...
A Fast Reading and Processing Method of Obstacle Detection in Changing Environment Using Color and Texture
A leading obstacle detection algorithm based on color and texture feature used monocular vision is basically described in this paper. The purpose of this paper is to provide an eye to a visually impaired people so that...
A Boost Converter for Renewable Energy Sources
This paper proposes a isolated multi-input single output dc-dc boost converter for instantaneous regulation of power from different renewable input energy sources having different capabilities. The proposed boost conver...
Unsteady MHD Free Convective Chemically Absorption Fluid Past an Impulsively Accelerated Plate with Thermal Radiation
A theoretical study on free convective heat and mass transfer flow of an electrically conducting incompressible viscous fluid past an impulsively accelerated permeable plate embedded in Darcian (thermal) absorption medi...
slugComparative Analysis of Web Mining Techniques: Survey
The cluster of technologies and design are known as web, which has now emerged as a fertile area for data mining research. The web mining research is being carried out across the globe. Many research communities such as...