2012 · 18 citations · 6 references
ComputingInformation SystemsInformation TechnologyBusiness IntelligenceData MiningDatabasesData IntegrationData PreprocessingData TransformationData WarehousingDatabase ManagementExtract, Transform, LoadExtractExtract (Etl) ProcessesExtract, Load, Transform (Elt) ArchitectureExtract, Transform, Load (Etl)Extract, Transform, Load (Etl) ArchitectureLoad (Etl) ProcessesStar SchemaTransform (Etl) Processes
The extract, transform and Load (ETL) tool is extracting data from multiple, heterogeneous data source, transforming data, and finally loading data into the data warehouse. It is the foundation of any data warehouse, data mining and business intelligence. The land and resources system usually adopts star schema database, so it is difficult to transform the data from source database to target warehouse. This paper research the key technologies of ETL, including data extracting,data transforming, data incremental loading and break-points transmission.
6
Conceptual modeling for ETL processes
Panos Vassiliadis, Alkis Simitsis, Spiros Skiadopoulos · 2002 · 378 citations · Full text
Optimizing ETL Processes in Data Warehouses
Alkis Simitsis, Panos Vassiliadis, Timos Sellis · 2005 · 207 citations · Full text
Mapping conceptual to logical models for ETL processes
Alkis Simitsis · 2005 · 66 citations
Orchid: Integrating Schema Mapping and ETL
Mauricio A. Hernández, Ryan Wisnesky, Ahmed Radwan et al. · 2008 · 64 citations
Towards generating ETL processes for incremental loading
Thomas Jörg, Stefan Deßloch · 2008 · 55 citations