摘要
ETL系统是构建数据仓库过程中极其重要的部分。以ETL基本原理和标准出发,从实践角度设计ETL系统的模型框架,包括调度和抽取模型,其中抽取模型是采用抽取-传输-缓冲-合并的方法,有效地解决了异构数据源抽取问题。在以保险行业为背景的项目中进行了应用,并取得较好的效果。
ETL system plays an important role in building data warehouse. On the basis of ETL rationale and standards, in the paper it designed model architecture of ETL system,including scheduling and extraction models in terms of practice. In the extraction model,the problem of taking data from disparate data source is solved effectively by using the extract-transform-buffering-combine technique. The above research has been applied to a project with insurance background, and achieved good results.
出处
《计算机应用与软件》
CSCD
2009年第4期198-201,共4页
Computer Applications and Software
