Invention Grant
- Patent Title: Data management system with stored procedures
-
Application No.: US15180398Application Date: 2016-06-13
-
Publication No.: US09886482B2Publication Date: 2018-02-06
- Inventor: Peter Bendel , Nicole Y. Finnie , Christian W. Hoerst , Knut Stolze
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Steve F. McDaniel
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F21/62

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.
Public/Granted literature
- US20160342654A1 DATA MANAGEMENT SYSTEM WITH STORED PROCEDURES Public/Granted day:2016-11-24
Information query