面向多源异构数据库的SQL解析与转换方法研究  

Research on SQL Parsing and Transformation Method for Multi-Source Heterogeneous Database

作　　者：练金栋 陈志 岳文静[2] 赵培 吕伟初 LIAN Jindong;CHEN Zhi;YUE Wenjing;ZHAO Pei;LYU Weichu(School of Computer Science,Nanjing University of Posts and Telecommunications;School of Communications and Information Engineering,Nanjing University of Posts and Telecommunications,Nanjing 210003,China;JINZHUAN Information Technology Co.,Ltd.,Nanjing 210012,China)

机构地区：[1]南京邮电大学计算机学院 [2]南京邮电大学通信与信息工程学院,江苏南京210003 [3]金篆信科有限责任公司,江苏南京210012

出　　处：《软件导刊》2023年第12期124-131,共8页Software Guide

基　　金：江苏省重点研发计划(社会发展)项目(BE2019739);中兴通讯产学研合作基金项目(2021H2ZTE05-01)。

摘　　要：传统的单一数据库模式难以适应如今多样化的数据管理需求。如何将多个异构独立的数据库进行集成,对数据库系统进行整体控制和协同操作成为研究热点。针对此问题进行面向多源异构数据库的SQL解析与转换方法研究,通过建立通用的中间表示模型,对异构数据库请求进行语法树解析、语义分析与模型转换,实现了不同数据库之间的互操作。在基于TPC-H基准测试数据集的功能测试中,测试系统对数据类型和语法操作的支持度达到100%。在性能测试中,测试系统在跨平台的增删改查操作时间上,较官方工具分别快了13.1 ms、8.8 ms、22.5 ms与2.3ms。实验验证了该方法的正确性与可行性。Nowadays,the traditional mode with single database has difficulty meeting with the demand of in diversified data management.The integration of multi-mode heterogeneous databases has become a research hotspot for overall control and collaborative operation of the global database system.Aiming at this problem,this paper studies the SQL parsing and transformation methods for heterogeneous databases.And in⁃teroperability between different database has been achieved through universal intermediate-representation-model establishing,syntax tree parsing,semantic analysis and model transformation.In the functional test based on the TPC-H benchmark dataset,the frame-based test sys⁃tem has 100%support for data types and syntax operations,while the framework has advantages over official tools in terms of operation speed for cross platform addition,deletion,modification,and query,with 13.1 ms,8.8 ms,22.5 ms,and 2.3 ms,respectively.The experiment ver⁃ifies the correctness and feasibility of the proposed method.

关 键 词：异构数据库 中间表示 语法解析 语法转换 

分 类 号：TP391[自动化与计算机技术—计算机应用技术]