Design And Implementation Of Intelligent Data System For Bus Enterprises

China's intelligent transportation industry started from the 90 s of last century,and after the establishment of the intelligent transportation system framework in 2005,the overall industry has developed rapidly.With more and more data information accumulated in domestic bus enterprises,the development of data warehouse system has not yet reached a certain scale.The intelligent public transport system is mainly focused on the realization of intelligent scheduling,for the data centralized,unified and lack of analysis.For bus companies,there is a need to have an intelligent data system that can directly reflect the operational situation and potential problems.Taking a bus company in Guangzhou city as an example,the current situation of intelligent data management detailed description of public transport enterprises,indepth analysis of the public transportation enterprise for many of its existing business system data integration needs,according to user needs for data analysis,design three functional modules operation scheduling,logistics technology and comprehensive analysis.According to the characteristics of the existing data,this paper describes the design of the data warehouse in detail,including the dimension table and the design of ETL.The dimension table takes the date dimension as an example,describes the detailed design process,lists the dimension table which is mainly used in the data warehouse of the system,and introduces the main keys in the table.In addition to detailed data collection,scheduling,fuel data extraction,data cleaning,conversion and data loading,the ETL design is described in detail with examples of the ETL process of daily revenue data.The system uses B/S operation mode,JavaEE as the technical framework,Java as programming language,SQL Server2008 as the background database,data visualization chart using Echart3.The fifth chapter describes the user login and access control,as well as the realization of the main module functions.The one or two main functions of the three modules of operation scheduling,technical logistics and comprehensive analysis are extracted,and the main ways and means of implementation are described.After the implementation of the whole system,the functional and nonfunctional simulation tests are carried out.Functional testing includes user login and several major functions mentioned in the fifth chapter,and non-functional tests are mainly compatibility testing,stress testing and security testing.This system realizes the integration of data bus enterprise business database,greatly reduce the workload of manual data processing,data processing and analysis for the daily routine,required 30% less time than in the past,greatly improve work efficiency.It uses histogram,line chart,pie chart and other intuitive visualization methods to display data,and provides more sufficient data support for the decision making of the bus enterprise management.