Issue No.03 - March (1991 vol.40)
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/12.76403
<p>The design and analysis of a special function unit for database operations (SFU-DB) that uses a novel hardware sorting module, the automatic retrieval memory (ARM), are described. The SFU-DB is a functionally independent unit that efficiently performs certain nonnumeric operations. It can function as a coprocessor for a host CPU or as a special processing unit in a highly parallel processing system. The ARM implements in hardware a true distribution-based sort algorithm that requires no comparison operations. Without performing any comparison, the SFU-DB avoids the lower bound constraint on comparison-based sorting algorithms and achieves, for the worst case, a complexity of O(n) for both execution time and main memory size. Using the fundamental sort algorithm with slight modifications. the SFU-DB also uses the ARM as an engine for other primitive database operations such as relational join, elimination of duplicates, set union, set intersection, and set difference, also with complexity of O(n). The SFU-DB/ARM architecture is rather simple and requires only a modest amount of specialized hardware. The specialized hardware has been designed and simulated for fabrication using CMOS gate arrays, and the remainder of the SFU-DB has been simulated in software using Turbo Pascal running on an IBM-PC.</p>
worst case complexity; duplicates elimination; special function unit; database operations; SFU-DB; performance evaluation; hardware sorting module; automatic retrieval memory; nonnumeric operations; coprocessor; host CPU; special processing unit; parallel processing system; distribution-based sort algorithm; execution time; main memory size; fundamental sort algorithm; relational join; set union; set intersection; set difference; fabrication; CMOS gate arrays; Turbo Pascal; computational complexity; database management systems; parallel algorithms; performance evaluation; sorting; special purpose computers.
C. Lee, H. Lam, "A Special Function Unit for Database Operations (SFU-DB): Design and Performance Evaluation", IEEE Transactions on Computers, vol.40, no. 3, pp. 263-275, March 1991, doi:10.1109/12.76403