摘要
随着网络中数据库应用的发展,使得分布式数据库的应用领域得到快速的扩展。针对商业流通企业大规模、分散式经营以及集团化管理的模式,提出了在商业供应链系统中采用分布式数据库的结构设计方案,对供应链系统的数据库体系进行了分析,对在数据库设计过程中的一些关键问题进行探讨并给出了解决方法。以Oracle9i数据库系统为例,介绍了采用增量复制、分组、半连接技术,进行数据复制、解决数据冲突以及进行查询优化的实现方法。
With the development of database application on network, the field of distributed database application is expanding rapidly In allusion to the distributed, large scale corporation mode of business, a structure design scheme about distributed database of supply chain management system is presented and the system of SCM is analyzed, some key problems in database design is discussed and corresponding resolutions is presented, Based on oracle 9i database, some techniques such as fast refresh, grouping and half joint are proposed, which are contributed to the realization methods of data duplications, data conflicts and query optimization.
出处
《计算机工程与设计》
CSCD
北大核心
2006年第17期3299-3301,共3页
Computer Engineering and Design
关键词
分布式数据库
供应链管理系统
数据库复制
数据冲突
查询优化
distributed database
supply chain management system
data duplication
data conflict
query optimization