A methodology and tool for conceptual designing a data warehouse from ontology-based sources

Authors:
Selma Khouri;Bellatreche Ladjel
Affiliations:
Ecole nationale Supérieure d'Informatique, Algiers, Algeria;ENSMA, Poitiers, France
Venue:
DOLAP '10 Proceedings of the ACM 13th international workshop on Data warehousing and OLAP
Year:
2010

Citing 10
Cited 8

Deriving initial data warehouse structures from the conceptual data models of the underlying operational information systems

Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
Designing data marts for data warehouses

ACM Transactions on Software Engineering and Methodology (TOSEM)
Extending the UML for Multidimensional Modeling

UML '02 Proceedings of the 5th International Conference on The Unified Modeling Language
Enterprise information integration: successes, challenges and controversies

Proceedings of the 2005 ACM SIGMOD international conference on Management of data
Contribution of ontology-based data modeling to automatic integration of electronic catalogues within engineering databases

Computers in Industry - Special issue: Collaborative environments for concurrent engineering
Automating multidimensional design from ontologies

Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
GRAnD: A goal-oriented approach to requirement analysis in data warehouses

Decision Support Systems
OntoDB: an ontology-based database for data intensive applications

DASFAA'07 Proceedings of the 12th international conference on Database systems for advanced applications
Querying ontology based database using OntoQL (an ontology query language)

ODBASE'06/OTM'06 Proceedings of the 2006 Confederated international conference on On the Move to Meaningful Internet Systems: CoopIS, DOA, GADA, and ODBASE - Volume Part I
Multidimensional integrated ontologies: a framework for designing semantic data warehouses

Journal on Data Semantics XIII

DOLAP 2010 workshop summary

CIKM '10 Proceedings of the 19th ACM international conference on Information and knowledge management
DWOBS: data warehouse design from ontology-based sources

DASFAA'11 Proceedings of the 16th international conference on Database systems for advanced applications: Part II
Semantic cockpit: an ontology-driven, interactive business intelligence tool for comparative data analysis

ER'11 Proceedings of the 30th international conference on Advances in conceptual modeling: recent developments and new directions
Embedding user's requirements in data warehouse repositories

OTM'11 Proceedings of the 2011th Confederated international conference on On the move to meaningful internet systems
Ontology-based structured web data warehouses for sustainable interoperability: requirement modeling, design methodology and tool

Computers in Industry
Towards ontology-based OLAP: datalog-based reasoning over multidimensional ontologies

Proceedings of the fifteenth international workshop on Data warehousing and OLAP
Query processing on cubes mapped from ontologies to dimension hierarchies

Proceedings of the fifteenth international workshop on Data warehousing and OLAP
Using domain ontologies as semantic dimensions in data warehouses

ER'12 Proceedings of the 31st international conference on Conceptual Modeling

Quantified Score

Hi-index	0.00

Visualization

Abstract

Ontologies become more popular in various domains. In database, they contribute largely in designing operational databases, that we call ontology-based databases (OBDB). An OBDB stores ontology and their instances in the same repository. Several DBMS propose solutions to manipulate and query this type of databases. As consequence, these operational OBDB become a candidate to feed data warehouses (DW). In this paper, we propose a new conceptual design methodology of DW from data residing in various OBDB that takes into account sources and decision maker requirements. As the result, a semantic DW model is generated. The presence of ontology within a DW facilitates its querying in semantic level and its future integration with other DW built using our methodology. Finally, we present a case tool, called S2RWC, supporting our proposal.