一种基于元数据静动态数据联合查询方法的研究与实现

STUDY AND REALISATION OF A METADATA-BASED FEDERATED QUERY METHOD USING STATIC AND DYNAMIC DATA

研究和实现一种结合股票静、动态数据进行实时行情信息联合查询的方法。描述运用元数据定义和管理各数据源关键信息的虚拟表,通过复制、移动和分割虚拟SQL查询语法树分支,实现对数据表的查询分割和根据查询返回合成查询结果集的技术思路与做法。研究的方法屏蔽了异构数据源查询的复杂细节,能够为用户提供一个统一、简便的SQL查询接口,使静、动态数据之间的联合查询更加便捷,有效地提高了联合查询的执行效率。

In the paper we study and implement an approach for federated query on real-time stock quotes by fusing the static and dynamic data. The paper describes the technical ideas and practices of the implementation of querying and segmenting datasheet and returning the synthetic query result set according to the query by using metadata to define and manage virtual table containing critical pieces of information about each data source and by copying, moving and segmenting the branches of virtual SQL query syntax tree. The method involved in this paper keeps the complex details of the queries across the heterogeneous data sources from users, and is able to provide a uniform and simple SQL query interface, makes the federated query of static and dynamic data more convenient, thus effectively improves the execution efficiency of federated query.