TY - GEN
T1 - An alternative data warehouse reference architectural configuration
AU - González-Castro, Victor
AU - MacKinnon, Lachlan M.
AU - Del Pilar Angeles, María
PY - 2009
Y1 - 2009
N2 - 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. © 2009 Springer Berlin Heidelberg.
AB - 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. © 2009 Springer Berlin Heidelberg.
KW - Alternative Data Model
KW - Architectural Configuration
KW - Binary-Relational
KW - Column DBMS
KW - Data Warehouse
KW - Database Explosion
UR - http://www.scopus.com/inward/record.url?scp=70350638593&partnerID=8YFLogxK
U2 - 10.1007/978-3-642-02843-4_6
DO - 10.1007/978-3-642-02843-4_6
M3 - Conference contribution
SN - 364202842X
SN - 9783642028427
VL - 5588 LNCS
T3 - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
SP - 33
EP - 41
BT - Dataspace: The Final Frontier - 26th British National Conference on Databases, BNCOD 26, Proceedings
T2 - 26th British National Conference on Databases
Y2 - 7 July 2009 through 9 July 2009
ER -