Article in Proceedings INPROC-1999-24

BibliographyJaedicke, Michael; Mitschang, Bernhard: User-Defined Table Operators: Enhancing Extensibility for ORDBMS.
In: VLDB'99, Proceedings of 25th International Conference on Very Large Data Bases, Edinburgh, Scotland, UK, September 7-10, 1999.
University of Stuttgart, Faculty of Computer Science.
pp. 494-505, english.
Morgan Kaufmann, May 4, 1999.
ISBN: 1-55860-615-7.
Article in Proceedings (Conference Paper).
CorporationInternational Conference on Very Large Data Bases
CR-SchemaH.2.4 (Database Management Systems)
Abstract

Currently parallel object-relational database technology is setting the direction for the future of data management. A central enhancement of object-relational database technology is the possibility to execute arbitrary user-defined functions within SQL statements. We show the limits of this approach and propose user-defined table operators as a new concept that allows the definition and implementation of arbitrary user-defined N-ary database operators, which can be programmed using SQL or Embedded SQL (with some extensions). Our approach leads to a new dimension of extensibility that allows to push more application code into the server with full support for efficient execution and parallel processing. Furthermore it allows performance enhancements of orders of magnitude for the evaluation of many queries with complex user-defined functions as we show for two concrete examples. Finally, our implementation perception guarantees that this approach fits well into the architectures of commercial object-relational database management systems.

Full text and
other links
Technical Report
ContactBernhard Mitschang mitsch@informatik.uni-stuttgart.de
Department(s)University of Stuttgart, Institute of Parallel and Distributed High-Performance Systems, Applications of Parallel and Distributed Systems
Project(s)MIDAS
Entry dateOctober 4, 2001
   Publ. Department   Publ. Institute   Publ. Computer Science