Getting Started Learning Data Warehouse

In my university (trunojoyo) Data Warehouse is one of choice subject for computer sains, if we learn about data warehouse, first of all, you need to know about the basic of Database and everything about it. i really confused when first time learning about data warehouse it self. Basically the meaning of data warehouse is a collection of data from many kinds of sources that is used to be analyzed and getting decision from that analyzes. For example, a company which has several branches in some places. The manager wants to get the result of transactional process quickly and making good decision for the future of the company. So, the data of transactional process is a kind of history data that is collected about 3 until 5 years in the past. By this kind of analyze the manager is able to get information quickly and correctly without typing query into database before.

Basically here is the process of data warehouse :

OLTP (collection of database)  –> Data Staging /ETL (Extraction – transformation – loading) –> OLAP (analize data warehouse).

Alright, i will explain  one by one the whole process. first, OLTP (OnLine Transactional Processing) means collection of several data from a company. this is not a common data but, this is transactional data that is always increase everyday/ every times.

Next process is Data Staging. It means process to bring OLTP into Data Warehouse. This proces contains of Extraction, transformation and Loading. Extraction is process to extract database into used tools. Transformation means process to transform data that is different from several database in order to be same. And Loading means process to pick database into data warehouse. In ETL process we can use many kinds of avaible tools.

Last Process is  Analyze process. In this step we need to use OLAP (Online Analytical Processing) tools to do. In this step we can get the result of data warehouse and what do we want on it.

That’s all a little bit about Data Warehouse. If you would like to learn more, you can see the following links

  1. http://en.wikipedia.org/wiki/Data_warehouse
  2. http://www.pentaho.com/explore/pentaho-data-integration/
  3. http://www.dwinfocenter.org/
  4. http://www.oracle.com/us/solutions/datawarehousing/index.html
  5. http://www-01.ibm.com/software/data/infosphere/warehouse/
  6. and many more….

Tagged:

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: