Resolving structural conflicts in the integration of Entity-Relationship schemas | Zendy

Mong Li Lee | Zendy; Tok Wang Ling | Zendy

AI Assistant Blog Pricing

Home ZAIA Blog

Open Access

Resolving structural conflicts in the integration of Entity-Relationship schemas

Author(s) -

Mong Li Lee,

Tok Wang Ling

Publication year - 1995

Publication title -

lecture notes in computer science

Language(s) - English

Resource type - Book series

SCImago Journal Rank - 0.249

H-Index - 400

eISSN - 1611-3349

pISSN - 0302-9743

ISBN - 3-540-60672-6

DOI - 10.1007/bfb0020552

Subject(s) - computer science , schema (genetic algorithms) , database schema , conceptual schema , schema migration , data integration , star schema , information schema , information retrieval , semi structured model , data mining , theoretical computer science , database design , gender schema theory , psychology , developmental psychology

Schema integration is essential to define a global schema that describes all the data in existing databases participating in a distributed or federated database management system. This paper describes a different approach to integrate two Entity-Relationship (ER) schemas. We focus on the resolution of structural conflicts. that is, when related real world concepts are modelled using different constructs in different schemas. Unlike previous works, our approach only needs to resolve the structural conflict between an entity type in one schema and an attribute in another schema and the other structural conflicts are automatically resolved. We have an algorithm to transform an attribute in one schema into an equivalent entity type in another schema without any loss of semantics or functional dependencies which previous approaches have not considered.

The content you want is available to Zendy users.

Already have an account? Click here to sign in.

Having issues? You can contact us here

Accelerating Research