Natural language reporting for ETL processes

Simitsis, A; Skoutas, D; Castellanos, M

dc.contributor.author	Simitsis, A	en
dc.contributor.author	Skoutas, D	en
dc.contributor.author	Castellanos, M	en
dc.date.accessioned	2014-03-01T02:45:40Z
dc.date.available	2014-03-01T02:45:40Z
dc.date.issued	2008	en
dc.identifier.uri	https://dspace.lib.ntua.gr/xmlui/handle/123456789/32324
dc.subject	Conceptual model	en
dc.subject	Data warehouses	en
dc.subject	ETL	en
dc.subject	Metadata	en
dc.subject	Natural language	en
dc.subject	Ontologies	en
dc.subject	Semantic web	en
dc.subject.other	Conceptual model	en
dc.subject.other	Customizable	en
dc.subject.other	ETL	en
dc.subject.other	ETL process	en
dc.subject.other	Extract transform loads	en
dc.subject.other	Linguistic techniques	en
dc.subject.other	Natural language	en
dc.subject.other	Natural Language Generation techniques	en
dc.subject.other	Natural language representation	en
dc.subject.other	Natural languages	en
dc.subject.other	Semantic Web technology	en
dc.subject.other	Template-based	en
dc.subject.other	Conceptual design	en
dc.subject.other	Knowledge management	en
dc.subject.other	Knowledge representation	en
dc.subject.other	Linguistics	en
dc.subject.other	Metadata	en
dc.subject.other	Multi agent systems	en
dc.subject.other	Ontology	en
dc.subject.other	Semantic Web	en
dc.subject.other	Semantics	en
dc.subject.other	Data warehouses	en
dc.title	Natural language reporting for ETL processes	en
heal.type	conferenceItem	en
heal.identifier.primary	10.1145/1458432.1458444	en
heal.identifier.secondary	http://dx.doi.org/10.1145/1458432.1458444	en
heal.publicationDate	2008	en
heal.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. Copyright 2008 ACM.	en
heal.journalName	DOLAP: Proceedings of the ACM International Workshop on Data Warehousing and OLAP	en
dc.identifier.doi	10.1145/1458432.1458444	en
dc.identifier.spage	65	en
dc.identifier.epage	72	en