A Heterogeneous Data Processing Technology Research Based On Interconnectivity Public Transportation One-card System Of Guangdong, Hong Kong And Macao

Urban public transportation IC card (hereinafter referred to as “transportation IC card” below)is developing rapidly in recent years in the field of public transport as a convenient paymenttool，it has been widely used and developed. Transportation IC card not only brings living ortravel convenience to the urban residents, but also break the isolation between administrativeregions.With the cross-border integration and connectivity of the transportation IC card market, itwould make the inter-city public transport to achieve integration, which greatly promote theexchanges of region’s economic and cultural, so as the development of the IC industry, andrealizes the big regional transportation integration.finally.In this paper, the goal is to study the key technology of heterogeneous data processing inpublic transport IC card connectivity platform for the requirements of future development ofintelligent transportation integration information system in Guangdong, HK and Macao. Themain content of the research is to process the data through cleaning, merger, standardizationand rationalization in data source from around the city and clearing system, and loaded intothe data warehouse to form a unified enterprise data integration platform. According to therequirements of the IC card operation and industrial development, the resources ofGuangdong,HK and Macao can be integrated effectively, which will attribute to the extensionof the transportation IC card industry chain and the sustainable and proactive development ofregional economic, and finally realizes the interconnectivity of public transportation inGuangdong, HK and Macao.