{"id":"W2108075439","doi":"","title":"Approximate joins: concepts and techniques","year":2005,"lang":"en","type":"article","venue":"Very Large Data Bases","topic":"Data Quality and Management","field":"Decision Sciences","cited_by":29,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Toronto","funders":"","keywords":"Joins; Multitude; Computer science; Database; Quality (philosophy); Data quality; Character (mathematics); Service (business); Relational database; Missing data; Data science; Data mining; World Wide Web; Business; Marketing","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.006040103,0.00137238,0.001788235,0.005530413,0.002078511,0.007529389,0.004463063,0.002123612,0.007152562],"category_scores_gemma":[0.01431196,0.001345527,0.002086507,0.01196514,0.003817465,0.01411243,0.006193004,0.003942075,0.003818381],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001649705,"about_ca_system_score_gemma":0.001604082,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.001865614,"about_ca_topic_score_gemma":0.001032387,"domain_scores_codex":[0.9927654,0.001666073,0.0006580524,0.001411758,0.003171111,0.0003276386],"domain_scores_gemma":[0.994006,0.003192716,0.0005770659,0.001216381,0.000822228,0.0001855755],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"theoretical_or_conceptual","study_design_scores_codex":[0.00008230271,0.00005709942,0.0006265952,0.0005938731,0.00009858916,0.0001568789,0.0006541516,0.01140397,0.0007031186,0.8232879,0.01116253,0.151173],"study_design_scores_gemma":[0.00001921954,0.00004485867,0.0001972327,0.0001340253,0.00005167186,0.000463908,0.0001446096,0.02946806,0.0007158418,0.9121346,0.05660031,0.00002572359],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":"theoretical_or_conceptual","genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.002688452,0.01004041,0.9739386,0.0007543589,0.0002603334,0.0001092527,0.0003528027,0.0007315455,0.01112419],"genre_scores_gemma":[0.09598676,0.01611122,0.8736335,0.0006923281,0.002030222,0.0004926331,0.001382469,0.0004471985,0.009223702],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.007529389,"threshold_uncertainty_score":0.03194344,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.2365840025725053,"score_gpt":0.4607702635409333,"score_spread":0.224186260968428,"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."}}