{"id":"W2100235843","doi":"10.5555/1182635.1164146","title":"Relaxing join and selection queries","year":2006,"lang":"en","type":"article","venue":"National University of Singapore","topic":"Data Management and Algorithms","field":"Computer Science","cited_by":95,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Toronto","funders":"","keywords":"Joins; Computer science; Traverse; Query optimization; Theoretical computer science; Relaxation (psychology); Join (topology); Lattice (music); Selection (genetic algorithm); Information retrieval; Data mining; Mathematics; Combinatorics; Machine learning","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.00009123666,0.00002806875,0.00003436602,0.00008066445,0.0001167176,0.00002461565,0.0001123149,0.00001575673,0.000007620805],"category_scores_gemma":[0.000006414773,0.00003438256,0.00001110586,0.0001485797,0.00003614108,0.0005893648,0.00007965569,0.00002802055,0.000002270064],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00002432455,"about_ca_system_score_gemma":0.00002017846,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0001296901,"about_ca_topic_score_gemma":0.00004349259,"domain_scores_codex":[0.9996643,0.000007859306,0.00003561772,0.00009568469,0.0001526766,0.00004384522],"domain_scores_gemma":[0.9998308,0.00001535202,0.00003918761,0.00002756111,0.00007761714,0.000009437704],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"observational","study_design_scores_codex":[0.000004825794,0.00004078533,0.005019847,0.00001445846,0.00001200862,0.000006532012,0.0001570729,0.0001645971,0.0008094828,0.9677135,0.01263304,0.0134239],"study_design_scores_gemma":[0.001631025,0.0001361912,0.4583706,0.0000732574,0.00002638253,0.00003037355,0.0005675244,0.1775815,0.001697956,0.1203758,0.2389967,0.0005126712],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.1677205,0.00008997609,0.7456872,0.003312232,0.000121704,0.0001225918,0.00001752293,0.0001955905,0.08273268],"genre_scores_gemma":[0.9268519,0.000006852325,0.07117795,0.0000244156,0.00002816197,2.164057e-8,0.00001627881,0.000001333657,0.001893075],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.8473377,"threshold_uncertainty_score":0.140208,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.008028305870935474,"score_gpt":0.1763056307184854,"score_spread":0.1682773248475499,"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."}}