External Database Extension Framework

Alexander Adam, Wolfgang Benn


Database systems nowadays show an incredible amount of extensibility interfaces, ranging from simple user defined functions to extensible indexing frameworks as seen in e. g. DB2 and Oracle. Approaching new projects using these interfaces definitely is a valuable option. For legacy systems, already set up and running in production environments, these options are often not available since most of them impose a change in the applications. In this work we present a database extension framework, that enables the user to define functionality which does not reside inside the database. We show different ways to integrate it into existing application landscapes without further modifications.


  1. (1995). International Standard for Database Language SQL - Part 3: Call Level Interface.
  2. (2009). PostgreSQL 8.4.3 Documentation. The PostgresSQL Global Development Group.
  3. (2013). http://www.greensql.com.
  4. (2013). Tabular Data Stream Protocol. Microsoft Corporation.
  5. Aboelfotoh, M., Dean, T., and Mayor, R. (2009). 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.
  6. Belden, E., Chorma, T., Das, D., Hu, Y., Kotsovolos, S., Lee, G., Leyderman, R., Mavris, S., Moore, V., Morsi, M., Murray, C., Raphaely, D., Slattery, H., Sundara, S., and Yoaz, A. (2009). Oracle Database Data Cartridge Developers Guide, 11g Release 2 (11.2). Oracle.
  7. Blakeley, J. (1997). In Compcon 7897. Proceedings, IEEE, title=Universal data access with OLE DB, pages 2-7.
  8. G├Ârlitz, O. (2005). Inhaltsorientierte Indexierung auf Basis k├╝nstlicher neuronaler Netze. PhD thesis.
  9. Guo, L. and Wu, H. (2009). Design and implementation of TDS protocol analyzer. In Computer Science and Information Technology, 2009. ICCSIT 2009. 2nd IEEE International Conference on, pages 633-636.
  10. IBM (2009). SQL Reference, Volume 1. IBM Corporation.
  11. Kansy, T. and Schwichtenberg, H. (2012). Datenbankprogrammierung mit .NET 4.5: Mit Visual Studio 2012 und SQL Server 2012. .NET-Bibliothek. Hanser Fachbuchverlag.
  12. Leuoth, S., Adam, A., and Benn, W. (2010). Profit of extending standard relational databases with the Intelligent Cluster Index (ICIx). In ICARCV, pages 1198- 1205. IEEE.
  13. Melnick, J. (2009). Oracle Call Interface Programmer's Guide, 11g Release 2 (11.2). Oracle.
  14. Menon, R. (2005). Expert Oracle JDBC Programming. Apress.
  15. Phoonsarakun, P., Adam, A., Lamtanyakul, K., and Benn, W. (2013). Extensible Database Communication Modification Framework. In Singh, R. K., editor, Proceedings of the Second International Conference on Advances in Information Technology AIT 2013.
  16. Rich, B. (2011). Oracle Database Reference, 11g Release 2 (11.2).
  17. Stolze, K. and Steinbach, T. (2003). DB2 Index Extensions by example and in detail, IBM Developer works DB2 library.
  18. The Open Group (2011). DRDA V5 Vol. 1: Distributed Relational Database Architecture.

Paper Citation

in Harvard Style

Adam A. and Benn W. (2014). External Database Extension Framework . In Proceedings of the 16th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-758-027-7, pages 249-255. DOI: 10.5220/0004896302490255

in Bibtex Style

author={Alexander Adam and Wolfgang Benn},
title={External Database Extension Framework},
booktitle={Proceedings of the 16th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},

in EndNote Style

JO - Proceedings of the 16th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - External Database Extension Framework
SN - 978-989-758-027-7
AU - Adam A.
AU - Benn W.
PY - 2014
SP - 249
EP - 255
DO - 10.5220/0004896302490255