Hana (High-performance Analytic Appliance) High performance Analytics device Hana is a combination of hardware and software that provides high-performance data query capabilities that allow users to query and analyze a large amount of real-time business data directly without the need to model business data, Aggregation and so on. The user gets a device with pre-configured software installed. As for Hana's cloud services, it is only possible for users to enjoy Hana's high performance without the purchase of relevant hardware, while the Hana Cloud service is backed by higher performance hardware. Software, Hana's in-memory database (SAP in-memory database, IMDB) is an important part of it, including database servers (in-memory databases server), modeling Tools (Studio), and client tools (ODBO, JDBC, ODBC, SQLDBC, etc.). The Computing engine is the core of Hana, responsible for parsing and processing various CRUDQ operations on large amounts of data, supporting SQL and MDX statements, SAP, and NON-SAP data. The obvious point is that the Hana compute engine quickly processes user complex query requests and returns query results quickly. The data in the SAP memory database is not only in memory, it is also written to the hard disk, which is used to replicate server replication server, including log-based,trigger-based and etl-based. These replication servers require the use of Sybase Replication Server, Sybase Replication server Agent, Sybase Adaptive server EntERPrise (AES, applicability server), etc. As well as Hana Load Controller and Bo Data Services. Operating system, Hana is currently only available on SuSE Linux Enterprise Edition (SLES).
Hardware Aspects, SAP and multiple hardware vendors work together to produce high-performance servers that support Hana, including Dell R910, Fujitsu, HP DL580, IBM x3850, and the Cisco Unified Computing System. UCS) and other companies. Intuitively, the hard drives of these machines may consist of several 600GB, 10k rpm drives consisting of RAID, memory may be 1 T, the file system may be ext3 or GPFS (IBM Universal Parallel File system, General Parallel filesystem). Like Hana, Oracle's Exadata is also a pre-configured hardware and software combination that provides high-performance data read and write operations. Exadata machine consists of exadata database machine, exadata database server, Exadata Storage server and high-speed network interface. The InfiniBand port can be transferred up to 40gb/seconds.
HANA
The Fastis to provide in-memory databases with large memory and to use Columnstore in the in-memory database so that more data can be loaded into memory (Columnstore is more suitable for data compression).
Exadata
The Fastis to push most database operations to the hardware, improve data query speed through high-performance hardware, reduce the amount of data that needs to be moved between storage and memory by using a column structure, and provide efficient data transfer through high-speed network interfaces.
What is SAP HANA?
