An experimental consideration of the use of the TransrelationalTM model for data warehousing

Victor Gonzalez-Castro, Lachlan M. MacKinnon, David H. Marwick

Research output: Chapter in Book/Report/Conference proceedingConference contribution

1 Citation (Scopus)

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.
Original languageEnglish
Title of host publicationFlexible and efficient information handling
Subtitle of host publication23rd British National Conference on Databases, BNCOD 23, Belfast, Northern Ireland, UK, July 18-20, 2006: proceedings
EditorsDavid A. Bell, Jun Hong
Place of PublicationBerlin
PublisherSpringer Verlag
Pages47-58
Number of pages12
ISBN (Electronic)9783540359715
ISBN (Print)9783540359692
DOIs
Publication statusPublished - 2006
Event23rd British National Conference on Databases - Belfast, United Kingdom
Duration: 18 Jul 200620 Jul 2006
Conference number: 23

Publication series

NameLecture Notes in Computer Science (LNCS)
PublisherSpringer-Verlag
Volume4042
ISSN (Print)0302-9743

Conference

Conference23rd British National Conference on Databases
Abbreviated titleBNCOD 2006
CountryUnited Kingdom
CityBelfast
Period18/07/0620/07/06

    Fingerprint

Cite this

Gonzalez-Castro, V., MacKinnon, L. M., & Marwick, D. H. (2006). An experimental consideration of the use of the TransrelationalTM model for data warehousing. In D. A. Bell, & J. Hong (Eds.), Flexible and efficient information handling: 23rd British National Conference on Databases, BNCOD 23, Belfast, Northern Ireland, UK, July 18-20, 2006: proceedings (pp. 47-58). (Lecture Notes in Computer Science (LNCS); Vol. 4042). Berlin: Springer Verlag. https://doi.org/10.1007/11788911_4