An Alternative Data Warehouse Reference Architectural Configuration

  • Authors:
  • Victor González-Castro;Lachlan M. Mackinnon;María Pilar Angeles

  • Affiliations:
  • School of Mathematical and Computer Sciences, Heriot-Watt University, Edinburgh, Scotland EH14 4AS;School of Computing and Creative Technologies, University of Abertay Dundee, Dundee, Scotland DD1 1HG;Facultad de Ingeniería, Universidad Nacional Autónoma de México, México CP04510

  • Venue:
  • BNCOD 26 Proceedings of the 26th British National Conference on Databases: Dataspace: The Final Frontier
  • Year:
  • 2009

Quantified Score

Hi-index 0.00

Visualization

Abstract

In the last few years the amount of data stored on computer systems is growing at an accelerated rate. These data are frequently managed within data warehouses. However, the current data warehouse architectures based on n-ary-Relational DBMSs are overcoming their limits in order to efficiently manage such large amounts of data. Some DBMS are able to load huge amounts of data nevertheless; the response times become unacceptable for business users during information retrieval. In this paper we describe an alternative data warehouse reference architectural configuration (ADW) which addresses many issues that organisations are facing. The ADW approach considers a Binary-Relational DBMS as an underlying data repository. Therefore, a number of improvements have been achieved, such as data density increment, reduction of data sparsity, query response times dramatically decreased, and significant workload reduction with data loading, backup and restore tasks.