Crux is becoming XTDB!

You can read the rename announcement, or head to this page on the new XTDB site (where you'll be taken in 10 seconds).

Solutions

Case studies and success stories.
#ecommerce

Pricing Management

Price calculation service for an automotive components catalog to support supply chain operations of a €300m+ revenue eCommerce distributor

Source: JUXT Project

Modeling future pricing changes requires bitemporal data. Valid Time is used to model scheduled changes to discount rules and 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 Crux a convenient addition to the technology landscape.

Risk Systems

End-of-Day risk calculations for trading desks across global regions

Source: JUXT Project

Risk Systems benefit directly from bitemporal modeling, for example, where 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 like this 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. Crux can handle your live data.

#finance #banking
#enterprise-apps

Modular CRM Platform

Consolidated database system for SaaS, Cloud-managed and on-premises variations of an enterprise CRM product

Source: Community

Avisi Apps build Atlassian Marketplace applications such as Atlas CRM, which integrate closely with Jira.

Eliminate 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 Crux'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

Powerful yet simple & stable API helps startups to rapidly explore new ideas

Source: Community

Crux 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 Crux, 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, Crux is one of those pieces of software that sparks joy.” — Jacob O'Bryant, Founder

#startups
#enterprise #big-data

Temporal Metadata Management

Temporal storage for the Linux Foundation's Open Metadata and Governance platform

Source: Community

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 Crux from an existing non-temporal graph backend, to support innovative temporal functionality whilst 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 relationships and Lucene full-text search.

Blockchain Systems

Graph queries for immutable financial transaction data and distributed ledger technologies

Source: JUXT Project

Crux graph queries are used across an asset marketplace backed by Corda. Readily-integrated indexing from the existing Corda transaction graph provides full query power across the entire market without the need to duplicate writes to Crux's native transaction log. Use of native Kotlin type integration enables flexible modeling and a GraphQL API.

#fintech
#ecommerce

Payments

Reconciliation engine for startup SaaS payments and subscription events

Source: Community

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.

While bitemporality simplifies complex features like payment gateway integration and auditing, Crux also serves as an uncomplicated, general-purpose database for tasks, such as persistence of Google OAuth tokens.

API Servers

Easy-to-deploy analytics data query service using Kafka

Source: JUXT Project

An on-premises predictive analytics application for app telemetry monitoring was easy to build with Crux using existing Kafka services across multiple enterprise installations. Thanks to the simplicity of Crux's data model, the rapid design and development of a Clojure application was possible in a primarily .NET organization.

#startups
#healthcare

Compliance & Privacy

Secure and auditable storage of healthcare data

Source: Community

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

Analyze complex graphs with declarative queries

Source: Community

Graph queries and cyclic pattern matching are essential components when creating fraud detection algorithms. Crux enables powerful Datalog graph queries over integrated upstream data sources. Because Crux is a general purpose database, horizontally scalable data analysis is possible without sacrificing consistency.

#banking #insurance
#manufacturing

Authorization

Multi-tenant whitelabel IoT sensor data platform

Source: JUXT Project

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.

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

Auditable records for complex insurance products, eligibility checks, coverage assessments, and customer interactions

Source: Community

180° is 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 and immutable graph semantics enables rapid development cycles and API-first development.

#insurance #startups