OLAP operations in Data warehousing.pptx

DWDM

1. OLAP Operations

2. Roll-up operation It is also called ‘aggregation.’ We can perform this operation in two ways. Reduction of dimension: It is the system in which the cube reduces its dimension Climbing up concept  hierarchy . It is the system of grouping things based on their level.

3. made by Radmilo Pesic & Branko Golubovic 10 /74

4. Drill-down operation It is the opposite process of roll-up. It performs in 2 ways. Increasing of dimension Climbing down the concept hierarchy

5. made by Radmilo Pesic & Branko Golubovic 14 /74 Chicago Toronto Vancouver New York computer security phone home entertainment Q1 Q2 Q3 Q4 item (types) time (quarters) location (cities) 400 14 825 605 computer security phone home entertainment item (types) computer security phone home entertainment item (types) supplier=“SUP1” supplier=“SUP1” supplier=“SUP2” A 4-D data cube representation of sales data for AllElectronics

6. made by Radmilo Pesic & Branko Golubovic 15 /74 1560 440 395 400 14 825 605 Chicago Toronto Vancouver New York computer security phone home entertainment Q1 Q2 Q3 Q4 item (types) time (quarters) address (cities) computer security phone home entertainment item (types) computer security phone home entertainment item (types) Chicago Toronto Vancouver New York address (cities) Q1 Q2 Q3 Q4 time (quarters) 100 150 150 1000 2000 Canada USA address (countries) time (months) Jan March Feb <Vancouver,Q1,security> Roll-up on address Drill-down on time data for Q1

7. In a slice method, one dimension is chosen, and a subcube is generated. Two or more dimensions are selected in a dice operation, and subcubes are generated .

8. made by Radmilo Pesic & Branko Golubovic 20 /74 time, location, supplier time, item, location time, item, supplier item, location, supplier time, item, location, supplier time, location time, supplier location, supplier time, item item, location item, supplier time location item supplier all 0-D (apex) cuboid 1-D cuboid 4-D (base) cuboid 2-D cuboid 3-D cuboid Lattice of cuboids, making up a 4-D data cube

9. made by Radmilo Pesic & Branko Golubovic 21 /74

10. Pivot The pivot operation is also known as rotation. It rotates the data axes in view in order to provide an alternative presentation of data.  made by Radmilo Pesic & Branko Golubovic 22 /74

11. Pivot To provide a substitute presentation of data, you need to rotate the data axes in this operation 23 /74

12. made by Radmilo Pesic & Branko Golubovic 25 /74 1560 440 395 400 14 825 605 Chicago Toronto Vancouver New York computer security phone home entertainment Q1 Q2 Q3 Q4 item (types) time (quarters) location (cities) 2000 1000 USA Canada computer security phone home entertainment Q1 Q2 Q3 Q4 item (types) time (quarters) location (countries) 150 100 150 Chicago Toronto Vancouver New York computer security phone home entertainment item (types) time (months) location (cities) January February March April May June July August September October November December roll-up on location (from cities to countries) drill-down on time (from quarters to months)

13. made by Radmilo Pesic & Branko Golubovic 28 /74 1560 440 395 400 14 825 605 Chicago Toronto Vancouver New York computer security phone home entertainment Q1 Q2 Q3 Q4 item (types) time (quarters) location (cities) 395 605 USA Canada computer home entertainment Q1 Q2 item (types) time (quarters) location (cities) dice for (location=“Toronto” or “Vancouver”) and (time=“Q1”or “Q2”) and (item=“home entertainment” or “computer”) slice for time=“Q1” 400 14 825 605 Vancouver Toronto New York Chicago computer security phone home entertainment item (types) location (cities) 400 14 825 605 Vancouver Toronto New York Chicago computer security phone home entertainment item (types) location (cities) pivot