SPLITTING FACTS USING WEIGHTS

Liga Grundmane, Laila Niedrite

2006

Abstract

A typical data warehouse report is the dynamic representation of some objects’ behaviour or changes of objects’ properties. If this behaviour is changing, it is difficult to make such reports in an easy way. It is possible to use the fact splitting to make this task simpler and more comprehensible for users. In the presented paper two solutions of splitting facts by using weights are described. One of the possible solutions is to make the proportional weighting accordingly to splitted record set size. It is possible to take into account the length of the fact validity time period and the validity time for each splitted fact record.

References

  1. Abelló, A., Samos, J., and Saltor, F. 2001. Understanding facts in a multidimensional object-oriented model. In: Proc. of the 4th ACM international Workshop on Data Warehousing and OLAP. ACM Press, 32-39.
  2. Abelló, A., Martin C. 2003. A Bitemporal Storage Structure for a Corporate Data Warehouse. In: Proc. of the 5th Int. Conf. of Enterprise Information Systems (ICEIS 2003), 177-183.
  3. Chen, C., Cochinwala, M., and Yueh, E. 1999. Dealing with slow-evolving fact: a case study on inventory data warehousing. In: Proc. of the 2nd ACM international Workshop on Data Warehousing and OLAP. ACM Press, 22-29.
  4. Eder, J. , Koncilia, C. , and Kogler, H. 2002. Temporal data warehousing: business cases and solutions. In: Proc. of the International Conference on Enterprise Information Systems (ICEIS'02), Spain, 81-88.
  5. Hüsemann, B. , Lechtenbörger, J., and Vossen., G. 2000. Conceptual Data Warehouse Design. In Proc. of the International Workshop on Design and Management of Data Warehouses (DMDW 2000), CEUR-WS (www.ceur-ws.org).
  6. Inmon, W.H.. 1996. Building the Data Warehouse, John Wiley.
  7. Jarke, M., Lanzerini, M., and Vassiliou, Y. 2002. Fundamentals of Data Warehouses, Berlin:Springer.
  8. Kimball, R. 1996. The Data Warehouse Toolkit: Practical Techniques for building Dimensional Data Warehouses. Jon Wiley & Sons.
  9. Kimball, R., Reeves, L., Ross, M., and Tthornthwaite, W., 1998. The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses, New York: Jon Wiley & Sons.
  10. Kimball, R. and Ross M., 2002. The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, John Wiley.
  11. Song, I.-Y. , Rowen, W. , Medsker, C. , and Ewen,E. 2001. An Analysis of Many-to-Many Relationships Between Fact and Dimension Tables in Dimensional Modeling. In Proc. of the Int. Workshop on Design and Management of Data Warehouses (DMDW'2001). CEUR-WS (www.ceur-ws.org).
Download


Paper Citation


in Harvard Style

Grundmane L. and Niedrite L. (2006). SPLITTING FACTS USING WEIGHTS . In Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-972-8865-41-2, pages 253-258. DOI: 10.5220/0002447402530258


in Bibtex Style

@conference{iceis06,
author={Liga Grundmane and Laila Niedrite},
title={SPLITTING FACTS USING WEIGHTS},
booktitle={Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2006},
pages={253-258},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002447402530258},
isbn={978-972-8865-41-2},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - SPLITTING FACTS USING WEIGHTS
SN - 978-972-8865-41-2
AU - Grundmane L.
AU - Niedrite L.
PY - 2006
SP - 253
EP - 258
DO - 10.5220/0002447402530258