{"id":"W2143682328","doi":"10.1007/s00778-004-0128-2","title":"Supporting top-k join queries in relational databases","year":2004,"lang":"en","type":"article","venue":"The VLDB Journal","topic":"Data Management and Algorithms","field":"Computer Science","cited_by":387,"is_retracted":false,"has_abstract":false,"ca_institutions":"University of Waterloo","funders":"","keywords":"Joins; Computer science; Join (topology); Sort-merge join; Query optimization; Ranking (information retrieval); Hash join; Database; Relational database; Heuristic; Query language; Sargable; Information retrieval; Rank (graph theory); Heuristics; Relational algebra; Query expansion; Theoretical computer science; Web search query; Search engine; Programming language; Mathematics; Artificial intelligence","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.000942455,0.0000639756,0.0000673653,0.00009654262,0.00020542,0.0002267427,0.0006272252,0.000009518862,0.00005282147],"category_scores_gemma":[0.00007608397,0.0000422743,0.0000299244,0.0002441867,0.00003421716,0.001437122,0.0002795435,0.0002170816,0.00004982662],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00003481286,"about_ca_system_score_gemma":0.00007023131,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0000367678,"about_ca_topic_score_gemma":0.0000262904,"domain_scores_codex":[0.9991531,0.00004155225,0.0002306436,0.0001125839,0.0002492864,0.0002128277],"domain_scores_gemma":[0.9995353,0.00004372435,0.0001168578,0.0002441402,0.00002114298,0.0000387867],"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.00001151408,0.0001209135,0.01438272,0.000009410037,0.00003461154,0.0004154485,0.002238633,0.004176923,0.000236198,0.8991257,0.008121914,0.07112599],"study_design_scores_gemma":[0.004895445,0.0002619804,0.2190561,0.0004689346,0.00004181938,0.002477039,0.001827708,0.03179492,0.003169,0.4493948,0.2854472,0.001164986],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":"theoretical_or_conceptual","genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.08592413,0.000247782,0.8941901,0.01591039,0.000657874,0.00009341004,0.000006407854,0.00005626861,0.002913599],"genre_scores_gemma":[0.7763634,0.0001651284,0.2193082,0.001698347,0.0008088802,0.000005820883,0.00002283884,0.00001440199,0.001613016],"genre_candidate":"methods","genre_consensus":null,"teacher_disagreement_score":0.6904392,"threshold_uncertainty_score":0.2186486,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.04003804845750331,"score_gpt":0.2958259358899701,"score_spread":0.2557878874324668,"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."}}