McObject updates eXtremeDB Embedded Database for Distributed Query Processing |

McObject updates eXtremeDB Embedded Database for Distributed Query Processing

October 272014

October 27, 2014 — McObject released version 6.0 of its eXtremeDB In-Memory Database System (IMDS). The upgrade adds support for distributed query processing, which improves database speed and scalability by leveraging the processing power, memory and bandwidth of multiple hardware nodes in carrying out queries. Additional improvements in version 6.0 benefit developers and end-users in areas including performance, ease of development and operating system support.
With distributed query processing, eXtremeDB partitions a database and distributes query processing across multiple servers, CPUs and/or CPU cores. Performance is accelerated – dramatically, in some cases – via parallel execution of database operations and by harnessing the capabilities of many host computers rather than just one.
Other new eXtremeDB 6.0 features improve the database system for both developers and end-users, and include:
Python support. eXtremeDB 6.0 enables integration using Python, a high-level language favored for its fast time-to-deployment, particularly for tasks such as prototyping. Using Python alongside eXtremeDB’s dynamic database definition language (DDL) capability, developers can implement their ideas quickly, and optimize rapidly by testing changes to code, database tables and indexes.
Avionics platform support. The upgrade adds compatibility with Wind River Systems’ VxWorks 653 commercial off-the-shelf (COTS) platform for delivering safety-critical, integrated modular avionics (IMa) applications; and VxWorks CERT, which is designed to permit certification to stringent industry standards, including RTCA DO-178 and EUROCAE ED-12, revisions B and C.
Trigram database index. This facilitates “fuzzy” or near matches between text strings. It was developed as an eXtremeDB feature for a customer whose application reads license plate numbers and required the ability to use wildcards in the event of partial data capture.
More flexible transaction scheduling. In addition to exploiting eXtremeDB’s transaction priorities, applications using eXtremeDB’s multiple-user, single-writer (MURSIW) transaction manager can override the default “first in, first out” scheduling policy within priority levels to favor either read-only or read-write transactions.
Data compression. Version 6.0 adds data compression for both in-memory and on-disk databases, reducing storage costs to lower cost-of-ownership.
Covered index option. eXtremeDB 6.0 adds the ability to store key values in b-tree indexes of in-memory databases. Normally such indexes include only a reference to values, to reduce storage footprint; the upgrade enables developers to store values within indexes when an application’s data usage pattern makes this optimal.
Binary schema evolution improvement. With this feature, eXtremeDB can save a database as a binary image and then restore it with a changed schema (design). Version 6.0 extends this feature to eXtremeDB Cluster edition.
Encryption extension. Support for RC4 encryption, which employs a user-provided cipher to prevent unauthorized access, has been extended in version 6.0 to databases managed entirely in main memory.