{"id":"W4300907083","doi":"10.1007/978-3-031-01881-7_3","title":"Basic Physical Design and Query Plans","year":2011,"lang":"en","type":"book-chapter","venue":"Synthesis lectures on data management","topic":"Teaching and Learning Programming","field":"Computer Science","cited_by":0,"is_retracted":false,"has_abstract":false,"ca_institutions":"University of Waterloo","funders":"","keywords":"Computer science; Query plan; Focus (optics); Plan (archaeology); Simple (philosophy); Query language; Data structure; Query optimization; Hash function; Theoretical computer science; Information retrieval; Database; Sargable; Programming language; Web search query; 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.0006934286,0.0004500989,0.0003826513,0.0002687029,0.0002130792,0.0003577789,0.00271559,0.0001404336,0.00003634411],"category_scores_gemma":[0.00006353735,0.000383124,0.00007605542,0.00003662662,0.00007657597,0.000222071,0.001645895,0.0005638957,0.0001820078],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00004133102,"about_ca_system_score_gemma":0.00002040476,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0000268366,"about_ca_topic_score_gemma":0.000005509638,"domain_scores_codex":[0.9975966,0.00013518,0.000204323,0.001289397,0.0004243492,0.0003501719],"domain_scores_gemma":[0.996474,0.0004596208,0.0001687455,0.002780997,0.00001170966,0.000104874],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"not_applicable","study_design_scores_codex":[0.00001526933,0.00003793893,6.526019e-7,0.00007133884,0.0002107001,0.00008286974,0.0001870556,0.00005146549,5.495341e-7,0.2132548,0.008318517,0.7777689],"study_design_scores_gemma":[0.00009012371,0.000116626,0.00005689631,0.0003843094,0.0001813352,0.000009599366,0.000003917119,0.00157704,0.00002844272,0.01026702,0.9867296,0.0005551042],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.000008154966,0.0004217618,0.8408082,0.0006273117,0.0003501204,0.0006720217,0.00005438827,0.0006614648,0.1563966],"genre_scores_gemma":[0.06430703,0.001458406,0.6296495,0.002892226,0.001537372,0.0002869195,0.0004205356,0.00055827,0.2988897],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.9784111,"threshold_uncertainty_score":0.9998621,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.0706653485221524,"score_gpt":0.2565631928402627,"score_spread":0.1858978443181104,"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."}}