{"id":"W4401608896","doi":"10.1109/icdabi60145.2023.10629374","title":"Talk to your data: Enhancing Business Intelligence and Inventory Management with LLM-Driven Semantic Parsing and Text-to-SQL for Database Querying","year":2023,"lang":"en","type":"article","venue":"","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":11,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Waterloo","funders":"University of Bahrain","keywords":"Computer science; Business intelligence; SQL; Parsing; Information retrieval; Database; Stored procedure; Natural language processing; Query by Example; Search engine","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.005389769,0.000874102,0.0007070832,0.001368951,0.0006341506,0.005687814,0.00246714,0.001135908,0.00490052],"category_scores_gemma":[0.02000204,0.000534007,0.001457706,0.001700333,0.001642311,0.009693094,0.004001192,0.001967789,0.00239494],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001539593,"about_ca_system_score_gemma":0.002377213,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.003954464,"about_ca_topic_score_gemma":0.004310885,"domain_scores_codex":[0.9957765,0.001664833,0.0003489658,0.0005628146,0.001444176,0.0002027118],"domain_scores_gemma":[0.9926894,0.003232876,0.0004337154,0.002313551,0.001075687,0.0002547576],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"not_applicable","study_design_scores_codex":[0.0007529813,0.0004657542,0.008288212,0.0009952462,0.0001784212,0.0005948645,0.003649436,0.06609584,0.01513483,0.4091696,0.04461065,0.4500642],"study_design_scores_gemma":[0.00006744961,0.0001524667,0.0009383525,0.0001886101,0.00008281315,0.0003788457,0.001063941,0.6300454,0.02513579,0.2552501,0.08659608,0.0001002685],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.01489354,0.0002853258,0.9569678,0.002288133,0.0001366074,0.0001816849,0.001631256,0.01744912,0.006166536],"genre_scores_gemma":[0.1744079,0.0003164421,0.8144327,0.001216523,0.00006656733,0.0001994588,0.004198689,0.001929081,0.003232703],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.005687814,"threshold_uncertainty_score":0.02850413,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.06720865886490134,"score_gpt":0.3079032934745465,"score_spread":0.2406946346096452,"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."}}