当前位置: 首页 > 文章 > ETL转换功能的设计与实现 河北农业大学学报 2010,33 (3) 132-135
Position: Home > Articles > Design and Realization of Transformation function in ETL Journal of Agricultural University of Hebei 2010,33 (3) 132-135

ETL转换功能的设计与实现

作  者:
车燕京;张月清;韩宪忠
单  位:
河北农业大学
关键词:
ETL;转换功能;临时数据库;脚本解析
摘  要:
通过对现有ETL(Extract Transformation Loading)工具的分析与研究,本研究提出了一种基于临时数据库和脚本解析方式实现ETL转换功能的解决方案,并用求学生平均成绩和教职工工资总和对该解决方案进行测试,正确率达100%,证明了该方案的可行性。
译  名:
Design and Realization of Transformation function in ETL
作  者:
CHE Yan-jing1,ZHANG Yue-qing2,HAN Xian-zhong1 (1.College of Information Science and Technology,Agricultural University of Hebei,Baoding 071001,China;2.Journal Publishing Department,Agricultural University of Hebei,Baoding 071001,China)
关键词:
ETL;function of transformation;temp db;script analysis
摘  要:
In light of the analysis and study of the existing ETL(Extract Transformation Loading) software,this paper introduces a solution based on the tempdb and script analysis technology to archive the function of transformation in ETL process,and aims to identify the average grades of the students in a school and the total wages of the teachers in the same school by such solution.The results show that the accuracy rate is 100%,and thereby prove this solution's validity.

相似文章

计量
文章访问数: 11
HTML全文浏览量: 0
PDF下载量: 0

所属期刊

推荐期刊