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.