{"id":"https://openalex.org/W4414266787","doi":"https://doi.org/10.14778/3750601.3750638","title":"SQL:Trek Automated Index Design at Airbnb","display_name":"SQL:Trek Automated Index Design at Airbnb","publication_year":2025,"publication_date":"2025-08-01","ids":{"openalex":"https://openalex.org/W4414266787","doi":"https://doi.org/10.14778/3750601.3750638"},"language":"en","primary_location":{"id":"doi:10.14778/3750601.3750638","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3750601.3750638","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/A5030480168","display_name":"Sam Lightstone","orcid":null},"institutions":[{"id":"https://openalex.org/I1317029613","display_name":"Air Canada","ror":"https://ror.org/00fby7m68","country_code":"CA","type":"company","lineage":["https://openalex.org/I1317029613"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Sam Lightstone","raw_affiliation_strings":["Airbnb, Toronto, Canada"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Airbnb, Toronto, Canada","institution_ids":["https://openalex.org/I1317029613"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100338632","display_name":"Ping Wang","orcid":"https://orcid.org/0000-0002-1557-0394"},"institutions":[{"id":"https://openalex.org/I106110158","display_name":"Bay Area Air Quality Management District","ror":"https://ror.org/04431t173","country_code":"US","type":"government","lineage":["https://openalex.org/I106110158"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ping Wang","raw_affiliation_strings":["Airbnb, San Francisco, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Airbnb, San Francisco, USA","institution_ids":["https://openalex.org/I106110158"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.27519317,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"18","issue":"12","first_page":"5210","last_page":"5222"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9954000115394592,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9954000115394592,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9904999732971191,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9846000075340271,"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/index","display_name":"Index (typography)","score":0.6818000078201294},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.6746000051498413},{"id":"https://openalex.org/keywords/index-selection","display_name":"Index selection","score":0.5396999716758728},{"id":"https://openalex.org/keywords/false-positive-paradox","display_name":"False positive paradox","score":0.46549999713897705},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.4603999853134155},{"id":"https://openalex.org/keywords/database-index","display_name":"Database index","score":0.4246000051498413},{"id":"https://openalex.org/keywords/compiler","display_name":"Compiler","score":0.4212999939918518},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.39309999346733093}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8331000208854675},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.6818000078201294},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.6746000051498413},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5866000056266785},{"id":"https://openalex.org/C2778360486","wikidata":"https://www.wikidata.org/wiki/Q6019110","display_name":"Index selection","level":3,"score":0.5396999716758728},{"id":"https://openalex.org/C64869954","wikidata":"https://www.wikidata.org/wiki/Q1859747","display_name":"False positive paradox","level":2,"score":0.46549999713897705},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.4603999853134155},{"id":"https://openalex.org/C59276292","wikidata":"https://www.wikidata.org/wiki/Q580427","display_name":"Database index","level":3,"score":0.4246000051498413},{"id":"https://openalex.org/C169590947","wikidata":"https://www.wikidata.org/wiki/Q47506","display_name":"Compiler","level":2,"score":0.4212999939918518},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4090000092983246},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.39309999346733093},{"id":"https://openalex.org/C204323151","wikidata":"https://www.wikidata.org/wiki/Q905424","display_name":"Range (aeronautics)","level":2,"score":0.3880999982357025},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.3714999854564667},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.3684000074863434},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.32260000705718994},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.3010999858379364},{"id":"https://openalex.org/C2778348673","wikidata":"https://www.wikidata.org/wiki/Q739302","display_name":"Production (economics)","level":2,"score":0.27869999408721924},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.2786000072956085},{"id":"https://openalex.org/C2989134064","wikidata":"https://www.wikidata.org/wiki/Q288510","display_name":"Execution time","level":2,"score":0.27149999141693115},{"id":"https://openalex.org/C2775973920","wikidata":"https://www.wikidata.org/wiki/Q3252726","display_name":"Selection algorithm","level":3,"score":0.2551000118255615},{"id":"https://openalex.org/C19012869","wikidata":"https://www.wikidata.org/wiki/Q578372","display_name":"Response time","level":2,"score":0.2547999918460846}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3750601.3750638","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3750601.3750638","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":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":13,"referenced_works":["https://openalex.org/W1521464082","https://openalex.org/W1576035775","https://openalex.org/W2047085757","https://openalex.org/W2168503413","https://openalex.org/W2240667924","https://openalex.org/W2396309311","https://openalex.org/W2918549777","https://openalex.org/W2944240329","https://openalex.org/W2950480046","https://openalex.org/W2968223482","https://openalex.org/W3021961968","https://openalex.org/W4210634541","https://openalex.org/W4385270589"],"related_works":[],"abstract_inverted_index":{"Automating":[0],"index":[1,70,105,139,171,188],"design":[2,71],"has":[3],"been":[4],"an":[5,76],"active":[6],"area":[7],"of":[8,161,169],"research":[9],"for":[10,56,68,186],"decades":[11],"due":[12],"to":[13,32,85],"the":[14,54,167],"significant":[15,133],"impact":[16],"that":[17,72,130],"indexes":[18,88],"have":[19],"on":[20,49,95],"query":[21,81,134],"performance":[22,135,160],"and":[23,122],"database":[24,60,109,192],"efficiency.":[25],"Existing":[26],"approaches":[27],"range":[28],"from":[29,44],"brute-force":[30],"search":[31],"cost-based":[33,153],"optimizations":[34],"and,":[35],"more":[36],"recently,":[37],"machine":[38],"learning":[39],"techniques.":[40],"However,":[41],"many":[42,152,162],"suffer":[43],"high":[45],"computational":[46],"costs,":[47],"reliance":[48],"inaccurate":[50],"cost":[51,83],"models,":[52],"or":[53],"need":[55],"deep":[57],"integration":[58],"with":[59,143],"internals.":[61],"We":[62],"introduce":[63],"SQL:Trek,":[64],"a":[65,96,182],"time-efficient":[66],"tool":[67],"automated":[69,187],"operates":[73],"entirely":[74],"as":[75,181],"external":[77],"utility.":[78],"SQL:Trek":[79,131,157,180],"leverages":[80],"compiler":[82],"models":[84],"identify":[86],"effective":[87],"while":[89,137,165],"mitigating":[90],"false":[91],"positives":[92],"through":[93],"execution":[94],"lightweight":[97],"simulation":[98],"database.":[99],"This":[100],"approach":[101],"enables":[102],"fast,":[103],"iterative":[104],"selection":[106,140],"without":[107],"modifying":[108],"internals,":[110],"making":[111],"it":[112],"broadly":[113],"applicable":[114],"across":[115],"relational":[116],"databases,":[117],"including":[118],"most":[119,144],"MySQL":[120],"\u00ae":[121,124],"PostgreSQL":[123],"derivative":[125],"databases.":[126],"Our":[127],"evaluation":[128],"demonstrates":[129],"delivers":[132],"improvements":[136],"keeping":[138],"computationally":[141],"efficient,":[142],"workloads":[145,164],"analyzed":[146],"in":[147,190],"under":[148],"five":[149],"minutes.":[150],"Unlike":[151],"what-if":[154],"analysis":[155],"methods,":[156],"significantly":[158],"improved":[159],"production":[163],"avoiding":[166],"majority":[168],"detrimental":[170],"recommendations":[172],"caused":[173],"by":[174],"optimizer":[175],"misestimates.":[176],"These":[177],"results":[178],"highlight":[179],"practical,":[183],"scalable":[184],"solution":[185],"tuning":[189],"modern":[191],"environments.":[193]},"counts_by_year":[],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}