Construction graphique d'entrepôts et de magasins de données

Nowadays, decisional systems have became a significant research topic in databases. Data warehouses and data marts are the main elements of such systems. This paper presents our decisional support system. We present graphical interfaces which help the administrator to build data warehouses and data marts. We present a data warehouse building interface based on an object-oriented conceptual model. This model allows the warehouse data historisation at three levels: attribute, class and environment. Also, we present a data mart building interface which allows warehouse data to be reorganised through a multidimensional object-oriented model.

[1]  Sushil Jajodia,et al.  Logical design for temporal databases with multiple granularities , 1997, TODS.

[2]  Jennifer Widom,et al.  Maintaining Temporal Views over Non-Temporal Information Sources for Data Warehousing , 1998, EDBT.

[3]  Surajit Chaudhuri,et al.  An overview of data warehousing and OLAP technology , 1997, SGMD.

[4]  Matteo Golfarelli,et al.  Conceptual design of data warehouses from E/R schemes , 1998, Proceedings of the Thirty-First Hawaii International Conference on System Sciences.

[5]  Gultekin Özsoyoglu,et al.  Towards a unified visual database access , 1993, SIGMOD '93.

[6]  Inderpal Singh Mumick,et al.  The Stanford Data Warehousing Project , 1995 .

[7]  Jennifer Widom,et al.  Research problems in data warehousing , 1995, CIKM '95.

[8]  Wojciech Cellary,et al.  Formal Model of an Object-Oriented Database with Versioned Objects and Schema , 1991, DEXA.

[9]  Jennifer Widom,et al.  View maintenance in a warehousing environment , 1995, SIGMOD '95.

[10]  Sunita Sarawagi,et al.  Modeling multidimensional databases , 1997, Proceedings 13th International Conference on Data Engineering.

[11]  José Samos,et al.  Database Architecture for Data Warehousing: An Evolutionary Approach , 1998, DEXA.

[12]  Eric Andonoff,et al.  Interrogation de bases de données intégrant des versions , 1997, INFORSID.

[13]  Jennifer Widom,et al.  A System Prototype for Warehouse View Maintenance , 1996, VIEWS.

[14]  Laks V. S. Lakshmanan,et al.  A Foundation for Multi-dimensional Databases , 1997, VLDB.

[15]  Matthias Jarke,et al.  Architecture and Quality in Data Warehouses , 1998, CAiSE.

[16]  Franck Ravat.  La fragmentation d'un schéma conceptuel orienté objet , 1995, INFORSID.

[17]  F. Staes,et al.  A graphical query language for object oriented databases , 1991, Proceedings 1991 IEEE Workshop on Visual Languages.

[18]  Eric Andonoff,et al.  Hypertext interface for an object-oriented database , 1991, RIAO.