In-database Analytics
eXtremeDB reduces latency-inducing transfers between CPU cache and main memory.
In-database Analytics
eXtremeDB delivers in-database analytics, for breakthrough efficiency working with IoT analytics or market data in financial systems. In-database analytics is implemented in software, and therefore should not be confused with the practice of optimizing analytics using FPGAs.
In-database analytics also differs substantially different from in-memory computing. While in-memory computing uses main memory as DBMS storage, to eliminate various kinds of latency, in-database analytics optimizes data flows to and from the CPU and maximizes the amount of relevant data held in CPU cache, to reduce latency-inducing transfers between CPU cache and main memory.
eXtremeDB in-database analytics can be used independent of the product’s in-memory database system (IMDS) capability.
Three components set in-database analytics with eXtremeDB apart from other systems:
1) The “sequence” data type implements columnar layout for data elements. Sequences are ideal for representing time series such as tick streams.
Database designs can combine row-based and column-based layouts in a hybrid data layout in order to best leverage the CPU cache speed. Learn more.
2) A rich library of vector-based statistical functions, to accelerate analysis of these sequences/columns.
Review the analytics functions library in our online documentation
3) A pipelining technique is used to combine these functions into assembly lines of processing, with output of one function becoming input for the next.
Watch a video about Pipelining
Learn more about Pipelining
The proof is in the results
In multiple audited STAC-M3 benchmark tests, McObject’s eXtremeDB database management system has broken earlier records for the best (lowest) mean response times and for lowest standard deviation (highest predictability/lowest “jitter”) of test results.
Review year after year of record-breaking, audited results
See a list of features to look for if speed matters to your next project
eXtremeDB features developed to maximize database reliability
Read our white papers
- Pipelining Vector-Based Statistical Functions for In-Memory Analytics
- Gaining an Extreme Performance Advantage: A Benchmark of McObject’s eXtremeDB In-Memory Database System
Used by innovative industry leaders in over 30,000,000 deployments world-wide in these markets and others.
Financial Systems
eXtremeDB’s unique hybrid row- and columnar-layout (OLTP and time series) coupled with pipelined functions for statistical analysis and scalable distributed database architecture power record-setting STAC-M3 benchmark results.
Big Data & Analytics
eXtremeDB’s Active Replication Fabric™ manages all aspects of IoT data communication: security, low bandwidth, intermittent connections, multi-tier and bi-directional replication, and more.
Related Resources
Articles for Professional Developers
- “On Time Series Analysis and Big Data. Interview with Andrei Gorine” ODBMS.org
- Gartner’s 19 In-memory Databases for Big Data Analytics, Information-Management.com
See a list of articles
Webinars for Professional Developers
Watch to on-demand Webinars, hosted by experts, about proven database management system practices. Watch “Eliminating Database Corruption“. Or, “Embedded Databases: Make or Break Technology Choices for High Performance Applications” and others.
Review our list of Webinars
White Papers for Professional Developers
We have been testing, improving on, and retesting our software from the beginning in 2001 in order to provide our clients with the best possible data management solutions. Read “Database Persistence, Without The Performance Penalty” and more.
Review our research
Data management wherever you need it.
Hybrid Data Storage Unlike other IMDS, eXtremeDB databases can easily be all-in-memory, all-persistent, or have a mix of in-memory tables and persistent tables.
Row & Columnar Flexibility for Time Series Data eXtremeDB supports database designs that combine row-based and column-based layouts, in order to best leverage the CPU cache speed.
A Hard Real-time Option eXtremeDB/rt is the first and only deterministic embedded DBMS for mission- and safety-critical real-time applications.
Embedded and Client/Server Fast, flexible eXtremeDB is data management wherever you need it, and can be deployed as an embedded database system, and/or as a client/server database system.
Platform Independent eXtremeDB is designed and implemented to be a highly portable.