{"id":"https://openalex.org/W2579169324","doi":"https://doi.org/10.14778/3021924.3021941","title":"Fast in-memory SQL analytics on typed graphs","display_name":"Fast in-memory SQL analytics on typed graphs","publication_year":2016,"publication_date":"2016-11-01","ids":{"openalex":"https://openalex.org/W2579169324","doi":"https://doi.org/10.14778/3021924.3021941","mag":"2579169324"},"language":"en","primary_location":{"id":"doi:10.14778/3021924.3021941","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3021924.3021941","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5036384670","display_name":"Chunbin Lin","orcid":"https://orcid.org/0000-0002-7068-9929"},"institutions":[{"id":"https://openalex.org/I2803209242","display_name":"University of California System","ror":"https://ror.org/00pjdza24","country_code":"US","type":"education","lineage":["https://openalex.org/I2803209242"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Chunbin Lin","raw_affiliation_strings":["University of California"],"affiliations":[{"raw_affiliation_string":"University of California","institution_ids":["https://openalex.org/I2803209242"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5022655976","display_name":"Benjamin Mandel","orcid":null},"institutions":[{"id":"https://openalex.org/I2803209242","display_name":"University of California System","ror":"https://ror.org/00pjdza24","country_code":"US","type":"education","lineage":["https://openalex.org/I2803209242"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Benjamin Mandel","raw_affiliation_strings":["University of California"],"affiliations":[{"raw_affiliation_string":"University of California","institution_ids":["https://openalex.org/I2803209242"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5059167302","display_name":"Yannis Papakonstantinou","orcid":"https://orcid.org/0009-0007-6360-9496"},"institutions":[{"id":"https://openalex.org/I2803209242","display_name":"University of California System","ror":"https://ror.org/00pjdza24","country_code":"US","type":"education","lineage":["https://openalex.org/I2803209242"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yannis Papakonstantinou","raw_affiliation_strings":["University of California"],"affiliations":[{"raw_affiliation_string":"University of California","institution_ids":["https://openalex.org/I2803209242"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5023094588","display_name":"Matthias Springer","orcid":"https://orcid.org/0000-0001-5077-7131"},"institutions":[{"id":"https://openalex.org/I2803209242","display_name":"University of California System","ror":"https://ror.org/00pjdza24","country_code":"US","type":"education","lineage":["https://openalex.org/I2803209242"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Matthias Springer","raw_affiliation_strings":["University of California"],"affiliations":[{"raw_affiliation_string":"University of California","institution_ids":["https://openalex.org/I2803209242"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5036384670"],"corresponding_institution_ids":["https://openalex.org/I2803209242"],"apc_list":null,"apc_paid":null,"fwci":2.3163,"has_fulltext":false,"cited_by_count":16,"citation_normalized_percentile":{"value":0.90043459,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":"10","issue":"3","first_page":"265","last_page":"276"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9997000098228455,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9997000098228455,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.998199999332428,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12292","display_name":"Graph Theory and Algorithms","score":0.9975000023841858,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8790752291679382},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.6337416768074036},{"id":"https://openalex.org/keywords/column","display_name":"Column (typography)","score":0.534477949142456},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5276055335998535},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.5031039118766785},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.43715885281562805},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.42015066742897034},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.33738940954208374},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.3060612082481384}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8790752291679382},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.6337416768074036},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.534477949142456},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5276055335998535},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.5031039118766785},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.43715885281562805},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.42015066742897034},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.33738940954208374},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.3060612082481384},{"id":"https://openalex.org/C126042441","wikidata":"https://www.wikidata.org/wiki/Q1324888","display_name":"Frame (networking)","level":2,"score":0.0},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3021924.3021941","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3021924.3021941","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":44,"referenced_works":["https://openalex.org/W79913551","https://openalex.org/W1482873624","https://openalex.org/W1521148341","https://openalex.org/W1569403765","https://openalex.org/W1578747365","https://openalex.org/W1704989917","https://openalex.org/W1932742904","https://openalex.org/W1996063819","https://openalex.org/W2005112390","https://openalex.org/W2006296837","https://openalex.org/W2014267653","https://openalex.org/W2034102265","https://openalex.org/W2066950784","https://openalex.org/W2071263634","https://openalex.org/W2072764742","https://openalex.org/W2085601491","https://openalex.org/W2085880494","https://openalex.org/W2104329103","https://openalex.org/W2105230838","https://openalex.org/W2106771621","https://openalex.org/W2108290652","https://openalex.org/W2108572131","https://openalex.org/W2110077960","https://openalex.org/W2114254535","https://openalex.org/W2114303224","https://openalex.org/W2116420167","https://openalex.org/W2117446654","https://openalex.org/W2117546628","https://openalex.org/W2133300302","https://openalex.org/W2139103617","https://openalex.org/W2158237121","https://openalex.org/W2159726625","https://openalex.org/W2164909398","https://openalex.org/W2168849769","https://openalex.org/W2208900636","https://openalex.org/W2232813226","https://openalex.org/W2257942629","https://openalex.org/W2533692962","https://openalex.org/W2546435473","https://openalex.org/W2548941637","https://openalex.org/W2971629451","https://openalex.org/W3138367763","https://openalex.org/W6675787820","https://openalex.org/W6677483091"],"related_works":["https://openalex.org/W2378213774","https://openalex.org/W2357522326","https://openalex.org/W6138692","https://openalex.org/W2363019959","https://openalex.org/W1535822977","https://openalex.org/W23190051","https://openalex.org/W2367419170","https://openalex.org/W2377387014","https://openalex.org/W2382180329","https://openalex.org/W2375394542"],"abstract_inverted_index":{"We":[0,37,63,167,250],"study":[1],"a":[2,24,65,95],"class":[3],"of":[4,27,33,79,87,119,156,187,197,201,216,229,240,247,267],"graph":[5,29,54],"analytics":[6],"SQL":[7],"queries,":[8],"which":[9,68,102,161],"we":[10],"call":[11],"relationship":[12,44],"queries.":[13,36],"These":[14],"queries":[15,31,45,172],"involving":[16],"aggregation,":[17],"join,":[18],"semijoin,":[19],"intersection":[20],"and":[21,32,53,91,110,112,189,192,225,234],"selection":[22],"are":[23,46,56,123,203],"wide":[25],"superset":[26],"fixed-length":[28],"reachability":[30],"tree":[34],"pattern":[35],"present":[38],"real-world":[39],"OLAP":[40,61,175],"scenarios,":[41],"where":[42],"efficient":[43,77],"needed.":[47],"However,":[48],"row":[49,120],"stores,":[50],"column":[51,126,149],"stores":[52],"databases":[55],"unacceptably":[57],"slow":[58],"in":[59,125,177],"such":[60],"scenarios.":[62],"propose":[64],"GQ-Fast":[66,93,128,141,151,169,181,241],"database,":[67],"is":[69],"an":[70],"indexed":[71],"database":[72],"that":[73,83,117,253],"roughly":[74],"corresponds":[75],"to":[76,170,243],"encoding":[78],"annotated":[80],"adjacency":[81],"lists":[82],"combines":[84],"salient":[85],"features":[86],"column-based":[88],"organization,":[89],"indexing":[90],"compression.":[92],"uses":[94],"bottom-up":[96,221],"fully":[97],"pipelined":[98],"query":[99,130],"execution":[100,223],"model,":[101],"enables":[103],"(a)":[104],"aggressive":[105],"compression":[106,157,248,261],"(e.g.,":[107],"compressed":[108],"bitmaps":[109],"Huffman)":[111],"(b)":[113],"avoids":[114],"intermediate":[115],"results":[116],"consist":[118],"IDs":[121],"(which":[122],"typical":[124],"databases).":[127],"compiles":[129],"plans":[131],"into":[132],"executable":[133],"C++":[134],"source":[135],"code.":[136],"Besides":[137],"achieving":[138],"runtime":[139,255],"efficiency,":[140],"also":[142,251],"reduces":[143],"main":[144],"memory":[145],"requirements":[146],"because,":[147],"unlike":[148],"databases,":[150],"selectively":[152],"allows":[153],"dense":[154,230,260],"forms":[155],"including":[158],"heavy-weight":[159],"compressions,":[160],"do":[162],"not":[163],"support":[164],"random":[165],"access.":[166],"used":[168],"accelerate":[171],"for":[173],"two":[174],"dashboards":[176],"the":[178,214,220,227,237,244,254,259,265],"biomedical":[179],"field.":[180],"outperforms":[182],"PostgreSQL":[183],"by":[184,194,258],"2--4":[185],"orders":[186,196],"magnitude":[188,198],"MonetDB,":[190],"Vertica":[191],"Neo4j":[193],"1--3":[195],"when":[199],"all":[200],"them":[202],"running":[204],"on":[205],"RAM.":[206],"Our":[207],"experiments":[208,235],"dissect":[209],"GQ-Fast's":[210],"advantage":[211],"between":[212],"(i)":[213],"use":[215,228,246],"compiled":[217],"code,":[218],"(ii)":[219],"pipelining":[222],"strategy,":[224],"(iii)":[226],"structures.":[231],"Other":[232],"analysis":[233],"show":[236,252],"space":[238],"savings":[239],"due":[242],"appropriate":[245],"methods.":[249],"penalty":[256],"incurred":[257],"methods":[262],"decreases":[263],"as":[264],"number":[266],"CPU":[268],"cores":[269],"increases.":[270]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":5}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}