OLAP ALGEBRAIC LAWS FOR IMPROVING OLAP EXPRESSION TREES

July 2020
Vol-6, Issue-4
Paper ID: 12431
ISSN: 2395-4396
Downloads: 58
Download PDF

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.

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.

Export Citation

Related Research

PReFace : AI -Assisted Plausible Facial Restoration and Damage Reconstruction System
Syeda Arbeena Kausar et al. 2026 Computer Science and Engineering (Computer Vision, Deep Learning and Image Processing)
Download PDF
Customer Churn Prediction Using Machine Learning
Dr. Roshni Khlhe et al. 2026 Machine Learning, Artificial Intelligence, Data Analytics, and Customer Churn Prediction.
Download PDF
Automated web vulnerability scanner
Jitendra Sahu et al. 2026 Computer science
Download PDF
BLOOD BANK DEMAND PREDICTION SYSTEM: MACHINE LEARNINGBASED BLOOD DEMAND FORECASTING
Uday Dharmapal Wankhede et al. 2026 Computer Science & Engineering
Download PDF