SQLScript advantages in SAP HANA

[Former Member]

Hi Experts,

Where exactly we can leverage SQLScript to fetch or for calculations as we already have attribute, analytical and calculations views to do the same on HANA Database.

What are the advantages or disadvantages of using Modeling and SQLScript in building HANA applications?

[Former Member]

Hi Naveen,

     SQLScript is used to embed data-intensive application logic into the database. Nowadays

most of the application logic is normally executed in an application server. When executing data intensive logic, this copying of data is very expensive in terms of processor and data transfer time. Moreover, when using an imperative language like ABAP or JAVA for processing data, developers tend to write algorithms which follow a one tuple at a time semantics (for example looping over rows in a table). However, these algorithms are hard to optimize and parallelize compared to declarative set-oriented languages such as SQL. SQLScript is designed to provide superior optimization possibilities.

You can refer this link to get more idea about SQLScript and why it is used for HANA database.

http://help.sap.com/hana/sap_hana_sql_script_reference_en.pdf

I hope this helps,

Cheers,

Sumit