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.

• Periodical: Advanced Materials Research (Volumes 433-440)
• Pages: 3425-3432
• DOI: https://doi.org/10.4028/www.scientific.net/AMR.433-440.3425
• Online since: January 2012
• Authors: Xiao Chuan Chen, Jin Fang Liu, Qing Li
• Keywords: Data Collection, Data Warehouse, Family Car, Life Cycle Cost (LCC)

References

[1] Benjamin S. Blanchard. Life cycle costing-A review, Terotechnica, 1, pp.9-15, (1979).

[2] Xiaochuan Chen, Chenxi Qiu, Jie Yuan, Zhongxu Tian. Family Cars' Life Cycle Cost Estimation Method Based-on CBR and Data Warehouse, 2010 3rd International Conference on Advanced Computer Theory and Engineering(ICACTE 2010), Chengdu, China. August 20-22, pp v1-212-216, (2010).

DOI: 10.1109/icacte.2010.5579032

[3] Francois Liger, Craig McQueen, Paul Wilton. C# Text Manipulation Handbook, Beijing: Tsinghua Press, (2003).

[4] Zhihui Li, Research on Problem of Data Quality During the Course of ETL Implement, Computer Knowledge and Technology, 2, pp.25-121, 2006. ( in Chinese).

[5] Jun Shao, Design and Application of Life Cycle Cost Data Warehouse" , Master, s thesis, Donghua University, 2008. ( in Chinese).

[6] Jie Yuan, Improvement and Application of Life Cycle Cost Data Warehouse Based on Web" , Master, s thesis, Donghua University, 2009. ( in Chinese).