What are some of the reasons that Core Data Services are preferable to the classical approach to data modeling?

Core Data Services (CDS) are designed to optimize data modeling in SAP environments by leveraging the capabilities of the database layer. One of the distinguishing features of CDS is the implementation of code pushdown, which allows more processing to be done directly within the database system rather than transferring data back and forth between the database and the application server.

Choosing code pushdown means that operations to compute or aggregate data are executed where the data resides, significantly reducing the amount of data that needs to be transferred over the network. This leads to improved performance and efficiency, making further use of the database's processing power rather than relying heavily on the application server.

So, while transferring results to the application server and avoiding data transfer are related concepts, the essential advantage lies in the optimization achieved through code pushdown. This ensures that only the necessary results are sent back to the application server, minimizing bandwidth usage and enhancing response times for end-users. Thus, implementing code pushdown is a key reason why Core Data Services are preferable to classical data modeling approaches.