DocumentCode
1055349
Title
Alpha: an extension of relational algebra to express a class of recursive queries
Author
Agrawal, Rakesh
Author_Institution
AT&T Bell Labs., Murray Hill, NJ, USA
Volume
14
Issue
7
fYear
1988
fDate
7/1/1988 12:00:00 AM
Firstpage
879
Lastpage
885
Abstract
An extension of E.F. Codd´s relational algebra (1970) with an alpha (α) operator is presented that allows a large class of natural and useful recursive queries to be expressed, and yet has the property of being efficiently implementable. Formally, this class is a superset of linear recursive queries. Intuitively, this class comprises queries that examine transitive relationships between various instances of an entity. It is believed that this class covers many natural and interesting recursive queries. Examples of such queries include determining parts requirements for manufacturing a product, finding the critical path in a project management network, finding the shortest path between two cities, verifying connectivity between two points of a circuit, etc
Keywords
database theory; query languages; recursive functions; relational databases; Codd; alpha operator; critical path; deductive databases; project management network; recursive queries; relational algebra; transitive relationships; Aggregates; Algebra; Calculus; Database languages; Database systems; Deductive databases; Manufacturing; Project management; Proposals; Relational databases;
fLanguage
English
Journal_Title
Software Engineering, IEEE Transactions on
Publisher
ieee
ISSN
0098-5589
Type
jour
DOI
10.1109/32.42731
Filename
42731
Link To Document