Skip to Main Content
  • Questions

  • need to access hana columnar table data in Oracle 11g through remote source

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question.

Asked: November 26, 2016 - 6:56 am UTC

Last updated: November 27, 2016 - 7:59 am UTC

Version: Oracle 11g

Viewed 1000+ times

You Asked

what will be the performance impact, if I remote source hana tables to Oracle 11g for real-time data read and update some oracle master table. as Oracle is OLTP and hana is used as data warehouse.
Can you pls suggest, the performance impact due to deduplication and column store compression (Hana column store - Oracle row store)

and Connor said...

My understanding is that HANA => Oracle, or Oracle => HANA is ultimately just a client connection to the server (depending on which way the traffic is going).

So if Oracle is reading from HANA, it is no different to anyone else querying HANA - the cost is based the queries you are running.

If HANA is reading from Oracle, then HANA is no different to anyone else querying HANA - the cost is based the queries you are running.

The decompression etc will be a HANA cost, because its the application doing all that work.

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.