anchoring script for student Orientation in university

List down Industry domains where Data warehousing technologies have been deployed?
2. List and define the OLAP operations.
3. What are the data integration challenges and how to cater them?

Advertisement

TABLE OF CONTENTS

- DW Overview

--------Architecture
--------Back-end Tools

- Intro to OLAP

--------Codd's 12 Rules
--------FASMI

- MD Data Structures

- OLAP Server

- OLAP Operations

- OLAP Architectures

--------MOLAP: Part I
--------MOLAP: Part II
--------ROLAP: Part I
--------ROLAP: Part II
--------HOLAP
--------DOLAP

- Data Explosion

- OLAP Criteria

- Glossary

- References

OLAP Operations
One of the most compelling front-end applications for OLAP is a PC spreadsheet program. Below is the list of some popular operations that are supported by the multidimensional spreadsheet applications.
Roll-up
Takes the current aggregation level of fact values and does a further aggregation on one or more of the dimensions.
Equivalent to doing GROUP BY to this dimension by using attribute hierarchy.
Decreases a number of dimensions - removes row headers.
SELECT [attribute list], SUM [attribute names]
FROM [table list]
WHERE [condition list]
GROUP BY [grouping list];
Drill-down
Opposite of roll-up.
Summarizes data at a lower level of a dimension hierarchy, thereby viewing data in a more specialized level within a dimension.
Increases a number of dimensions - adds new headers

Slice
Performs a selection on one dimension of the given cube, resulting in a sub-cube.
Reduces the dimensionality of the cubes.
Sets one or more dimensions to specific values and keeps a subset of dimensions for selected values.
Dice
Define a sub-cube by performing a selection of one or more dimensions.
Refers to range select condition on one dimension, or to select condition on more than one dimension.
Reduces the number of member values of one or more dimensions.

Pivot (or rotate)
Rotates the data axis to view the data from different perspectives.
Groups data with different dimensions.

Drill-across
Accesses more than one fact table that is linked by common dimensions.
Combines cubes that share one or more dimensions.
Drill-through
Drill down to the bottom level of a data cube down to its back-end relational tables.
Cross-tab
Spreadsheet style row/column aggregates.