Ads from Google

Monday, June 27, 2011

SAP HANA in memory database implementation

HANA stands for High performance ANalytic Appliance.
New technology roadmap for in memory technology  as mentioned in zdnet comes to enterprise.

SAP HANA vs Oracle Exadata Exalogic

I read SAP HANA list of application from ematters.wordpress.com, it will be a competitor for BW solution from  other vendor such as Oracle Exadata etc.

Oracle will definitely hostile force customer to their hardware platform such as Sun Solaris. while SAP solution are more independent to any hardware vendor. Oracle Exadata is also estimated million dollar price, while SAP HANA may be as low as 1/100 up to 1/10 of the Exadata.

other reference:
In-Memory Data Management: An Inflection Point for Enterprise Applications
Real-Time Access to Information: SAP In-Memory Computing

Replacement by HANA
Is HANA replacement for relational database? What support and maintenance for such database? what application that can use HANA, OLTP,BW,SCM,CRM? Is HANA same with BW/BI Accelerator? HANA appliance may be addition or plug in to existing traditional database which used for reporting and query purpose which 3600x faster transaction than traditional database query. HANA may also replace OLAP/BI/BW requirement for certain function. Is HANA also replacement for BI Business Object in future? BW will be still needed e.g. for financial consolidation .

Implementation time and phase: could be few weeks, e.g. 3 weeks

More Information

Availability: HANA is available for customer worldwide since July 2011 (general availability)

Support and Maintenance: open connection using saprouter from SAP Global support for service type SAP In-Memory database, standard support timeline information is still not found

History:
- SAP acquired Transact In Memory company (founded by Mr Sang Cha) in 2005 , developing next-generation of in-memory OLTP engine
- HANA initially stands for Hasso's New Architecture (2008) then now it is High Performance Analytical Appliance
- SAP acquired Sybase database?
- HANA ramp up (available to selected customer) Nov 2010 with HANA 1.0
- HANA available to worldwide customer July 2011

Documentation:
- SAP Note 1514967 – SAP HANA 1.0: Central Note
- HANA collaboration workspace https://cw.sdn.sap.com/cw/community/docupedia/hana, https://cw.sdn.sap.com/cw/community/sap/pcn/emea/hana, contain documents, discussions, and blog
- collection of HANA webinars https://cw.sdn.sap.com/cw/servlet/JiveServlet/downloadBody/143978-102-1-306080/HANA_Webinars.pdf or https://cw.sdn.sap.com/cw/docs/DOC-143978
- Innovation for Industries https://cw.sdn.sap.com/cw/docs/DOC-142474, covering in-memory, mobility, on-demand and analytics for each type of industries. I think it is possible with combination of ERP 6.0 EHP4 EHP5 and other existing or the latest release of SAP products. e.g. In-memory computing for


Aerospace and Defense
Automotive
Banking
Chemicals
Consumer Products
Defense and Security
Engineering, Construction and Operations
Healthcare
High Tech
Higher Education and Research
Industrial Machinery and Components
Insurance
Life Sciences
Media and Entertainment
Mill Products
Mining
Oil and Gas
Professional Services
Public Sector
Retail
Telecommunications
Transportation and Logistics
Utilities
Wholesale Distribution




Released version
- SAP HANA 1.0 (General Available May 2011) HANA 1.0 SPS2  (SAP HANA 1.0: SPS2 Release Note 1600147)
- SAP HANA 1.5 (ramp up planned in Q4 2011), HANA 2.0, (HANA 3.0?)
- SAP BW 7.3 ready for SAP HANA
- SAP Note 1513496: data from Oracle into SAP HANA 1.0 not supported until further notice
- Cloud based HANA: expected Q4/Q1 2012


  • SAP Partner for In Memory database:  Intel, Cisco, Delloite, Fujitsu, IBM, HP

  • SAP In-Memory Computing web from SAP.
  • Help portal from SAP http://help.sap.com/hana/
  • course/Training (classroom and virtual class)/hands on experience: TZHANA code in http://www.sap.com/services/education/index.epx :  SAP - SAP In-Memory Appliance (SAP HANA 1.0) for selected partner until Q3 2011 for public (2 days 1400 usd) with following contents (from SAP.com website)
    • The SAP In-Memory Appliance (SAP HANA) enables business departments to analyze business as it happens. Individuals can create very flexible analytic models based on real-time data originating from business applications. In order to cover for the full spectrum of information which might be relevant for business, data from other sources like SAP BW or 3rd party databases can also be brought in and mashed up.
    • Overview HANA product strategy
    • InMemory Computing (Row Store, Column Store, Persistency Layer, Architectural Concept)
    • HANA based Real-time Operational Analytics
    • HANA based Agile Data Marts for Rapid Prototyping with Analytic Models
    • New Modeling Paradigm in order to provide agility and flexibility from business question to report
    • InMemory Computing (Administration and Monitoring)


