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)Full text not available from this repository.
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.
|Additional Information:|| First published: 2009.  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.  Also given ISBN: 978-3-642-02842-7 (Print); 978-3-642-02843-4 (Online).  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|
|School / Department / Research Groups:||School of Computing & Mathematical Sciences|
|Last Modified:||08 Jul 2013 09:47|
Actions (login required)