home 
 
 
 
ennl
 
Home
A propos
Services
Cours
Ressources
Contacts
MyABIS
C
Tous les coursbalkjeGénéralités » Introduction HW & SW » Soft skills » Cycles completsSystèmes d’exploitation » MVS - z/OS » Linux - UNIX » Mac OS X » iPad et iPhone iOSBases de données et middleware » Relational databases & SQL » Db2 for z/OS » Db2 for LUW » Oracle » SQL Server » MySQL & MariaDB » IMS » CICS » IBM MQ » WebSphere » Data Science, Big Data et AnalyticsDéveloppement d’applications » Méthodiques et techniques » TOGAF » PRINCE2 » Agile et Scrum » Les langages de programmation » Internet development » Object Oriented systems » Java » Development tools » SAS » XML » SOA & web servicesGestion de système » ITIL » SecuritybalkjeEn pratiqueInscriptions 
Cette page n'est pas disponible en français.
Dimensional modeling

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).

Schedule

dateduréelang.  lieu  prix
12 Dec3NHilversum  (NL)2120 EUR  (exempte de TVA) 
03 Apr3NHilversum  (NL)2120 EUR  (exempte de TVA) 
04 Sep3NHilversum  (NL)2120 EUR  (exempte de TVA) 
11 Dec3NHilversum  (NL)2120 EUR  (exempte de TVA) 
INFO SESSION ET INSCRIPTION

Intended for

Designers of data warehouses.

Background

Basic understanding of relational database systems is required (see SQL and relational databases fundamentals).

Main topics

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.

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 One Attribute Set Interface • technical versus user dimensions • join navigation, aggregate navigation • OASI and heterogeneous dimensions

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

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

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

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.

Duration

3 days.

Course leader

Harm van der Lek.

Aussi intéressant

Participants de ce cours ont aussi suivi les formations suivantes:


INFO SESSION ET INSCRIPTION