Diego Arroyuelo, Fabrizio Barisione, Antonio Fariña, Adrián Gómez-Brandón, Gonzalo Navarro
{"title":"用于图数据库多重连接的新压缩索引","authors":"Diego Arroyuelo, Fabrizio Barisione, Antonio Fariña, Adrián Gómez-Brandón, Gonzalo Navarro","doi":"arxiv-2408.00558","DOIUrl":null,"url":null,"abstract":"A recent surprising result in the implementation of worst-case-optimal (wco)\nmultijoins in graph databases (specifically, basic graph patterns) is that they\ncan be supported on graph representations that take even less space than a\nplain representation, and orders of magnitude less space than classical\nindices, while offering comparable performance. In this paper we uncover a wide\nset of new wco space-time tradeoffs: we (1) introduce new compact indices that\nhandle multijoins in wco time, and (2) combine them with new query resolution\nstrategies that offer better times in practice. As a result, we improve the\naverage query times of current compact representations by a factor of up to 13\nto produce the first 1000 results, and using twice their space, reduce their\ntotal average query time by a factor of 2. Our experiments suggest that there\nis more room for improvement in terms of generating better query plans for\nmultijoins.","PeriodicalId":501123,"journal":{"name":"arXiv - CS - Databases","volume":null,"pages":null},"PeriodicalIF":0.0000,"publicationDate":"2024-08-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"New Compressed Indices for Multijoins on Graph Databases\",\"authors\":\"Diego Arroyuelo, Fabrizio Barisione, Antonio Fariña, Adrián Gómez-Brandón, Gonzalo Navarro\",\"doi\":\"arxiv-2408.00558\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"A recent surprising result in the implementation of worst-case-optimal (wco)\\nmultijoins in graph databases (specifically, basic graph patterns) is that they\\ncan be supported on graph representations that take even less space than a\\nplain representation, and orders of magnitude less space than classical\\nindices, while offering comparable performance. In this paper we uncover a wide\\nset of new wco space-time tradeoffs: we (1) introduce new compact indices that\\nhandle multijoins in wco time, and (2) combine them with new query resolution\\nstrategies that offer better times in practice. As a result, we improve the\\naverage query times of current compact representations by a factor of up to 13\\nto produce the first 1000 results, and using twice their space, reduce their\\ntotal average query time by a factor of 2. Our experiments suggest that there\\nis more room for improvement in terms of generating better query plans for\\nmultijoins.\",\"PeriodicalId\":501123,\"journal\":{\"name\":\"arXiv - CS - Databases\",\"volume\":null,\"pages\":null},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2024-08-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"arXiv - CS - Databases\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/arxiv-2408.00558\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"arXiv - CS - Databases","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/arxiv-2408.00558","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
New Compressed Indices for Multijoins on Graph Databases
A recent surprising result in the implementation of worst-case-optimal (wco)
multijoins in graph databases (specifically, basic graph patterns) is that they
can be supported on graph representations that take even less space than a
plain representation, and orders of magnitude less space than classical
indices, while offering comparable performance. In this paper we uncover a wide
set of new wco space-time tradeoffs: we (1) introduce new compact indices that
handle multijoins in wco time, and (2) combine them with new query resolution
strategies that offer better times in practice. As a result, we improve the
average query times of current compact representations by a factor of up to 13
to produce the first 1000 results, and using twice their space, reduce their
total average query time by a factor of 2. Our experiments suggest that there
is more room for improvement in terms of generating better query plans for
multijoins.