OLAP operations

Description

Information Technology Mind Map on OLAP operations, created by Parag Gawde on 21/10/2018.
Parag Gawde
Mind Map by Parag Gawde, updated more than 1 year ago
Parag Gawde
Created by Parag Gawde over 5 years ago
46
0

Resource summary

OLAP operations
  1. Roll-up
    1. Performs Aggression on a data cube in two ways
      1. Climbing up a concept hierarchy for a dimension
        1. Dimension Reduction
      2. Drill-down
        1. Reverse of Roll-up, navigates from less detailed data to more detailed data
          1. Stepping down a concept hierarchy for a dimension
            1. Introducing additional dimensions
          2. Slice
            1. Performs a selection on one dimension
              1. Results in a sub cube
            2. Pivot
              1. Visualization operation that rotates the data axes in view
                1. Provides an alternative presentation of data
              2. Dice
                1. Performs a selection on two or more dimensions
                Show full summary Hide full summary

                Similar

                CCNA Security 210-260 IINS - Exam 3
                Mike M
                Application of technology in learning
                Jeff Wall
                Innovative Uses of Technology
                John Marttila
                Ch1 - The nature of IT Projects
                mauricio5509
                The Internet
                Gee_0599
                SQL Quiz
                R M
                CCNA Answers – CCNA Exam
                Abdul Demir
                Professional, Legal, and Ethical Issues in Information Security
                mfundo.falteni
                System Analysis
                R A
                Flash Cards Networks
                JJ Pro Wrestler
                EDUC260- Multimodal Literacies for a Digital Age
                angelwoo2002