SciELO - Scientific Electronic Library Online

 
vol.31 issue1Anaerobic treatment of lactic waste and goat manureHydroinformatics’ contributionto Amazonian water resources and ecosystem management author indexsubject indexarticles search
Home Pagealphabetic serial listing  

Services on Demand

Journal

Article

Indicators

Related links

  • On index processCited by Google
  • Have no similar articlesSimilars in SciELO
  • On index processSimilars in Google

Share


Ingeniería e Investigación

Print version ISSN 0120-5609

Abstract

MORENO, Francisco  and  ARANGO, Fernando. Operators for reclassification que- queries in a temporal multidimensio- ries multidimensional model. Ing. Investig. [online]. 2011, vol.31, n.1, pp.99-107. ISSN 0120-5609.

Data warehouse dimensions are usually considered to be static because their schema and data tend not to change; however, both dimension schema and dimension data can change. This paper focuses on a type of dimension data change called reclassification which occurs when a member of a certain level becomes a member of a higher level in the same dimension, e.g. when a product changes category (it is reclassified). This type of change gives rise to the notion of classification period and to a type of query that can be useful for decision-support. For example, What were total chess-set sales during first classification period in Toy category? A set of operators has been proposed to facilitate formulating this type of query and it is shown how to incorporate them in SQL, a familiar database developer language. Our operators´ expressivity is also shown because formulating such queries without using these operators usually leads to complex and nonintuitive solutions.

Keywords : temporal data warehouse; OLAP; reclassification; classification period.

        · abstract in Spanish     · text in English | Spanish     · Spanish ( pdf )

 

Creative Commons License All the contents of this journal, except where otherwise noted, is licensed under a Creative Commons Attribution License