What is the HANA database?

The SAP HANA database is an in-memory, column-oriented, relational database management system. It stores all data in-memory (RAM) and in a compressed columnar format. It is very fast; hence it does not require sums, indexes, materialized views, or aggregates. This reduces the database footprint. Everything is calculated on-demand and in the main memory. This makes it possible for companies to run online transaction processing (OLTP) and analytics applications (OLAP) on the same instance at the same time.

Was this answer helpful?


Top Questions & Answers

Related FAQs

  • How do you access SAP HANA?
    There are many ways of access the SAP HANA database. The SAP HANA Cloud platform is a commonly used solution for SAP HANA app development. It is ...
  • What is HANA studio in SAP?
    HANA studio is a client tool from SAP. HANA studio allows both administrators and developers to manage content within the HANA database. Many adm...