{"id":"https://openalex.org/W2806878452","doi":"https://doi.org/10.1145/3209950.3209958","title":"Snowtrail","display_name":"Snowtrail","publication_year":2018,"publication_date":"2018-06-05","ids":{"openalex":"https://openalex.org/W2806878452","doi":"https://doi.org/10.1145/3209950.3209958","mag":"2806878452"},"language":"en","primary_location":{"id":"doi:10.1145/3209950.3209958","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3209950.3209958","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Workshop on Testing Database Systems","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/A5101988437","display_name":"Jiaqi Yan","orcid":"https://orcid.org/0000-0001-6261-6802"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Jiaqi Yan","raw_affiliation_strings":["Snowflake Computing"],"affiliations":[{"raw_affiliation_string":"Snowflake Computing","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5062885939","display_name":"Qiuye Jin","orcid":"https://orcid.org/0000-0002-9474-4427"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Qiuye Jin","raw_affiliation_strings":["Snowflake Computing"],"affiliations":[{"raw_affiliation_string":"Snowflake Computing","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5067118709","display_name":"Shrainik Jain","orcid":null},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Shrainik Jain","raw_affiliation_strings":["University of Washington"],"affiliations":[{"raw_affiliation_string":"University of Washington","institution_ids":["https://openalex.org/I201448701"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5001088660","display_name":"Stratis D. Viglas","orcid":null},"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":"Stratis D. Viglas","raw_affiliation_strings":["Google"],"affiliations":[{"raw_affiliation_string":"Google","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5051343710","display_name":"Allison Lee","orcid":"https://orcid.org/0000-0002-9464-0927"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Allison Lee","raw_affiliation_strings":["Snowflake Computing"],"affiliations":[{"raw_affiliation_string":"Snowflake Computing","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5101988437"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.6608,"has_fulltext":false,"cited_by_count":25,"citation_normalized_percentile":{"value":0.85583825,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"6"},"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.9994000196456909,"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.9994000196456909,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9993000030517578,"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"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9952999949455261,"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.8103593587875366},{"id":"https://openalex.org/keywords/snowflake","display_name":"Snowflake","score":0.7608563303947449},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.6509044766426086},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.5755404829978943},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.569117546081543},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5640640258789062},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.4654812216758728},{"id":"https://openalex.org/keywords/service","display_name":"Service (business)","score":0.45452558994293213},{"id":"https://openalex.org/keywords/container","display_name":"Container (type theory)","score":0.45340460538864136},{"id":"https://openalex.org/keywords/metadata","display_name":"Metadata","score":0.4330001771450043},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.24322670698165894},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.11439061164855957},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.08573907613754272}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8103593587875366},{"id":"https://openalex.org/C54059038","wikidata":"https://www.wikidata.org/wiki/Q550147","display_name":"Snowflake","level":3,"score":0.7608563303947449},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.6509044766426086},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.5755404829978943},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.569117546081543},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5640640258789062},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.4654812216758728},{"id":"https://openalex.org/C2780378061","wikidata":"https://www.wikidata.org/wiki/Q25351891","display_name":"Service (business)","level":2,"score":0.45452558994293213},{"id":"https://openalex.org/C2781018962","wikidata":"https://www.wikidata.org/wiki/Q5164884","display_name":"Container (type theory)","level":2,"score":0.45340460538864136},{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.4330001771450043},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.24322670698165894},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.11439061164855957},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.08573907613754272},{"id":"https://openalex.org/C78519656","wikidata":"https://www.wikidata.org/wiki/Q101333","display_name":"Mechanical engineering","level":1,"score":0.0},{"id":"https://openalex.org/C197046000","wikidata":"https://www.wikidata.org/wiki/Q7561","display_name":"Snow","level":2,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C136264566","wikidata":"https://www.wikidata.org/wiki/Q159810","display_name":"Economy","level":1,"score":0.0},{"id":"https://openalex.org/C153294291","wikidata":"https://www.wikidata.org/wiki/Q25261","display_name":"Meteorology","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3209950.3209958","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3209950.3209958","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Workshop on Testing Database Systems","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.6399999856948853,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W1527501358","https://openalex.org/W2093826418","https://openalex.org/W2169124185","https://openalex.org/W2187089797","https://openalex.org/W2189625117","https://openalex.org/W2430301697","https://openalex.org/W2575917280","https://openalex.org/W2785612209","https://openalex.org/W2857131573","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W2378213774","https://openalex.org/W2357522326","https://openalex.org/W2363019959","https://openalex.org/W1535822977","https://openalex.org/W23190051","https://openalex.org/W2367419170","https://openalex.org/W6138692","https://openalex.org/W2377387014","https://openalex.org/W2382180329","https://openalex.org/W2375394542"],"abstract_inverted_index":{"Database":[0],"as":[1,25,45],"a":[2,28,93,111],"service":[3,31,104],"provided":[4,32],"on":[5],"cloud":[6,29,37],"computing":[7],"platforms":[8],"has":[9],"been":[10],"rapidly":[11],"gaining":[12],"popularity":[13],"in":[14],"recent":[15],"years.":[16],"The":[17,36],"Snowflake":[18,34,46,55,73],"Elastic":[19],"Data":[20],"Warehouse":[21],"(henceforth":[22],"referred":[23],"to":[24,80,88],"Snowflake)":[26],"is":[27,74],"database":[30,42,52],"by":[33],"Computing.":[35],"native":[38],"capabilities":[39],"of":[40,59,100,114],"new":[41,49],"services":[43],"such":[44],"bring":[47],"exciting":[48],"opportunities":[50],"for":[51],"testing.":[53],"First,":[54],"maintains":[56],"extensive":[57],"knowledge":[58],"historical":[60],"customer":[61,90],"queries,":[62],"including":[63],"both":[64],"the":[65,97,118],"query":[66],"text":[67],"and":[68,82],"corresponding":[69],"system":[70],"configurations.":[71],"Second,":[72],"multi-tenant,":[75],"which":[76],"provides":[77],"easy":[78],"access":[79],"metadata":[81],"data":[83,102],"that":[84],"can":[85],"be":[86],"used":[87],"rerun":[89],"queries":[91,109],"from":[92],"privileged":[94],"role.":[95],"Furthermore,":[96],"elastic":[98],"nature":[99],"Snowflake's":[101],"warehouse":[103],"allows":[105],"testing":[106],"with":[107],"these":[108],"using":[110],"separate":[112],"set":[113],"resources":[115],"without":[116],"impacting":[117],"customer's":[119],"production":[120],"workload.":[121]},"counts_by_year":[{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":4},{"year":2022,"cited_by_count":5},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2018-06-13T00:00:00"}