General Hana Knowlege Flashcards
What does HANA stand for?
High-performance ANalytical Appliance
There are 4 types of services provided by HANA. What are they
Application services
Processing services
Integration services
Database services
What are the 5 types of Application services provided by HANA?
Web services
Fiori UX
Graphic modeler
Java script
Application Life Cycle Management
What are the 5 types of processing services provided by HANA
Text Analytics
Spatial
Graph
Series data
Predictive
What are the 5 Integration services provided by HANA
Data virtualization
ETL and replication
Streaming
Remote data sync
Hadoop integration
What are the 6 database services provided by HANA
Columnar OLAP OLTP
Multicore parellization
Advanced compression
Multi-tiered storage
Data modeling
Disaster recovery
True or false, HANA has it’s own application server
True, and this is why some applications can be developed entirely in HANA and accessed by a web browser
What is meant by the SAP term “dynamic tiering”?
That frequently accessed data (hot) will remain in memory, while less frequently accessed data (warm) will be moved to disk
True or false, when a table stored in warm memory is required, it will be entirely loaded into hot memory?
False, a partition or column of the warm table might be all that is needed and therefore loaded into memory
Is HANA an OLAP or OLTP database?
Both, it is a hybrid (HTAP) database that supports both OLAP and OLTP processing
What are the two types of data compression used by HANA?
Dictionary compression
Advanced compression
What are the 5 types of advanced compression
Prefix encoding
Run length encoding (RLE)
Cluster encoding
Sparse encoding
Indirect encoding
What are the 5 golden rules of code to data programming?
Keep the result set small
Minimize the amount of data transferred
Minimize the number of data base accesses
Minimize the search overhead
Minimize the database load
