Database access acceleration

• US 8,775,397 B2
• Filed: 10/04/2012
• Issued: 07/08/2014
• Est. Priority Date: 06/26/2012
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Dong, Bin, Li, Wen-Syan, Wei, Zheng Long, Shen, Yongyuan, Sun, Qi
• Primary Examiner(s): MORRISON, JAY A
• Application Number:
  US13/644,974
• Publication Number:
  US 20130346380A1
• Time in Patent Office: 642 Days
• Field of Search: None
• US Class Current: 707/705
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor
• CPC Class Codes: G06F 16/23 Updating
• CPC Class Codes: G06F 16/2471 Distributed queries

Abstract

A system includes a request analyzer configured to receive a plurality of database requests and classify the plurality of database requests as transaction requester or non-transaction requests, and further configured to route the transaction requests to a transaction server for application against a transaction database, including write access to an identified portion thereof, and to route the non-transaction requests to a non-transaction server to thereby read data obtained from a non-transaction database. The system also includes an update manager configured to update the non-transaction database, based on the application of the transaction requests against the transaction database.

Claims

1. A system including instructions recorded on a non-transitory computer-readable medium, and executable by at least one semiconductor processor, the system comprising:

an acceleration manager configured to cause the at least one semiconductor processor to manage access to a database of data records corresponding to items for sale, including separating each data record into a transaction portion requiring relatively frequent updates and a non-transaction portion requiring relatively infrequent updates, wherein the transaction portions are stored in a transaction database and the non-transaction portions are stored in main memory in a non-transaction database, the acceleration manager including

a request analyzer configured to cause the at least one semiconductor processor to receive a plurality of database requests and classify the plurality of database requests as transaction requests or non-transaction requests, and further configured to cause the at least one processor to route the transaction requests to a transaction server for application against the transaction database, including write access to identified portions thereof, and to route the non-transaction requests to a non-transaction server to thereby read data obtained from the non-transaction database; and

an update manager configured to cause the at least one semiconductor processor to update the non-transaction database, based on the application of the transaction requests against the transaction database.

2. The system of claim 1, wherein the requests are received by way of a website associated with the transaction server and the non-transaction server.

3. The system of claim 2, wherein the request analyzer is configured to cause the at least one processor to route the requests based on Uniform Resource Locators (URLs) associated with the requests.

4. The system of claim 1, wherein the non-transaction portions of the data records included in the non-transaction database are copied from corresponding portions of the data records of the transaction database.

5. The system of claim 1, comprising a cached content generator configured to cause the at least one processor to generate cached content including processing the transaction portions and/or the non-transaction portions, wherein the cached content is stored in the non-transaction database in the main memory and at least some of the non-transaction requests are satisfied using the cached content.

6. The system of claim 5, wherein the non-transaction server includes at least two non-transaction servers, and wherein the cached content generator is further configured to cause the at least one processor to partition the cached content and distribute the partitioned cached content among the at least two non-transaction servers.

7. The system of claim 5, wherein the cached content generator is further configured to update the cached content, based on the update of the non-transaction database.

8. The system of claim 7, wherein the cached content generator is further configured to update the cached content, based on a delta between the cached content and the updated cached content.

9. The system of claim 1, comprising an update monitor configured to cause the at least one processor to detect the applications of the transaction requests against the transaction database, and further configured to provide a notification to the update manager regarding a result thereof.

10. The system of claim 9, wherein the notification includes a delta characterizing a difference between the non-transaction database and the transaction database, following the applications.

11. The system of claim 9, wherein the update manager is further configured to cause the at least one processor to maintain the delta in a temporary table over a plurality of the notifications, and to merge the temporary table with the non-transaction database.

12. A computer-implemented method for executing instructions stored on a computer readable storage medium, the method comprising:

managing access to a database of data records corresponding to items for sale, including separating each data record into a transaction portion requiring relatively frequent updates and a non-transaction portion requiring relatively infrequent updates, wherein the transaction portions are stored in a transaction database and the non-transaction portions are stored in main memory in a non-transaction database;

receiving a plurality of database requests;

classifying the plurality of database requests as transaction requests or non-transaction requests;

routing the transaction requests to a transaction server for application against the transaction database, including write access to identified portions thereof;

routing the non-transaction requests to a non-transaction server to thereby read data obtained from the non-transaction database; and

updating the non-transaction database, based on the application of the transaction requests against the transaction database.

13. The method of claim 12, further comprising generating cached content including processing the transaction portions and/or the non-transaction portions, wherein the cached content is stored in the non-transaction database in the main memory and at least some of the non-transaction requests are satisfied using the cached content.

14. The method of claim 13, wherein the non-transaction server includes at least two non-transaction servers, and wherein the cached content is partitioned and distributed among the at least two non-transaction servers.

15. The method of claim 12, wherein the updating the non-transaction database comprises:

detecting the applications of the transaction requests against the transaction database; and

providing a notification to the update manager regarding a result thereof.

16. A computer program product, the computer program product being tangibly embodied on a non-transitory computer-readable storage medium and comprising instructions that, when executed, are configured to:

manage access to a database of data records corresponding to items for sale, including separating each data record into a transaction portion requiring relatively frequent updates and a non-transaction portion requiring relatively infrequent updates, wherein the transaction portions are stored in a transaction database and the non-transaction portions are stored in main memory in a non-transaction database;

receive a plurality of database requests;

classify the plurality of database requests as transaction requests or non-transaction requests;

route the transaction requests to a transaction server for application against the transaction database, including write access to identified portions thereof;

route the non-transaction requests to a non-transaction server to thereby read data obtained from the non-transaction database; and

update the non-transaction database, based on the application of the transaction requests against the transaction database.

17. The computer program product of claim 16, wherein the requests are received by way of a website associated with the transaction server and the non-transaction server.

18. The computer program product of claim 16, wherein the instructions, when executed, are further configured to generate cached content including processing the transaction portions and/or the non-transaction portions, wherein the cached content is stored in the non-transaction database in the main memory and at least some of the non-transaction requests are satisfied using the cached content.

19. The computer program product of claim 17, wherein the non-transaction server includes at least two non-transaction servers, and wherein the cached content is partitioned and distributed among the at least two non-transaction servers.

20. The computer program product of claim 16, wherein, in the updating the non-transaction database, the instructions are further configured to:

detect the applications of the transaction requests against the transaction database; and

provide a notification to the update manager regarding a result thereof.