{"id":"W4414266787","doi":"10.14778/3750601.3750638","title":"SQL:Trek Automated Index Design at Airbnb","year":2025,"lang":"en","type":"article","venue":"Proceedings of the VLDB Endowment","topic":"Data Management and Algorithms","field":"Computer Science","cited_by":0,"is_retracted":false,"has_abstract":true,"ca_institutions":"Air Canada","funders":"","keywords":"Index (typography); Scalability; Index selection; False positive paradox; Selection (genetic algorithm); Database index; Compiler; Relational database","routes":{"ca_aff":true,"ca_fund":false,"ca_venue":false,"about_ca":false,"invisible_to_affiliation_only":false},"retraction":null,"screen":null,"direct_labels":[],"prediction":{"model_version":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.005140516,0.001712404,0.001288316,0.001398985,0.0007947845,0.004414225,0.004071147,0.001033218,0.01579102],"category_scores_gemma":[0.0140425,0.001362544,0.001225554,0.001549544,0.001143962,0.00534754,0.002624885,0.002267918,0.01114941],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001654392,"about_ca_system_score_gemma":0.003537254,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.004667907,"about_ca_topic_score_gemma":0.004255686,"domain_scores_codex":[0.9940971,0.001072018,0.0004851145,0.001119502,0.002713274,0.0005128666],"domain_scores_gemma":[0.9927532,0.002070603,0.0003971853,0.002491547,0.001919547,0.0003679289],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.005073494,0.0009184523,0.01145667,0.001388205,0.0003993067,0.000753646,0.0008504938,0.05167148,0.09659583,0.02289318,0.3326831,0.4753162],"study_design_scores_gemma":[0.0008313333,0.0006937878,0.003599538,0.0001162823,0.00008495302,0.0005101602,0.0002034036,0.7817953,0.09665499,0.01593696,0.09936646,0.0002068433],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"software","genre_gemma":"empirical","genre_scores_codex":[0.04632236,0.001137004,0.3839169,0.0005869854,0.0003639922,0.0005246637,0.004940564,0.5482848,0.01392265],"genre_scores_gemma":[0.361954,0.0006819779,0.5415967,0.0009752258,0.000193841,0.0006050255,0.02736305,0.0521738,0.01445652],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.01579102,"threshold_uncertainty_score":0.05282623,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.01118379359232271,"score_gpt":0.2298920848846669,"score_spread":0.2187082912923442,"validation_status":"score_only:v0-immature-baseline","note":"Baseline scores from an immature model (maturity gate not passed). Scores rank; they never assert a category."}}