Comparison of SAP HANA with conventional database

All the database objects in SAP HANA system are maintained in the CATALOG folder in HANA Studio. Following are the key capabilities of SAP HANA database system −

• You can use a high-performance in-memory database for processing complex transactions and analytics. You can manage large database volumes in multitenant database containers.
• Using SAP HANA in-memory database component, you can run advanced analytical queries that are complex in nature that too with high-speed transactions to get the correct, up-to-date responses in a fraction of a second. SAP HANA in-memory db system removes the need of predefined aggregates, materialized views, and removes data duplicity between operation and transaction system and hence provides real-time analytics data.

Anil SAP Gupta

Published on 21-Feb-2018 17:52:20

• Related Questions & Answers
• Limitations covered by SAP HANA as compared to conventional database
• SAP HANA database functions in HANA Cockpit
• Use of _SYS_REPO in SAP HANA database
• Benefits of using SAP HANA database views
• Understanding a database view in SAP HANA database
• Finding a database view in SAP HANA database
• Getting age of tracefiles in SAP HANA database
• Meaning/Use of multi-tenant SAP HANA database
• Changing Ownership of schema in SAP HANA Database
• Unloading tables in SAP HANA database
• Database objects in SAP HANA Studio
• Using database view in SAP HANA
• Dropping a SAP HANA database view
• Changing storage type of table in SAP HANA database
• Example of creating a database view in SAP HANA