{"id":176,"date":"2013-05-23T11:31:09","date_gmt":"2013-05-23T15:31:09","guid":{"rendered":"https:\/\/solutionsreview.com\/data-integration\/?p=176"},"modified":"2016-10-05T10:52:11","modified_gmt":"2016-10-05T14:52:11","slug":"the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse","status":"publish","type":"post","link":"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/","title":{"rendered":"The Evolution of Extract, Transform and Load – ETL – in the Data Warehouse"},"content":{"rendered":"

\"The<\/a>There are few better online sources than the BeyeNETWORK which focuses on business intelligence, performance management, data warehousing, data integration and data quality. And one of their best blog experts is Dr. Bin Jiang a Distinguished Professor of a large university in China, and the author of the book Constructing Data Warehouses with Metadata-driven Generic Operators.<\/p>\n

Dr. Jiang’s most recent post is a great review of the “architectural evolution road that data warehouses generally have followed in the past and the possibilities leading to the future. In this article, he focus eson the placement and treatment evolution of three major functionalities within data warehouses, i.e., extracting data (E), transforming data (T) and loading data (L). In most cases, this placement decides the effectiveness of the resulting data warehouses.”<\/p>\n

Be sure to check out the summary by the good doctor of the four evolutional phases of data warehouse architecture discussed along with the five driving forces. “As a matter of fact, the validity of the discussion results obtained in this article is not limited only to data warehouses. They are also valid with regard to the so-called enterprise data integration in general”, concludes Dr. Jiang.<\/p>\n

A link to the print version on the BeyeNetwork can be found here.<\/a><\/p>\n
Widget not in any sidebars
\n","protected":false},"excerpt":{"rendered":"

There are few better online sources than the BeyeNETWORK which focuses on business intelligence, performance management, data warehousing, data integration and data quality. And one of their best blog experts is Dr. Bin Jiang a Distinguished Professor of a large university in China, and the author of the book Constructing Data Warehouses with Metadata-driven Generic […]<\/p>\n","protected":false},"author":1,"featured_media":177,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[],"acf":[],"yoast_head":"\nThe Evolution of Extract, Transform and Load - ETL - in the Data Warehouse » Data Integration Tools & ETL Software | Solutions Review<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Doug Atkinson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/\"},\"author\":{\"name\":\"Doug Atkinson\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/5992f02d38e7b28251ad933cd131dcae\"},\"headline\":\"The Evolution of Extract, Transform and Load – ETL – in the Data Warehouse\",\"datePublished\":\"2013-05-23T15:31:09+00:00\",\"dateModified\":\"2016-10-05T14:52:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/\"},\"wordCount\":227,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#organization\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2013\/05\/Featured_Image_Data_Integration_Bin_Jiang.jpg\",\"articleSection\":[\"Best Practices\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/\",\"name\":\"The Evolution of Extract, Transform and Load - ETL - in the Data Warehouse » Data Integration Tools & ETL Software | Solutions Review\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2013\/05\/Featured_Image_Data_Integration_Bin_Jiang.jpg\",\"datePublished\":\"2013-05-23T15:31:09+00:00\",\"dateModified\":\"2016-10-05T14:52:11+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/#primaryimage\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2013\/05\/Featured_Image_Data_Integration_Bin_Jiang.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2013\/05\/Featured_Image_Data_Integration_Bin_Jiang.jpg\",\"width\":600,\"height\":270,\"caption\":\"The Evolution of ETL in the Data Warehouse\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/solutionsreview.com\/data-integration\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Evolution of Extract, Transform and Load – ETL – in the Data Warehouse\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#website\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/\",\"name\":\"Data Integration Tools & ETL Software | Solutions Review\",\"description\":\"Evaluating Enterprise ETL Tools, Cloud iPaaS & Real-Time Data Streaming Platforms.\",\"publisher\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/solutionsreview.com\/data-integration\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#organization\",\"name\":\"Solutions Review\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2016\/02\/Solutions_Review_Header_Data_Integration_225.png\",\"contentUrl\":\"https:\/\/solutionsreview.com\/data-integration\/files\/2016\/02\/Solutions_Review_Header_Data_Integration_225.png\",\"width\":225,\"height\":90,\"caption\":\"Solutions Review\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/5992f02d38e7b28251ad933cd131dcae\",\"name\":\"Doug Atkinson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/092cfcbe5c7f2c185c21f152aada2d2f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/092cfcbe5c7f2c185c21f152aada2d2f?s=96&d=mm&r=g\",\"caption\":\"Doug Atkinson\"},\"description\":\"An entrepreneur and executive with a passion for enterprise technology, Doug founded Solutions Review in 2012. He has previously served as a newspaper boy, a McDonald's grill cook, a bartender, a political consultant, a web developer, the VP of Sales for e-Dialog - a digital marketing agency - and as Special Assistant to Governor William Weld of Massachusetts.\",\"sameAs\":[\"https:\/\/solutionsreview.com\"],\"url\":\"https:\/\/solutionsreview.com\/data-integration\/author\/doug-atkinson-4\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The Evolution of Extract, Transform and Load - ETL - in the Data Warehouse » Data Integration Tools & ETL Software | Solutions Review","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/","twitter_misc":{"Written by":"Doug Atkinson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/#article","isPartOf":{"@id":"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/"},"author":{"name":"Doug Atkinson","@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/5992f02d38e7b28251ad933cd131dcae"},"headline":"The Evolution of Extract, Transform and Load – ETL – in the Data Warehouse","datePublished":"2013-05-23T15:31:09+00:00","dateModified":"2016-10-05T14:52:11+00:00","mainEntityOfPage":{"@id":"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/"},"wordCount":227,"commentCount":0,"publisher":{"@id":"https:\/\/solutionsreview.com\/data-integration\/#organization"},"image":{"@id":"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2013\/05\/Featured_Image_Data_Integration_Bin_Jiang.jpg","articleSection":["Best Practices"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/","url":"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/","name":"The Evolution of Extract, Transform and Load - ETL - in the Data Warehouse » Data Integration Tools & ETL Software | Solutions Review","isPartOf":{"@id":"https:\/\/solutionsreview.com\/data-integration\/#website"},"primaryImageOfPage":{"@id":"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/#primaryimage"},"image":{"@id":"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2013\/05\/Featured_Image_Data_Integration_Bin_Jiang.jpg","datePublished":"2013-05-23T15:31:09+00:00","dateModified":"2016-10-05T14:52:11+00:00","breadcrumb":{"@id":"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/#primaryimage","url":"https:\/\/solutionsreview.com\/data-integration\/files\/2013\/05\/Featured_Image_Data_Integration_Bin_Jiang.jpg","contentUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2013\/05\/Featured_Image_Data_Integration_Bin_Jiang.jpg","width":600,"height":270,"caption":"The Evolution of ETL in the Data Warehouse"},{"@type":"BreadcrumbList","@id":"https:\/\/solutionsreview.com\/data-integration\/the-evolution-of-extract-transform-and-load-etl-in-the-data-warehouse\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/solutionsreview.com\/data-integration\/"},{"@type":"ListItem","position":2,"name":"The Evolution of Extract, Transform and Load – ETL – in the Data Warehouse"}]},{"@type":"WebSite","@id":"https:\/\/solutionsreview.com\/data-integration\/#website","url":"https:\/\/solutionsreview.com\/data-integration\/","name":"Data Integration Tools & ETL Software | Solutions Review","description":"Evaluating Enterprise ETL Tools, Cloud iPaaS & Real-Time Data Streaming Platforms.","publisher":{"@id":"https:\/\/solutionsreview.com\/data-integration\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/solutionsreview.com\/data-integration\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/solutionsreview.com\/data-integration\/#organization","name":"Solutions Review","url":"https:\/\/solutionsreview.com\/data-integration\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/logo\/image\/","url":"https:\/\/solutionsreview.com\/data-integration\/files\/2016\/02\/Solutions_Review_Header_Data_Integration_225.png","contentUrl":"https:\/\/solutionsreview.com\/data-integration\/files\/2016\/02\/Solutions_Review_Header_Data_Integration_225.png","width":225,"height":90,"caption":"Solutions Review"},"image":{"@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/5992f02d38e7b28251ad933cd131dcae","name":"Doug Atkinson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-integration\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/092cfcbe5c7f2c185c21f152aada2d2f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/092cfcbe5c7f2c185c21f152aada2d2f?s=96&d=mm&r=g","caption":"Doug Atkinson"},"description":"An entrepreneur and executive with a passion for enterprise technology, Doug founded Solutions Review in 2012. He has previously served as a newspaper boy, a McDonald's grill cook, a bartender, a political consultant, a web developer, the VP of Sales for e-Dialog - a digital marketing agency - and as Special Assistant to Governor William Weld of Massachusetts.","sameAs":["https:\/\/solutionsreview.com"],"url":"https:\/\/solutionsreview.com\/data-integration\/author\/doug-atkinson-4\/"}]}},"_links":{"self":[{"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/posts\/176"}],"collection":[{"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/comments?post=176"}],"version-history":[{"count":0,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/posts\/176\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/media\/177"}],"wp:attachment":[{"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/media?parent=176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/categories?post=176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solutionsreview.com\/data-integration\/wp-json\/wp\/v2\/tags?post=176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}