An Extension of the General Entity Manipulator Language for Global View Definition

Abstract We extend the General Entity Manipulator (GEM) language with a facility for defining multidatabase views which we call global views. Our language permits global entity types to be defined with the full features of GEM entity types including generalization, entity-valued attributes, and set-valued attributes. The language supports the definition of entity mappings which define how global entity occurrences are materialized from local entity occurrences and attribute mappings which define conversions between local and global attributes. Entity level mappings are defined with a GEM data retrieval expression or the outer join operator. Attribute mappings are defined with a rich variety of conversion techniques such as string operators, database queries, and pre-compiled procedures. The language also accommodates the initial definition of a global view as well as the maintenance of an existing global view.

[1]  Terry A. Landers,et al.  An Overview of MULTIBASE , 1986, DDB.

[2]  Clement T. Yu,et al.  Distributed query processing strategies in Mermaid, a frontend to data management systems , 1984, 1984 IEEE First International Conference on Data Engineering.

[3]  Virgil D. Gligor,et al.  Interconnecting Heterogeneous Database Management Systems , 1984, Computer.

[4]  Laura Yedwab,et al.  Processing Read-Only Queries Over Views With Generalization , 1984, VLDB.

[5]  Umeshwar Dayal,et al.  View Definition and Generalization for Database Integration in a Multidatabase System , 1984, IEEE Transactions on Software Engineering.

[6]  Dennis McLeod,et al.  A federated architecture for information management , 1985, TOIS.

[7]  Wolfgang Effelsberg,et al.  Attribute equivalence in global schema design for heterogeneous distributed databases , 1984, Inf. Syst..

[8]  Randy H. Katz,et al.  View Processing in MULTIBASE, A Heterogeneous Database System , 1981, ER.

[9]  Michael Stonebraker,et al.  Implementation of integrity constraints and views by query modification , 1975, SIGMOD '75.

[10]  Michael Victor Mannino.  A methodology for global schema design , 1983 .

[11]  Umeshwar Dayal,et al.  Processing Queries Over Generalization Hierarchies in a Multidatabase System , 1983, VLDB.

[12]  Carlo Zaniolo,et al.  The database language GEM , 1983, SIGMOD '83.

[13]  Wolfgang Effelsberg,et al.  Matching techniques in global schema design , 1984, 1984 IEEE First International Conference on Data Engineering.

[14]  Diane C. P. Smith,et al.  Database abstractions: aggregation and generalization , 1977, TODS.

[15]  Yuri Breitbart,et al.  Database integration in a distributed heterogeneous database system , 1986, 1986 IEEE Second International Conference on Data Engineering.