What is SAP HANA?
SAP HANA Enterprise 1.0 is an in-memory computing appliance that combines SAP database software with pre-tuned server, storage, and networking hardware from one of several SAP hardware partners. It is designed to support real-time analytic and transactional processing.
What are the technical components that make up HANA?
SAP In-Memory Database 1.0
SAP In-Memory Computing Studio
SAP Host Agent 7.2
Sybase Replication Server 15
SAP HANA Load Controller 1.00
SAP Landscape Transformation 1 Ã¢â‚¬â€œ SHC for ABA
What are potential uses cases of SAP HANA?
Monitoring and optimization of energy use
Detection of security and fraud
Reporting and forecasting of profitability
Retail merchandizing and supply chain optimization
Monitoring and optimizing of telecommunications network
What are the major business benefits of SAP Business Suite powered by SAP HANA?
Smarter business innovations
Rethink business processes
Faster business processes
Allow real-time planning, execution, reporting, and analytics on live data
Simpler business interactions
Provide real-time business insights
Where can I find current information on SAP Business Suite powered by SAP HANA on an ongoing basis?
You can find the current information and the latest versions in at the SAP's official website, www.saphana.com (or) www.sap.com/suiteonhana
SAP HANA is an in-memory database. Justify
SAP HANA stores the necessary data in RAM (main memory) rather than on a hard disk. By using the main memory SAP HANA, a combination of hardware and software processes massive amount of real-time data.
The pivotal functionality of SAP HANA is real-time analytics besides deploying and developing real-time applications.
What is the language used to develop SAP HANA program and mention the operating system supported by SAP HANA?
The SAP HANA database is developed using C++ and at present, the operating system supported by SAP HANA is SUSE Linux Enterprise Server x86-64 (SLES) 11 SP.
Describe the difference between column based and row based approach.
Column based approach
A sequential database approach is followed in column-based approach
Tables are stored in a sequence of columns here
Row based approach
A traditional relational database approach is followed in row based approach
It uses a sequence of rows store tables
Though SAP HANA is particularly optimized for column-based approach, it also supports row-based approach.
Why materialized aggregates are not recommended in HANA?
The activities such as data-intensive operations, additional complex calculations and functions will be managed by in-memory storage of SAP HANA database. Therefore, there is no need for materialized aggregates. In fact, it has some benefits such as simplified application logic, simplified data model and a higher level of concurrency.
List down the factors responsible for the fast operation of SAP HANA?
SAP HANA is fast because of the following factors,
Row and Column database
Massively parallel processing
What are the components of SAP HANA database architecture?
Here are the components of SAP HANA database architecture,
Session and Transaction manager
What are the different types of modeling views and engines available in HANA?
Types of modeling views
The three major types of engines in HANA are,
OLAP engine (used of analytic views)
Join engine (used for attribute views)
Calculation engine (used for calculation views)
Write about the types of packages in HANA.
There are two types of packages in HANA such as Structural package and Non-structural package.
Structural package has sub-packages but not repository objects whereas Non-structural package contains both sub-packages and repository objects.
Mention the types of schemas in HANA?
The three types of Schemas in HANA are,
SLT derived schema