LeanXcale

LeanXcale database is the result of 20 years of research. LeanXcale is a SQL database with real-time aggregation with no contention.

LeanXcale is designed to accelerate batch processing, provide real-time analytics, and perform scalable operational workloads.

 
 

SQL Database

LeanXcale provides JDBC, ODBC, and BDAPI drivers

LeanXcale is simple to use. Migration processes are very straightforward. LeanXcale can use the complete SQL ecosystem.
 

SQL Ansi 2003

LeanXcale provides a full 2003 ANSI-compliant SQL interface to facilitate the migration from other databases, allowing the user to take advantage of all the SQL tools.

Check our SQL reference..

BI integrations

LeanXcale can integrate with the most popular BI tools, such as QLink, SAS, Tableau, Apache Superset, or Power BI, through OData, ODBC, or JDBC interface.

 

 Efficient Primary & Secondary Indexes

LeanXcale provides primary indexes. Also, LeanXcale supports efficient secondary indexes that are distributed and connected to primary data. Queries over secondary indexes can retrieve the primary data locally and provide the entire result with the minimum number of round trips.
 

Complete JOIN Support

Perform JOIN operations to combine data from multiple tables. LeanXcale supports any type of JOINS, including INNER JOINs, LEFT JOINs, RIGHT JOINs, or FULL JOINs. Its SQL capabilities provide flexibility and efficiency to extract valuable insights from your relational data.

Covering indexes

LeanXcale provides covering indexes that boost the response time. So, this helps to avoid the round trip to the table to satisfy the request, seeing as all the requested columns exist in the non-clustered index itself.
 

Linear scalability from MVP to global 

RUN ON A SINGLE PC OR IN 100S OF SERVERS, WHILST MAINTAINING A LINEAR PERFORMANCE

Process up to millions of transactions per second. Grow as the business needs the same cost per transaction, even for hundreds of nodes. Reduce CAPEX on development by increasing the architecture life.

Watch LeanXcale running on a cluster of 1, 10, and 100 nodes.

Great linear scalability

Traditional ACID databases either do not scale out linearly, or do not scale out at all. LeanXcale has developed the patented technology to scale out linearly, with no bottleneck, from a single server to hundreds. It uses a distributed algorithm that processes transactions in parallel, whilst always staying ACID-compliant.


Watch this video and learn how the full algorithm works, as explained by its creator. Read and learn how it works.
icon_three layers.png

Distributed architecture

LeanXcale, like any other relational database, has three layers: store, transactional, and query engine. The three layers are completely distributed and can scale independently.

Learn more.

 Predicate push-down

LeanXcale is a fully distributed database. When a Query Engine performs a JOIN, all the predicates can be pushed down to several storage engines, improving the performance and avoiding costly data movements.

Parallel Scans

Leanxcale can improve massive data queries. It can reduce the latency and take advantage of user infrastructure by parallelizing scan operations over large tables that are split across several store engines.

Elastic behaviour

LeanXcale has a novel, non intrusive data migration algorithm that allows data to be moved from one server to another without disrupting operations, even while it is being updated and, moreover, retains full ACID consistency. LeanXcale can grow or shrink with zero downtime to meet current needs.
 

Online aggregations

Compute KPIs in real-time thanks to a patented tecnology 

LeanXcale enables the addition of values of several inserts in a specific row in real-time as part of the insertion transaction without any contention or conflict. Aggregation computing is performed online during insertion, so aggregates are calculated in real-time. The desired result is attained by simply reading a row.

More info here.
 

Fast ingestion even for great volumes   

The disruptive store engine design enables an ingestion 72-faster than the SQL database market leader.

Ultra-efficient store engine single-thread design avoids expensive context switches, thread synchronization, and NUMA remote memory accesses. It takes advantage of 20+ years of operating systems research.

Watch its performance in this demo.
 

Cache Management

LeanXcale can balance data in-memory and disk to optimize the balance for performance and cost.

Near costless MVCC

Modern databases use multi-version concurrency control (MVCC) to avoid conflicts between reads and writes. However, MVCC requires the removal of obsolete versions. LeanXcale's MVCC uses a new approach that is almost costless and does not create issues with any update rate.

Check out this benchmark.
 

Compression

Use ZFS file system compression and optimize the resources' usage for storing high volumes of data.

Ultra-efficient

The store engine single-thread design avoids expensive context switches, thread synchronization, and NUMA remote memory accesses. It takes advantage of 20+ years of operating systems research

Watch its performance in this demo.

Distributed storage

Distribute your data table along the different storage engines to get fast parallel scans and inserts. Distribution could be using an horizontal PK partitioning, according to several dimension partioning or using hashing.

New data structure

Prior to LeanXcale, there had been a duality between SQL databases and key-value data stores: SQL databases, using B+ trees, have been more performant for range queries. Key-value data stores, with LSM trees, have been more efficient for data ingestion. LeanXcale uses a novel data structure that is as efficient as B+-trees for range queries, and as efficient as LSM-trees for random updates/inserts. To learn more.

Bidimensional partitioning

