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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Gonzalez-Castro, V., MacKinnon, L., Marwick, D.: A Performance Evaluation of Vertical and Horizontal Data Models in Data Warehousing. In: Olivares Ceja, J., Guzman Arenas, A. (eds.) Research in Computing Science, vol. 22, pp. 67–78 (2006), Special issue: Data Mining and Information Systems. Instituto Politécnico Nacional, Centro de Investigación en Computación, México, ISSN: 1870-4069
Datta, A., et al.: Curio: A Novel Solution for efficient Storage and Indexing in Data Warehouses. In: Proceedings 25th VLDB Conference, Edinburgh, Scotland, pp. 730–733 (2004)
Pendse, N.: Database Explosion. The OLAP Report, http://www.olapreport.com/DatabaseExplosion.htm (updated 10-March-2009)
Gonzalez-Castro, V., MacKinnon, L.: A Survey “Off the Record” –Using Alternative Data Models to Increase Data Density in Data Warehouse Environments. In: Lachlan, M., Burger Albert, G., Trinder Philip, W. (eds.) Proceedings of the 21st British National Conference on Databases BNCOD, Edinburgh, Scotland, vol. 2 (2004)
Codd, E.F.: The Relational Model for database Management Version 2. Addison Wesley Publishing Company, Reading (1990)
Gonzalez-Castro, V., MacKinnon, L.: Using Alternative Data Models in the context of Data Warehousing. In: Petratos, P., Michalopoulos, D. (eds.) 1st International Conference on Computer Science and Information Systems by the Athens Institute of Education and Research ATINER, Athens, Greece, pp. 83–100 (2005), ISBN-960-88672-3-1
Zukowski, M.: Improving I/O Bandwidth for Data-Intensive Applications. In: Proceedings BNCOD 2005, Sunderland, England U.K., vol. 2, pp. 33–39 (2005)
Pendse, N.: The OLAP survey 4, http://www.olapreport.com
MonetDB web site, http://monetdb.cwi.nl
Akadia website, http://www.akadia.com/services/ora_materialized_views.html
Acharya, S., et al.: Aqua: A Fast Decision Support System Using Approximate Query Answers. In: Proceedings 25 VLDB, Edinburgh, Scotland, pp. 754–757 (1999)
Shanmugasundaram, J., et al.: Compressed Data Cubes for OLAP aggregate Query Approximation on Continuous Dimensions. In: ACM KDD-1999, pp. 223–232 (1999)
Poss, M., Potapov, D.: Data Compression in Oracle. In: Proceedings of the 29th VLDB conference, Berlin Germany (2003)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2009 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
González-Castro, V., MacKinnon, L.M., del Pilar Angeles, M. (2009). An Alternative Data Warehouse Reference Architectural Configuration. In: Sexton, A.P. (eds) Dataspace: The Final Frontier. BNCOD 2009. Lecture Notes in Computer Science, vol 5588. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-02843-4_6
Download citation
DOI: https://doi.org/10.1007/978-3-642-02843-4_6
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-02842-7
Online ISBN: 978-3-642-02843-4
eBook Packages: Computer ScienceComputer Science (R0)