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?
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.
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.
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
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
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
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.
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.
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.