Domain/Mapping Model: A Novel Data Warehouse Data Mode

Ivan Bojicic, Zoran Marjanovic, Nina Turajlic, Marko Petrovic, Milica Vuckovic, Vladan Jovanovic

Abstract


In order for a data warehouse to be able to adequately fulfill its integrative and historical purpose, its data model must enable the appropriate and consistent representation of the different states of a system. In effect, a DW data model, representing the physical structure of the DW, must be general enough, to be able to consume data from heterogeneous data sources and reconcile the semantic differences of the data source models, and, at the same time, be resilient to the constant changes in the structure of the data sources. One of the main problems related to DW development is the absence of a standardized DW data model. In this paper a comparative analysis of the four most prominent DW data models (namely the relational/normalized model, data vault model, anchor model and dimensional model) will be given. On the basis of the results of [1]a, the new DW data model (the Domain/Mapping model- DMM) which would more adequately fulfill the posed requirements is presented.

Keywords


data warehouse, data models, relational/normalized model, data vault model, anchor model, dimensional model, domain/mapping model

Full Text:

PDF

References


I. Bojicic, Z. Marjanovic, N. Turajlic, M. Petrovic, M. Vuckovic and V. Jovanovic (2016), A comparative analysis of data warehouse data models, Computers Communications and Control (ICCCC), 2016 6th International Conference on, IEEE Xplore, e-ISBN 978-1-5090- 1735-5, doi: 10.1109/ICCCC.2016.7496754, 151-159.
https://doi.org/10.1109/ICCCC.2016.7496754

W. Inmon, Building the Data Warehouse. Wiley, 2002.

R. Kimball, L. Reeves, M. Ross and W. Thornthwaite (1998), The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing, and Deploying Data Warehouses, Wiley, 1998.

Object Management Group (2002); Common Warehouse Metamodel, available at: http://www.omg.org/cgi-bin/doc?formal/03-03-02.pdf

O. Regardt, L. Ronnback, M. Bergholtz, P. Johannesson and P. Wohed (2009); Anchor Modeling: An Agile Modeling Technique Using the Sixth Normal Form for Structurally and Temporally Evolving Data, in Proc. of ER09 (Brazil) , LNCS, 5829(1): 234-250.
https://doi.org/10.1007/978-3-642-04840-1_19

D. Linstedt (2010); Data Vault Modeling Specification v1.0.9., available at: http:// danlinstedt.com/datavaultcat/standards/dv-modeling-specification-v1-0-8/

B. Lazarevic, Z. Marjanovic, N. Anicic and S. Babarogic (2010). Baze podataka. Fakultet organizacionih nauka, 2010 (Textbook in Serbian).

E. F. Codd (1969); Derivability, Redundancy and Consistency of Relations Stored in Large Data Banks, IBM Research Report, San Jose, California, 1969.

E. F. Codd (1970); A Relational Model of Data for Large Shared Data Banks, in Communications of the ACM, 13(6):377-387.
https://doi.org/10.1145/362384.362685

D. Linstedt (2002); Data Vault Series 1 - Data Vault Overview, available at: http://www. tdan.com/view-articles/5054/

D. Linstedt (2011); Super Charge Your Data Warehouse: Invaluable Data Modeling Rules to Implement Your Data Vault, CreateSpace Independent Publishing Platform, 2011.

D. Linstedt (2003); Data Vault Series 2 - Data Vault Components, available at: http://www.tdan.com/view-articles/5155/

L. Ronnback, O. Regardt, M. Bergholtz, P. Johannesson, P. Wohed (2010); Anchor modeling - Agile information modeling in evolving data environments, in Data & Knowledge Engineering, 69(12):1229-1253.

R. Kimball and M. Ross (2013);

The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, Wiley, 3rd ed., 2013.

M. Golfarelli and S. Rizzi (2009);

Data Warehouse Design - Modern Principles and Methodologies, McGraw - Hill, 2009.

Anchor Modeling Tool, available at: http://www.anchormodeling.com/modeler

E. Malinowski and E. Zimanyi (2008); Advanced Data Warehouse Design - From Conventional to Spatial and Temporal Applications, Springer-Verlag Berlin Heidelberg, 2008.

R. T. Snodgrass, I. Ahn (1986); Temporal Databases, in IEEE Computer, 19(9):35 - 42.

C. Jensen, J. Clifford, R. Elmasri, S. K. Gadia, P. J. Hayes, S. Jajodia (1994);

A Consensus Glossary of Temporal Database Concepts, SIGMOD Record, 23(1):52 - 64.
https://doi.org/10.1145/181550.181560

