Authors:
Alexandra Pomares Q.
1
and
José Abásolo P.
2
Affiliations:
1
Javeriana University, Colombia
;
2
Los Andes University, Colombia
Keyword(s):
Data warehouse, ontologies, dimensional model, data integration, data warehouse design.
Related
Ontology
Subjects/Areas/Topics:
Coupling and Integrating Heterogeneous Data Sources
;
Data Warehouses and OLAP
;
Databases and Information Systems Integration
;
Enterprise Information Systems
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.