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

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

doi:10.1007/11788911_4

An experimental consideration of the use of the Transrelational^TM model for data warehousing

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

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution

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 Transrelational^TM 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 language	English
Title of host publication	Flexible and efficient information handling
Subtitle of host publication	23rd British National Conference on Databases, BNCOD 23, Belfast, Northern Ireland, UK, July 18-20, 2006: proceedings
Editors	David A. Bell, Jun Hong
Place of Publication	Berlin
Publisher	Springer Verlag
Pages	47-58
Number of pages	12
ISBN (Electronic)	9783540359715
ISBN (Print)	9783540359692
DOIs	https://doi.org/10.1007/11788911_4
Publication status	Published - 2006
Externally published	Yes
Event	23rd British National Conference on Databases - Belfast, United Kingdom Duration: 18 Jul 2006 → 20 Jul 2006 Conference number: 23

Publication series

Name	Lecture Notes in Computer Science (LNCS)
Publisher	Springer-Verlag
Volume	4042
ISSN (Print)	0302-9743

Conference

Conference	23rd British National Conference on Databases
Abbreviated title	BNCOD 2006
Country/Territory	United Kingdom
City	Belfast
Period	18/07/06 → 20/07/06

Keywords

Data warehousing

Access to Document

10.1007/11788911_4

Cite this

Gonzalez-Castro, V., MacKinnon, L. M., & Marwick, D. H. (2006). An experimental consideration of the use of the Transrelational^TM 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). Springer Verlag. https://doi.org/10.1007/11788911_4

Gonzalez-Castro, Victor ; MacKinnon, Lachlan M. ; Marwick, David H. / An experimental consideration of the use of the Transrelational^TM model for data warehousing. Flexible and efficient information handling: 23rd British National Conference on Databases, BNCOD 23, Belfast, Northern Ireland, UK, July 18-20, 2006: proceedings. editor / David A. Bell ; Jun Hong. Berlin : Springer Verlag, 2006. pp. 47-58 (Lecture Notes in Computer Science (LNCS)).

@inproceedings{d83a8930bf9b4107be10413f7bfeeccf,

title = "An experimental consideration of the use of the TransrelationalTM model for data warehousing",

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.",

author = "Victor Gonzalez-Castro and MacKinnon, {Lachlan M.} and Marwick, {David H.}",

year = "2006",

doi = "10.1007/11788911_4",

language = "English",

isbn = "9783540359692",

series = "Lecture Notes in Computer Science (LNCS)",

publisher = "Springer Verlag",

pages = "47--58",

editor = "Bell, {David A.} and Jun Hong",

booktitle = "Flexible and efficient information handling",

address = "Germany",

note = "23rd British National Conference on Databases, BNCOD 2006 ; Conference date: 18-07-2006 Through 20-07-2006",

}

Gonzalez-Castro, V, MacKinnon, LM & Marwick, DH 2006, An experimental consideration of the use of the Transrelational^TM model for data warehousing. in DA 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. Lecture Notes in Computer Science (LNCS), vol. 4042, Springer Verlag, Berlin, pp. 47-58, 23rd British National Conference on Databases, Belfast, United Kingdom, 18/07/06. https://doi.org/10.1007/11788911_4

An experimental consideration of the use of the Transrelational^TM model for data warehousing. / Gonzalez-Castro, Victor; MacKinnon, Lachlan M.; Marwick, David H.
Flexible and efficient information handling: 23rd British National Conference on Databases, BNCOD 23, Belfast, Northern Ireland, UK, July 18-20, 2006: proceedings. ed. / David A. Bell; Jun Hong. Berlin: Springer Verlag, 2006. p. 47-58 (Lecture Notes in Computer Science (LNCS); Vol. 4042).

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution

TY - GEN

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

AU - Gonzalez-Castro, Victor

AU - MacKinnon, Lachlan M.

AU - Marwick, David H.

N1 - Conference code: 23

PY - 2006

Y1 - 2006

N2 - 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.

AB - 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.

U2 - 10.1007/11788911_4

DO - 10.1007/11788911_4

M3 - Conference contribution

SN - 9783540359692

T3 - Lecture Notes in Computer Science (LNCS)

SP - 47

EP - 58

BT - Flexible and efficient information handling

A2 - Bell, David A.

A2 - Hong, Jun

PB - Springer Verlag

CY - Berlin

T2 - 23rd British National Conference on Databases

Y2 - 18 July 2006 through 20 July 2006

ER -

Gonzalez-Castro V, MacKinnon LM, Marwick DH. An experimental consideration of the use of the Transrelational^TM model for data warehousing. In Bell DA, Hong J, editors, Flexible and efficient information handling: 23rd British National Conference on Databases, BNCOD 23, Belfast, Northern Ireland, UK, July 18-20, 2006: proceedings. Berlin: Springer Verlag. 2006. p. 47-58. (Lecture Notes in Computer Science (LNCS)). doi: 10.1007/11788911_4