{"id":"W2019933064","doi":"10.2200/s00363ed1v01y201105dtm018","title":"Fundamentals of Physical Design and Query Compilation","year":2011,"lang":"en","type":"article","venue":"Synthesis lectures on data management","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":29,"is_retracted":false,"has_abstract":false,"ca_institutions":"University of Waterloo","funders":"National Institute of Informatics","keywords":"Computer science; Query optimization; Information retrieval","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.001422112,0.001496685,0.000982614,0.001087554,0.0007895465,0.004520024,0.002153899,0.001157958,0.01608396],"category_scores_gemma":[0.004554764,0.001253599,0.001059538,0.001789478,0.002445603,0.004320087,0.001343253,0.002577258,0.005928399],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001880155,"about_ca_system_score_gemma":0.001883415,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.001775311,"about_ca_topic_score_gemma":0.001451489,"domain_scores_codex":[0.9983286,0.0002421307,0.0001188488,0.0002969037,0.0008739234,0.0001395024],"domain_scores_gemma":[0.9986564,0.0005766683,0.00006952296,0.0003407844,0.0003090922,0.0000475554],"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.00007274147,0.00006783795,0.0002506881,0.0006314187,0.00004343575,0.00006120098,0.0002261512,0.01719327,0.004863184,0.6680764,0.03025871,0.2782549],"study_design_scores_gemma":[0.00005320268,0.00006249247,0.0004274371,0.0002411998,0.00005689858,0.0002391682,0.00008014586,0.06763911,0.007044692,0.6951364,0.2289696,0.0000497192],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.001517181,0.00714461,0.9602653,0.00121733,0.0007855681,0.00006543807,0.0001561899,0.001681822,0.02716666],"genre_scores_gemma":[0.1532607,0.01880754,0.7662249,0.0008731135,0.002038915,0.0007134253,0.0007022375,0.00139086,0.05598826],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.01608396,"threshold_uncertainty_score":0.05380619,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.09803155566453071,"score_gpt":0.2776241855349245,"score_spread":0.1795926298703938,"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."}}