Products
Who We Are
TDengine™ is a time-series database purpose-built for Industry 4.0 and IIoT.
Our mission is to democratize industrial data systems and make big data accessible, valuable, and affordable for everyone.
!
On Premises
TDengine Enterprise
Deploy TDengine on the edge, on a local server, or in a public, private, or hybrid cloud
In the Cloud
TDengine Cloud
Run your industrial data workflows in our fully managed cloud service
Solutions
What We Do
TDengine is designed to help traditional industries achieve digital transformation and improve operational efficiency.
TDengine centralizes, stores, analyzes, and shares massive amounts of industrial data so you can scale your operations for Industry 4.0.
!!
By Industry
By Data Source
By Application
Resources
Why Developers Choose Us
* High Performance: outperforms other time-series databases in ingestion, querying, and compression.
* Cloud Native: enables scalability, elasticity, resiliency, observability, and automation in a distributed architecture.
* Ease of Use: reduces effort to deploy your time-series database, with simple, standardized interfaces and seamless integration.
Docs
Read the official documentation to learn about our products
Blog
View the latest articles about industrial data processing
Downloads
Download installation packages, special reports, and more
Tutorials
Follow along with step-by-step guides through the data lifecycle
Webinars
Watch live and on-demand webinars to learn more about TDengine
TDengine OSS
Explore our open source time series database project
# Siemens SIMICAS Simplifies Industrial Time-Series Data Processing Workflows
Chait Diwadkar
July 31, 2022
 /
