IBM Db2 Database and SAP HANA compete in the database solutions category, both offering compelling features. SAP HANA has the upper hand with its advanced in-memory processing capabilities that enhance speed and real-time data analytics.
Features: IBM Db2 offers a powerful structured query language, compatibility across multiple platforms, and self-tuning memory management, making it a reliable and stable choice. SAP HANA is known for its in-memory database, facilitating fast processing speeds and efficient data storage, which are ideal for real-time analytics and large-scale applications.
Room for Improvement: IBM Db2 could benefit from addressing its complexity, licensing issues, and integration challenges. SAP HANA users highlight the need for improvements in customization, support, and affordability, as the high cost is a recurring concern.
Ease of Deployment and Customer Service: IBM Db2 primarily offers on-premises deployment with dependable customer support, although some users face delays. SAP HANA provides flexibility with deployment across hybrid and private cloud environments, but its service, despite being knowledgeable, can involve high wait times.
Pricing and ROI: IBM Db2 is known for its expensive pricing but is still more affordable than Oracle, and it offers good ROI through stable performance. Although SAP HANA is costly, its rapid data processing and functionality provide value, making the investment worthwhile for many businesses. However, the price might limit accessibility for smaller enterprises.
We do not feel we're getting value for the investment due to the additional resources needed for integration and maintenance.
SAP HANA is a cost-saving solution that helps save money and serves as a time-saving solution that helps save time.
We normally receive substantial discounts on the price.
The community support is better than the official SAP support.
While issues are resolved eventually, the first level of support is not as good as we would like.
Time to respond to SAP support is an issue, and finding the right person and handling the whole process are problems too.
Our operations have grown from a hundred data operations a day to as many in a couple of seconds.
The scalability rating is based on the ability to expand.
There is enough scalability offered by SAP to meet our deployment needs.
We recently faced customer data loss during the cluster handover or failover fallback.
We have not had any problems in the last seven to eight years.
Regarding stability, they are using legacy systems and have implemented SAP HANA.
It might be slightly slower than other database vendors, but it works well since banks typically do not move quickly with leading-edge technology.
The main issue is the ecosystem, which lacks the widespread support that SQL enjoys.
The problem is the price; it's too expensive for what it actually delivers.
Many customers still prefer Oracle, possibly due to cost or familiarity, despite SAP mandating that they have to go to SAP HANA.
It's a recurring subscription model, which is expensive compared to legacy systems with just a maintenance fee.
The pricing of SAP HANA is quite expensive.
I would rate the price for SAP HANA as high.
IBM Db2 Database, because of enterprise performance and support, is why banks still maintain their relationship with it.
The IBM Db2 Database is trusted, and IT effort is less than any other product.
The concept enhances speed, allowing the database to serve and move data quickly.
It allows some tables to be stored in a column base, others in a row base, and the In-Memory functionalities are mostly the highlight of SAP HANA, especially compared to disk-based memory users.
This architecture allows for faster data processing and real-time analytics that were not possible with traditional databases.
| Product | Market Share (%) |
|---|---|
| SAP HANA | 9.6% |
| IBM Db2 Database | 7.6% |
| Other | 82.8% |
| Company Size | Count |
|---|---|
| Small Business | 20 |
| Midsize Enterprise | 13 |
| Large Enterprise | 48 |
| Company Size | Count |
|---|---|
| Small Business | 26 |
| Midsize Enterprise | 11 |
| Large Enterprise | 61 |
SAP HANA, also known as SAP High-performance Analytics Appliance, is a multi-model database that stores data in its memory, allowing users to avoid disk storage. The product combines its robust database with services for creating applications. SAP HANA is faster than other database management systems (DBMS) because it stores data in column-based tables in main memory and brings online analytical processing (OLAP) and online transaction processing (OLTP) together.
The column-oriented in-memory database design allows users to run high-speed transactions alongside advanced analytics, all in a single system. This provides companies with the ability to process very large amounts of data with low latency and query data in an instant. By combining multiple data management capabilities, the solution simplifies IT, helps businesses with innovations, and facilitates digital transformation.
The solution is structured into five groups of capabilities, categorized as:
There are three more SAP products that work alongside SAP HANA and complete the experience for users together. SAP S/4HANA Cloud is a ready-to-run cloud enterprise resource planning (ERP). SAP BW/4HANA is a packaged data warehouse, based on SAP HANA, which allows users to consolidate data across the enterprise to get a consistent view of their data. Finally, SAP Cloud is a single database as a service (DBaaS) foundation for modern applications and analytics across all enterprise data. All three products can combine with SAP HANA to deliver to users an optimized experience regarding their data.
SAP HANA Features
Each architectural group of capabilities of SAP HANA has various features that users can benefit from. These include:
SAP HANA Benefits
SAP HANA provides many benefits for its users. These include:
Reviews from Real Users
According to a database consultant at a pharma/biotech company, SAP HANA is a very robust solution with good data access.
Bruno V., owner at LAVORO AUTOM INF E COM LTDA, likes SAP HANA because the product offers advanced features, helps reduce hours, and makes it easy to find what you need.
We monitor all Relational Databases Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.
