Relational Databases

Relational database

At dawn of IoT era, relational databases were the only way for arranging enterprise-grade storage facility. Comparing with other options available nowadays, they demonstrate quite low performance on data item insertion.

Relational databases can store most types of data items: configuration, events, binary data and topologies. Storing topologies (large numbers of mutually linked class instances) in a relational database enables using SQL language for their advanced processing.

Relational storage can be clustered for high availability using either AggreGate's technology or RDBMS native technology.

Despite AggreGate installation bundles come with an embedded low-footprint relational database and sometimes with a pre-configured MySQL instance, the platform can store data in almost any relational database.

Supported database servers are:

MySQL
PostgreSQL
Microsoft SQL
Oracle Database
Firebird
Sybase
Pointbase
SAP MaxDB
Progress
FrontBase
Informix
IBM DB2
Ingres

Since AggreGate uses a standard and mature Object-to-Relational Mapping (ORM) technology, other database types can also work fine.