Efficient Computing of Relational Algebraic Primitives in a Database Machine Architecture

Algorithms are described and analyzed for the efficient evaluation of the primitive operators of a relational algebra on a database machine architecture. The architecture contains a RAM divided up into partitions, each partition having a separate server. Tuples from the first operand relation are stored in linked lists in the partitioned RAM via bit and pointer arrays based on hashed column values. Each tuple in the second operand relation is either deposited in the corresponding partition server queue based on the hashed value, or it is ignored. Cross-referencing involved in the operations is removed without performing a sorting operation, which significantly reduces the time complexity. A procedure is also presented for computing the optimal number of partition servers for different applications.

[1]  D. J. De Witt,et al.  Direct—A Multiprocessor Organization for Supporting Relational Database Management Systems , 1979 .

[2]  David K. Hsiao,et al.  Design and Analysis of a Relational Join Operation for VLSI , 1981, VLDB.

[3]  G. Jack Lipovski,et al.  The Architectural Features and Implementation Techniques of the Multicell CASSM , 1979, IEEE Transactions on Computers.

[4]  Kenneth C. Smith,et al.  RAP.2—An Associative Processor for Databases and Its Applications , 1979, IEEE Transactions on Computers.

[5]  Jayanta Banerjee,et al.  DBC—A Database Computer for Very Large Databases , 1979, IEEE Transactions on Computers.

[6]  Yang-Chang Hong.  Efficient Computing of Relational Join Operations by Means of Specialized Hardware , 1983, ICPP.

[7]  Yuzuru Tanaka,et al.  Pipeline Searching and Sorting Modules as Components of a Data Flow Database Computer , 1980, IFIP Congress.

[8]  Chyuan Shiun Lin,et al.  The design of a rotating associative memory for relational database applications , 1976, TODS.

[9]  Edward Babb,et al.  Implementing a relational database by means of specialzed hardware , 1979, TODS.

[10]  David Elliot Shaw.  A Relational Database Machine Architecture , 1980, CAW '80.

[11]  Stanley Y. W. Su,et al.  Cellular-Logic Devices: Concepts and Applications , 1979, Computer.

[12]  Kenneth C. Smith,et al.  RAP: an associative processor for data base management , 1975, AFIPS '75.

[13]  Stanley Y. W. Su,et al.  Associative hardware and software techniques for integrity control , 1981, TODS.

[14]  Stanley Y. W. Su,et al.  A Mechanism for Database Protection in Cellular-Logic Devices , 1982, IEEE Transactions on Software Engineering.

[15]  Diane C. P. Smith,et al.  Relational Data Base Machines , 1979, Computer.

[16]  Vincent Y. Lum,et al.  The Rebound Sorter: An Efficient Sort Engine for Large Files , 1978, VLDB.

[17]  Murray Edelberg,et al.  Intelligent memory , 1976, AFIPS '76.