摘要： 通过讨论数据提取、转换、加载(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
中图分类号:
刘娜嘉;朱 力. ETL在水路客运行业项目中的应用[J]. 计算机工程, 2007, 33(19): 283-封3.
LIU Na-jia; ZHU Li. Application on ETL of Waterage Passenger Transportation Industry in BI Project[J]. Computer Engineering, 2007, 33(19): 283-封3.