SAP HANA

[Former Member]

Hi Experts,

Can you please Explain the Architecture of Sap Hana?

Please share the Deck also!!

Thanks in advance!!

[skugan_venkatesan]

Hi,

I have a small clarification w.r.t HANA architecture. I do see that under In-memory computing engine only Index server is there.

So, Does Name Server, pre-processor, statistics and XS Engine servers are not in-memory? I mean, when I say Servers, it means the data stored w.r.t the particular server.. For example: Name Server- where will the data containing information topology of HANA system be stored? will it also  be stored in RAM or Physical Disk ?

Thanks,

Skugan V

[Former Member]

Hi Experts,

Being New to Sap Basis World..

I dont understand how it is working and how different componenets are working to provide in memory computing??

LIke Businees object Enterprise,ERP,Metedata Manager,and In memory Computing Engine.

Other one is -- How is it possible to keep all the data in Memory ??

If this is the case ,,then what would be the size of memory or cache??

Please Suggest!!

Thanks,

Swati

[Former Member]

Hi Swati,

Please refer to this Webinar. This webinar gives you a fair idea on SAP HANA's architecture

http://scn.sap.com/docs/DOC-13232

How is it possible to  keep all the data in Memory? As per my understanding all the data is stored in memory, so if you obtain a Hardware of 128GB RAM, equivalent amount of data can be stored.

So you need to decide on which tables to stored in HANA and what is their expected growth.

SAP is also going to DISK based store inside the HANA architecture in future releases which is as per the above Webinar which will allow you to store data in disk and read from disk as well directly. this will particularly help when you have historical data in HANA DB which you rarely use.

REFER to below statement's

Actions During System Restart

Last savepoint must be restored plus…

• Undo logs must be read for uncommitted transactions saved with last savepoint
• Redo logs for committed transactions since last savepoint

Complete content of row store is loaded into memory

Column store tables may be marked for preload or not. Only tables marked for preload

are loaded into memory during startup

If table is marked for loading on demand, the restore procedure is invoked on first access

Thanks

Karthik N S

[Former Member]

See also the LOAD, UNLOAD and MERGE options that are available against a COLUMN table in HANA Studio which will give you some management capabilities in terms or deciding which table can be loaded to memory or which can unloaded from memory. I have not checked these things practically but I am sharing what I understand from various HANA documents

Thanks

Karthik N S

[Former Member]

Thanks for information!!

But i have this PPt's with me..

Only thing is i am not able to undertsand this architecture..

Can anyone help me out in understanding this??

[Former Member]

Thanks for information!!
> But i have this PPt's with me..
> Only thing is i am not able to undertsand this architecture..
> Can anyone help me out in understanding this??

Hello,

Could you be a bit more specific, what doubt you have in HANA architecture ?

Thanks

[michael_ruth3]

HANA is like a separate database and BW sits on top of it. So any processing done in BW will be done in HANA instead as previously in the database of the system. That's a 10,000 foot overview but I think the links the other people ave you might help.

Cheers,

Michael

[Former Member]

Hi,

Please check the following link for HANA system architecture details.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70d16119-ad21-2e10-de8b-eaaedf86b...

Hope this helps.

Regards,

Varun

[sunny_pahuja2]

Hi,

Check below link:

http://www.sdn.sap.com/irj/sdn/in-memory

Thanks

Sunny