InfiniDB

InfiniDB

Database of Databases
+
+

Related Products

  • Google Cloud BigQuery
    2,027 Ratings
    Visit Website
  • DbVisualizer
    585 Ratings
    Visit Website
  • Google Cloud SQL
    554 Ratings
    Visit Website
  • RaimaDB
    12 Ratings
    Visit Website
  • Couchbase
    418 Ratings
    Visit Website
  • BidJS
    35 Ratings
    Visit Website
  • Crelate
    695 Ratings
    Visit Website
  • ClickLearn
    67 Ratings
    Visit Website
  • Arryved
    46 Ratings
    Visit Website
  • NewOrg
    124 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

Airbyte Supported
Arcade Supported
AtomicJar Supported
Azure Marketplace Supported
BI Book Supported
CelerData Cloud Supported
Colrows Supported
DataGrip Supported
DataHub Supported
FastReport Mono Supported
FastReport Online Designer Supported
Gravity Data Supported
Grouparoo Supported
Hue Supported
IBM watsonx.data Supported
NudgeBee Supported
Prisme Analytics Supported
Sematext Cloud Supported
WrenAI Supported
rakam Supported

Integrations

Airbyte Not Supported
Arcade Not Supported
AtomicJar Not Supported
Azure Marketplace Not Supported
BI Book Not Supported
CelerData Cloud Not Supported
Colrows Not Supported
DataGrip Not Supported
DataHub Not Supported
FastReport Mono Not Supported
FastReport Online Designer Not Supported
Gravity Data Not Supported
Grouparoo Not Supported
Hue Not Supported
IBM watsonx.data Not Supported
NudgeBee Not Supported
Prisme Analytics Not Supported
Sematext Cloud Not Supported
WrenAI Not Supported
rakam 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