Direct loading of opaque types

Details Direct loading of opaque types Direct loading of opaque types

2003-08-25

2010-06-29

Jalil, Neveen Abel (Department: 2165)

Data processing: database and file management or data structures

File or database maintenance

Database recovery

Reexamination Certificate

active

07747580

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.

REFERENCES:
patent: 6085198 (2000-07-01), Skinner et al.
patent: 6115705 (2000-09-01), Larson
patent: 6360302 (2002-03-01), Baylor
patent: 6470494 (2002-10-01), Chan et al.
patent: 6542911 (2003-04-01), Chakraborty et al.
patent: 6654761 (2003-11-01), Tenev et al.
patent: 6662342 (2003-12-01), Marcy
patent: 6721723 (2004-04-01), Gibson et al.
patent: 6772180 (2004-08-01), Li et al.
patent: 6915304 (2005-07-01), Krupa
patent: 6915307 (2005-07-01), Mattis et al.
patent: 6941511 (2005-09-01), Hind et al.
patent: 6957237 (2005-10-01), Traversat et al.
patent: 7031956 (2006-04-01), Lee et al.
patent: 7036072 (2006-04-01), Sulisito et al.
patent: 7113942 (2006-09-01), Levanoni et al.
patent: 7134072 (2006-11-01), Lovett et al.
patent: 7406522 (2008-07-01), Riddle
patent: 7457910 (2008-11-01), Chang et al.
patent: 2001/0049818 (2001-12-01), Banerjia et al.
patent: 2002/0056025 (2002-05-01), Qiu et al.
patent: 2002/0087596 (2002-07-01), Lewontin
patent: 2002/0116371 (2002-08-01), Dodds et al.
patent: 2002/0147763 (2002-10-01), Lee et al.
patent: 2002/0184188 (2002-12-01), Mandyam et al.
patent: 2003/0115421 (2003-06-01), McHenry et al.
patent: 2003/0120665 (2003-06-01), Fox et al.
patent: 2003/0140308 (2003-07-01), Murthy et al.
patent: 2004/0015936 (2004-01-01), Susarla et al.
patent: 2004/0066529 (2004-04-01), Wu et al.
patent: 2004/0088415 (2004-05-01), Chandrasekar et al.
patent: 2004/0117359 (2004-06-01), Snodgrass et al.
patent: 2005/0050092 (2005-03-01), Jain et al.
patent: 2005/0050105 (2005-03-01), Idicula et al.
patent: 2006/0036935 (2006-02-01), Warner et al.
patent: 2006/0047717 (2006-03-01), Pereira
patent: 2006/0200439 (2006-09-01), Bhatia et al.
patent: 2007/0005624 (2007-01-01), Wu et al.
patent: 1 241 589 (2002-09-01), None
patent: 60-218142 (1985-10-01), None
patent: 2-165353 (1990-06-01), None
patent: 8-249159 (1996-09-01), None
patent: WO 01/42881 (2001-06-01), None
“SerialJavaObject (Java 2 Platform SE 5.0)”. Available online at http://java.sun.com/j2se/1.5.0/docs/api/javax/sql/rowset/serial/SerialJavaObject.html, accessed Apr. 8, 2006. Copyright Sun Microsystems.
“10.1. What is the Direct Path?” from Oracle SQL Loader: The Definitive Guide. Published by O'Reilly & Associates, 2001.
“Java programming dynamics, Part 2: Introducing reflection” by Dennis Sosnoski. Published Jun. 3, 2003. Available online at http://www-128.ibm.com/developerworks/library/j-dyn0603/.
“Using Java Relection” by Glen McCluskey. Published Jan. 1998. Available online at http://java.sun.com/developer/technicalArticles/ALT/Reflection/.
“Objects, Collections, and Opaque Types” from Oracle9i SQLJ Developer's Guide and Reference Release 2 (9.2).Copyright 1999, 2002. Available online at http://www.lc.leidenuniv.nl/awcourse/oracle/java.920/a96655/objcoll.htm.
Shelley Higgins, Oracle Corporation, “Oracle9i, XML Database Developer's Guide—Oracle XML DB,” Release 2 (9.2), Oct. 2002, Part No. A96620-02, pp. 1-1,044 (text provided on CD-ROM).
Ipedo, Inc., “Ipedo XML Database 3.1: Developer's Guide,” 2001, XP-002306148, 12 pages.
Chris Parkerson, “Ipedo XML Database 3.1 Now Available,” Jul. 22, 2002, XP-002306149, pp. 1-2.
Can Türker, “Schema Evolution in SQL-99 and Commercial (Object-) Relational DBMS,” 9thInternational Workshop on Foundations of Models and Languages for Data and Obejcts Fomlado/Demm 2000, Sep. 18, 2000, XP-002306150, pp. 1-32.
Hong Su et al., “XEM: XML Evolution Management,” Jan. 2002, XP-002306151, pp. 1-32.
Yuan Wang et al., “X-Diff: An Effective Change Detection Algorithm for XML Documents,” Proceedings of the 19thInternational Conference on Data Engineering (ICDE'03), 2003, IEEE, pp. 519-530.
Awais Rashid, “A Framework for Customisable Schema Evolution in Object-Oriented Databases,” Proceedings of the Seventh International Database Engineering and Applications Symposium (IDEAS'03), 2003, IEEE, 5 pages.
Xue Li, “A Survey of Schema Evolution in Object-Oriented Databases,” 1999, IEEE, pp. 362-371.
International Search Authority, “Notification of Transmittal of the International Search Report and the Written Opinion of the International Search Authority, or the Declaration,” Dec. 8, 2004, International Application No. PCT/US2004/027464, 14 pages.
“Current Claims of PCT/US2004/027464,” pp. 1-7.
Japan Patent Office, “Notice of Ground of Rejection,” with English translation, application 569332/2000, dated Apr. 27, 2005, 6 pages.
Riggs, Roger et al., “Pickling State in the Java™ System,” XP002128178, 10 pages.
“Universal Data Option for Informix Dynamic Server,” Informix Corporation, 1998, 8 pages.
Oracle, “Conventional and Direct Path Loads,” Chapter 9 of Oracle 9i Database Utilities-Release 2 (9.2), Copyright 2002 Oracle Corporation, 29 pages.
Claims, International application No. PCT/US2006/045700, 2 pages.
European Patent Office, “Notification of Transmittal of the International Search Report and the Written Opinion of the International Searching Authority, or the Declaration”, International application No. PCT/US2006/045700, dated Jul. 20, 2007, 12 pages.
Chakraborty, Krishnendu, et al., “The XML Garbage Collector”, XP-002297849, The Source for Developers & Sun Developer Network Site, Technical Articles & Tips, dated Mar. 2002, 5 pages.

Affiliated with

Also associated with

Rating

Direct loading of opaque types does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Direct loading of opaque types, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Direct loading of opaque types will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4157529