{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.001001616,0.001302042,0.0007475206,0.0007861906,0.001093782,0.004202657,0.002254243,0.00111161,0.06336083],"category_scores_gemma":[0.002635602,0.001567093,0.0009340695,0.001416499,0.001812538,0.004898593,0.001493341,0.002136017,0.02247333],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001085495,"about_ca_system_score_gemma":0.001649884,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.002215699,"about_ca_topic_score_gemma":0.001760958,"domain_scores_codex":[0.998962,0.0001005929,0.00009700274,0.0002014301,0.000563197,0.00007572686],"domain_scores_gemma":[0.9994627,0.0001600579,0.00001982251,0.0001895607,0.000141269,0.00002658322],"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.00009222525,0.00007275385,0.0001520108,0.0005417009,0.00001616836,0.00008614705,0.0004373234,0.005796873,0.007980575,0.7433541,0.04284227,0.1986279],"study_design_scores_gemma":[0.00004282895,0.00005270252,0.0002644532,0.0001491036,0.0000272241,0.000293121,0.0001460001,0.02148804,0.007884061,0.464699,0.5049152,0.00003829407],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.001933493,0.001108355,0.8509762,0.0009607124,0.0002603778,0.000490803,0.001650039,0.004290029,0.13833],"genre_scores_gemma":[0.05604055,0.003096788,0.7012144,0.0004560489,0.0002464048,0.001368282,0.005084841,0.002440391,0.2300522],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.06336083,"threshold_uncertainty_score":0.2119631,"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."}}