Data warehouse

Question 1

Definition of data warehouse

Answer 1

A data warehouse is a subject-orientated, integrated, time variant and non-volatile collection of data in support of managements decision making process

They provide a solid platform if consolidated historical data for analysis.

Question 2

Main terms of data warehouse

Answer 2

Subject-orientated
integrated
Time-variant
non-volatile

Question 3

Data warehouses are constructed via:

Answer 3

Data cleaning
Data transformation
Data integration
Data Loading

Question 4

Data webhouse

Answer 4

The data warehouse has been forced to adapt new requirements for webbased data hence the development of the web warehouse.
Web offers an immense source of data about people who use their browser to interact on websites.
Data mining techniques can be implemented to determine patterns.

Question 5

Data Marts

Answer 5

Focuses on selected subjects.
A thematic data base originaly orientated towards the marketing field.
Designed to answer specific quations for a specific set of users.