{"id":"https://openalex.org/W2546435473","doi":"https://doi.org/10.14778/2994509.2994510","title":"G-SQL","display_name":"G-SQL","publication_year":2016,"publication_date":"2016-08-01","ids":{"openalex":"https://openalex.org/W2546435473","doi":"https://doi.org/10.14778/2994509.2994510","mag":"2546435473"},"language":"en","primary_location":{"id":"doi:10.14778/2994509.2994510","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2994509.2994510","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/A5043145009","display_name":"Hongbin Ma","orcid":"https://orcid.org/0000-0003-0930-517X"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Hongbin Ma","raw_affiliation_strings":["eBay, Shanghai, China"],"affiliations":[{"raw_affiliation_string":"eBay, Shanghai, China","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101518422","display_name":"Bin Shao","orcid":"https://orcid.org/0000-0002-9790-5687"},"institutions":[{"id":"https://openalex.org/I4210113369","display_name":"Microsoft Research Asia (China)","ror":"https://ror.org/0300m5276","country_code":"CN","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210113369"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Bin Shao","raw_affiliation_strings":["Microsoft Research Asia, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Microsoft Research Asia, Beijing, China","institution_ids":["https://openalex.org/I4210113369"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5090455375","display_name":"Yanghua Xiao","orcid":"https://orcid.org/0000-0001-8403-9591"},"institutions":[{"id":"https://openalex.org/I24943067","display_name":"Fudan University","ror":"https://ror.org/013q1eq08","country_code":"CN","type":"education","lineage":["https://openalex.org/I24943067"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yanghua Xiao","raw_affiliation_strings":["Fudan University, Shanghai, China"],"affiliations":[{"raw_affiliation_string":"Fudan University, Shanghai, China","institution_ids":["https://openalex.org/I24943067"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5082243416","display_name":"Liang Jeff Chen","orcid":null},"institutions":[{"id":"https://openalex.org/I4210113369","display_name":"Microsoft Research Asia (China)","ror":"https://ror.org/0300m5276","country_code":"CN","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210113369"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Liang Jeff Chen","raw_affiliation_strings":["Microsoft Research Asia, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Microsoft Research Asia, Beijing, China","institution_ids":["https://openalex.org/I4210113369"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5063351917","display_name":"Haixun Wang","orcid":"https://orcid.org/0009-0007-0773-7004"},"institutions":[{"id":"https://openalex.org/I4210114444","display_name":"Meta (United States)","ror":"https://ror.org/01zbnvs85","country_code":"US","type":"company","lineage":["https://openalex.org/I4210114444"]},{"id":"https://openalex.org/I4210099336","display_name":"Menlo School","ror":"https://ror.org/01240pn49","country_code":"US","type":"education","lineage":["https://openalex.org/I4210099336"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Haixun Wang","raw_affiliation_strings":["Facebook, Menlo Park"],"affiliations":[{"raw_affiliation_string":"Facebook, Menlo Park","institution_ids":["https://openalex.org/I4210114444","https://openalex.org/I4210099336"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5043145009"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.67,"has_fulltext":false,"cited_by_count":13,"citation_normalized_percentile":{"value":0.89524561,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":"9","issue":"12","first_page":"900","last_page":"911"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12292","display_name":"Graph Theory and Algorithms","score":0.9998999834060669,"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"}},"topics":[{"id":"https://openalex.org/T12292","display_name":"Graph Theory and Algorithms","score":0.9998999834060669,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9987999796867371,"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.996399998664856,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.9080658555030823},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6206299066543579},{"id":"https://openalex.org/keywords/graph-database","display_name":"Graph database","score":0.5747348666191101},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4669194221496582},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.44241228699684143},{"id":"https://openalex.org/keywords/graph-traversal","display_name":"Graph traversal","score":0.42643052339553833},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.404825896024704},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.38351887464523315},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3369271755218506}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9080658555030823},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6206299066543579},{"id":"https://openalex.org/C176225458","wikidata":"https://www.wikidata.org/wiki/Q595971","display_name":"Graph database","level":3,"score":0.5747348666191101},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4669194221496582},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.44241228699684143},{"id":"https://openalex.org/C96333769","wikidata":"https://www.wikidata.org/wiki/Q907955","display_name":"Graph traversal","level":3,"score":0.42643052339553833},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.404825896024704},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.38351887464523315},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3369271755218506}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/2994509.2994510","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2994509.2994510","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":[{"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure","score":0.44999998807907104}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":33,"referenced_works":["https://openalex.org/W78077100","https://openalex.org/W253264081","https://openalex.org/W1487405157","https://openalex.org/W1489285575","https://openalex.org/W1549439022","https://openalex.org/W1570991867","https://openalex.org/W1616338336","https://openalex.org/W1788180225","https://openalex.org/W1943411325","https://openalex.org/W1973898816","https://openalex.org/W1982177147","https://openalex.org/W1997520998","https://openalex.org/W2022015062","https://openalex.org/W2028716971","https://openalex.org/W2041021943","https://openalex.org/W2069944651","https://openalex.org/W2089247435","https://openalex.org/W2096848102","https://openalex.org/W2100586946","https://openalex.org/W2102303750","https://openalex.org/W2112132204","https://openalex.org/W2118212234","https://openalex.org/W2123659430","https://openalex.org/W2135577024","https://openalex.org/W2137152505","https://openalex.org/W2152603468","https://openalex.org/W2160459668","https://openalex.org/W2170616854","https://openalex.org/W2171539317","https://openalex.org/W2486095760","https://openalex.org/W4256251415","https://openalex.org/W4285719527","https://openalex.org/W6638233953"],"related_works":["https://openalex.org/W2950177805","https://openalex.org/W4300908983","https://openalex.org/W244044452","https://openalex.org/W2909405936","https://openalex.org/W1901747001","https://openalex.org/W2003603054","https://openalex.org/W2807077404","https://openalex.org/W1005082427","https://openalex.org/W2908735009","https://openalex.org/W2786642168"],"abstract_inverted_index":{"A":[0],"lot":[1],"of":[2,6,97,112,119,133,235],"real-life":[3],"data":[4,35,167,173,177],"are":[5,30,39],"graph":[7,42,45,49,58,88,99,140,147,153,188,199],"nature.":[8],"However,":[9],"it":[10,53,161,192],"is":[11,84,92,105,182,223],"not":[12,40],"until":[13],"recently":[14],"that":[15,60,229],"business":[16,23],"begins":[17],"to":[18,68,74,86,108,155,164,196,218],"exploit":[19],"data's":[20],"connectedness":[21],"for":[22,34,41,51,241],"insights.":[24],"On":[25],"the":[26,76,79,116,131,145,152,197,209,220],"other":[27],"hand,":[28],"RDBMSs":[29,163],"a":[31,47,57,62,93,109,134,137,183,214],"mature":[32,166],"technology":[33],"management,":[36],"but":[37],"they":[38],"processing.":[43],"Take":[44],"traversal,":[46],"common":[48],"operation":[50,104],"example,":[52],"heavily":[54],"relies":[55],"on":[56],"primitive":[59],"accesses":[61],"given":[63],"node's":[64],"neighborhood.":[65],"We":[66],"need":[67],"join":[69,158],"tables":[70],"following":[71],"foreign":[72],"keys":[73],"access":[75,178],"nodes":[77],"in":[78],"neighborhood":[80],"if":[81],"an":[82],"RDBMS":[83,135],"used":[85],"manage":[87],"data.":[89],"Graph":[90],"exploration":[91,148,189],"fundamental":[94],"building":[95],"block":[96],"many":[98],"algorithms.":[100],"But":[101],"this":[102,123],"simple":[103],"costly":[106],"due":[107],"large":[110],"volume":[111],"I/O":[113],"caused":[114],"by":[115,151],"massive":[117],"amount":[118],"table":[120],"joins.":[121],"In":[122],"paper,":[124],"we":[125],"present":[126],"G-SQL,":[127],"our":[128,230],"effort":[129],"toward":[130],"integration":[132],"and":[136,175,191,201,237],"native":[138],"in-memory":[139,198],"processing":[141],"engine.":[142],"G-SQL":[143,181,206],"leverages":[144],"fast":[146],"capability":[149],"provided":[150],"engine":[154,200],"answer":[156],"multi-way":[157],"queries.":[159,244],"Meanwhile,":[160],"uses":[162],"provide":[165],"management":[168],"functionalities,":[169],"such":[170],"as":[171],"reliable":[172],"storage":[174],"additional":[176],"methods.":[179],"Specifically,":[180],"SQL":[184],"dialect":[185],"augmented":[186],"with":[187],"functionalities":[190],"dispatches":[193],"query":[194,211,222],"tasks":[195],"its":[202],"underlying":[203],"RDMBS.":[204],"The":[205],"runtime":[207],"coordinates":[208],"two":[210],"processors":[212],"via":[213],"unified":[215],"cost":[216],"model":[217],"ensure":[219],"entire":[221],"processed":[224],"efficiently.":[225],"Experimental":[226],"results":[227],"show":[228],"approach":[231],"greatly":[232],"expands":[233],"capabilities":[234],"RDBMs":[236],"delivers":[238],"exceptional":[239],"performance":[240],"SQL-graph":[242],"hybrid":[243]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2016-11-11T00:00:00"}