Revista Facultad de Ingeniería Universidad de Antioquia
versão impressa ISSN 0120-6230
Data warehouses are usually modelled in a multidimensional way. The multidimensional models have dimensions composed by hierarchically organized levels according to their full containment. For example, in a geographical dimension with Department and Country levels, a department is fully contained into one country. Recently, a generalization of full containment has been proposed. It is known as the partial containment. For example, only a 20% of a highway could be contained into a department. In this paper we adopt a multidimensional model that supports partial containment. Our main contribution is to extend this model in order to support the change of the percentage of containment, because the percentage can change over time. To the best of our knowledge, this topic has not been examined in previous works. Our extension is also incorporated into a multidimensional query language, which enables what-if analysis in order to help decision-makers. In order to illustrate the improvements of our proposal, we present a study case related to car accidents.
Palavras-chave : Multidimensional models; data warehouses; full containment; partial containment; temporality.