{"title":"Novel approach in ETL","authors":"A. Prema, A. Pethalakshmi","doi":"10.1109/ICPRIME.2013.6496515","DOIUrl":null,"url":null,"abstract":"The term ETL which stands for Extraction, Transformation, and Loading is a batch or scheduled data integration process that includes extracting data from their operational or external data sources, transforming the data into an appropriate format, and loading the data into a data warehouse repository. Through the study of Extract, Transform, and Load (ETL) hypothesis, a new ETL is designed, which is titled as Hyper-ETL for increasing an efficiency of ETL process. Hyper-ETL allows the integration of XML document file and Oracle data warehouse to reduce an execution time and to remove the mismanagement of metadata in an existing ETL process.","PeriodicalId":123210,"journal":{"name":"2013 International Conference on Pattern Recognition, Informatics and Mobile Engineering","volume":"87 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2013-04-15","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"8","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"2013 International Conference on Pattern Recognition, Informatics and Mobile Engineering","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ICPRIME.2013.6496515","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 8
Abstract
The term ETL which stands for Extraction, Transformation, and Loading is a batch or scheduled data integration process that includes extracting data from their operational or external data sources, transforming the data into an appropriate format, and loading the data into a data warehouse repository. Through the study of Extract, Transform, and Load (ETL) hypothesis, a new ETL is designed, which is titled as Hyper-ETL for increasing an efficiency of ETL process. Hyper-ETL allows the integration of XML document file and Oracle data warehouse to reduce an execution time and to remove the mismanagement of metadata in an existing ETL process.
术语ETL代表提取、转换和加载，它是一个批处理或计划的数据集成过程，包括从操作数据源或外部数据源提取数据，将数据转换为适当的格式，并将数据加载到数据仓库存储库中。通过对ETL (Extract, Transform, and Load)假说的研究，设计了一种新的ETL，称为Hyper-ETL，以提高ETL过程的效率。Hyper-ETL允许集成XML文档文件和Oracle数据仓库，以减少执行时间，并消除现有ETL进程中元数据管理不善的问题。
京公网安备 11010802042870号
京ICP备2023020795号-1
分享
求助内容：
应助结果提醒方式：
扫码关注我们
