Techniques for transaction semantics for a database server performing file operations

• US 7,716,260 B2
• Filed: 12/16/2004
• Issued: 05/11/2010
• Est. Priority Date: 12/16/2004
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Pannala, Syam, Sedlar, Eric, Jain, Namit, Idicula, Sam, Agarwal, Nipun
• Primary Examiner(s): Mofiz; Apu M
• Assistant Examiner(s): Le; Hung D
• Application Number:
  US11/013,889
• Publication Number:
  US 20060136509A1
• Time in Patent Office: 1,972 Days
• Field of Search: None
• US Class Current: 707/825
• CPC Class Codes: G06F 16/2322 using timestamps
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: G06F 2201/80 Database-specific techniques
• CPC Class Codes: G06F 2209/523 Mode
• CPC Class Codes: G06F 9/466 Transaction processing
• CPC Class Codes: G06F 9/526 Mutual exclusion algorithms

Abstract

A method and apparatus for reverting a resource to a prior state in time is provided. Changes are committed to a resource at a particular point in time. After the particular point in time, a request, which may be a file system operation request, to revert the resource to a state prior to the particular point in time is received at a database server. In response to the request, the resource is reverted to the state prior to the particular point in time. The current state of the resource ceases to reflect the plurality of changes. Advantageously, if a requestor creates an incorrect version of a resource, the changes made to a schema-based resource are not compatible with the schema, or the changes of multiple requesters are not compatible with each other, the resource may be reverted to the earlier point in time.

Claims

1. A machine-implemented method, comprising the machine-implemented steps of:

a database server receiving a file command representing at least a request to open a resource stored in a database;

commencing one or more database transactions to execute the file command;

opening said resource;

while said resource is opened in response to said file command, prior to closing said resource;

said database server successfully committing the one or more database transactions, wherein the one or more database transactions resulted in a change being committed to the resource;

after said database server successfully committing the one or more database transactions, said database server determining that the resource is to be reverted to a state that existed prior to receiving said file command and that does not reflect the committed change; and

after determining that the resource should be reverted to a state that existed prior to receiving said file command that does not reflect the committed change, reverting said resource to said state;

wherein the method is performed by one or more computing devices.

2. The method of claim 1 wherein the step of determining that the resource should be reverted is performed in response to a request to revert the resource.

3. The method of claim 1, wherein said change is one of a plurality of changes committed to the resource, and wherein the step of determining that the resource should be reverted is performed in response to a determination that the plurality of changes committed to the resource are not compatible with each other.

4. The method of claim 1 wherein:

prior to the change, the resource conforms to a particular schema; and

the step of determining that the resource should be reverted is performed in response to determining that, with said change, the resource ceases to conform to said particular schema.

5. The method of claim 1, wherein committing the one or more database transactions comprises:

making a first copy of the resource based on an original version of said resource;

establishing said first copy as the current version of said resource;

making said change to said first copy; and

committing said change to said first copy.

6. The method of claim 5, wherein said first copy is a constructed version of said resource, and wherein said original version of said resource is a deconstructed version of said resource.

7. The method of claim 6, wherein the step of making said first copy comprises the steps of:

constructing said constructed version of said resource based on said deconstructed version of said resource; and

storing said constructed version of said resource in a particular column of a database table.

8. The method of claim 5, wherein:

said step of copying said original version of said resource to said first copy comprises storing said first copy in a LOB column in a row of a database table within said database; and

said row is associated with said original version of said resource.

9. The method of claim 5, wherein said step of reverting said resource to said state comprises:

ceasing to use said first copy of said resource as the current version;

establishing said original version of said resource as the current version of said resource.

10. The method of claim 1, wherein

committing the one or more database transactions comprises:

if certain criteria are satisfied, then

making a copy of the resource,

establishing the copy as the current version of the resource, and

committing the change to the copy;

if said certain criteria are not satisfied, then

storing a snapshot time that reflects a time prior to receiving said file command, and

committing the change to the current version of the resource without making a copy of the current version of the resource.

11. The method of claim 10 wherein the certain criteria is based on whether undo information associated with said change may not be retained for a particular amount of time.

12. The method of claim 1, wherein said step of committing the one or more database transactions comprises:

storing a snapshot time with said resource, wherein said snapshot time indicates a logical time prior to when said change is committed to said resource;

making said change to said resource.

13. The method of claim 12, wherein said step of reverting said resource to said state comprises:

reconstructing said resource to reflect a state identified by said snapshot time using undo information.

14. The method of claim 1, further comprising the steps of:

