Design And Implementation Of The Sunway Equipment Inventory Management System

Metro serves the people. Although there is no intense market competition, it reflects the image of a country, an industry. Therefore, metro company still needs to continue to improve the management of its own problems. Equipment management is a very important part among all kinds of management problems faced by the metro company. Metro vehicles and their accessories are large, and the maintenance and repair cost great manpower, material resources and financial resources. Management by experience is not objective and scientific, and transactional inventory management is needed, but it can not achieve the purpose of decision support. In this paper, we expect to develop a management system of metro vehicle equipment based on data warehouse with multidimensional analysis capability. It is expected to help metro company reduce equipment consumption, save costs, make the limited resources to maximize the use, and can also make people benefit from it.This paper mainly includes the following research contents: construction of the basic inventory management system of metro vehicle equipment, realization of real-time tracking of storage vehicle equipment, storage of mass transactional data of equipments’ inbound and outbound; construction of metro vehicle equipment management data warehouse prepares for multidimensional analysis of metro vehicle equipment. In this process, it is important to determine the subject domain of data warehouse and the ETL process of building data warehouse; Construction of multidimensional analysis system for metro vehicle equipment management data warehouse. On the one hand, the multidimensional analysis model is constructed, on the other hand, multidimensional analysis method is analyzed and visually displayed.This paper first reviews the relevant fields of domestic and international research status and related key technologies, including the.NET platform which constructed this system and data warehouse related theory, and then carries on the system demands investigation and study. On the basis of the system demands, the functional requirements analysis and performance analysis are carried out, and the boundary of the system is defined. Then, the overall design of the system, detailed function module database design and data warehouse design are carried out. Finally, the system is implemented and tested. The system is developed under the.NET platform, and completes transaction management and data warehouse of metro vehicle equipment management system through the Server SQL Server database. The research in this paper is expected to help metro company improve its management capacity, and make the metro transportation service satisfy the people, as well as saving national related expenditure.