A Novel Approach to Version XML Data Warehouse

International Journal of Computer Science and Engineering

© 2021 by SSRG - IJCSE Journal

Volume 8 Issue 9

Year of Publication : 2021

Authors : Mitesh Athwani

10.14445/23488387/IJCSE-V8I9P102

How to Cite?

Mitesh Athwani, "A Novel Approach to Version XML Data Warehouse," SSRG International Journal of Computer Science and Engineering , vol. 8,  no. 9, pp. 5-11, 2021. Crossref, https://doi.org/10.14445/23488387/IJCSE-V8I9P102

Abstract:

Data warehouses are fast becoming a norm for a standard company. XML has emerged as a standard for communication and storage of data. A distributed data warehouse having data format as XML i.e., XML warehouses have gained much popularity. Data warehouses have emerged as an important aid in decision-making and in what-if-analysis. To achieve this purpose, the presence of historical data is essential. Versioning plays an important role particularly in maintaining historical data. Research and implementation of document versioning have been carried out on many fronts, but the issue of schema versioning is still in its early stage. In this paper, we have concentrated on both content versioning as well as schema versioning. Earlier work on schema versioning has largely taken the view of versioning on attributes. We have versioned the schema on a new approach taking the dimension level.
To maneuver the challenging task of schema versioning we have also taken an example case study that has been used to describe the scenario in a better manner.
Also, to portray our work, we have made a prototype using the .NET framework that depicts both schema versioning as well as content versioning. The approach is user-centric and therefore it allows the user to generate versions of schema according to their need specified in an XML document called” Version Specification Document” (appended to this paper). As an additional characteristic, it also allows validation of document files against the schema files.

Keywords:

Data Warehouse, XML, Versioning, Dimensions, Facts

References:

[1] Bogdan Czejdo, Kenneth Messa, Tadeusz Morzy, Mikolaj
Morzy, Janusz Czejdo Data Warehouses with Dynamically changing Schemas and Data Sources.
[2] Bartosz Bebel, Tadeusz Morzy, Robert Wrembel, Johann Eder, Christian Koncilla, Creation and Management of Versions in Multiversion Data Warehouse.
[3] Matteo Golfarelli, Stefano Rizzi, Boris Vrdoljak, Data Warehouse Design from XML Sources.
[4] Matteo Golfarelli, Stefano Rizzi, Jens Lechtenborger Gottifried Vossen, Schema Versioning in Data Warehouse.
[5] Li Yang , Naphtali Rishe, A Flexible & Effective XML Storage & Retrieval System.
[6] XML Schema Versioning.
[7] John Finianos, Jugdish Mistry, Versioning in Existing Data Warehouse.
[8] Marko Banek, Zoran Skoeir and Boris Vrdoljak, Logical Design of Data Warehouses from XML.