Describing SAP HANA

Question 1

SAP HANA

Answer 1

Multiple applications running on one platform

Removes redundancy

Only one copy of data is needed for any type of access by any applicaiton

Combines transactional and analysis processing in one platform using the same data set

Question 2

3 components of the intelligent enterprise

Answer 2

1. Intelligent Suite,
2. Intelligent technologies, AI, Machine Learning, Internet of things, analytics
3. Intelligent platform, SAP HANA

Question 3

Persistent Memory (PMEM)

Answer 3

New type of memory

Advantages,

Able to hold onto data when power outage occurs

Cheaper, and comes in much larger sizes than DRAM

Disadvantages,

Cannot perform as fast as DRAM

Question 4

Dynamic Memory (DRAM)

Answer 4

Advantages,

• The speed of accessing data for applications
• Ideal for storing volatile working structures

Disadvantages,

• Business continuity, when power is lost due to unexpected outage or system needs a restart, data is lost from memory and needs to be reloaded from disk back to memory. With huge memory, reloading can take time
• Cost, it’s expesnive to size large hardware with very large DRAM memory

Question 5

SAP HANA memory data reading

Answer 5

SAP HANA automatically compresses data

SAP HANA accelerates all data because all data can fit in memory

Question 6

Disk cont’d

Answer 6

Cheaper than Memory

Used as back up of Memory

Question 7

Eliminates the complexity of applications

Answer 7

simplified core data model as well as simplified application code

Question 8

SAP HANA Tasks

Answer 8

• Aggregate and disaggregate data
• Filter, sort and rank data
• Calculate values from data
• Generate forecasts
• Convert data (e.g. currency, unit of measure)
• Cleanse data
• Re-structure data

Question 9

Where is does data processing occur?

Answer 9

In memory, so performance is execellent

Question 10

Push down

Answer 10

Moving data processing tasks from the application layer to the database layer

Question 11

Types of data

Answer 11

• Text Data: This is unstructured data from social media posts, help desk tickets, news streams, system logs, and so on.
• Spatial Data: This is data that relates to locality, maps, engineering diagrams, floor plans, and so on.
• Graph Data: This is data that relates to highly networked entities such as social networks, supply chains, and so on.
• Series Data: This is data that is collected in a steady time continuum, such as smart meter readings captured every 10 minutes.

Question 12

key capabilities of SAP HANA

Answer 12

Application Development: As well as a database, SAP HANA also provides many application services.

Advanced Analytical Processing: SAP HANA provides native in-memory engines that process all types of data in real time.

Data Integration: SAP HANA has the following built-in data consumption options

Database Management: SAP HANA is a full, in-memory column-and-row store database that can support both OLTP and OLAP requirements and is built to run on high-end hardware.

Question 13

Data Integration

Answer 13

• Continual streaming data analysis
• Read data remotely in any data source
• Read from Big Data stores such as Hadoop
• Synchronizes in both directions with remote databases and devices that collect data (IoT)

Question 14

ETL

Answer 14

Extraction, Transformation, and Loading capabilities: separate software is no longer needed to clean, enrich, and profile data from any source.