As soon the memory cannot handle the workload, IO increments, and throughput reduces. LeanXcale is optimized to work with large fact tables. To partition the data in several dimensions, making clever use of cache and increasing the data locality in the searches.

Learn how it works.
 

High Availability

Execute critical applications

Operational databases require secure environments. LeanXcale ensures the execution in critical environments due to its active-active high availability.
 

Efficient High Availability

Active-active high availability is a typical bottleneck for databases. LeanXcale has developed a new replication algorithm based on our scalability patent with no overhead and bottleneck-free.

Check out how it works.

In-same-transaction Replication

It is common in asynchronous execution that you write information and when you read it on another server, it is not available. In this situation it is not possible to guarantee performance during a downtime. LeanXcale writes to the replica as part of the same transaction, so replication is transparent to you.

Automatic Query Balancing

LeanXcale manages the end-user requests to balance the workload among different servers transparently.
 

Deploy LeanXcale Clusters Anywhere

USE COMMODITY HARDWARE

LeanXcale has a shared-nothing architecture that enables it to run anywhere: on a commodity bare-metal cluster, on a container, as OEM, as Database as a Service, or on a private cloud.
 
 
 

Integrate it with your applications

Use it with your Java and Python applications

LeanXcale provides drivers for the most popular languages and platforms.
 

World-class management and monitoring

POWERFUL TOOLS THAT BOOST THE PERFORMANCE OF ANY DEVOPS TEAM

LeanXcale is a database engine that works in your critical systems. Set up your system through a console. Keep track of its performance to ensure the best quality.

On-prem Version Monitoring

LeanXcale provides an integrated monitoring dashboard, based on Prometheus and Grafana, out of the box. Additionally, LeanXcale exposes a series of metrics to third-party systems through JMX and as Prometheus custom exporters.

Learn more here.

24x7 Supported DBaaS

LeanXcale offers 24x7 support for its Database as a Service (DBaaS), ensuring that users have access to assistance and assistance around the clock. This means that no matter when an issue arises or assistance is needed, LeanXcale's support team is available to provide help and address any concerns, enhancing the reliability and availability of your database operations.

Learn more about our comprehensive support offerings here.

Cold and Hot Backup

LeanXcale, evenly distributed, has hot backups capability. .Cold and hot backup allow seamless data recovery in the event of system failures or application errors.

Read more here.
 

Security and compliance

MEET ANY COMPLIANCE REQUIREMENT

Security is an important aspect of any application. However, some of them have critical data, with special security restrictions to be handled because of business or legal requirements (e.g., banking, insurance or health). LeanXcale provides the highest standard to be compliant with any requirement.

Read the details about LeanXcale's security.
 

Communication encryption

Activate SSL/TLS encryption for any external connection and, depending on the deployment and security level of your application, you can enable SSL/TLS for connections between internal database components.
 

Access control

LeanXcale can provide role-based access control, per user, and individual permission level. LeanXcale can integrate authorization with an enterprise level LDAP

Auditing

LeanXcale also offers robust auditing capabilities to help organizations track and monitor database activities for security and compliance purposes.
 

Data storage encryption

LeanXcale, encrypting all the information using AES and meeting the highest standards.
 
 

​​LeanXcale migration tools, training and professional services

MAKE AN EFFORTLESS TRANSITION TO AN EASY-TO-MIGRATE SQL DATABASE

LeanXcale provides a set of tools, compatibility capabilities and services to migrate transparently from your current database to LeanXcale.
Easy model and data duplication: Since LeanXcale is a SQL database with JDBC driver and it provides fast ingestion rates, it integrates with standard tools such as AWS Glue or using LeanXcale loader to duplicate a schema and data in LeanXcale easily.
Transparent adaptor: LeanXcale is a 2003 ANSI SQL-compliant database. However, some proprietary database extension could be in need of translation. The transparent adaptor allows this to be done dynamically, with no code changes.
Professional services to migrate: LeanXcale can help in the migration process through a turn-key project by LeanXcale or a Partner, with an end-to-end migration, or with active support with weekly meetings to reply to inquiries and propose solutions.
Training: LeanXcale provides on-demand training, certification, and knowledge transfer programs. LeanXcale offers pools for hours to solve complex inquiries or design complex scenarios.
Remote administration: Leanxcale provides a solution tailored to each customer that provides a proficient extension of your team and improves your performance and reliability. Leanxcale offers 24x7 Support for a fixed monthly pricing.
 

Other workloads

A VERSATILE DATABASE

LeanXcale is a versatile database that performs highly for GIS, time series, or machine learning.

Scalable GeoTempory

Execute complex geographical queries at any scale while under high-rate data ingestion. LeanXcale can efficiently handle large volumes of geographical data while supporting numerous parallel geographical requests.

Watch it in this demo.

Geohash filters

Thanks to a new geo-hash-based filtering algorithm specially designed for LeanXcale, it can offer high-performance behavior over queries containing geographical functions.

Read this benchmark.

ML integration

Integrate with your favorite Machine Learning Toolkit: R, Pandas, Tensorflow, or Spark.

Read this post.
 

Do you have any queries? Would you like to request enhancement?