cancel
Showing results for 
Search instead for 
Did you mean: 

Is there volatility issue of in-memory DBMSs?

0 Kudos

Hello Everyone,

I happen to read one article, there it is also mentioned that "If you pull the plug on a computer with an in-memory database, you've lost everything".

Request you to kindly share your thoughts if this scenario is really a concern? If yes, then how this has to be overcome?

Regards,

Ajay J

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Ajay.

I dont know what article was that, and to witch technology it was about, but regarding SAP Hana, that will never happen.

SAP Hana has the database in memory, but it also has a persistent disc with all the database.

All the changes in the database are writen to logs and commited to persistence at time intervals - SAVEPOINTS.

So if you pull the plug, you will not loose everything.

Please verify the SAP documentation about this, it´s very specific.

http://service.sap.com/sap/support/notes/2100009

Regards.

Osvaldo.

Answers (2)

Answers (2)

davidebruno
Participant
0 Kudos

there is a persistent layer on disk.........................obviously

former_member185132
Active Contributor
0 Kudos

If this scenario was actually a concern, SAP wouldn't be able to sell analytical or transaction-processing solutions on HANA such as S/4 would they? Customers would take a rather dim view of a database that you could wipe out by pulling a plug.

No wonder, that the DB does have a persistence layer for this reason. I would suggest going over the documentation, starting with the link below.

https://help.sap.com/saphelp_hanaplatform/helpdata/en/d8/d14ef53e244f6cabd10dd3f5e8c11e/content.htm?...