Object representation of relational database cells having nontraditional large object datatypes

Claim 2

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.

Claim 3

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.

Claim 4

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.

Claim 5

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.

Claim 6

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.

Claim 7

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.

Claim 8

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.

Claim 9

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.

Claim 10

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.

Claim 11

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.

Claim 12

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.

Claim 13

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.

Claim 14

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.

Claim 15

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.

Claim 16

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.

Claim 17

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.

Claim 18

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.

Claim 19

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.

Claim 20

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.

Claim 21

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.