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 behavior of Relational, Binary Relational and Associative models within the context of Data Warehousing, to address issues of storage efficiency and combinatorial explosion through data repetition. In this paper we present an implementation of the TransrelationalTM model, based on the public domain definition provided by C.J. Date, which we believe to be the first reported instantiation of the model. Following the presentation of the implementation, we also present the results of performance tests utilising a set of metrics for Data Warehouse environments, which are compared against a traditional N-ary Relational implementation. The experiment is based on the standard and widely-accepted TPC-H data set.
The Transrelational model is based on the Tarin Transform Method and is the intellectual property of Required Technologies Inc.
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
Boncz, P.: Monet: A next generation DBMS Kernel for query intensive applications. PhD Thesis. Amsterdam (2002)
Copeland, G.P., Khoshafian, S.N.: A Decomposition Storage Model. In: Proceedings of the ACM SIGMOD Int’l. Conf. On Management of Data, pp. 268–279 (May 1985)
Date, C.J.: An introduction to Database Systems. Appendix A. In: The Transrelational Model, 8th edn., pp. 941–966. Addison Wesley, Reading (2004)
Gonzalez-Castro, V., MacKinnon, L.: A Survey “Off the Record” - Using Alternative Data Models to increase Data Density in Data Warehouse Environments. In: Williams, H., MacKinnon, L.M. (eds.) BNCOD 2004. LNCS, vol. 3112. Springer, Heidelberg (2004)
Gonzalez-Castro, V., MacKinnon, L.: Data Density of Alternative Data Models and its Benefits in Data Warehousing Environments. In: Jackson, M., Nelson, D., Stirk, S. (eds.) BNCOD 2005. LNCS, vol. 3567, pp. 21–24. Springer, Heidelberg (2005)
MonetDB. ©1994-2004 by CWI, http://monetdb.cwi.nl
Pendse, N.: Database explosion (updated, August 2003), http://www.olapreport.com
Gonzalez-Castro, V., Mackinnon, L.: Using Alternative Data Models in the Context of Data Warehousing. In: Petratos, P., Michalopoulos, D. (eds.) 2005 International Conference in Computer Science and Information Systems. Athens Institute of Education and Research, ATINER, Greece, vol. 1, pp. 83–100 (2005) ISBN: 960-88672-3-1
Stonebraker, M., et al.: C-Store: A column Oriented DBMS. In: Proceedings of the 31st VLDB conference, Trondheim, Norway, pp. 553–564 (2005)
SybaseIQ web site, http://www.sybase.com/products/informationmanagement/sybaseiq
Sybase Inc. Migrating from Sybase Adaptive Server Enterprise to SybaseIQ white paper. USA (2005)
TPC Benchmark H (Decision Support) Standard Specification Revision 2.1.0 (2002)
U.S. Patent and Trademark Office: Value-Instance-connectivity Computer-Implemented Database. U.S. Patent No. 6,009,432 (December 28, 1999)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Gonzalez-Castro, V., MacKinnon, L.M., Marwick, D.H. (2006). An Experimental Consideration of the Use of the TransrelationalTMModel for Data Warehousing. In: Bell, D.A., Hong, J. (eds) Flexible and Efficient Information Handling. BNCOD 2006. Lecture Notes in Computer Science, vol 4042. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11788911_4
Download citation
DOI: https://doi.org/10.1007/11788911_4
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-35969-2
Online ISBN: 978-3-540-35971-5
eBook Packages: Computer ScienceComputer Science (R0)