Apache HBase vs. InterSystems Caché (legacy product)

HBase is well suited for streaming ingest, fast lookups, massive datasets, data warehouse lookup tables, RDBMS replacement, MongoDB replacement, key-value store, data scans, logs, JSON storage and some binary storage. My preferred use case is for storing data points like time series or data produced by sensors. I often use HBase when I need data available immediately and I am not looking for transactions. This is a great store for really wide tables with tons of columns. It is also great if you are not sure what type of data you are going to have. It really excels at sparse data.

Incentivized

Great for a one for all, heavy bundled, and licensed solution. When trying to evolve and scale, it can be very limiting. Think future proof as something that fits now could be hard to change later and work around.

Incentivized

• Scalable and truly non-relational data
• HBase operations run in real-time on its database rather than MapReduce jobs
• Scales linearly to support billions of rows with millions of columns

Incentivized

• Fast development
• the language light to learn.
• Different ways to access data
• Good internal documentation, which is also available online.

Incentivized

• Write performance
• Performance support for parquet file format. supports, but performance wise still not there
• API / library availability for spark, rather than creating a new library for it

Incentivized

• The great functionality hides behind an old UI that can be cumbersome to navigate, making Cache configurations take more time.
• The easy installs of Cache need specific setups to work well, and if yours is unique or if your servers are highly specialized on a networking level in terms of ports, VMs, or otherwise, then there may be some difficulties getting things to work.

Incentivized

There's really not anything else out there that I've seen comparable for my use cases. HBase has never proven me wrong. Some companies align their whole business on HBase and are moving all of their infrastructure from other database engines to HBase. It's also open source and has a very collaborative community.

Incentivized

Compared NoSQL databases with traditional databases for faster retrieval and consistency. As MongoDB is a NoSQL supports dynamic fields, however, query performance is bad for aggregations and added maintenance. When compared with MySQL and Teradata, it could not scale up as fast as Hbase and added cost involved to it. HBase can be easily scalable to a huge volume of records, have a faster lookup and provides consistency

Incentivized

I've only worked with products that do one thing before, but there's so much that Cache offers versus piecing different services together manually. Not only does the product offer a more robust tool-set, but the support is wonderful and I've never encountered a better vendor in any industry in terms of how well they interact with their customers and care about helping you solve your problems. They want you to grow and to get better.

Incentivized

• Positive: Open source, easy to use, good to store big data.
• Negative: SQL functionalities are not available.
• More memory utilization
• More troubleshooting

Incentivized

• A fast ROI due to its rapid programing language allowing the developers to write reliable code in a very short period of time.

Incentivized