SAP HANA Temporal Table and History Table

[Raja]

Hi Experts,

SAP HANA History table is explained in the links like

• http://help.sap.com/hana/html/sql_create_table_history_time_travel.html
• http://help.sap.com/hana/html/sql_select.html

SAP HANA Temporal table is explained in the development guide and scn like:

• http://help.sap.com/hana/SAP_HANA_Developer_Guide_en.pdf

Both of them seems exactly to be same. But there are no supporting documents which says that History table and Temporal table are same thing.

Q: Are history table and temporary table exactly same? If not, what is the difference?

Regards,

Raja

[vivekbhoj]

Hi Raja,

I have not used Temporal table concept

As per the below Video regarding Temporal concept on DB2:

DB2 Temporal tables best practices - YouTube

My understanding of Temporal table is a table that it has time fields and has all the updated records and at the same time also has a history table associated with it where it records all the changes

So we can say history table is also part of Temporal table concept. Now this is how it is implemented in DB2. Don't know if HANA uses it the same way or not

Hope to see better replies from other SCN members

Regards,

Vivek

[Raja]

Hi Vivek,

"History table is a part of Temporal table concept"

Thats exactly what I also thinks.

In HANA SQL there is nothing like create temporal table. Hence it seems temporal table is a general concept and history table is HANA's way of supporting this.

But I could not find a doc which supports my understanding.

Regards,

Raja