Parimala N., Vinay Gautam


Change identification is one of the main challenges for Data Warehouse Schema evolution. Changes to the schema are required, among other situations, when the data warehouse fails to provide information to the decision maker. In this paper we address the issue of identification of changes when such a situation occurs. Towards this, the decision maker is asked to specify the information he/she needs, in business terms, to meet a goal. With the help of ontology and a set of rules we identify whether the information is present in the warehouse or not. The absence of data could be because it is not directly stored or because it is actually absent. In both these cases the changes needed to the data warehouse schema are suggested by the system, called the Change Identification System (CIS).


  1. Lacy W. L.(2005), Representing Information Using the Web Ontology Language. Trafford Publishing.
  2. Zohra Bellahsene (2002), Schema evolution in data warehouses. Knowledge and Information System Journal, Springer-Verlag Newyork, Vol. 4 issue 3, pages 283-304.
  3. Ahlem nabli, Jamel Feki and Farez Gargouri (2009), An ontology based method for normalization terminology. LNCS, Springer, Vol. 4870/2009, pages 235-246.
  4. OWL (2008)
  5. Matthias Kehlenbeck and Michael H. Breitner (2009), Ontology-Based Exchange and Immediate Application of Business Calculation Definitions for Online Analytical Processing. DaWaK , pages 298- 311
  6. Naveen Prakash and Anjana Gosain (2008), An approach to engineering requirements of data warehouse, Requirement Engineering Journal, Springer, Vol. 13, No. 1.
  7. Bartosz Bebel, Zbyszko Królikowski, and Robert Wrembel (2006), Managing Evolution of Data Warehouse System by Mean of Nested Transaction, Springer Berlin / Heidelberg, Vol. 4243.
  8. Fadila Bentayeb, Cecile Favre and Omar Boussaid (2008), A User-driven data warehouse Evolution Approach for Concurrent Personalized Analysis Needs, Published in Integrated Computer-Aided Engineering, Vol. 15 No. 1 , pages 21-36.
  9. Paolo Giorgini, Stefano Rizzi and Maddalena Garzetti (2008), GRAnD: A goal-oriented approach to requirement analysis in data warehouses, Decision Support Systems, Vol. 45 , Issue 1,Pages 4-21.
  10. Shazad, M. K., J. A. Nasir and M. A. Pasa: Creation and evolution versions in data warehouse, Asian journal of IT, 910-917, 2005, Grace Publication.
  11. Body, M., Miquel, M., Bedard, Y. and Tchounikine, A. (2003), Handling Evolutions in Multidimensional Structures, Proceedings of 19th International Conference on Data Engineering, pages 581- 591
  12. Mathurine Body, Marryvonne Miquel, Yvan Bedard and Anne Tchounikie (2002), A multidimensional and multi-version structure for OLAP Application, 5th ACM international workshop on Data Warehousing and OLAP, Pages: 1-6.
  13. Guotong Xie, Yang Yang, Shengping Liu, Zhaoming Qiu, Yue Pan and Xiongzhi Zhou (2008), EIAW: Towards a Business-Friendly data warehouse using Semantic Web Technology, LNCS, Springer, Vol. 4825.

Paper Citation

in Harvard Style

N. P. and Gautam V. (2010). CIS: CHANGE IDENTIFICATION SYSTEM . In Proceedings of the International Conference on Knowledge Engineering and Ontology Development - Volume 1: KEOD, (IC3K 2010) ISBN 978-989-8425-29-4, pages 347-350. DOI: 10.5220/0003069003470350

in Bibtex Style

author={Parimala N. and Vinay Gautam},
booktitle={Proceedings of the International Conference on Knowledge Engineering and Ontology Development - Volume 1: KEOD, (IC3K 2010)},

in EndNote Style

JO - Proceedings of the International Conference on Knowledge Engineering and Ontology Development - Volume 1: KEOD, (IC3K 2010)
SN - 978-989-8425-29-4
AU - N. P.
AU - Gautam V.
PY - 2010
SP - 347
EP - 350
DO - 10.5220/0003069003470350