EXTENDED METADATA FOR DATA WAREHOUSE SCHEMA

N. Parimala, Vinay Gautam

2011

Abstract

We are concerned with providing support for identification of changes to the data warehouse schema. The approach involves, building an extended metadata, E-Metadata, using which we identify changes. In this paper we show the manner in which E-Metadata is built. E-Metadata consists of the technical metadata and an ontology. In the E-Metadata Development Process (EDP), first, the technical metadata is extracted from the metadata of the warehouse schema. In the next stage of ontology development process, the schema terms are extracted from the technical metadata. The data warehouse administrator is asked to provide business terms for the schema terms. We, then search the WordNet for synonyms, hypernyms etc. for these terms. Using this information we build the ontology.

References

  1. Ahlemnabli, Jamel Feki and Farez Gargouri., 2009. An ontology based method for normalization terminology, LNCS, Springer, Vol., 235-246.
  2. Ahlemnabli, Jamel Feki and Farez Gargouri., 2009. An ontology based method for normalization terminology, LNCS, Springer, Vol., 235-246.
  3. Anca Vaduva, 2001, Metadata Management for Data Warehousing: Between vision and reality, Database Engineering & Applications, 129-135.
  4. Anca Vaduva, 2001, Metadata Management for Data Warehousing: Between vision and reality, Database Engineering & Applications, 129-135.
  5. George Angelos Papadopoulos, Wita Wojtkowski, Gregory Wojtkowski Stanislaw Wrycza, Jo¿e Zupancic, 2010, Metadata support for data warehouse evolution, Information Systems Development.
  6. George Angelos Papadopoulos, Wita Wojtkowski, Gregory Wojtkowski Stanislaw Wrycza, Jo¿e Zupancic, 2010, Metadata support for data warehouse evolution, Information Systems Development.
  7. Guotong Xie, Yang Yang, Shengping Liu, Zhaoming Qiu, Yue Pan and Xiongzhi Zhou, 2010, EIAW: Towards a Business-Friendly Data Warehouse Using Semantic Web Technologies, 2nd Asian conference on Asian semantic web conference.
  8. Guotong Xie, Yang Yang, Shengping Liu, Zhaoming Qiu, Yue Pan and Xiongzhi Zhou, 2010, EIAW: Towards a Business-Friendly Data Warehouse Using Semantic Web Technologies, 2nd Asian conference on Asian semantic web conference.
  9. Igor Jurisica, 2004, Ontology's for Knowledge Management: An Information Systems Perspective, Knowledge and Information Systems Volume 6, Number 4, 380-401.
  10. Igor Jurisica, 2004, Ontology's for Knowledge Management: An Information Systems Perspective, Knowledge and Information Systems Volume 6, Number 4, 380-401.
  11. Katic, N., Quirchmay, G., Schiefer, J., Stolba, M., Tjoa, A. M.,1998, A Prototype Model for Data Warehouse Security Based on Metadata, International Workshop in DESA.
  12. Katic, N., Quirchmay, G., Schiefer, J., Stolba, M., Tjoa, A. M.,1998, A Prototype Model for Data Warehouse Security Based on Metadata, International Workshop in DESA.
  13. Kurze, C. Gluchowski, P. Bohringer, M., 2010, Towards an Ontology of Multidimensional Data Structures for Analytical Purposes, HICSS.
  14. Kurze, C. Gluchowski, P. Bohringer, M., 2010, Towards an Ontology of Multidimensional Data Structures for Analytical Purposes, HICSS.
  15. L. Wua, L. Millera, S. Nilakanta, 2001, Design of data warehouses using metadata, Information and Software Technology,109-119.
  16. L. Wua, L. Millera, S. Nilakanta, 2001, Design of data warehouses using metadata, Information and Software Technology,109-119.
  17. N. L. Sarda, 2006, Structuring Business Metadata in Data Warehouse Systems for Effective Business Support, International Enterprise Object Computing Conference Workshops.
  18. N. L. Sarda, 2006, Structuring Business Metadata in Data Warehouse Systems for Effective Business Support, International Enterprise Object Computing Conference Workshops.
  19. Parimala N., Vinay Gautam, 2010, CIS: Change Identification System, proceeding Knowledge Engineering and Ontology Development SciTePress.
  20. Parimala N., Vinay Gautam, 2010, CIS: Change Identification System, proceeding Knowledge Engineering and Ontology Development SciTePress.
  21. Paulheim, H., Probst, F, 2010, Ontology-Enhanced User Interfaces: A Survey, International Journal on Semantic Web and Information Systems.
  22. Paulheim, H., Probst, F, 2010, Ontology-Enhanced User Interfaces: A Survey, International Journal on Semantic Web and Information Systems.
  23. Peter Spyns, 2008, An Ontology engineering methodology for DOGMA, Applied Ontology archive.
  24. Peter Spyns, 2008, An Ontology engineering methodology for DOGMA, Applied Ontology archive.
  25. Ting Wang, 2010, Constructing a Dataspace Based on Metadata and Ontology for Complicated Scientific Data Management, Pervasive Computing and Applications.
  26. Ting Wang, 2010, Constructing a Dataspace Based on Metadata and Ontology for Complicated Scientific Data Management, Pervasive Computing and Applications.
  27. Thomas Vetterliy Anca Vaduvaz Martin Staudty, 2000, Metadata standards for data warehousing: Open Information Meta-model Vs Common Warehouse Meta-model, ACM SIGMOD.
  28. Thomas Vetterliy Anca Vaduvaz Martin Staudty, 2000, Metadata standards for data warehousing: Open Information Meta-model Vs Common Warehouse Meta-model, ACM SIGMOD.
  29. Veronika Stefanov, Beate List, 2006, Business Metadata for data warehouse - weaving Enterprise goals and models, Journal of Object Technology 4(2), 41-48.
  30. Veronika Stefanov, Beate List, 2006, Business Metadata for data warehouse - weaving Enterprise goals and models, Journal of Object Technology 4(2), 41-48.
  31. W. L. Lacy, 2009. Representing Information Using the Web Ontology Language, Trafford Publishing.
  32. W. L. Lacy, 2009. Representing Information Using the Web Ontology Language, Trafford Publishing.
  33. Won Kim, 2005, On Metadata Management Technology: Status and Issues, Journal of Object Technology.
  34. Won Kim, 2005, On Metadata Management Technology: Status and Issues, Journal of Object Technology.
  35. OWL, 2004, www.w3.org/2004/OWL.
  36. OWL, 2004, www.w3.org/2004/OWL.
