Data Warehouse Solution

Definition of data warehouse

• Data Warehouse and OLAP are basic element in decision support. Especially for companies that uses large complex database.
• Data Warehouse helps manager, executive and analyst for making decision faster and easier.
• Datawarehouse is gathered data from various sources and stored in large capacity repository.
• Data warehouse let users to check data history, analyze data and takes decision based on analysis given.

Benefit of data warehouse

• Ability to access and analyze large complex data.
• Ability to had consistent data.
• Faster analysis on data.
• Able to find company redundancy.
• Finding gap in business process and business knowledge.
• Minimize administration process.
• Increase productivity by giving access for employee access and analyze data

Characteristics of data warehouse

• Subject Oriented: Data warehouse focus on high-level business entity.
• Integrated : Data stored in consistent format (naming convention, domain constraint, physical attributes)
• Time variant: Data associated with time.
• Non-volatile: Data could not change with read only permission.

Design a datawarehouse

• Design data warehouse architecture, capacity planning, picking storage server, server OLAP, database, and required tools.
• Integrate server, storage and client tools.
• Design data warehouse scheme and views.
• Manage physical database, data placement, partition, accessing method
• Connect source using gateway, ODBC driver, etc
• Design and implement script for data extraction, cleaning, transform, load and refresh
• Integrate repository with schema and view, script and metadata
• Design end user application

Differences with Database Table

• Data warehouse is stable storage
• Data warehouse not always relational, but also multidimensional.
• Data warehouse provide integrated and temporal data in large more than one database

Data Model

• Star scheme that is used widely in OLAP
• Forms multi dimensional data compatible for business needs.

Star Scheme

• The center is fact table.
• Fact table consist of main indicator of Key Performance Indicator.
• Tabel around fact table is dimension table
• Each dimension table relates with fact table based on primary key
• Star scheme implemented using relational database.

Similar Posts:

None Found