Session B: Information Systems and Data Warehouse
Jean-François DESNOS: A National Data Warehouse Project for French Universities

4. The target database.

The target or data warehouse itself is a ROLAP Oracle 8i database, designed the following way:

4.1 Four principal tables: STUDENT, PERSONNEL, BUDGET, and HC, (HC is made of extractions from payroll). Each of these tables gathers information from the various operational applications.

4.2 A number of wording and aggregate tables. Columns of aggregate tables are calculated during the loading process: for example the number of professors in a given field.

4.3 Two "service" tables:

In these tables the value of an indicator is a number (derived from a boolean) the value of which is 0 (false) or 1 (true). Indicators will simplify the scorings with Business Objects.

The STUDENT and its subsidiary tables are figured thereunder as an example, avoiding specific French system data.

<SPAN CLASS=@ITALIC@>STUDENT and subsidiary tables.</SPAN>


© This publication and its compilation in form and content is copyrighted. Every realization which is not explicitly allowed by copyright law requires a written agreement. Especially, this holds for reprography and processing / storing by electronic systems.

EUNIS Proceeding DTD Version 1.0
HTML - Version create: Fri Mar 23 15:28:59 2001