Please use this identifier to cite or link to this item: https://doi.org/10.1007/BF00965874
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
Source: 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. https://doi.org/10.1007/BF00965874
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
URI: http://scholarbank.nus.edu.sg/handle/10635/99271
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.

SCOPUSTM   
Citations

2
checked on Jan 9, 2018

Page view(s)

26
checked on Jan 19, 2018

Google ScholarTM

Check

Altmetric


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