International Journal of Advances in Computer Science and Its Applications
Author(s) : ALEXANDER ADAM , KAMOL LIMTANYAKUL , PINAET PHOONSARAKUN , WOLFGANG BENN
Current databases use many different protocols to communicate with their clients. Applications running on that communication protocols have to implement support for each of them. In this paper, we propose an abstraction layer, that enables an application to be applicable to many database protocols, such as the database protocol TNS for Oracle database, TDS for Microsoft SQL Server, DRDA for IBM DB2, and so on, using only one abstract interface. On this layer, there will be various primary abstract functions that database protocol applications can customize or integrate them for their own particular purposes, such as SQL rewrite, analysis, timing, result set cache, direct generation of result sets, intrusion detection, etc. The aim of this paper is to develop and propose this abstraction layer. Finally we show some examples of applications utilizing the proposed abstraction layer, they are able not only to perform SQL rewrite and timing, but also support the database protocol TNS, TDS, and DRDA.