An alternative data warehouse reference architectural configuration

González-Castro, Victor, MacKinnon, Lachlan M. and del Pilar Angeles, María (2009) An alternative data warehouse reference architectural configuration. Lecture Notes in Computer Science, 5588. pp. 33-41. ISSN 0302-9743 (Print), 1611-3349 (Online) (doi:10.1007/978-3-642-02843-4_6)

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.

Actions (login required)