Micro-specialization: dynamic code specialization of database management systems
Micro-specialization: dynamic code specialization of database management systems
复制标题
微专业化：数据库管理系统的动态代码专业化
DOI：
--
复制
发表时间：
2012
期刊：
影响因子：
--
通讯作者：
R. Snodgrass
中科院分区：
文献类型：
--
作者：
Rui Zhang;S. Debray;R. Snodgrass
数据库管理系统（DBMS）是现代IT基础设施的基石，具有出色的性能至关重要。迄今为止，有关优化DBMS性能的大部分工作都强调确保从辅助存储高效访问数据。本文表明，DBMS也可以从动态代码专门化中受益匪浅。我们的方法侧重于这种系统通常使用的迭代查询评估循环。查询评估涉及到对关系模式、谓词值和连接类型的大量引用，这些在查询评估期间都是不变的，因此受到基于值的动态代码专门化的影响。
我们引入三种不同类型的专门化，每一种对应于一种特定的不变量。我们实现这些技术，在演唱会上称为微专业化，通过一个独立于DBMS的运行时环境，并将它们应用到一个高性能的开源DBMS，PostgreSQL。我们表明，微专业化需要最小的变化的DBMS，可以同时产生性能的提高，在广泛的查询和修改，在存储，CPU使用率和I/O时间的标准DBMS基准。我们还讨论了一个集成的开发环境，它可以帮助DBMS开发人员将微专门化应用于已识别的目标代码序列。
Database management systems (DBMSes) form a cornerstone of modern IT infrastructure, and it is essential that they have excellent performance. Much of the work to date on optimizing DBMS performance has emphasized ensuring efficient data access from secondary storage. This paper shows that DBMSes can also benefit significantly from dynamic code specialization. Our approach focuses on the iterative query evaluation loops typically used by such systems. Query evaluation involves extensive references to the relational schema, predicate values, and join types, which are all invariant during query evaluation, and thus are subject to dynamic value-based code specialization.
We introduce three distinct types of specialization, each corresponding to a particular kind of invariant. We realize these techniques, in concert termed micro-specialization, via a DBMS-independent run-time environment and apply them to a high-performance open-source DBMS, PostgreSQL. We show that micro-specialization requires minimal changes to the DBMS and can yield performance improvements simultaneously across a wide range of queries and modifications, in terms of storage, CPU usage, and I/O time of standard DBMS benchmarks. We also discuss an integrated development environment that helps DBMS developers apply micro-specializations to identified target code sequences.
为现代硬件高效编译高效的查询计划
DOI：
10.14778/2002938.2002940
发表时间：
2011
期刊：
Proc. VLDB Endow.
影响因子：
--
作者：
T. Neumann
通讯作者：
T. Neumann