{"id":"W2522191305","doi":"","title":"Advanced techniques for high performance query optimization in database systems","year":2004,"lang":"en","type":"article","venue":"","topic":"Data Management and Algorithms","field":"Computer Science","cited_by":0,"is_retracted":false,"has_abstract":true,"ca_institutions":"York University","funders":"","keywords":"Computer science; Query optimization; Scalability; Skyline; Online aggregation; View; Data mining; Materialized view; Cardinality (data modeling); Join (topology); Web query classification; Database; Sargable; Query plan; Query language; Key (lock); Task (project management); Query expansion; Result set; Information retrieval; Set (abstract data type); Web search query; Database design; 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.006269861,0.002933229,0.002663881,0.003250949,0.001452502,0.005808198,0.003890034,0.001766488,0.007393727],"category_scores_gemma":[0.01641727,0.001649522,0.002845072,0.007785202,0.002356034,0.00894814,0.00469596,0.006688677,0.004100735],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.002698853,"about_ca_system_score_gemma":0.002093841,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.003039547,"about_ca_topic_score_gemma":0.00243418,"domain_scores_codex":[0.9876834,0.00306017,0.00119794,0.001265042,0.006205306,0.0005882435],"domain_scores_gemma":[0.9922901,0.003452426,0.0004487399,0.002633906,0.001035239,0.0001394951],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.0004609356,0.0002558326,0.001291926,0.001239099,0.0002759623,0.0002181836,0.0006017415,0.114632,0.011143,0.4041758,0.03384331,0.4318621],"study_design_scores_gemma":[0.0001162669,0.0001494199,0.0003855198,0.0001215326,0.00006825932,0.0002379558,0.0001182009,0.6408862,0.005752907,0.3083103,0.04379548,0.00005798135],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.001807918,0.00218176,0.9905571,0.000753945,0.0001113877,0.0001648174,0.0002341333,0.001841332,0.002347696],"genre_scores_gemma":[0.06627021,0.003829615,0.9220565,0.000466238,0.0005918798,0.0008531723,0.001110374,0.0006002401,0.004221824],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.007393727,"threshold_uncertainty_score":0.0331586,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.01202378458636421,"score_gpt":0.2380083851690474,"score_spread":0.2259846005826832,"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."}}