Abstract
This paper introduces a formal definition of a Data Vault model and a conceptual data model of a new Data Warehouse (DW) system catalog (Metadata Vault Repository - MDV) which is based on the Data Vault (DV) method for database modeling. The goal of this conceptual MDV model is to serve as a basis for future development of a new generation of DW temporal system catalogs β catalogs that will track and manage changes in the DW data and metadata, as well as in itsβ schemas. The main contributions of this paper are: (a) a formal definition of DV model and its main concepts, (b) a conceptual MDV model, (c) a final set of fundamental changes over the DW schema, and (d) a formal algebra for DW schema maintenance.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
References
Andany, J., Leonard, M., Palisser, C.: Management of schema evolution in databases. In: Proceedings of the 17th International Conference on Very Large Databases, Barcelona (1991)
Banerjee, S., Davis, K.C.: Modeling data warehouse schema evolution over extended hierarchy semantics. In: Journal on Data Semantics XIII. LNCS, vol. 5530, pp. 72β96. Springer, Heidelberg (2009)
Bebel, B., Krolinkowski, Z., Wrembel, R.: Formal approach to modeling a multiversion data warehouse. In: Bulletin of the Polish Academy of Sciences, Technical Sciences, vol. 54, no. 1 (2006)
Bellahsene, Z.: Schema evolution in data warehouses. Knowl. Inf. Syst. 4(3), 283β304 (2002)
Cui, Y., Widom, J.: Practical lineage tracing in data warehouses. In: Proceedings of the 16th International Conference on Data Engineering (ICDE 2000), San Diego, California (2000)
Date, C.J., Darwen, H., Lorentzos, N.: Temporal Data & the Relational Model. Morgan Kaufmann Publishers, Burlington (2002)
Eder, J., Koncilla, C.: Evolution of dimension data in temporal data warehouses. Technical report (2000)
ErWin Data Modeler. http://erwin.com/products/data-modeler. Accessed 17 Nov 2017
Golfarelli, M., LechtenbΓΆrger, J., Rizzi, S., Vossen, G.: Schema versioning in data warehouses. In: ER Workshops 2004. LNCS, vol. 3289, pp. 415β428. Springer, Heidelberg (2004)
Idef1X. http://www.idef.com/idef1x-data-modeling-method/. Accessed 14 Jan 2018
Inmon, W.H., Strauss, D., Neushloss, G.: DW 2.0: The Architecture for the Next Generation of Data Warehousing. Morgan Kaufmann Publishers, Burlington (2008)
Inmon, W.H., Linstedt, D.: Data Architecture: A Primer for the Data Scientist: Big Data, Data Warehouse and Data Vault. Morgan Kaufmann, Burlington (2014)
JovanoviΔ, V., BojiΔiΔ, I.: Conceptual data vault model. In: Proceedings of the Southern Association for Information Systems Conference, Atlanta, USA (2012)
JovanoviΔ, V., BojiΔiΔ, I., Knowles, C., Pavlic, M.: Persistent staging area models for data warehouses. In: Issues in Information Systems, vol. 13, no. 1, pp. 121β132 (2012)
Linstedt, D.: SuperCharge Your Data Warehouse: Invaluable Data Modeling Rules to Implement Your Data Vault. CreateSpace Independent Publishing Platform, USA (2011)
Linstedt, D., Olschimke, M.: Building a Scalable Data Warehouse with Data Vault 2.0: Implementation Guide for Microsoft SQL Server 2014. Morgan Kaufmann, Burlington (2015)
Malinowski, E., ZimΓ‘nyi, E.: A conceptual model for temporal data warehouses and its transformation to the ER and the object-relational models. Data Knowl. Eng. 64, 101β133 (2008)
Quix, C.: Repository support for data warehouse evolution. In: Proceedings of the International Workshop DMDW, Heidelberg, Germany (2004)
Rundensteiner, E.A., Koeller, A., Zhang, X.: Maintaining data warehouses over changing information sources. Commun. ACM 43, 57β62 (2000)
SubotiΔ, D., Jovanovic, V., PoΕ‘ΔiΔ, P.: Data warehouse schema evolution: state of the art. In: 25th Central European Conference on Information and Intelligent Systems CECIIS, VaraΕΎdin, Croatia (2014)
Yessad, L., Labiod, A.: Comparative study of data warehouses modeling approaches: Inmon, Kimball and Data Vault. In: International Conference on System Reliability and Science (ICSRS), pp. 95β99 (2016)
Bojicic, I., Marjanovic, Z., Turajlic, N., Petrovic, M., Vuckovic, M., Jovanovic, V.: Domain/mapping model: a novel data warehouse data model. Int. J. Comput. Commun. Control 12(2), 166β182 (2017)
Rocha, L., Vale, F., Cirilo, E., Barbosa, D., MourΓ£o, F.: A framework for migrating relational datasets to NoSQL. Procedia Comput. Sci. 51(1), 2593β2602 (2015)
Hanine, M., Bendarag, A., Boutkhoum, O.: Data-migration-methodology-from-relational-to-NoSQL-databases. Int. J. Comput. Electr. Autom. Control Inf. Eng. 9, 2369β2373 (2015)
JakΕ‘iΔ, D., JovanoviΔ, V., PoΕ‘ΔiΔ, P.: Integrating evolving MDM and EDW systems by data vault based system catalog. In: Proceedings of the 40th Jubilee International Convention on Information and Communication Technology, Electronics and Microelectronics MIPRO, Opatija, pp. 1633β1638 (2017)
Acknowledgements
This paper is based upon work supported by the University of Rijeka under project no. 13.13.2.2.06, titled βMetode i modeli za dizajn i evoluciju skladiΕ‘ta podatakaβ.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
Β© 2020 Springer Nature Switzerland AG
About this paper
Cite this paper
Jaksic, D., Poscic, P., Jovanovic, V. (2020). Conceptual Model for the New Generation of Data Warehouse System Catalog. In: Arai, K., Bhatia, R. (eds) Advances in Information and Communication. FICC 2019. Lecture Notes in Networks and Systems, vol 69. Springer, Cham. https://doi.org/10.1007/978-3-030-12388-8_55
Download citation
DOI: https://doi.org/10.1007/978-3-030-12388-8_55
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-12387-1
Online ISBN: 978-3-030-12388-8
eBook Packages: Intelligent Technologies and RoboticsIntelligent Technologies and Robotics (R0)