高速铣削异构数据库共享和透明访问技术研究  

High-speed Milling Heterogeneous Database Sharing and Transparent Access Technology

作　　者：陈龙[1] 郑敏利[1] 姜彬[1] 蒋玲[1] 

机构地区：[1]哈尔滨理工大学机械工业切屑控制及高效刀具技术重点实验室,哈尔滨150080

出　　处：《机械工程师》2009年第3期21-23,共3页Mechanical Engineer

基　　金：高等学校博士学科点专项科研基金项目(20070214004);哈尔滨市科技攻关项目(2006AA2CG025);黑龙江省杰出青年基金项目(JC200807)

摘　　要：针对目前高速铣削数据库种类繁多、结构各异、数据重复等问题,在典型高速铣削数据库结构和特点分析基础上,提出基于透明访问和数据转换的异构数据库共享策略。采用ADO访问不同数据源,并利用DTS技术完成异构数据库的数据转换,实现Visual FoxPro高速铣削数据库和SQL Server高速铣削数据库共享。结果表明,高速铣削异构数据库间数据转换准确、透明访问顺利;以已有数据库为基础,通过数据库透明访问和数据转换,实现异构数据共享,为高速铣削数据共享提供了切实可行的方案。In view of the current problems of high-speed milling database, such as a wide range of heterogeneous databases, the different structure, data duplication and so on, Heterogeneous database sharing strategy with the transparent access and the data conversion is proposed based on the analysis of a typical structure and characteristics of the high-speed milling database. By using ADO to access different database and using DTS technology for database conversion, data sharing of high-speed milling database between Visual FoxPro and SQL Server database is achieved. The results show that the data conversion is accurate, the transparent access is successful. Based on the old database data, by using transparent access and data conversion strategy to achieve data sharing, a practical and feasible solution for the shared high-speed milling heterogeneous database is provided.

关 键 词：高速铣削 异构数据库 数据共享 透明访问 

分 类 号：TG506.1[金属学及工艺—金属切削加工及机床]