Data Warehouse Objectives

* Increase the efficiency of data management related to the perfomance of financial institution and financial policy
* Set up database as a central office for storing data for economic, financial institutions and markets
* Ability to collect and share information from diffrent sources
* Increase the process efficiency in data management
* Improve the quality of the infomation
* Ability to distribute the information to the internal and external user

What Is Data Warehouse

Data warehousing is the design and implementation of processes, tools, and facilities to manage and deliver complete, timely, accurate, and understandable information for decision making. It includes all the activities that make it possible for an organization to create, manage, and maintain a data warehouse or data mart.

Data Warehouse Database Design Challenges

There are certain challenges should be solved in order to complete data warehouse database design,
* Query requirements
* Data restructuring
* Response times
* Managing data volumes
* Operating costs and interfaces
* Controlling interfaces and tools
*Backup and restore

Data Warehouse Database Design Tasks

* Describe enterprise-level strategic analysis tasks.
* Define components of business modeling.
* Discuss the role of metadata in the data warehouse and methods of tracking metadata.
* Define a logical model and entity relationship modeling.

Data warehouse features

* Data warehouse is a repository for information,
It integrate data and gives broader access to different kind of data user from many different management level/division.
* Data warehouse guarantee integrity and quality of data.
This integrity is important since data warehouse is designed to provides a historical perspective/views.
* Data warehouse designed to reduce reporting and analysis process in main operational system.
Operational system is dedicated to support daily business process.
* Data warehouse is to serve backoffice and management reporting and analysis requirement, and decision suppport system if any.
This last feature make data warehouse requires a major system integration effort.

Database design functions

a data warehouse database design must:
* focus on queries
* allow incremental development
* Have non-volatile structure
* Provide historical data

Data warehouse elements

Data warehouse has some basic key or elements:
* source, from which data warehouse get amount of data it stored.
* data staging area, is an intermediate area in which data from source transformed and ready to load to a target database/container.
* target, is a presentation server for the new data warehouse or data mart.