Module 20Visual ArchitectureClient-Side Mermaid.js

SAP HANA Architecture & Visual Learning Gallery

Interactive Mermaid diagrams mapping engine internal memory structures, persistence loops, MDC tenant isolation, and disaster recovery replication handshakes. Toggle code to inspect diagram definitions or copy source code.

SAP HANA In-Memory Engine & Persistence Layer

Mermaid DiagramSAP HANA In-Memory Engine & Persistence Layer

Architectural Flow: Illustrates the dual-store column architecture where writes land in write-optimized Delta Storage and synchronously flush to /hana/log, while reads query compressed Main Storage. Savepoints periodically persist RAM pages to /hana/data.

Multitenant Database Containers (MDC): SystemDB & Tenant Isolation

Mermaid DiagramMultitenant Database Containers (MDC): SystemDB & Tenant Isolation

Architectural Flow: SystemDB supervises system topology while Tenant PRD and Tenant BWP operate dedicated indexservers with distinct memory allocation limits, persistence directories, and SQL listener ports.

HANA System Replication (HSR): Primary to Secondary Synchronization

Mermaid DiagramHANA System Replication (HSR): Primary to Secondary Synchronization

Architectural Flow: Transactions commit on the primary while the HSR engine simultaneously ships redo log buffers over a dedicated network. In logreplay mode, the secondary indexserver continuously replays changes into its in-memory tables.

SAP HANA SQL Request Processing & Query Execution Pipeline

Mermaid DiagramSAP HANA SQL Request Processing & Query Execution Pipeline

Architectural Flow: SQL statements enter via client ports, are parsed, optimized by the Cost-Based Optimizer, checked against SQL Plan Cache, and executed by specialized vector engines before persistence logging.