The eXtremeDB Financial Edition DBMS Platform
eXtremeDB Financial Edition benefits from a highly optimized and scalable underlying embedded in-memory database system (IMDS) design with rich developer tools.
Flexible Storage: In-Memory and On-Disk
At its core, eXtremeDB Financial Edition is an in-memory database system (IMDS): records are stored in main memory, eliminating caching, disk and file I/O, and other significant storage-related latency found in “traditional” on-disk DBMSs. It also enables the developer to selectively add persistent storage, so that a given database design can incorporate anywhere from zero to 100% persistent storage. This hybrid storage capability is ideal for working with large volumes of historical and real-time data.
eXtremeDB can run entirely within the application process, eliminating inter-process communication (IPC) between separate software modules. Client/server designs are also supported.
Short execution path
A minimal code path speeds execution by reducing the number of CPU cycles required per database operation and increasing the likelihood that code needed for an operation is already in the CPU cache.
The 64-bit eXtremeDB platform is proven managing terabyte-plus databases with billions of rows entirely in memory; persistently stored data scales to OS file system limits. Choose between transactions managers to scale predominantly read-only and predominantly read-write and/or clustered applications.
eXtremeDB Financial Edition provides numerous tools to boost developer productivity and maximize reliability and performance of real-time capital markets applications. These include:
Multiple Language Support. Developers can access eXtremeDB Financial Edition’s most powerful capabilities – including pipelining vector-based statistical functions – from the industry standard SQL and the Python scripting language. Application development (including the use of pipelining and other specialized features) is supported in C/C++, Java, C# (.NET) and Python. The native, navigational C/C++ API is type-safe and specific to a given project/database design. When coding in C or C++, applications can access the database using this API as well as standard SQL/ODBC. Native Java and C# interfaces are provided, as is a type-3, version 4 JDBC driver.
Market data enhancements. Developers use eXtremeDB Financial Edition’s optional columnar layout to efficiently organize trades, quotes and other time series data, and vector-based statistical functions to accelerate financial calculations.
Choice of indexes. Supported indexes include standard B-trees, hash indexes, Trigram index, KD-trees for multi-dimensional data and Query-by-Example (QBE), custom indexes and more.
Performance monitoring. GUI-based performance monitoring enables users to zero in on key metrics when fine-tuning to reduce latency, and allows the developer to provide performance monitoring as an application feature. See a screen shot of the performance monitor.