{"id":"W2211823484","doi":"10.1109/icde.1994.283003","title":"Exploiting uniqueness in query optimization","year":2002,"lang":"en","type":"article","venue":"","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":29,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Waterloo","funders":"","keywords":"Query optimization; Computer science; Uniqueness; Sargable; Query language; Web search query; Information retrieval; Mathematics; 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.00009395588,0.00005151438,0.0000661485,0.00006179441,0.00003600854,0.00002369076,0.0001266946,0.00001806382,0.00006282283],"category_scores_gemma":[0.0000223443,0.00004568572,0.00001075228,0.0002503757,0.000009020715,0.00101992,0.00007750782,0.00003623714,0.00002006943],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00001899426,"about_ca_system_score_gemma":0.00000478112,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00006903463,"about_ca_topic_score_gemma":0.00003104473,"domain_scores_codex":[0.9994878,0.00002877561,0.0001320739,0.0001585642,0.00007401509,0.0001187896],"domain_scores_gemma":[0.9996687,0.00002750447,0.0000296144,0.0002285296,0.00002121319,0.00002450213],"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":[7.192479e-7,0.00003750738,0.0007969567,0.00001638009,0.000001678644,0.00003145601,0.0007005836,0.1490844,0.0001950332,0.8221201,0.0003820682,0.02663313],"study_design_scores_gemma":[0.000128963,0.000009298729,0.00006710929,0.0000318393,2.168918e-7,0.000009669107,0.0001136702,0.9921671,0.001060084,0.0002083206,0.006086945,0.000116858],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.001378532,0.00006319227,0.9879023,0.0002081561,0.0000849613,0.00005309208,5.253127e-7,0.0001265916,0.01018258],"genre_scores_gemma":[0.1875314,0.00004473541,0.81127,0.0002322866,0.0000299706,0.00001875778,0.000002479197,0.000005458378,0.0008649156],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.8430826,"threshold_uncertainty_score":0.1863009,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.02719003291806306,"score_gpt":0.2186161833753887,"score_spread":0.1914261504573256,"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."}}