The open-source time-series database software IoTDB, developed by the School of Software at Tsinghua University, has set a new world record.
### Abstract: Apache IoTDB Sets New World Record in Industrial IoT Performance Benchmark On August 30, during the International Transaction Processing Performance Council (TPC) Technical Conference, the committee officially announced the latest results of the authoritative database performance benchmark. Notably, Apache IoTDB, an open-source time series database developed by the Software College of Tsinghua University, has set a new record in the TPCx-IoT benchmark, achieving top rankings in both performance and cost efficiency. #### Overview of Apache IoTDB Apache IoTDB is a specialized time series database designed to handle the vast amounts of data generated by industrial equipment sensors. It serves as a critical infrastructure for industrial digital transformation by efficiently storing, managing, and analyzing these sensor data. The software was initiated by Professor Jianmin Wang's team at Tsinghua University's Software College in 2011, driven by the goal of advancing China's industrial development towards higher sophistication, intelligence, and sustainability. #### Key Technological Breakthroughs The development of Apache IoTDB has focused on several core technological advancements: 1. **High Compression**: Efficiently compressing large volumes of sensor data to reduce storage costs and improve performance. 2. **End-to-Edge-to-Cloud Integration**: Enabling seamless data flow from the device level (end), through edge computing nodes, to the cloud, thus supporting comprehensive data management and analysis. 3. **Time Series Big Models**: Developing sophisticated models for time series data to enhance predictive analytics and decision-making. These breakthroughs support the entire data lifecycle, from collection and aggregation at the device level to processing and analysis in the cloud, and from model training in the cloud to inference and execution at the edge and device levels. This integrated approach helps enterprises transition from merely collecting data to effectively utilizing it for operational improvements. #### Industry Applications and Impact Apache IoTDB has been widely adopted across various industries, including aerospace, energy, and engineering. It has been implemented in thousands of large-scale industrial enterprises worldwide, with notable users such as: - **Aerospace**: China Aviation Chengfei, China Commercial Aircraft Corporation (COMAC), and China Shipbuilding Industry Corporation. - **Energy Power**: China National Nuclear Corporation and ZTE Cidi. - **Engineering Equipment**: Goldwind Technology, Baowu Intelligent Maintenance, Changan Automobile, CRRC Sifang, Siemens, and Bosch Rexroth. The software has played a crucial role in enhancing the efficiency and reliability of data management in these sectors, contributing to significant technological and operational advancements. For instance, the results of IoTDB's implementation in China Aviation Chengfei's equipment manufacturing were showcased at the National "13th Five-Year Plan" Science and Technology Innovation Achievements Exhibition, highlighting its impact on industrial innovation. #### TPCx-IoT Benchmark The TPCx-IoT benchmark is a standard set by the TPC to evaluate the performance of systems in industrial IoT scenarios. It simulates the management of massive sensor data in power grid substations and measures two primary metrics: 1. **Effective Throughput**: The database's ability to handle large volumes of data efficiently. 2. **Total Cost per Unit Performance**: The cost-effectiveness of the database's performance. TPC, founded in 1988, is a non-profit organization and one of the most authoritative bodies for database performance benchmarks. Many leading database vendors, including Oracle, Microsoft SQL Server, IBM DB2, and Databricks, participate in TPC benchmarks to validate their products. #### Achievements in the TPCx-IoT Benchmark Apache IoTDB's performance in the TPCx-IoT benchmark is a testament to its advanced capabilities. The software achieved the highest effective throughput and the lowest total cost per unit performance, outperforming other well-known databases. This success not only underscores the technical prowess of Tsinghua University's Software College but also highlights the potential of open-source software in driving industrial innovation and efficiency. #### Conclusion The development and success of Apache IoTDB mark a significant milestone in the advancement of industrial IoT technologies. By addressing the unique challenges of industrial data management, IoTDB has become an essential tool for enterprises aiming to leverage data for smarter and more sustainable operations. Its top performance in the TPCx-IoT benchmark further solidifies its position as a leading solution in the industry, paving the way for broader adoption and continued innovation in the field of industrial digital transformation. #### Source Tsinghua University News Network, September 2, 2024.
