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

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

传统的单一数据库模式难以适应如今多样化的数据管理需求。如何将多个异构独立的数据库进行集成,对数据库系统进行整体控制和协同操作成为研究热点。针对此问题进行面向多源异构数据库的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.