prior to the step of determining that the resource should be reverted, receiving, from a requestor, a request to view the resource;

determining a requestor type of said requestor; and

determining, based on the requestor type of said requestor, whether to provide (a) a version of the resource that reflects the committed change or (b) a version of the resource reflecting the state prior to receiving said file command that does not reflect the committed change.

15. The method of claim 1, further comprising:

receiving, from a requestor, a request for a particular resource of said one or more resources;

determining which version of the particular resource to provide to the requestor based on (a) the requestor type of the requestor and (b) which types of locks are currently held on the particular resource.

29. The computer-readable storage medium of claim 1, wherein the one or more sequences of instructions, when executed by the one or more processors, further cause:

prior to the step of determining that the resource should be reverted, receiving, from a requestor, a request to view the resource;

determining a requestor type of said requestor; and

determining, based on the requestor type of said requestor, whether to provide (a) a version of the resource that reflects the committed change or (b) a version of the resource reflecting the state prior to receiving said file command that does not reflect the committed change.

30. The computer-readable storage medium of claim 1, wherein the one or more sequences of instructions, when executed by the one or more processors, further cause:

receiving, from a requestor, a request for a particular resource of said one or more resources;

determining which version of the particular resource to provide to the requestor based on (a) the requestor type of the requestor and (b) which types of locks are currently held on the particular resource.

16. A computer-readable storage medium storing one or more sequences of instructions which, when executed by one or more processors, causes:

a database server receiving a file command representing at least a request to open a resource stored in a database;

commencing one or more database transactions to execute the file command;

opening said resource;

while said resource is opened in response to said file command, prior to closing said resource;

said database server successfully committing the one or more database transactions, wherein the one or more database transactions resulted in a change being committed to the resource;

after said database server successfully committing the one or more database transactions, said database server determining that the resource is to be reverted to a state that existed prior to receiving said file command and that does not reflect the committed change; and

after determining that the resource should be reverted to a state that existed prior to receiving said file command that does not reflect the committed change, reverting said resource to said state.

17. The computer-readable storage medium of claim 16, wherein determining that the resource should be reverted is performed in response to a request to revert the resource.

18. The computer-readable storage medium of claim 16, wherein said change is one of a plurality of changes committed to the resource, and wherein determining that the resource should be reverted is performed in response to a determination that the plurality of changes committed to the resource are not compatible with each other.

19. The computer-readable storage medium of claim 16, wherein:

prior to the change, the resource conforms to a particular schema; and

determining that the resource should be reverted is performed in response to determining that, with said change, the resource ceases to conform to said particular schema.

20. The computer-readable storage medium of claim 16, wherein committing said one or more database transactions comprises:

making a first copy of the resource based on an original version of said resource;

establishing said first copy as the current version of said resource;

making said change to said first copy; and

committing said change to said first copy.

21. The computer-readable storage medium of claim 20, wherein said first copy is a constructed version of said resource, and wherein said original version of said resource is a deconstructed version of said resource.

22. The computer-readable storage medium of claim 21, wherein making said first copy comprises the steps of:

constructing said constructed version of said resource based on said deconstructed version of said resource; and

storing said constructed version of said resource in a particular column of a database table.

23. The computer-readable storage medium of claim 20, wherein:

copying said original version of said resource to said first copy comprises storing said first copy in a LOB column in a row of a database table within said database; and

said row is associated with said original version of said resource.

24. The computer-readable storage medium of claim 20, wherein reverting said resource to said state comprises:

ceasing to use said first copy of said resource as the current version;

establishing said original version of said resource as the current version of said resource.

25. The computer-readable storage medium of claim 16, wherein committing the one or more database transactions comprises:

if certain criteria are satisfied, then

making a copy of the resource,

establishing the copy as the current version of the resource, and

committing the change to the copy;

if said certain criteria are not satisfied, then

storing a snapshot time that reflects a time prior to receiving said file command, and

committing the change to the current version of the resource without making a copy of the current version of the resource.

26. The computer-readable storage medium of claim 25, wherein the certain criteria is based on whether undo information associated with said change may not be retained for a particular amount of time.

27. The computer-readable storage medium of claim 16, wherein committing the one or more database transactions comprises:

storing a snapshot time with said resource, wherein said snapshot time indicates a logical time prior to when said change is committed to said resource;

making said change to said resource.

28. The computer-readable storage medium of claim 27, wherein said step of reverting said resource to said state comprises:

reconstructing said resource to reflect a state identified by said snapshot time using undo information.