Re: (OT ?) How does SAP HANA Work

On 02/05/2017 08:29 PM, Hemant K Chitale wrote:
> Is SAP HANA an "SAP - ERP *only*" implementation ? OR is it targeted
> at "generic" databases ? Which ones (OLTP or DWH / DSS) ?
> How much content is loaded / processed "in-memory" ? How does it
> separate the "on-disk" data from the "in-memory processing" data ?
>
> --
>
> Hemant K Chitale
> http://hemantoracledba.blogspot.com
> http://hemantscribbles.blogspot.com
>

Hi Hemant,

SAP Hana is an OLTP database, which is entirely loaded into memory. It uses similar mechanism to Oracle redo logs to make the changes permanent.

https://help.sap.com/saphelp_hanaplatform/helpdata/en/c4/86a0a3bb571014ab46c0633224f02f/content.htm

There is also an express edition, if you want to download it an play with it:

http://www.sap.com/developer/topics/sap-hana-express.html

Stefan is the group's resident SAP expert, he can probably add more about SAP Hana.

-- 
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l