HPC Analytics Demo

Record-breaking performance of SQL queries using columnar storage and pipelined sequence math functions.

Evaluate free trial software

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?
Try eXtremeDB for HPC Linux 86_64

 

Click to expand image

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.

Z

eXtremeDB supports database designs that combine row-based and column-based layouts, in order to best leverage the CPU cache speed.  Learn more.

Z

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, then broken our own records.  See the stats.

eXtremeDB has columnar and row layout

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.

Database Pipelining video copyright McObject
I

Watch a 2 minute video on Pipelining. 

U

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

Built-in mathematical functions

eXtremeDB comes with a library of more than 100 functions for performing statistical analysis on time series data, such as grand, group, grid and window averages to name a few.

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

Z

Review a list of features to look for to maximize database reliability

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.

High Availability and other Distributed Database options

eXtremeDB offers 99.999% uptime through with high availability capabilities the advanced Active Replication Fabric.

Review this chart of different distributed database options and objectives

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.