Dynamically Sizing Buffers to Optimal Size in Network Layers When Supporting Data Transfers Related to Database Applications

• US 20060206453A1
• Filed: 04/27/2005
• Published: 09/14/2006
• Est. Priority Date: 03/10/2005
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Itikarlapalli, Krishna Mohan, Bande, Amit, Chatterjee, Debashish
• Granted Patent: US 7,827,141 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/24552 Database cache management
• CPC Class Codes: H04L 49/90 Buffering arrangements

Abstract

In transferring data from/to a database server, the size of a network buffer used by a network layer is dynamically adjusted according to the call type and expected size of data to be transferred for the call. Due to such use of appropriate buffer size, throughput performance of the transfer may be enhanced.

Claims

1. A method of supporting data transfers from a first database system to a second database system, said method being performed in said first database system, said method comprising:

receiving data related to a first call and then related to a second call from a database application implemented in said first database system, said first call and said second call respectively being related to corresponding operations with said second database system; and

using a network buffer of a first size to transfer data related to said first call, and of a second size to transfer data related to said second call, wherein said network buffer is used by a network layer to transfer data from said first database system, and wherein said first size is not equal to said second size.

2. The method of claim 1, wherein said first and second call are generated on the same connection setup between said first database system and said second database system.

3. The method of claim 2, further comprising determining the size of said buffer according to a type of said first call and said second call.

4. The method of claim 3, wherein said size of said buffer is larger if said type of first call is for large objects or for graphics data compared to a select statement which fetches only a small amount of data.

5. The method of claim 3, further comprising determining the size of said buffer according to an expected size of data to be transferred on said first call and said second call.

6. The method of claim 3, wherein said first call is related to a write operation to said second database system, a presentation layer receiving said data and converting said data into a converted data consistent with a format suitable for said second database system, said converted data being stored in said buffer before said network layer transmits said data to said second database system on a network.

7. The method of claim 6, wherein said network layer uses system calls in receiving from and storing data to said buffer, wherein a number of said system calls are reduced due to said determining.

8. A computer readable medium carrying one or more sequences of instructions causing a first database system to support data transfers to a second database system, wherein execution of said one or more sequences of instructions by one or more processors contained in said first database system causes said one or more processors to perform the actions of:

receiving data related to a first call and then related to a second call from a database application implemented in said first database system, said first call and said second call respectively being related to corresponding operations with said second database system; and

using a network buffer of a first size to transfer data related to said first call, and of a second size to transfer data related to said second call, wherein said network buffer is used by a network layer to transfer data from said first database system, and wherein said first size is not equal to said second size.

9. The computer readable medium of claim 8, wherein said first and second call are generated on the same connection setup between said first database system and said second database system.

10. The computer readable medium of claim 9, further comprising determining the size of said buffer according to a type of said first call and said second call.

11. The computer readable medium of claim 10, wherein said size of said buffer is larger if said type of first call is for large objects or for graphics data compared to a select statement which fetches only a small amount of data.

12. The computer readable medium of claim 10, further comprising determining the size of said buffer according to an expected size of data to be transferred on said first call and said second call.

13. The computer readable medium of claim 10, wherein said first call is related to a write operation to said second database system, a presentation layer receiving said data and converting said data into a converted data consistent with a format suitable for said second database system, said converted data being stored in said buffer before said network layer transmits said data to said second database system on a network.

14. The computer readable medium of claim 13, wherein said network layer uses system calls in receiving from and storing data to said buffer, wherein a number of said system calls are reduced due to said determining.

15. A first database system supporting data transfers to a second database system, said method comprising:

means for receiving data related to a first call and then related to a second call from a database application implemented in said first database system, said first call and said second call respectively being related to corresponding operations with said second database system; and

means for using a network buffer of a first size to transfer data related to said first call, and of a second size to transfer data related to said second call, wherein said network buffer is used by a network layer to transfer data from said first database system, and wherein said first size is not equal to said second size.

16. The first database system of claim 15, wherein said first and second call are generated on the same connection setup between said first database system and said second database system.

17. The first database system of claim 16, further comprising determining the size of said buffer according to a type of said first call and said second call.

18. The first database system of claim 17, wherein said size of said buffer is larger if said type of first call is for large objects or for graphics data compared to a select statement which fetches only a small amount of data.

19. The first database system of claim 17, further comprising determining the size of said buffer according to an expected size of data to be transferred on said first call and said second call.

20. The first database system of claim 17, wherein said first call is related to a write operation to said second database system, a presentation layer receiving said data and converting said data into a converted data consistent with a format suitable for said second database system, said converted data being stored in said buffer before said network layer transmits said data to said second database system on a network.