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
Paessler: Easy to Use With Enterprise Power. Free Trial Icon
Paessler: Easy to Use With Enterprise Power. Free Trial

A low-code dashboard makes monitoring intuitive for any admin, while scripting and custom sensors give experts full control.

You shouldn't have to choose between a monitoring tool that's easy to use and one that's powerful enough for a complex environment. PRTG's low-code interface lets any admin build dashboards, set alerts and monitor devices without scripting, while custom sensors and full API access are there when your team needs deeper control. One platform, no compromise. Download a free 30-day trial now.
Get Free Download

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