The Performance of Anchor Model in Data Warehousing

Gladly Caren Rorimpandey, Jan Pieter Zwart, Julyeta Paulina Amelia Runtuwene, Ferdinan Ivan Sangkop, Vivi Peggie Rantung, Parabelem Tinno Dolf Rompas, Cindy Pamela C. Munaiseche

2018

Abstract

Data model performance became one of essential to be future-proof criteria in data warehouse. The aim of this research is to proof that the performance of Anchor Model as good as the performance of traditional data models that used in data warehousing. The research method is inferential statistics which takes one scenario to generate the sample of data by using SQL Server as the RDBMS. The performance result is discussed by Post-hoc analysis. The experiment performed evidently shows that the Anchor Model has no significantly different with Optimal Normal Form and Data Vault but it has significantly different with star schema. It means the time execution in the SQL statement with more join tables will be shorter than the SQL statement with less join tables. So, the companies that will design and develop data warehouse can be consider to using Anchor Model as their data model in data warehousing.

Download


Paper Citation


in Harvard Style

Rorimpandey G., Zwart J., Runtuwene J., Sangkop F., Rantung V., Rompas P. and Munaiseche C. (2018). The Performance of Anchor Model in Data Warehousing.In Proceedings of the 7th Engineering International Conference on Education, Concept and Application on Green Technology - Volume 1: EIC, ISBN 978-989-758-411-4, pages 304-308. DOI: 10.5220/0009010103040308


in Bibtex Style

@conference{eic18,
author={Gladly Caren Rorimpandey and Jan Pieter Zwart and Julyeta Paulina Amelia Runtuwene and Ferdinan Ivan Sangkop and Vivi Peggie Rantung and Parabelem Tinno Dolf Rompas and Cindy Pamela C. Munaiseche},
title={The Performance of Anchor Model in Data Warehousing},
booktitle={Proceedings of the 7th Engineering International Conference on Education, Concept and Application on Green Technology - Volume 1: EIC,},
year={2018},
pages={304-308},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0009010103040308},
isbn={978-989-758-411-4},
}


in EndNote Style

TY - CONF

JO - Proceedings of the 7th Engineering International Conference on Education, Concept and Application on Green Technology - Volume 1: EIC,
TI - The Performance of Anchor Model in Data Warehousing
SN - 978-989-758-411-4
AU - Rorimpandey G.
AU - Zwart J.
AU - Runtuwene J.
AU - Sangkop F.
AU - Rantung V.
AU - Rompas P.
AU - Munaiseche C.
PY - 2018
SP - 304
EP - 308
DO - 10.5220/0009010103040308