Amazon DynamoDB vs. Apache HBase

It is useful use-case by use-case. For our use case, it was the best and easiest option for the integration as well as development side. It is serverless so no need of deployment and maintenance hustle. It is easy to scale up due to the same functionality. Supports AWS Security features and just a click away for enabling it so security is good.

Incentivized

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

• It's very easy to get started, creating a table with a partition/sort key and you're on your way.
• You can scale up and down your read/write IO as needed.
• You can store structured and unstructured data.
• It works great with Web Development as it's JSON based.

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

• Cost model may not be easy to control and may lead to higher costs if not carefully planned
• Indexing may be a cost culprit when not planned, because it's not included on the data costs
• The Query Language may not fulfill everybody's expectations, as it has less features than those of competitors.

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

It's core to our business, we couldn't survive without it. We use it to drive everything from FTP logins to processing stories and delivering them to clients. It's reliable and easy to query from all of our pipeline services. Integration with things like AWS Lambda makes it easy to trigger events and run code whenever something changes in the database.

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

Functionally, DynamoDB has the features needed to use it. The interface is not as easy to use, which impacts its usability. Being familiar with AWS in general is helpful in understanding the interface, however it would be better if the interface more closely aligned with traditional tools for managing datastores.

Incentivized

While the actual performance of DynamoDB can vary based on workload and region, it is generally highly responsive and well-regarded for delivering low-latency access to data, making it a strong choice for applications with stringent performance requirements. Organizations often choose DynamoDB for its ability to provide a reliable and performant database service, particularly when combined with effective application design and optimization.

Incentivized

I have not had to contact support for this service, however I have had to contact AWS for other services and their support has been good.

Incentivized

For our use case, we needed a noSQL that would work with AWS Lambdas of specific parts of the internal web applications. We optimized billing and uses , diversified databases for various parts; so it’s not very expensive.

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 have taken one point away due to its size limits. In case the application requires queries, it becomes really complicated to read and write data. When it comes to extremely large data sets such as the case in my company, a third-party logistics company, where huge amount of data is generated on a daily basis, even though the scalability is good, it becomes difficult to manage all the data due to limits.

Incentivized

• Businesses may only pay for the services they actually use thanks to DynamoDB's usage-based pricing approach.
• AWS handles hardware provisioning, data recovery, fault tolerance, patching, and database upgrades for DynamoDB since it is a fully managed database service.
• DynamoDB differs from conventional relational databases in terms of its data model, which might be difficult for developers accustomed to dealing with SQL-based systems.

Incentivized

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

Incentivized