Abstract
In recent years there has been a growing interest in the research community in the utilisation of alternative data models that abandon the relational record storage and manipulation structure. The authors have already reported experimental considerations of the behaviour of n-ary Relational, Binary-Relational, Associative and Transrelational models within the context of Data Warehousing [1], [2], [3] to address issues of storage efficiency and combinatorial explosion through data repetition. In this paper we present the results obtained during the industrial usage of Binary-Relational model based DBMS within a reference architectural configuration. These industrial results are similar to the ones obtained during the experimental stage of this research at the University laboratory [4] where improvements on query speed, data load and considerable reductions on disk space are achieved. These industrial tests considered a wide set of industries: Manufacturing, Government, Retail, Telecommunications and Finance.
Keywords
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
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
Gonzalez-Castro, V., MacKinnon, L.: Data Density of Alternative Data Models and its Benefits in Data Warehousing Environments. In: British National Conference on Databases BNCOD 22 Proceedings, Sunderland, England U.K., vol. 2, pp. 21–24 (2005)
Gonzalez-Castro, V., MacKinnon, L.M., Marwick, D.H.: An Experimental Consideration of the Use of the TransrelationalTMModel for Data Warehousing. In: Bell, D.A., Hong, J. (eds.) BNCOD 2006. LNCS, vol. 4042, pp. 47–58. Springer, Heidelberg (2006)
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 (November 2006), Special issue: Data Mining and Information Systems. Instituto Politécnico Nacional, Centro de Investigación en Computación, México, ISSN: 1870-4069
MonetDB web site, http://monetdb.cwi.nl/ (updated 20-March-2009)
Sybase Inc. Migrating from Sybase Adaptive Server Enterprise to SybaseIQ White paper USA (2005)
Codd, E.F.: The Relational Model for database Management Version 2. Addison Wesley Publishing Company, Reading (1990)
Poss, M., Potapov, D.: Data Compression in Oracle. In: Proceedings of the 29th VLDB conference, Berlin Germany (2003)
Gonzalez-Castro, V., MacKinnon, L.M., Angeles Maria del, P.: An Alternative Data Warehouse Reference Architectural Configuration. In: Proceedings of the 26th British National Conference on Databases, BNCOD 2009, Birmingham, UK (to be published)
Cognos Inc. website, http://www.cognos.com/ (updated 20-March-2009)
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). The Use of the Binary-Relational Model in Industry: A Practical Approach. 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_9
Download citation
DOI: https://doi.org/10.1007/978-3-642-02843-4_9
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)