Example Analysis of Database layer of SAP Netweaver and Hybris

This article introduces the SAP Netweaver and Hybris database layer example analysis, the content is very detailed, interested friends can refer to, hope to be helpful to you.

ABAP Netweaver

In SAP Netweaver-based ABAP applications, application developers use Open SQL to access databases, and these Open SQL are converted by Database interface (database interface) into native SQL statements supported by various database providers and executed.

Database providers supported by Netweaver can see this in the DBMS field of table DBCON:

In addition to ordinary ABAP Open SQL statements used to add, delete, query and modify business data, Enterprise Search (sometimes called simple search, fuzzy search) is also supported in SAP CRM and C4C. Just like Google search, users only need to specify the value to be searched without specifying the search conditions corresponding to the search value.

The principle of Enterprise Search implementation in these two products is actually that the application initiates a RFC (Remote Function Call) to get the query results on the TREX server.

For an introduction to SAP TREX, please refer to wikipedia.

Https://en.wikipedia.org/wiki/TREX_search_engine

Hybris

There are also layers in Hybris that play the same role as the API layer in CRM WebUI, encapsulating the operation of DB.

The implementation of database access in Hybris is encapsulated in a large number of Java class ending in DAO (Data Access Object), which is equivalent to those function module in the SAP CRM API layer.

Click on a DAO to see the implementation, which also spells out the SQL statement and throws it to the DB for execution:

The SQL statement assembled in the above code is not the native SQL language associated with the data provider, but a new language called Flexible Search. Like ABAP's OPEN SQL, it decouples the code of the Hybris application accessing the database layer from the underlying database.

You can see a list of supported databases on the Hybris help documentation:

The database used in the Hybris development environment is called HSQLDB: an open source relational database system developed by lightweight pure Java.

This is the end of the sample analysis of the database layer of SAP Netweaver and Hybris. I hope the above content can be of some help and learn more. If you think the article is good, you can share it for more people to see.