Indian Journal of Science and Technology
Year: 2023, Volume: 16, Issue: 1, Pages: 12-22
K Venkateswara Rao1*
1Department of Computer Science and Engineering, CVR College of Engineering, Hyderabad, India
Email: [email protected]
Received Date:17 August 2022, Accepted Date:30 November -0001, Published Date:03 January 2023
Background: Data driven sustainable agriculture involves the collection, storage, processing, and analysis of enormous spatiotemporal data related to crop production processes, systems, infrastructure, and environment. Literature survey on smart agriculture research projects indicates that there is a need for improving handling of spatiotemporal data. There are gaps in handling spatial and temporal variability of parameters, division of crop field into management zones to reduce the variability for optimizing application of inputs such as fertilizers, water or pesticides. These gaps are to be addressed at design level of spatiotemporal database for smart agriculture. Objective: To engineer a spatiotemporal database schema that can be used for data driven sustainable agriculture. Methods: The methodology involves spatiotemporal data representation and modeling, Object oriented analysis and design of the database and Verification of the database using life cycle model and algorithmic steps. Findings: The resulting database is capable to store spatial and temporal variability of soil, plant and water parameters as well as handle spatial split, spatial merge, geometry and location changes of spatiotemporal objects. Novelty: Novel Use cases in smart agriculture along with spatiotemporal attributes are identified so that efficient applications can be realized. Adaption of the spatiotemporal database schema for Smart Irrigation System and its implementation methodology are presented.
Keywords: Spatiotemporal Database Design; Data-Driven Agriculture; Agriculture Informatics; Database Verification; Spatiotemporal Data Analysis
© 2023 Rao. This is an open-access article distributed under the terms of the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original author and source are credited. Published By Indian Society for Education and Environment (iSee)
Subscribe now for latest articles and news.