{"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":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.0004816576,0.000191689,0.0002217659,0.0002505188,0.0002654079,0.0001762963,0.0004544739,0.00002022603,0.000001724717],"category_scores_gemma":[0.00007081534,0.0001583855,0.000009608446,0.0008801394,0.0000425582,0.001503322,0.002173476,0.00005448642,0.00001550919],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00002607401,"about_ca_system_score_gemma":0.00003100916,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0002271491,"about_ca_topic_score_gemma":0.0008576885,"domain_scores_codex":[0.9982497,0.0000246615,0.0002604679,0.0008558231,0.0002200704,0.0003893491],"domain_scores_gemma":[0.9986012,0.00009316354,0.00006351829,0.0009709852,0.0000788605,0.0001922738],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.0003279723,0.0003022366,0.004489999,0.009076687,0.0004308859,0.001437833,0.01191656,0.01360296,0.03210884,0.3659923,0.01118306,0.5491307],"study_design_scores_gemma":[0.001658572,0.0007378318,0.006484406,0.007526609,0.000159452,0.00042126,0.01613645,0.7070958,0.0140459,0.001207515,0.2412683,0.003257909],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.0277991,0.00008600552,0.9702859,0.0005788254,0.0001835294,0.0007259476,0.00007240673,0.0001882546,0.00008001121],"genre_scores_gemma":[0.1891117,0.0001361798,0.8089038,0.0006079771,0.0001079761,0.0001343079,0.000146974,0.00003590382,0.0008151224],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.6934928,"threshold_uncertainty_score":0.6458773,"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."}}