InfiniDB Description

InfiniDB is a column-oriented database management system specifically designed for online analytical processing (OLAP) workloads, featuring a distributed architecture that facilitates Massive Parallel Processing (MPP). Its integration with MySQL allows users who are accustomed to MySQL to transition smoothly to InfiniDB, as they can connect using any MySQL-compatible connector. To manage concurrency, InfiniDB employs Multi-Version Concurrency Control (MVCC) and utilizes a System Change Number (SCN) to represent the system's versioning. In the Block Resolution Manager (BRM), it effectively organizes three key structures: the version buffer, the version substitution structure, and the version buffer block manager, which all work together to handle multiple data versions. Additionally, InfiniDB implements deadlock detection mechanisms to address conflicts that arise during data transactions. Notably, it supports all MySQL syntax, including features like foreign keys, making it versatile for users. Moreover, it employs range partitioning for each column, maintaining the minimum and maximum values of each partition in a compact structure known as the extent map, ensuring efficient data retrieval and organization. This unique approach to data management enhances both performance and scalability for complex analytical queries.

Integrations

Reviews

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

Company Details

Company:
Database of Databases
Year Founded:
2000
Headquarters:
United States
Website:
dbdb.io/db/infinidb

Media

InfiniDB Screenshot 1
Recommended Products
99.99% Uptime for MySQL and PostgreSQL Databases Icon
99.99% Uptime for MySQL and PostgreSQL Databases

Sub-second maintenance. 2x read/write performance. Built-in vector search for AI apps.

Cloud SQL Enterprise Plus delivers near-zero downtime with 35 days of point-in-time recovery. Supports MySQL, PostgreSQL, and SQL Server.
Start Free

Product Details

Platforms
Linux
Types of Training
Training Docs
Customer Support
Online Support

InfiniDB Features and Options

InfiniDB User Reviews

Write a Review
  • Previous
  • Next