{"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":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.0002975694,0.0001266195,0.0001767321,0.0000958784,0.00006994043,0.00002672136,0.000635638,0.00001726217,0.00001380624],"category_scores_gemma":[0.00003356306,0.0001005225,0.00002053263,0.0001140304,0.0000579916,0.0005733854,0.0007489094,0.00004110246,0.00001233679],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00001393918,"about_ca_system_score_gemma":0.000006132509,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0000301746,"about_ca_topic_score_gemma":0.000003756535,"domain_scores_codex":[0.9989496,0.000101164,0.0001650699,0.0004270757,0.0002140959,0.0001429419],"domain_scores_gemma":[0.9983792,0.0001679323,0.0001054161,0.001295696,0.00001305629,0.0000386888],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"bench_or_experimental","study_design_scores_codex":[0.00009210862,0.0003314907,0.0001158509,0.0002240513,0.000196582,0.00002651503,0.0008004664,0.0003236365,0.001102854,0.7176191,0.003296036,0.2758713],"study_design_scores_gemma":[0.002095762,0.001864879,0.06022419,0.00179882,0.0005036413,0.00004259442,0.0009987488,0.2222789,0.4085772,0.04160923,0.2569854,0.003020616],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.001756682,0.00007225004,0.9953036,0.00005947303,0.0000663637,0.0003111268,0.00009327106,0.0000577279,0.002279489],"genre_scores_gemma":[0.6812433,0.00003726876,0.31849,0.0001053824,0.00002431711,0.00003133704,0.00002948622,0.000008949258,0.00003001751],"genre_candidate":"methods","genre_consensus":null,"teacher_disagreement_score":0.6794866,"threshold_uncertainty_score":0.4099191,"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."}}