The Design of Family Cars’ Life Cycle Cost Data Warehouse Based on Web

Abstract

This paper mainly focused on the life cycle cost collection of manufacturing product based on web and data organization methodology according to business requirements. The general features of manufacturing product life cycle cost were analyzed at first while cost collection objects and cost-related product features were chosen. After that, the software system was developed using .NET and C# web programming technique picking up cost data from credible websites on Internet. Then, life cycle cost data warehouse model was designed via features of cost collection object ending up with the establishment of data warehouse system acquiring cost data as data source. Basic data cleaning and data validation function was developed to meet data quality demand referring to data integrality, data authenticity and data time effectiveness. Finally, an exemplification system of family cars was set up successfully assembling 300 thousand plus records about 3500 car models in last 26 months. This system was proved to work without human manipulation over hours visiting 10 thousand web pages and collecting cost data. This proved the software was valid.