Sap Se

Sap Ag

Frank O Schulz

Michael Seubert

Werner Gnan

Thilo Kraehmer

Martin J Wilmes

Stefan J Moeller

Michael Hartel

Benjamin Ringl

Thomas Friedrich

Martin Schmidt

Sergio Rozenszajn

Daniel Scheibli

Sabine Seelenmeyer

A determination is made that an execution plan for a received structure query language (SQL) database query to execute on a database is not present in a database plan cache. An external offline optimization process is triggered to generate an externally optimized execution plan for the SQL database query. The generation of the externally optimized execution plan includes: receiving all or part of the received SQL database query as SQL statements and metadata associated with the database, looping over and analyzing all the received SQL statements, selecting at least one an optimization strategy for the SQL statements; and executing the selected at least one optimization strategy to generate the externally optimized execution plan. The externally optimized execution plan is then pinned into the database plan cache.

External offline query optimization

A business object model, which reflects data that is used during a given business transaction, is utilized to generate interfaces. This business object model facilitates commercial transactions by providing consistent interfaces that are suitable for use across industries, across businesses, and across different departments within a business during a business transaction. In some operations, software creates, updates, or otherwise processes information related to a goods tag, a production bill of material hierarchy, and/or a release order template business object.

Managing consistent interfaces for goods tag, production bill of material hierarchy, and release order template business objects across heterogeneous systems

Growing community of inventors

Schwetzingen, Germany

Frank O Schulz