SAP In-Memory providse businesses to get instant access to their analytical data. How SAP In-Memory Computing is now different from other business intelligence (BI) or other analytic approaches, remarkable results which SAP was able to achieve. Video of SAP Runs Better With In-Memory Computing :


- basic concept: columnar database
- combine historycal keyfigures and trend indicators with current data sources to provide predictive analysis. Implant OLAP cubes and relational database in server RAM/memory.
- it is realtime business, information at a speed of light, based on the latest in-memory technology, data is not stored in physical disk, the future is IN-MEMORY; 
- real-time analytic for huge data records
- realtime replication from other application (OLTP/SAP ECC/ERP, CRM, BW/BI etc), may be based on Sybase Replication technology
- SQL database language compatible, SQL interface for multi dimensional query interface for third party application (SAP and non-SAP), MDX interface, and BICS interface (for SAP BI client)
- certified interface: ODBO, ODBC, JDBC, SQLDBC , SAP BI 4.0, documented SQL/MDX (SAP Note 1577128), customer developed application (not certified) will be not supported
- HANA is attached to SAP or non-SAP application as side-by-side appliance (e.g with SAP R/3 4.6, SAP R3 Enterprise 4.7, ECC 5.0, ECC 6.0, BW, CRM etc), may be considered as accelerator for datawarehouse, e.g. BW Accelerator for BW. Also may be as engine for Business Object Explorer Accelerated.
-APPLIANCE means it is a complete box of software, hardware, configuration and everything in one box just plugged in to the network and then attached to application services; in SAP case: push entire CRM system to HANA of 3TB, 650K opportunities, 12 million records, 700hundred million logs over 6 year historical data, which all available in realtime, 2 hours data latency, 
- Hard drive harddisk storage: are history, considered as archives, for persistence object only (views), transactional data

-benefit in business scenario, forecast, planning, application availability for mobile devices; plug in HANA appliance to application (e.g. CRM, BW)  without disruption and downtime
Module: Opportunity Management, CRM

- mobile device to access SAP and HANA realtime in-memory computing in future: Winpad, Epad, Ipad, Iphone, smartphone, Windows mobile phone and devices, Android mobile phone and devices


Testimonial Video from Customers 





Customer experience video can be found here: BASF, Bosch, Siemens, Centrica, Hilti, Infosys, Lenovo, etc 


Roadmap : Planned for 2011


SAP announce a roadmap for upcoming in-memory application in SAP Run Better tour (information from sap.info).

  • Sales and Operations Planning
  • : This application will enable sales and marketing departments to collaborate with operations and finance in order to evaluate the impact of their strategies and make accurate predictions.
  • Intelligent Payment Broker
  • : This application will calculate financing options on open invoices and will help determine which discounting terms should be offered on which invoices.
  • Smart Meter Analytics
  • : The software for intelligent electricity meters: With this application utility companies can analyze smart meter readings to forecast demand and develop new products.
  • SAP Trade Promotion Management Application
  • improves the planning process and helps develop accurate strategies for particular customers.
  • SAP Cash and Liquidity Management Application
  • allows companies to predict inbound and outbound cash flows and risk management.



Performance
- run 10,000 queries per hour against 1,3TB of data , result within few seconds http://en.sap.info/hana-inmemory-ibm-x3850-analytics/49008 under SAP and IBM test result. Using IBM x3850 X5 server contains 32 cores, 0.5 terabytes of memory, and a RAID 5 disk system
- query a 100GB in-memory database in just seconds (based on a speed of 2MB/ms per CPU core)  http://en.sap.info/sapphire-orlando-2010/32966
- http://en.sap.info/hana-inmemory-newdb-westmere/44852/3 : "a pile of CRM data that takes up 2.5TB on a conventional hard drive occupies only 600GB when arranged in SAP HANA’s column-wise structure. Under ideal conditions, the compression rate can reach a factor of 10"


Hardware list for HANA
- FUJITSU PRIMERGY: from 128GB to 1TB main memory , t-shirt sizing available
- IBM system for HANA
- Blade servers from some hardware vendors for HANA http://en.sap.info/hana-inmemory-newdb-westmere/44852/3

Fujitsu, HP, and IBM offering blade servers with 2TB of RAMTo enable customers to take advantage of the fully in-memory database technology offered by SAP HANA, Fujitsu, Hewlett-Packard, and IBM have introduced blade servers equipped with Intel processors and chipsets.
These new blade servers sport motherboards based on the Intel Westmere-EX platform, which supports DIMM memory chips of up to 32GB each. The ability to install up to 64 of these modules puts the maximum memory of one server at 2TB; as far as business processes are concerned, most of the databases today’s companies maintain are no larger than 500GB. In addition to this generous RAM capacity, the blades can contain as many as 64 CPU cores (with Intel’s Hyper-Threading technology) – enough for most computing operations.






2 comments:

IT Training & Placement said...

This post has a lot of importance to the people, I want to do SAP Online Training so please suggest me best training center in USA.

manisha jain said...

thanks for sharing important information on sap-hana