Silhouettes: a graphical aid to the interpretation and validation of cluster analysis
Journal of Computational and Applied Mathematics
A guided tour to approximate string matching
ACM Computing Surveys (CSUR)
On Clustering Validation Techniques
Journal of Intelligent Information Systems
ODB-QOPTIMIZER: A Tool for Semantic Query Optimization in OODB
ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
Synthesizing an Integrated Ontology
IEEE Internet Computing
Optimizing ETL Processes in Data Warehouses
ICDE '05 Proceedings of the 21st International Conference on Data Engineering
Designing ETL processes using semantic web technologies
DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
Extracting Relevant Attribute Values for Improved Search
IEEE Internet Computing
A method for the mapping of conceptual designs to logical blueprints for ETL processes
Decision Support Systems
Orchid: Integrating Schema Mapping and ETL
ICDE '08 Proceedings of the 2008 IEEE 24th International Conference on Data Engineering
The Emerging Web of Linked Data
IEEE Intelligent Systems
Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP
Principles for an ETL Benchmark
Performance Evaluation and Benchmarking
Schema Normalization for Improving Schema Matching
ER '09 Proceedings of the 28th International Conference on Conceptual Modeling
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)
Automatic annotation in data integration systems
OTM'07 Proceedings of the 2007 OTM confederated international conference on On the move to meaningful internet systems - Volume Part I
Automatic lexical annotation applied to the SCARLET ontology matcher
ACIIDS'10 Proceedings of the Second international conference on Intelligent information and database systems: Part II
Rule-Based management of schema changes at ETL sources
ADBIS'09 Proceedings of the 13th East European conference on Advances in Databases and Information Systems
A semantically enhanced service repository for user-centric service discovery and management
Data & Knowledge Engineering
| Hi-index | 0.00 |
Data warehouse architectures rely on extraction, transformation and loading (ETL) processes for the creation of an updated, consistent and materialized view of a set of data sources. In this paper, we support these processes by proposing a tool that: (1) allows the semi-automatic definition of inter-attribute semantic mappings, by identifying the parts of the data source schemas which are related to the data warehouse schema, thus supporting the extraction process; and (2) groups the attribute values semantically related thus defining a transformation function for populating with homogeneous values the data warehouse. Our proposal couples and extends the functionalities of two previously developed systems: the MOMIS integration system and the RELEVANT data analysis system. The system has been experimented within a real scenario concerning the creation of a data warehouse for enterprises working in the beverage and food logistic area. The results showed that the coupled system supports effectively the extraction and transformation processes.