Compare ClickHouse and Oracle Database

At a Glance
ClickHouse
ClickHouse
Star Rating
(21)4.4 out of 5
Market Segments
Small-Business (50.0% of reviews)
Information
Pros & Cons
Entry-Level Pricing
Starting at $1.00 Per Month
Learn more about ClickHouse
Oracle Database
Oracle Database
Star Rating
(1,001)4.3 out of 5
Market Segments
Enterprise (60.7% of reviews)
Information
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about Oracle Database
AI Generated Summary
AI-generated. Powered by real user reviews.
  • G2 reviewers report that Oracle Database excels in its ability to handle complex data integration tasks, with users noting its speed in processing and integrating previous employee information efficiently. This makes it a strong choice for enterprises needing robust data management.
  • Users say ClickHouse stands out for its exceptional query performance, particularly on large datasets. Reviewers highlight its columnar storage design, which significantly optimizes both storage and computation, making it ideal for real-time analytics workloads.
  • According to verified reviews, Oracle Database is praised for its multithreaded updates, which users find superior compared to other traditional RDBMS options like MySQL and DB2. This feature enhances performance in environments with heavy data loads.
  • Reviewers mention that ClickHouse is incredibly user-friendly, allowing for rapid querying of millions of rows in just seconds. Its SQL-like syntax, combined with a variety of procedural functions, makes it accessible for users familiar with SQL while offering advanced capabilities.
  • G2 reviewers highlight that while Oracle Database has a solid support structure, ClickHouse's support quality is also commendable, with users appreciating the responsiveness and helpfulness of the ClickHouse team, particularly for small business needs.
  • Users report that Oracle Database, while powerful, can be more complex to set up compared to ClickHouse, which boasts a simpler setup process. This ease of setup is a significant advantage for smaller teams or businesses looking to implement a database solution quickly.
