People Innovation Excellence

What is Data Warehouse ?

Many companies already use Data Warehouse to manage their company data because Data warehouse can make their business process become easier to provide report to the management, because can support the company decision making process in an efficient way.

Definition of Data Warehouse                       

Data warehouse is a database that react with each other that can be used to query and analyst, is the orientation of the subject, integrated, time-variant, unchanged used to assist decision makers. Data warehouse is a method in the design of the database, which support the DSS (Decission Support System) and EIS (Executive Information System). Physically data warehouse is a database, but the data warehouse and database design is very different. In traditional database design using normalization, whereas the normalized data warehouse is not the best way.

Data Warehousing Tools and technologies – ETL Processes

Data warehouse has using ETL process to provide information to management by using this scheme :

To display the data, Data Warehouse extract data from transactional data and transform into the format which suitable with Enterprise, and load the data based on user requirement, that can be divided into several Data Marts.

The terms relating with data warehose

  1. Data Mart

Is a part of the data warehouse that supports the creation of report and analysis on a unit, section or the operation of a company. Data mart is created because people want to be easy to access the data that they use more often.

  1. On-Line Analytical Processing (OLAP)

Is a database processing that uses fact and dimension tables to display various kinds of reports, analyzes, queries of large-sized data.

  1. On-Line Transaction Processing (OLTP)

Is a processing that stores data on operational activities of daily transactions.

  1. Dimension Table

Table containing summaries categories with detailed data that can be reported. Such as profit on the fact table can be reported as the time dimension (in the form of monthly, and annual perkwartal).

  1. Fact Table

A table which generally contain only numbers and the history data in which the key (the key) that is produced is very unique, because it consists of the key foreign key (foreign key) which is the primary key (primary key) of some dimension tables are related.

  1. DSS

A system that provides information to the user that explains how this system can analyze the situation and support a good decision.

Reference :

https://www.google.co.id/url?sa=t&rct=j&q=&esrc=s&source=web&cd=7&ved=0ahUKEwjNrJehxuzUAhULo48KHXz2DQwQFghdMAY&url=http%3A%2F%2Fhanj.cs.illinois.edu%2Fbk3%2Fbk3_slides%2F04OLAP.ppt&usg=AFQjCNHaDTuUZ3utRaSPoD8r_KFinOXwoA


Published at :
Written By
Marisa Karsen
Subject & Content Coordinator Information Systems | School of Information Systems http://sis.binus.ac.id/
Leave Your Footprint

    Periksa Browser Anda

    Check Your Browser

    Situs ini tidak lagi mendukung penggunaan browser dengan teknologi tertinggal.

    Apabila Anda melihat pesan ini, berarti Anda masih menggunakan browser Internet Explorer seri 8 / 7 / 6 / ...

    Sebagai informasi, browser yang anda gunakan ini tidaklah aman dan tidak dapat menampilkan teknologi CSS terakhir yang dapat membuat sebuah situs tampil lebih baik. Bahkan Microsoft sebagai pembuatnya, telah merekomendasikan agar menggunakan browser yang lebih modern.

    Untuk tampilan yang lebih baik, gunakan salah satu browser berikut. Download dan Install, seluruhnya gratis untuk digunakan.

    We're Moving Forward.

    This Site Is No Longer Supporting Out-of Date Browser.

    If you are viewing this message, it means that you are currently using Internet Explorer 8 / 7 / 6 / below to access this site. FYI, it is unsafe and unable to render the latest CSS improvements. Even Microsoft, its creator, wants you to install more modern browser.

    Best viewed with one of these browser instead. It is totally free.

    1. Google Chrome
    2. Mozilla Firefox
    3. Opera
    4. Internet Explorer 9
    Close