Conceptual modeling for ETL processes
Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP
Naive Semantics to Support Automated Database Design
IEEE Transactions on Knowledge and Data Engineering
NLDB '02 Proceedings of the 6th International Conference on Applications of Natural Language to Information Systems-Revised Papers
Aggregation in Natural Language Generation
EWNLG '93 Selected papers from the Fourth European Workshop on Trends in Natural Language Generation, An Artificial Intelligence Perspective
Contextual Knowledge Representation for Requirements Documents in Natural Language
Proceedings of the Fifteenth International Florida Artificial Intelligence Research Society Conference
Transformation of Requirement Specifications Expressed in Natural Language into an EER Model
ER '93 Proceedings of the 12th International Conference on the Entity-Relationship Approach: Entity-Relationship Approach
ER '93 Proceedings of the 12th International Conference on the Entity-Relationship Approach: Entity-Relationship Approach
A survey of approaches to automatic schema matching
The VLDB Journal — The International Journal on Very Large Data Bases
State-Space Optimization of ETL Workflows
IEEE Transactions on Knowledge and Data Engineering
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)
Applying MDA to the development of data warehouses
Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
Mapping conceptual to logical models for ETL processes
Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
Real versus Template-Based Natural Language Generation: A False Opposition?
Computational Linguistics
A user profile-based approach for personal information access: shaping your information portfolio
Proceedings of the 15th international conference on World Wide Web
Designing ETL processes using semantic web technologies
DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
Toward expressive syndication on the web
Proceedings of the 16th international conference on World Wide Web
Automating multidimensional design from ontologies
Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
Synthesizing structured text from logical database subsets
EDBT '08 Proceedings of the 11th international conference on Extending database technology: Advances in database technology
Discovering topical structures of databases
Proceedings of the 2008 ACM SIGMOD international conference on Management of data
Natural language reporting for ETL processes
Proceedings of the ACM 11th international workshop on Data warehousing and OLAP
The Data Warehouse Lifecycle Toolkit
The Data Warehouse Lifecycle Toolkit
Using OCL for automatically producing multidimensional models and ETL processes
DaWaK'12 Proceedings of the 14th international conference on Data Warehousing and Knowledge Discovery
Harvesting models from web 2.0 databases
Software and Systems Modeling (SoSyM)
| Hi-index | 0.00 |
Extract-Transform-Load (ETL) processes constitute the back stage of Data Warehouse architectures. Several studies characterize the ETL design as a time-consuming and error-prone procedure. A critical phase in the ETL lifecycle involves the early communications and design steps that aim at producing a conceptual ETL design. Various research approaches have dealt with the conceptual modeling of ETL processes, but all share two inconveniences: they require intensive human effort from the designers to create them, as well as technical knowledge from the business people to understand them. In this paper, we focus on the second aspect and provide a method for the representation of a conceptual ETL design as a narrative, which is the most natural means of communication and does not require particular technical skills or familiarity with any specific model. Specifically, this work builds upon previously proposed techniques that automate the conceptual design by leveraging Semantic Web technology. The key idea is to map the involved data stores, either source or target, to a domain ontology and then, to use a reasoner for producing the ETL design. We discuss how linguistic techniques can be used for the establishment of a common application vocabulary. We present a flexible and customizable template-based mechanism for the representation of the ETL design as a narrative. Finally, we discuss issues related to the production of meaningful reports and we provide implementation details.