Wednesday, February 22, 2012

5 Facts that SAP won't tell you about HANA

SAP has been touting HANA as an innovative, breakthrough technology and the next “big thing”. They are aspiring to be the #2 database vendor riding on the HANA hype. Well, time to dig deeper and bring forward 5 facts that SAP won’t tell you about HANA.

#1: HANA is an In-Memory database. So, where’s the innovation?
SAP has positioned HANA as the newest, most innovative category defining offering. However, HANA is an in-memory database which may be a new category for SAP but has existed in the market for years. A quick Wikipedia search on in-memory databases reveals that in-memory databases have been around since the 1990s and today there are 40+ such independent offerings of which HANA is one. Oracle alone has 3 in-memory database offerings with successful products like TimesTen, Berkeley DB and MySQL.  Introduced in 1990’s, Oracle’s TimesTen remains an early innovator and a leader in this space. HANA, introduced in 2011 is the youngest member of the group.

#2: HANA adoption is growing rapidly. So, where’s the growth?
SAP will show numbers like FY 2011 revenues of $200M and 100+ customers to underscore HANA’s rapid customer adoption. Putting these numbers in perspective; Vertica, the largest independent in-memory database vendor before being acquired by HP in 2011, was on track to deliver revenues around $100M with 200+ customers and over 100% YoY growth rate. Oracle remains the leader in data warehouse platform market with FY 2010 revenues of close to $3B and thousands of customers. Given Oracle & Vertica’s impressive performance, HANA’s numbers while good are hardly “rapid”.

#3: HANA is enterprise ready. So, where’s the manageability and reliability?
It takes years to develop and perfect a complex product like database management system. Oracle database has been perfected over 30+ years and billions of dollars in R&D investment. TimesTen has been around for 15 years and is still being aggressively developed and perfected. SAP would like you to believe that HANA is enterprise ready from day one but dig deeper and you’ll find that HANA lacks basic features like clustering, high availability, file system persistence and ACID style transaction integrity support. HANA lacks referential integrity support so there is NO means to ensure the integrity of data stored in a HANA database. HANA’s support for locks and transaction isolation is primitive so multi user concurrency is an issue. Hopefully, you get the picture that HANA is an immature version 1 DBMS which is far from being ready to support mission critical enterprise applications.

#4: HANA is non disruptive. So, where’s plug and play?
HANA has limited support for standard ANSI SQL.  In fact, HANA requires applications to be custom written for it using non-standard SQL. In my view this is a major show stopper. In this day and age where every vendor is working diligently to support openness and application integration via support for services oriented architecture and web services in comes HANA with SAP’s age old vision of closed system with no access to underlying data structures. HANA takes vendor lock in to new levels by limiting your choice of applications, reporting & analysis tools to a few offered by SAP.

#5: HANA is an appliance. So, where’s ease and speed of deployment?
Wikipedia defines computer appliances as consisting hardware and software pre-integrated and pre-configured before delivery to customer, to provide a "turn-key" solution to a particular problem. Benefits of appliances include ease and speed of deployment with lower risk and faster time to value. With HANA you buy hardware, software, networking switches and storage from different vendors. There isn’t a single point of support and with different vendors having markedly different development and upgrade cycles it’s excruciatingly hard to test, configure, certify and update the joint solution.

