International Business Machines Corporation

Claus Kempfert

Knut Stolze

Peter Bendel

Nicole Finnie

Oliver Koeth

Namik Hrle

Curt Lee Cotner

Guogen Zhang

Oliver Draese

Ruiping Li

John A McPherson, Jr

Margaret Zagelow

Robert S Muse

Laura Michiko Kunioka-Weis

Bjoern Broll

A method for executing a computational task in a data management system is provided. The method includes storing a first stored procedure in a first database management system (DBMS) including first data containers. The first stored procedure receives names of one or more of the first data containers to act as input or output data containers and includes first statements for triggering resolution of features of a respective first input or output data container. The method also includes storing a second stored procedure in a second DBMS including second data containers. The second stored procedure implements the computational task and operates on one or more of the second data containers. The method also includes receiving, by the first DBMS, a request from a client application to perform the computational task.

Task-execution in a DBMS using stored procedures

Securing invocation of stored procedures is provided herein. A first database management system (DBMS) can include a first database with first tables, a first user management module configured to manage privileges of database users (DB-users) of the first DBMS, and at least one first stored procedure. A second DBMS can include a second database with second tables, a second user management module configured to manage privileges of DB-users of the second DBMS, and at least one second stored procedure, the at least one second stored procedure configured to perform a computational task in the second DBMS. A synchronization mapping can map at least a portion of the first tables to respective ones of the second tables. Thus, a transfer of data of at least some of the first tables to the respective ones of the second tables in accordance with the synchronization-mapping can be performed.

Secure invocation of stored procedures in database management systems

A method for archiving a predefined portion of a table residing in a database system includes: creating a first backup copy of the portion of the table; assigning to the portion of the table an access state flag; setting the access state flag; using the access state flag for preventing modification of existing backup copies of the portion of the table and for preventing further backup operations on the portion of the table; archiving the portion of the table to a separate system; deleting the content of the portion of the table from the database system and retaining the access state flag in the database system.

Method and system for a safe archiving of data

In a particular embodiment, a method includes storing, at a staging table of a database, a data update generated based on a transaction performed with respect to a data table that is associated with one or more indexes. Each index of the one or more indexes is maintained externally to the database. The method further includes maintaining the data update at the staging table at least until index update data is received at the database. The index update data represents a modification, based on the data update, to a particular index of the one or more the indexes.

Maintaining index data in a database

At least a portion of data from a first processing system is archived onto a second processing system based on partitions of the data. A query received at the first processing system is processed at the second processing system to retrieve archived data satisfying the received query in response to determining at the first processing system that the received query encompasses archived data. Embodiments of the present invention further include methods, systems, and computer program products for archiving and accessing data in substantially the same manner described above.

Archiving data in database management systems

According to one embodiment of the present invention, at least a portion of data from a first processing system is archived onto a second processing system based on partitions of the data. A query received at the first processing system is processed at the second processing system to retrieve archived data satisfying the received query in response to determining at the first processing system that the received query encompasses archived data. Embodiments of the present invention further include methods, systems, and computer program products for archiving and accessing data in substantially the same manner described above.

Systems, methods, and computer program products to persist external index data in a database are disclosed. In an embodiment, a method includes maintaining a database including a first data table that is configured to store data in a database format and a second data table that is configured to store index data. The index data represents an index of a first portion of the first data table, and the index maintained externally to the database by an index manager. The method also includes generating a data update representing a modification to the first data table and communicating the data update to the index manager. The method further includes receiving index update data from the index manager representing a modification to the index as a result of the data update and applying the index update data to the second data table.

Growing community of inventors

Altdorf, Germany

Claus Kempfert