XTDB in Production

Risk Systems

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

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.

Content Management

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

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.

Blockchain Systems

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.

Payments

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.

API Servers

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

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.

Fraud Systems

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.

Authorization

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.

Insurance Systems

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.