摘要
数据库是数据分析、人工智能、云计算和大数据等领域的关键工作负载,是提高系统整体性能的关键。传统数据库系统查询执行效率偏低,并且CPU通常需要优先处理事务性负载,使数据查询逐渐成为制约整个数据库系统性能和效率提升的瓶颈。为了提高数据库在大规模并发访问时的数据处理能力,提出了一种CPU+FPGA加速数据库查询的异构体系结构,通过使用异构缓存一致性加速接口将加速器集成到CPU中,在FPGA内定制可配置的多引擎查询方式,对数据库查询进行加速。聚焦常用的SQL查询语句SELECT,详细分析了系统在延迟和简化的软件堆栈方面的优势,最后使用浪潮F37X加速卡和浪潮服务器对加速模型功能和性能进行了验证。实验结果表明,与使用POWER 9 CPU进行同样的查询操作相比,数据库系统整体处理速度提高了3~9倍,这种先进的异构计算加速结构可应用在未来数据库硬件专业化的设计中。
Database is a key workload in data analysis,artificial intelligence,cloud computing,big data,and other fields,and it is the key to improving the overall performance of the system.The query execution efficiency of traditional database systems is low,and the CPU usually needs to process tran-saction loads first,so that data query becomes a bottleneck that restricts the performance and efficiency of the entire system.In order to improve the system's ability of supporting large-scale data and high-intensity instantaneous concurrent access,a CPU+FPGA heterogeneous architecture is proposed to accelerate database queries.The accelerator is integrated into the CPU by using coherent acceleration processor interfaces.The way of customizing multi-engine configurable query logic in FPGA accelerates database query.The commonly used SQL query statement SELECT is focused on,and the advantages of the system in terms of latency and simplified software stack are analyzed in detail.Finally,the Inspur F37X acceleration card and Inspur server were used to verify the function and performance of the acceleration model.The test results show that,compared with the latest CPU-based query method,the proposal increase the overall processing speed by 3 to 9 times.The accelerated structure of structural computing can be applied in the design of database hardware specialization in the future.
作者
李仁刚
任智新
黄广奎
孙颉
王峰
张闯
LI Ren-gang;REN Zhi-xin;HUANG Guang-kui;SUN Jie;WANG Feng;ZHANG Chuang(Inspur Electronic Information Industry Co.,Ltd.,Jinan 250013;State Key Laboratory of High-end Server&Storage Technology,Jinan 250013,China)
出处
《计算机工程与科学》
CSCD
北大核心
2020年第12期2169-2178,共10页
Computer Engineering & Science
关键词
数据库查询
异构计算
异构体系结构
异构缓存一致性
POSTGRESQL
database query
heterogeneous acceleration
heterogeneous architecture
coherent accele-ration processor interface
Postgre SQL
