IP Library Granted Patent US 9,104,724
Granted Patent B2
US 9,104,724 · App. 13/798,364 · Granted Aug 11, 2015

Dynamic bridging of application and data servers

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 9,104,724
App. No.
13/798,364
Granted
Aug 11, 2015
Kind
B2
Abstract

Described herein is a technology to facilitate dynamic bridging of an application server and a data server. In accordance with one aspect, a query script based on source code of an application is generated at the application server. The query script may include at least one placeholder that represents a dynamic term in the source code of the application. The query script may be processed by replacing the placeholder with a static term generated based on one or more values received during execution of the application. The query script is then executed to manage data at a data server.

Claims (35)

1. A method of dynamically bridging an application server and a data server, comprising:

generating, by the application server, a query script by paraphrasing source code of an application, wherein the query script includes at least one placeholder that represents a dynamic term in the source code;

processing, by the application server, the query script by replacing the placeholder with a static term generated based on one or more values received during execution of the application;

validating, by the application server, the query script to minimize security risks; and

executing, by the application server via a database interface, the query script to manage data at a data server.

2. A method of dynamically bridging an application server and a data server, comprising:

generating, by the application server, a query script by paraphrasing source code of an application, wherein the query script includes at least one placeholder that represents a dynamic term in the source code;

processing, by the application server, the query script by replacing the placeholder with a static term generated based on one or more values received during execution of the application; and

executing the query script to manage data at a data server.

3. The method of claim 2 wherein the source code comprises ABAP™ code.

4. The method of claim 2 wherein the data server comprises an in-memory database.

5. The method of claim 2 wherein generating the query script comprises paraphrasing database-independent source code of the application into equivalent query statements that are native to the data server.

6. The method of claim 5 wherein the query statements are based on SQL language or extensions thereof.

7. The method of claim 2 further comprising storing the query script as a function module in the application server.

8. The method of claim 2 wherein the dynamic term comprises a dynamic condition.

9. The method of claim 8 wherein the dynamic condition comprises a WHERE condition.

10. The method of claim 8 wherein the dynamic condition is stored in an internal table.

11. The method of claim 10 wherein the internal table comprises a range table.

12. The method of claim 2 wherein the dynamic term comprises a dynamic variable.

13. The method of claim 2 wherein the one or more values are received in response to a user making a selection via a user interface.

14. The method of claim 2 further comprising validating the query script to minimize security risks.

15. The method of claim 14 wherein validating the query script comprises detecting one or more predefined words in the query script.

16. The method of claim 2 further comprising formatting the query script for readability.

17. The method of claim 2 further comprising executing, at the application server, the query script via a database interface that establishes a connection with the data server.

18. The method of claim 2 further comprising receiving, by the application server, query results from the data server and formatting the query results in a data structure native to the application server.

19. A non-transitory computer-readable medium having stored thereon program code, the program code executable by a computer to:

generate, at an application server, a query script by paraphrasing source code of an application, wherein the query script includes at least one placeholder that represents a dynamic term in the source code;

process, at the application server, the query script by replacing the placeholder with a static term generated based on one or more values received during execution of the application; and

execute the query script to manage data at a data server.

20. A system comprising:

a non-transitory memory device for storing computer readable program code; and

a processor in communication with the memory device, the processor being operative with the computer readable program code to:

generate, at an application server, a query script by paraphrasing source code of an application, wherein the query script includes at least one placeholder that represents a dynamic term in the source code;

process, at the application server, the query script by replacing the placeholder with a static term generated based on one or more values received during execution of the application; and

execute the query script to manage data at a data server.

Assignments (2)
CHANGE OF NAME Recorded Aug 26, 2014
From: SAP AG
To: SAP SE
Reel/Frame 033625/0223 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Mar 13, 2013
From: LIU, XIAOWEI; CHEN, YINGYU
To: SAP AG
Reel/Frame 029980/0333 →