Paper Info
Title
Natural language reporting for ETL processes
Abstract
The conceptual design of the Extract -- Transform -- Load (ETL) processes is a crucial, burdensome, and challenging procedure that takes places at the early phases of a Data Warehouse project. Several models have been proposed for the conceptual design and representation 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 a previous work, we have relaxed the former difficulty by working on the automation of the conceptual design leveraging Semantic Web technology. In this paper, we built upon our previous results and we tackle the second issue by investigating the application of natural language generation techniques to the ETL environment. In particular, we 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 knowledge of any specific model. We discuss how linguistic techniques can be used for the establishment of a common application vocabulary. Finally, we present a flexible and customizable template-based mechanism for generating natural language representations for the ETL process requirements and operations.
Year
DOI
Venue
2008
10.1145/1458432.1458444
DOLAP
Keywords
Field
DocType
natural language representation,etl environment,natural language reporting,conceptual etl design,natural mean,natural language generation technique,previous work,etl process requirement,conceptual design,previous result,common application vocabulary,metadata,data warehouse,natural language,data warehouses,conceptual model,semantic web,ontologies
Natural language generation,Ontology (information science),Data warehouse,Data mining,Conceptual design,Conceptual model,Computer science,Semantic Web,Natural language,Vocabulary,Database
Conference
Citations 
PageRank 
References 
11
0.63
19
Authors
3
Name
Order
Citations
PageRank
Alkis Simitsis1166594.62
Dimitrios Skoutas283355.09
Malú Castellanos335174.33