Time Series Database
eXtremeDB for HPC is the ideal time series database for Big Data, capital markets and IoT.
Today’s IoT and capital markets depend heavily on applications’ underlying approach to managing information.
Conventional relational database management systems (RDBMSs) cannot deliver the speed, reliability and flexibility these applications demand.
McObject’s eXtremeDB for HPC provides an alternative: a low latency database system for time series data such as that found in financial applications and the Internet of Things. Built on a core in-memory database system (IMDS) design with advanced features to deliver high performance, scalability and reliability, eXtremeDB for HPC is optimized for handling time series data such as trades and quotes, sensor data, and all other types of streaming data. Hybrid storage (in-memory and/or persistent) supports management of both streaming and historical data with a single database architecture.
Flexible data layout
eXtremeDB for HPC implements columnar data layout for fields of type ‘sequence’. Sequences can be combined to form a time series, ideal for working with tick streams, historical quotes and other sequential data. This technology supports database designs that combine row-based and column-based layouts, in order to best leverage the CPU cache speed. Learn how.
“eXtremeDB leverages its sequence storage format to be best-in-class in filtering, aggregations, and window operations.” TSM-Bench: Benchmarking Time Series Database Systems for Monitoring Applications
Throughput between main memory and CPU cache is 3x to 4x slower than the CPU can process data. Traditional DBMSs traverse this bottleneck frequently (twice per function), with the CPU handing off results of each step of a multi-step calculation to temporary tables in main memory.
Choosing a low latency time series database for analytics, tick database, risk management
For streaming data, eXtremeDB delivers low latency database management via a highly efficient in-memory database system (IMDS) design that removes the I/O, cache management, data transfer and other sources of DBMS latency.
For historical or OLTP data, offers a wide array of performance-enhancing features, such as pre-warming the cache, cache prioritization, and many more.
When deployed as an embedded database system, its in-process architecture eliminates costly (in performance terms) inter-process communication. When deployed as a client/server database system, eXtremeDB offers tremendous scalability.
In addition, eXtremeDB is optimized with internal transaction and memory managers to provide maximum efficiency working with multi-threaded applications on multi-processor systems. Support for clustering accelerates processing by enabling multiple servers to share the workload.
eXtremeDB is the ideal high performance time series database for your next project.
Scalable low latency database processing
Time series data management systems frequently require large volumes of information to be available continuously. eXtremeDB excels in this capability. Review McObject’s benchmark demonstrates nearly linear scalability of the 64-bit eXtremeDB, as database size grows to 1.17 Terabytes (15.54 billion rows) on a 160-core Linux server.
The product’s features for handling time series data include support for columnar data layout, which improves efficiency in handling time-series data such as ticks and quotes. System designers can combine a columnar layout with traditional rows in a single database design, to optimize run-time efficiency. A rich library of vector-based statistical functions cuts latency in time series analytics and maximizes efficiency of L1/L2 cache use. GUI-based database performance monitoring enables the user to view key metrics such as transaction time and throughput when fine-tuning to reduce latency.
eXtremeDB ’s fast, native C/C++ API interoperates fully with its SQL API. The native interface is ideal for time-sensitive operations, while the SQL API (with its JDBC & ODBC support) permits higher level access and interfacing with external systems. eXtremeDB Data Relay enables open, highly selective replication between a system’s low latency database and external systems such as enterprise DBMSs.
Persistence and availability
Applications must ensure data integrity, persistence and availability. eXtremeDB for HPC achieves these goals through ACID transactions, optional transaction logging, and selective volatile or persistent storage via the product’s hybrid storage capability. High availability support enables deployment of non-stop fault-tolerant systems based on multiple, synchronized database copies, with application-directed failover.
Learn why we think eXtremeDB would be the best time series database for your next project with a free trial.
Network & Telecom
Network gear developers build on proven eXtremeDB speed and reliability, combined in-memory and persistent data layouts, optimized access methods and unmatched flexibility.
JVC, DirecTV, GoPro and others all discovered that eXtremeDB’s small code size, portable data format and efficient use of compute & storage can reduce component cost while also supporting data-hungry new features.
eXtremeDB’s sophisticated event notification systems, time series data processing and high availability have powered its wide-spread adoption in SCADA, fleet management, smart building automation and other verticals.
Aerospace & Defense
Northrop Grumman, Lockheed Martin, British Aerospace, EADS and others depend on eXtremeDB’s reliability, unmatched performance and broad platform support.
eXtremeDB optimization technology can dramatically boost utilities’ power generation yields. Distribution networks can become self-healing and bi-directional, enabling end-users to contribute power back to the grid.
eXtremeDB’s unique hybrid row- and columnar-layout (OLTP and time series) couples with pipelined functions for statistical analysis and scalable distributed database architecture power record-setting STAC-M3 benchmark results.
Hard Real-time Systems
eXtremeDB/rt is the first and only deterministic embedded DBMS for mission- and safety-critical hard real-time applications. It is built to satisfy strict requirements for timely execution of avionics and aircraft navigation systems, driver assistance systems, critical medical equipment and similar systems’ data management.
Big Data & Analytics
Columnar and row-oriented storage, a SQL engine infused with advanced analytics, and a scalable distributed architecture deliver speed and reliability to complex data-driven applications.
From inception, eXtremeDB’s resilient and optimized storage capabilities uniquely qualified it to fuel database management for safety-critical and resource-constrained embedded applications.
Internet of Things
eXtremeDB’s Active Replication Fabric™ creates a data management foundation for the IoT ecosystem that seamlessly integrates edge and cloud applications’ storage and ensuring data safety all around.