SAP HANA ADMIN TRAINING

SAP HANA ADMIN

SAP Hana Administration is the synthesis of three separate products

• It began in 1996 as a student project at SAP in collaboration with DFKI. TREX became a standard component in SAP NetWeaverin 2000. In-memory attributes were added in 2002 and columnar data store was added in 2003, both as ways to enhance performance.
• In 2005 SAP acquired Menlo Park based Transact in Memory, Inc. With the acquisition came P*Time, an in-memory light-weight online transaction processing (OLTP) RDBMS technology with a row-based data store.
• S MaxDB (formerly SAP DB), a relational database coming from Nixdorf via Software AG (Adabas D) to SAP, was added to TREX and P*Time to provide persistence and more traditional database features like backup.

In 2008, SAP CTO Vishal Sikka wrote about Hana Administration Administration “…teams working together with the Hasso Plattner Institute and Stanford University demonstrated how a new application architecture is possible, one that enables real-time complex analytics and aggregation, up to date with every transaction, in a way never thought possible in financial applications”. In 2009 a development initiative was launched at SAP to integrate the three technologies above to provide a more comprehensive feature set. The resulting product was named internally and externally as NewDB until the change to Hana Administration Administration DB was finalized in 2011.

SAP Hana Administration Administration is not SAP’s first in-memory product. Business Warehouse Accelerator (BWA, formerly termed BIA) was designed to accelerate queries by storing BW infocubes in memory. This was followed in 2009 by Explorer Accelerated where SAP combined the Explorer BI tool with BWA as a tool for performing ad-hoc analyses. Other SAP products using in-memory technology were CRM Segmentation, By Design (for analytics) and Enterprise Search (for role based search on structured and unstructured data). All of these were based on the TREX engine.

Taking a different approach Advanced Planning and Optimization (APO) used LiveCache for its analytics.