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

High-speed Milling Heterogeneous Database Sharing and Transparent Access Technology

针对目前高速铣削数据库种类繁多、结构各异、数据重复等问题,在典型高速铣削数据库结构和特点分析基础上,提出基于透明访问和数据转换的异构数据库共享策略。采用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.