Data management system with stored procedures

US9886482B2 · kind B2 · utility

Assignee

• International Business Machines Corporation · US

Inventors

• Peter Bendel · Holzgerlingen, DE
• Nicole Ying Finnie · Eppelheim, DE
• Christian Wilhelm Paul Hoerst · Eppelheim, DE
• Knut Stolze · Jena, DE

Key dates

• Filing date: Jun 13, 2016
• Grant date: Feb 6, 2018
• Expiry date: Jun 13, 2036

Classification

• Technology area (CPC G): Physics
• CPC primary: G06F21/6236
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

Abstract

A method includes storing a first stored procedure in a first database management module and a second stored procedure in a second database management module, receiving by the first database management module a request to run a computational task with the first stored procedure, receiving a request to perform the computational task and in response thereto causing a first query optimizer in the first database management module to automatically compute a query execution plan for the first stored procedure, using the query execution plan to identify all first data containers on the first database management module that provide input data for the requested computational task, identifying a list of names of all second data containers mapped to the identified first data containers, and performing the second stored procedure using the list of names. A corresponding computer program product and data management system are also disclosed herein.