Object representation of relational database cells having nontraditional large object datatypes

• US 5,890,160 A
• Filed: 05/06/1997
• Issued: 03/30/1999
• Est. Priority Date: 05/06/1997
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Hembry, Douglas M.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): WALLACE, MICHAEL J
• Application Number:
  US08/852,052
• Time in Patent Office: 693 Days
• Field of Search: 707/10, 707/103, 707/104
• US Class Current: 1/1
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

A program product is described in which a class library is provided to permit object oriented applications to access and to manipulate, in accordance with the object model, nontraditional data values of a relational table and, in particular, large objects. The data is manipulable by virtue of extended data objects that each represent a cell of a relational row, and that each inherit type-specific behaviors from the class library. Special handling for large objects is provided so as to avoid undue burdens on performance.

Claims

1. In a computer system having a database under control of a server-based database management system which supports a large object (LOB) datatype, said database including a table with rows and columns, cells being defined by intersections of said rows and said columns, one of said rows having a cell of said LOB datatype, a data access method for a client-based applications program to access and manipulate a LOB value of said cell, said method comprising the steps of:

providing to said applications program an object representing said cell, said object having member functions including functions for;

setting a LOB access mode of said object to a direct method, and

setting said LOB access mode to an indirect method;

wherein;

when said direct method is set, said object responds to a retrieval request of said applications program by causing said database management system to provide to said object said LOB value, said manipulation of said LOB value occurring at said client by said object;

when said indirect method is set, said object responds to said retrieval request by causing said database management system to provide a LOB locator usable by said database management system, said manipulation of said LOB value occurring at said server;

said applications program accesses and manipulates said LOB value by sending a message to said object.

2. The data access method according to claim 1, wherein:

said member functions of said object further include a function for setting said LOB access mode to an automatic method;

when said automatic method is set, and said LOB value has a length that exceeds a predetermined threshold, said object responds to said retrieval request by causing said database management system to provide to said object said LOB value, said manipulation of said LOB value occurring at said client by said object; and

when said automatic method is set, and said length of said LOB value does not exceed said predetermined threshold, said object responds to said retrieval request by causing said database management system to provide a LOB locator usable by said database management system, said manipulation of said LOB value occurring at said server.

3. The data access method according to claim 2, wherein:

said member functions of said object further include a comparing function for comparing said length of said LOB value with a threshold;

said comparing function is invoked in response to said retrieval request; and

said comparing function is invoked in response to a change in said length of said LOB value.

4. The data access method according to claim 3, wherein:

said member functions of said object further include a binary LOB function; and

when said binary LOB function is invoked, said object determines whether both operands of said binary LOB function are co-located.

5. The data access method according to claim 4, wherein when said operands are not co-located, said object causes one of said operands to be located with the other one of said operands prior to execution of said binary LOB function.

6. The data access method according to claim 3, wherein:

setting said LOB access method to said indirect method is accomplished by adjusting said threshold of said comparing function to a value less than a smallest allowable value for said large object datatype;

setting said LOB access method to said direct method is implemented by adjusting said threshold of said comparing function to a value greater than a greatest allowable value for said large object datatype; and

setting said LOB access method to said automatic method is accomplished by adjusting said threshold of said comparing function to said predetermined threshold.

7. A computer system, comprising:

a database, including a table with rows and columns, cells being defined by intersections of said rows and said columns,

a server-based database management system controlling said database and supporting a large object (LOB) datatype, one of said rows having a cell of said LOB datatype,

a data access facility interfacing with said database management system, and

a client-based applications program for accessing and manipulating a LOB value of said cell;

said applications program providing to said data access facility an access request pertaining to said cell;

said data access facility providing to said applications program, in response to said access request, an object representing said cell, said object having member functions including functions for setting a LOB access mode of said object to a direct method, and for setting said LOB access mode to an indirect method;

wherein when said direct method is set, said object responds to a retrieval request of said applications program by causing said database management system to provide to said object said LOB value, said manipulation of said LOB value occurring at said client by said object;

wherein when said indirect method is set, said object responds to said retrieval request by causing said database management system to provide a LOB locator usable by said database management system, said manipulation of said LOB value occurring at said server; and

