A horizontal fragmentation algorithm for the fact relation in a distributed data warehouse

  • Authors:
  • Amin Y. Noaman;Ken Barker

  • Affiliations:
  • Department of Computer Science, University of Manitoba, Winnipeg, Manitoba, Canada R3T 2N2;Department of Computer Science, University of Manitoba, Winnipeg, Manitoba, Canada R3T 2N2

  • Venue:
  • Proceedings of the eighth international conference on Information and knowledge management
  • Year:
  • 1999

Quantified Score

Hi-index 0.00

Visualization

Abstract

Data warehousing is one of the major research topics of appliedside database investigators. Most of the work to date has focused on building large centralized systems that are integrated repositories founded on pre-existing systems upon which all corporate-wide data are based. Unfortunately, this approach is very expensive and tends to ignore the advantages realized during the past decade in the area of distribution and support for data localization in a geographically dispersed corporate structure. This research investigates building distributed data warehouses with particular emphasis placed on distribution design for the data warehouse environment. The article provides an architectural model for a distributed data warehouse, the formal definition of the relational data model for data warehouse and a methodology for distributed data warehouse design along with a “horizontal” fragmentation algorithm for the fact relation.