Research On Passenger Flow Analysis Of High Speed Railway Based On Big-data

Recently,with the characteristics of fast,punctuality,safety and environmental protection,high-speed railway is developing rapidly in our country and the whole world.With the increase of network scale and operating mileage of China's high-speed railway,the capacity of railway passenger transport has been gradually released,and the situation that the railway passenger transportation is in short supply situation has been eased,and railway transportation is gradually transformed from extensive to intensive.As the basis and key factor of railway transport organization,The passenger flow's analysis work is a complex process,how to systematically analyze its distribution characteristics and change rule,and grasp its status and trend,is of great significance to the railway operation scheme,ticket sales and marketing strategy,etc..With the deepening development and construction of informatization,a large number of complete and consistent historical data have been accumulated in China's railway ticketing and reservation system,which can provide the data base for the reasonable and scientific analysis of the passenger flow of high-speed railway,and the acquisition of the high quality of the assistant decision-making information.Following the networking technologies and cloud computing,big data analysis technology has become the core technology needed to collect,store,retain,manage,analyze and share massive data.This paper plans to use Microsoft SQL Server 2012 as a data analysis tool to construct a star scheme of railway ticket data bank and multidimensional dataset and aim at OLAP analysis and data mining of railway ticket,so that it can extract useful information that will be displayed to the user with a standard and clear report forms from vast amounts of ticket data,which better guides the railway transportation allocation and provides support for the leadership's decision-making..This paper firstly summarizes the research achievements of the application of big data technology and the analysis of railway passenger flow at home and abroad,and the most mature development of the big data analysis technology,namely data warehouse and data mining technology,and the main research contents of the railway passenger flow,including passenger travel behavior,the characteristics of spatial temporal and spatial distribution,and the relationship between the ticket revenue and transport capacity,and the forecast passenger flow according to the actual characteristics of the high-speed railway ticket.Then it seeks to find a way how to combing the data warehouse and data mining technology and railway passenger flow research based on business intelligence tools of Microsoft SQL Server 2012.Finally it introduces the development tools and specific functional modules of the statistical and decision-making analysis system of the high-speed railway passenger ticket,and uses the ticket data between 2016.11.21 and 2016.11.27 of GuiGuang high-speed railway to test the system.