{"id":"https://openalex.org/W2948906765","doi":"https://doi.org/10.1145/3299869.3324959","title":"RaSQL","display_name":"RaSQL","publication_year":2019,"publication_date":"2019-06-18","ids":{"openalex":"https://openalex.org/W2948906765","doi":"https://doi.org/10.1145/3299869.3324959","mag":"2948906765"},"language":"en","primary_location":{"id":"doi:10.1145/3299869.3324959","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3299869.3324959","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2019 International Conference on Management of Data","raw_type":"proceedings-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/A5090386129","display_name":"Jiaqi Gu","orcid":"https://orcid.org/0000-0001-8535-7698"},"institutions":[{"id":"https://openalex.org/I161318765","display_name":"University of California, Los Angeles","ror":"https://ror.org/046rm7j60","country_code":"US","type":"education","lineage":["https://openalex.org/I161318765"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Jiaqi Gu","raw_affiliation_strings":["University of California, Los Angeles, Los Angeles, CA, USA"],"affiliations":[{"raw_affiliation_string":"University of California, Los Angeles, Los Angeles, CA, USA","institution_ids":["https://openalex.org/I161318765"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034161987","display_name":"Yugo H. Watanabe","orcid":null},"institutions":[{"id":"https://openalex.org/I161318765","display_name":"University of California, Los Angeles","ror":"https://ror.org/046rm7j60","country_code":"US","type":"education","lineage":["https://openalex.org/I161318765"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yugo H. Watanabe","raw_affiliation_strings":["University of California, Los Angeles, Los Angeles, CA, USA"],"affiliations":[{"raw_affiliation_string":"University of California, Los Angeles, Los Angeles, CA, USA","institution_ids":["https://openalex.org/I161318765"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064796242","display_name":"William A. Mazza","orcid":null},"institutions":[{"id":"https://openalex.org/I71267560","display_name":"University of Naples Federico II","ror":"https://ror.org/05290cv24","country_code":"IT","type":"education","lineage":["https://openalex.org/I71267560"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"William A. Mazza","raw_affiliation_strings":["Univ. of Naples Federico II, Naples, Italy"],"affiliations":[{"raw_affiliation_string":"Univ. of Naples Federico II, Naples, Italy","institution_ids":["https://openalex.org/I71267560"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5073720497","display_name":"Alexander Shkapsky","orcid":null},"institutions":[{"id":"https://openalex.org/I4210132246","display_name":"Workday (United States)","ror":"https://ror.org/02nn1vm89","country_code":"US","type":"company","lineage":["https://openalex.org/I4210132246"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Alexander Shkapsky","raw_affiliation_strings":["Workday, Inc., Pleasanton, CA, USA"],"affiliations":[{"raw_affiliation_string":"Workday, Inc., Pleasanton, CA, USA","institution_ids":["https://openalex.org/I4210132246"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103075868","display_name":"Mohan Yang","orcid":"https://orcid.org/0000-0002-6886-0256"},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Mohan Yang","raw_affiliation_strings":["Google LLC, Mountain View, CA, USA"],"affiliations":[{"raw_affiliation_string":"Google LLC, Mountain View, CA, USA","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5089004332","display_name":"Ling Ding","orcid":"https://orcid.org/0000-0002-1146-4535"},"institutions":[{"id":"https://openalex.org/I161318765","display_name":"University of California, Los Angeles","ror":"https://ror.org/046rm7j60","country_code":"US","type":"education","lineage":["https://openalex.org/I161318765"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ling Ding","raw_affiliation_strings":["University of California, Los Angeles, Los Angeles, CA, USA"],"affiliations":[{"raw_affiliation_string":"University of California, Los Angeles, Los Angeles, CA, USA","institution_ids":["https://openalex.org/I161318765"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5113467760","display_name":"Carlo Zaniolo","orcid":null},"institutions":[{"id":"https://openalex.org/I161318765","display_name":"University of California, Los Angeles","ror":"https://ror.org/046rm7j60","country_code":"US","type":"education","lineage":["https://openalex.org/I161318765"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Carlo Zaniolo","raw_affiliation_strings":["University of California, Los Angeles, Los Angeles, CA, USA"],"affiliations":[{"raw_affiliation_string":"University of California, Los Angeles, Los Angeles, CA, USA","institution_ids":["https://openalex.org/I161318765"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5090386129"],"corresponding_institution_ids":["https://openalex.org/I161318765"],"apc_list":null,"apc_paid":null,"fwci":1.9232,"has_fulltext":false,"cited_by_count":30,"citation_normalized_percentile":{"value":0.89115885,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"467","last_page":"484"},"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/T11106","display_name":"Data Management and Algorithms","score":0.9983000159263611,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9976999759674072,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.886380672454834},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7616422176361084},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.6578596234321594},{"id":"https://openalex.org/keywords/software-portability","display_name":"Software portability","score":0.6447815895080566},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.6286572217941284},{"id":"https://openalex.org/keywords/compiler","display_name":"Compiler","score":0.6143302917480469},{"id":"https://openalex.org/keywords/operator","display_name":"Operator (biology)","score":0.5054974555969238},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.4798718988895416},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4517847001552582},{"id":"https://openalex.org/keywords/scala","display_name":"Scala","score":0.4472118020057678},{"id":"https://openalex.org/keywords/simple","display_name":"Simple (philosophy)","score":0.41213685274124146},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.35919952392578125},{"id":"https://openalex.org/keywords/java","display_name":"Java","score":0.20400407910346985},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.2006893754005432}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.886380672454834},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7616422176361084},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.6578596234321594},{"id":"https://openalex.org/C63000827","wikidata":"https://www.wikidata.org/wiki/Q3080428","display_name":"Software portability","level":2,"score":0.6447815895080566},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.6286572217941284},{"id":"https://openalex.org/C169590947","wikidata":"https://www.wikidata.org/wiki/Q47506","display_name":"Compiler","level":2,"score":0.6143302917480469},{"id":"https://openalex.org/C17020691","wikidata":"https://www.wikidata.org/wiki/Q139677","display_name":"Operator (biology)","level":5,"score":0.5054974555969238},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.4798718988895416},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4517847001552582},{"id":"https://openalex.org/C109701466","wikidata":"https://www.wikidata.org/wiki/Q460584","display_name":"Scala","level":3,"score":0.4472118020057678},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.41213685274124146},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.35919952392578125},{"id":"https://openalex.org/C548217200","wikidata":"https://www.wikidata.org/wiki/Q251","display_name":"Java","level":2,"score":0.20400407910346985},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2006893754005432},{"id":"https://openalex.org/C158448853","wikidata":"https://www.wikidata.org/wiki/Q425218","display_name":"Repressor","level":4,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C86339819","wikidata":"https://www.wikidata.org/wiki/Q407384","display_name":"Transcription factor","level":3,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3299869.3324959","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3299869.3324959","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2019 International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":57,"referenced_works":["https://openalex.org/W78077100","https://openalex.org/W125332145","https://openalex.org/W1425731158","https://openalex.org/W1448681276","https://openalex.org/W1486392831","https://openalex.org/W1493893823","https://openalex.org/W1590360882","https://openalex.org/W1602871442","https://openalex.org/W1807272711","https://openalex.org/W1823445833","https://openalex.org/W1846087057","https://openalex.org/W1993892970","https://openalex.org/W2001340865","https://openalex.org/W2016531106","https://openalex.org/W2033258621","https://openalex.org/W2038412523","https://openalex.org/W2046413390","https://openalex.org/W2082171780","https://openalex.org/W2083541728","https://openalex.org/W2087032149","https://openalex.org/W2096544401","https://openalex.org/W2096650850","https://openalex.org/W2098678491","https://openalex.org/W2100586946","https://openalex.org/W2101196063","https://openalex.org/W2106771621","https://openalex.org/W2114409719","https://openalex.org/W2118668463","https://openalex.org/W2119011418","https://openalex.org/W2131785201","https://openalex.org/W2141711298","https://openalex.org/W2145067417","https://openalex.org/W2151251992","https://openalex.org/W2170616854","https://openalex.org/W2173213060","https://openalex.org/W2189465200","https://openalex.org/W2214884049","https://openalex.org/W2215524946","https://openalex.org/W2219764230","https://openalex.org/W2280236292","https://openalex.org/W2296407087","https://openalex.org/W2341979758","https://openalex.org/W2433992225","https://openalex.org/W2493178615","https://openalex.org/W2585641484","https://openalex.org/W2612488340","https://openalex.org/W2613995098","https://openalex.org/W2743659711","https://openalex.org/W2747409681","https://openalex.org/W2799059383","https://openalex.org/W2805517282","https://openalex.org/W2856694434","https://openalex.org/W2897611396","https://openalex.org/W2964250337","https://openalex.org/W3098257205","https://openalex.org/W4285719527","https://openalex.org/W4289761483"],"related_works":["https://openalex.org/W107105315","https://openalex.org/W4367156293","https://openalex.org/W1584537303","https://openalex.org/W4388155270","https://openalex.org/W4248962295","https://openalex.org/W1872724644","https://openalex.org/W2128640905","https://openalex.org/W2011460173","https://openalex.org/W2021092055","https://openalex.org/W2768256330"],"abstract_inverted_index":{"Thanks":[0],"to":[1,31,54],"a":[2],"simple":[3],"SQL":[4,67],"extension,":[5],"Recursive-aggregate-SQL":[6],"(RaSQL)":[7],"can":[8],"express":[9],"very":[10],"powerful":[11],"queries":[12,34],"and":[13,21,58,73,77,89],"declarative":[14,33],"algorithms,":[15],"such":[16],"as":[17],"classical":[18],"graph":[19],"algorithms":[20],"data":[22],"mining":[23],"algorithms.":[24],"A":[25,45],"novel":[26],"compiler":[27],"implementation":[28,48,74],"allows":[29],"RaSQL":[30,62],"map":[32],"into":[35],"one":[36],"basic":[37],"fixpoint":[38,51],"operator":[39,52],"supporting":[40],"aggregates":[41],"in":[42],"recursive":[43],"queries.":[44],"fully":[46],"optimized":[47],"of":[49,82],"this":[50],"leads":[53],"superior":[55],"performance,":[56],"scalability":[57],"portability.":[59],"Thus,":[60],"our":[61],"system,":[63],"which":[64],"extends":[65],"Spark":[66],"with":[68],"the":[69,80],"before-mentioned":[70],"new":[71],"constructs":[72],"techniques,":[75],"matches":[76],"often":[78],"surpasses":[79],"performance":[81],"other":[83],"systems,":[84],"including":[85],"Apache":[86],"Giraph,":[87],"GraphX":[88],"Myria.":[90]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":4},{"year":2021,"cited_by_count":5},{"year":2020,"cited_by_count":6},{"year":2019,"cited_by_count":4}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2019-06-14T00:00:00"}