What is data base interface and the role it will play while retrieving data

[Former Member]

What is data base interface and the role it will play while retrieving data.

[Former Member]

Hi,

Dtabase interface will convert the Open SQL to the corresponding Native Sql for accessing data from the database

Regards,

Ram

Pls reward points if helpful....

[Former Member]

Hi,

check out the following link.

http://help.sap.com/saphelp_nw04s/helpdata/en/97/68d64260752a78e10000000a155106/frameset.htm

it says:

Database Interface

Interface to the database of the NetWeaver AS ABAP that is integrated in the ABAP-runtime environment. The statements of Open SQL and Native SQL access the database using the database interface. The database interface is responsible for data transport between business layer and persistence layer, automatic client handling, and SAP buffering.

hope it helps.

Regards,

kinshuk

[Former Member]

data base interface is conection between the data base layer and application layer. it act as a mediater between both layers.

using this interface we can featch the data from database and make it process in application layer and display it in prasentation layer.

[seshatalpasai_madala]

Hi,

Database interface is the process that runs in each of the workprocess of the application server. Its role is to convert the OPEN SQL statements into native SQL statements and based onthe query define the acess stratergy. That is when you use a select statement it decides which index can be used or can we use buffered data all that stuff.

Its basically a mediator between Application server and Database server and performance optimizer as it has access to buffers.

Regards,

Sesh