Data model view with complex calculation capability
AssigneeSap SE
InventorsZhiqiang Wu, Zhongjie Fang
Life of this patent
Estimating the term…
Abstract
Described herein is a framework for providing data model views with complex calculation capability. In accordance with one aspect, the framework receives a request to calculate target results. An object in an application layer may be invoked to perform complex calculation to generate intermediate results. The intermediate results are stored in a global temporary table. A data model view in a database layer may then be invoked to calculate the target results based on the intermediate results retrieved from the global temporary table. The calculated target results are then returned.
Claims20
A computer system, comprising:
- one or more non-transitory memory devices for storing computer-readable program code within a database layer, an application layer, and a presentation layer;
- and
- one or more processors in communication with the one or more memory devices, the one or more processors being operative with the computer-readable program code to perform operations comprising:
- receiving, by the application layer, a request to calculate target results;
- in response to receiving the request to calculate target results, invoking, by the application layer, an object in the application layer to perform complex calculation to generate intermediate results;
- sending the intermediate results from the application layer to the database layer;
- storing, by the database layer, the intermediate results in a global temporary table residing in the database layer;
- invoking, by the application layer, a data model view in the database layer to calculate the target results based at least in part on the intermediate results;
- by the database layer, retrieving at least a portion of the intermediate results from the global temporary table;
- by the database layer, calculating the target results based at least in part on the retrieved at least a portion of the intermediate results;
- sending the target results from the database layer to the application layer;
- and
- returning, by the application layer to the presentation layer, the target results.
A method, implemented in a computing environment comprising one or more processors and one or more memories coupled to the one or more processors, comprising:
- receiving, by an application layer, a request to calculate target results;
- invoking an object in the application layer to perform complex calculation to generate intermediate results;
- sending the intermediate results from the application layer to a database layer;
- storing the intermediate results in a global temporary table maintained in the database layer;
- retrieving, by the database layer, at least a portion of the stored intermediate results;
- calculating the target results based at least in part on the intermediate results retrieved by the database layer from the global temporary table;
- and
- returning the target results to the application layer.
One or more non-transitory computer-readable media having stored thereon program code, the program code executable by a computer to perform operations comprising:
- receiving a request to calculate target results;
- performing complex calculation at an application layer to generate intermediate results;
- sending the intermediate results from the application layer to a database layer;
- storing the intermediate results in a global temporary table maintained in the database layer;
- by the database layer, retrieving the intermediate results from the global temporary table;
- calculating, by the database layer, the target results based at least in part on the intermediate results retrieved from the global temporary table;
- and
- returning the target results from the database layer to the application layer.
Dependencies are inferred from the claim text.