Raijin has announced the release of version 1.2 of its powerful, schemaless SQL-like database engine. This version introduces significant performance improvements and usability enhancements.

Faster data ingestion and query performance

This release optimizes data ingestion by introducing partial parallelization. Raijin Database now parses and inserts batches of data simultaneously, resulting in up to 15% faster ingestion.

The team also addressed bottlenecks in the SELECT and COPY statements and implemented several optimizations to improve overall query performance.

Support for SQL views

Raijin Database now supports saving SQL queries as views for later use. You can reference a saved view from a SQL query in place of a subquery. Using saved views allows you to reuse recurring queries to reduce complexity and improve manageability.

Enhanced table partitioning

Table partitioning now supports updating the partitioning expression of a table, including tables that were previously not partitioned or tables already manually or dynamically partitioned. Other enhancements include:

  • The partition name and path have been updated to include a user-friendly name and the partitioning expression.

  • The PARTITION BY clause now supports the IN operator when creating a table.

  • The root partition is now the default partition.

  • The default partition will only be created if necessary, i.e., if data is inserted without a partition name and the table does not contain a partitioning expression.

Improved Ingestion API error reporting

The Raijin Ingestion API has been updated to provide a detailed error report when it fails to process ingested records. The Ingestion API response now includes the raw data, the record position in the batch, and the reason for each failure, in addition to the total failed records. This information allows for client-side error handling and reporting to ensure no log records are lost.

Collect logs with NXLog

As a database engine, Raijin is geared towards semi-structured data, making it a perfect solution for log storage. Log data is notoriously unstructured, making it hard to store in rigid table structures like traditional SQL systems.

Raijin complements NXLog’s powerful log collection and centralization solutions. With NXLog Enterprise Edition’s Raijin integration, you can seamlessly and easily send logs from NXLog Enterprise Edition to a Raijin database instance. The two fit hand in glove, providing the methods of capturing, processing, and storing log data for a complete log management solution.

Check out the Raijin release notes for a full breakdown of the features and improvements.

NXLog Platform is an on-premises solution for centralized log management with
versatile processing forming the backbone of security monitoring.

With our industry-leading expertise in log collection and agent management, we comprehensively
address your security log-related tasks, including collection, parsing, processing, enrichment, storage, management, and analytics.

Start free Contact us
Share
Related Posts