{"id":"W7106824301","doi":"10.48448/aacw-wm35","title":"QuackIR: Retrieval in DuckDB and Other Relational Database Management Systems","year":2025,"lang":"","type":"other","venue":"Open MIND","topic":"","field":"","cited_by":0,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Waterloo","funders":"","keywords":"Relational database; Leverage (statistics); Relational database management system; Data retrieval; Benchmark (surveying); Database design; Relational model; Database model","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.008223951,0.001207324,0.001225875,0.003101765,0.001962277,0.006071076,0.005265696,0.001660109,0.01271151],"category_scores_gemma":[0.01844257,0.001290442,0.0009627925,0.004302287,0.001405702,0.009822433,0.006099941,0.002097446,0.01223662],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.002552195,"about_ca_system_score_gemma":0.003746188,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0501455,"about_ca_topic_score_gemma":0.03932163,"domain_scores_codex":[0.991484,0.001756872,0.001136873,0.001446037,0.003589338,0.0005868524],"domain_scores_gemma":[0.9919444,0.001827321,0.0004124647,0.003563231,0.001753484,0.0004990333],"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.002638508,0.0009118587,0.006047882,0.002575512,0.0003690333,0.0008301563,0.001794789,0.01211146,0.02167598,0.0529612,0.499989,0.3980946],"study_design_scores_gemma":[0.0008193537,0.0006383617,0.005880693,0.0003716221,0.0001777104,0.001347656,0.001323532,0.184824,0.06685065,0.03957755,0.6976054,0.0005834592],"study_design_candidate":"not_applicable","study_design_consensus":"not_applicable","genre_codex":"software","genre_gemma":"software","genre_scores_codex":[0.04592514,0.00904384,0.3696438,0.003503618,0.0009113021,0.001882125,0.03641166,0.4864958,0.04618271],"genre_scores_gemma":[0.2198906,0.002298401,0.620463,0.002758433,0.0001721194,0.000815033,0.1072268,0.01923933,0.02713629],"genre_candidate":"software","genre_consensus":"software","teacher_disagreement_score":0.0501455,"threshold_uncertainty_score":0.09970725,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.06124864814948414,"score_gpt":0.3323211774183939,"score_spread":0.2710725292689098,"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."}}