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
CYBERSECURITY WITH AI
PDF Unavailable
DESIGN AND IMPLEMENTATION OF A SECURE IMAGE STEGANOGRAPHY SYSTEM USING LSB AND CRYPTOGRAPHY
PDF Unavailable
A NOVEL HYBRID IMAGE STEGANOGRAPHY TECHNIQUE BASED ON LSB AND CRYPTOGRAPHIC SECURITY
PDF Unavailable
BioPrint AI: An Intelligent Deep Learning and Computer Vision Based Blood Group Identification System Using Fingerprint Patterns
PDF Unavailable
AnimalAid AI: A Deep Learning Powered Early Warning System for Detecting Skin Infections and Diseases in Stray Dogs
PDF Unavailable
LiverCare AI: Intelligent Medical Imaging Platform for Liver Tumor Detection and Clinical Guidance
PDF Unavailable