III: Small: Database Algorithms for Modern CPU Memory Hierarchies

现代数据库服务器通常运行在具有大量RAM的机器集群上，以确保当通常访问的数据（甚至整个数据库）可以容纳在主内存中时快速查询响应。数据可以驻留在远程或本地内存中，或者驻留在几个级别的缓存中;每种类型的内存都有自己的特征大小和性能属性。 这个项目将开发查询处理算法和查询处理系统，以适应这种内存层次结构。分析数据库系统已经成为从从医学、科学到商业的“大数据”集合中提取可操作信息的关键技术。该项目实现的核心数据库操作性能的改进将对许多应用领域产生影响。该项目还将通过提供用于教学数据库系统实现技术的技术来促进教育。该项目将开发一种以有效分区为核心操作的数据库体系结构，在内存层次结构的每一级使用不同的分区技术。将在适当的地方采用就地分区，以避免分配额外的内存，分区速度只会有很小的下降。分区将被用作其他操作符（如排序、连接和聚合）的构建块。将实现各种数据库算法，利用分区的效率在规模上表现良好。 使用专门的连接算法将减少网络传输量，因为这种传输可能是涉及大型分布式连接的查询的瓶颈。 这些算法将构成在项目过程中开发的数据库系统原型的基础。该项目将提供新的技术，利用现代机器进行有效的分析查询处理。拟议的系统将大大提高数据密集型查询的吞吐量。欲了解更多信息，请访问项目网站：http://www.cs.columbia.edu/~kar/cpumem.html

A modern database server typically runs on a cluster of machines with a large amount of RAM, to ensure fast query responses when the commonly accessed data (or even the whole database) can fit in main memory. Data may reside in remote or local memory, or in one of several levels of cache; each type of memory has its own characteristic size and performance properties. This project will develop query processing algorithms and a query processing system tailored to such memory hierarchies. Analytic database systems have emerged as a key technology for extracting actionable information from "big data" collections ranging from medicine to science to business. Improvements in the performance of core database operations achieved by the project will have impact on many application domains. The project will also contribute to education by contributing technology for use in teaching database system implementation techniques.The project will develop a database architecture with efficient partitioning as the core operation, using different partitioning techniques at each level of the memory hierarchy. In-place partitioning will be employed where appropriate to avoid allocating extra memory, with only a small decrease in partitioning speed. Partitioning will be used as a building block for other operators such as sorting, joins and aggregation. A variety of database algorithms will be implemented, taking advantage of the efficiency of partitioning to perform well at scale. Network transfer volumes will be reduced using specialized join algorithms, since such transfers are likely to be the bottleneck for queries involving large distributed joins. These algorithms will form the basis of a database system prototype to be developed during the course of the project. The project will provide new techniques to exploit modern machines for efficient analytic query processing. The proposed system will significantly improve the throughput of data-intensive queries.For further information see the project web site at: http://www.cs.columbia.edu/~kar/cpumem.html