基于数据仓库的船厂物资采购决策支持系统研究计算机技术专业论文.docxVIP

mining techniques, found the data potential models in the data warehouse, and make predictions automatically based on these patterns. In the process of building the system, based on the data warehouse modeling, carding, improved business process, established a full range of data perspective， eliminate information isolated island and data difference; based on O LAP multidimensional analysis，realized the material procurement information multi-angle, multi-dimensional statistical analysis；based on execute data mining on the data warehouse, gained a lot of valuable information about material management decision, it has satisfied the demand of materials management decision support. The system gives full play to the data warehouse, online analytical processing, data mining. Through this system, a large number of historical data and heterogeneous data has been fully utilized, purchaser that not only to understand the material needs of the various departments of the shipyard, but also to grasp the market trend; thereby lowering the cost of procurement, improving service quality on the maximum extent, reducing the risk of material procurement decision- making, to create maximum economic benefit for the shipyard. Key Words: Data Warehouse (DW), Data Mining (DM), on Line Analytical Processing (OLAP), Decision Support System (DSS), multi-dimensional analysis, Shipbuilding Material Management 目录 第一章 前言 1 1.1 课题研究背景及意义1 1.2 国内外研究现状2 1.2.1 决策支持系统发展现状 2 1.2.2 物资管理系统发展现状 4 1.3 本文主要研究内容4 1.4 论文架构 5 第二章 关键技术综述 6 2.1 船厂物资采购决策支持系统方案设计6 2.2 船厂物资采购数据建模关键技术8 2.2.1 数据仓库建模过程 8 2.2.2 数据仓库建模方法 9 2.2.3 数据建模的意义 12 2.3 船厂物资采购数据分析关键技术13 2.3.1 联机分析处理 13 2.3.2 数据挖掘 15 2.3.3 数据仓库与数据挖掘的联系 19 第三章 物资采购决策支持系统的总体设计 20 3.1 系统需求分析20 3.2 系统体系结构20 3.3 系统主要功能模块设计 21 3.3.1 供应商分析子系统 25 3.3.2 采购计划分析子系统 25 3.3.3 物资入库分析子系统 25 3.3.4 物资出库分析子系统 25 3.3.5 物资库存分析子系统 26 第四章 物资采购数据仓库的设计与实现 27 4.1 物资采购数据仓库模型设计 27 4.1.1 概念模型设计 27 4.1.2 逻辑模型设计 30 4.1.3 数据接口 32 4.1.4 数据抽取、转换和装载过程 32 4.1.5 物理结构设计 33 4.2 物资采购数