wherein said applications program accesses and manipulates said LOB value by sending a message to said object.

8. The computer system according to claim 7, wherein:

said member functions of said object further include a function for setting said LOB access mode to an automatic method;

when said automatic method is set, and said LOB value has a length that exceeds a predetermined threshold, said object responds to said retrieval request by causing said database management system to provide to said object said LOB value, said manipulation of said LOB value occurring at said client by said object; and

when said automatic method is set, and said length of said LOB value does not exceed said predetermined threshold, said object responds to said retrieval request by causing said database management system to provide a LOB locator usable by said database management system, said manipulation of said LOB value occurring at said server.

9. The computer system according to claim 8, wherein:

said member functions of said object further include a comparing function for comparing said length of said LOB value with a threshold;

said comparing function is invoked in response to said retrieval request; and

said comparing function is invoked in response to a change in said length of said LOB value.

10. The computer system according to claim 9, wherein:

said member functions of said object further include a binary LOB function; and

when said binary LOB function is invoked, said object determines whether both operands of said binary LOB function are co-located.

11. The computer system according to claim 10, wherein when said operands are not co-located, said object causes one of said operands to be located with the other one of said operands prior to execution of said binary LOB function.

12. The computer system according to claim 9, wherein:

setting said LOB access method to said indirect method is accomplished by adjusting said threshold of said comparing function to a value less than a smallest allowable value for said large object datatype;

setting said LOB access method to said direct method is implemented by adjusting said threshold of said comparing function to a value greater than a greatest allowable value for said large object datatype; and

setting said LOB access method to said automatic method is accomplished by adjusting said threshold of said comparing function to said predetermined threshold.

13. A program product, comprising:

a class library, and

a computer-readable medium bearing said class library;

said class library including a particular class for constructing an object to represent a selected cell in a computer system having a relational database supporting a large object (LOB) datatype, said selected cell having said LOB datatype, said relational database having a server location and said object having a client location;

said particular class defining member functions of said object, including a function for setting a LOB access mode of said object to a direct method, a function for setting said LOB access mode to an indirect method, and a function for performing a retrieval with respect to said selected cell;

said member functions of said object being defined by said particular class so that;

when said direct method is set, said retrieval is performed by causing said database management system to provide to said object said LOB value so that manipulation of said LOB value may be performed at said client location;

when said indirect method is set, said retrieval is performed by causing said database management system to provide to said object a LOB locator, said LOB locator being usable by said relational database so that manipulation of said LOB value may be performed at said server location.

14. The program product according to claim 13, wherein:

said particular class further defines said member functions of said object to include a function for setting said LOB access mode to an automatic method;

said member functions of said object are defined by said particular class so that;

when said automatic method is set, and said LOB value has a length that exceeds a predetermined threshold, said retrieval is performed according to said direct method; and

when said automatic method is set, and said length of said LOB value does not exceed said predetermined threshold, said retrieval is performed according to said indirect method.

15. The program product according to claim 14, wherein:

said particular class further defines said member functions of said object to include a comparing function for comparing said length of said LOB value with a threshold;

said member functions of said object are defined by said particular class so that said comparing function is invoked when said function for performing a retrieval is invoked, and in response to a change in said length of said LOB value.

16. The program product according to claim 15, wherein:

said particular class further defines said member functions of said object to include a binary LOB function having two operands; and

said member functions of said object are defined by said particular class so that, when said binary LOB function is invoked, said object determines whether both operands of said binary LOB function are co-located.

17. The program product according to claim 16, wherein said member functions of said object are defined by said particular class so that, when said operands are not co-located, said object causes one of said operands to be located with the other one of said operands prior to execution of said binary LOB function.

18. The program product according to claim 15, wherein said member functions of said object are defined by said particular class so that,:

setting said LOB access method to said indirect method is accomplished by adjusting said threshold of said comparing function to a value less than a smallest allowable value for said large object datatype;

setting said LOB access method to said direct method is implemented by adjusting said threshold of said comparing function to a value greater than a greatest allowable value for said large object datatype; and

setting said LOB access method to said automatic method is accomplished by adjusting said threshold of said comparing function to said predetermined threshold.