Database Reference
In-Depth Information
2.1
Business case
There are several reasons for migrating your SAP BW system to SAP HANA. The most im-
portant reasons are those that provide the greatest advantage to your business. The reasons
that provide the most impact include:
Superior performance with a smaller database footprint
More agile development and simpler maintenance
Landscape simplification and real-time reporting
These benefits drive a lower total cost of ownership (TCO), and they can be achieved by
migrating without reimplementation or disruption to your existing landscape or reporting
scenarios. Keep reading to take a closer look at the reasons for choosing SAP HANA.
2.1.1
Superior performance with a smaller database footprint
Just by migrating your existing system to SAP HANA you will achieve superior data loading
and query performance. On average, BW queries are at least nine times faster compared to
the same queries in an SAP BW system not running on HANA.
SAP HANA is fast
Based on data gathered from our projects to date, SAP HANA ex-
ecutes queries 9-23 times faster (16 times on average) than other data-
bases. So the minimum expected performance improvement is around
nine times faster for queries in HANA.
The increased speed of data access from external tools is also improved. For example, a
database with 1.2 billion rows of data returned aggregated results in BO Explorer in around
4.5 seconds. One study published by SAP found that Web Intelligence reports loaded ap-
proximately 12 times faster.
