有色金属行业采购系统分布式数据库设计  

Design of Distributed Database Solution for Nonferrous Metals Enterprise Procurement System

作　　者：黎辛晓[1] LI Xin-xiao （Guilin University of Technology, Department of Electronics and Computer Science, Guilin 541004,China）

机构地区：[1]桂林工学院电子与计算机系,广西桂林541004

出　　处：《电脑知识与技术》2007年第6期1191-1192,1194,共3页Computer Knowledge and Technology

摘　　要：通过对某大型有色金属企业的组织机构地域分布特点、采购作业流程和采购系统数据特征的分析，利用Oracle对分布式数据库的良好支持．结合各种采购数据的分布特征及各部门的数据访问需求，设计了该行业采购系统的分布式数据库方案，以提高数据访问效率。基于该方案所实现的采购系统较好的解决了大量数据传输效率问题，避免集中式数据库的通信瓶颈，实现了数据处理负载均衡，同时满足了数据共享需求。Based on the analysis of a super nonferrous metals enterprise＇ s distribution of branches, procurement processing flOWS and procurement datum characteristic, making use of the good support by Oracle and considering the different data accessing requirement by the different departments, this paper presents a distributed database solution for nonferrous metals enterprise procurement system using Oracle. This solution enhances the efficiency of data access. The application base on this solution solves the problem on processing and sharing of great deal of datum in this kind of enterprise procurement system by making datum processing balance.

关 键 词：采购系统 分布式数据库 ORACLE 快照 视图 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论;自动化与计算机技术—计算机科学与技术]