AgriF2P: AI-Driven natural Language Query System for Agricultural Data Management using LLMs and NoSQL
Ahmed, Salman and Caldwell, Nicholas (2026) AgriF2P: AI-Driven natural Language Query System for Agricultural Data Management using LLMs and NoSQL. In: Intelligent Computing-Proceedings of the 2026 Computing Conference. Wiley, pp. 866-881. ISBN 9783032317544
Full text not available from this repository.Abstract
Agricultural data management continues to rely heavily on traditional practices, such as manual record-keeping, spreadsheet-based tracking, and semi-structured digital forms. These methods are often labour-intensive, error-prone, and difficult for non-specialist users who may lack the technical expertise to apply query languages. To address these challenges, this paper introduces a user-friendly interface that enables natural language querying of operational datasets stored in NoSQL databases. Unlike prior NL2Mongo approaches, Agri-F2P integrates the schema validation, JSON repair, and workflow features such as auto-mated dispatch ticket generation to meet agricultural compliance re-quirements. The proposed system processes free-form English text input through a structured pipeline involving lexical normalisation, schema alignment, and controlled language generation. Evaluation was conducted on 300 ground-truthed queries, confirming high correctness in execution (87.3% success rate), accurate field alignment (93.5%), and robust data handling (96.8%). In addition, a benchmarking empirical comparative analysis has been performed to compare multiple LLM Model(s) families (GPT-3.5, GPT-4o, GPT-4.1-mini/nano, GPT-5-mini/nano, Flan-T5, DeepSeek). Results showed the most recent released GPT-5 variants as inefficient due to excessive token use, higher latency, and reduced reliability in JSON validation. Conversely, legacy models like GPT-3.5 Turbo are latency-optimal, while GPT-4.1-nano is the most cost-efficient. These findings demonstrate that newer models do not necessarily outperform earlier ones in structured query generation.
| Item Type: | Book Section |
|---|---|
| Uncontrolled Keywords: | agricultural data management, user-friendly interface, natural language querying, NoSQL databases, AgriF2P |
| Subjects: | Q Science > QA Mathematics > QA75 Electronic computers. Computer science Q Science > QA Mathematics > QA76 Computer software |
| Divisions: | Other Departments (Central units) > Research Directorate |
| Depositing User: | Salman Ahmed |
| Date Deposited: | 20 Jul 2026 10:21 |
| Last Modified: | 20 Jul 2026 10:21 |
| URI: | https://oars.uos.ac.uk/id/eprint/5364 |
Downloads
Downloads per month over past year
Tools
Tools