e e cient management of data is an important prerequisite for realising the potential of the Internet of ings (IoT). Two issues given the large volume of structured time-series IoT data are, addressing the di culties of data integration between heterogeneous ings and improving ingestion and query performance across databases on both resource-constrained ings and in the cloud. In this paper, we examine the structure of public IoT data and discover that the majority exhibit unique at, wide and numerical characteristics with a mix of evenly and unevenly-spaced time-series. We investigate the advances in time-series databases for telemetry data and combine these ndings with microbenchmarks to determine the best compression techniques and storage data structures to inform the design of a novel solution optimised for IoT data. A query translation method with low overhead even on resource-constrained ings allows us to utilise rich data models like the Resource Description Framework (RDF) for interoperability and data integration on top of the optimised storage. Our solution, TritanDB, shows an order of magnitude performance improvement across both ings and cloud hardware on many state-of-the-art databases within IoT scenarios. Finally, we describe how TritanDB supports various analyses of IoT time-series data like forecasting.