{"id":"W2953181121","doi":"10.1145/3140587.3062348","title":"HoTTSQL: proving query rewrites with univalent SQL semantics","year":2017,"lang":"en","type":"article","venue":"ACM SIGPLAN Notices","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":23,"is_retracted":false,"has_abstract":true,"ca_institutions":"","funders":"Defense Advanced Research Projects Agency; Alberta Innovates - Technology Futures; U.S. Department of Energy; National Science Foundation","keywords":"Computer science; SQL; Query optimization; Programming language; Query language; Conjunctive query; Query by Example; Sargable; Spatial query; Undecidable problem; Tuple; Null (SQL); Database; Theoretical computer science; Decidability; Relational database; Information retrieval; Web search query; Mathematics; Discrete mathematics","routes":{"ca_aff":false,"ca_fund":true,"ca_venue":false,"about_ca":false,"invisible_to_affiliation_only":true},"retraction":null,"screen":null,"direct_labels":[],"prediction":{"model_version":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.009966806,0.001497313,0.001394484,0.002097997,0.001874078,0.006338528,0.005300167,0.002187614,0.006644669],"category_scores_gemma":[0.04017539,0.001990314,0.005073568,0.001484471,0.00589394,0.01122616,0.007248421,0.005280179,0.001451409],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00287519,"about_ca_system_score_gemma":0.005983519,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.01039719,"about_ca_topic_score_gemma":0.008623196,"domain_scores_codex":[0.9815261,0.004241802,0.00194874,0.002581471,0.007929556,0.001772268],"domain_scores_gemma":[0.9595309,0.02600263,0.00188642,0.006946812,0.005128226,0.0005049972],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"theoretical_or_conceptual","study_design_scores_codex":[0.0005283144,0.0005880921,0.01127865,0.001615417,0.0006290841,0.001826773,0.002359798,0.08672984,0.03441773,0.7038888,0.02181356,0.1343239],"study_design_scores_gemma":[0.0002660011,0.0002702359,0.001560836,0.0002352458,0.0004147802,0.0007677229,0.0006905482,0.4555072,0.08311863,0.4349579,0.02201672,0.0001941127],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":"theoretical_or_conceptual","genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.01586992,0.0001736149,0.9686193,0.0006523689,0.0001363578,0.0001757888,0.0006925925,0.0108924,0.002787543],"genre_scores_gemma":[0.4024791,0.0004757826,0.5827797,0.002104458,0.0004504315,0.0004763247,0.003611349,0.003842208,0.00378061],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.01039719,"threshold_uncertainty_score":0.05271012,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.02599575075013483,"score_gpt":0.2683679918576917,"score_spread":0.2423722411075568,"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."}}