Download


Paper Citation


in Harvard Style

Parimala N. and Gautam V. (2011). EXTENDED METADATA FOR DATA WAREHOUSE SCHEMA . In Proceedings of the 6th International Conference on Evaluation of Novel Approaches to Software Engineering - Volume 1: ENASE, ISBN 978-989-8425-57-7, pages 254-259. DOI: 10.5220/0003468202540259


in Harvard Style

Parimala N. and Gautam V. (2011). EXTENDED METADATA FOR DATA WAREHOUSE SCHEMA . In Proceedings of the 6th International Conference on Evaluation of Novel Approaches to Software Engineering - Volume 1: ENASE, ISBN 978-989-8425-57-7, pages 254-259. DOI: 10.5220/0003468202540259


in Bibtex Style

@conference{enase11,
author={N. Parimala and Vinay Gautam},
title={EXTENDED METADATA FOR DATA WAREHOUSE SCHEMA},
booktitle={Proceedings of the 6th International Conference on Evaluation of Novel Approaches to Software Engineering - Volume 1: ENASE,},
year={2011},
pages={254-259},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003468202540259},
isbn={978-989-8425-57-7},
}


in Bibtex Style

@conference{enase11,
author={N. Parimala and Vinay Gautam},
title={EXTENDED METADATA FOR DATA WAREHOUSE SCHEMA},
booktitle={Proceedings of the 6th International Conference on Evaluation of Novel Approaches to Software Engineering - Volume 1: ENASE,},
year={2011},
pages={254-259},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003468202540259},
isbn={978-989-8425-57-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 6th International Conference on Evaluation of Novel Approaches to Software Engineering - Volume 1: ENASE,
TI - EXTENDED METADATA FOR DATA WAREHOUSE SCHEMA
SN - 978-989-8425-57-7
AU - Parimala N.
AU - Gautam V.
PY - 2011
SP - 254
EP - 259
DO - 10.5220/0003468202540259


in EndNote Style

TY - CONF
JO - Proceedings of the 6th International Conference on Evaluation of Novel Approaches to Software Engineering - Volume 1: ENASE,
TI - EXTENDED METADATA FOR DATA WAREHOUSE SCHEMA
SN - 978-989-8425-57-7
AU - Parimala N.
AU - Gautam V.
PY - 2011
SP - 254
EP - 259
DO - 10.5220/0003468202540259