← Back to Patent Explorer
US5960438A Expired / Lapsed US ⏱️ 0.0 years remaining

Class hierarchy for object aggregation representation of relational database rows with cells having nontraditional datatypes

Assignee: International Business Machines Corp
•
Filing: 1997-05-06
•
Granted: 1999-09-28
•
Expires: 2017-05-06
📄 Original PDF 🌐 Google Patents 🔄 Sync Now

Abstract

Abstract A program product is described in which a particularly advantageous hierarchical class library is provided to permit object oriented applications to instantiate objects to access and to manipulate, in accordance with the object model, nontraditional data values of a relational table. Nontraditional datatypes of a relational table include multimedia and large object datatypes. 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. The class library is advantageously structured into a hierarchy that ensures the availability of certain member functions for extended data objects.

Inventors

  • 👤 Daniel T. Chang
  • 👤 Douglas M. Hembry
  • 👤 Basuki N. Soetarman
  • 👤 Robert N. Summers

Bibliographic Details

Application Number —
Jurisdiction US
Data Source google_patents
Last Synchronized 2026-10-30 09:45
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/289; G06F16/284; Y; Y10; Y10S; Y10S707/00; Y10S707/912; Y10S707/913; Y10S707/914; Y10S707/915; Y10S707/916; Y10S707/953; Y10S707/954; Y10S707/955; Y10S707/956; Y10S707/99941; Y10S707/99944; Y10S707/99945

Claims Analysis

