{"id":"W4301385930","doi":"10.1007/978-3-031-01881-7_5","title":"Query Compilation and Plan Synthesis","year":2011,"lang":"en","type":"book-chapter","venue":"Synthesis lectures on data management","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":0,"is_retracted":false,"has_abstract":false,"ca_institutions":"University of Waterloo","funders":"","keywords":"Computer science; Query optimization; Query language; Sargable; Query plan; Plan (archaeology); Query expansion; Web query classification; Information retrieval; RDF query language; Online aggregation; Web search query; Theoretical computer science; Database; Search engine","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":"codex-gemma-dda1882f352a","candidate_categories":["metaepi_narrow"],"consensus_categories":[],"category_scores_codex":[0.000448812,0.000574344,0.0005716258,0.0003890765,0.0002341262,0.0001639158,0.001860785,0.0001896686,0.0002072506],"category_scores_gemma":[0.00009265257,0.0004946173,0.00007365886,0.00004979356,0.0001142552,0.0006989329,0.002382986,0.0002515025,0.0002184669],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00006593083,"about_ca_system_score_gemma":0.00002387272,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0000315059,"about_ca_topic_score_gemma":0.00006582346,"domain_scores_codex":[0.9971455,0.00006885096,0.0004529491,0.001471839,0.0005206478,0.0003401994],"domain_scores_gemma":[0.9948544,0.0004869607,0.0003543506,0.004150586,0.00003177307,0.000121927],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"not_applicable","study_design_scores_codex":[0.0000242856,0.00001900467,0.000002630572,0.0002194922,0.0002404666,0.0000811205,0.00003663248,0.000007998669,0.000002342664,0.7508445,0.01454731,0.2339742],"study_design_scores_gemma":[0.00007301995,0.00003662668,0.000167226,0.0008588133,0.0001568478,0.00001587716,0.000008426427,0.0002933736,0.0001866831,0.01154798,0.9859808,0.0006743075],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"other","genre_gemma":"methods","genre_scores_codex":[0.000001987987,0.001173001,0.3823387,0.0004267514,0.0005145404,0.0007877872,0.003495523,0.0003528334,0.6109089],"genre_scores_gemma":[0.0190494,0.02213409,0.5218557,0.004941354,0.002214046,0.001077619,0.007301723,0.0009462932,0.4204798],"genre_candidate":"other","genre_consensus":null,"teacher_disagreement_score":0.9714335,"threshold_uncertainty_score":0.9997506,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.06647717028824002,"score_gpt":0.2419019282067119,"score_spread":0.1754247579184719,"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."}}