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
Link To Document