{"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":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.003856645,0.0001260537,0.0002134087,0.0001463361,0.0001617881,0.0004400091,0.001418007,0.00004111492,0.0008855336],"category_scores_gemma":[0.001758456,0.00009404742,0.00002534918,0.0002678238,0.0001180869,0.002311572,0.002198617,0.00007824468,0.0004176799],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00001094035,"about_ca_system_score_gemma":0.0000240456,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00003720919,"about_ca_topic_score_gemma":0.0001823869,"domain_scores_codex":[0.997833,0.0001688038,0.0004116658,0.0006506177,0.0006721424,0.0002638179],"domain_scores_gemma":[0.9972637,0.0004654627,0.0001218718,0.002003961,0.00005401519,0.00009098494],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"not_applicable","study_design_gemma":"not_applicable","study_design_scores_codex":[0.00001416099,0.0001302958,0.0005217004,0.00001256216,0.00001253064,0.00001040675,0.00008042766,4.638468e-7,0.00009157779,0.01568962,0.8023581,0.1810782],"study_design_scores_gemma":[0.0001752135,0.00002317092,0.0004111849,0.00001660637,0.00001178612,0.000004337811,0.0004267237,0.001060392,0.001178982,0.001975029,0.9945806,0.0001360034],"study_design_candidate":"not_applicable","study_design_consensus":"not_applicable","genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.2004807,0.01323976,0.4310565,0.04598019,0.002408485,0.004996289,0.1685955,0.003369529,0.129873],"genre_scores_gemma":[0.8628125,0.002198087,0.09010569,0.02685067,0.001046362,0.00008473015,0.008422949,0.00005652888,0.00842254],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.6623317,"threshold_uncertainty_score":0.9695972,"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."}}