Universitas Indonesia Conferences, The 4th International Conference of Vocational Higher Education

Font Size: 
Anchor Model Performance in Data Warehouse
Gladly Caren Rorimpandey

Last modified: 2019-08-06

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.


References


Bassil, Y., 2012. A Data Warehouse Design for A typical University Information System. Journal of Computer Science & Research. JCSCR.

Inmon, W., . Building the data warehouse, Wiley Publishing. Canada, 4th edition.

Kujur, A G P., Oraon, A., 2016A Data Warehouse Design and Usagel. International Research Journal of Engineering and Technology. IRJET.

Pereira, D G., Afonso, A., 2015. Overview of friedman’s Test and Post hoc Analysis. Communication in statistics-simulation and computation.

Ronnback, L., Johannesson, P., Regardt, O., Wohed, P., 2010. Anchor Modeling-Agile Information modelling in Envolving Data Environment. Journal of Data and Knowledge Engineering. Research Gate.

Rorimpandey, G C., Sangkop, F I., Rantung, V P., Zwart, J P., Liando, O E S., Mewengkang, A., 2018. Data Model Performance in Data Warehousing. IOP Conf. Series: Materials Sciences and Engineering. IOP Publishing.