Active Replication Fabric for Reliable IoT Database Management

Evaluate free trial softwareLearn about the IoT demo app

eXtremeDB Active Replication Fabric™ offers solutions for IoT system developers.

Active Replication Fabric offers reliable data management for IoT by solving 5 challenges for IoT system developers:

•   Bidirectional Replication
•   Intermittent connections
•   Multi-tier replication (e.g. edge-to-gateway-to-gateway-to-cloud)
•   Security
•   Compression to maximize limited bandwidth networks

eXtremeDB xPanel net viewer

Edge nodes’ physical connectivity can be intermittent, and constrained. Some popular protocols have limited bandwidth (ZigBee, NFC and RFID, LPWAN, Bluetooth Low Energy, etc.). Edge device connectivity can be intermittent because of the physical device location (e.g. a mobile device) or because the device is battery operated and connects at certain predefined times. From the standpoint of data management, the unpredictable connectivity means that fully integrated support for “push” and “pull” protocols is important to preserve data collected at the edge.

We use the term storage containers for databases maintained on edge devices that are mapped to an upstream database.

The eXtremeDB Active Replication Fabric APIs allow device-based applications to collect data, then transmit the collected data when connected.  Likewise, they also allow replicating server-side data to IoT devices; a common task for new device configuration and provisioning.  Data flow is fully automated through the Active Replication Fabric.  The APIs provide automatic or on-demand data exchange between collection points and servers.

Security Features

Billions of IoT devices’ and their storage containers are exposed and inherently vulnerable. Unlike servers, IoT edge devices run in the open and don’t enjoy IT staff attendance, sophisticated firewalls and other security apparatus available at the back-end. 

~

eXtremeDB security features include Secure Sockets Layer (SSL) connections, a standard security technology that creates an encrypted link between two endpoints.

~

Cyclic Redundancy Check (CRC) on the database page level detects any unauthorized modification to stored data

~

AES encryption employs a user-provided cipher to prevent access or tampering

eXtremeDB knows developers must protect IoT data

Multi-tier Network Topology and Network Discovery

eXtremeDB’s Active Replication Fabric supports complex IoT network topology; edge devices connect to gateways, gateways connect to other gateways closer to the cloud, which ultimately connect to servers in the cloud which may themselves consist of many shards/nodes. Further, any eXtremeDB instance in this topology might also be a member of a high availability group or an eXtremeDB Cluster. eXtremeDB’s xPanel dashboard includes a visual network discovery tool that greatly simplifies managing, monitoring and leveraging eXtremeDB’s tracing capability.

Z

Learn how eXtremeDB Active Replication Fabric treats distributed database topologies in our online documentation.

Z

Review our different distributed database options and objectives

Z

Learn what makes eXtremeDB a flexible database for embedded and client/server

Z

Learn how eXtremeDB Active Replication Fabric treats distributed database topologies in our online documentation.

Z

Review our different distributed database options and objectives

Z

Learn what makes eXtremeDB a flexible database for embedded and client/server

Data Compression

Run-length encoding (RLE) compression can be applied to columnar data (i.e. fields defined as the ‘sequence’ data type).  McObject tests show that activating this feature reduced storage space requirements by 75% and improved the speed of reading the database by 21%.  eXtremeDB also includes a feature for compressing non-columnar data.

eXtremeDB also offers low-level network compression.  IoT networks often use low-bandwidth networks which requires network traffic to be compressed. eXtremeDB implements compression at its System Abstraction Layer (SAL), meaning that compression can be applied to any supported socket type (plain TCP, SSL, local-domain, UDP and others). 

/

Learn how eXtremeDB allows for both columnar and row storage in a single database instance

/

Learn more about the eXtremeDB tiny footprint database

/

Review a list of DBMS features to look for if speed matters to your next project

/

Learn what makes eXtremeDB a flexible database for embedded and client/server

Pipelining statistical functions makes for an ultra fast embedded database

Active Replication fabric means reliable database management for IoT and support on all platforms from edge to cloud

Learn more about the eXtremeDB IoT Software Development Toolkit.  The eXtremeDB IoT SDK runs on the device, gateway and server, a bundled setup that eliminates the need to learn different DBMS and leverages staff skills.

eXtremeDB for the IoT Edge

  • The flexibility of an in-memory or hybrid persistent database
  • Compatible with all embedded/real-time operating systems
  • Specialized indexing for Geospatial, IP/Telephony & Fuzzy search
  • High Availability for embedded systems that require 5 9s availability

eXtremeDB for IoT Big Data & Analytics

  • A library of more than 100 functions for performing statistical analysis on time series data
  • CPU cache-optimized analytics
  • Sharding for elastic scalability
  • Combine row-based and column-based layouts, in order to best leverage the CPU cache speed

eXtremeDB for IoT Big Data & Analytics

  • A library of more than 100 functions for performing statistical analysis on time series data
  • CPU cache-optimized analytics
  • Sharding for elastic scalability
  • Combine row-based and column-based layouts, in order to best leverage the CPU cache speed

eXtremeDB IoT Software Development Toolkit

  • A bundled setup that eliminates the need to learn different DBMS and leverages staff skills.
  • A wide range of supported data types
  • Native and SQL APIs for C/C++, Java, C#, Python
  • Numerous features built-in to prevent data corruption and maximize reliability

Related Resources

Watch this and other Webinars from the DBMS experts at McObject

Webinars for Professional Developers

Watch to on-demand Webinars, hosted by experts, about proven database management system practices.  Watch “Eliminating Database Corruption“.  Or, “Embedded Databases: Make or Break Technology Choices for High Performance Applications” and others.

I

Watch Scaling IoT Applications – Panel Discussion Part I.
The IoT panel discusses scaling by sensors, performance, users, and geography.

I

Watch Scaling IoT Applications – Panel Discussion Part II.
The IoT panel reviews the tools, architectures and key components used to move the application from prototype to successful deployment.

I

Watch Edge Node Database Systems, the Internet of Things’ Hidden Workhorses
Topics covered include DBMS architectures, NoSQL, data complexity, and more.

 Review our list of Webinars

More than just IoT database Webinars, find our experts in respected journals

Articles for Professional Developers

See a list of articles

White Papers for Professional Developers

We have been testing, improving on, and retesting our software from the beginning in 2001 in order to provide our clients with the best possible data management solutions. Read “Database Persistence, Without The Performance Penalty” and more.

Review our research

White paper: Distributed Database Systems and Edge/Fog/Cloud Computing

A distributed database system is one in which the data belonging to a single logical database is distributed to two or more physical databases. Beyond that simple definition, there are a confusing number of possibilities for when, how, and why the data is distributed. Some are applicable to edge and/or fog computing, some others are applicable to fog and/or cloud  computing, and some are applicable across the entire spectrum of edge, fog and cloud computing.

White paper:  Will the Real IMDS Please Stand Up?

In-memory database systems (IMDSs) have changed the software landscape, enabling “smarter” real-time applications and sparking mergers and acquisitions involving the largest technology companies. But IMDSs’ popularity has sparked a flurry of products falsely claiming to be in-memory database systems. Understanding the distinction is critical to determining the performance, cost and ultimately the success or failure of a solution. This white paper examines specific products, seeking to answer the question, “is it really an in-memory database system?”

Best Development Tool & Operating System at IoT World 2019

Read the press release

IoT Vendor of the Year

Read the press release

Outstanding Structured Database

Read the press release

Best Big Data Analytics & Technology Provider

Read the press release

eXtremeDB Shatters Speed Records (again)

Review the data