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

Université de Grenoble and Agence de Modernisation des Universités, Paris, France

Jean-Francois.Desnos@grenet.fr

Chef de Departement, CICG, Universités de Grenoble BP 53, 38041 Grenoble Cedex 9, France

http://www.grenet.fr

Keywords:
data warehouse, executive information system, French universities, prototype

Abstract

This paper presents the French universities national data warehouse project, which was begun in 1999. The Source databases are the administrative systems, and the target data base, or, data warehouse, is designed to be the executive information system of the institution. Pilot universities in Amiens, Paris, Rennes, Strasbourg, and Versailles are presently testing the prototype. A first release will be done in 2002 for other interested institutions.


Table of Contents

Front pageA National Data Warehouse Project for French Universities
1 Introduction.
2 The steps of the project.
3 The specifications.
4 The target database.
5 Metadata.
6 Data Stage job example: loading the budget in the BUDGET target table.
7 Target queries.
8 Conclusion.
9 Acknowledgements.
Bibliography Bibliography.

Table of Figures

Figure 1: Some key-numbers for a given field of studies


© 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