• 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