作者投稿和查稿 主编审稿 专家审稿 编委审稿 远程编辑

计算机工程 ›› 2007, Vol. 33 ›› Issue (17): 111-113. doi: 10.3969/j.issn.1000-3428.2007.17.038

• 软件技术与数据库 • 上一篇    下一篇

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

李润洲,方 明   

  1. (西安石油大学计算机学院,西安 710065)
  • 收稿日期:1900-01-01 修回日期:1900-01-01 出版日期:2007-09-05 发布日期:2007-09-05

Metadata and Dynamic Multi Tables Query Algorithm Based on Heterogeneous Integration

LI Run-zhou, FANG Ming   

  1. (School of Computer Science, Xi’an Shiyou University, Xi’an 710065)
  • Received:1900-01-01 Revised:1900-01-01 Online:2007-09-05 Published:2007-09-05

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

关键词: 关系数据库, 元数据, 数据集成, 动态查询

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

中图分类号: