Tool for optimizing system performance and methods relating to same

• US 7,516,239 B2
• Filed: 12/30/2004
• Issued: 04/07/2009
• Est. Priority Date: 12/30/2004
• Status: Active Grant

• Current Assignee: Regional Resources Ltd (Imperial Metals Corp.)
• Original Assignee: SAP AG (SAP SE)
• Inventors: Poyourow, David
• Primary Examiner(s): NEURAUTER, GEORGE C
• Application Number:
  US11/026,523
• Publication Number:
  US 20060149703A1
• Time in Patent Office: 1,559 Days
• Field of Search: 709/217, 709/224, 709/228, 709/233, 707/10
• US Class Current: 709/233
• CPC Class Codes: G06F 16/24553 of query operations
• CPC Class Codes: G06F 16/24568 Data stream processing; Continuous queries

Abstract

Improved communication with a database comprising multiple clients utilizing multiple large data objects concurrently. For example when a client system interacts with a server with respect to a data object that is over a threshold size, the system may utilizing a communication methodology that minimizes system resource usage such as CPU and network utilization. When a client request for an object is within a size threshold, embodiments segment the object into smaller size chunks. Hence the server is not required to assemble all data associated with a request at once, but instead starts transmitting smaller segments. Allowing for transmission of smaller data chunks prevents allocating large blocks of memory to one object and although the server handles more memory allocations, each allocation is smaller and can be processed much faster. Chunk size may depend on environmental factors: time of day, day of week, number of users, number of predicted users.

Claims

1. A method comprising:

obtaining a time window via computer readable program code on a computer system comprising a client and a database server;

obtaining a historic memory utilization of said database server over said time window and said database server'"'"'s current memory utilization;

computing a chunk size threshold for optimal performance in transferring binary large object data from said database server to said client, based on a historic network availability period and a current number of database users;

performing a function to compute a chunk size for optimal performance in transferring binary large object data greater than said chunk size threshold from said database server to said client, said function based on an environmental factor, said current memory utilization, said historic memory utilization, and said current number of database users; and

,

using said chunk size and said chunk size threshold to transfer said binary large object data from said database server to said client.

2. The method of claim 1 further comprising:

waiting for a configurable time period; and

,

repeating said method of claim 1.

3. The method of claim 1 wherein said environmental factor is a time of day.

4. The method of claim 1 wherein said environmental factor is a day of the week.

5. The method of claim 1 wherein said environmental factor is a number of users.

6. The method of claim 1 wherein said environmental factor is a number of predicted users.

7. The method of claim 1 wherein said environmental factor is based on a predicted network utilization.

8. A computer program product comprising:

a computer usable memory medium having computer readable program code embodied therein wherein said computer readable program code comprises a data chunking interface module, said computer readable program code configured to;

obtain a time window via said computer readable program code on a computer system comprising a client and a database server;

obtain a historic memory utilization of said database server over said time window and said database server'"'"'s current memory utilization;

obtain a current number of database users;

perform a function to compute a chunk size for transferring binary large object data from said database server to said client, said function based on an environmental factor, said current memory utilization said historic memory utilization and said current number of database users; and

,

use said chunk size to transfer said binary large object data from said database server to said client.

9. The computer program product of claim 8 wherein said computer readable program code is further configured to:

wait for a configurable time period; and

,

repeat said steps of said data chunking interface module.

10. The computer program product of claim 8 wherein said environmental factor is a time of day.

11. The computer program product of claim 8 wherein said environmental factor is a day of the week.

12. The computer program product of claim 8 wherein said environmental factor is a number of users.

13. The computer program product of claim 8 wherein said environmental factor is a number of predicted users.

14. The computer program product of claim 8 wherein said environmental factor is a predicted network utilization.