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:

• The "structure of the university" table. This table gives a unique code to each faculty member, and each school of the university. This is necessary because all of the operational source application has its own code and wording.
• The "observation dates" table. This table will permit the extraction of Business Objects in different layers for each of the source databases. This means that it can be edited as a report based on: the snapshot on 15/01/2001 of the student system, and the snapshot on 01/01/2001 of the financial system, etc...

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.

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