ExtremeDB

Additional features

Embedded Database Management System

Core offering, designed to be integrated directly into applications.

Hybrid Persistent & In-memory Storage

Allows developers to define tables as in-memory (for speed) or persistent (for durability on disk/flash), balancing performance with storage costs.

Hard Real-Time Edge to Cloud

Supports deployments from tiny embedded devices at the edge to large cloud-based systems.

Highly Scalable Distributed Client/Server

Can operate as a standalone embedded database or as part of a distributed system.

SQL API (eXtremeSQL)

A high-performance implementation of ANSI SQL (broad coverage of SQL-89 standard) accessible directly or via ODBC/JDBC. Includes eXtremeDB-specific extensions for native data types, distributed queries, and a library of over 150 vector-based functions for time-series analytics.

Native APIs

Offers highly optimized, type-safe APIs for C, C++, Java, C#, Python, and Lua, allowing direct data manipulation for maximum performance and control.

eXtremeDB/rt (Hard Real-Time Edition)

First and only COTS hard real-time embedded DBMS.

Guarantees transaction deadlines, ensuring timely execution of mission-critical operations.

Preserves external and internal data consistency by enforcing transaction deadlines and ACID properties.

Supports adaptable real-time transaction managers (e.g., High Priority Earliest Deadline First, Priority Inheritance).

Works with various Real-Time Operating Systems (RTOS) like VxWorks, INTEGRITY, ThreadX, QNX, FreeRTOS.

IoT Software Development Toolkit (SDK)

Active Replication Fabric™

Unique feature for robust data exchange between IoT edge devices and remote systems, handling intermittent connections and multi-tier replication (edge-to-gateway-to-cloud).

Intelligently queues data during network outages and synchronizes it upon re-connection.

Supports all platforms from edge to cloud.

Includes built-in security (encryption, CRC32).

Small code size (as little as 300K).

eXtremeDB Cluster

McObject's distributed database system for managing databases across multiple hardware nodes.

Enables two or more servers to share the workload, dramatically increasing processing power.

Peer-to-peer (master-master) architecture where every database instance serves as a master, distributing updates across nodes.

Supports a two-phase commit protocol for distributed transactions.

Eliminates inter-process communication (IPC) overhead by running the DBMS within the application process on each node.

Quorum-based availability for write operations.

Seamless "hot" synchronization of newly connected nodes.

High Availability (HA)

Ensures continuous database operation with 99.999% uptime.

Synchronizes two or more databases within separate hardware instances.

Supports synchronous (2-safe) and asynchronous (1-safe) replication.

Provides automatic failover.

Sharding

Supports horizontal partitioning of data across multiple nodes for scalability in distributed deployments.

ACID Transactions

Guarantees Atomicity, Consistency, Isolation, and Durability for all database operations, ensuring data integrity.

Concurrency Control

Supports both Multiple-Reader, Single-Writer (MURSIW) locking and Multi-Version Concurrency Control (MVCC) for flexible transaction management based on workload.

Optimized Data Access

Eliminates file system I/O, multiple data copies, and redundant processes (like caching) for high performance.

Tiny Footprint

Code size as small as 150KB for the core engine, minimizing memory demands and enabling lower-cost hardware.

Cross-Platform Portability

Runs on a wide range of operating systems (Windows, Linux, many Unix variants, VxWorks, INTEGRITY, ThreadX, eCos, QNX, Android, iOS) and CPUs (x86, PowerPC, ARM, MIPS).

Time Series Analytics

Specialized features for managing time-series data, including columnar (vertical) storage for sequences data type and a library of over 150 vector-based statistical functions.

Pipelining Vector-Based Functions

Optimizes performance for time-series analysis by chaining functions to minimize data transfers.

Variety of Index Types

Supports B-tree, R-tree (geospatial), Hash table, Radix tree (Patricia trie), k-d tree, Trigram index (text), and custom indexes.

Flexible Storage Models

Supports N-ary Storage Model (row-oriented) and Decomposition Storage Model (columnar) for sequences data. Hybrid designs possible.

Security Features

Includes page-level Cyclic Redundancy Checking (CRC) for data integrity, AES encryption, and Secure Sockets Layer (SSL).

Event Notifications

Notifies applications when specific database changes occur, supporting synchronous and asynchronous modes.

Transaction Logging

Records database changes for recovery in case of system failure.

Data Relay Technology

Facilitates fine-grained data sharing between eXtremeDB applications and external enterprise DBMSs.

Binary Schema Evolution

Allows modifying the database schema without requiring a full data dump and reload.

Optimized for Various Markets

Proven in Network & Telecom, Consumer Electronics, Industrial Systems, Aerospace & Defense, Energy, Finance, Big Data & Analytics, and general Embedded Systems.

xPanel (GUI Tool)

A management tool for SQL database management, including a visual network discovery tool.

Online Backup

Supports backing up databases while they are in use.

Source Code Available (License-Dependent)

Offers transparency and deep control for developers.

Deterministic Rule-Based SQL Optimizer

Provides predictable performance for SQL queries, crucial for real-time systems.

Stored Procedures

Supports stored procedures written in Lua, Python, or C/C++ to reduce client-server communication.

Authentication & Authorization

Integrates with Active Directory and offers granular access control.

Compression

Includes Zip-like compression for tables and Run-length Encoding for time-series data.

Cache Prioritization

Allows applications to influence cache policies beyond typical LRU to minimize retrieval overhead for time-sensitive data.