{"title":"ETL, ELT和反向ETL:一个商业案例研究","authors":"Bharat Singhal, A. Aggarwal","doi":"10.1109/ICATIECE56365.2022.10046997","DOIUrl":null,"url":null,"abstract":"Most organizations today rely heavily on their data warehouse to make enterprise level decisions. Data Warehouse pulls data from various heterogeneous sources and thus, when setting up a data warehouse, there are three ways to process data: ELT (Extract, Load and Transform), ETL (Extract, Transform and Load) and reverse ETL. It can be challenging to select the best approach when deciding how to implement a data warehouse because it has to do with costs, procedures, performance, and ongoing company improvement. In this paper, we'll be discussing the three approaches and their use cases.","PeriodicalId":199942,"journal":{"name":"2022 Second International Conference on Advanced Technologies in Intelligent Control, Environment, Computing & Communication Engineering (ICATIECE)","volume":"267 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2022-12-16","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"ETL, ELT and Reverse ETL: A business case Study\",\"authors\":\"Bharat Singhal, A. Aggarwal\",\"doi\":\"10.1109/ICATIECE56365.2022.10046997\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"Most organizations today rely heavily on their data warehouse to make enterprise level decisions. Data Warehouse pulls data from various heterogeneous sources and thus, when setting up a data warehouse, there are three ways to process data: ELT (Extract, Load and Transform), ETL (Extract, Transform and Load) and reverse ETL. It can be challenging to select the best approach when deciding how to implement a data warehouse because it has to do with costs, procedures, performance, and ongoing company improvement. In this paper, we'll be discussing the three approaches and their use cases.\",\"PeriodicalId\":199942,\"journal\":{\"name\":\"2022 Second International Conference on Advanced Technologies in Intelligent Control, Environment, Computing & Communication Engineering (ICATIECE)\",\"volume\":\"267 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2022-12-16\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2022 Second International Conference on Advanced Technologies in Intelligent Control, Environment, Computing & Communication Engineering (ICATIECE)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/ICATIECE56365.2022.10046997\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2022 Second International Conference on Advanced Technologies in Intelligent Control, Environment, Computing & Communication Engineering (ICATIECE)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ICATIECE56365.2022.10046997","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Most organizations today rely heavily on their data warehouse to make enterprise level decisions. Data Warehouse pulls data from various heterogeneous sources and thus, when setting up a data warehouse, there are three ways to process data: ELT (Extract, Load and Transform), ETL (Extract, Transform and Load) and reverse ETL. It can be challenging to select the best approach when deciding how to implement a data warehouse because it has to do with costs, procedures, performance, and ongoing company improvement. In this paper, we'll be discussing the three approaches and their use cases.
求助内容：
应助结果提醒方式：
京公网安备 11010802042870号
