Hot deployment of embedded database procedures

US9753971B2 · kind B2 · utility

Assignee

• SAP SE · DE

Inventors

• Martin Hartig · Speyer, DE
• Helmut Prestel · Bad Schönborn, DE
• Rolf Hammer · Walldorf, DE
• Kai Baumgarten · Walldorf, DE
• Sigrid Wortmann · Walldorf, DE
• Christiane Kettschau · Leimen, DE
• Stefan Werner · Hamburg, DE
• Ralf Wendelgass · Walldorf, DE

Key dates

• Filing date: Nov 20, 2014
• Grant date: Sep 5, 2017
• Expiry date: Feb 5, 2036

Classification

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

Abstract

Disclosed herein are systems and methods for the hot deployment of database procedures embedded in a host software application. In various example embodiments, the database procedures are encapsulated in specially marked methods of the host application, which, when called at runtime, cause the database procedures, and associated procedure stubs through which the database procedures are called, to be created in a database catalog and executed on the database server. When an embedded database procedure is modified in an application by one user during execution of that application by a second user, compilation of the modified database procedure may result in deletion of the original database procedure and/or associated procedure stub from the database, avoiding inconsistencies between database procedure versions during application execution by the second user.