Article thumbnail
Location of Repository

An alternative data warehouse reference architectural configuration

By Victor González-Castro, Lachlan M. MacKinnon and María del Pilar Angeles

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

Topics: QA75
Publisher: Springer Berlin Heidelberg
Year: 2009
DOI identifier: 10.1007/978-3-642-02843-4
OAI identifier: oai:gala.gre.ac.uk:6468
Download PDF:
Sorry, we are unable to provide the full text but you may find it at the following location(s):
  • http://dx.doi.org/10.1007/978-... (external link)
  • http://www.gre.ac.uk/schools/c... (external link)
  • http://dx.doi.org/10.1007/978-... (external link)
  • Suggested articles


    To submit an update or takedown request for this paper, please submit an Update/Correction/Removal Request.