{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,1,10]],"date-time":"2026-01-10T07:47:22Z","timestamp":1768031242286,"version":"3.49.0"},"reference-count":66,"publisher":"Association for Computing Machinery (ACM)","issue":"11","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2021,7]]},"abstract":"<jats:p>We revisit column-oriented storage and query processing techniques in the context of contemporary graph database management systems (GDBMSs). Similar to column-oriented RDBMSs, GDBMSs support read-heavy analytical workloads that however have fundamentally different data access patterns than traditional analytical workloads. We first derive a set of desiderata for optimizing storage and query processors of GDBMS based on their access patterns. We then present the design of columnar storage, compression, and query processing techniques based on these desiderata. In addition to showing direct integration of existing techniques from columnar RDBMSs, we also propose novel ones that are optimized for GDBMSs. These include a novel list-based query processor, which avoids expensive data copies of traditional block-based processors under many-to-many joins, a new data structure we call single-indexed edge property pages and an accompanying edge ID scheme, and a new application of Jacobson's bit vector index for compressing NULL values and empty lists. We integrated our techniques into the GraphflowDB in-memory GDBMS. Through extensive experiments, we demonstrate the scalability and query performance benefits of our techniques.<\/jats:p>","DOI":"10.14778\/3476249.3476297","type":"journal-article","created":{"date-parts":[[2021,10,27]],"date-time":"2021-10-27T16:46:23Z","timestamp":1635353183000},"page":"2491-2504","source":"Crossref","is-referenced-by-count":22,"title":["Columnar storage and list-based processing for graph database management systems"],"prefix":"10.14778","volume":"14","author":[{"given":"Pranjal","family":"Gupta","sequence":"first","affiliation":[{"name":"University of Waterloo"}]},{"given":"Amine","family":"Mhedhbi","sequence":"additional","affiliation":[{"name":"University of Waterloo"}]},{"given":"Semih","family":"Salihoglu","sequence":"additional","affiliation":[{"name":"University of Waterloo"}]}],"member":"320","published-online":{"date-parts":[[2021,10,27]]},"reference":[{"key":"e_1_2_1_1_1","volume-title":"Column Stores for Wide and Sparse Data. In Third Biennial Conference on Innovative Data Systems Research, CIDR 2007","author":"Abadi Daniel J.","year":"2007"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/1142473.1142548"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/1376616.1376712"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.5555\/1325851.1325900"},{"key":"e_1_2_1_5_1","volume-title":"Last Accessed","year":"2020"},{"key":"e_1_2_1_6_1","volume-title":"Last Accessed","author":"Authors JanusGraph","year":"2020"},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.14778\/2556549.2556579"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.14778\/2350229.2350242"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2006.67"},{"key":"e_1_2_1_10_1","unstructured":"Peter Boncz. 2002. Monet: A Next-Generation Database Kernel for Query-Intensive Applications. Ph.D. Dissertation. Universiteit van Amsterdam. https:\/\/ir.cwi.nl\/pub\/14832\/14832A.pdf  Peter Boncz. 2002. Monet: A Next-Generation Database Kernel for Query-Intensive Applications. Ph.D. Dissertation. Universiteit van Amsterdam. https:\/\/ir.cwi.nl\/pub\/14832\/14832A.pdf"},{"key":"e_1_2_1_11_1","volume-title":"Second Biennial Conference on Innovative Data Systems Research, CIDR 2005","author":"Boncz Peter A.","year":"2005"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.5555\/3307192"},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-030-33223-5_37"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-03367-4_9"},{"key":"e_1_2_1_15_1","volume-title":"Last Accessed","year":"2020"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/3314221.3314598"},{"key":"e_1_2_1_17_1","volume-title":"Last Accessed","author":"DB.","year":"2020"},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1145\/2723372.2742786"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1145\/3183713.3190657"},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.5555\/645483.656226"},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.5555\/129687.129692"},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1109\/69.273032"},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1109\/SOAC.1991.143840"},{"key":"e_1_2_1_24_1","volume-title":"Last Accessed","year":"2020"},{"key":"e_1_2_1_25_1","volume-title":"Last Accessed","year":"2021"},{"key":"e_1_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.1145\/3327964.3328495"},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1145\/1807167.1807227"},{"key":"e_1_2_1_29_1","first-page":"40","article-title":"MonetDB: Two Decades of Research in Column-oriented Database Architectures","volume":"35","author":"Idreos Stratos","year":"2012","journal-title":"IEEE Data Engineering Bulletin"},{"key":"e_1_2_1_30_1","doi-asserted-by":"publisher","DOI":"10.1109\/SFCS.1989.63533"},{"key":"e_1_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3056445"},{"key":"e_1_2_1_33_1","doi-asserted-by":"publisher","DOI":"10.1145\/2487788.2488173"},{"key":"e_1_2_1_34_1","volume-title":"Last Accessed","author":"Kunegis J\u00e9r\u00f4me","year":"2021"},{"key":"e_1_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.14778\/2850583.2850594"},{"key":"e_1_2_1_36_1","doi-asserted-by":"publisher","DOI":"10.1002\/spe.2203"},{"key":"e_1_2_1_37_1","doi-asserted-by":"publisher","DOI":"10.1145\/1081870.1081893"},{"key":"e_1_2_1_38_1","doi-asserted-by":"publisher","DOI":"10.14778\/3021924.3021941"},{"key":"e_1_2_1_39_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2015.7113298"},{"key":"e_1_2_1_40_1","volume-title":"Last Accessed","year":"2020"},{"key":"e_1_2_1_41_1","doi-asserted-by":"publisher","DOI":"10.14778\/3342263.3342643"},{"key":"e_1_2_1_42_1","doi-asserted-by":"publisher","DOI":"10.1145\/1397735.1397742"},{"key":"e_1_2_1_43_1","volume-title":"Last Accessed","author":"DB.","year":"2020"},{"key":"e_1_2_1_44_1","doi-asserted-by":"publisher","DOI":"10.1145\/1216370.1216372"},{"key":"e_1_2_1_45_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.tcs.2012.11.031"},{"key":"e_1_2_1_46_1","volume-title":"Last Accessed","year":"2020"},{"key":"e_1_2_1_47_1","volume-title":"Last Accessed","year":"2020"},{"key":"e_1_2_1_48_1","volume-title":"Last Accessed","year":"2020"},{"key":"e_1_2_1_49_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2011.5767868"},{"key":"e_1_2_1_50_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-009-0165-y"},{"key":"e_1_2_1_51_1","doi-asserted-by":"publisher","DOI":"10.1145\/3003665.3003667"},{"key":"e_1_2_1_52_1","doi-asserted-by":"publisher","DOI":"10.1145\/2656335"},{"key":"e_1_2_1_53_1","volume-title":"Last Accessed","year":"2020"},{"key":"e_1_2_1_54_1","volume-title":"Last Accessed","year":"2020"},{"key":"e_1_2_1_55_1","volume-title":"Datenbanksysteme f\u00fcr Business, Technologie und Web (BTW), 15. Fachtagung des GI-Fachbereichs \"Datenbanken und Informationssysteme\" (DBIS) (LNI)","author":"Rudolf Michael"},{"key":"e_1_2_1_56_1","doi-asserted-by":"publisher","DOI":"10.1145\/3186728.3164139"},{"key":"e_1_2_1_57_1","doi-asserted-by":"publisher","DOI":"10.1145\/3226595.3226638"},{"key":"e_1_2_1_58_1","doi-asserted-by":"publisher","DOI":"10.1145\/3318464.3386138"},{"key":"e_1_2_1_59_1","volume-title":"Last Accessed","year":"2020"},{"key":"e_1_2_1_60_1","volume-title":"Proceedings of the 8th IFIP Congress","author":"Uemura Syunsuke","year":"1980"},{"key":"e_1_2_1_61_1","volume-title":"Last Accessed","year":"2020"},{"key":"e_1_2_1_62_1","doi-asserted-by":"publisher","DOI":"10.14778\/1453856.1453965"},{"key":"e_1_2_1_63_1","doi-asserted-by":"publisher","DOI":"10.1145\/362084.362137"},{"key":"e_1_2_1_64_1","doi-asserted-by":"publisher","DOI":"10.1145\/3375660"},{"key":"e_1_2_1_65_1","doi-asserted-by":"publisher","DOI":"10.14778\/3384345.3384351"},{"key":"e_1_2_1_66_1","doi-asserted-by":"publisher","DOI":"10.1145\/2213836.2213967"},{"key":"e_1_2_1_67_1","first-page":"21","article-title":"Vectorwise","volume":"35","author":"Zukowski Marcin","year":"2012","journal-title":"Beyond Column Stores. IEEE Data Engineering Bulletin"},{"key":"e_1_2_1_68_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2006.150"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3476249.3476297","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T10:06:40Z","timestamp":1672222000000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3476249.3476297"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2021,7]]},"references-count":66,"journal-issue":{"issue":"11","published-print":{"date-parts":[[2021,7]]}},"alternative-id":["10.14778\/3476249.3476297"],"URL":"https:\/\/doi.org\/10.14778\/3476249.3476297","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2021,7]]}}}