H. Gregersen, J.S. Jensen (1999);

Temporal Entity-Relationship models a survey, IEEE Transactions on Knowledge and Data Engineering, 11: 464-497.
https://doi.org/10.1109/69.774104

L. Ronnback, O. Regardt, M. Bergholtz, P. Johannesson, P. Wohed 92010); From Anchor Model to Relational Database, available at: http://www.anchormodeling.com/wp-content/ uploads/2010/09/AM-RDB.pdf

M. Golfarelli, J. Lechtenborger, S. Rizzi, G. Vossen (2006); Schema versioning in data warehouses: Enabling cross-version querying via schema augmentation, in Data & Knowledge Engineering, 59(2):435-459.

B. Inmon (2004); The Single Version of The Truth, Business Intelligence Network (Powell Media LLC), available at: http://www.b-eye-network.com/view/282.

R. Damhof (2008); The next generation EDW, available at: http://prudenza.typepad. com/files/




DOI: https://doi.org/10.15837/ijccc.2017.2.2876



Copyright (c) 2017 Ivan Bojicic, Zoran Marjanovic, Nina Turajlic, Marko Petrovic, Milica Vuckovic, Vladan Jovanovic

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.

CC-BY-NC  License for Website User

Articles published in IJCCC user license are protected by copyright.

Users can access, download, copy, translate the IJCCC articles for non-commercial purposes provided that users, but cannot redistribute, display or adapt:

  • Cite the article using an appropriate bibliographic citation: author(s), article title, journal, volume, issue, page numbers, year of publication, DOI, and the link to the definitive published version on IJCCC website;
  • Maintain the integrity of the IJCCC article;
  • Retain the copyright notices and links to these terms and conditions so it is clear to other users what can and what cannot be done with the  article;
  • Ensure that, for any content in the IJCCC article that is identified as belonging to a third party, any re-use complies with the copyright policies of that third party;
  • Any translations must prominently display the statement: "This is an unofficial translation of an article that appeared in IJCCC. Agora University  has not endorsed this translation."

This is a non commercial license where the use of published articles for commercial purposes is forbiden. 

Commercial purposes include: 

  • Copying or downloading IJCCC articles, or linking to such postings, for further redistribution, sale or licensing, for a fee;
  • Copying, downloading or posting by a site or service that incorporates advertising with such content;
  • The inclusion or incorporation of article content in other works or services (other than normal quotations with an appropriate citation) that is then available for sale or licensing, for a fee;
  • Use of IJCCC articles or article content (other than normal quotations with appropriate citation) by for-profit organizations for promotional purposes, whether for a fee or otherwise;
  • Use for the purposes of monetary reward by means of sale, resale, license, loan, transfer or other form of commercial exploitation;

    The licensor cannot revoke these freedoms as long as you follow the license terms.

[End of CC-BY-NC  License for Website User]


INTERNATIONAL JOURNAL OF COMPUTERS COMMUNICATIONS & CONTROL (IJCCC), With Emphasis on the Integration of Three Technologies (C & C & C),  ISSN 1841-9836.

IJCCC was founded in 2006,  at Agora University, by  Ioan DZITAC (Editor-in-Chief),  Florin Gheorghe FILIP (Editor-in-Chief), and  Misu-Jan MANOLESCU (Managing Editor).

Ethics: This journal is a member of, and subscribes to the principles of, the Committee on Publication Ethics (COPE).

Ioan  DZITAC (Editor-in-Chief) at COPE European Seminar, Bruxelles, 2015:

IJCCC is covered/indexed/abstracted in Science Citation Index Expanded (since vol.1(S),  2006); JCR2018: IF=1.585..

IJCCC is indexed in Scopus from 2008 (CiteScore2018 = 1.56):

Nomination by Elsevier for Journal Excellence Award Romania 2015 (SNIP2014 = 1.029): Elsevier/ Scopus

IJCCC was nominated by Elsevier for Journal Excellence Award - "Scopus Awards Romania 2015" (SNIP2014 = 1.029).

IJCCC is in Top 3 of 157 Romanian journals indexed by Scopus (in all fields) and No.1 in Computer Science field by Elsevier/ Scopus.

 

 Impact Factor in JCR2018 (Clarivate Analytics/SCI Expanded/ISI Web of Science): IF=1.585 (Q3). Scopus: CiteScore2018=1.56 (Q2);

SCImago Journal & Country Rank

Editors-in-Chief: Ioan DZITAC & Florin Gheorghe FILIP.