Time Series DBMS Use Cases
Machbase edge computing database uses range from process data management in the semiconductor industry, to product lifecycle and predictive maintenance in high-tech industries, as well as real-time data processing in precision industrial environments.
Transportation
Due to the rise of industrial IoT, Petabytes of data are being generated for real-time response, from automobiles driving records, to train, ships, aircraft or other vehicle operations. Machbase collects signals, safety, and plant data from operating vehicles in order to record fuel savings and engine idle time. By deploying real-time monitoring and diagnostics of railway, ship, or automobile operation operating costs are reduced and safety in improved.
Railway
Background
A railroad company needs to analyze all the data collected from trains and rails to achieve operational improvements, to reduce costs, and ensure safety. For the purpose of real-time monitoring of railway signals, data sharing and monitoring, existing Relational Databases are not suitable for collecting all real-time data. a maximum of 1000 event per second can be stored.
Requirements
In order to carry out safety control It is necessary to obtain statistical results. by storing and processing all train communication data and comparing it to historical values/conditions., Preventing performance degradation was a key requirement. We provide a table (Lookup Table) that enables quick update of real-time data. Sensor data needs to be updated quickly. The log and volatile tables must be started from a single database.
Effect of application
As each individual monitoring system processed big data based on existing RDBMS, the processing speed was less than 1,000 per second, Applying Machbase allowed full real-time control of train signals, power and facilities. Machbase makes real-time processing of big data possible. With Machbase more than 60,000 real-time processing per second is possible, while concurrently performing Insert & Update of new data.. Resulting in a 60X + improvement over the existing implementation,
Automotive
Background
As LiDAR-based autonomous vehicles become increasingly popular, electric vehicle suppliers need new manufacturing lines. Real-time response and control using various sensors installed in the vehicle is essential.
Requirements
Dashboard, sensor, ultrasound, and LiDAR data, which form the basis of in-vehicle data sources, are pouring in enormous amounts data into a vehicle. Introducing a Black Box as a system that records all the new data, as well as vehicle driving records brings in brand new requirements. This black box must have durability, safety, high availability, high performance and high efficiency, and above all, achieve the highest computing power at the lowest cost.
Effect of application
Black box requirements are achieved by embedding Machbase on an ARM chip-based board/appliance. The data stability is achieved with a triple redundant Machbase structure in one black box. This blackbox takes advantage of Machbase’s support for SSD (performance of up to 100,000 per second), and real-time data compression (90%.)