In Oracle : Data Warehouse: cubes, dimensions

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle Data Warehouse & BI

In-Oracle.com  -> Oracle Data Warehouse & BI  -> Oracle Data Warehouse

-> Data Warehouse: cubes, dimensions

 

 Data Warehouse: cubes, dimensions

 

 

What is a CUBE in data warehousing concept ?

 

 

Cubes are logical representation of multidimensional data. The name of "cube" is visually related to a 3 dimensional model, but we can have more than 3 dimensions.

 

 

Here is a 3 dimensional cube:

 

 

Cube, Dimensions

 

You can see that a cube has some dimensions. In this case we have 3 dimensions: product, location, time. In real life we can have more than 3 dimensions. In that case, inside a cube we can have another cubes.

 

A 3 dimensional cube is made of cubes. Each cube can be imagines as a sum of cubes.

 

Each cube store a value at the intersection of each dimension and that value is named measure. In that cube, 200, 100 are measures.

 

 

What is data cube technology used for ?

 

 This kind of representation allows one to view aggregated data from a number of perspectives. So, this is used for reporting.

 

In-Oracle.com  -> Oracle Data Warehouse & BI  -> Oracle Data Warehouse

-> Data Warehouse: cubes, dimensions

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.