{"id":"W4416037522","doi":"10.18653/v1/2025.emnlp-industry.33","title":"QuackIR: Retrieval in DuckDB and Other Relational Database Management Systems","year":2025,"lang":"","type":"article","venue":"","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":1,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Waterloo","funders":"Natural Sciences and Engineering Research Council of Canada","keywords":"Relational database; Data retrieval; Entity–relationship model; Database design; Information system; Data management; Relational database management system; Relational model","routes":{"ca_aff":true,"ca_fund":true,"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.01102783,0.001496684,0.001579399,0.003547857,0.002388122,0.005896016,0.007637214,0.002232719,0.01701698],"category_scores_gemma":[0.02294818,0.001818232,0.001289148,0.005130216,0.001563611,0.01109965,0.007125314,0.002703402,0.01425846],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00354283,"about_ca_system_score_gemma":0.004414042,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.06272438,"about_ca_topic_score_gemma":0.05153214,"domain_scores_codex":[0.9897947,0.001925243,0.001532231,0.001812461,0.004197037,0.0007383578],"domain_scores_gemma":[0.9904785,0.00259274,0.0004405421,0.003791316,0.002021431,0.0006755113],"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.003278696,0.000999105,0.004761711,0.003500497,0.0004250375,0.0007804887,0.001830206,0.01095066,0.02095101,0.04486702,0.540956,0.3666995],"study_design_scores_gemma":[0.001196408,0.000725974,0.005501068,0.0004817596,0.000224222,0.001526672,0.0009990587,0.2102304,0.06494093,0.03497349,0.6784574,0.0007425946],"study_design_candidate":"not_applicable","study_design_consensus":"not_applicable","genre_codex":"software","genre_gemma":"empirical","genre_scores_codex":[0.02510033,0.006587811,0.3554862,0.002247427,0.0007986055,0.002221265,0.02666937,0.5480757,0.03281335],"genre_scores_gemma":[0.1465186,0.001742177,0.7161785,0.002727954,0.0001566547,0.0009377389,0.08365966,0.02553295,0.0225456],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.06272438,"threshold_uncertainty_score":0.1247185,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.0240072976872973,"score_gpt":0.2777318631896082,"score_spread":0.2537245655023109,"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."}}