基于异构集成的元数据及其多表动态查询算法

基于企业内多个分布异构关系数据库的集成需求，设计了一个向上支持集成访问界面，向下表述数据库网络位置、数据模式、数据内容的元数据字典模式。给出了面向集成环境和各异构数据库的通用查询请求表示。基于元数据字典，提出了一种因访问需求变化而引起相关数据库关系表动态变化的动态查询语句构造算法，并对算法进行了论证。

Metadata and Dynamic Multi Tables Query Algorithm Based on Heterogeneous Integration

Based on the integration demand of multi distributed and heterogeneous relational databases within an enterprise,a metadata dictionary pattern is designed to sustain upper integration access interface and to depict the lower databases'network location,data schema and data content.A denotation of universal query request orienting integration environment and heterogeneous database is given.Based on the metadata dictionary,a dynamic query algorithm to join relevant database's multi tables changing with the change of access need involved in a query is put forward,and the algorithm is demonstrated.