III: Small: Extending and Automating Dynamic Specialization of Database Management Systems

数据库管理系统(DBMS)在工业中无处不在，其性能和功能在商业IT基础设施中至关重要。在改进这些关键系统的性能方面已经做了大量工作。本项目采用互补性和正交性相结合的方法来显著提高DBMS的性能。这是通过利用有关DBMS的运行时信息来动态专门化DBMS代码以尽可能多地消除不必要的工作来实现的。这种动态代码优化，我们称之为“微专门化”，是非常积极的，远远超出了使用现有编译器优化技术所能实现的范围。这种对运行时代码优化的关注也与当前大多数关于DBMS性能改进的研究有很大不同。该项目研究了自动识别代码序列的算法，其中微专门化可能是有益的；可以微专门化这种已识别的目标代码序列的算法；以及确保结果代码的正确性的技术。对不同的DBMS的初步研究表明，当应用于成熟、高性能的DBMS和行业标准基准时，微专业化可以显著提高性能，并有大量机会获得其他显著的性能提升，而对DBMS体系结构的影响最小。该项目的广泛影响包括提高了各种公司使用的IT基础设施的效率，从而提高了整体生产率。作为项目不可分割的一部分，研究生和本科生将参与研究活动的各个方面。私人投资机构在将研究活动纳入本科课程和让本科生，包括妇女和代表性不足的少数群体成员参与研究方面有着既定的记录；该项目延续了这一传统。有关更多信息，请访问http://www.cs.arizona.edu/projects/microspecialization/网站。

Database management systems (DBMSs) are ubiquitous in industry and their performance and functionality are crucially important in commercial IT infrastructure. There has been a lot of work on improving the performance of these critical systems. This project adopts a complementary and orthogonal approach to substantially increasing the performance of DBMSs. This is done by exploiting runtime information about the DBMS to specialize the DBMS code on the fly in order to eliminate as much unnecessary work as possible. This dynamic code optimization, which we term "micro-specialization", is highly aggressive and goes well beyond what can be achieved using existing compiler optimization technology. This focus on runtime code optimization is also very different from most of the current research on DBMS performance improvement. The project investigates algorithms for automatic identification of code sequences where micro-specialization may profitably be applied; algorithms that can micro-specialize such identified target code sequences; and techniques for ensuring the correctness of the resulting code. Preliminary studies on disparate DBMSes suggest that micro-specialization offers significant performance improvements when applied to mature, high-performance DBMSs and to industry-standard benchmarks, and that there are rich opportunities for other substantial performance gains, with minimal impact on the DBMS architecture.Broader impacts of this project include increased efficiency of the IT infrastructure used by a wide variety of companies, leading to improved overall productivity. Graduate and undergraduate students are involved in all aspects of the research activities as an integral part of the project. The PIs have an established track record of integrating research activities into the undergraduate curriculum and involving undergraduates, including women and members of underrepresented minorities, in research; this project continues this tradition.For further information see the web site at http://www.cs.arizona.edu/projects/microspecialization/ .