LAYER 01 · DATABASE ENGINE
One Core Engine for
Time-Series Speed and Lifecycle
Use purpose-built engines for raw time series and business data. Keep one data model from small edge devices to servers and clusters.
01
Layer 1: Data Layer
Database Engine
One DBMS for raw time series and business data, with an engine for each workload.
Machbase 8.7 offers fast TAG/LOG ingestion, TRANSACTION for relational DML and transactions, VOLATILE for live state and LOOKUP for reference data.
TAG
Sensors and equipment
Tag names and time/distance axes
Manages bulk measurements and ROLLUP statistics based on criteria.
Columnar · PRIMARY KEY · Persistent
VOLATILE
Real-time status
Quickly retrieve and update temporary state and cached data in memory.
In-memory · Disappears upon restart
LOG
Events and Logs
Stores additional central events, packets, and logs along with automatically generated arrival times.
Columnar · _arrival_time · Persistent
LOOKUP
Reference data
Manages small, frequently referenced reference information such as equipment codes and tag metadata.
Row-based · Primary Key Required · Persistent
TRANSACTION
Business and status data
Manage relational business data and aggregation results using row-level DML and explicit transactions.
Row-based · Standard Edition · Persistent
16.96M
TPCx-IoT Results
200B+
Sensor Records / TB
50–90%
Live Compression
100+
Proven in Korean Industry
TRANSACTION TABLE
Raw Time Series
and Business Transactions Together
JOIN TAG/LOG data with equipment records, work orders, inspections and alarms. Use TRANSACTION tables for business data that changes.
Transaction Control
BEGIN · COMMIT · ROLLBACK
Relational Model
PRIMARY KEY · UNIQUE · AUTO_INCREMENT
Full DML
INSERT · SELECT · UPDATE · DELETE
Query & Data
JOIN · INDEX · JSON · UPSERT· BACKUP · MOUNT
BUILT FOR PHYSICAL DATA
Handle large AI and industrial datasets with ease.
Built for fast ingestion, rare updates, time-range queries, recent-data analysis, aggregates and long-term retention.
01
Bulk Data Capture
Append-optimized storage for Physical AI generating millions of data points/sec
04
Flexible Schema
Handle high-cardinality tags and new metrics as equipment scales
02
Live Analysis & Monitoring
Subsecond queries deliver recent data for dashboards, alerts and anomaly detection.
05
Data Lifecycle
Unify raw data, ROLLUP, backup and archive policies to cut long-term storage costs
03
Time Queries
Query 5-minute to multi-year trends with the same SQL, time indexes and aggregates
06
Edge Ready
Filter, compress and preprocess on site. Send only what's needed to cut latency and cloud costs.
Make Stored Data Ready for Apps
NEXT LAYER
Explore Neo's ingestion, transforms, APIs, visuals and automation.
