Publication Details

Application of Time Series Database for IoT Smart City Platform

JOHN Petr, HYNEK Jiří, HRUŠKA Tomáš and VALNÝ Michal. Application of Time Series Database for IoT Smart City Platform. In: IEEE Xplore. 2023 Smart City Symposium Prague (SCSP). Prague: Institute of Electrical and Electronics Engineers, 2023, pp. 1-6. ISBN 979-8-3503-2162-3. Available from:
Czech title
Využití databází pro časové série pro IoT platformy chytrých měst
conference paper
John Petr, Ing. (DIFS FIT BUT)
Hynek Jiří, Ing., Ph.D. (DIFS FIT BUT)
Hruška Tomáš, prof. Ing., CSc. (DIFS FIT BUT)
Valný Michal, Ing., Ph.D. (Logimic, s.r.o.)

IoT, Smart City, Database, NoSQL, Time Series, AWS, Serverless computing


IoT devices are becoming more prevalent yearly due to their relatively low cost and high maintainability. Their use cases are often varied-from industry (e.g., devices intended for quality control) to their application in smart cities, where they can help supervise day-to-day operations. With the increase in popularity comes the need to effectively store, query and process the data produced by such devices. This problem can seem relatively easy at first glance, but often, the solutions are not as straightforward. In real-world applications, multiple device types are needed to accomplish each task. This typically results in large streams of incoming data, each with its own structure and data representation. Due to the large amounts of devices, it may be necessary to distribute the workload or use serverless computing to tackle fluctuations in incoming requests. This paper provides a study of some options that can be used to achieve this goal, focusing on the efficiency and ease of use of both SQL and NoSQL databases currently available regarding deployment on both local devices and serverless functions like AWS Lambda. Document or relational databases are often used to store data from such devices. However, features of Time Series databases could be used to improve the entire system's performance and reduce storage requirements. One of the systems that could benefit from this improvement is a Smart City system developed by Logimic.  The cost of the proposed smart city platform is essential because a high running cost can result in the system being more expensive than the cost reduction from using efficient IoT devices.

IEEE Xplore
2023 Smart City Symposium Prague (SCSP)
Smart Cities Symposium Prague 2023 & European Transport Congress 2023, Prague, CZ
Institute of Electrical and Electronics Engineers
Prague, CZ
EID Scopus
   author = "Petr John and Ji\v{r}\'{i} Hynek and Tom\'{a}\v{s} Hru\v{s}ka and Michal Valn\'{y}",
   title = "Application of Time Series Database for IoT Smart City Platform",
   pages = "1--6",
   booktitle = "IEEE Xplore",
   series = "2023 Smart City Symposium Prague (SCSP)",
   year = 2023,
   location = "Prague, CZ",
   publisher = "Institute of Electrical and Electronics Engineers",
   ISBN = "979-8-3503-2162-3",
   doi = "10.1109/SCSP58044.2023.10146237",
   language = "english",
   url = ""
Back to top