Design and Implementation of a Shared Memory Multiprocessor Database Machine

本项目的目标是研究和建立一个平行的 用于共享存储器多处理器输入/输出（I/O）系统。 主要 用于此系统的应用程序是并行数据库操作 其目标性能为每秒1000个事务。 这 该项目是在大学所做工作的自然延伸， 加州伯克利的共享内存多处理器体系结构（SPUR 项目）和数据库管理系统（INGRES和POSTGRES。 虽然在处理器领域已经取得了许多研究成果， 和内存设计的一些研究小组，相当少 我们的工作是针对I/O设计的问题。 作为 处理器速度提高，I/O操作变得更加明显， 构成了并行系统的瓶颈。磁盘技术现在 在该阶段，它可以提供具有成本效益的高I/O带宽。 具体的研究目标是：（1）探索新的方法， 将大量I/O设备耦合到多处理器， 影响有限的内存系统带宽;（2）探索 I/O处理器的体系结构;以及（3）实现硬件辅助 对于数据库应用程序，如稳定存储器、字符串操作 协处理器和硬件一致性以及日志记录机制。 强烈建议对这项建议提供资金，因为：（1） 主要研究者的研究记录非常好， 环境是非常刺激的-因此有很高的机会， （2）有必要进行平行研究。 该项目所涵盖的加工区，预计 这项研究的影响将是巨大的。

The goal of this project is to research and build a parallel input/output (I/O) system for a shared-memory multiprocessor. The main applications intended for this system are parallel database operations with a target performance of 1000 transactions per second. This project is a natural extension of work done at the University of California, Berkeley in shared-memory multiprocessor architecture (SPUR project) and database management systems (INGRES and POSTGRES). While many research results have been obtained in the area of processor and memory design by a number of research groups, considerable less effort has been directed towards the issues of I/O design. As processor speeds increase, it becomes more obvious that I/O operations constitute the bottleneck of parallel systems. Disk technology is now at the stage where it can provide cost effective high I/O bandwidth. The specific research objectives are: (1) to investigate new ways to couple large numbers of I/O devices to multiprocessors without affecting the limited memory system bandwidth; (2) to explore architectures for I/O processors; and (3) to implement hardware assists for database applications such as stable memories, string manipulation co-processors and hardware coherency and logging mechanisms. This proposal is strongly recommended for funding because: (1) the principal investigators research records are excellent and the research environment is extremely stimulating--thus there is a high chance of success; (2) there is a great need for research in the parallel processing area covered by this project and it is expected that the impact of this research will be significant.