Type 2 slowly changing dimensions: a case study using the cooperating system

  • Authors:
  • Craig W. Stanfill

  • Affiliations:
  • Ab Initio Software LLC, Lexington, MA, USA

  • Venue:
  • Proceedings of the fifteenth international workshop on Data warehousing and OLAP
  • Year:
  • 2012

Quantified Score

Hi-index 0.00

Visualization

Abstract

The CoOperating System - a parallel and distributed enterprise computing platform based on dataflow - is applied to the management of Type 2 slowly changing dimensions. Five different solutions, using merge join, hybrid hash join, lookup files, SQL, and stored procedures are implemented and evaluated. Solutions to important but often neglected aspects of such systems, such as auditing and error handling are also described. The solutions are evaluated based on scalability and performance and are found to scale up to the limits of the platform.