Method and system for managing external routines in a database management system

a database management system and external routine technology, applied in the field of managing routines, can solve problems such as logistical challenges, inconvenient management, and increased burden on the system administrator

What is AI technical title?
AI technical title is built by PatSnap AI team. It summarizes the technical point description of the patent document.
a database management system and external routine technology, applied in the field of managing routines, can solve problems such as logistical challenges, inconvenient management, and increased burden on the system administrator

US20070038662A1Inactive Publication Date: 2007-02-15IBM CORP

11 Cites 32 Cited by

Image

Smart Image Click on the blue labels to locate them in the text.

Viewing Examples

Smart Image

Examples

Experimental program

Comparison scheme

Effect test

Embodiment Construction

[0015] Embodiments of the present invention relate to managing external routines, such as stored procedures and user-defined functions, in a computer implemented database system. Various modifications to the preferred embodiment and the generic principles and features described herein will be readily apparent to those skilled in the art. For example, the following discussion is presented in the context of a DB2® database environment available from IBM® Corporation. It should be understood, however, that the present invention is not limited to DB2 and may be implemented with other relational database systems. Thus, the present invention is to be accorded the widest scope consistent with the principles and features described herein.

[0016] An exemplary computer hardware environment that utilizes a DBMS is illustrated in FIG. 1. A distributed computer system 10 utilizes a network to connect client systems 11 executing client applications to a database server 12 executing software and o...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine

Login to View More

PUM

Login to View More

Abstract

A method for managing an external routine in a computer implemented database management system includes creating a first table for storing external routines in a data store coupled to the database management system. An external routine is stored in the first table so that the database management system is allowed to automatically manage any modification related to the external routine and to control access to the external routine such that administrative support is minimized.

Description

FIELD OF THE INVENTION [0001] The present invention relates to database management systems and in particular, to managing routines, such as stored procedures or user defined functions, in a database management system. BACKGROUND OF THE INVENTION [0002] Database management systems (DBMS) maintain and manage data stored in databases. Management includes storing, deleting, retrieving and updating the data. Typically, data stored in a database includes plain values, e.g., numbers and alphanumeric strings, and complex objects such as images, documents and spatial data. The DBMS typically is hosted by a database server that is accessible by a plurality of client systems via a network. [0003] In state of the art systems, the DBMS is capable of invoking executable code to manipulate the data in the database. In some systems, when instructed, the DBMS can automatically load and execute the code. Such executable code, known as an external routine, can be a stored procedure (STP) or a user def...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine

Login to View More

Application Information

Patent Timeline

15 Feb 2007

Publication

US20070038662A1

IPC: G06F7/00

CPC: G06F17/30289; G06F16/21

Inventors: BENDEL, PETER; MEYER, GREGOR