Call for Papers:Vol.12 Issue.2

Submission
Last date		 28-Apr-2026
Acceptance Status In One Day
Paper Publish In Two Days
Submit ManuScript

News & Updates

Submit Article

Dear Authors, Article publish in our journal for Volume-12,Issue-2. For article submission on below link: Submit Manuscript


Join As Board

Dear Reviewer, You can join our Reviewer team without given any charges in our journal. Submit Details on below link: Join As Board


Paper Publication Charges

IJARIIE APP
Download Android App

For Authors

Archives

IJARIIE Board

Downloads

Android App

Download IJARIIE APP

Authors

Title: :  OLAP ALGEBRAIC LAWS FOR IMPROVING OLAP EXPRESSION TREES
PaperId: :  12431
Published in:   International Journal Of Advance Research And Innovative Ideas In Education
Publisher:   IJARIIE
e-ISSN:   2395-4396
Volume/Issue:    Volume 6 Issue 4 2020
DUI:    16.0415/IJARIIE-12431
Licence: :   IJARIIE is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Author NameAuthor Institute
DR. BHAVESH PATELDEPT. OF COMPUTER SCIENCE, H.N.G.UNIVERSITY. PATAN, GUJARAT
DR. JIGNESH PATELDEPT. OF COMPUTER SCIENCE, H.N.G.UNIVERSITY. PATAN, GUJARAT
DR. BADAL KOTHARIDEPT. OF COMPUTER SCIENCE, H.N.G.UNIVERSITY. PATAN, GUJARAT

Abstract

COMPUTER SCIENCE
Algebraic Laws, MOLAP Algebra, Operation in MOLAP
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.

Citations

Copy and paste a formatted citation or use one of the links to import into a bibliography manager and reference.

IJARIIE 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 Volume 6 Issue 4 2020 Page 1140-1145
MLA 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 6.4(2020) : 1140-1145.
APA DR. BHAVESH PATEL, DR. JIGNESH PATEL, & DR. BADAL KOTHARI. (2020). OLAP ALGEBRAIC LAWS FOR IMPROVING OLAP EXPRESSION TREES. International Journal Of Advance Research And Innovative Ideas In Education, 6(4), 1140-1145.
Chicago 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 6, no. 4 (2020) : 1140-1145.
Oxford 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, 2020, p. 1140-1145. Available from IJARIIE, http://ijariie.com/AdminUploadPdf/OLAP_ALGEBRAIC_LAWS_FOR_IMPROVING_OLAP_EXPRESSION_TREES_ijariie12431.pdf (Accessed : 06 August 2020).
Harvard DR. BHAVESH PATEL, DR. JIGNESH PATEL, and DR. BADAL KOTHARI. (2020) 'OLAP ALGEBRAIC LAWS FOR IMPROVING OLAP EXPRESSION TREES', International Journal Of Advance Research And Innovative Ideas In Education, 6(4), pp. 1140-1145IJARIIE [Online]. Available at: http://ijariie.com/AdminUploadPdf/OLAP_ALGEBRAIC_LAWS_FOR_IMPROVING_OLAP_EXPRESSION_TREES_ijariie12431.pdf (Accessed : 06 August 2020)
IEEE 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, Jul-Aug 2020. [Online]. Available: http://ijariie.com/AdminUploadPdf/OLAP_ALGEBRAIC_LAWS_FOR_IMPROVING_OLAP_EXPRESSION_TREES_ijariie12431.pdf [Accessed : 06 August 2020].
Turabian 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 [Online]. volume 6 number 4 (06 August 2020).
Vancouver 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 [Internet]. 2020 [Cited : 06 August 2020]; 6(4) : 1140-1145. Available from: http://ijariie.com/AdminUploadPdf/OLAP_ALGEBRAIC_LAWS_FOR_IMPROVING_OLAP_EXPRESSION_TREES_ijariie12431.pdf
BibTex EndNote RefMan RefWorks

Number Of Downloads


Last download on 8/6/2020 2:20:49 AM

Save in Google Drive

Similar-Paper

TitleArea of ResearchAuther NameAction
Consumer Behavioural Analysis Using Advanced Clustering TechniquesComputer Science and EngineeringSupriya Thati Download
Predicting Stock Market Trends using Deep Learning TechniquesComputer Science and EngineeringAkruthi Shere Download
A SURVEY ON SMART VOTING SYSTEM USING BLOCKCHAINComputer Science EngineeringAleena Shaju Download
A SURVEY ON SECURESCAN 360: CYBER INTEGRATED SYSTEM FOR THREAT DETECTION AND IMAGE AUTHENTICATIONComputer Science and EngineeringAparna Sunil Download
Efficient Use of Dialog Boxes in GUI Development using VB.NETComputer ScienceDR. RISHI MATHUR Download
A SURVEY ON HOPEBITE: AI-POWERED SMART FOOD DISTRIBUTION FOR COMMUNITIES IN NEEDComputer Science and EngineeringJUGAL KRISHNA V S Download
A SURVEY ON ACCIDENT DETECTION AND AUTOMATED EMERGENCY NOTIFICATION SYSTEM USING YOLO V8Computer EngineeringVipin Varghese Download
INVISIBLE DISABILITY AND ROUTINE WELLNESS TRACKERComputer Science and EngineeringAnna Rose Poly Download
A SURVEY ON AI POWERED SELF HEALING CODE DEBUGGERComputer EngineeringNandana Shibu Download
MULTIPLE DISEASE PREDICTION AND DRUG RECOMMENDATION SYSTEM USING MACHINE LEARNINGCOMPUTER ENGINEERING DR. J. AMUTHARAJ Download
SOLAR TRACKING SYSTEM WITH WEATHER FORECASTING AND AUTOMATED CLEANING SYSTEMArtificial Intelligence Electrical and Electronics EngineeringVanarasan S Download
ASD PredictionComputer scienceAbhilasha M Download
Music Recommendation based on Face Emotion Using Artificial Intelligence and Machine LearningInformation Science EngineeringDr. Sreenivasa Murthy V Download
SMART TRAFFIC AI MONITORING SYSTEM-AI/MLINFORMATION SCIENCE AND ENGINEERING PRIYANKA MT Download
SHADOW THE WEB BROWSERComputer Science and EngineeringLakshmi Narayan S Download
12