Paul Gorman Reilly

US Patent:

7747580, Jun 29, 2010

Filed:

Aug 25, 2003

Appl. No.:

10/648577

Inventors:

Namit Jain - Emeryville CA, US
Ellen Batbouta - Hollis NH, US
Nipun Agarwal - Santa Clara CA, US
Ravi Murthy - Fremont CA, US
Paul Reilly - Nashua NH, US
James Stenoish - San Francisco CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 17/30

US Classification:

707679

Abstract:

Techniques and systems are disclosed for storing instances of an opaque type in a database according to a direct path loading approach. According to one aspect, an opaque type implementor registers, with a loader application, routines that the opaque type implementor implements. In response, the loader application associates the opaque type with the routines. The loader application reads data that comprises instances of the opaque type. The loader application determines which routines are associated with the opaque type. The loader application invokes the routines, which create an array for storing instances of the opaque type and populate the array with values specified in the data. The loader application converts the array into a data stream that conforms to the format of the database's data blocks. The loader application then streams the data to a database server, which writes the data directly into data blocks in the database.