计算机工程 ›› 2007, Vol. 33 ›› Issue (19): 283-封3.doi: 10.3969/j.issn.1000-3428.2007.19.100

• 开发研究与设计技术 • 上一篇    

ETL在水路客运行业项目中的应用

刘娜嘉1,朱 力2   

  1. (1. 华东计算技术研究所,上海 200233;2. 上海华宇电子工程有限公司,上海 200003)
  • 收稿日期:1900-01-01 修回日期:1900-01-01 出版日期:2007-10-05 发布日期:2007-10-05

Application on ETL of Waterage Passenger Transportation Industry in BI Project

LIU Na-jia1, ZHU Li2   

  1. (1. East China Institute of Computer Technology, Shanghai 200233; 2. Shanghai Huayu Electronic Engineering Co., Shanghai 200003)
  • Received:1900-01-01 Revised:1900-01-01 Online:2007-10-05 Published:2007-10-05

摘要: 通过讨论数据提取、转换、加载(ETL)技术在上海水路客运票务系统项目中的实践应用,说明了ETL技术的特点、本质及其重要性。其中,ETL的具体应用包括数据查找、变更以及维护。采用ETL技术可以使数据库系统完全分离,大大减轻了数据汇总查询对实时票务系统的负荷,提高了查询分析速度。

关键词: 数据提取、转换、加载, 水路客运, 数据转换

Abstract: This paper describes the attributes, essence and importance of extraction transformation loading(ETL) technology by discussing the application in the business information system in waterage passenger transportation industry. It studies how ETL technology is used to solve the problems in data search, modification and maintenance. The use of ETL can separate the database system completely, and decrease the load of data search, increasing the speed of search and analysis.

Key words: extraction transformation loading(ETL), waterage passenger transportation, data transformation

中图分类号: