The data lake is fully integrated with the SAP HANA Cloud database using Smart Data Access (SDA) technology. The data lake is ideal for managing very large amounts of data where performance does not need to be optimal. Just like hot and warm layers, even the cold layer allows not just reading data but also writing data. Cold data is also stored on disk but manages huge volumes of data compared to NSE, and at much lower cost. A Data Lake provides data storage for cold data. In addition to hot and warm data layers, during provisioning, you can also select an optional Data Lake. During deployment you can choose the size of the memory (for hot data) and also the disk storage (for warm data) of your SAP HANA database.
#Sap hana studio sql console how to
NSE uses an intelligent caching mechanism that works closely with memory to determine how to keep the most popular data in memory - in other words how to upgrade the warm data temporarily to hot data while it is popular, remembering to bring it back to the warm tier when it is no longer popular.
In SAP HANA Cloud, warm data is managed by a component called Native Storage Extension (NSE). Data that does not require high performance is called warm data and is stored on disk. SAP HANA Cloud supports multi-temperature, data tiering.ĭata that is access frequently and requires optimal performance is called hot data and is stored in the memory of the SAP HANA Cloud database.
This component ensures that all databases (cloud and on-premise) are in real-time sync. SAP HANA database, adaptive server enterprise replication supports real-time data replication using log-based approach. This component provides ASE on-premise customers with a migration path to the cloud and can be fully integrated with SAP HANA database for a seamless OLAP / OLTP solution. This component supports extreme-performance transactional applications that requires instant response over huge volumes of data. SAP HANA database, adaptive server enterprise is the cloud version of the on-premise database that was originally Sybase ASE. This means that very large data sets can be stored and queried directly, or accessed in real-time from SAP HANA database.
SAP HANA Cloud, data lake is an optional component and provides a warm tier data layer. As well as the database, there is are also tools to support the development of advanced data models that can be consumed by any analytical application. SAP HANA database is the core component that provides the in-memory database.
0 kommentar(er)
