Proxy Framework for Database Extension: Database-Independent Function Extension


  • Pinaet Phoonsarakun Burapha University Sakaeo Campus
  • Alexander Adam Development Division, dimensio Informatics GmbH, 09111 Chemnitz, Germany
  • Attaporn Khaesawad Department of Information Technology, Burapha University Sakaeo Campus, 27160 Sakaeo
  • Seree Chinodom Department of Information Technology, Burapha University Sakaeo Campus, 27160 Sakaeo



Database Extension, Indexing, Proxy, Transparent


This paper presents a proxy framework, which allows introducing various functionalities in an existing database system and application environment. By using a proxy not interfering with the application and with the database are necessary. An abstraction layer is introduced to make functional modules, database independent, and illustrates its use in two examples – index integration and a result cache. Finally, an overview of the results that have been achieved is given.


IBM Deutschland GmbH. DB2 Spatial Extender und Geodetic Data Management Feature – Benutzer- und Referenzhandbuch, July 2006.

C. Murray. Oracle Spatial Developers Guide, 11g Release 2 (11.2). Oracle, Dec. 2009.

IBM. SQL Reference, Volume 1. IBM Corporation, Nov. 2009.

B. Rich. Oracle Database Reference, 11g Release 2 (11.2), Sept. 2011.

K. Stolze and T. Steinbach. DB2 Index Extensions by example and in detail, IBM Developer works DB2 library. Dec. 2003.

E. Belden, T. Chorma, D. Das, Y. Hu, S. Kotsovolos, G. Lee, R. Leyderman, S. Mavris, V. Moore, M. Morsi, C. Murray, D. Raphaely, H. Slattery, S. Sundara, and A. Yoaz. Oracle Database Data Cartridge Developers Guide, 11g Release 2 (11.2). Oracle, July 2009.

R. Menon. Expert Oracle JDBC Programming. Apress, 2005.

International Standard for Database Language SQL -Part 3: Call Level Interface, 1995.

J. Blakeley. In Compcon ’97. Proceedings, IEEE, title=Universal data access with OLE DB, pages 2–7, 1997.

D. Sceppa. Microsoft Ado. Net (Core Reference). Microsoft Press, 2002.

J. Melnick. Oracle Call Interface Programmer’s Guide, 11g Release 2 (11.2). Oracle, Oct. 2009.

Microsoft Corporation. Tabular Data Stream Protocol, Jan. 2013.

L. Guo and H. Wu. Design and implementation of TDS protocol analyzer. In Computer Science and Information Technology, 2009. ICCSIT 2009. 2nd IEEE International Conference on, pages 633–636, 2009., 2013.

The Open Group. DRDA V5 Vol. 1: Distributed Relational Database Architecture, Aug. 2011.

M. Aboelfotoh, T. Dean, and R. Mayor. An empirical evaluation of a language-based security testing technique. In Proceedings of the 2009 Conference of the Center for Advanced Studies on Collaborative Research, pages 112–121. ACM, 2009.

S. Leuoth, A. Adam, and W. Benn. Profit of extending standard relational databases with the Intelligent Cluster Index (ICIx). In ICARCV, pages 1198–1205. IEEE, 2010.

O. Görlitz. Inhaltsorientierte Indexierung auf Basis künstlicher neuronaler Netze. PhD thesis, 2005.

Adam, S. Leuoth, and W. Benn. Minimal-Invasive Indexintegration – Transparente Datenbankbeschleunigung. In I. Schmitt, S. Saretz, and M. Zierenberg, editors, Grundlagen von Datenbanken, volume 850 of CEUR Workshop Proceedings, pages 83–87., 2012.

Council, Transaction Processing Performance. TPC-H benchmark specification. Published at, 2008.

D. Litchfield. The Oracle Hacker’s Handbook: Hacking and Defending Oracle. John Wiley & Sons, Inc., New York, NY, USA, 2007.

S. Watt. SQL*Plus – Users Guilde and Reference, Release 10.2. Oracle, June 2005.




How to Cite

Phoonsarakun, P., Adam, A., Khaesawad, A., & Chinodom, S. (2014). Proxy Framework for Database Extension: Database-Independent Function Extension. Transactions on Engineering and Computing Sciences, 2(5), 17–26.