on 08-30-2019 8:37 AM
Hi
I have just completed the OpenSAP course on ABAP Development for SAP HANA. After that I was still trying to understand why the Code to Data paradigm is "new" news... I think we all understand that doing operations is better at the Database Level rather than at the Application Level has been known since databases were "invented" . - so there is no surprise there.
SAP have given us HANA - great job !... SAP have given us CDS etc and improved Open SQL greatly.
So I have SAP running on SAP Hana - if you had to select data that required CASE, COALESCE, UNION and you can do this in ABAP Open SQL in a regular ABAP why would you go off into yet another tool - Eclipse and create a CDS view or AMDP. Would it perform better ?
Code pushdown is nothing new, you are absolutely right. It's just "new" for many ABAP developers. And in addition before NW 7.40 SP5/8 ABAP SQL just hadn't enough power (CASE, COALESCE, UNION ) to do many pushdowns.
AMDP adds the ability to execute SQL Script and other database dependent features like Graph processing.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
CDS views offers the capabilities to push down several filters to the database level that weren’t available before. One eg is the authorization restrictions which are applied after data selection. Now with CDS DCL concept these filter/restrictions are pushed down to the dB level.
Another major benefit is the power to aggregate and to manipulate this using dB hints defined using CDS views. They instruct the dB how to execute the query.
Some of these capabilities weren’t available before. So it’s more about adding features rather than introducing a new concept.
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
77 | |
11 | |
10 | |
8 | |
6 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.