topic What is data base interface and the role it will play while retrieving data in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/what-is-data-base-interface-and-the-role-it-will-play-while-retrieving-data/m-p/1700575#M307181 <HTML><HEAD></HEAD><BODY><P>What is data base interface and the role it will play while retrieving data.</P></BODY></HTML> Tue, 07 Nov 2006 08:34:30 GMT Former Member 2006-11-07T08:34:30Z What is data base interface and the role it will play while retrieving data https://community.sap.com/t5/application-development-and-automation-discussions/what-is-data-base-interface-and-the-role-it-will-play-while-retrieving-data/m-p/1700575#M307181 <HTML><HEAD></HEAD><BODY><P>What is data base interface and the role it will play while retrieving data.</P></BODY></HTML> Tue, 07 Nov 2006 08:34:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/what-is-data-base-interface-and-the-role-it-will-play-while-retrieving-data/m-p/1700575#M307181 Former Member 2006-11-07T08:34:30Z Re: What is data base interface and the role it will play while retrieving data https://community.sap.com/t5/application-development-and-automation-discussions/what-is-data-base-interface-and-the-role-it-will-play-while-retrieving-data/m-p/1700576#M307182 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Dtabase interface will convert the Open SQL to the corresponding Native Sql for accessing data from the database</P><P></P><P>Regards,</P><P>Ram</P><P></P><P></P><P>Pls reward points if helpful....</P></BODY></HTML> Tue, 07 Nov 2006 08:38:20 GMT https://community.sap.com/t5/application-development-and-automation-discussions/what-is-data-base-interface-and-the-role-it-will-play-while-retrieving-data/m-p/1700576#M307182 Former Member 2006-11-07T08:38:20Z Re: What is data base interface and the role it will play while retrieving data https://community.sap.com/t5/application-development-and-automation-discussions/what-is-data-base-interface-and-the-role-it-will-play-while-retrieving-data/m-p/1700577#M307183 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> check out the following link.</P><P><A href="http://help.sap.com/saphelp_nw04s/helpdata/en/97/68d64260752a78e10000000a155106/frameset.htm" target="test_blank">http://help.sap.com/saphelp_nw04s/helpdata/en/97/68d64260752a78e10000000a155106/frameset.htm</A></P><P></P><P>it says: </P><P>Database Interface</P><P></P><P>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.</P><P></P><P>hope it helps.</P><P>Regards,</P><P>kinshuk</P></BODY></HTML> Tue, 07 Nov 2006 08:39:13 GMT https://community.sap.com/t5/application-development-and-automation-discussions/what-is-data-base-interface-and-the-role-it-will-play-while-retrieving-data/m-p/1700577#M307183 Former Member 2006-11-07T08:39:13Z Re: What is data base interface and the role it will play while retrieving data https://community.sap.com/t5/application-development-and-automation-discussions/what-is-data-base-interface-and-the-role-it-will-play-while-retrieving-data/m-p/1700578#M307184 <HTML><HEAD></HEAD><BODY><P>data base interface is conection between the data base layer and application layer. it act as a mediater between both layers.</P><P></P><P>using this interface we can featch the data from database and make it process in application layer and display it in prasentation layer.</P></BODY></HTML> Tue, 07 Nov 2006 08:39:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/what-is-data-base-interface-and-the-role-it-will-play-while-retrieving-data/m-p/1700578#M307184 Former Member 2006-11-07T08:39:36Z Re: What is data base interface and the role it will play while retrieving data https://community.sap.com/t5/application-development-and-automation-discussions/what-is-data-base-interface-and-the-role-it-will-play-while-retrieving-data/m-p/1700579#M307185 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P> 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.</P><P></P><P>Its basically a mediator between Application server and Database server and performance optimizer as it has access to buffers.</P><P></P><P>Regards,</P><P>Sesh</P></BODY></HTML> Tue, 07 Nov 2006 08:42:48 GMT https://community.sap.com/t5/application-development-and-automation-discussions/what-is-data-base-interface-and-the-role-it-will-play-while-retrieving-data/m-p/1700579#M307185 seshatalpasai_madala 2006-11-07T08:42:48Z