HPC Analytics Demo
Record-breaking performance of SQL queries using columnar storage and pipelined sequence math functions.
eXtremeDB for HPC Analytics Demo
This is a Windows program that demonstrates execution of SQL queries using columnar storage and pipelined sequence math functions. The program loads sample market data into an eXtremeDB database and performs a complex RSI (Relative Strength Indicator) calculation in several threads to identify potential ‘long’ and ‘short’ opportunities.
Developing in Linux?
Get a free trial of
eXtremeDB for HPC
Linux 86_64
What makes eXtremeDB for HPC the best choice for your next project?
Columnar and Row-oriented Storage
Combining analytics and online transaction processing (OLTP) queries is a common requirement for today’s high-performance database systems. eXtremeDB supports two storage formats: Vertical (columnar) storage for time-series data, which is ideal for working with tick streams and machine-generated IoT data, while traditional row-oriented storage is de rigueur for OLTP workloads.
eXtremeDB supports database designs that combine row-based and column-based layouts, in order to best leverage the CPU cache speed. Learn more.
eXtremeDB for HPC time series database delivers the most powerful solution for managing market data while maximizing productivity through open, developer-preferred languages, making it the ideal database for financial systems.
Since 2014, eXtremeDB for HPC has set records, only to beat them with successive releases. See the stats.
Pipelining
Pipelining refers to a series of data processing steps where the output of one step is the input to the next step. The pipelining of vector‐based statistical functions is key to eXtremeDB’s ability to accelerate performance when working with IoT and capital markets’ time series data. eXtremeDB’s extensive library of math functions are the building blocks that are assembled into pipelines to minimize data transfers and maximally exploit the CPU’s L1/L2/L3 cache. Don’t see the function your analytics require? No problem, write it yourself and use it alongside the built-in functions seamlessly.
Watch a 2 minute video on Pipelining.
Review the white paper: Pipelining Vector-Based Statistical Functions for In-Memory Analytics
Read about analytics in our on-line documentation
What makes eXtremeDB for HPC different from all of the databases that also claim they are fast?
Many database systems include one or two of the same performance-enhancing features such as in-memory data storage, columnar data handling, fast native APIs as well as high performance SQL, and a short execution path. But you’d be hard-pressed to find all of them in one database system, and solutions offering some of these features may also lack “real” database capabilities such as ACID transactions. In contrast, eXtremeDB offers all of them plus a rich assortment of additional development and run-time features.
Flexible hybrid in-memory & persistent storage
The eXtremeDB hybrid database combines the strengths of on-disk and in-memory database systems. eXtremeDB was originally designed and optimized to be an in-memory database system (IMDS) and this distinction allows for improved performance. Learn why here.
In-database Analytics
eXtremeDB delivers in-database analytics, for breakthrough efficiency working with IoT analytics or market data in financial systems.
Learn the 3 components that set in-database analytics with eXtremeDB apart from other systems
Choice of Programming Interface
eXtremeDB provides a set of libraries written in the C language that enables you to access databases from within any C or C++ program, and language bindings for Python, C#, Java, Scala, PHP, Rust and Lua, and a RESTful API for browser-based apps. Whether you prefer SQL or a native (nonSQL) API, eXtremeDB has you covered.
Elastic scalability via sharding
Configure sharding easily with xPanel for database administration/monitoring. Sharding horizontally partitions a logical database into multiple physical databases that can be distributed on any number of virtual or physical servers to take advantage of multiple I/O channels and multiple CPUs/CPU cores. Learn more
Features to look for if speed matters in your next project
Review a list of features to maximize database reliability
High Availability and other Distributed Database options
eXtremeDB offers 99.999% uptime with high availability Review this chart of different distributed database options and objectives
Built-in mathematical functions
eXtremeDB comes with a library of more than 150 functions for performing statistical analysis on time series data, such as grand, group, grid and window averages to name a few.
Used by innovative industry leaders in over 30,000,000 deployments world-wide in these markets and others.
Telecom & Netcom
eXtremeDB powers routers, application traffic management, SCADA network fault management and more from industry leaders like F5, ViaSat, Motorola, Sandvine, Hutchinson, TNS and Ribbon that require real-time performance and five 9s high availability.
Internet of Things
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.
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.