Opaque types

• US 7,007,037 B2
• Filed: 07/09/2002
• Issued: 02/28/2006
• Est. Priority Date: 07/31/2000
• Status: Expired due to Term

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Krishnamurthy, Viswanathan, Govindarajan, Rajagopalan, Nori, Anil
• Primary Examiner(s): Kindred, Alford
• Assistant Examiner(s): AL HASHEMI, SANA A
• Application Number:
  US10/192,411
• Publication Number:
  US 20020174128A1
• Time in Patent Office: 1,330 Days
• Field of Search: 707/104.1, 707100-102, 707/10, 707/3, 707/103.Y
• US Class Current: 1/1
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

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.

Claims

1. 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;

prior to storing said data item to non-volatile memory, said database system invoking said pickling mechanism to transform said data item from said native structure to a storable format;

upon reading said data item from non-volatile memory, said database system invoking said unpickling mechanism to transform said data item from said storable format to said native structure; 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.

2. The computer-readable medium of claim 1 wherein:

the step of invoking an unpickling mechanism is performed by invoking a runtime subsystem for a programming environment associated with the data type; and

the step of invoking a pickling mechanism is performed by invoking said runtime subsystem for the programming environment associated with the data type.

3. The computer-readable medium of claim 1 wherein:

the computer-readable medium includes the sequences of instructions for performing the steps of

the database system registering a first user-implemented routine for pickling data items that belong to said data type;

the database system registering a second user-implemented routine for unpickling data items that belong to said data type;

the step of invoking a pickling mechanism is performed by invoking said first user-implemented routine; and

the step of invoking an unpickling mechanism is performed by invoking said second user-implemented routine.

4. The computer-readable medium of claim 1 further comprising instructions for performing the step of said database system receiving a type declaration associated with said data type, wherein said type declaration specifies one or more attributes that are of data types that are supported by said database system.

5. The computer-readable medium of claim 4 further comprising sequences of instructions for performing the steps of:

said database system registering a user-specified routine associated with a first attribute of said one or more attributes; and

said database system invoking said user-specified routine to access said first attribute.

6. The computer-readable medium of claim 5 further comprising instructions for performing the steps of:

said database system registering a second user-specified routine associated with a second attribute of said one or more attributes; and

said database system invoking said second user-specified routine to access said second attribute.

7. The computer-readable medium of claim 4 wherein:

said native structure has a plurality of attributes; and

said plurality of attributes do not have a one-to-one correspondence with said one or more attributes specified by said type declaration.

8. The computer-readable medium of claim 7 wherein said native structure has an attribute that does not correspond to any of said one or more attributes specified by said type declaration.

9. The computer-readable medium of claim 7 wherein said native structure does not have any attribute that corresponds to one of said one or more attributes specified by said type declaration.

10. 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, comprising the steps of:

said database system receiving user input that specifies a pickling mechanism and an unpickling mechanism for said data type;

prior to storing said data item to non-volatile memory, said database system invoking said pickling mechanism to transform said data item from said native structure to a storable format;

upon reading said data item from non-volatile memory, said database system invoking said unpickling mechanism to transform said data item from said storable format to said native structure; 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.

11. The method of claim 10 wherein:

the step of invoking an unpickling mechanism is performed by invoking a runtime subsystem for a programming environment associated with the data type; and

the step of invoking a pickling mechanism is performed by invoking said runtime subsystem for the programming environment associated with the data type.

12. The method of claim 10 further including:

the database system registering a first user-implemented routine for pickling data items that belong to said data type;

the database system registering a second user-implemented routine for unpickling data items that belong to said data type;

the step of invoking a pickling mechanism is performed by invoking said first user-implemented routine; and

the step of invoking an unpickling mechanism is performed by invoking said second user-implemented routine.

13. The method of claim 10 further including said database system receiving a type declaration associated with said data type, wherein said type declaration specifies one or more attributes that are of data types that are supported by said database system.

14. The method of claim 13 further comprising:

said database system registering a user-specified routine associated with a first attribute of said one or more attributes; and

said database system invoking said user-specified routine to access said first attribute.

15. The method of claim 14 further comprising:

said database system registering a second user-specified routine associated with a second attribute of said one or more attributes; and

said database system invoking said second user-specified routine to access said second attribute.

16. The method of claim 13 wherein:

said native structure has a plurality of attributes; and

said plurality of attributes do not have a one-to-one correspondence with said one or more attributes specified by said type declaration.

17. The method of claim 16 wherein said native structure has an attribute that does not correspond to any of said one or more attributes specified by said type declaration.

18. The method of claim 16 wherein said native structure does not have any attribute that corresponds to one of said one or more attributes specified by said type declaration.

19. 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:

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; and

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.

20. The computer-readable medium of claim 19, the steps further comprising 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.

21. The computer-readable medium of claim 19 wherein said native structure has a plurality of attributes, and said plurality of attributes do not have a one-to-one correspondence with said set of attributes.

22. The computer-readable medium of claim 21 wherein the at least one attribute does not correspond to any of said plurality of attributes.