SAP HANA

From Infogalactic: the planetary knowledge core
Jump to: navigation, search
SAP HANA
SAP 2011 logo.svg
Developer(s) SAP SE
Stable release SPS12 Revision 120[1] / May 11, 2016; 7 years ago (2016-05-11)
Development status Active...
Written in C, C++
Available in Multi-lingual
Type In-memory RDBMS
License Proprietary
Website SAP HANA DB

SAP HANA is an in-memory, column-oriented, relational database management system developed and marketed by SAP SE.[2][3] SAP HANA was previously called "SAP High-Performance Analytic Appliance".[4]

History

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.[5][6] 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".[7]

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

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

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

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

Rather than versioning, the software utilizes service packs.[18]

Architecture

The main process, called the index server, has a structure shown in the diagram to the right.[19]

HANA indexer components

The indexer performs session management, authorization, transaction management and command processing. Note that HANA has both a row store and a column store. Users can create tables using either store, but the column store has more capabilities. The index server also manages persistence between cached memory images of database objects, log files and permanent storage files.

Features

Major Features as available in HANA SPS12:

  • Triggers
  • Cursors
  • Query caching
  • Sub-SELECTs (i.e. nested SELECTs)
  • Full-text indexing and searching
  • Unicode support
  • Shared-nothing clustering (Scale-Out)
  • ACID compliance[20][21]
  • MVCC support[22]
  • Multitenancy[23][24]
  • Built in application server with Java, JavaScript, Node.JS, C++ runtime support and works with Git/GitHub and Maven.[25] Applications can use SQL, JDBC, ODBC, ADO.NET, ODATA XML/A and MDX to access data.[26]
  • Text analytics: Supports text analysis, mining, natural language processing capabilities such as linguistic analysis, stemming, tokenization, tagging, entity extract and sentiment analysis from unstructured data from 32 languages[27][28]
  • Predictive analytics[29]
  • Spatial processing[30]
  • Graph[31]
  • Data Streaming[31]
  • Time Series Data Processing[32]
  • Text Search

Supported platforms

Deployment

SAP HANA can be deployed on-premises as an appliance from a certified hardware vendor or on certified hardware with tailored data center integration (TDI). HANA is also available in the cloud as a Database as a Service on Amazon Web Services, Microsoft Azure, or the SAP HANA Cloud Platform.

References

  1. ↑ Support Package Stack 12 (Last Update: May 11, 2016, Revision 120)
  2. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  3. ↑ SAP HANA - The Column Oriented (Based) Database on YouTube (December 8, 2012)
  4. ↑ http://www.computerworld.com/article/2514617/business-intelligence/sap-s-hana-will-speed-real-time-data-analytics.html
  5. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  6. ↑ 6.0 6.1 Lua error in package.lua at line 80: module 'strict' not found.
  7. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  8. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  9. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  10. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  11. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  12. ↑ IBM Cloud AMM for SAP HANA One
  13. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  14. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  15. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  16. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  17. ↑ http://www.vmware.com/company/news/releases/vmw-newsfeed/SAP-and-VMware-Announce-SAP-HANA%C2%AE-for-Production-Use-on-VMware-vSphere-5.5/1837460#sthash.SJsM5ITw.dpuf
  18. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  19. ↑ http://www.saphana.com/community/blogs/blog/2012/12
  20. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  21. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  22. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  23. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  24. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  25. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  26. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  27. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  28. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  29. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  30. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  31. ↑ 31.0 31.1 Lua error in package.lua at line 80: module 'strict' not found.
  32. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  33. ↑ Lua error in package.lua at line 80: module 'strict' not found.
  34. ↑ Lua error in package.lua at line 80: module 'strict' not found.

External links

Retrieved from "https://infogalactic.com/w/index.php?title=SAP_HANA&oldid=722187625"