SAP HANA is the synthesis of three distinct products -
TREX, P * Time and MaxDB.
TREX (Text Retrieval and extraction) is a search engine.
It began in 1996 as a student project at SAP in collaboration with DFKI. TREX
has become a standard feature in SAP NetWeaver 2000. Memory attributes were
added in 2002 and store data column was added in 2003 as a means to improve
performance.
In 2005, SAP acquired Menlo Park Transact founded in
memory, Inc. With the acquisition came P * Time, light processing (OLTP) RDBMS
technology memory transactions with a database based on lines .
MaxDB (formerly SAP DB), a relational database from
Nixdorf via Software AG (Adabas D) SAP TREX was added to P * and time to
provide persistence and functionality of more traditional data such as backup.
In 2008, SAP CTO Vishal Sikka wrote on HANA "... our
teams work together with the Hasso Plattner Institute and Stanford University
have shown how a new application architecture is possible, which allows for
complex analyzes real-time aggregation, updated with each transaction, a way
never thought possible in financial applications. " In 2009, a development
initiative was launched SAP to integrate the three technologies above to
provide a more complete set of features. The resulting product was named as
internal and external NewDB until the change HANA DB was finalized in 2011.
SAP HANA is not the first product in memory of SAP.
Business Warehouse Accelerator (BWA formerly BIA) has been designed to speed up
queries by storing in memory BW InfoCubes. It was followed in 2009 by the then
accelerated Explorer where the combined SAP BI Explorer tool with BWA as a tool
to perform ad-hoc analyzes. Other SAP products using in-memory technology were
CRM Segmentation, By Design (for analysis) and Enterprise Search (for the role
of research based on structured and unstructured data). All of these were based
on the TREX engine.
Taking a different approach, Advanced Planning and
Optimization (APO) LiveCache used for its analysis.
Versions, service
packs
Co-founder (and chairman of the supervisory board of SAP
from 2012) SAP Hasso Plattner recommended system "versionless" for
emissions. Support plans to date are:
SP0 - published November 20, 2010, HANA first public
release
SP1 - published June 20, 2011, HANA general availability
(GA), the focus is also operating a data mart
SP2 - published June 27, 2011, more functions mart data
Aka HANA 1.5 SP3 - 7 November 2011 Authorization)
emphasis on HANA as a basis for the underlying data in the Business Warehouse
(BW), also called Project Orange
SP4 - May 2012; solve a variety of problems of stability
and to add new functionality for BW, according to SAP
SP5 - November 2012, introduced Extended Application
Services driver (REST)
SP6 - June 28, 2013, current version
