Re: SAP and HANA
Date: Fri, 18 May 2012 06:28:45 -0700 (PDT)
Message-ID: <1337347725.40871.YahooMailNeo_at_web110003.mail.gq1.yahoo.com>
Hi,
I do not have hands-on experience myself, but our client had implemented HANA recently in their SAP environment and they are pretty happy with initial results - query that was running 5 minutes 30 seconds (SAP+Oracle11.2), in SAP+HANA was completing in 12 seconds. Where all speed of HANA comes from comparing with traditional RDBMS? Different data storage concept - Column-oriented storage versus Row-oriented storage which allows fast access to data without using indexes, good compression ratio due to repeating data in columns - good academical paper on Column-oriented storage is here http://db.lcs.mit.edu/projects/cstore/vldb.pdf This is In-memory database. Please do not mix this concept with In-memory data caching - more reading on that http://en.wikipedia.org/wiki/In-memory_database, http://www.mcobject.com/in_memory_database My understanding is that similar concepts are embeded into Microsoft PowerPivot engine (http://www.powerpivot-info.com/). At this point HANA is read-only database (no transactions allowed) - in next version SAP claims that it will support transactions. I am just sharing information I have - it's up to you to interpret/decide if those new technologies have any future in DB landscape.
Regards
Mike Navickas
Oracle&DB2 DBA
From: Subodh Deshpande <deshpande.subodh_at_gmail.com> To: stmontgo_at_gmail.com
Cc: oracle-l <Oracle-L_at_freelists.org> Sent: Friday, May 18, 2012 4:30:21 AM
Subject: Re: SAP and HANA
The way in which new technologies are emerging such kind of challenges may arrive
If a revolutionary change occurs and if a new database can replace DB2 and/or Oracle, then definitely it will be a matter of concern.
Mostly HANNA will require more technical resources to manage the architecture, when every one is cutting down the cost on their present assets.
primafacie in memory database in this new sap and oracle times ten database are not different, and now please tell me the difference between times ten and huge sga with almost all objects cached in memory ! I think such databases are suitable for dataware house where as SAP is known for process means the databases will be more General purpose or OLTP..how it will benefit..i think somewhere it is written new sap db is going to use rule based optimiser
if suppose tomorrow a new features emerges in a database technology and in SQL engine, like when a query is fired it will decide where its a pure select query or also has dmls, ddls in its other query portion, it will decide what should be its plan, depending upon this the query execution will change..the nature of usage of undo, buffer cache will change...means memory gain..today we just mark dirty buffers..if dirty buffers are flagged depending upon the type of query the execution will change..may there will be multiple lru lists
by flagging I mean, select and insert requires index position, where as update and delete may change the index position..the query when fired should decide what is the nature of the query and should go ahead..
these are just thoughts..may be wrong..I am just a database user working as dba...
thanks and take care..subodh
On 17 May 2012 09:07, Art Vandelay <stmontgo_at_gmail.com> wrote:
> List,
> We're seeing some discussions in our organization around the SAP
> Database offering Hana.
> I'm interested to hear your thoughts on this
>
> Do you think this product will gain any traction?
>
> Do you believe Gartner when they state "A Double Wake Up Call for
> SAP's Competitors" - Should Larry be worried?
> http://www.gartner.com/technology/reprints.do?id=1-17OKEN0&ct1014&st=sb
>
> Is anyone running Hana and can they provide some feedback?
>
> I appreciate your thoughts on the matter.
>
> Steve
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- ============================================= Love me or Hate me both are in my Favour. Love me, I am in your Heart. Hate me, I am in your Mind. ============================================= -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Fri May 18 2012 - 08:28:45 CDT