Network Structure Of Multi-Cities And Multi-Platforms For Transportation Planning

At present, the urban traffic information network system of each subsystem is a single urban transport system in the local, small-scale, relatively simple, relatively more independent of the operation. Different traffic management, planning departments in the development of transportation network information system commissioned by different developers or companies set up their traffic information subsystem of various forms of information are also different; different times and different stages of the development of traffic information system not the same demand, leading to the information subsystem in data storage format can not reach consensus; traffic information subsystem, including computers, communications and many other fields, resulting in a variety of standardized data between the inconsistent rules, and so on. This will inevitably lead to various information subsystems of the connection can not achieve effective, comprehensive traffic information system can not achieve all the information the effective integration of information between subsystems.Multi-city, multi-platform traffic study information network platform used to implement various information subsystems effective connection and on the basis of the existing subsystems relatively well established multi-city, multi-platform traffic information sharing platform that allows the information subsystem to achieve resource sharing, information sharing, mutual coordination, comprehensive, accurate and efficient integrated management of traffic information and control. Thereby reducing traffic congestion and reduce the waste of resources, increase economic efficiency, promote social development and urban transport planning integrated, comprehensive management, treating the symptoms play a positive role in pushing forward multi-city, multi-platform traffic information platform for the establishment and improvement will also in the realization of efficient, convenient, comfortable transport play an important role in society.This article is based on the overall structure of the multi-city, multi-platform network transport technology as the basis for critical discourse, the first comparison of various key technologies, make the method suitable for the platform, then combined with the project to achieve the key technology needs, In the final Integration of various technologies to build multi-city, multi-platform traffic information network platform.Firstly, a brief introduction to domestic and foreign urban traffic information system development status, based on the number of cities by comparing data traffic information platform construction situation, proposed for multi-city, multi-platform network of transportation information platform needs to build a data Sharing, information extraction, analysis and decision support services, information network platform as the main framework and suitable for general multi-city, multi-platform application traffic information network to provide key technology and multi-city, multi-platform network traffic information to build the necessary technical Means.The second part focuses on the database access interface technologies are studied, through the ODBC and JDBC data interface brief manner and on the basis of comparative analysis, focusing on the multi-city database data extraction, transformation, cleaning, loading the Transact-SQL, BCP command line tool called Data Transformation Services DTS and the use of the data processing of the three methods are discussed and analyzed. Through Access, Oracle, txt and SQL Server data migration between the three specific examples described conversion is proposed for this method of data transformation platform.The third part in the realization of data conversion on the basis of migration, mainly on the integration of data analysis and the formation of multi-dimensional OLAP analysis of the financial statements of the basic operations, storage and logic modeling for the specific study and discussion. Through multi-dimensional OLAP reporting tools:an open source project Mondrian OLAP engine, the specific method was proposed for the project's multi-dimensional analysis techniques, and on this basis, Mondrian's API, schema and MDX language further discussed and studied.Complete the multi-city, multi-platform traffic information network platform data extraction, transformation, cleaning, loading process and technology-based OLAP multidimensional data analysis, the paper analyzes the relationship of data, prediction data mining techniques are brief introduction, and mining features a brief introduction and implementation.Finally, the paper integrates the key technologies, to build a multi-city, multi-platform traffic information network platform. Focus on multi-city, multi-platform information traffic information network platform publishing, information retrieval, information analysis, data mining functions of each module are introduced. Finally, a use case diagram with system platform, the system visually show the concrete realization of the platform. Structures through the platform and key technology, the basic realization of the multi-city, multi-platform traffic through the information network platform for development purposes.