EXPERIMENTAL EVIDENCE ON DATA WAREHOUSE FRAGMENTATION AND ALLOCATION IN A DISTRIBUTED CONTEXT

Tekaya Karima, Abdellaziz Abdelatif, Habib Ounalli

Abstract

Since a relational data warehouse has the same physical structure as a classical database, it can enjoy all the benefits realized during the past in distributed databases such us data availability, simplicity, rapid local data access and transparent access to remote sites. So, it would be interesting to test its decentralization by adapting the most adequate fragmentation and allocation technique. In this paper, we present a data warehouse fragmentation and allocation approach in a distributed context. We conduct first, computation studies using a mathematical cost model. Then, we test our approach on a real data warehouse by using the APB1 benchmark data set on Oracle11G.

References

  1. Bellatreche, L., & Boukhalfa, K., 2005, An Evolutionary Approach to Schema Partitioning Selection in a Data Warehouse, In DAWAK'07, 7th International Conference on Data Warehousing and Knowledge Discovery. Volume 3589 of LNCS,
  2. Chakravarthy S., et al., 1992. An objective function for vertically partitioning relations in distributed databases and its analysis, Distributed and Parallel Databases journal.
  3. Ciferri, C. D. A. & Souza, F., 2002, Focusing on Data Distribution in the WebD2W System. In DAWAK'02, 4th International Conference on Data Warehousing and Knowledge Discovery, Vol. 2454 of LNCS.
  4. Ciferri, C. D. A., et al., 2007. Horizontal fragmentation as a technique to improve the performance of drill-down and roll-up queries. In SAC'07, 22nd ACM Symposium on Applied Computing.
  5. Costa, M. & Madeira, H., 2004. Handling Big Dimensions in Distributed Data Warehouses using the DWS Technique. In DOLAP'04, 7th ACM Eleventh International Workshop on Data Warehousing and OLAP.
  6. Datta, A. & Ramamritham, K., & Thomas, H. M., 1999. Curio: A Novel Solution for Efficient Storage and Indexing in Data Warehouses. In VLDB'99, 25th International Conference on Very Large Data Bases.
  7. Furtado, P., 2004. Workload-based Placement and Join Processing in Node-Partitioned Data Warehouses. In DaWaK'04, 6th International Conference on Data Warehousing and Knowledge Discovery., p. 38-47.
  8. Golfarelli, M., Maio, D. & Rizzi, S., 1999. Vertical fragmentation of views in relational data warehouses. SEDB'99. In Settimo Convegno Nazionale su Sistemi Evoluti Per Basi Di Dati.
  9. Jain, A. & Dubes, R., 1988. Agorithms for clustering Data. Prentice Hall Advanced Reference Series, Englewood Cliffs, NJ.
  10. Noaman, A. Y. & Barker, K., 1997. Distributed data warehouse architectures. Journal of Data Warehousing. Vol. 2.
  11. Noaman, A. Y., Barker, K., 1999. A Horizontal Fragmentation Algorithm for the fact relation in a Distributed Data Warehouse. In ICKM'99, 8th International Conference on Information and Knowledge Management.
  12. OLAP Council, 1998. Apb-1 olap Benchmark, release 2. http://www.olapcouncil.org/research/bmarkly.htm.
  13. Ozsu, M. T. & Valduriez, P., 1991. Principles of Distributed Database Systems. (pp. 657). PrenticeHall, Inc. Upper Saddle River, NJ, USA
  14. Wehrle, P., Miquel, M. & Tchounikine, A., 2005. A Model for Distributing and Querying a Data Warehouse on a Computing Grid. In ICPADS'05, 11th International Conference on Parallel and Distributed Systems. IEEE Computer Society.
  15. Wu, M.-C. & Buchmann, A. P., 1997. Research Issues in Data Warehousing. In Datenbanksysteme in Buro, Technik und Wissenschaft, pages 61-82.
Download


Paper Citation


in Harvard Style

Karima T., Abdelatif A. and Ounalli H. (2010). EXPERIMENTAL EVIDENCE ON DATA WAREHOUSE FRAGMENTATION AND ALLOCATION IN A DISTRIBUTED CONTEXT . In Proceedings of the International Conference on Knowledge Management and Information Sharing - Volume 1: KMIS, (IC3K 2010) ISBN 978-989-8425-30-0, pages 102-110. DOI: 10.5220/0003104801020110


in Bibtex Style

@conference{kmis10,
author={Tekaya Karima and Abdellaziz Abdelatif and Habib Ounalli},
title={EXPERIMENTAL EVIDENCE ON DATA WAREHOUSE FRAGMENTATION AND ALLOCATION IN A DISTRIBUTED CONTEXT},
booktitle={Proceedings of the International Conference on Knowledge Management and Information Sharing - Volume 1: KMIS, (IC3K 2010)},
year={2010},
pages={102-110},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003104801020110},
isbn={978-989-8425-30-0},
}


in EndNote Style

TY - CONF
JO - Proceedings of the International Conference on Knowledge Management and Information Sharing - Volume 1: KMIS, (IC3K 2010)
TI - EXPERIMENTAL EVIDENCE ON DATA WAREHOUSE FRAGMENTATION AND ALLOCATION IN A DISTRIBUTED CONTEXT
SN - 978-989-8425-30-0
AU - Karima T.
AU - Abdelatif A.
AU - Ounalli H.
PY - 2010
SP - 102
EP - 110
DO - 10.5220/0003104801020110