Dynamic data formatting during transmittal of generalized byte strings, such as XML or large objects, across a network

• US 20070198482A1
• Filed: 02/21/2006
• Published: 08/23/2007
• Est. Priority Date: 02/21/2006
• Status: Abandoned Application

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Pickel, James, Allen, Terry, Ho, Kelvin, Sun, Frankie, Weihrauch, Maryela, Haynes, Toby, Springgay, Michael
• Application Number:
  US11/358,467
• Publication Number:
  US 20070198482A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2219 Large Object storage; Management thereof

Abstract

A method, apparatus and program storage device is provided for dynamic data formatting during transmittal of generalized byte string data across a computer network. Remote server dynamically changes format of each column string data value from the result set separately, according to actual size of the string data value, and returns it to a client. Small-size data value is returned in a single network return message as varchar type, in-line with the rest of the query data. Medium-sized data value is retrieved without locators and streamed in multiple return network messages in a separate data object following the query data and in the same response. Large-size data value is retrieved using locators and returned as a progressive reference in pieces of specified size, where each piece of data value is separately transferred under client'"'"'s control when needed, thus eliminating the need to buffer large amount of data.

Claims

1. A method for dynamic data formatting during transmittal of generalized byte string data across a computer network connecting a client and a remote server, comprising:

(a) in the remote server, dynamically changing format of each string data value from a query result set separately, according to actual size of the string data value; and

(b) returning each string data value to the client.

2. The method according to claim 1, wherein the dynamic data formatting is performed by a database server in the remote server, at the time of data retrieval caused by receipt of a single request to the remote server which returns multiple data values in the result set, by controlling a return mode and representation of each data value from the result set.

3. The method according to claim 2, wherein the mode and representation is defined by a Dynamic Data Format mechanism to enforce sequential access for retrieved data.

4. The method according to claim 1, wherein a small-size data value is returned in a single network return message as varchar type, in-line with the rest of the query data.

5. The method according to claim 1, wherein a medium-sized data value is retrieved without locators and streamed in multiple return network messages in a separate data object following the query data and in the same response.

6. The method according to claim 1, wherein a large-size data value is retrieved using locators and returned as a progressive reference in pieces of specified size, where each piece of data value is separately transferred under client'"'"'s control when needed, thus eliminating the need to buffer large amount of data.

7. The method according to claim 1, wherein the generalized byte string data are sequentially retrieved by a progressive reference data request mechanism to return data in pieces, according to a specified piece length, wherein the progressive reference manages the progression of return of each piece of data of the requested length and frees resources associated with the progressive references with the release of the progressive reference.

8. The method according to claim 1, wherein the generalized byte string data are selected from the group consisting of large object (LOB), XML data, small character strings, serialized Java objects, XML documents and all datatypes that have the pattern of definition being much bigger than the actual size, and wherein a threshold, determining whether the actual size of the string data value is deemed small, medium or large, is provided to the remote server by the client for performance tuning.

9. The method according to claim 1, wherein the remote server has access to multiple data sources, physically distributed and disparate DBMSs, residing on different hardware systems and possibly storing data in a different format.

10. The method according to claim 1, wherein the computer network connecting the client and the remote server uses a Distributed Relational Database Architecture (DRDA) protocol.

11. A system for dynamic data formatting during transmittal of generalized byte string data across a computer network connecting a client and a remote server, comprising:

means in the remote server for dynamically changing format of each string data value from a query result set separately, according to actual size of the string data value; and

means for returning each string data value to the client.

12. The system according to claim 11, wherein the dynamic data formatting is performed by a database server in the remote server, at the time of data retrieval caused by receipt of a single request to the remote server which returns multiple data values in the result set, by controlling a return mode and representation of each data value from the result set.

13. The system according to claim 12, wherein the mode and representation is defined by a Dynamic Data Format mechanism to enforce sequential access for retrieved data.

14. The system according to claim 11, wherein a small-size data value is returned in a single network return message as varchar type, in-line with the rest of the query data.

15. The system according to claim 11, wherein a medium-sized data value is retrieved without locators, and streamed in multiple return network messages in a separate data object following the query data and in the same response.

16. The system according to claim 11, wherein a large-size data value is retrieved using locators and returned as a progressive reference in pieces of specified size, where each piece of data value is separately transferred under client'"'"'s control when needed, thus eliminating the need to buffer large amount of data.

17. The system according to claim 11, wherein the generalized byte string data are sequentially retrieved by a progressive reference data request mechanism to return data in pieces, according to a specified piece length, wherein the progressive reference manages the progression of return of each piece of data of the requested length and frees resources associated with the progressive references with the release of the progressive reference.

18. The system according to claim 11, wherein the generalized byte string data are selected from the group consisting of large object (LOB), XML data, small character strings, serialized Java objects, XM:

L documents and all datatypes that have the pattern of definition being much bigger than the actual size, and wherein a threshold, determining whether the actual size of the string data value is deemed small, medium or large, is provided to the remote server by the client for performance tuning.

19. The system according to claim 11, wherein the remote server has access to multiple data sources, physically distributed and disparate DBMSs, residing on different hardware systems and possibly storing data in a different format.

20. The system according to claim 11, wherein the computer network connecting the client and the remote server uses a Distributed Relational Database Architecture (DRDA) protocol.

21. A program storage device readable by a computer tangibly embodying a program of instructions executable by the computer to perform method steps for dynamic data formatting during transmittal of generalized byte string data across a computer network connecting a client and a remote server, comprising:

(c) in the remote server, dynamically changing format of each string data value from a query result set separately, according to actual size of the string data value; and

(d) returning each string data value to the client.

22. The method according to claim 21, wherein the dynamic data formatting is performed by a database server in the remote server, at the time of data retrieval caused by receipt of a single request to the remote server which returns multiple data values in the result set, by controlling a return mode and representation of each data value from the result set.

23. The method according to claim 22, wherein the mode and representation is defined by a Dynamic Data Format mechanism to enforce sequential access for retrieved data.

24. The method according to claim 21, wherein a small-size data value is returned in a single network return message as varchar type, in-line with the rest of the query data.

25. The method according to claim 21, wherein a medium-sized data value is retrieved without locators and streamed in multiple return network messages in a separate data object following the query data and in the same response.

26. The method according to claim 21, wherein a large-size data value is retrieved using locators and returned as a progressive reference in pieces of specified size, where each piece of data value is separately transferred under client'"'"'s control when needed, thus eliminating the need to buffer large amount of data.

27. The method according to claim 21, wherein the generalized byte string data are sequentially retrieved by a progressive reference data request mechanism to return data in pieces, according to a specified piece length, wherein the progressive reference manages the progression of return of each piece of data of the requested length and frees resources associated with the progressive references with the release of the progressive reference.

28. The method according to claim 21, wherein the generalized byte string data are selected from the group consisting of large object (LOB), XML data, small character strings, serialized Java objects, XML documents and all datatypes that have the pattern of definition being much bigger than the actual size, and wherein a threshold, determining whether the actual size of the string data value is deemed small, medium or large, is provided to the remote server by the client for performance tuning.

29. The method according to claim 21, wherein the remote server has access to multiple data sources, physically distributed and disparate DBMSs, residing on different hardware systems and possibly storing data in a different format.

30. The method according to claim 21, wherein the computer network connecting the client and the remote server uses a Distributed Relational Database Architecture (DRDA) protocol.