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 HANA's 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 system (DBMS)