Tool for optimizing system performance and methods relating to same
First Claim
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.
3 Assignments
0 Petitions
Accused Products
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.
25 Citations
14 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. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
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. - View Dependent Claims (9, 10, 11, 12, 13, 14)
Specification