Skip to Content
avatar image
Former Member

SQLScript advantages in SAP HANA

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 29, 2014 at 10:44 AM

    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

    Add comment
    10|10000 characters needed characters exceeded