US 2006/0136452 A1 · Method of generating database schema to provide integrated view of dispersed data and data integrating system

Abstract

A method for generating a database schema in order to generate an integrated view capable of obtaining desired data from data resources dispersed and stored in different formats in different locations, and an data integrating system are provided. The method includes rules for parsing the structure and contents of an database described in a specification language, generating a schema semantically corresponding to the database, and defining data items required for generating an integrated view. Also, in order to generate a global schema expressing an integrated view, part of XQuery grammar is introduced for local schemas expressing a single database, and a definition of standard expression for expressing a data view is included. Accordingly, an data integrating system can generate an integrated view for a variety of heterogeneous databases dispersed on a network by using a specification language, and post a query in real time.

Claims10

Dependent claims

A schema generation method for a dispersed database, comprising:

parsing a specification language document for the database and generating meta-data;
if the database is a local database, generating a local schema for each item of the parsed specification language document;
and
if the database is not a local database, parsing an input query and generating a global schema for each item of a return clause included in the parsed query.

1 more element

An data integrating system using dispersed databases, comprising:

a query processing unit which receives a query on desired data from a user and divides the query into local queries for each of the dispersed databases;
a wrapper management unit which manages at least one wrapper which performs the divided local query and transfers the result of the query to the query processing unit;
and
a schema management unit which parses a specification language document on the database and generates meta data, and if the database is a local database, generates a local schema for each item of the parsed specification language document, and if the database is not a local database, parses the input query and generates a global schema for each item of a return clause included in the parsed query.

1 more element

Dependencies are inferred from the claim text.

Method of generating database schema to provide integrated view of dispersed data and data integrating system

Life of this patent

Method of generating database schema to provide integrated view of dispersed data and data integrating system

Life of this patent

Abstract

Claims10