Selective Data Migration Between In-Memory and Extended Storage
Tutorials that teach this
- Tutorial Multi-Store Tables
- Tutorial Selectively Move Data Between In-Memory and Extended Tables
- Tutorial Converting Between an In-Memory Table and an Extended Table
- Tutorial View Data Across Both In-Memory and Dynamic Tiering Tables Using a SQL View
- Tutorial Adding Our Union Calculation View into the Converted Data Model
- Tutorial Create Tables and Import Data
- Tutorial Compare Prepared and Executed Plan
- Tutorial View Data Across Both In-Memory and Dynamic Tiering Tables Using a SQL View
- Tutorial Create Multi-Store Tables
- Tutorial Convert Between an In-Memory Table and an Extended Table
- Tutorial Migrate Records in Related Tables Using Stored Procedure
- Tutorial Migrate Records in Related Tables Using Stored Procedures
- Tutorial Seeing Calculation View Results
Prerequisites
- Concept Database Transaction Isolation Levels
- Concept SAP HANA SQL API Usage
- Concept SAP HANA Stored Procedure Creation and Execution
- Concept SAP HANA Database Administration
- Concept SQL JOIN Operations (INNER JOIN)
- Concept SAP HANA In-Memory Relational Database
- Concept Foreign Key Constraints and Referential Integrity
- Concept HANA Column Store and Row Store Tables
- Concept SQL Querying Fundamentals (SELECT, WHERE, GROUP BY, ORDER BY)
- Concept SQL Nested Queries and Subqueries
- Concept SAP HANA Dynamic Tiering (Extended Tables)
- Concept Auto Commit and Manual Transaction Control in SQL