A Logical Spreadsheet Management System

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

SAKTHI: Scheduling Algorithm K to Hybrid in Cloud Computing

Cloud computing is based on the concepts of distributed computing, grid computing, utility computing and virtualization. It is a virtual pool of resources which are provided to users via Internet. These cloud computing...

Innovative method for Iris melanoma detection

Iris Melanoma is one of the type of eye tumor. Iris is colored part of eye that surrounds pupil. The Melanoma is tumor which grows and develops in tissues in middle layer of eyeball. Symptoms of Melanoma are dark spots...

Aptitude-Suite

Aptitude Suite Exam Generation system is Desktop Based Application. This Desktop Application is efficient, quickest and smartest rather than manual exam management process. Aptitude suite is more flexible and efficient...

Advanced Surveillance Robot

In the current context of increased surveillance and security, more sophisticatedly advanced and technologically innovative surveillance systems are needed. The detection or tracking of human in highly restricted areas...

Fundamentals of Cognitive Radio

This document gives an overview of the fundamental concepts related to the working of Cognitive Radio. In today’s world, where the demand for wireless applications and services is increasing beyond limits and at the sam...

Download PDF file
  • EP ID EP24417
  • DOI -
  • Views 283
  • Downloads 8

How To Cite

Ramya R, Dinesh P S, Iniya Shree S (2017). A Logical Spreadsheet Management System. International Journal for Research in Applied Science and Engineering Technology (IJRASET), 5(6), -. https://europub.co.uk./articles/-A-24417