From Verify.Wiki
Jump to: navigation, search


SAP HANA is an in-memory, column-oriented, relational database management syatem, developed to handle both transactions and analytics on a single data copy. This data-management platform is developed and marketed by SAP SE. HANA stands for "High-performance Analytic Appliance" .


SAP HANA is an in-memory database platform which means that all the data is stored in the memory (RAM). This means no time is wasted in loading the data from hard-disk to RAM or while processing keeping some data in RAM and temporary some data on disk. Everything is in-memory all the time, which gives the CPUs quick access to data for processing.It is a columnar store that optimizes the benefits of multicore processing and the single-instruction, multipledata instruction set. It is fully compliant with requirements for atomicity, consistency, isolation, and durability (the ACID standards). Using intuitive modeling tools, decision tables, and preconfigured function libraries, complex business logic can be run directly inside the database. This reduces latencies in moving between the database and the application servers. Stored procedures take advantage of optimized in-memory calculation engines to run faster.

When multitenant database containers are set, several databases can be managed as one while maintaining their isolation from one another.Administrative tasks can be performed such as backup and patching on all tenants at once and also optionally allocate resources to each tenant separately to protect performance.Service-level requirements are also met at greater operational efficiency and lower cost

It has the facility of dynamic tiering, through which frequently accessed data can be kept in-memory while moving rarely accessed data to disk.Complex calculations on data are not carried out in the application layer, but are moved to the database, thereby managing Big Data economically without the constraints of memory size.

SAP HANA is equipped with multiengine query processing environment which supports relational as well as graphical and text data within same system. It provides features that support significant processing speed, handle huge data sizes and text mining capabilities. Applications can access data independently of storage location,and storage preferences can be modified as required.

SAP HANA includes native high-performance predictive algorithms and integration with R-Server to reveal meaningful patterns in data to develop predictive models. Features such as Text search and text analysis extract meaning from semi-structured text and transform it into a data model for analysis. It provides native support for spatial data – points, lines, and polygons – and spatial functions. Base maps in SAP HANA – with political boundaries and points of interest – help accelerate development of location-aware business applications. Streaming data from from sensors, plant equipment, or financial transactions can be processed and analyzed with SAP HANA. Series data processing helps to store and query time-series data like price fluctuations, seasonal trends, and information on machine efficiency and network flow. There is a provision to store highly interconnected graph data in a dynamic data model.

SAP HANA connects with existing applications using open standards and offers a choice of ways to build Web-based applications and applications based on microservices. SAP Web IDE, a Web-based development environment, offers a comprehensive lightweight tool set for data modeling and application development. The SAP HANA studio offers similar capabilities with Eclipse-based tools.It supports ABAP language ad SAP Power Designer software as well. Integrated lifecycle management features helps to define application structure, track object changes, and assemble applications and deploy them to the production system.

SAP HANA supports a variety of programming languages, including Java, JavaScript, Node.js, JSON, and C++ runtime. It contains several preconfigured business functions, such as discounted cash flow and interest rate management, to further accelerate development. These run inside the database for optimal performance and can be called directly from SQLScript. SAP HANA also includes a framework that lets you create your own data processing algorithms to run inside the database. Queries can be sent to external data sources such as other databases,Apache Hadoop, and Apache Spark to perform queries without costly data movement.Features for remote data synchronization to synchronize data bidirectionally among databases in SAP HANA and the SAP SQL Anywhere , within the enterpise SAP HANA cockpit platform is coupled with tools to control, monitor and provide a real-time insight into the entire system's functioning and security.


To create SAP HANA, SAP SE developed or acquired technologies, including TREX search engine (in-memory column-oriented search engine), P*TIME (in-memory OLTP Platform acquired by SAP in 2005), and MaxDB with its in-memory liveCache engine. In 2008, teams from SAP SE, working with Hasso Plattner Institute and Stanford University, demonstrated an application architecture for real-time analytics and aggregation, mentioned as "Hasso's New Architecture" in former SAP executive Vishal Sikka's blog. Before the name "HANA" stabilised, people referred to this product as "New Database".

The first product shipped in late November 2010. By mid-2011, the technology had attracted interest but the experienced business customers still considered it "in early days".HANA support for SAP NetWeaver Business Warehouse was announced in September 2011 for availability by November.

In 2012, SAP promoted aspects of cloud computing. In October 2012, SAP announced a variant called HANA One that used a smaller amount of memory. It is available on IBM Cloud and on Amazon Web Services for a monthly and an hourly fee respectively.

In January 2013, SAP enterprise resource planning software from its Business Suite was announced for HANA, and became available by May.In May 2013, a software as a service offering called the HANA Enterprise Cloud service was announced.

In May 2014 SAP and VMWare announced SAP HANA for production use on VMware vSphere 5.5

Rather than versioning, the software utilizes service packs.


For years Wall Street analysts like Peter Goldmacher (formerly of Cowen & Co.) have criticized SAP's financial treatment of HANA, arguing that the legacy software vendor had been misrepresenting HANA revenue to project an "inflated growth rate." In short,it has been stated that HANA's zero-to-$1 billion rapid growth story seems to be highly unlikely Security firm Onapsis just uncovered 21 significant security flaws in HANA, eight of which it deemed "critical. It was stated that ,"Unless companies act to change system configurations, "Unauthenticated attackers could take full control of vulnerable SAP HANA systems, including stealing, deleting or changing business information, as well as taking the platform offline to disrupt key business processes." It is the reason why Host Analytics and data infrastructure expert Dave Kellogg advises HANA customers to switch to "standard infrastructure," in part because it's "more proven." It also has inherent weaknesses such as limited coverage of actual reporting needs, difficult customisation, large number of views and many others. Apart from this, the inability of SAP HANA to cater to the needs to open-source market and to remain at par in the same, amidst tough competitors aided by giants like Google, could prove to be detrimental to the company in the long run.

Top 5 Recent Tweets

April 18, 2023PVersionitSAP ABAP S/4 HANA


April 18, 2023SaitechIncAccelerate your SAP HANA and S/4HANA transformation journey with @HPE Gen10 servers! Learn more—download this infog…
April 17, 2023opensitnetA session by Moyan Liu at #sitTokyo 2022: SAP HANA Cloud Resource Planning with PAL #HANADB #CloudNative
April 17, 2023ale287_SAP workloads are business-critical for many organizations. Any technology or deployment direction that SAP takes h…
April 17, 2023HANAonPOWERSAP recently (March 2023) published a blog about HANA on POWER10 with a lot of important and collected infos:…

We’ve taken an a rock solid platform & enhanced it. Here's what's new in #SAPHANA SPS12 Not your mother's farms-- See how orgs are using #IoT to supercharge agriculture: Get the scoop on the top sessions happening at #HANA2016. We can't wait to be in #Vienna Predicting the needs of 200 million athletes worldwide helps @UnderArmour #runsimple Brainpower & financial acuity have Pudong, Shanghai finding its way in the #futureofwork.

Top 5 Recent News Headlines

Top 5 Lifetime Tweets

Top 5 Lifetime News Headlines

Verification history