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 :
بازگشت