{"id":"W2918878758","doi":"10.1007/978-0-387-39940-9_297","title":"Query Processing and Optimization in Object Relational Databases","year":2009,"lang":"en","type":"book-chapter","venue":"Encyclopedia of Database Systems","topic":"Data Management and Algorithms","field":"Computer Science","cited_by":0,"is_retracted":false,"has_abstract":false,"ca_institutions":"University of Waterloo","funders":"","keywords":"Computer science; Query optimization; Database; Relational database; Sargable; Information retrieval; Object (grammar); Artificial intelligence; 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.0005543197,0.000315125,0.0004381977,0.0005161733,0.00006582227,0.000109254,0.0005367793,0.0001000466,0.00001867831],"category_scores_gemma":[0.00005802145,0.0003147887,0.00003905232,0.0001444174,0.00005734306,0.002256306,0.0004815418,0.0002431963,0.00001278616],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00004508733,"about_ca_system_score_gemma":0.000155698,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0001148213,"about_ca_topic_score_gemma":0.00002835225,"domain_scores_codex":[0.9978165,0.00004435984,0.0006916289,0.000695526,0.0005357878,0.0002161818],"domain_scores_gemma":[0.9984447,0.00010189,0.0004960591,0.0008002566,0.00008177073,0.00007531705],"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.000023994,0.0001453295,0.0003838414,0.002054084,0.00008305917,0.000302237,0.0003417908,0.009651566,0.000005645747,0.7880054,0.01446446,0.1845386],"study_design_scores_gemma":[0.0009396317,0.00009645736,0.0002631366,0.004795401,0.00008531765,0.00005068422,0.00004382954,0.319976,0.000003246737,0.0008195624,0.6717406,0.001186105],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.000006732998,0.006521144,0.5428643,0.00008152821,0.0006441035,0.0007527001,0.0009514057,0.0001218111,0.4480563],"genre_scores_gemma":[0.0006395304,0.01869612,0.5346355,0.0001570659,0.001455139,0.00007939881,0.01790919,0.0001464073,0.4262816],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.7871858,"threshold_uncertainty_score":0.9999304,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.0239549014329269,"score_gpt":0.2416569673018848,"score_spread":0.2177020658689579,"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."}}