Matches in SemOpenAlex for { <https://semopenalex.org/work/W2153309623> ?p ?o ?g. }
- W2153309623 endingPage "1440" @default.
- W2153309623 startingPage "1417" @default.
- W2153309623 abstract "Data warehouse loading and refreshment is typically performed by means of complex software processes called extraction–transformation–loading (ETL). In this paper, we propose a system based on a suite of visual languages for mastering several aspects of the ETL development process, turning it into a visual programming task. The approach can be easily generalized and applied to other data integration contexts beyond data warehouses. It introduces two new visual languages that are used to specify the ETL process, which can also be represented by means of UML activity diagrams. In particular, the first visual language supports data manipulation activities, whereas the second one provides traceability information of attributes to highlight the impact of potential transformations on integrated schemas depending on them. Once the whole ETL process has been visually specified, the designer might invoke the automatic generation of an activity diagram representing a possible orchestration of it based on its dependencies. The designer can edit such a diagram to modify the proposed orchestration provided that changes do not alter data dependencies. The final specification can be translated into code that is executable on the data sources. Finally, the effectiveness of the proposed approach has been validated through a user study in which we have compared the effort needed to design an ETL process in our approach with respect to the one required with main visual approaches described in the literature.Copyright © 2013 John Wiley & Sons, Ltd." @default.
- W2153309623 created "2016-06-24" @default.
- W2153309623 creator A5018172218 @default.
- W2153309623 creator A5041872893 @default.
- W2153309623 creator A5074856207 @default.
- W2153309623 creator A5083976078 @default.
- W2153309623 date "2013-05-20" @default.
- W2153309623 modified "2023-09-27" @default.
- W2153309623 title "A visual language-based system for extraction-transformation-loading development" @default.
- W2153309623 cites W1516952047 @default.
- W2153309623 cites W1541535863 @default.
- W2153309623 cites W1966294080 @default.
- W2153309623 cites W1967093902 @default.
- W2153309623 cites W1970657608 @default.
- W2153309623 cites W1971518725 @default.
- W2153309623 cites W1982212058 @default.
- W2153309623 cites W1993582687 @default.
- W2153309623 cites W200788562 @default.
- W2153309623 cites W2014763157 @default.
- W2153309623 cites W2032667551 @default.
- W2153309623 cites W2075518254 @default.
- W2153309623 cites W2096347930 @default.
- W2153309623 cites W2099185267 @default.
- W2153309623 cites W2100211863 @default.
- W2153309623 cites W2108132403 @default.
- W2153309623 cites W2130929089 @default.
- W2153309623 cites W2140109318 @default.
- W2153309623 cites W2153834102 @default.
- W2153309623 cites W2158643472 @default.
- W2153309623 cites W2166006219 @default.
- W2153309623 cites W2166261528 @default.
- W2153309623 cites W2167234995 @default.
- W2153309623 cites W22588544 @default.
- W2153309623 cites W4250102289 @default.
- W2153309623 cites W4252729912 @default.
- W2153309623 doi "https://doi.org/10.1002/spe.2201" @default.
- W2153309623 hasPublicationYear "2013" @default.
- W2153309623 type Work @default.
- W2153309623 sameAs 2153309623 @default.
- W2153309623 citedByCount "11" @default.
- W2153309623 countsByYear W21533096232014 @default.
- W2153309623 countsByYear W21533096232016 @default.
- W2153309623 countsByYear W21533096232018 @default.
- W2153309623 countsByYear W21533096232022 @default.
- W2153309623 crossrefType "journal-article" @default.
- W2153309623 hasAuthorship W2153309623A5018172218 @default.
- W2153309623 hasAuthorship W2153309623A5041872893 @default.
- W2153309623 hasAuthorship W2153309623A5074856207 @default.
- W2153309623 hasAuthorship W2153309623A5083976078 @default.
- W2153309623 hasConcept C115903868 @default.
- W2153309623 hasConcept C133162039 @default.
- W2153309623 hasConcept C135572916 @default.
- W2153309623 hasConcept C138885662 @default.
- W2153309623 hasConcept C142362112 @default.
- W2153309623 hasConcept C145644426 @default.
- W2153309623 hasConcept C150670458 @default.
- W2153309623 hasConcept C153349607 @default.
- W2153309623 hasConcept C160145156 @default.
- W2153309623 hasConcept C199168358 @default.
- W2153309623 hasConcept C199360897 @default.
- W2153309623 hasConcept C26517878 @default.
- W2153309623 hasConcept C2777904410 @default.
- W2153309623 hasConcept C2780878386 @default.
- W2153309623 hasConcept C38652104 @default.
- W2153309623 hasConcept C41008148 @default.
- W2153309623 hasConcept C41895202 @default.
- W2153309623 hasConcept C558565934 @default.
- W2153309623 hasConcept C64219723 @default.
- W2153309623 hasConcept C77088390 @default.
- W2153309623 hasConcept C98045186 @default.
- W2153309623 hasConceptScore W2153309623C115903868 @default.
- W2153309623 hasConceptScore W2153309623C133162039 @default.
- W2153309623 hasConceptScore W2153309623C135572916 @default.
- W2153309623 hasConceptScore W2153309623C138885662 @default.
- W2153309623 hasConceptScore W2153309623C142362112 @default.
- W2153309623 hasConceptScore W2153309623C145644426 @default.
- W2153309623 hasConceptScore W2153309623C150670458 @default.
- W2153309623 hasConceptScore W2153309623C153349607 @default.
- W2153309623 hasConceptScore W2153309623C160145156 @default.
- W2153309623 hasConceptScore W2153309623C199168358 @default.
- W2153309623 hasConceptScore W2153309623C199360897 @default.
- W2153309623 hasConceptScore W2153309623C26517878 @default.
- W2153309623 hasConceptScore W2153309623C2777904410 @default.
- W2153309623 hasConceptScore W2153309623C2780878386 @default.
- W2153309623 hasConceptScore W2153309623C38652104 @default.
- W2153309623 hasConceptScore W2153309623C41008148 @default.
- W2153309623 hasConceptScore W2153309623C41895202 @default.
- W2153309623 hasConceptScore W2153309623C558565934 @default.
- W2153309623 hasConceptScore W2153309623C64219723 @default.
- W2153309623 hasConceptScore W2153309623C77088390 @default.
- W2153309623 hasConceptScore W2153309623C98045186 @default.
- W2153309623 hasIssue "12" @default.
- W2153309623 hasLocation W21533096231 @default.
- W2153309623 hasOpenAccess W2153309623 @default.
- W2153309623 hasPrimaryLocation W21533096231 @default.
- W2153309623 hasRelatedWork W1515054923 @default.
- W2153309623 hasRelatedWork W1995786580 @default.
- W2153309623 hasRelatedWork W2009376878 @default.