Datawarehouses [25 mn de lecture - paru le 8/28/2006 5:13:24 PM - Public : Débutant]

Auteur

Nicolas BEAUMONT Elève-Ingénieur Supinfo Paris Promotion SUPINFO 2006    Lui écrire    Tous les projets de cet auteur    Le mini-CV de cet auteur

Summary

In a world where the companies tend to be internationalized, the speed and the effectiveness of the decisions taken by the leaders play an important role. The datawarehouses are there to simplify this decision-making allowing to have a global vision of the companies’ performances.

Through this article, we will see what are the datawarehouses and why it becomes important to study the creation of it for its company.

Sommaire

• Introduction
• 1 – Some definitions
• 2 – The need of datawarehouses
• 3 – Concept of datawarehouses
• 3.1 Subject oriented
• 3.2 Integrated
• 3.3 Historised
• 3.4 Non-volatile
• 4 – Technical aspects
• 4.1 The database
• 4.2 Modeling
• 4.3 Structure
• 5 – Datawarehouse exploitation
• 5.1 ETL (Extract, Transform, Load)
• 5.2 Restitution tools
• Conclusion