TUTCRIS - Tampereen teknillinen yliopisto

TUTCRIS

Avoiding anomalies when modeling a many-to-many relationship in a multidimensional database

Tutkimustuotosvertaisarvioitu

Yksityiskohdat

AlkuperäiskieliEnglanti
OtsikkoBIR 2009 - 8th International Conference on Perspectives in Business Informatics Research
KustantajaKristianstad Academic Press
TilaJulkaistu - 2014
OKM-julkaisutyyppiA4 Artikkeli konferenssijulkaisussa
Tapahtuma8th International Conference on Perspectives in Business Informatics Research, BIR 2009 - Kristianstad, Ruotsi
Kesto: 1 lokakuuta 20092 lokakuuta 2009

Conference

Conference8th International Conference on Perspectives in Business Informatics Research, BIR 2009
MaaRuotsi
KaupunkiKristianstad
Ajanjakso1/10/092/10/09

Tiivistelmä

Multidimensional database cubes are easier to design and use when the dimension attributes and fact table measures are in one-to-many relation-ships in the data warehouse. The anomalies that can arise when users browse a cube that incorporates dimensions with many-to-many relationships are widely documented by practitioners. We categorise many-to-many relationships in terms of their associated design problems and we present two techniques for modelling restricted forms of many-to-many relationships. We demonstrate that the techniques can avoid anomalies and we discuss performance implications.