What literature to read on the design of real-time monitoring systems?

Question

Database

Hello, dear forum users. In the near future, it is planned to refactor the GPS tracking system for vehicles.
The task such:
Is at the very least working system with 2 users. Each user has about 100 cars with installed GPS trackers. Car coordinates are stored in the database. In the user's personal account, it is possible to display the distance traveled by a certain car on the map. + It is possible to compile reports (how many stops on the route, average speed, etc.)
In the near future, it is planned to redesign the system so that up to 100 users can use it (each user has up to 100 cars). Geographically, users are located in Moscow and Moscow Region.
Given the new requirements, I have identified the main difficult points:
The rapid growth of stored data.
For half a year, 2 users have accumulated about 100 million car coordinates. And ideally, we plan to pull out 100 users. Moreover, we plan to store not only the coordinates of cars, but also the values ​​transmitted by various sensors.
Operational processing of incoming data.
Example, the car deviated from the specified route, a message is sent to the user's mailbox. We received a critical value from the N sensor (for example, the engine speed exceeds the allowable value) sent some notification.
Compilation of statistical calculations for logisticians.
Reports on the average speed of movement in section N, the total number of stops, etc.
Please tell me the answers to the following questions:
Is there any literature (books, articles from magazines, etc.) on the design of systems of this kind? If you have something in mind, please share links.
What is the best technology stack for this system?
Thanks in advance.

Answer 1

Here you can use different stacks:
it all depends on what you currently store and what you will store in the future
and how often the sensors send their coordinates to the server.
Can you clarify?