JSON, Fractional-second Events and Generated Columns Available in Current ClustrixDB Release
Clustrix, the provider of the world’s leading scale-out SQL database announced that ClustrixDB 9 — the currently available release — handles sophisticated, modern data including semi-structured data, fractional-second events, and generated columns while simultaneously delivering the ClustrixDB advantages of performance, scalability without sharding or replication, and ACID compliance. ClustrixDB is for high-value, high-volume OLTP applications that need the scalability of a distributed database without sacrificing availability or data integrity ― applications such as e-commerce, social, SaaS, gaming and ad tech.
“Making the application developer’s job easier by putting functionality and logic into the database instead of application code has always been a significant part of the Clustrix mission,” said Mike Azevedo, CEO of Clustrix. “With ClustrixDB 9, developers who want to innovate do not have to choose between an RDBMS that has these features but does not scale well and a NoSQL database that has to relax availability and consistency in order to scale.”
Read more about ClustrixDB: https://www.clustrix.com/scaleout-database/
ClustrixDB 9.0 Modern Data Features
- JSON Support for Semi-structured and Schemaless Data ― ClustrixDB 9 supports a native JSON data type and functions for parsing data and indexes to support JSON queries based on the content within JSON data or documents. JSON data can be joined with transactional data while maintaining high scalability without replication or sharding and full ACID compliance without relaxing availability or consistency.
- Fractional Record and Event Timestamps to Support Microsecond Event Data ― ClustrixDB 9 supports storing dates and times with precision up to the microsecond, enabling applications to maintain the critical timestamp granularity needed for mobile, SaaS, gaming, ad tech, IoT, among others.
- Generated Columns for Commonly Calculated Values ― ClustrixDB 9 supports generated columns for calculated columns that can be virtual (calculated on the fly) or stored and indexed. Column values can be generated from other columns by defining expressions at the table level. Queries on generated columns automatically get the right value every time, changes to application logic can be reduced and commonly used values can be indexed for fast retrieval. Combined with ClustrixDB 9’s JSON support, developers can dynamically create indexes within JSON documents for better search and query performance.
Read more about ClustrixDB 9 https://www.clustrix.com/press-release/clustrix-adds-aws-availability-zone-multi-az-support-clustrixdb-9-0/
Clustrix delivers the world’s leading scale-out SQL database perfectly suited for high-value, high-performance OLTP applications that run on-premise or in the cloud. ClustrixDB is a drop-in MySQL replacement and is known for its on-demand scalability, high availability, resiliency, ACID compliance, and shared-nothing architecture. ClustrixDB avoids the expensive redesign and redevelopment of MySQL applications and data architectures required by the typical MySQL scaling techniques such as replication and sharding. ClustrixDB delivers more than twenty-five trillion transactions per month for customers including AOL, Nielsen, Twoo, and Rakuten. ClustrixDB is available in software that runs on commodity hardware and on any cloud. Clustrix is headquartered in San Francisco. For more information, visit www.clustrix.com.