Precise design of environmental data warehouses - INRAE - Institut national de recherche pour l’agriculture, l’alimentation et l’environnement Access content directly
Journal Articles Operational Research Year : 2010

Precise design of environmental data warehouses


People use data warehouses to help them make decisions. For example, public policy decision-makers can improve their decisions by using this technology to analyze the environmental effects of human activity. In production systems, data warehouses provide structures for extracting the knowledge required to optimize systems. Designing data warehouses is a complex task; designers need flexible and precise methods to help them create data warehouses and adapt their analysis criteria to developments in the decision-making process. In this paper, we introduce a flexible method based on UML (Unified Modeling Language). We introduce a UML profile for building multi-dimensional models and for choosing different criteria according to analysis requirements. This profile makes it possible to specify integrity constraints in OCL (Object Constraint Language). We apply our method to the construction of an environmental system for analyzing the use of certain agricultural fertilizers. We integrate various data sources into a multi-dimensional model showing several categories of analysis, and the consistency of data can be checked with OCL constraints.
Fichier principal
Vignette du fichier
CF2010-PUB00027892.pdf (1.14 Mo) Télécharger le fichier
Origin : Files produced by the author(s)

Dates and versions

hal-00518410 , version 1 (05-10-2010)



François Pinet, Michel Schneider. Precise design of environmental data warehouses. Operational Research, 2010, 10 (3), p. 349 - p. 369. ⟨10.1007/s12351-009-0069-z⟩. ⟨hal-00518410⟩
132 View
181 Download



Gmail Facebook X LinkedIn More