Data Storage Options
AggreGate Server stores enormous amount of data collected from a device network and generated internally:
- Definitions and configuration of server modules and system resources
- Audit trail of all system operations and events
- Historical values of device metrics
- Persistent events received from the network
- History of synthetic internal metrics and events
All data items stored by the server are divided in two major groups: configuration and events. This simple division provides absolute flexibility in adding new types of devices and business objects without ever changing structure of data storage.
AggreGate Server provides several options for storing configuration and events:
System and device configuration can be organized in the following storage types:
- Relational Database. Any enterprise-grade RDBMS can keep configuration data. Server is bundled with either an embedded database or MySQL database that is preconfigured for optimal performance. Relational database can be clustered for high availability using either AggreGate's own technology or RDBMS native technology.
- Key-Value Database. This integrated storage type is ideal for combining extremely high configuration items update rate with failover clustering functionality.
- File-based Storage. This storage type is normally used by embedded server installations on systems with limited resources.
Persistent device and system events can be stored in:
- Relational Database. Offering standard approach and failover clustering capabilities, this storage option has limited event insertion performance substantiated by limitations of any SQL database.
- NoSQL Database. Integrated NoSQL database engine offers very high insertion rates and failover clustering, as well as storage-level horizontal scalability by employing multi-server storages.
- Memory Storage. This effectively disables persistent event storage, what could be feasible for some embedded installations.
Discover some performance figures of AggreGate Server data storage.
Relational Database Compatibility
Despite AggreGate installation bundles come with an embedded low-footprint relational database and sometimes with a pre-configured MySQL instance, the IoT platform can store data in almost any relational database.
Supported database servers are:
- Microsoft SQL
- SAP DB
- And more (you can always ask us if your DBMS isn’t on this list)