Pricing
Entry-Level Pricing
ClickHouse
ClickHouse Pricing
Starting at $1.00
Per Month
Learn more about ClickHouse
Oracle Database
No pricing available
Free Trial
ClickHouse
No trial information available
Oracle Database
No trial information available
Ratings
Meets Requirements
9.0
12
9.0
722
Ease of Use
8.8
12
8.3
728
Ease of Setup
9.2
8
7.6
383
Ease of Admin
7.0
5
7.8
331
Quality of Support
8.5
10
8.3
691
Has the product been a good partner in doing business?
Not enough data
8.1
333
Product Direction (% positive)
10.0
11
8.2
691
Features by Category
Database Management Systems (DBMS)Hide 10 FeaturesShow 10 Features
8.9
7
Not enough data
Management
9.4
6
Not enough data
7.9
7
Not enough data
9.3
7
Not enough data
9.4
6
Not enough data
10.0
5
Not enough data
Maintenance
8.8
7
Not enough data
7.8
6
Not enough data
Not enough data
Not enough data
Security
Not enough data
Not enough data
Not enough data
Not enough data
9.0
6
8.8
572
Management
Not enough data
9.0
145
9.3
5
8.9
148
Feature Not Available
8.8
130
Not enough data
8.8
140
Support
Not enough data
8.4
142
Not enough data
8.9
145
Not enough data
8.7
143
Not enough data
8.8
141
Security
Feature Not Available
8.8
143
Not enough data
8.8
148
Not enough data
8.7
138
Not enough data
8.8
144
Performance
Not enough data
8.6
144
Not enough data
8.8
139
Not enough data
8.5
140
Not enough data
8.8
142
Not enough data
8.8
146
Database Features
9.0
5
9.0
499
9.3
5
9.0
503
9.0
5
8.9
509
9.0
5
8.7
501
Not enough data
9.0
499
Not enough data
8.7
491
8.7
5
8.9
497
8.5
9
Not enough data
Storage
9.2
6
Not enough data
9.0
7
Not enough data
Availability
Feature Not Available
Not enough data
7.8
6
Not enough data
8.3
6
Not enough data
Performance
8.1
6
Not enough data
Security
9.0
5
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
8.3
5
Not enough data
Support
Not enough data
Not enough data
Not enough data
Not enough data
Real-time Analytic DatabaseHide 10 FeaturesShow 10 Features
Not enough data
Not enough data
Query latency
Not enough data
Not enough data
Not enough data
Not enough data
Data latency
Not enough data
Not enough data
Not enough data
Not enough data
Connectors
Not enough data
Not enough data
Not enough data
Not enough data
Scale
Not enough data
Not enough data
Not enough data
Not enough data
Architecture
Not enough data
Not enough data
Not enough data
Not enough data
Database as a Service (DBaaS)Hide 17 FeaturesShow 17 Features
Not enough data
8.7
96
Configuration
Not enough data
8.8
92
Not enough data
8.3
87
Not enough data
8.6
89
Not enough data
8.4
84
Not enough data
8.9
88
Database Administration
Not enough data
8.4
86
Not enough data
8.8
83
Not enough data
8.9
85
Availability
Not enough data
8.9
87
Not enough data
9.0
89
Not enough data
8.8
83
Not enough data
8.7
84
Security
Not enough data
8.8
86
Not enough data
8.6
83
Not enough data
8.7
80
Data Management
Not enough data
8.9
81
Not enough data
8.7
80
Categories
Categories
Shared Categories
ClickHouse
ClickHouse
Oracle Database
Oracle Database
ClickHouse and Oracle Database are categorized as Relational Databases
Unique Categories
Oracle Database
Oracle Database is categorized as Database as a Service (DBaaS)
Reviews
Reviewers' Company Size
ClickHouse
ClickHouse
Small-Business(50 or fewer emp.)
50.0%
Mid-Market(51-1000 emp.)
40.0%
Enterprise(> 1000 emp.)
10.0%
Oracle Database
Oracle Database
Small-Business(50 or fewer emp.)
12.0%
Mid-Market(51-1000 emp.)
27.3%
Enterprise(> 1000 emp.)
60.7%
Reviewers' Industry
ClickHouse
ClickHouse
Information Technology and Services
35.0%
Computer Software
20.0%
Wholesale
5.0%
Telecommunications
5.0%
Marketing and Advertising
5.0%
Other
30.0%
Oracle Database
Oracle Database
Information Technology and Services
20.3%
Computer Software
11.3%
Financial Services
5.6%
Banking
5.1%
Hospital & Health Care
4.4%
Other
53.3%
Alternatives
ClickHouse
ClickHouse Alternatives
Google Cloud BigQuery
Google Cloud BigQuery
Add Google Cloud BigQuery
MySQL
MySQL
Add MySQL
Snowflake
Snowflake
Add Snowflake
Microsoft SQL Server
MS SQL
Add Microsoft SQL Server
Oracle Database
Oracle Database Alternatives
Amazon Relational Database Service (RDS)
Amazon Relational Database...
Add Amazon Relational Database Service (RDS)
IBM Db2
IBM Db2
Add IBM Db2
SAP HANA Cloud
SAP HANA Cloud
Add SAP HANA Cloud
Amazon Aurora
Amazon Aurora
Add Amazon Aurora
Discussions
ClickHouse
ClickHouse Discussions
Monty the Mongoose crying
ClickHouse has no discussions with answers
Oracle Database
Oracle Database Discussions
What is Oracle Database used for?
2 Comments
Abid Hussain A.
AA
Oracle Database is a relational database management system (RDBMS) that is widely used in the industry for managing and storing large volumes of data. It...Read more
What is the solution for extracting pdf data stored in DB in clob format
1 Comment
walter g.
WG
try APEXRead more
Why oracles was not up the mark in mobile arena.
1 Comment
walter g.
WG
All Oracle products have mobile versions. For development, try APEX.Read more