Handbook of graph grammars and computing by graph transformation: volume I. foundations
Handbook of graph grammars and computing by graph transformation: volume I. foundations
A New Algorithm for Error-Tolerant Subgraph Isomorphism Detection
IEEE Transactions on Pattern Analysis and Machine Intelligence
IEEE Transactions on Pattern Analysis and Machine Intelligence
Conceptual modeling for ETL processes
Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP
NLDB '02 Proceedings of the 6th International Conference on Applications of Natural Language to Information Systems-Revised Papers
A survey of approaches to automatic schema matching
The VLDB Journal — The International Journal on Very Large Data Bases
G-ToPSS: fast filtering of graph-based metadata
WWW '05 Proceedings of the 14th international conference on World Wide Web
State-Space Optimization of ETL Workflows
IEEE Transactions on Knowledge and Data Engineering
Applying MDA to the development of data warehouses
Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
Designing ETL processes using semantic web technologies
DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
Automating multidimensional design from ontologies
Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
Yahoo! pipes
Natural language reporting for ETL processes
Proceedings of the ACM 11th international workshop on Data warehousing and OLAP
A generic and customizable framework for the design of ETL scenarios
Information Systems - Special issue: The 15th international conference on advanced information systems engineering (CAiSE 2003)
Automatically composing data workflows with relational descriptions and shim services
ISWC'07/ASWC'07 Proceedings of the 6th international The semantic web and 2nd Asian conference on Asian semantic web conference
Potluck: semi-ontology alignment for casual users
ISWC'07/ASWC'07 Proceedings of the 6th international The semantic web and 2nd Asian conference on Asian semantic web conference
Semantic matching: algorithms and implementation
Journal on data semantics IX
A survey of schema-based matching approaches
Journal on Data Semantics IV
How to tame a very large ER diagram (using link analysis and force-directed drawing algorithms)
ER'05 Proceedings of the 24th international conference on Conceptual Modeling
Enriching data warehouse dimension hierarchies by using semantic relations
BNCOD'06 Proceedings of the 23rd British National Conference on Databases, conference on Flexible and Efficient Information Handling
Flexible and customizable NL representation of requirements for ETL processes
NLDB'07 Proceedings of the 12th international conference on Applications of Natural Language to Information Systems
A model-driven framework for ETL process development
Proceedings of the ACM 14th international workshop on Data Warehousing and OLAP
A BPMN-Based Design and Maintenance Framework for ETL Processes
International Journal of Data Warehousing and Mining
Hi-index | 0.00 |
One of the main tasks during the early steps of a data warehouse project is the identification of the appropriate transformations and the specification of inter-schema mappings from the source to the target data stores. This is a challenging task, requiring firstly the semantic and secondly the structural reconciliation of the information provided by the available sources. This task is a part of the Extract-Transform-Load (ETL) process, which is responsible for the population of the data warehouse. In this paper, we propose a customizable and extensible ontology-driven approach for the conceptual design of ETL processes. A graph-based representation is used as a conceptual model for the source and target data stores. We then present a method for devising flows of ETL operations by means of graph transformations. In particular, the operations comprising the ETL process are derived through graph transformation rules, the choice and applicability of which are determined by the semantics of the data with respect to an attached domain ontology. Finally, we present our experimental findings that demonstrate the applicability of our approach.