Select Page

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.

9

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.

9

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.

9

Watch a video about Pipelining

9

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.

9

Review year after year of record-breaking, audited results

9

See a list of features to look for if speed matters to your next project

9

eXtremeDB features developed to maximize database reliability

In-database Analytics from eXtremeDB is the fastest solution for time series data

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

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 and benchmarks about ultra fast eXtremeDB with In-database Analytics

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