SAP Hana
HANA satnds for High Performance Analytical Appliance that is in-memory database, initially the data is saved in RAM and during save point operation data copy from RAM to disk.
HANA db is developed by the team from SAP SE(Hasso Plattner and Vishal Sikka) and the team from Standford University, Hasso Plattner University.
Benefits of SAP Hana Database: Hana Database is complete pack of services, fast in processing, efficient for data compression, powerful for massivly parallel processing,flexible to deploy on public or pricate cloud and secure.
Key roles of SAP HANA
- Hana db is a column oriented database, 97 to 98% tables are column oriented.
- Hana db is an appliance software i.e. combination of software and hardware.
- Hana db is following rdbms ACID properties(Atomicity, Consistency, Isolation, Durability).
- Hana db is having high compression ratio minimum 7 to 8 times.
- Hana db is an appliance platform, it can act as ETL tool(SLT, SDI, SDA)
- Hana db can act as Web application server such as web-as-java server.
Syllabus
- Hana architecture
- Hana db process
- Layers in Hana db
- Pre step and downloading Hana db
- Installation steps of Hana db
- Start and stop in Hana db
- Hana db file system layout
- Application installation on Hana db
- Hana db post steps
- Sap application distribution installation in Hana db
- Scale out installation in Hana db
- Hana upgrade revision, maintenance revision, sps and version
- Phases in Hana update and upgrade
- Hana db pluggins installation and resident hdblcmgui
- Hana db pluggins uninstallation scripts
- Hana db backup
- Hana db recovery
- Hana point in time recovery and how to add Hana db as secondary connection
- System landscape transformation in Hana db
- Smart data access in Hana db
- Hana transports
- Hana db as a multi database container
- Hana db system replication
- Hana db security
Features of the course
- SAP authentication and authorization
- Maintain roles and profiles as per departments
- Complete user administration
- Managing critical authorization
- Management of audits