Skip navigation

An alternative data warehouse reference architectural configuration

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:https://doi.org/10.1007/978-3-642-02843-4_6)

Full text not available from this repository.

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.

Item Type: Article
Additional Information: [1] First published: 2009. [2] Published as: 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. [3] Also given ISBN: 978-3-642-02842-7 (Print); 978-3-642-02843-4 (Online). [4] Book title: Dataspace: The Final Frontier, edited by Alan P. Sexton - with subtitle: 26th British National Conference on Databases, BNCOD 26, Birmingham, UK, July 7-9, 2009. Proceedings.
Uncontrolled Keywords: alternative data model, data warehouse, binary-relational, architectural configuration, database explosion, column DBMS
Subjects: Q Science > QA Mathematics > QA75 Electronic computers. Computer science
Pre-2014 Departments: School of Computing & Mathematical Sciences
Related URLs:
Last Modified: 14 Oct 2016 09:16
Selected for GREAT 2016: None
Selected for GREAT 2017: None
Selected for GREAT 2018: None
Selected for GREAT 2019: None
URI: http://gala.gre.ac.uk/id/eprint/6468

Actions (login required)

View Item View Item