Extended Change Identification System

Parimala N., Vinay Gautam


Schema evolution leads to multiple versions of the data warehouse schema. We address the issue of whether the information required by the decision maker is present in some version of the data warehouse or not by checking all the versions for the existence or the absence of the required information. The user specifies the sought information using business terms. We build Delta Ontology which captures the ontology information in terms of mapping between business terms and schema terms. The Delta Ontology is built for the modifications to the schema as it evolves. We propose an algorithm to search for the information in the latest version of E-Metadata and the Delta Ontology. Our algorithm lists all the versions where the information is available giving precedence to finding the information in a single version over across versions. The decision maker is also informed if the information is totally missing.


  1. Bebel, B., Królikowski, Z. and Wrembel, R., 2006. Managing evolution of data warehouses by means of nested transactions. In Advances in Information Systems (pp. 119-128). Springer Berlin Heidelberg.
  2. Blaschka, M., Sapia, C. and Höfling, G., 1999. On schema evolution in multidimensional databases. In Data Warehousing and Knowledge Discovery(pp. 153-164). Springer Berlin Heidelberg.
  3. Body, M., Miquel, M., Bédard, Y. and Tchounikine, A., 2003, March. Handling evolutions in multidimensional structures. In Data Engineering, 2003. Proceedings. 19th International Conference on (pp. 581-591). IEEE.
  4. Cañas, A.J., Valerio, A., Lalinde-Pulido, J., Carvalho, M. and Arguedas, M., 2003, October. Using WordNet for word sense disambiguation to support concept map construction. In String Processing and Information Retrieval(pp. 350-359). Springer Berlin Heidelberg.
  5. Gautam, V. and Parimala, N., 2012. E-Metadata versioning system for data warehouse schema. International Journal of Metadata, Semantics and Ontologies, 7(2), pp.101-113.
  6. Golfarelli, M., Lechtenbörger, J., Rizzi, S. and Vossen, G., 2006. Schema versioning in data warehouses: Enabling cross-version querying via schema augmentation. Data & Knowledge Engineering, 59(2), pp.435-459.
  7. Kaas, C., Pedersen, T.B. and Rasmussen, B., 2004. Schema evolution for stars and snowflakes. In Proceedings of the Sixth International Conference on Enterprise Information Systems.
  8. Leja, W., Wrembel, R. and Ziembicki, R., 2009. On Querying Data and Metadata in Multiversion Data Warehouse. Data Warehousing Design and Advanced Engineering Applications: Methods for Complex Construction: Methods for Complex Construction, p.206.
  9. Maté, A. and Trujillo, J., 2014. Tracing conceptual models' evolution in data warehouses by using the model driven architecture. Computer Standards & Interfaces, 36(5), pp.831-843.
  10. Miller, G.A., 1995. WordNet: a lexical database for English. Communications of the ACM, 38(11), pp.39- 41.
  11. Miller, G.A. and Hristea, F., 2006. WordNet nouns: Classes and instances. Computational linguistics, 32(1), pp.1-3.
  12. Pan, D., 2010. Metadata version management for DW 2.0 environment'.Journal of Convergence Information Technology, 5(3).
  13. Parimala, N. and Gautam, V., 2010. CIS: Change Identification System. In KEOD (pp. 347-350).
  14. Parimala, N. and Gautam, V., 2011. Extended Metadata for Data Warehouse Schema. In ENASE (pp. 254-259).
  15. Saddad, E., El-Bastawissy, A., Rafea, M. and Hegazy, O., 2008, March. Multiversion queries in multidimensional structures. In Proceedings of the 6th International Conference on Informatics and Systems (INFOS'08).
  16. Serra, I. and Girardi, R., 2011. A process for extracting non-taxonomic relationships of ontologies from text. Intelligent Information Management, 3, 119.
  17. Shahzad, M.K., Nasir, J.A. and Pasha, M.A., 2005. CEVDW: Creation and Evolution of Versions in Data Warehouse. Asian Journal of Information Technology, 4(10), pp.910-917.
  18. Vaduva, A. and Dittrich, K.R., 2001. Metadata management for data warehousing: between vision and reality. In Database Engineering and Applications, 2001 International Symposium on. (pp. 129-135). IEEE.
  19. Wrembel, R. and Bebel, B., 2007. Metadata management in a multiversion data warehouse. In Journal on data VIII (pp. 118-157). Springer

Paper Citation

in Harvard Style

N. P. and Gautam V. (2016). Extended Change Identification System . In Proceedings of the 11th International Conference on Evaluation of Novel Software Approaches to Software Engineering - Volume 1: ENASE, ISBN 978-989-758-189-2, pages 51-58. DOI: 10.5220/0005776100510058

in Bibtex Style

author={Parimala N. and Vinay Gautam},
title={Extended Change Identification System},
booktitle={Proceedings of the 11th International Conference on Evaluation of Novel Software Approaches to Software Engineering - Volume 1: ENASE,},

in EndNote Style

JO - Proceedings of the 11th International Conference on Evaluation of Novel Software Approaches to Software Engineering - Volume 1: ENASE,
TI - Extended Change Identification System
SN - 978-989-758-189-2
AU - N. P.
AU - Gautam V.
PY - 2016
SP - 51
EP - 58
DO - 10.5220/0005776100510058