Patents by Inventor Claus Kempfert
Claus Kempfert has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Patent number: 10585909Abstract: 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.Type: GrantFiled: September 20, 2016Date of Patent: March 10, 2020Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Peter Bendel, Nicole Ying Finnie, Claus Kempfert, Knut Stolze
-
Patent number: 10387643Abstract: 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.Type: GrantFiled: July 31, 2018Date of Patent: August 20, 2019Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Peter Bendel, Nicole Y. Finnie, Claus Kempfert, Knut Stolze
-
Patent number: 10210327Abstract: 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.Type: GrantFiled: July 31, 2018Date of Patent: February 19, 2019Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Peter Bendel, Nicole Y. Finnie, Claus Kempfert, Knut Stolze
-
Publication number: 20180365413Abstract: 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.Type: ApplicationFiled: July 31, 2018Publication date: December 20, 2018Inventors: Peter Bendel, Nicole Y. Finnie, Claus Kempfert, Knut Stolze
-
Publication number: 20180336347Abstract: 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.Type: ApplicationFiled: July 31, 2018Publication date: November 22, 2018Inventors: Peter Bendel, Nicole Y. Finnie, Claus Kempfert, Knut Stolze
-
Patent number: 10095861Abstract: 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.Type: GrantFiled: November 25, 2015Date of Patent: October 9, 2018Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Peter Bendel, Nicole Y. Finnie, Claus Kempfert, Knut Stolze
-
Patent number: 10013312Abstract: 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.Type: GrantFiled: September 24, 2014Date of Patent: July 3, 2018Assignee: International Business Machines CorporationInventors: Bjoern Broll, Claus Kempfert, Oliver Koeth, Laura M. Kunioka-Weis, Knut Stolze
-
Patent number: 9892142Abstract: 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.Type: GrantFiled: June 20, 2012Date of Patent: February 13, 2018Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Margaret Zagelow, Curt L. Cotner, John A. McPherson, Jr., Claus Kempfert
-
Publication number: 20170097970Abstract: 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.Type: ApplicationFiled: September 20, 2016Publication date: April 6, 2017Inventors: PETER BENDEL, NICOLE YING FINNIE, CLAUS KEMPFERT, KNUT STOLZE
-
Publication number: 20170091446Abstract: 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.Type: ApplicationFiled: November 25, 2015Publication date: March 30, 2017Inventors: PETER BENDEL, NICOLE Y. FINNIE, CLAUS KEMPFERT, KNUT STOLZE
-
Patent number: 9286300Abstract: 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.Type: GrantFiled: May 2, 2013Date of Patent: March 15, 2016Assignee: International Business Machines CorporationInventors: Oliver Draese, Namik Hrle, Claus Kempfert, Oliver Koeth, Ruiping Li, Robert S. Muse, Knut Stolze, Guogen Zhang
-
Publication number: 20150142749Abstract: 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.Type: ApplicationFiled: September 24, 2014Publication date: May 21, 2015Inventors: Bjoern BROLL, Claus KEMPFERT, Oliver KOETH, Laura M. KUNIOKA-WEIS, Knut STOLZE
-
Patent number: 8825604Abstract: 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.Type: GrantFiled: September 28, 2012Date of Patent: September 2, 2014Assignee: International Business Machines CorporationInventors: Oliver Draese, Namik Hrle, Claus Kempfert, Oliver Koeth, Ruiping Li, Robert S. Muse, Knut Stolze, Guogen Zhang
-
Publication number: 20140095443Abstract: 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.Type: ApplicationFiled: May 2, 2013Publication date: April 3, 2014Applicant: International Business Machines CorporationInventors: Oliver Draese, Namik Hrle, Claus Kempfert, Oliver Koeth, Ruiping Li, Robert S. Muse, Knut Stolze, Guogen Zhang
-
Publication number: 20140095441Abstract: 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.Type: ApplicationFiled: September 28, 2012Publication date: April 3, 2014Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Oliver Draese, Namik Hrle, Claus Kempfert, Oliver Koeth, Ruiping Li, Robert S. Muse, Knut Stolze, Guogen Zhang
-
Publication number: 20120259824Abstract: 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.Type: ApplicationFiled: June 20, 2012Publication date: October 11, 2012Applicant: International Business Machines CorporationInventors: Margaret Zagelow, Curt L. Cotner, John A. McPherson, JR., Claus Kempfert
-
Patent number: 8239389Abstract: 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.Type: GrantFiled: September 29, 2008Date of Patent: August 7, 2012Assignee: International Business Machines CorporationInventors: Margaret Zagelow, Curt L. Cotner, John A. McPherson, Jr., Claus Kempfert
-
Publication number: 20100082630Abstract: 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.Type: ApplicationFiled: September 29, 2008Publication date: April 1, 2010Applicant: International Business Machines CorporationInventors: Margaret Zagelow, Curt L. Cotner, John A. McPherson, JR., Claus Kempfert