基于互联网的全生命周期成本数据仓库的设计与实现

The Design and Application of Life Cycle Cost Data Warehouse Based on Web

以制造业中产品全生命周期成本数据的网络收集和基于业务的数据组织方法为研究对象,首先选择成本收集对象及影响成本的性能指标,然后以.NET作为软件开发平台,基于C#网络编程技术开发了从互联网可信站点搜索、采集成本数据的软件系统。再以成本收集对象的特性设计全生命周期成本数据仓库数据模型,以所获取的成本数据作为数据仓库的数据源,建立了数据仓库。为了保证数据质量,系统已建立初步的数据清理转换与数据源回溯验证功能,保证数据仓库数据的正确性、完整性和实效性。最后,本文以家用轿车为实例,建立了其全生命周期成本数据仓库,目前已积累近3500款车型30多个月以来30万条的产品信息及成本数据,验证了方法的可行性。

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 in 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 exemplar system of family cars was set up successfully which has accumulated 300 thousand plus records about 3500 car models in last 30 months.This proved the method was valid.