{"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":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.0002135886,0.00007621796,0.00008455035,0.0001227032,0.00004421522,0.0001232624,0.0004737813,0.00001995068,0.00000203932],"category_scores_gemma":[0.000009851845,0.00006744658,0.0000102284,0.0002623868,0.000009359183,0.002172948,0.00016035,0.00003372319,0.000005788884],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00004433067,"about_ca_system_score_gemma":0.00001926384,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00008622488,"about_ca_topic_score_gemma":0.000007611849,"domain_scores_codex":[0.9993278,0.000007309994,0.0001560311,0.0002432618,0.0001054884,0.0001600889],"domain_scores_gemma":[0.9995216,0.0000135253,0.00004245865,0.000368679,0.00003164646,0.0000220717],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.00001489706,0.0001616023,0.0001347104,0.0002179047,0.000008321465,0.000008958739,0.00006603894,0.3660493,0.0002604259,0.5041557,0.0008360707,0.1280861],"study_design_scores_gemma":[0.0007189007,0.0001171183,0.0001187196,0.0001209003,0.000002318849,0.000001899165,0.00002505203,0.9886515,0.006911019,0.0004933153,0.002622767,0.0002164977],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.001455198,0.00002741436,0.9963555,0.0002480223,0.0002132824,0.0004694378,0.000007670974,0.0002543582,0.0009690954],"genre_scores_gemma":[0.1632099,0.00009035543,0.8359001,0.000124491,0.0000368956,0.0001440998,0.000088251,0.000005981992,0.0003999268],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.6226022,"threshold_uncertainty_score":0.2750392,"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."}}