Road Freight Transportation Industry Economic Activity Analysis Based On Data Warehouse

Road transport as an important part of the transport sector, in the transport ofgoods is playing an increasingly important role. Based on the mass production of roadfreight transport vehicles, cargo companies, case management information, acomprehensive understanding of the production, road freight transport operations,accurate control of the position and role of an integrated transport system in the roadtransport of goods for the road freight transport industry Providing all aspects ofplanning, construction, management, and operation and effective decision making,become a very critical issue.In the road freight transport system, every aspect of information flow are veryhuge, road freight transport statistics record the changes in the development of roadtransport industry, through the analysis of statistical data for managementdecision-making at all levels and operators a large number of decision-making basis,and achieved obvious results. But the current statistical analysis of the data is reflectedin the road freight transport surface results obtained can not explore in depth the causesof problems, there are some flaws in economic activity analysis systems.Based on the understanding of the economic activity analysis and data warehousetheory, combined with the demand for road freight transport statistics analysis, designof data warehouse technology-based, on-line analysis and data mining technology as ameans of road transport of goods analysis of economic activity program. Analysis ofdifferent themes designed and data star schema and snowflake modelsmultidimensional model of mining design, combined with Jilin Road Freight TransportStatistics application SQL Server2012database platform complete data warehousesolutions, ETL programs and data mining program implementation, use of OLAPanalysis tool for multi-dimensional model created by multi-angle, multi-level analysis,using data mining techniques to identify the laws of Jilin road freight transport data.Using data warehouse technology to economic activities road freight transportwere analyzed to gain insight into historical data, obtain information quickly reflectroad freight transport in the production of vehicles and related operational status of thevarious indicators of economic activity, production and possession of inside industrymanagement information, provide data support for decision-makers, will help improve the industry, to promote the development of transportation and production, increaseeconomic efficiency.