Please use this identifier to cite or link to this item:
|Title:||ERL: Logic for entity-relationship databases||Authors:||Grant, J.
Li Lee, M.
|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. 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.
checked on May 14, 2021
checked on May 2, 2021
Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.