Sharing large objects in distributed systems

• US 20060004838A1
• Filed: 08/12/2004
• Published: 01/05/2006
• Est. Priority Date: 05/14/2004
• Status: Abandoned Application

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Lakshminath, Anand, Kulkarni, Goutam, Kundu, Joydip, Shodhan, Neeraj Pradip, Gu, Yuhong, Kaplan, Lewis
• Application Number:
  US10/918,023
• Publication Number:
  US 20060004838A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2219 Large Object storage; Management thereof

Abstract

A system and method for efficiently sharing Large Objects (LOBs) is disclosed. Historical records (e.g., redo logs) are kept in which a marker is placed prior to the LOB. The marker includes identifying information, such as the row-column intersection. Using the identifying information in the marker, the LOB may be shared with other systems without staging the LOB at a source database system, prior to transporting the LOB from the source database system to the destination database system. Additionally, using the identifying information, the LOB may be accessed and manipulated prior to being consumed at the destination system.

Claims

1. A machine-implemented method for sharing large objects comprising:

recording in a redo log a first set of one or more records describing at least identifying information of a large object prior to storing a second set of one or more records that include at least a portion of content of the large object; and

determining how to process the second set based on the first set.

2. The method of claim 1, wherein the one or more records includes only the identifying information.

3. The method of claim 1, further comprising:

receiving from a user a specification of the identifying information to include in the first set of information that identifies the second set.

4. The method of claim 1, wherein the identifying information includes an identifier of a portion of a row record associated with the large object.

5. The method of claim 1, wherein the identifying information includes an identifier of a portion of a table associated with the large object.

6. The method of claim 1, wherein the determining includes at least determining to send the second set of one or more records to a destination database system.

7. The method of claim 1, wherein a first portion of data for a character is stored in a first record of the one or more records and a second portion of data for the character is stored in a second record of the one or more records, and the method further comprises:

determining the character based on the first record and the second record.

8. The method of claim 1, further comprising

sending the second set of one or more records to a destination database system;

and

accessing and transforming the second set of one or more records after the sending and prior to consuming the second set of one or more records at the destination database, based on the information.

9. The method of claim 1, further comprises, based on the determining, discarding the second set of one or more records prior to capturing a last portion of the large object.

10. The method of claim 1, further comprises, based on the determining, discarding the second set of one or more records without staging the large object.

11. The method of claim 1,

wherein the redo log is associated with a source database system, and

wherein the method further comprises:

capturing the second set of one or more records, based on the determining;

sending the second set of one or more records to a destination database system, based on the determining;

detecting that a problem occurred at the source database system after the second set of one or more records was sent, wherein the problem occurred prior to a last portion of the large object being sent;

wherein the capturing changes and the sending are not repeated for records belonging to the second set of one or more records that were already sent.

12. A machine-readable medium carrying information comprising:

a log including at least a log of changes made to information stored in a database;

one or more portions of data associated with a large object stored in the database; and

a marker including at least information identifying the large object, wherein

the marker is located within the log prior to the one or more portions of data

13. The machine readable medium of claim 12, wherein the marker does not indicate a change made to information stored in the database.

14. A machine-readable medium carrying one or more sequences of instructions, which when executed by one or more processors, causes the one or more processors to perform a method comprising:

recording in a redo log a first set of one or more records describing at least identifying information of a large object prior to storing a second set of one or more records that include at least a portion of content of the large object; and

determining how to process the second set based on the first set.

15. The machine readable medium of claim 14, wherein the one or more records includes only the identifying information.

16. The machine-readable medium of claim 14, wherein the method further comprises:

receiving from a user a specification of the identifying information to include in the first set of information that identifies the second set.

17. The machine-readable medium of claim 14, wherein the identifying information includes an identifier of a portion of a row record associated with the large object.

18. The machine-readable medium of claim 14, wherein the identifying information includes an identifier of a portion of a table associated with the large object.

19. The machine-readable medium of claim 14, wherein the determining includes at least determining to send the second set of one or more records to a destination database system.

20. The machine-readable medium of claim 14, wherein a first portion of data for a character is stored in a first record of the one or more records and a second portion of data for the character is stored in a second record of the one or more records, and the method further comprises:

determining the character based on the first record and the second record.

21. The machine-readable medium of claim 14, wherein the method further comprises:

sending the second set of one or more records to a destination database system; and

accessing and transforming the second set of one or more records after the sending and prior to consuming the second set of one or more records at the destination database, based on the information.

22. The machine-readable medium of claim 14, wherein the method further comprises, based on the determining, discarding the second set of one or more records prior to capturing a last portion of the large object.

23. The machine-readable medium of claim 14, wherein the method further comprises, based on the determining, discarding the second set of one or more records without staging the large object.

24. The machine-readable medium of claim 14,

wherein the redo log is associated with a source database system, and

wherein the method further comprises:

capturing the second set of one or more records, based on the determining;

sending the second set of one or more records to a destination database system, based on the determining;

detecting that a problem occurred at the source database system after the second set of one or more records was sent, wherein the problem occurred prior to a last portion of the large object being sent;

wherein the capturing changes and the sending are not repeated for records belonging to the second set of one or more records that were already sent.