US 6,286,015 B1 · Opaque types

Abstract

A method and apparatus are provided for handling within a database system data items that are associated with data types whose native structure is not known to the database system. The data items are stored within the database system in their native structure, even though it is not understood by the database system. To store the data items, the database system calls a pickling routine that is provided by the user, or by the runtime subsystem of the programming environment that is native to the data item. To retrieve the routine from storage, the database system calls an unpickling routine, also provided by the user or the appropriate runtime subsystem. Because the database maintains the data items in their native format, no conversions are required as the data items are passed between the database system and external routines that manipulate the data items. Techniques are also provided for declaring attributes of the data item that can be accessed within the database system. The user provides routines for the database system to call in order to access the declared attributes, which may be different than the actual attributes that the data item has in its native environment.

Claims22

Dependent claims

A method of handling within a database system a data item that is associated with a data type whose native structure is not known to said database system, the method comprising the steps of:

said database system receiving user input that specifies a pickling mechanism and an unpickling mechanism for said data type;
the database system registering a first user-specified routine for pickling data items that belong to said data type;
the database system registering a second user-specified routine for unpickling data items that belong to said data type;
prior to storing said data item to non-volatile memory, said database system invoking the pickling mechanism that has been specified by user input, said pickling mechanism transforming said data item from said native structure to a storable format, wherein the step of invoking the pickling mechanism is performed by invoking the first user-specified routine for pickling data items that belong to said data type;
upon reading said data item from non-volatile memory, said database system invoking the unpickling mechanism that has been specified by user input, said unpickling mechanism transforming said data item from said storable format to said native structure, wherein the step of invoking the unpickling mechanism is performed by invoking the second user-specified routine for unpickling data items that belong to said data type;
and
maintaining said data item in said native structure as the data item is passed between said database system and routines that expect said data item to be in said native structure.

4 more elements

A method for handling within a database system a data item that is associated with a data type whose native structure is not known to said database system, the method comprising the steps of:

the database system registering a first user-specified routine for pickling data items that belong to said data type;
the database system registering a second user-specified routine for unpickling data items that belong to said data type;
to store data items that belong to said data type on non-volatile memory, invoking said first user-specified routine for pickling data items that belong to said data type;
and to load data items that belong to said data type from non-volatile memory, invoking said second user-specified routine for unpickling data items that belong to said data type;
said database system receiving user input that specifies the set of attributes;
said database system receiving user input that specifies a data type that is supported by said database system for each attribute in said set of attributes;
said database system receiving user input that specifies an external routine for accessing a first attribute of said set of attributes, wherein said external routine expects said data item to have said native structure;
said database system invoking said external routine to access said at least one attribute;
in response to invoking said external routine, said database system receiving from said external routine a value that is structured according to the data type associated with said first attribute.

6 more elements

A computer-readable medium carrying one or more sequences of instructions for handling within a database system a data item that is associated with a data type whose native structure is not known to said database system, wherein execution of the one or more sequences of instructions by one or more processors causes the one or more processors to perform the steps of:

said database system receiving user input that specifies a pickling mechanism and an unpickling mechanism for said data type;
the database system registering a first user-specified routine for pickling data items that belong to said data type;
the database system registering a second user-specified routine for unpickling data items that belong to said data type;
prior to storing said data item to non-volatile memory, said database system invoking the pickling mechanism that has been specified by user input, said pickling mechanism transforming said data item from said native structure to a storable format, wherein the step of invoking the pickling mechanism is performed by invoking the first user-specified routine for pickling data items that belong to said data type;
upon reading said data item from non-volatile memory, said database system invoking the unpickling mechanism that has been specified by user input, said unpickling mechanism transforming said data item from said storable format to said native structure, wherein the step of invoking the unpickling mechanism is performed by invoking the second user-specified routine for unpickling data items that belong to said data type;
and
maintaining said data item in said native structure as the data item is passed between said database system and routines that expect said data item to be in said native structure.

4 more elements

Dependencies are inferred from the claim text.

Opaque types

Life of this patent

Opaque types

Life of this patent

Abstract

Claims22