基于多数据源的遗留系统数据共享交换研究与设计  

Research and design of legacy system data exchange based on multiple data sources

作　　者：杨俊钦 林平荣 施晓权 周谚辩 Yang Junqin;Lin Pingrong;Shi Xiaoquan;Zhou Yanbian(Information Technology Education Center,Software Engineering Institute of Guangzhou,Guangzhou 510990,China)

机构地区：[1]广州软件学院信息与教育技术中心,广州510990

出　　处：《现代计算机》2024年第18期49-53,共5页Modern Computer

基　　金：广州市哲学社会科学发展“十四五”规划2021年度共建课题(2021GZGJ179)。

摘　　要：在智慧校园建设的浪潮中,遗留系统与异构数据源的整合问题日益凸显。这些系统往往由不同的供应商开发,采用多样化的数据格式和通信协议,给数据的交换和整合带来了显著挑战。为了解决此问题,提出了一种基于多数据源的遗留系统数据交换方案,通过构建多源异构数据交换的活接口,实现两处数据库的连接,选择适配的驱动对接数据源,将异构数据源的数据结构转换为定制化的目标表结构,并执行同步策略,确保数据在异构数据源间准确无误地传输。通过实验验证,该方案不仅具备高度的可行性和可拓展性,而且能够以较小的侵入方式实现异构数据源的数据交换,为智慧校园建设的深入发展提供了有力的技术支撑和实践参考。With the wave of smart campus construction,the integration of legacy systems with heterogeneous data sources has become increasingly prominent.These systems are often developed by different vendors and use diverse data formats and communication protocols,which bring significant challenges to data exchange and integration.In order to solve this problem,a data exchange scheme for legacy systems based on multiple data sources is proposed,which implements the connection of two databases by constructing a live interface for heterogeneous data exchange from multiple sources,selecting an adapted driver to interface with the data sources,converting the data structure of heterogeneous data sources into a customized target table structure,and enforcing synchronization policies to ensure the data is transferred accurately and without errors among heterogeneous data sources.Through experimental verification,the scheme is not only highly feasible and expandable,but also can realize data exchange of heterogeneous data sources in a less intrusive way,which provides a strong technical support and practical reference for the in‑depth development of the smart campus construction.

关 键 词：遗留系统 多数据源 数据共享交换 较小侵入 

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