scispace - formally typeset
Search or ask a question

Showing papers by "Ramez Elmasri published in 1989"


Book
01 Jan 1989
TL;DR: Fundamentals of Database Systems combines clear explanations of theory and design, broad coverage of models and real systems, and excellent examples with up-to-date introductions to modern database technologies.
Abstract: From the Publisher: Fundamentals of Database Systems combines clear explanations of theory and design, broad coverage of models and real systems, and excellent examples with up-to-date introductions to modern database technologies. This edition is completely revised and updated, and reflects the latest trends in technological and application development. Professors Elmasri and Navathe focus on the relational model and include coverage of recent object-oriented developments. They also address advanced modeling and system enhancements in the areas of active databases, temporal and spatial databases, and multimedia information systems. This edition also surveys the latest application areas of data warehousing, data mining, web databases, digital libraries, GIS, and genome databases. New to the Third Edition Reorganized material on data modeling to clearly separate entity relationship modeling, extended entity relationship modeling, and object-oriented modeling Expanded coverage of the object-oriented and object/relational approach to data management, including ODMG and SQL3 Uses examples from real database systems including OracleTM and Microsoft AccessAE Includes discussion of decision support applications of data warehousing and data mining, as well as emerging technologies of web databases, multimedia, and mobile databases Covers advanced modeling in the areas of active, temporal, and spatial databases Provides coverage of issues of physical database tuning Discusses current database application areas of GIS, genome, and digital libraries

4,242 citations


Journal ArticleDOI
TL;DR: The authors present a common foundation for integrating pairs of entity sets, pairs of relationship sets, and an entity set with a relationship set based on the basic principle of integrating attributes.
Abstract: The authors present a common foundation for integrating pairs of entity sets, pairs of relationship sets, and an entity set with a relationship set. This common foundation is based on the basic principle of integrating attributes. Any pair of objects whose identifying attributes can be integrated can themselves be integrated. Several definitions of attribute equivalence are presented. These definitions can be used to specify the exact nature of the relationship between a pair of attributes. Based on these definitions, several strategies for attribute integration are presented and evaluated. >

445 citations


Proceedings ArticleDOI
03 Jan 1989
TL;DR: A method is developed for determining the constraints that hold on the integrated global database and for checking and enforcing constraints in a hierarchical fashion during global updates.
Abstract: In supporting global updates in a distributed database system obtained by database integration, three key problems arise: (1) update translation, i.e. how to translate a global update into a corresponding set of local updates; (2) constraint integration, i.e. how to determine what constraints exist on the integrated global database and how to check and enforce them during global updates; and (3) transaction management, i.e. distributed concurrency control, commit, and recovery mechanisms. The constraint integration problem is dealt with in the context of the integration of relational databases using the 2-D union operator, a slightly modified form of the outer natural join. Given the local constraints that hold on the individual local databases, a method is developed for determining the constraints that hold on the integrated global database and for checking and enforcing constraints in a hierarchical fashion during global updates. >

3 citations