, 
The Industrial Internet of Things (IIoT) is the continuous integration of collectors and controllers with sensing and monitoring capabilities, as well as mobile communications and intelligent analytics, into every aspect of industrial production. With the IIoT, traditional industrial production is entering into the age of intelligence.
The data obtained from Internet-connected equipment is used to improve efficiency, enable real-time decision-making, solve key problems, and create new, innovative experiences. However, new challenges have been brought by the increasing level of fragmentation and number of interconnected devices. To unlock the power of data, industry needs end-to-end, interoperating solutions that bridge the gap between equipment and the Internet and drive a new wave of innovation.
## Background
SIMICAS® is a digital transformation solution that Siemens DE&DS DSM has developed for equipment manufacturers. With SIMICAS, you can remotely maintain equipment and perform intelligent analytics on service data, enabling higher efficiency and reduced costs in the post-sales phase.
This solution offers the flexibility you need to define your path to digitalization based on your own development needs. It consists of the SIMICAS intelligent gateway, SIMICAS configuration tool, SIMICAS Metrics Performer, and SIMICAS Performance analyzer, the latter two of which are based on the open IoT system MindSphere.
## System architecture
In version 1, the architecture involved Flink, Kafka, PostgreSQL, and Redis. The following figure shows the data flow.
The network gateways deployed on premises transmit equipment data to the IoT edge components, which process this data and write it to the Kafka queue. Flink then consumes the data in the queue and performs the required computations on it. The raw data and computed metrics are then written into a PostgreSQL database, with the newest data also being written to Redis for faster query response. Historical data is still queried from PostgreSQL.
## Business challenges
After SIMICAS 1.0 was launched, two pain points were identified:
First, introducing Flink and Kafka into the architecture made deploying the solution cumbersome and required more server resources. Second, applications for the solution became more complex because databases and tables had to be partitioned in PostgreSQL in order to store the large amounts of incoming data.
The solution team was therefore tasked with finding ways to reduce complexity, hardware resource usage, and customer costs.
## Component selection
It was decided to rearchitect the SIMICAS solution to resolve the identified pain points and align better with future development plans. A component was needed that met the following requirements:
* High performance: millions of concurrent writes, tens of thousands of concurrent reads, and the ability to handle a large number of aggregate queries without performance deterioration
* High availability: cluster deployment, horizontal scaling, and no single points of failure
* Reduced cost: low requirements on hardware resources and high compression ratio
* High level of integration: message queue, stream processing, and caching features included with the database as a single solution
The solution team compared various open-source data platforms and  (TSDB) management systems and finally selected TDengine as the only platform that offered built-in message queuing, stream processing, and caching.
## Implementation
### Data flow
In SIMICAS OEM 2.0, three components – Flink, Kafka, and Redis – were replaced by TDengine, greatly simplifying the system architecture.
### Data model
#### Creating the database
The solution uses a three-node TDengine cluster. In the cluster, a database is created that retains data for two years, replicates data to all three nodes, and enables record updating.
```
create database if not exists simicas_data keep 712 replica 3 update 2;
#### Creating the table for real-time metrics
An independent supertable is created for each type of equipment that the solution handles. Within each supertable, a table for each device is created.
create stable if not exists product_${productKey} (ts timestamp,linestate bool,${device_properties}) tags (device_code binary(64));
create table if not exists device_${device_code} using product_${productKey} tags (${device_code});
#### Creating the table for status data
A single supertable is created to store the status data of all equipment in the solution.
create stable if not exists device_state (ts timestamp,linestate bool,run_status int,error_code binary(64),run_total_time int,stop_total_time int,error_total_time int) tags (device_code binary(64),product_key binary(64));
create table if not exists device_state_${device_code} using device_state tags (${device_code},${productKey});
### Metric Calculation
Java Expression Language (JEXL) is used to define expressions that the system converts into SQL query tasks. The results of these queries are used to calculate the metric, which is then sent to the frontend for display.
As an example, the following JEXL expression is used to find the average voltage of all devices in project abc:
avg(voltage,run\_status=1 \&\& project=abc)
The system breaks this expression down into the following SQL queries:
1. Query all devices whose run\_status is 1 and whose project is abc.
2. From the results of step 1, query the latest value of the voltage field for each device
3. From the results of step 2, calculate the average value.
With multithreading and the high-performance querying offered by TDengine, the P99 latency for a single KPI is under 100 ms.
## Discovered issues
The best practices published by TDengine recommend using a multiple column data model in which metrics are stored as columns in a supertable. However, in environments with a large number of metrics, this can cause SQL statements to be excessively long. Also, devices that upload data only when a change occurs will have a large number of null values in their tables, making the `SELECT LAST(*) FROM device_xxx` statement inefficient.
Upon consultation with the TDengine Team, it was clarified that the LAST function queries each column until it finds a non-null value. In the current edition of TDengine, this means that the LAST function may access data that is not in the cache.
To resolve the issue with long SQL statements, an upper limit was set on the number of metrics that a single device can have. For the second issue, the method of uploading data to the system was changed.
These issues could have been avoided with better consideration of the production environment. Going forward, SIMICAS supports both single column and multiple column data models so that customers can choose the best model for their use case.
Finally, the maintenance and monitoring capabilities of TDengine are weaker than its competitors. However, the recently released TDinsight has improved this situation, and the SIMICAS team plans to test this component in the next phase.
## Conclusion
Overall, the SIMICAS team was greatly impressed with the performance of TDengine and the level of support received. The simplified architecture enabled by TDengine will benefit all SIMICAS customers, and we are excited to continue working with TDengine in the future.
[Download TDengine OSS and get started in 60 seconds
Download Now
[Contact us to learn more about TDengine Enterprise
Contact Us
[Register for a free TDengine Cloud account today
Register for Cloud
Subscribe to our newsletter
Search
TDengine™ is a time-series database purpose-built for Industry 4.0 and Industrial IoT. It enables real-time ingestion, storage, analysis, and distribution of petabytes of data per day, generated by billions of sensors and data collectors. With TDengine making big data accessible, valuable, and affordable, digital transformation has never been easier.
© 2022–2025 TDengine
Learn
Company
Social
Search for:
# TDengine Helps Lotus Expand Data Infrastructure
TDengine Team
December 16, 2024
TDengine is delighted to announce that it has been engaged by Lotus Technology, the owner of , to provide data services for its worldwide business. With TDengine, Lotus has successfully expanded its global network of data nodes, enabling seamless data processing and transmission. Leveraging TDengine’s efficient and scalable time-series data processing capabilities, Lotus has significantly increased its data handling capacity and efficiency, ensuring that car owners, no matter where they are, enjoy instant response and exceptional service.
“Lotus has been at the forefront of automotive innovation for decades,” said Jeff Tao, founder and CEO of TDengine, “and it is a distinct pleasure to work with them to handle the massive scale of data generated by the latest in electric vehicles. They can be confident that with TDengine’s highly scalable solution will continue to provide the top-tier performance and service that customers associate with the Lotus brand.”
In the  sector, TDengine has been a part of numerous digital transformation projects for prominent companies including  and  and has accumulated extensive experience in addressing the data processing demands and architectural optimization needs of modern vehicles. This renewed collaboration with Lotus Technology further solidifies TDengine’s technical advantages in automotive applications and supports the advancement of smart driving technologies.
## About Lotus Technology
Lotus Technology Inc. has operations across the UK, EU, and China. The Company is dedicated to delivering luxury lifestyle battery electric vehicles, with a focus on world-class R&D in next-generation automobility technologies such as electrification, digitalisation and more. For more information about Lotus Technology Inc., please visit .
## About TDengine
# TDengine Case Studies
View the latest case studies with TDengine
[Building a Virtual Power Plant Management System: Pain Points & Best Practices
Amber Optimal's platform uses TDengine to manage large-scale data ingestion, real-time analytics, and algorithm-based analysis for optimized resources.
Jim Fan
December 27, 2024
|
Case Studies, Featured, Renewable Energy
[Reducing Energy Costs by 90%: The Future of Battery Manufacturing with TDengine
TDengine cuts costs by 86%, reducing energy consumption by 90% and simplifying data management, boosting battery production efficiency.
Sun Yu
December 12, 2024
Featured, Case Studies
[TDengine Powers Mogulinker’s AI-Driven Control Platform for Industrial Energy Optimization
TDengine powers Mogulinker’s real-time processing of 100GB+ IoT data daily, optimizing industrial energy management.
December 9, 2024
Case Studies, Featured
[TDengine Enables Alerting and Predictive Maintenance for IoT Motor Platform
To accommodate business growth and overcome difficulties with predictive maintenance, an electric motor company migrated their IoT platform to TDengine.
November 12, 2024
[TDengine Powers Vibration Data Analysis and Fault Prediction at Hydroelectric Plant
TDengine was deployed at a hydroelectric power operator as part of a monitoring system to ingest and process high-frequency data.
November 4, 2024
[Earthshaking Speed: TDengine Ingests 50,000 Seismological Records per Second
TDengine ingests 500 billion data points per day at 100 Hz without performance deterioration for an earthquake research center.
October 31, 2024
[Gotion Elevates Energy Storage with TDengine Cloud
TDengine Cloud helps Gotion run energy storage projects at minimal cost thanks to its reasonably priced, fully managed enterprise service.
Zhicheng Liu (Gotion)
June 30, 2024
Renewable Energy, Case Studies
[Mingyang Group Powers Smart Wind Energy System with TDengine
TDengine's high performance and scalability now enable Mingyang's real-time monitoring and prediction applications for their wind turbines,
[Nevados Streamlines Solar Tracker Data Operations with TDengine
Nevados has selected TDengine as its time-series database to process solar tracker data.
January 9, 2024
Case Studies, Energy, Featured
[Siemens SIMICAS Simplifies Industrial Time-Series Data Processing Workflows
Industry needs end-to-end, interoperating solutions that bridge the gap between equipment and the Internet. See how Siemens used time-series technology to build such a solution.
Case Studies, Manufacturing
1