Abstract:
With the continuous development of the railway passenger ticketing and reservation system and the increasing business demand, the multi-source and heterogeneous characteristics of the massive passenger transport marketing data become more and more obvious, and the cross node and cross network segment data exchange becomes more and more frequent.Based on Kettle, an open-source ETL data analysis tool, this article constructed the ETL process model of marketing data, and designed the core modules of data exchange, which were with high configurable data model management, customized trigger rules, and independently running jobs according to the scheduling cycle. The article used the architecture system of interface service oriented, integrated the distributed technology, developed the passenger marketing data exchange platform, extracted, transformed and loaded the passenger marketing data, implemented the rapid integration and exchange of data.In addition, the article designed the functions of task configuration, node management and exception handling based on Web, and supported data exchange jobs and distributed deployment across nodes and network segments, could carry out abnormal operation warning and message push in time.The use of the marketing data exchange platform greatly meets the demand of the current railway passenger transport marketing data collection and exchange, and plays an important role in making full use of the existing data resources and reducing the workload of data maintenance.