DB-EnginesExtremeDB: the mission critical dbmsEnglish
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Machbase

Machbase System Properties

Please select another system to compare it with Machbase.

Our visitors often compare Machbase with InfluxDB, SAP Advantage Database Server and TimescaleDB.

Editorial information provided by DB-Engines
NameMachbase infoFormer name was Infiniflux
DescriptionTimeSeries DBMS for AIoT and BigData
Primary database modelTime Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Rank#348  Overall
#32  Time Series DBMS
Technical documentationendoc.machbase.com
Initial release2013
Current releaseV6.5, August 2021
License infoCommercial or Open Sourcecommercial infofree test version available
Cloud-based only infoOnly available as a cloud serviceno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC
Server operating systemsLinux
Data schemeyes
Typing infopredefined data types such as float or dateyes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.no
Secondary indexesyes
SQL infoSupport of SQLSQL-like query language
APIs and other access methodsHTTP REST
Supported programming languagesC
PHP infovia ODBC
R infovia ODBC
Server-side scripts infoStored proceduresno
Partitioning methods infoMethods for storing different data on different nodesSharding
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factor
MapReduce infoOffers an API for user-defined Map/Reduce methodsno
Foreign keys infoReferential integrityno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano
Concurrency infoSupport for concurrent manipulation of datayes
Durability infoSupport for making data persistentno
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yes infovolatile and lookup table
User concepts infoAccess controlsimple password-based access control
More information provided by the system vendor
Machbase infoFormer name was Infiniflux
Specific characteristics

Machbase is an extremely fast time series database which processes large volumes of log/machine data, generated from Smart Factory/X-era. Machbase is the database management system solution, the "Database of Things(tm)." It performs real-time data analysis. This columnar database is optimized for fast time series data entry, analysis and search technology in real-time. It processes various log data operations (i.e. input, change, delete, read, etc.) without conflicting one another. Therefore, even when hundreds of thousands of data are entered and some parts are deleted in real time, the SELECT operation can speed up statistical operations on millions of records.

Machbase offers a complete unified product platform including Edge, Fog and cluster/cloud editions.  Machbase enables data's value to be unlocked locally (the edge) and beyond.

Machbase Edge Edition supports IIoT edge devices for local database management, with minimal memory and storage requiements.  Hundreds of thousands of inserts per second are possible and sub second query time.

Overcoming the limits of Machbase Gateway/Fog Edition, Machbase Cluster Edition has a structure where several processes reside in a general-purpose server. The Multi-Node Cluster Edition has dedicated multiple processes to analyze large amounts of data. It is scalable to ensure the high-availability in order to store and analyze large amounts of data

Competitive advantages
Fastest Database for IIoT, Independently verified, on Industry Standard Benchmarks.

Machbase now holds the #1 performance TPCx-IoT benchmark rank  (http://www.tpc.org/tpcx-iot/results/tpcxiot_perf_results5.asp)
Machbase is the first to break the three million (3,410,800) processing records per sec score.  TPCx-IoT is the recognized industry standard for independently testing top databases against specific speed benchmarks. 

Real-time data processing
Machbase processes (i.e. collecting, storing, indexing, analyzing and visualizing the massive amount of log data) in real-time. Machbase provides the continuous stream of entering and analyzing data with a short real-time interval. This real-time DBMS has been developed to process log/machine data from Smart Factory. 

Simple Structure for data processing and installation. 
In order to reduce complexity and incompatibility, whenever new big data solutions are introduced to existing systems, Machbase does not require three to five tiers of complex structures to build a database management system for collecting, storing, indexing, analyzing and visualizing data. This time-series DBMS has a simple, out-of-box type of installation process. Engineers can start collecting, storing, indexing, analyzing and visualizing their massive amount of log data in real-time just by installing and setting Machbase.

High Availability 
MACHBASE Cluster Edition distributes the data and collects the calculated results from distributed query execution. High Availability provides reliable data processing utilization with a minimum amount of down-time. In other words, Machbase ensures that data is always available even if any of data processing procedures fails. 

High Scalability 
Data storage can be distributed and parallel analysis can be performed on the distributed data. Hence data process performance increases as the cluster grows. This multi-cluster Edition has no limit of data processing as you add more nodes.
Interactive Utilities to maximize data processing performance
When data is entered into the log table through Broker, it is distributed to all warehouses. (The data is not stored in the Broker that performs the input.) The Coordinator determines the database size of each warehouse, and the Broker distributes the data on the basis. However, if data is entered directly into the log table via Warehouse, it is stored only in the corresponding warehouse. You can choose this method if you want to avoid the performance degradation due to distributed algorithm and network bottlenecks.
Typical application scenarios
Distributed Query
In Machbase Cluster Edition, a broker node, which is responsible for the client connection creates query execution plans. A warehouse node passes these query execution plans to a warehouse. The distributed query is executed on the data of this warehouse. The broker transmits the results from the warehouse to the client. Since the actual query execution is executed in the warehouse node, the performance can be increased by distributed execution if the number of nodes increases.

High Data Ingestion
The data transferred from the client is entered through the broker to warehouse. Since the warehouse can be configured with several nodes, the input performance improves in proportion to the increase of the warehouse. As the number of nodes increases, the amount of data processing increases. 

Conventional SQL Syntax Support
Machbase supports standard SQL syntax, including JOIN, GROUP BY, ORDER BY and HAVING clause. Subqueries (including inline view) and various SQL standard functions can be used in Machbase. It also supports analysis of keywords and patterns. Users can directly use the search commands in SQL syntax without learning new language. 

Real-time Indexing 
Machbase has the architecture to index data in near real-time while large volumes of data are inserted per second. This is the crucial feature for time series data analysis as it lays the ground for searching large volumes of data per second. 
Key customers

Machbase has over 50 customers, including Samsung, POSCO, and Hyundai.

Market metrics
Real-time data processing
Real-time index creation
Optimized DBMS for processing data from Smart Factory or Smart-Era X applications
Excellent for all timestamp log applications - e.g. Security
Flexible pricing based on core volume, perpetual or subscription license
Licensing and pricing models

Machbase provide several product editions, including: Intelligent Edge Device, Fog or Gateway, and Cluster/Cloud verisons.

We assure you our pricing rate is flexible, depending on your business infrastructure. Please email to Machbase sales department, sales@machbase.com for more details.

Related products and services

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Redis logo

The world’s most loved real‑time data platform.
Try free

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 80GB free.

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Present your product here