{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.002213042,0.001036477,0.001901124,0.00114603,0.000670568,0.005079128,0.002908738,0.001064293,0.005666837],"category_scores_gemma":[0.005574837,0.0009059962,0.0009584069,0.0051755,0.001753598,0.005678536,0.001691638,0.002183389,0.002412478],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001430796,"about_ca_system_score_gemma":0.001406423,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00381359,"about_ca_topic_score_gemma":0.002667967,"domain_scores_codex":[0.9963826,0.0007070508,0.0003146184,0.0003870463,0.002045371,0.0001633275],"domain_scores_gemma":[0.9985164,0.0009007478,0.00005969672,0.00028926,0.0001977622,0.00003609646],"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.0001650259,0.000168699,0.0006334689,0.001237581,0.0001077115,0.0001741854,0.000456341,0.0449909,0.003282666,0.3328542,0.05456661,0.5613626],"study_design_scores_gemma":[0.00005434049,0.00008798422,0.0008001876,0.0002173804,0.00009794049,0.0004517227,0.0002210029,0.3019513,0.00468086,0.5526935,0.1386801,0.00006366937],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"other","genre_scores_codex":[0.00709327,0.04054554,0.9244781,0.00150765,0.0004412284,0.0001288688,0.0003954743,0.001697531,0.02371238],"genre_scores_gemma":[0.1060825,0.03619816,0.8117274,0.0006793482,0.001430655,0.0003191677,0.001977911,0.0009256956,0.04065921],"genre_candidate":"other","genre_consensus":null,"teacher_disagreement_score":0.005666837,"threshold_uncertainty_score":0.01895744,"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."}}