home 
 
 
 
ennl
 
Home
A propos
Services
Cours
Ressources
Contacts
MyABIS
Tous les coursbalkjeGénéralités » Introduction HW & SW » Cycles completsSystèmes d’exploitation » MVS - z/OS » UNIX - Linux - AIX » VMwareBases de données, systèmes transactionnels et middleware » DB2 for z/OS » DB2 UDB for Linux, UNIX and Windows » Oracle » SQL Server » MySQL » IMS » CICS » WebSphere MQ » WebSphere Application Server » Business intelligence et data warehouseDéveloppement d’applications » Méthodiques et techniques » TOGAF » PRINCE2 » Les langages de programmation » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesGestion de système » ITILbalkjeEn pratiqueInscriptions 
Cette page n'est pas disponible en français.
Dimensional modeling

Intended for

Designers of data warehouses.

Background

Basic understanding of relational database systems is required (see RDBMS concepts).

Training method

The theory will be illustrated by exercises. As the number of attendees is limited, all students will be individually coached during these exercises. Furthermore, an extra instructor will be present when needed. In this way, everyone will get optimal benefit from this course, even if there are differences in the background of the students.

Course leader

Harm van der Lek.

Duration

3 days.

Schedule

datelanguelieuprixremarques
06/03/2012NHilversum1890 EUR
05/06/2012NHilversum1890 EUR
Légende
  • Vous pouvez vous inscrire en cliquant sur les dates dans le calendrier.
  • N: Néerlandais; F: Français; E: Anglais; Sans code de langue: dépendant des participants.
  • Tous les prix sont hors TVA.
  • Pays:
    Belgique 
    Pays-Bas 
    Ailleurs 

Objectives

For the design of data structures of a data warehouse, star scheme techniques are becoming more important every day. This course treats dimensional modeling in detail, including the latest developments (e.g. data vault of Dan Lindstedt).

Main topics

  • Star schemes:

What is dimensional modeling? • Why a star scheme? • relational versus multidimensional databases • facts table, dimension tables • dimensions: causal, heterogeneous, monster, mini, degenerated • normalisation, denormalisation, snowflake schemes • pure star scheme versus snapshot.

  • History in a data warehouse:

Detail versus analytic attributes • mutations in dimensions, type 0 to 5 approach • minidimensions and history • transaction orientation versus state orientation • scheme changes through time

  • The OASI concept:

The One Attribute Set Interface • technical versus user dimensions • join navigation, aggregate navigation • OASI and heterogeneous dimensions

  • Design, starfinding:

DWH-Blueprint, evolutionary development • conform dimensions • sample - snapshot - adapting a star scheme • OLAP design • approach for dimensional modeling • starfinding

  • Advanced concepts:

Bridge tables • complex hierarchies • star schemes and meta-data • extraction, cleansing, transformation and loading

  • User disclosure:

Middleware • protection against 'runaway' queries • OLAP tools • report tools