In-memory and Persistent Database Management System
Designed to be a powerful tool for the professional developer.
The eXtremeDB in-memory and persistent database management system is McObject’s core product. Exceptionally fast, with unparalleled flexibility, eXtremeDB is a powerful tool for the professional developer.
eXtremeDB: an In-memory and Persistent DBMS
The eXtremeDB database management system was originally designed and optimized to be an in-memory database system (IMDS) with direct data manipulation. Storing and manipulating data in exactly the form used by the application removes overheads associated with caching and translation. On embedded platforms (e.g. ARM, PowerPC), typical read and write accesses are at the level of a few microseconds, or less. On workstation or server platforms, performance is sub-microsecond. (Review our independently audited STAC benchmark test results.) The engine is reentrant, allowing for multiple execution threads, with transactions supporting the ACID properties, assuring data integrity.
In addition, eXtremeDB combines the strengths of on-disk and in-memory database systems. Databases can be all-in-memory, all-persistent, or have a mix of in-memory tables and persistent tables. This unparalleled flexibility enables developers to tailor data management in order to optimize applications for speed and persistence, and make intelligent tradeoffs between cost-efficiency, power consumption, and physical space-conserving data storage hardware.
eXtremeDB can be utilized as an embedded database system (typical in embedded platforms for Industrial Control, Aerospace/Defense, Consumer Electronics, and Network/Telecom gear), or as a highly scalable client/server architecture able to be distributed through sharding to gain maximum advantage of multiple cores, CPUs and/or servers (typical for High Performance Computing and Financial systems in private or public clouds).
Optional modules are offered for:
IoT Vendor of the Year 2018
Best Big Data Analytics & Technology Provider
Outstanding Structured Database 2018
Best Development Tool & Operating System at IoT World
The Runtime Environment
The eXtremeDB runtime environment provides:
- Accelerated transactions. The eXtremeDB in-memory database system stores data entirely in main memory, eliminating the need for disk access, caching and other processes that add overhead to disk-based databases. The eXtremeDB transaction manager is optimized for high transaction rates. When persistence is required, eXtremeDB gives you choices.
- Ultra-small footprint. eXtremeDB was originally designed to be an in-memory database system. In this configuration, it eliminates many artifacts of persistent database systems and enables an unbelievably small code size of approximately 200K. As a persistent database system, the code size of eXtremeDB can still be under 200K. And, as a full-on SQL relational database system, the code size is still on the order of just 500K. This makes eXtremeDB a powerful enhancement to many intelligent devices with resource limits that, until now, ruled out the use of an embedded database system.
- Direct data access. Earlier data management technology required copying records from database storage to cache, and then to a new location for manipulation by the application. By operating as an in-memory database system that works with data directly in main memory, eXtremeDB eliminates the overhead of duplicate data sets and of copying data between locations.
- No Translation. eXtremeDB stores data in the exact form in which it is used by the application – no mapping a C data element to a relational representation, for example, or requiring additional code to pick fields from tables and copy them to C structures. By eliminating this overhead, eXtremeDB reduces memory and CPU demands.
- High reliability. For data integrity, eXtremeDB transactions support the ACID properties, ensuring that operations grouped into transactions will complete together or the database will be rolled back to the pre-transaction state.
- Native language APIs, as well as SQL. The native language API for C/C++ derives from the given application’s database schema and thus reflects the purpose for which it is being used. For the runtime environment, this means more reliable code – the C/C++ compiler will catch data typing and assignment errors when the application is built. This makes eXtremeDB-based applications more reliable, since it is much harder for coding errors to make it into the final build. For C# and Java, the language itself can be the schema language by incorporating decorations into the class definitions, which are used at runtime to build the database dictionary. Multiple languages can use the same database by using one language to generate the database schema for the other language(s).
eXtremeDB is designed for High-Performance: optimized memory managers, hash and tree-based indices, multiple data layouts, transactions with priority scheduling and an application-specific API.
eXtremeDB REST API
eXtremeDB provides Web Services using the popular REST (Representational State Transfer) protocol. The REST server can be accessed using any language that supports HTTP and JSON, which includes but is not limited to C/C++, Python, Java and C#. Note that the REST server is simply an HTTP server that serves JSON content, and thus conforms to the HTTP and JSON standards.
Learn more in our extensive documentation.
The Development Environment
Developers strive to produce readable, maintainable, efficient code in the shortest possible time. The eXtremeDB in-memory database system (IMDS) includes several features that boost the developer’s capabilities when integrating the database in demanding IoT/real-time applications. Incorporating third party software often means learning and adopting an API that does not completely fit an application. eXtremeDB’s project-specific API ensures that each database operation in the API reflects the type of the data being manipulated. To help in application debugging, McObject’s embedded database includes numerous traps in the runtime code; these can be selectively disabled as development and testing progresses, to optimize the application for speed. McObject offers full source code, to give an in-depth understanding of eXtremeDB within an application. In addition, eXtremeDB supports virtually all data types as well as extremely efficient indexing for queries. For querying, McObject provides hash indexes for exact match searches; tree indexes for pattern match, range retrieval and sorting; and object-identifier references, for direct access. Specialized indexes support domains such as IP/telephony (Patricia trie), geospatial (R-Tree), query-by-example (KD-Tree) and fuzzy search (Trigram). Indexes are constructed and optimized according to the storage media. For an in-memory database, rather than storing duplicate data, indexes contain only a reference to data, keeping memory requirements for an in-memory database to an absolute minimum. For a persistent database, index structures include the indexed data to minimize I/O operations and optimize performance. With the eXtremeDB embedded database and native language C/C++ API, the developer focuses on the data definition first, then eXtremeDB generates the API from this definition via the schema compiler.
The result is:
- An easy-to-learn API that is optimized for the application.
- Code that is more legible as well as easier to write and maintain.
- Compile-time type checking that helps eliminate coding errors.
Example: The following is a (simple) class and an example of the API to put a new value into a record in the database:
Progressive error detection and consistency checking features If an application mistakenly passes a corrupted transaction or object handle into a runtime method, eXtremeDB (by default) raises a fatal exception and stops the execution of the program. In most cases, the application developer can then examine the call stack to find the source of corruption. The eXtremeDB runtime implements many verification traps and consistency checks like this. Obviously, that does not come free; the runtime requires extra CPU cycles and space for that. However, when the application is debugged and consistently passes verification tests, developers can link the optimized version of the eXtremeDB runtime, removing the traps and internal checks to restore valuable clock cycles.
Complex data types and efficient queries
- Supports virtually all data types, including strings, boolean, binary, structures, arrays, vectors and BLOBs
- Querying methods include hash indexes for exact match searches
- Tree indexes support queries for pattern match, range retrieval and sorting
- “Voluntary” indexes for program control over index population
- Object-identifier references provide direct data access
- Autoid for system-defined object identifiers
- Rather than storing duplicate data, indexes contain only a reference to data, minimizing memory requirements
- Synchronous/asynchronous event notifications
- QNX Neutrino
- Various Real-Time Linux distributions
- Lynx OS
- Microsoft Windows Embedded Platforms
- Windows Real-Time Extensions
- Bare bones boards (no operating system required)
Server and Desktop Platforms:
- Sun Solaris
- Linux distributions
- Classic Windows platforms (98/NT/2000/XP/Vista/8/10)
- gnu toolchain (gcc 2.95 and higher)
- Tornado (GNU and Diab compilers)
- QNX Momentics IDE (C, C++, Embedded C++)
- Metrowerks CodeWarrior IDE (various platforms)
- GreenHills Multi
- Microsoft Visual Studio (C/C++)