A Special Function Unit for Database Operations (SFU-DB): Design and Performance Evaluation

Herman Lam, C. Lee, Stanley Y.W. Su

研究成果: Article同行評審


This paper describes the design and analysis of a special function unit for database operations (SFU-DB) which uses a novel hardware sorting module, the Automatic Retrieval Memory (ARM). 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). Finally, 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.

頁(從 - 到)263-275
期刊IEEE Transactions on Computers
出版狀態Published - 1991 3月

All Science Journal Classification (ASJC) codes

  • 軟體
  • 理論電腦科學
  • 硬體和架構
  • 計算機理論與數學


深入研究「A Special Function Unit for Database Operations (SFU-DB): Design and Performance Evaluation」主題。共同形成了獨特的指紋。