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 302
- Downloads 8
Automatic Text Document Summarization
Conventional Information Retrieval approaches are insufficient for the increasingly vast amounts of text data. Typically, only a small amount of the many available documents will be applicable to a given individual or u...
Brief Review of Various Metrics to Achieve Reusability and Changeability of a Software
Component Based Software Engineering (CBSE) is one of the trending techniques that specifies upon the design and construction of large and complex software systems. The main objective is to minimize the changeability, c...
Augmentation Heat Transfer in a Circular Tube Using Divergent Nozzle as Insert
Augmentation techniques place a vital role in enhancement of heat transfer. The above techniques are classified as active, passive and compound techniques, In passive techniques insertion of twisted tape, coils, obstruc...
Assessment of Works under Jalyukta Shivar Campaign – A Case Study of Pusad Region
JYS is the Government of Maharashtra’s program to provide water for all and make villages scarcity-free. Maharashtra has been witnessing increasing agricultural and drinking water stress in recent years. Maharashtra gov...
Implementation of GSM and Zigbee Technology to Improve the Operational Efficiency of Road Transportation System
At the moment, reporting bus station is rely mainly on driver’s manual operation, thus, making mistakes and misleading passengers becomes inevitable when driving the bus. Therefore, this Paper proposes a supervisory sys...