Conceptual modeling for ETL processes

Vassiliadis, P; Simitsis, A; Skiadopoulos, S

dc.contributor.author	Vassiliadis, P	en
dc.contributor.author	Simitsis, A	en
dc.contributor.author	Skiadopoulos, S	en
dc.date.accessioned	2014-03-01T02:42:05Z
dc.date.available	2014-03-01T02:42:05Z
dc.date.issued	2002	en
dc.identifier.uri	https://dspace.lib.ntua.gr/xmlui/handle/123456789/30773
dc.subject	Conceptual modeling	en
dc.subject	Data warehousing	en
dc.subject	ETL	en
dc.subject.other	Costs	en
dc.subject.other	Data structures	en
dc.subject.other	Data warehouses	en
dc.subject.other	Database systems	en
dc.subject.other	Logic design	en
dc.subject.other	Data cleaning	en
dc.subject.other	Data sources	en
dc.subject.other	Data staging area	en
dc.subject.other	Extraction-transformation-loading tools	en
dc.subject.other	Computer aided software engineering	en
dc.title	Conceptual modeling for ETL processes	en
heal.type	conferenceItem	en
heal.identifier.primary	10.1145/583890.583893	en
heal.identifier.secondary	http://dx.doi.org/10.1145/583890.583893	en
heal.publicationDate	2002	en
heal.abstract	Extraction-Transformation-Loading (ETL) tools are pieces of software responsible for the extraction of data from several sources, their cleansing, customization and insertion into a data warehouse. In this paper, we focus on the problem of the definition of ETL activities and provide formal foundations for their conceptual representation. The proposed conceptual model is (a) customized for the tracing of inter-attribute relationships and the respective ETL activities in the early stages of a data warehouse project; (b) enriched with a 'palette' of a set of frequently used ETL activities, like the assignment of surrogate keys, the check for null values, etc; and (c) constructed in a customizable and extensible manner, so that the designer can enrich it with his own re-occurring patterns for ETL activities.	en
heal.journalName	ACM International Workshop on Data Warehousing and OLAP (DOLAP)	en
dc.identifier.doi	10.1145/583890.583893	en
dc.identifier.spage	14	en
dc.identifier.epage	21	en