Dimensional Modeling By Using a New Response to Slowly Changing Dimensions

Research output: Contribution to book/anthology/report/conference proceedingArticle in proceedingResearchpeer-review

56 Citations (Scopus)

Abstract

Dimensions are defined as dynamic or slowly changing if the attributes or relationships of a dimension can be updated. Aggregations to dynamic dimensions might be misleading if the measures are aggregated without regarding the changes of the dimensions. Kimball et al. has described three classic solutions/responses to handling the aggregation problems caused by slowly changing dimensions. In this paper, we will describe a fourth solution. A special aspect of our new response is that it should be used before the other responses, as it will change the design of the data warehouse. Afterwards, it may be necessary to use the classic responses to improve the design further.
Original languageEnglish
Title of host publicationProceedings of the Second International Conference on Information Technology
Publication date2005
Pages7-10
Publication statusPublished - 2005
EventInternational Conference on Information Technology - Amman, Jordan
Duration: 3 May 20055 May 2005
Conference number: 2

Conference

ConferenceInternational Conference on Information Technology
Number2
CountryJordan
CityAmman
Period03/05/200505/05/2005

Fingerprint

Agglomeration
Data warehouses

Cite this

Frank, L., Frank, C., Jensen, C. S., & Pedersen, T. B. (2005). Dimensional Modeling By Using a New Response to Slowly Changing Dimensions. In Proceedings of the Second International Conference on Information Technology (pp. 7-10)
Frank, L. ; Frank, C. ; Jensen, Christian Søndergaard ; Pedersen, Torben Bach. / Dimensional Modeling By Using a New Response to Slowly Changing Dimensions. Proceedings of the Second International Conference on Information Technology. 2005. pp. 7-10
@inproceedings{0fd6d49031c411db8de7000ea68e967b,
title = "Dimensional Modeling By Using a New Response to Slowly Changing Dimensions",
abstract = "Dimensions are defined as dynamic or slowly changing if the attributes or relationships of a dimension can be updated. Aggregations to dynamic dimensions might be misleading if the measures are aggregated without regarding the changes of the dimensions. Kimball et al. has described three classic solutions/responses to handling the aggregation problems caused by slowly changing dimensions. In this paper, we will describe a fourth solution. A special aspect of our new response is that it should be used before the other responses, as it will change the design of the data warehouse. Afterwards, it may be necessary to use the classic responses to improve the design further.",
author = "L. Frank and C. Frank and Jensen, {Christian S{\o}ndergaard} and Pedersen, {Torben Bach}",
year = "2005",
language = "English",
pages = "7--10",
booktitle = "Proceedings of the Second International Conference on Information Technology",

}

Frank, L, Frank, C, Jensen, CS & Pedersen, TB 2005, Dimensional Modeling By Using a New Response to Slowly Changing Dimensions. in Proceedings of the Second International Conference on Information Technology. pp. 7-10, International Conference on Information Technology, Amman, Jordan, 03/05/2005.

Dimensional Modeling By Using a New Response to Slowly Changing Dimensions. / Frank, L.; Frank, C.; Jensen, Christian Søndergaard; Pedersen, Torben Bach.

Proceedings of the Second International Conference on Information Technology. 2005. p. 7-10.

Research output: Contribution to book/anthology/report/conference proceedingArticle in proceedingResearchpeer-review

TY - GEN

T1 - Dimensional Modeling By Using a New Response to Slowly Changing Dimensions

AU - Frank, L.

AU - Frank, C.

AU - Jensen, Christian Søndergaard

AU - Pedersen, Torben Bach

PY - 2005

Y1 - 2005

N2 - Dimensions are defined as dynamic or slowly changing if the attributes or relationships of a dimension can be updated. Aggregations to dynamic dimensions might be misleading if the measures are aggregated without regarding the changes of the dimensions. Kimball et al. has described three classic solutions/responses to handling the aggregation problems caused by slowly changing dimensions. In this paper, we will describe a fourth solution. A special aspect of our new response is that it should be used before the other responses, as it will change the design of the data warehouse. Afterwards, it may be necessary to use the classic responses to improve the design further.

AB - Dimensions are defined as dynamic or slowly changing if the attributes or relationships of a dimension can be updated. Aggregations to dynamic dimensions might be misleading if the measures are aggregated without regarding the changes of the dimensions. Kimball et al. has described three classic solutions/responses to handling the aggregation problems caused by slowly changing dimensions. In this paper, we will describe a fourth solution. A special aspect of our new response is that it should be used before the other responses, as it will change the design of the data warehouse. Afterwards, it may be necessary to use the classic responses to improve the design further.

M3 - Article in proceeding

SP - 7

EP - 10

BT - Proceedings of the Second International Conference on Information Technology

ER -

Frank L, Frank C, Jensen CS, Pedersen TB. Dimensional Modeling By Using a New Response to Slowly Changing Dimensions. In Proceedings of the Second International Conference on Information Technology. 2005. p. 7-10