The purpose of this database is to create a clone of the California Irrigation Management Information System (CIMIS) database. The CIMIS database has frequent outages, some lasting as long as 3 months, so this database aims to be a more robust alternative for use by the California Irrigation Web Application Program (CIWA). To do this we are using a commercially viable host, Microsoft Azure, and their various services including Azure Functions, Azure Core Tools, Azure Service Bus, Azure Data Queue, and Azure SQL Databases.
The database structure is comprised of a multiple functions which send requests through Azure Data Queues, allowing for thousands of instructions to be sent at once and to be handled over long periods of time. A large SQL database comprised of multiple SQL tables are used throughout the project to allow for efficient data retrieval and storage. This structure creates a single point at which the database is accessed allowing simple interaction through a lightweight API.
