Supporting Transactional and Analytical Applications

Objectives
After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Describe how SAP HANA Cloud supports transactional and analytical applications in the same database

Supporting Transactional and Analytical Applications

Row store tables are optimized for fast update, whereas column store tables are optimized for fast read. So does this mean that all applications that need to update data (insert, delete, update) must only use row store? The answer is, no. Even column store tables can handle record updates. To enable this, SAP HANA Cloud uses a smart mechanism called delta merge that runs in the background.

Watch this video to learn about the Delta Merge.

Save progress to your learning plan by logging in or creating an account