Case Study SAP HANA and other modern databases.

When answering the following questions, conduct your own research using all accessible resources, in addition to the class materials. No question should be answered depending solely on a single source:

1. What makes an in-memory computing technology like SAP HANA so widely accepted?

2. What are OLTP and OLAP? Explain their implementation in SAP HANA.

3. What is normalization and how it was achieved in SAP HANA as an example of in-memory databases?

4. Explain the aspects and advantages of columnar databases in contrast with row-based databases and how this is implemented in SAP HANA.

5. What is data redundancy and how does it affect businesses?

6. List in detail SAP HANAs capabilities in light of advantages to businesses with a high volume of transactions and analytics.

7. Explain in detail and with examples the differences between in-memory databases and the distributed databases.

8. What is big data and what are the best types of databases to deal with it? Explain in detail.

9. What are the major capabilities of database management systems (DBMS)?