{"id":"W1819934925","doi":"10.7302/24323","title":"Query optimization in multidatabase systems","year":2024,"lang":"en","type":"article","venue":"Deep Blue (University of Michigan)","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":28,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Waterloo","funders":"","keywords":"Query optimization; Computer science; Sargable; Query expansion; Query language; Web search query; View; Query by Example; Distributed database; Online aggregation; Database; RDF query language; Web query classification; Information retrieval; Distributed computing; Data mining; Search engine; Database design","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.0001743023,0.00009059752,0.0001569205,0.000233992,0.0000654967,0.00002585026,0.0002937313,0.00004608348,0.00001313344],"category_scores_gemma":[0.00001132431,0.0001064463,0.00004397308,0.000457035,0.00004795866,0.001232702,0.0001939982,0.00009823271,0.00004098814],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0000305694,"about_ca_system_score_gemma":0.00005128892,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0006366199,"about_ca_topic_score_gemma":0.00651634,"domain_scores_codex":[0.9992388,0.00005537588,0.0001193244,0.0002985481,0.0001395535,0.0001484176],"domain_scores_gemma":[0.9994425,0.00005822417,0.00005225158,0.0003536449,0.00004139135,0.00005198461],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"simulation_or_modeling","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.00003623004,0.0001290097,0.0001040639,0.0008387439,0.0000757273,0.001028271,0.09154071,0.5171024,0.002355149,0.3801089,0.0002276037,0.006453183],"study_design_scores_gemma":[0.0002436068,0.00001955585,0.00006393144,0.0002460823,0.000006343432,0.00001925982,0.0130852,0.9679884,0.000107011,0.00001860675,0.01805015,0.0001518635],"study_design_candidate":"simulation_or_modeling","study_design_consensus":"simulation_or_modeling","genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.1197818,0.0009456081,0.8782707,0.00007889645,0.0003698536,0.0001179344,0.00004339792,0.0001193891,0.0002723787],"genre_scores_gemma":[0.6772762,0.0002467274,0.3211173,0.00002954718,0.00006318527,9.980084e-7,0.0001065869,0.00001718938,0.001142262],"genre_candidate":"methods","genre_consensus":null,"teacher_disagreement_score":0.5574943,"threshold_uncertainty_score":0.4340756,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.00728528310605132,"score_gpt":0.1919368438286114,"score_spread":0.1846515607225601,"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."}}