软件导刊2023，Vol.22Issue(12)：124-131,8.DOI:10.11907/rjdk.232028
面向多源异构数据库的SQL解析与转换方法研究
Research on SQL Parsing and Transformation Method for Multi-Source Heterogeneous Database
摘要
Abstract
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.关键词
异构数据库/中间表示/语法解析/语法转换Key words
heterogeneous database/intermediate representation/syntax parsing/grammar transformation分类
信息技术与安全科学引用本文复制引用
练金栋,陈志,岳文静,赵培,吕伟初..面向多源异构数据库的SQL解析与转换方法研究[J].软件导刊,2023,22(12):124-131,8.基金项目
江苏省重点研发计划(社会发展)项目(BE2019739) （社会发展）
中兴通讯产学研合作基金项目(2021H2ZTE05-01) （2021H2ZTE05-01）