Total Claims: 36
Claim 1
Independent Claim 52 words
A program product, comprising: a class library, and a computer-readable medium bearing said class library; said class library expressing an inheritance hierarchy and including an EXOB base class for constructing extended data objects that each represent only one cell of a row of a relational table, said cell having a nontraditional datatype.
Claim 2
Dependent Claim 52 words
A program product, comprising: a class library, and a computer-readable medium bearing said class library; said class library expressing an inheritance hierarchy and including an EXOB base class for constructing extended data objects that each represent only one cell of a row of a relational table, said cell having a nontraditional datatype.
Claim 3
Dependent Claim 51 words
The program product according to claim 1, wherein said EXOB base class includes, as a respective subclass thereof, an autonomous EXOB class defining core member functions for interacting with said only one cell, said core member functions including an add function, a retrieve function, an update function, and a delete function.
Claim 4
Dependent Claim 25 words
The program product according to claim 2, wherein said autonomous EXOB class includes, as respective subclasses thereof, a multimedia class and a large object class.
Claim 5
Dependent Claim 26 words
The program product according to claim 3, wherein said multimedia class includes, as respective subclasses thereof, an image class, a video class, and an audio class.
Claim 6
Dependent Claim 28 words
The program product according to claim 3, wherein said large object class includes, as respective subclasses thereof, a binary large object class and a character large object class.
Claim 7
Dependent Claim 24 words
The program product according to claim 5, wherein said large object class pertains to data values having a length of at least 32 kbytes.
Claim 8
Dependent Claim 24 words
The program product according to claim 6, wherein said large object class pertains to data values having a length of at least 64 kbytes.
Claim 9
Dependent Claim 48 words
The program product according to claim 2, wherein said EXOB base class further includes, as another said respective subclass thereof, a non-autonomous EXOB class for constructing said extended data objects representing said only one cell of a row of a relational table, said cell having a user-defined datatype.
Claim 10
Dependent Claim 144 words
A program product for use with a computer system in which relational tables of a relational database management system are accessed by an applications program, said program product comprising: a computer usable medium bearing computer programming statements for causing said computer system to respond to an access request of said applications program for access to data cells of a row of one of said relational tables by providing (A) an entity object representing said row and having traditional type data values for each of said cells of a traditional datatype, and (B) for each of said data cells that has a nontraditional datatype, an extended data object representing said cell and having a respective nontraditional type data value; said computer programming statements including a class library expressing an inheritance hierarchy and including an EXOB base class for constructing instances of said extended data object.
Claim 11
Dependent Claim 144 words
A program product for use with a computer system in which relational tables of a relational database management system are accessed by an applications program, said program product comprising: a computer usable medium bearing computer programming statements for causing said computer system to respond to an access request of said applications program for access to data cells of a row of one of said relational tables by providing (A) an entity object representing said row and having traditional type data values for each of said cells of a traditional datatype, and (B) for each of said data cells that has a nontraditional datatype, an extended data object representing said cell and having a respective nontraditional type data value; said computer programming statements including a class library expressing an inheritance hierarchy and including an EXOB base class for constructing instances of said extended data object.
Claim 12
Dependent Claim 51 words
The program product according to claim 9, wherein said EXOB base class includes, as a respective subclass thereof, an autonomous EXOB class defining core member functions for interacting with said only one cell, said core member functions including an add function, a retrieve function, an update function, and a delete function.
Claim 13
Dependent Claim 25 words
The program product according to claim 10, wherein said autonomous EXOB class includes, as respective subclasses thereof, a multimedia class and a large object class.
Claim 14
Dependent Claim 26 words
The program product according to claim 11, wherein said multimedia class includes, as respective subclasses thereof, an image class, a video class, and an audio class.
Claim 15
Dependent Claim 28 words
The program product according to claim 11, wherein said large object class includes, as respective subclasses thereof, a binary large object class and a character large object class.
Claim 16
Dependent Claim 24 words
The program product according to claim 13, wherein said large object class pertains to data values having a length of at least 32 kbytes.
Claim 17
Dependent Claim 24 words
The program product according to claim 14, wherein said large object class pertains to data values having a length of at least 64 kbytes.
Claim 18
Dependent Claim 48 words
The program product according to claim 10, wherein said EXOB base class further includes, as another said respective subclass thereof, a non-autonomous EXOB class for constructing said extended data objects representing said only one cell of a row of a relational table, said cell having a user-defined datatype.
Claim 19
Dependent Claim 190 words
A computer system, comprising: a relational database management system with relational tables having rows of respective data cells, each of said data cells having a respective datatype and a respective stored value, a data access facility for interfacing with said relational database management system to provide access to said relational tables, an applications program for accessing a selected row of said data cells using said data access facility, and a class library; said data access facility responding to an access request of said applications program for access to said selected row by providing: an entity object representing said selected row, said entity object holding values corresponding to said respective stored value of all of said respective data cells in which said respective datatype is traditional, and a respective extended data object for each cell of said respective data cells in which said respective datatype is nontraditional, said respective extended data object holding a respective nontraditional data value corresponding to said respective stored value of said each cell; and wherein said library expresses an inheritance hierarchy including an extended data object base class for constructing instances of said extended data object.
Claim 20
Dependent Claim 190 words
A computer system, comprising: a relational database management system with relational tables having rows of respective data cells, each of said data cells having a respective datatype and a respective stored value, a data access facility for interfacing with said relational database management system to provide access to said relational tables, an applications program for accessing a selected row of said data cells using said data access facility, and a class library; said data access facility responding to an access request of said applications program for access to said selected row by providing: an entity object representing said selected row, said entity object holding values corresponding to said respective stored value of all of said respective data cells in which said respective datatype is traditional, and a respective extended data object for each cell of said respective data cells in which said respective datatype is nontraditional, said respective extended data object holding a respective nontraditional data value corresponding to said respective stored value of said each cell; and wherein said library expresses an inheritance hierarchy including an extended data object base class for constructing instances of said extended data object.
Claim 21
Dependent Claim 61 words
The computer system according to claim 17, wherein said extended data object base class includes, as a respective subclass thereof, an autonomous extended data object class defining core member functions for interacting with said each cell in which said respective datatype is nontraditional, said core member functions including an add function, a retrieve function, an update function, and a delete function.
Claim 22
Dependent Claim 27 words
The computer system according to claim 18, wherein said autonomous extended data object class includes, as respective subclasses thereof, a multimedia class and a large object class.
Claim 23
Dependent Claim 26 words
The computer system according to claim 19, wherein said multimedia class includes, as respective subclasses thereof, an image class, a video class, and an audio class.
Claim 24
Dependent Claim 28 words
The computer system according to claim 19, wherein said large object class includes, as respective subclasses thereof, a binary large object class and a character large object class.
Claim 25
Dependent Claim 24 words
The computer system according to claim 21, wherein said large object class pertains to data values having a length of at least 32 kbytes.
Claim 26
Dependent Claim 24 words
The computer system according to claim 22, wherein said large object class pertains to data values having a length of at least 64 kbytes.
Claim 27
Dependent Claim 54 words
The computer system according to claim 18, wherein said extended data object base class further includes, as another said respective subclass thereof, a non-autonomous extended data object class for constructing said extended data object to represent said each cell in which said respective datatype is nontraditional when said respective datatype is a user-defined datatype.
Claim 28
Dependent Claim 273 words
A data access method in a computer system having a relational database management system with relational tables, a data access facility for interfacing with said relational database management system to provide access to said relational tables, an applications program for accessing one of said relational tables using said data access facility, and a class library, said relational database management system supporting traditional and nontraditional datatype cells, the method comprising: sending, from said applications program to said data access facility, a request for access to respective data cells of a selected row of one of said relational tables, said data cells each having a respective datatype; creating, in response to said request, an entity object representing said row and having respective traditional data values for each of said respective cells that is one of said traditional datatype cells; providing said entity object to said applications program; creating, in response to said request, a respective extended object for each of said respective cells that is one of said nontraditional datatype cells, said extended data object having a respective nontraditional data value for said one of said nontraditional datatype cells, said respective extended data object being created based on an extended data object base class of said class library, said class library expressing an inheritance hierarchy for constructing instances of said extended data object; providing each said respective extended data object to said applications program; and accessing said one of said nontraditional datatype cells of said selected row by invoking member functions of said respective extended data object, and accessing said traditional datatype cells of said selected row by invoking member functions of said entity object.
Claim 29
Dependent Claim 273 words
A data access method in a computer system having a relational database management system with relational tables, a data access facility for interfacing with said relational database management system to provide access to said relational tables, an applications program for accessing one of said relational tables using said data access facility, and a class library, said relational database management system supporting traditional and nontraditional datatype cells, the method comprising: sending, from said applications program to said data access facility, a request for access to respective data cells of a selected row of one of said relational tables, said data cells each having a respective datatype; creating, in response to said request, an entity object representing said row and having respective traditional data values for each of said respective cells that is one of said traditional datatype cells; providing said entity object to said applications program; creating, in response to said request, a respective extended object for each of said respective cells that is one of said nontraditional datatype cells, said extended data object having a respective nontraditional data value for said one of said nontraditional datatype cells, said respective extended data object being created based on an extended data object base class of said class library, said class library expressing an inheritance hierarchy for constructing instances of said extended data object; providing each said respective extended data object to said applications program; and accessing said one of said nontraditional datatype cells of said selected row by invoking member functions of said respective extended data object, and accessing said traditional datatype cells of said selected row by invoking member functions of said entity object.
Claim 30
Dependent Claim 56 words
The data access method according to claim 25, wherein said extended data object base class includes, as a respective subclass thereof, an autonomous extended data object class defining core member functions for interacting with said only one cell, said core member functions including an add function, a retrieve function, an update function, and a delete function.
Claim 31
Dependent Claim 28 words
The data access method according to claim 26, wherein said autonomous extended data object class includes, as respective subclasses thereof, a multimedia class and a large object class.
Claim 32
Dependent Claim 27 words
The data access method according to claim 27, wherein said multimedia class includes, as respective subclasses thereof, an image class, a video class, and an audio class.
Claim 33
Dependent Claim 29 words
The data access method according to claim 27, wherein said large object class includes, as respective subclasses thereof, a binary large object class and a character large object class.
Claim 34
Dependent Claim 25 words
The data access method according to claim 29, wherein said large object class pertains to data values having a length of at least 32 kbytes.
Claim 35
Dependent Claim 25 words
The data access method according to claim 30, wherein said large object class pertains to data values having a length of at least 64 kbytes.
Claim 36
Dependent Claim 53 words
The data access method according to claim 26, wherein said extended data object base class further includes, as another said respective subclass thereof, a non-autonomous extended data object class for constructing said extended data objects representing said only one cell of a row of a relational table, said cell having a user-defined datatype.

References Cited (Backward Citations)

US5680619A Cited
US5649195A Cited
US5689698A Cited
US5778378A Cited

USPTO Annuity & Maintenance Windows

Annuity Stage Window Opens Payment Deadline Surcharge Period Until Estimated Fee Status
3.5 Years (Year 4) 2002-09-27 2003-03-29 2003-09-28 $2000.00 Window Closed / Lapsed
7.5 Years (Year 8) 2006-09-27 2007-03-29 2007-09-28 $3760.00 Window Closed / Lapsed
11.5 Years (Year 12) 2010-09-27 2011-03-29 2011-09-28 $7700.00 Window Closed / Lapsed

Assigned Categories & Tags

No categories assigned to this patent yet.

Assign Category Tag