Please use this identifier to cite or link to this item:
Title: ERL: Logic for entity-relationship databases
Authors: Grant, J.
Ling, T.W.
Li Lee, M. 
Keywords: database language
database transformation
entity-relationship logic
entity-relationship model
first-order logic
Issue Date: Jun-1993
Citation: Grant, J.,Ling, T.W.,Li Lee, M. (1993-06). ERL: Logic for entity-relationship databases. Journal of Intelligent Information Systems 2 (2) : 115-147. ScholarBank@NUS Repository.
Abstract: We develop a logic for entity-relationship databases, ERL, that is a generalization of database logic. ERL provides advantages to the ER model much as FOL (first-order logic) does to the relational model: a uniform language for expressing database schema, integrity constraints, and database manipulation; clearly defined semantics; the capability to express database transformations; and deductive capabilities. We propose three query languages for ER databases called ERRC, ERSQL, and ERQBE, which are generalizations of the relational calculus, SQL, and QBE, respectively. We use example queries and updates to demonstrate the capabilities of these languages. We apply database transformations to introduce the notion of views and to show that both ERRC and ERSQL are relationally complete. © 1993 Kluwer Academic Publishers.
Source Title: Journal of Intelligent Information Systems
ISSN: 09259902
DOI: 10.1007/BF00965874
Appears in Collections:Staff Publications

Show full item record
Files in This Item:
There are no files associated with this item.


checked on May 14, 2021

Page view(s)

checked on May 2, 2021

Google ScholarTM



Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.