Research In Locomotive Four Analysis System Based On Data Warehouse

Along with the rise of big data era, China’s railway transportation system has also ushered in the overall popularity of railway information. Railway bureaus across the country have set up their own data corresponding information systems, Railway Bureau and other departments are also subordinate to build their own security costs corresponding production scheduling information platform, with the railway bureau constitute a complete information center production operations command information system, the locomotive daily transportation, production operations generated a tremendous positive effect, greatly promoted the railway information process.Decision support system for enterprise information technology is an important part of corporate executives to make decisions quickly and accurately plays a key role. As railways information technology pilot unit, a decision support system for locomotive depot is still quite scarce in decision analysis within the department, and even still in the multi-point, multi-mode information-gathering stage, unable to meet senior managers depot decision-making needs. Therefore, in this study, background, based on data warehouse technology to build a depot enterprise data warehouse enabling information decision support systems, auxiliary high-level decision-making needs. Content of this study and research results are as follows.(1) Through detailed field research to study the locomotive depot current development of decision support systems, combined with data warehouse technology proposed system needs analysis, the completion of the overall system demand reports.(2) According to the data warehouse’s basic theory and basic methods of data warehouse-depth discussion, build an overall implementation plan. Conduct on which the technical problems to overcome, such as the overall system architecture and data structures from multiple data sources of data extraction, transformation, and loading and other problems. Combined depot status of decision support systems and data warehouse technology to analyze the locomotive depot decision support system needs and the future needs of a prediction.(3) We have analyzed the decision analysis process of locomotive running preparation data based on locomotive four analysis system.Including the establishment of a data warehouse, data loading and the using of data. Based on data warehouse technology to complete the locomotive four analysis system, and applied in the relevant units with a good effect.