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

5. Metadata.

Metadata includes definitions on used items, (aggregates, fact tables), of the target data base, on the data itself, and the way they are extracted, calculated, and inserted in target tables and columns. Our metadata repository being a 55 page document, is listed here with only a few general notions.

Academic year: it's a key concept of the DWH. For most of extracted data, the reference year is the academic year, except for the financial data, where it is the calendar year. The existence of two reference periods is one of the difficulties of the DWH building and querying.

Course: the educational organization is tree-structured. Only terminal elements of the tree-structure are used for calculations.

Faculty, school: some of them do not appear in all the source application. The structure of the institution and the codes can also be different. A common "institution structure" table, with source and structure links, has been added to the DWH tables.

Teaching units: the payment of teaching hours for an associate professor depends on what is done: lectures,tutorials,labs, and on the teacher's rank.



© 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