A method for the mapping of conceptual designs to logical blueprints for ETL processes

Simitsis, A; Vassiliadis, P

dc.contributor.author	Simitsis, A	en
dc.contributor.author	Vassiliadis, P	en
dc.date.accessioned	2014-03-01T01:27:42Z
dc.date.available	2014-03-01T01:27:42Z
dc.date.issued	2008	en
dc.identifier.issn	0167-9236	en
dc.identifier.uri	https://dspace.lib.ntua.gr/xmlui/handle/123456789/18547
dc.subject	Conceptual modeling	en
dc.subject	Data warehouses	en
dc.subject	ETL	en
dc.subject	Logical modeling	en
dc.subject.classification	Computer Science, Artificial Intelligence	en
dc.subject.classification	Computer Science, Information Systems	en
dc.subject.classification	Operations Research & Management Science	en
dc.subject.other	Blueprints	en
dc.subject.other	Conceptual design	en
dc.subject.other	Data warehouses	en
dc.subject.other	Project management	en
dc.subject.other	Conceptual model	en
dc.subject.other	Logical modeling	en
dc.subject.other	Computer aided software engineering	en
dc.title	A method for the mapping of conceptual designs to logical blueprints for ETL processes	en
heal.type	journalArticle	en
heal.identifier.primary	10.1016/j.dss.2006.12.002	en
heal.identifier.secondary	http://dx.doi.org/10.1016/j.dss.2006.12.002	en
heal.language	English	en
heal.publicationDate	2008	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 previous work, we presented a modeling framework for ETL processes comprised of a conceptual model that concretely deals with the early stages of a data warehouse project, and a logical model that deals with the definition of data-centric workflows. In this paper, we describe the mapping of the conceptual model to the logical model. First, we identify how conceptual entities are mapped to logical entities. Next, we determine the execution order in the logical workflow using information adapted from the conceptual model. Finally, we provide a method for the transition from the conceptual model to the logical model. (C) 2006 Elsevier B.V. All rights reserved.	en
heal.publisher	ELSEVIER SCIENCE BV	en
heal.journalName	Decision Support Systems	en
dc.identifier.doi	10.1016/j.dss.2006.12.002	en
dc.identifier.isi	ISI:000255734400003	en
dc.identifier.volume	45	en
dc.identifier.issue	1	en
dc.identifier.spage	22	en
dc.identifier.epage	40	en