汽车维修行业管理数据仓库的建立

作者：张昕1，杨志军2 日期：2008-12-26/span> 浏览：3169 查看PDF文档

汽车维修行业管理数据仓库的建立

张昕1，杨志军2
(1.浙江万里学院 智能控制研究所，浙江 宁波 305010；2.宁波市生产力促进中心，浙江 宁波 305010)

摘要：为满足汽车维修行业管理部门对大量关于维修运行及汽车工业发展的历史数据的需求，通过汽车维修行业管理数据仓库的研究和建立，将数据仓库应用于汽车维修行业管理。在了解汽车维修行业管理现状的基础上，采集了大量汽车维修行业管理的实践数据，利用SQL Sever 2005完成了汽车维修行业管理数据仓库的设计，为汽车维修行业管理者的决策提供了数据依据，提高了汽车维修行业的管理水平，为改善目前我国汽车维修行业管理的落后现状做出有益的探索。
关键词：汽车维修行业；管理；数据仓库；联机分析处理
中图分类号：TH17文献标识码：B文章编号：1001-4551(2008)11-0031-04

Establishment of data warehouse for the management of automobile service industry
ZHANG Xin1, YANG Zhijun2
(1.Institute of Intelligent Control, Zhejiang Wanli University, Ningbo 305010, China;
2.Niugbo Productivity Promotion Center, Ningbo 305010, China)
Abstract: To meet the automobile service industry management departments demand of mass historical data about service enterprise and automation industry, with the study and establishment of data warehouse for the management of automobile service industry, the data warehouse technology was applied in the management of automobile service industry. On the bases of collecting the management data of automobile service industry, the implementation of the online analytical processing（OLAP）were introduced as well as the data warehouse for the management of automobile service industry was designed. These works will provide the support for decisionmaking, and it is helpful experience to apply the data warehouse to the management of automobile service industry. The application of the study will improve the recent status quo of the management of automobile service industry in China.
Key words: automobile service industry; management; data warehouse; online analytical processing(OLAP)
参考文献(References):
［1］李琪,白英彩.数据仓库中维度建模和查询［J］. 计算机发展与研究， 2002,39(5)：612-618.
［2］姜澄，吴光宇.基于数据仓库的设备维修管理系统及关键技术研究［J］. 机械设计与制造，2003（1）：54－56.
［3］蔡艳宁，叶雪梅，汪洪桥，等.军事训练考核数据仓库模型设计与实现［J］. 计算机工程，2006,32(1)：276－278.
［4］孙泳，刘少辉，史忠植. 数据仓库中多维分析的数据展现［J］.计算机工程与应用，2004（4）：201－202.
［5］SHAH B, RAMACHANDRAN K, RAGHAVAM V. A hybrid approach for data warehouse view selection［J］. International Journal of Data Warehousing and Mining,2006,2(2):1-37.
［6］GUPTA H, MUMICK I S. Selection of views to materialize in a data warehouse［J］. IEEE Transactions on Knowledge and Data Engineering,2005,17(1):24-43
［7］SHUKLA A, DESHPANDE P M, NAUGHTON J F. Materialized view selection for multicube data models［C］∥7th International Conference on Extending Database Technology(EDBT2000).Konstanz,Germany:［s.n］,2000:269-284.