OLAP ALGEBRAIC LAWS FOR IMPROVING OLAP EXPRESSION TREES
Abstract & Details
Research Area
COMPUTER SCIENCE
Keywords
Algebraic Laws
MOLAP Algebra
Operation in MOLAP
Abstract
OLAP algebra, In other words, we describe simple semantics representing a comprehensive Multi-dimensional OLAP algebra that can directly exploit the clean Object-Oriented conceptual model. In this paper, we describe a number of laws for our comprehensive OLAP algebra. To illustrate the motivation for this process, first recall that a query in traditional relational databases, written in SQL, is translated internally into an initial relational algebra expression that can be then transformed into equivalent, but more efficient ones by applying various relational algebraic rules. In order to perform better joins between the cube and dimension tables, we change the restriction of the selection operation so that it can be performed on the relevant cuboid/view alone. In summary, our comprehensive OLAP query algebra (operations and laws), grammar and metadata storage are essential components in the process of resolving OLAP queries written in native OOP languages.
License
This work is licensed under a Creative
Commons
Attribution-ShareAlike 4.0 International License.
Author Information
| # | Name | Institute / Affiliation |
|---|---|---|
| 1 | DR. BHAVESH PATEL | DEPT. OF COMPUTER SCIENCE, H.N.G.UNIVERSITY. PATAN, GUJARAT |
| 2 | DR. JIGNESH PATEL | DEPT. OF COMPUTER SCIENCE, H.N.G.UNIVERSITY. PATAN, GUJARAT |
| 3 | DR. BADAL KOTHARI | DEPT. OF COMPUTER SCIENCE, H.N.G.UNIVERSITY. PATAN, GUJARAT |
How to Cite
Use the following formats to cite this article in your research.
APA Style
PATEL, DR. BHAVESH, PATEL, DR. JIGNESH, & KOTHARI, DR. BADAL (2020). OLAP ALGEBRAIC LAWS FOR IMPROVING OLAP EXPRESSION TREES. International Journal of Advance Research and Innovative Ideas In Education, 6(4), 1140-1145.
MLA Style
PATEL, DR. BHAVESH, et al. "OLAP ALGEBRAIC LAWS FOR IMPROVING OLAP EXPRESSION TREES." International Journal of Advance Research and Innovative Ideas In Education, vol. 6, no. 4, 2020, pp. 1140-1145.
IEEE Style
DR. BHAVESH PATEL, DR. JIGNESH PATEL, and DR. BADAL KOTHARI, "OLAP ALGEBRAIC LAWS FOR IMPROVING OLAP EXPRESSION TREES," International Journal of Advance Research and Innovative Ideas In Education, vol. 6, no. 4, pp. 1140-1145, 2020.
Vancouver Style
PATEL DR. BHAVESH, PATEL DR. JIGNESH, KOTHARI DR. BADAL. OLAP ALGEBRAIC LAWS FOR IMPROVING OLAP EXPRESSION TREES. International Journal of Advance Research and Innovative Ideas In Education. 2020;6(4):1140-1145.
Harvard Style
PATEL, DR. BHAVESH, PATEL, DR. JIGNESH, & KOTHARI, DR. BADAL (2020) 'OLAP ALGEBRAIC LAWS FOR IMPROVING OLAP EXPRESSION TREES', International Journal of Advance Research and Innovative Ideas In Education, 6(4), pp. 1140-1145.
Chicago Style
PATEL, DR. BHAVESH, DR. JIGNESH PATEL, and DR. BADAL KOTHARI. "OLAP ALGEBRAIC LAWS FOR IMPROVING OLAP EXPRESSION TREES." International Journal of Advance Research and Innovative Ideas In Education 6, no. 4 (2020): 1140-1145.
Turabian Style
PATEL, DR. BHAVESH, DR. JIGNESH PATEL, and DR. BADAL KOTHARI. "OLAP ALGEBRAIC LAWS FOR IMPROVING OLAP EXPRESSION TREES." International Journal of Advance Research and Innovative Ideas In Education 6, no. 4 (2020): 1140-1145.
Related Research
EduQuest AI: A Gamified Learning Platform for Interactive and Personalized Digital Education
Download PDF
Distributed Real-Time Stream Analytics and Ingestion Engine for High-Velocity Big Data Architectures
Download PDF