InfiniDB

InfiniDB

Database of Databases
+
+

Related Products

  • Google Cloud BigQuery
    2,027 Ratings
    Visit Website
  • DbVisualizer
    593 Ratings
    Visit Website
  • Google Cloud SQL
    554 Ratings
    Visit Website
  • RaimaDB
    12 Ratings
    Visit Website
  • Couchbase
    417 Ratings
    Visit Website
  • BidJS
    37 Ratings
    Visit Website
  • Crelate
    699 Ratings
    Visit Website
  • Muzaic
    2 Ratings
    Visit Website
  • ClickLearn
    67 Ratings
    Visit Website
  • Arryved
    46 Ratings
    Visit Website

About

ClickHouse is a fast open-source OLAP database management system. It is column-oriented and allows to generate analytical reports using SQL queries in real-time. ClickHouse's performance exceeds comparable column-oriented database management systems currently available on the market. It processes hundreds of millions to more than a billion rows and tens of gigabytes of data per single server per second. ClickHouse uses all available hardware to its full potential to process each query as fast as possible. Peak processing performance for a single query stands at more than 2 terabytes per second (after decompression, only used columns). In distributed setup reads are automatically balanced among healthy replicas to avoid increasing latency. ClickHouse supports multi-master asynchronous replication and can be deployed across multiple datacenters. All nodes are equal, which allows avoiding having single points of failure.

About

InfiniDB is a column-store DBMS optimized for OLAP workloads. It has a distributed architecture to support Massive Paralllel Processing (MPP). It uses MySQL as its front-end such that users familiar with MySQL can quickly migrate to InfiniDB. Due to this fact, users can connect to InfiniDB using any MySQL connector. InfiniDB applies MVCC to do concurrency control. It uses term System Change Number (SCN) to indicate a version of the system. In its Block Resolution Manager (BRM), it utilizes three structures, version buffer, version substitution structure, and version buffer block manager, to manage multiple versions. InfiniDB applies deadlock detection to resolve conflicts. InfiniDB uses MySQL as its front-end and supports all MySQL syntaxes, including foreign keys. InfiniDB is a columnar DBMS. For each column, InfiniDB applies range partitioning and stores the minimum and maximum value of each partition in a small structure called extent map.

Platforms Supported

Windows Not Supported
Mac Not Supported
Linux Not Supported
Cloud Supported
On-Premises Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Platforms Supported

Windows Not Supported
Mac Not Supported
Linux Supported
Cloud Not Supported
On-Premises Not Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Audience

Companies of all sizes

Audience

Developers, professionals, and enterprises seeking a column-store database solution optimized for OLAP workloads

Support

Phone Support Not Supported
24/7 Live Support Not Supported
Online Not Supported

Support

Phone Support Not Supported
24/7 Live Support Not Supported
Online Supported

API

Offers API Not Supported

API

Offers API Not Supported

Screenshots and Videos

Screenshots and Videos

Pricing

No information available.
Free Version Supported
Free Trial Not Supported

Pricing

No information available.
Free Version Not Supported
Free Trial Not Supported

Reviews/Ratings

Overall 5.0 / 5
ease 3.0 / 5
features 4.0 / 5
design 5.0 / 5
support 5.0 / 5

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Pros & Cons from Real Users

Pros

  • ClickHouse is really really fast. I can say that it is THE fastest I've came across. It has lots of native integration options S3, Kafka, SQLite, PostgreSQL and so on. Its SQL capabilities are top notch. And it is 100% free!

Cons

  • - Updates and deletes are eventual. - Hard to setup a cluster. - Does not have ACID.

Training

Documentation Not Supported
Webinars Not Supported
Live Online Not Supported
In Person Not Supported

Training

Documentation Supported
Webinars Not Supported
Live Online Not Supported
In Person Not Supported

Company Information

ClickHouse
Founded: 2021
United States
clickhouse.com

Company Information

Database of Databases
Founded: 2000
United States
dbdb.io/db/infinidb

Alternatives

Alternatives

InfiniGuard

InfiniGuard

Infinidat
InfiniTime 7.0

InfiniTime 7.0

Inception Technologies
InfiniBox

InfiniBox

Infinidat
Infiny

Infiny

Epsilon Telecommunications
CelerData Cloud

CelerData Cloud

CelerData
TrinityX

TrinityX

Cluster Vision

Categories

Categories

Integrations

Acryl Data Supported
BI Book Supported
ChartDB Supported
ElevateHQ Supported
FastReport .NET Supported
Formal Supported
HubiFi Supported
Hydrolix Supported
ILLA Cloud Supported
Latitude Supported
Nucleon Database Master Supported
One-IoT Device Management Supported
Peaka Supported
Ploy Supported
PopSQL Supported
Prisme Analytics Supported
RudderStack Supported
SIEM Compliance Supported
SQL Supported
Streamkap Supported

Integrations

Acryl Data Not Supported
BI Book Not Supported
ChartDB Not Supported
ElevateHQ Not Supported
FastReport .NET Not Supported
Formal Not Supported
HubiFi Not Supported
Hydrolix Not Supported
ILLA Cloud Not Supported
Latitude Not Supported
Nucleon Database Master Not Supported
One-IoT Device Management Not Supported
Peaka Not Supported
Ploy Not Supported
PopSQL Not Supported
Prisme Analytics Not Supported
RudderStack Not Supported
SIEM Compliance Not Supported
SQL Not Supported
Streamkap Not Supported
Claim ClickHouse and update features and information
Claim ClickHouse and update features and information
Claim InfiniDB and update features and information
Claim InfiniDB and update features and information