XTDB in Production
Our users solve problems with XTDB in fields ranging from predictive risk systems in investment banks to fraud detection via graph analytics. From authorization for IoT data to temporal queries across financial transactions on enterprise blockchains, XTDB is everywhere.
Price calculation service for an automotive components catalog to support supply chain operations of a €300m+ revenue eCommerce distributor
Modeling future pricing changes requires bitemporal data and extensive temporal queries. Valid Time is used to model scheduled discount rule changes and to project fluctuations in supplier prices. Transaction Time is used to scale the database installation and enable consistent real-time pricing calculations.
The initial installation was simplified by the fact that an existing Kafka cluster was already in place, making XTDB a convenient addition to the technology landscape.
End-of-Day risk calculations for trading desks across global regions
Risk Systems benefit directly from bitemporal modeling. For example, Valid Time can be used to correlate out-of-order trade data. The immutable nature of Transaction Time enables auditable corrections to trade data in the form of bitemporal records — making compliance easy.
Backtesting of risk models against historical data is also effortless with bitemporal records. Querying historical data with ‘as-of’ queries is as simple as actually querying the database at that precise date and time in the past.
Risk Systems typically require high throughput, especially during End-of-Day reporting windows. Other databases can only accomplish bitemporal modeling with offline analytics or time-series outside of the critical path. XTDB can handle your live data.
Modular CRM Platform
Consolidated database system for SaaS, Cloud-managed and on-premises variations of an enterprise CRM product
Avisi Apps build Atlassian Marketplace applications such as Atlas CRM, which integrate closely with Jira.
Avisi eliminated the duplication of code and modeling work required to maintain multiple database backends by using a configurable Datalog engine that can improve development speed and platform support. With XTDB’s pluggable storage layers, it is possible to deploy across diverse operating requirements including bespoke transaction logs, document stores, and index KV stores.
Powerful yet simple & stable API helps startups to rapidly explore new ideas
XTDB underpins a Firebase-inspired open source framework for Clojure, upon which a broader CMS is built.
Schema-on-Read is well-suited to rapid prototyping. It allows a focus on the product, first and foremost. With Biff running atop XTDB, there are virtually no operational overheads when delivering pilots and other small projects with scope for significant growth.
“Like Vim, Arch Linux, and Clojure itself, XTDB is one of those pieces of software that sparks joy.” — Jacob O’Bryant, Founder
Temporal Metadata Management
Temporal storage for the Linux Foundation's Open Metadata and Governance platform
The Egeria platform enables the peer-to-peer exchange of metadata between tools from different vendors to support enterprise-wide initiatives across development, operations, and data science teams.
A foundational data storage layer transitioned to XTDB from an existing non-temporal graph backend, to support innovative temporal functionality while also improving performance and overall scalability. Egeria uses Valid Time to enable consistent and efficient real-time queries across the complete history of a organization’s metadata landscape.
Querying the platform requires complex use of ad-hoc graph relationships and Lucene full-text search.
Datalog queries for immutable financial transactions on DLTs
XTDB Datalog queries are used across an asset marketplace backed by Corda. Readily-integrated indexing from the existing Corda transaction network provides full query power across the entire market without the need to duplicate writes to XTDB’s native transaction log. Use of native Kotlin type integration enables flexible modeling and a GraphQL API.
Reconciliation engine for startup SaaS payments and subscription events
Using Valid Time, it was possible to implement a flexible subscription scheduling model by integrating API events across multiple payment gateways. Transaction Time provides an ideal audit mechanism for manual error resolution and intervention.
Bitemporality simplifies complex features like payment gateway integration and auditing. However, XTDB also serves as an uncomplicated, general-purpose database for other system tasks, such as persistence of Google OAuth tokens.
Easy-to-deploy analytics data query service using Kafka subscription events
An on-premises predictive analytics application for app telemetry monitoring was easy to build with XTDB using existing Kafka services across multiple enterprise installations. Thanks to the simplicity of XTDB’s data model, the rapid design and development of a Clojure application was possible in a primarily .NET organization.
Compliance & Privacy
Secure and auditable storage of healthcare data
Immutable, bitemporal records ensure all data can always be audited. At the same time, eviction operations are used to manage the handling of sensitive information, based on retention policies. New instances are easily deployed in approved environments.
Analyze complex graphs with declarative queries
Graph queries and cyclic pattern matching are essential components when creating fraud detection algorithms. XTDB enables powerful Datalog graph queries over integrated upstream data sources. Because XTDB is a general purpose database, horizontally scalable data analysis is possible without sacrificing consistency.
Multi-tenant whitelabel IoT sensor data platform
Powerful, flexible authorization is at the heart of this IoT data platform used for technical maintenance of precision industrial equipment. The platform enables predictive maintenance necessitating an immutable, time-oriented database to track historical IoT data.
Speculative transactions and extensive Datalog rules enforce easily configurable access policy controls.
No-Code Approach: The API-first design is future-proofed by completely avoiding the use of custom code to capture the business model. This allows for ad-hoc addition of new organization and user roles. The system behaviour is defined using JSON Schema and an OpenAPI-derived data service specification.
Auditable records for complex insurance products
A whitelabel business-to-business-consumer (B2B2C) insurance API platform that operates a multi-tenant cloud service to facilitate innovation in the broader market of insurance products.
Modeling complex insurance products using Datalog simplifies logic around perform eligibility checks, coverage assessments, and customer interactions. All of this is delivered in rapid development cycles using API-first development.
XTDB Sector Briefs
XTDB has broad application in a number of industries. Where a single case study does not do justice to the use of XTDB in a particular field, a sector brief explains its direct application to an entire category of businesses.
XTDB in HFT, forex, and predictive markets
XTDB enables your trading firm to unify relational data, event streams, and downstream analytics. Essential trade data, such as an event’s “knowledge time,” is inherently bitemporal. Without immutable, bitemporal trade and instrument records, this valuable data is lost forever.
Read more to see how XTDB can eliminate the risk of letting legacy databases dictate your position in the market.