Abstract:
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.
Key words:
relational database,
metadata,
data integration,
dynamic query
摘要: 基于企业内多个分布异构关系数据库的集成需求,设计了一个向上支持集成访问界面,向下表述数据库网络位置、数据模式、数据内容的元数据字典模式。给出了面向集成环境和各异构数据库的通用查询请求表示。基于元数据字典,提出了一种因访问需求变化而引起相关数据库关系表动态变化的动态查询语句构造算法,并对算法进行了论证。
关键词:
关系数据库,
元数据,
数据集成,
动态查询
CLC Number:
LI Run-zhou; FANG Ming. Metadata and Dynamic Multi Tables Query Algorithm Based on Heterogeneous Integration[J]. Computer Engineering, 2007, 33(17): 111-113.
李润洲;方 明. 基于异构集成的元数据及其多表动态查询算法[J]. 计算机工程, 2007, 33(17): 111-113.