Week 4

I learned about the different designs of Data warehouse: Star schema, snowflake schema and constellation schema. Also the different types of OLAP cube: ROLAP, MOLAP and HOLAP.

The software available for Data warehouse is Oracle Data Warehousing:
http://www.oracle.com/us/solutions/datawarehousing/index.htm

Below are websites that gives detailed information on the different OLAP cubes:
http://www.1keydata.com/datawarehousing/molap-rolap.html

http://www.geekinterview.com/question_details/271

I also learned that there is another type of OLAP cube called the DOLAP which is Desktop Online Analytical Process. The OLAP that communicates with Desktop Databases to retrieve the data.