The system for collecting and storing statistical information from city surveillance devices collects data from more than 2000 devices in real time. The data is collected at user-defined intervals and stored on a fault-tolerant server with backups.
A system was needed to collect and store data from various devices such as: weather stations, surveillance cameras, and other statistical information. The main requirement was the ability to add devices with a basic query handling interface (REST API).
After receiving the initial TOR from the customer, we started a detailed analysis of each of its items. As a result, we reduced the complexity of the overall system by creating a universal data storage system in a minimum number of SQL tables. The customer was also offered to connect the mechanism of dynamic SQL queries with transfer of filters for data selection.
Intervals and new data collection points are added using the UI interface. It is also possible to configure the server using the graphical interface.
Create a graphical administration interface.
Implement fault tolerance of the system.
Deploy the server in a closed customer environment.
Due to the reduced complexity of the project, the order amount was reduced by 1/3 and the complexity of the implementation was reduced.
The project was implemented in two months. During the implementation, the customer made some additional changes to the system, was in constant contact with the development team, and periodically reviewed the demo on our proposal.
Within a year of implementation, the customer received one year of free warranty support, constant contact via messenger and quick help in case of unclear system behaviour.