Metadata and Dynamic Multi Tables Query Algorithm Based on Heterogeneous Integration
Ming Fang · Jisuanji gongcheng · 2007
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.