Sap Se

Sigrid K Wortmann

Helmut Prestel

Rolf Hammer

Kai Baumgarten

Ralf Wendelgass

Martin Hartig

Christiane Kettschau

Stefan Werner

Christoph Weyerhaeuser

Boris Gruschko

Christian Mohr

Martin Strenge

Andreas Blumenthal

Reiner Singer

Kerstin Hoeft

Sebastian Seifert

Andreas Simon Schmitt

Welf N Walter

Philipp Grosse

Yu Su

Jens Lieberum

Veit Spaegele

Thomas Elvers

Junhui Liu

Juan Ge

Jianfeng Yan

Disclosed herein are systems and methods for embedding database procedures in data-driven software applications written in a language different from the database-procedure language. For example, in some embodiments, the hosting application may be written in ABAP whereas the database procedure may be written in SQLScript. In various embodiments, the database procedures are encapsulated in specially marked methods of the host application, which, when called at runtime, cause the database procedures to be created in a database catalog and executed on a database server.

Embedding database procedures in data-driven applications

Disclosed herein are systems and methods facilitating extensions to software applications that access a database, and in particular to applications with embedded database procedures. In various embodiments, an extension anchor embedded in the application as well as one or more extensions implemented as database procedures are encapsulated in specially marked database-procedure methods.

Extensibility of embedded database procedures

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.

Hot deployment of embedded database procedures

In one embodiment, a method includes defining a parent structure including an extension. A polymorphic structure is defined for the extension. The polymorphic structure is associated with a plurality of client specialization structures, each client specialization being associated with a client in a plurality of clients. During runtime by a computing device, the parent structure is generated with an extension to a client specialization structure associated with one of the plurality of clients where client specialization structures associated with other clients are not visible to the parent structure.

Generic boxed components for multi-client systems

Methods and apparatus, including computer program products, are provided for implementing a cooperative model between an application and a database. In one aspect, there is provided a computer-implemented method. The method may include receiving from an application a command to perform an operation at a database; accessing metadata representative of the application; configuring, based on at least the metadata, a result of the operation; and sending the configured result to shared memory accessible by the application. Related apparatus, systems, methods, and articles are also described.

Cooperative model between an application server and a database

Growing community of inventors

Heidelberg, Germany

Sigrid K Wortmann