RDBMS上图BI查询的微架构分析

Proceedings of the 19th International Workshop on Data Management on New Hardware Pub Date : 2023-06-18 DOI:10.1145/3592980.3595321

Rathijit Sen, Yuanyuan Tian

{"title":"RDBMS上图BI查询的微架构分析","authors":"Rathijit Sen, Yuanyuan Tian","doi":"10.1145/3592980.3595321","DOIUrl":null,"url":null,"abstract":"We present results of microarchitectural analysis for LDBC SNB BI queries on a relational database engine. We find underutilization of multicore CPUs, inefficient instruction execution, data access overheads at the on-chip cache hierarchy, data TLB overheads, and overall low (but short-term high) memory bandwidth utilization. Using huge pages increased query performance by up to 65% and workload performance by 23%.","PeriodicalId":400127,"journal":{"name":"Proceedings of the 19th International Workshop on Data Management on New Hardware","volume":"73 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2023-06-18","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Microarchitectural Analysis of Graph BI Queries on RDBMS\",\"authors\":\"Rathijit Sen, Yuanyuan Tian\",\"doi\":\"10.1145/3592980.3595321\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"We present results of microarchitectural analysis for LDBC SNB BI queries on a relational database engine. We find underutilization of multicore CPUs, inefficient instruction execution, data access overheads at the on-chip cache hierarchy, data TLB overheads, and overall low (but short-term high) memory bandwidth utilization. Using huge pages increased query performance by up to 65% and workload performance by 23%.\",\"PeriodicalId\":400127,\"journal\":{\"name\":\"Proceedings of the 19th International Workshop on Data Management on New Hardware\",\"volume\":\"73 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2023-06-18\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Proceedings of the 19th International Workshop on Data Management on New Hardware\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1145/3592980.3595321\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Proceedings of the 19th International Workshop on Data Management on New Hardware","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1145/3592980.3595321","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 0

摘要

我们给出了关系型数据库引擎上LDBC SNB BI查询的微架构分析结果。我们发现多核cpu利用率不足、指令执行效率低下、片上缓存层次结构的数据访问开销、数据TLB开销以及总体较低(但短期较高)的内存带宽利用率。使用大型页面可将查询性能提高65%，工作负载性能提高23%。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

查看原文本刊更多论文

Microarchitectural Analysis of Graph BI Queries on RDBMS

We present results of microarchitectural analysis for LDBC SNB BI queries on a relational database engine. We find underutilization of multicore CPUs, inefficient instruction execution, data access overheads at the on-chip cache hierarchy, data TLB overheads, and overall low (but short-term high) memory bandwidth utilization. Using huge pages increased query performance by up to 65% and workload performance by 23%.

求助全文

通过发布文献求助，成功后即可免费获取论文全文。去求助

来源期刊

Proceedings of the 19th International Workshop on Data Management on New Hardware

自引率

0.00%

发文量