• DocumentCode
    1444929
  • Title

    Distributive implementation of relational operations

  • Author

    Ullmann, J.R.

  • Author_Institution
    Dept. of Comput., King´´s Coll., London, UK
  • Volume
    137
  • Issue
    4
  • fYear
    1990
  • fDate
    7/1/1990 12:00:00 AM
  • Firstpage
    283
  • Lastpage
    294
  • Abstract
    Like sorting algorithms, implementations of relational database operations can either be comparative or distributive or a hybrid of these. Relational intersection, natural join and union operations can be implemented distributively by bitwise Boolean operations on bit matrices that are superimposed coded representations of operand relations. A bitwise AND or OR operation yields a further bit matrix from which a result relation can be recovered by a backtrack search process that is fast if pruned by using highly parallel logic circuits implementing relational consistency conditions. The paper gives details of such circuits. The paper introduces a new mode of operation in which bit matrices are constructed on the fly during query answering. This mode is slower but has substantially lower hardware cost and no problem with deletion and with updating relations. Detection and elimination of spurious result tuples is straightforward.
  • Keywords
    logic design; relational databases; OR operation; bit matrices; bitwise AND; bitwise Boolean operations; distributive implementation; highly parallel logic circuits; natural join; operand relations; query answering; relational operations; union operations;
  • fLanguage
    English
  • Journal_Title
    Computers and Digital Techniques, IEE Proceedings E
  • Publisher
    iet
  • ISSN
    0143-7062
  • Type

    jour

  • Filename
    54332