Skip to Content
-1

Spatial Analysis - in SAP HANA XSJS

Apr 23 at 09:51 AM

38

avatar image

Hi Friends

I am trying to understand, if we can use ST_POINT, ST_DISTANCE spatial analysis functions directly in XSJS (via CDS)

Thanks for your inputs

Regards

Giri

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Thomas Jung
Apr 23 at 01:40 PM
0

What do you mean directly in XSJS via CDS? Do you mean XSJS or CDS? From XSJS you can issue SQL statements and use such functions within this SQL.

Show 4 Share
10 |10000 characters needed characters left characters exceeded

Thanks Thomas, for the response.

We have achieved this by putting the logic in an Stored Proc. But the response time is not that great. So we thought of using/calling these function (ST_POINT & ST_DISTANCE) from XSJS.

As we were using XSDS for all the interactions with HANA, which is much faster than executing the SQL statements, from XSJS. Can this be possible using XSDS? Thank you

Regards

Giri

0

First question would be why is the response time calling via Stored Procedure not good?

XSDS does not support spatial SQL Functions. Nor would I really recommend the use of XSDS as it isn't supported forward into XSA. Once you migrate you will have to rewrite/redesign your application.

0

We are not just using this logic, but there are few other calculations in the SP. The response time is around 2 seconds, But we are looking for a response below 1 second.

So far, I am in a understanding that, XSDS will give us faster responses than calling a SP/Calc view from XSJS. Hence I am planning to pull the logic from SPs and achieve that in XSJS using XSDS libraries.

In fact we are using XSDS to pull the data from HANA CDS Tables, for all the existing XSJS services. (These tables are populated via SPs which calls the Calc views)

We are migrating to XSA, our environment is ready as well. Will the migration assistant does this re-design?

Thanks for your response

Regards

Giri

0

>We are migrating to XSA, our environment is ready as well. Will the migration assistant does this re-design?

No

0