In conclusion, SAP’s larger than life solution HANA definitely underscores the strategic importance of data management and analysis to organizations but due to limitations highlighted above HANA is far from being ready to support mission critical enterprise applications. Customers should consider mature technologies like TimesTen based Oracle Exalytics and Oracle Exadata for their in-memory analytics needs. 


  1. I like your blog,and also like the article,and thank you for provide me so much information :)) sap business analytics

  2. Isn't Exadata an "appliance" too? It's been a while since I have looked, but I thought it was a hardware/software bundle. But maybe I am confusing it with something else.
    Certainly Vertica + VoltDB look to be at least as interesting in this space.

  3. This post has a lot of importance to the people…I hope you can continue to inspire and post more of this…Thanks

  4. hi im robertads .. i am sap mm consultant ,, thanks for sharining a vailable information,, sap-sd

  5. This is nice site and thanks share with us.we providing SAP HANA online training

  6. The information which you have provided is very good and easily understood.
    It is very useful who is looking for sap hana Online Training.

  7. This comment has been removed by the author.

  8. you must feel like a fool now that a year later SAP's growth continues to with HANA adoption and the revenue generated from HANA continues to break previous records...

  9. Oracle 11g Online Training
    Oracle 11g Online Training is combined with programming of SQL and PLSQL online training 12+ years of real-time exp. trainer, Enroll for Job oriented program

  10. #1: HANA is an In-Memory database. So, where’s the innovation?
    ===> Runs on INTEL laptop processor. Does not need any special hardware.
    It you need to compare oracle in-memory, you need to match with SAP BW accelator

    #3: HANA is enterprise ready. So, where’s the manageability and reliability?
    ===> if you call Oracle 8.1 is enterprise ready, HANA is more than ready for enterprise

    #4: HANA is non disruptive. So, where’s plug and play?
    ====> 100% support for SQL-92. For special performance you need to use SQLScript.
    If you have any dispute on this matter, why there was PL/SQL innovation?

    #5: HANA is an appliance. So, where’s ease and speed of deployment?
    With HANA you buy hardware, software, networking switches and storage from different vendors.

  11. Samsung Xpress SL-M2070 Toner dolum yapılmaya müsait kartuş kullanmakla birlikte ucuz dolum yapılması zor yazıcı tonerleri arasında bulunmaktadır. Ucuz samsung 2070 toner dolumu yapılmamasının sebebi kartuşun üzerinde bulunan çip adındaki elektronik kart kullanmasından kaynaklıdır. sl m 2070 w yazıcıların kullandığı mlt-d111 kartuşun kullandığı chip detaylı çipler arasında bulunduğundan pahalı chip fiyatları samsung m2070 toner dolum dışında ucuz samsung m2070 muadil toner fiyatlarını pahalı biçime getirmektedir.
    Yalnızca dolum yapılarak kullanılmaya çalışıldığında kaliteli kopyalama yapması mümkün olmadığından ilgili yazıcı kartuşunun yenileme yapılarak kullanılması birim kopya fiyatlarını yükseltmektedir.
    Uygun fiyatlara satılan yazıcıları tercih eden kullanıcıların satın almaları ardından yüksek maliyetlerle kullanmak zorunda kaldıklarından sıkıntı yaşamaktadırlar.
    Samsung sl-m2070 dolum fiyatları yüksek olması yanında kaset tankı içerisinde bulunan toner tozu miktarı düşük olduğundan % 5 doluluk oranı esas alınarak kopyalama yapıldığında 1000 sayfa çıktı vermesi dolumcuyla sıkça karşılaşılmasını sağlamaktadır. sl-m2070 fiyatı açısından dikkate alınmadığında kaliteli kopyalama yapma özellikleri taşıyan küçük ebatları nedeniyle gerek ev, gerekse iş yerlerinde kolayca kullanılabilen yazıcı modelleri arasındadır.
    m 2070 yazıcı satın almamış araştırma yapıyorsanız baskı maliyetleri düşük yazıcılar arasından seçim yaparak düşük maliyetli ürünler arasından seçim yapmanızı öneririz.
    Satın almış bulunuyorsanız ucuz doldurma yapmak yerine garantili yenileme yapılmasını tercih etmenizi öneririz.
    Firmamızın web sitesinde bulunan fiyatlar orjinal kalitede yenileme yapılmış kartuş fiyatları olmakla beraber, satışını yaptığımız muadil (yan sanayi) ürünlerin tamamı orijinal kartuştan farksız kaliteye sahiptir.
    samsung m2070 toner dolumu


  12. I feel really glad to read the blog with attractive . Online education is really gaining a global attention. I enjoy reading through your article post sap all modules
    sap mm training