A new concept for hardware acceleration of database code

This paper introduces a new concept in the field of CPU performance improvement for non-numeric processing. Instead of accelerating the most time-critical high-level software constructs in algorithms that are traditionally used for software implementations, we analyzed a variety of modified algorithms (non-optimal for software implementations) and the acceleration of their inherent low-level primitives. An original class of algorithms, OTHER (Ordered Table Hashing and Radix Sort) algorithms, proved useful for efficient hardware support. This paper presents the fundamentals of the OTHER algorithms and analyzes their possible acceleration efficiency for selected non-numeric operations. Two original accelerator architectures have been proposed and their performance was evaluated. Both accelerators are realized in the standard-cell VLSI technology. It was shown that a low complexity hardware support may significantly improve the processor performance for non-numeric operations.

[1]  Philip S. Yu,et al.  On Workload Characterization of Relational Database Environments , 1992, IEEE Trans. Software Eng..

[2]  David J. DeWitt,et al.  A Single User Evaluation of the Gamma Database Machine , 1987, IWDM.

[3]  C. V. Ramamoorthy,et al.  A Design of a Fast Cellular Associative Memory for Ordered Retrieval , 1978, IEEE Transactions on Computers.

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

[5]  Richard C. Singleton,et al.  Sorting by Address Calculation , 1956, JACM.

[6]  Ted G. Lewis,et al.  Hash Table Methods , 1975, CSUR.

[7]  David J. DeWitt,et al.  A methodology for database system performance evaluation , 1984, SIGMOD '84.

[8]  Masaru Kitsuregawa,et al.  The Super Database Computer (SDC): system architecture, algorithm and preliminary evaluation , 1992, Proceedings of the Twenty-Fifth Hawaii International Conference on System Sciences.

[9]  Ali R. Hurson,et al.  Parallel Architectures for Database Systems , 1989, Adv. Comput..

[10]  Victor Mak,et al.  VLSI accelerators for large database systems , 1991, IEEE Micro.

[11]  Emil Jovanov,et al.  Hardware implementation of some DBMS functions using SPR , 1992, Proceedings of the Twenty-Fifth Hawaii International Conference on System Sciences.

[12]  Emil Jovanov,et al.  A sorting processor for microcomputers , 1988 .

[13]  Donald Ervin Knuth,et al.  The Art of Computer Programming , 1968 .

[14]  Hideaki Takeda,et al.  Rinda: a relational database processor with hardware specialized for searching and sorting , 1991, IEEE Micro.