{"id":"W2027088687","doi":"10.5539/cis.v2n1p115","title":"A Study On Query Optimization for Federated Database Systems","year":2009,"lang":"en","type":"article","venue":"Computer and Information Science","topic":"Data Management and Algorithms","field":"Computer Science","cited_by":3,"is_retracted":false,"has_abstract":true,"ca_institutions":"","funders":"","keywords":"Computer science; Query optimization; Database; Information retrieval; View; Sargable; Web search query; Database design; Search engine","routes":{"ca_aff":false,"ca_fund":false,"ca_venue":true,"about_ca":false,"invisible_to_affiliation_only":true},"retraction":null,"screen":null,"direct_labels":[],"prediction":{"model_version":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.008437186,0.001037853,0.002460959,0.001637506,0.001754776,0.005348294,0.003015141,0.001399565,0.004656544],"category_scores_gemma":[0.03255176,0.000853872,0.001671945,0.006721522,0.001492119,0.00909132,0.001667577,0.002219962,0.0004794494],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.003534675,"about_ca_system_score_gemma":0.003529152,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.01253933,"about_ca_topic_score_gemma":0.005165342,"domain_scores_codex":[0.9843768,0.006568215,0.0009868317,0.001921647,0.004720384,0.001426083],"domain_scores_gemma":[0.9799586,0.01384475,0.0006187497,0.003133141,0.00207255,0.0003722784],"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.001755689,0.001151594,0.009437332,0.001341634,0.0004797977,0.0004383163,0.001166924,0.4101875,0.007502936,0.2105685,0.01605758,0.3399122],"study_design_scores_gemma":[0.00006688019,0.0001780693,0.001214827,0.0000486105,0.0001266405,0.0002448609,0.0004256307,0.9493698,0.003448793,0.0397509,0.005099687,0.00002531499],"study_design_candidate":"simulation_or_modeling","study_design_consensus":"simulation_or_modeling","genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.235723,0.01171055,0.7225605,0.004188055,0.0003092319,0.0006159436,0.0008465866,0.002573933,0.02147224],"genre_scores_gemma":[0.7581173,0.002478379,0.2304017,0.0004491603,0.0002624177,0.0001912727,0.00105504,0.0006105523,0.006434106],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.01253933,"threshold_uncertainty_score":0.04462063,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.02732586993840915,"score_gpt":0.276357045068118,"score_spread":0.2490311751297088,"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."}}