DATA WHAREHOUSES: AN ONTOLOGY APPROACH

Alexandra Pomares Q., José Abásolo P.

Abstract

Although dimensional design for data warehouses has been used in a considerable amount of projects, it does have limitations of expressiveness, particularly with respect to what can be said about relations and attributes properties and restrictions. We present a new way to design data warehouses, based on ontologies, that overcomes many of these limitations. In the proposed architecture descriptive ontologies are used to build the data warehouse and taxonomic ontologies are used during data preparation phase. We discuss the expressive power of Ontology approach showing a semantic comparison with dimensional model both applied to a case study.

References

  1. Antoniou G. & van Harmelen F. (2004) A Semantic Web Primer. First Edition. MIT Press
  2. Clusters, W. & Smith, B. Fielding, J. (2004). On the Application of Formal Principles to Life Science Data: A Case Study in the Gene Ontology. [Electronic Version]. DILS 2004.
  3. Cullot N. & Parent C & Spaccapietra s. & Vangenot C. (2003) Ontologies: A contribution to the DL/DB debate. Proceedings of Semantic Web and Databases 2003: Berlin, Germany . http://lbdsun.epfl.ch/e/publications_new/articles.pdf/C ullot_SW_DB2003_CR.pdf (Published Septiembre 2003; accessed 8 July 2005)
  4. Dean M. & Schreiber G. (2004). OWL Web Ontology Language Reference W3C Recommendation. http://www.w3.org/TR/owl-ref/ (Published 10 February 2004; accessed 11 March 2005)
  5. Heflin J (2004). OWL Web Ontology Language Use Cases and Requirements. W3C Recommendation. http://www.w3.org/TR/webont-req/ (Published 10 February 2004; accessed 22 April 2005)
  6. Kedad, Z. & Métais E. (2002). Ontology - Based Data Cleaning. [Electronic version]. NLDB 2002 Record.
  7. Kimball R. & Ross M. (2002) The data warehouse toolkit : the complete guide to dimensional modeling. Second Edition. New York : Wiley, c2002
  8. Lee J. & Goodwin R. et al (2003). Towards EnterpriseScale Ontology Management. IBM T. J. Watson Research Center, 2004.
Download


Paper Citation


in Harvard Style

Pomares Q. A. and Abásolo P. J. (2006). DATA WHAREHOUSES: AN ONTOLOGY APPROACH . In Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-972-8865-41-2, pages 187-192. DOI: 10.5220/0002460601870192


in Bibtex Style

@conference{iceis06,
author={Alexandra Pomares Q. and José Abásolo P.},
title={DATA WHAREHOUSES: AN ONTOLOGY APPROACH},
booktitle={Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2006},
pages={187-192},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002460601870192},
isbn={978-972-8865-41-2},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Eighth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - DATA WHAREHOUSES: AN ONTOLOGY APPROACH
SN - 978-972-8865-41-2
AU - Pomares Q. A.
AU - Abásolo P. J.
PY - 2006
SP - 187
EP - 192
DO - 10.5220/0002460601870192