ClickHouse is an open-source, column-oriented OLAP database system enabling real-time analytical reports using SQL queries. With linear scalability, it handles trillions of rows and petabytes of data. ClickHouse Cloud offers a scalable serverless solution for real-time analytics.
N/A
Oracle Exalogic
Score9 out of 10
N/A
Oracle's Exalogic is a converged infrastructure appliance.
N/A
Pricing
ClickHouse
Oracle Exalogic
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
ClickHouse
Oracle Exalogic
Free Trial
Yes
No
Free/Freemium Version
Yes
No
Premium Consulting/Integration Services
Yes
No
Entry-level Setup Fee
Optional
No setup fee
Additional Details
Pay for what is used:
It automatically scales up and down compute resources based on the user's workload
It scales storage and compute separately
It automatically scales unused resources down to zero so that users don’t pay for idle services
The most important thing when using ClickHouse is to be clear that the scenarios in which you want to use it really are the right ones. Many users think that when a database is very fast for a specific use case, it can be extrapolated to other contexts (most of the time different) in which a previous analysis has not been carried out.
ClickHouse is an analytical database, as such, it should be used for such purposes, where the information is stored correctly, the data volumes are really large and the queries to be performed are not the typical traditional queries on several columns with multiple aggregations. ClickHouse is not the solution for this.
On the other hand, if your case is not one of the above, it is quite possible that ClickHouse can help you. Where ClickHouse shines is when you are looking for aggregation over a particular column in large volumes of data.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Oracle Exalogic in conjunction with an Oracle Exadata based platform is what I would consider the best of breed solution; however the performance may be overkill for what you need. Don't spend the money unless you need the performance, Oracle offers other solutions at a much lower cost. Purchase what you need not what's the shiny new product.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Their MergeTree table engine provide impressive performance for data insert in bulk
Not only data insert but also the way MergeTree engine uses Primary Keys to sort the data and perform data skipping based on the granules its also their secret for ridiculous fast queries
Data compression its also great
They provide especial table engines that allow you to read data directly from other sources like S3
Since its written with C++ you have very granular data types and especial ones like enum, LowCardinality and etc, they save you a lot of storage since are stored as integer values
ClickHouse functions besides the ones that respect ANSI Standards are also awesome and useful
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Private Cloud: in the virtual configuration, you can create several accounts and assign different resources (vCPU, RAM, etc.) to several departments in your organization.
SDP & Infiband: Oracle Exalogic can be connected to Oracle Exadata using Infiniband Fabric, to take advantage of high bandwidth and low latency network to connect Weblogic to Oracle Database.
Standardization: Oracle Weblogic Server running on Oracle Exalogic is the same software running on a normal Linux machine, so you can easily move Java applications without changing it, and immediately benefit from the Exalogic Optimizations.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Currently, the management of Exalogic is a little arcane. There is a good chance that Oracle can bring flexibility into the control stack because we have seen changes with each version of the software Echo was an improvement and foxtrot even more so. The ability to easily change VM shapes was another welcome change.
Again the fact arises that to build a very high performance machine there will be idiosyncrasies and a certain amount of retraining may be required. I think this is one area where Exalogic lacks not as a product but as a solution is that there isn't as much good knowledge available about it as there is for other engineered systems.
The Exalogic default setup could do with an SSD storage option, currently the onboard comes with a spinning disk.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
It is a very condensed version of what used to be rows of servers. I like that storage, networking and compute nodes fit in one rack. The power and the software are top notch. The only problem is cost. You need to do some serious processing to get the true value out of the Exalogic system.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
ClickHouse outperforms, especially in costs, since its compression/indexing engines are so smart, and even with very low computing power, you can already perform huge analyses of the data.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
It's hard to compare Oracle Exalogic Engineered Systems with anything else on the market. It's so purpose built for application performance and intended to be used in conjunction with other Oracle Engineered Systems. As I alluded to earlier in this review the cost may not be worth the investment if the performance isn't needed. Oracle offers other solutions like the Oracle PCA which will meet the need for licensing compliance at a much lower cost of ownership and may fit better into your current infrastructure.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
