McObject eXtremeDB 4.1 Real-time Database System for Embedded Systems

McObject rolled out eXtremeDB v4.1 real-time database system for embedded systems. The latest version of the embedded database features support for custom database collations, new encryption, additional security features, and improvements in how eXtremeDB organizes data on disk and flash media. Using eXtremeDB, developers can eliminate the need to create custom data management code, or to modify a DBMS designed for slower business applications into a real-time system.

McObject eXtremeDB 4.1 Enhancements

  • Support for custom collations
    eXtremeDB 4.1 adds “hooks” that enable developers to provide a desired character sorting sequence (collation) for data stored as text, including collation that supports a particular language or combination of languages. Developers creating products with search and other text-processing functions for a global marketplace have already taken advantage of this feature, which moves eXtremeDB well beyond the default, single-fixed-collation capability of most embedded databases.

  • Binary schema evolution
    This enables eXtremeDB to save a database as a binary image and then restore it with a changed schema, or layout of tables, fields, indexes and other elements. For example, a financial trading application could be more easily enhanced to accommodate a new type of futures contract or other investment; an older portable media player (PMP) design that does not display “album art” could be updated with firmware that supports that capability. With this new feature, database design changes are accomplished more quickly, using less memory and storage, than with the previous (and still available) eXtremeDB approach to schema evolution using XML import/export.

  • Faster on-disk storage and retrieval
    Version 4.1 improves the Disk Manager process that manages interaction with persistent media (hard disk, flash, etc.) in eXtremeDB Fusion, McObject’s hybrid in-memory/on-disk embedded database. Improvements include enhanced “locality of reference” (related objects are stored closer to one another); improved ability to keep entire objects on the same page; reduced file fragmentation; and better statistical information, which is important for SQL optimization.

  • CRC and RC4 encryption
    These new options detect tampering and secure the database from intruders, respectively. Cyclic Redundancy Check (CRC) on the database page level detects whether unauthorized modification to stored data has occurred, while RC4 encryption employs a user-provided cipher to prevent access or tampering. These new features have already generated interest from defense/aerospace companies seeking additional safety in equipment that stores sensitive information such as battle plans. Page-level CRC can also be used in devices such as portable audio players to ensure digital rights management code has not been circumvented.

  • CRC-checking on backup
    Starting in version 4.1, Cyclic Redundancy Check is also employed to add reliability in the backup/restore feature of eXtremeDB in-memory databases. CRC executes automatically when a file is loaded to ensure the databases has not been corrupted, and when it is saved, to verify that the file has been written in its entirety.

  • Improved transaction logging
    eXtremeDB version 4.1 adds the ability to restore a database from transactions logged up to a specific date/time or according to an “application-defined bookmark.” In the case of an accidental mass deletion or change, this gives eXtremeDB the ability to restore to the last backup, and then replay transactions up to, but not including, the error.

More information: McObject