An experimental consideration of the use of the transrelational™ model for data warehousing

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

Research output: Chapter in Book/Report/Conference proceedingConference 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™ 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. © Springer-Verlag Berlin Heidelberg 2006.

Original languageEnglish
Title of host publicationFlexible and Efficient Information Handling - 23rd British National Conference on Databases, BNCOD 23, Proceedings
Pages47-58
Number of pages12
Volume4042 LNCS
Publication statusPublished - 2006
Event23rd British National Conference on Databases - Belfast, Northern Ireland, United Kingdom
Duration: 18 Jul 200620 Jul 2006

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume4042 LNCS
ISSN (Print)0302-9743

Conference

Conference23rd British National Conference on Databases
Abbreviated titleBNCOD 23
CountryUnited Kingdom
CityBelfast, Northern Ireland
Period18/07/0620/07/06

Fingerprint

Data warehouses
Explosions
Data structures
Experiments

Cite this

Gonzalez-Castro, V., MacKinnon, L. M., & Marwick, D. H. (2006). An experimental consideration of the use of the transrelational™ model for data warehousing. In Flexible and Efficient Information Handling - 23rd British National Conference on Databases, BNCOD 23, Proceedings (Vol. 4042 LNCS, pp. 47-58). (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 4042 LNCS).
Gonzalez-Castro, Victor ; MacKinnon, Lachlan M. ; Marwick, David H. / An experimental consideration of the use of the transrelational™ model for data warehousing. Flexible and Efficient Information Handling - 23rd British National Conference on Databases, BNCOD 23, Proceedings. Vol. 4042 LNCS 2006. pp. 47-58 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)).
@inproceedings{215e8f5c1c21451da94ec25977478706,
title = "An experimental consideration of the use of the transrelational™ 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 Transrelational™ 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. {\circledC} Springer-Verlag Berlin Heidelberg 2006.",
author = "Victor Gonzalez-Castro and MacKinnon, {Lachlan M.} and Marwick, {David H.}",
year = "2006",
language = "English",
isbn = "3540359699",
volume = "4042 LNCS",
series = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",
pages = "47--58",
booktitle = "Flexible and Efficient Information Handling - 23rd British National Conference on Databases, BNCOD 23, Proceedings",

}

Gonzalez-Castro, V, MacKinnon, LM & Marwick, DH 2006, An experimental consideration of the use of the transrelational™ model for data warehousing. in Flexible and Efficient Information Handling - 23rd British National Conference on Databases, BNCOD 23, Proceedings. vol. 4042 LNCS, Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), vol. 4042 LNCS, pp. 47-58, 23rd British National Conference on Databases, Belfast, Northern Ireland, United Kingdom, 18/07/06.

An experimental consideration of the use of the transrelational™ 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, Proceedings. Vol. 4042 LNCS 2006. p. 47-58 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 4042 LNCS).

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

TY - GEN

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

AU - Gonzalez-Castro, Victor

AU - MacKinnon, Lachlan M.

AU - Marwick, David H.

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 Transrelational™ 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. © Springer-Verlag Berlin Heidelberg 2006.

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 Transrelational™ 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. © Springer-Verlag Berlin Heidelberg 2006.

UR - http://www.scopus.com/inward/record.url?scp=33746747050&partnerID=8YFLogxK

M3 - Conference contribution

SN - 3540359699

SN - 9783540359692

VL - 4042 LNCS

T3 - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

SP - 47

EP - 58

BT - Flexible and Efficient Information Handling - 23rd British National Conference on Databases, BNCOD 23, Proceedings

ER -

Gonzalez-Castro V, MacKinnon LM, Marwick DH. An experimental consideration of the use of the transrelational™ model for data warehousing. In Flexible and Efficient Information Handling - 23rd British National Conference on Databases, BNCOD 23, Proceedings. Vol. 4042 LNCS. 2006. p. 47-58. (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)).