Methods and systems for archiving data

• US 7,457,933 B2
• Filed: 09/04/2003
• Issued: 11/25/2008
• Est. Priority Date: 09/09/2002
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Fischer, Martin, Pferdekaemper, Thorsten
• Primary Examiner(s): BATAILLE, PIERRE MICHE
• Application Number:
  US10/526,504
• Publication Number:
  US 20060129768A1
• Time in Patent Office: 1,909 Days
• Field of Search: 711/170, 711/156, 707/204, 707/200
• US Class Current: 711/170
• CPC Class Codes: G06F 16/2336 Pessimistic concurrency control approaches, e.g. locking or multiple versions without time stamps

Abstract

Methods, computer readable medium, and systems are provided for moving data objects from a first storage location to a second storage location. A data object may be selected from the first storage location. A first type identifier (ID) and a second type ID may be assigned to the data object. The second type ID may be stored in a second lock object. The first type ID may be stored in a first lock object. The data object may then be stored at the second storage location. The data object may then be deleted from the first storage location. The second type ID may then be deleted from the second lock object.

Claims

1. A computer system for processing data, comprising:

memory means for storing program instructions;

input means for entering data;

storage means for storing data;

a processor responsive to the program instructions, wherein the program instructions comprise program code means for performing a method for moving data objects in the computer system from a first storage location to a second storage location, the method comprising;

selecting a data object from the first storage location;

assigning a first type identifier (ID) to the data object;

assigning a second type ID to the data object;

storing the second type ID in a second lock object, indicating that the data object is being accessed;

determining whether the second type ID was stored successfully in the second lock object, and upon a successful storage, storing the first type ID in a first lock object, indicating that the data object is being moved;

storing the data object at the second storage location;

deleting the data object from the first storage location; and

deleting the second type ID from the second lock object, indicating that the data object is no longer being accessed, after the first type ID has been stored in the first lock object.

2. A computerized system for processing data, the computerized system executing a method comprising:

selecting a data object from a first storage location;

assigning a first type identifier (ID) to the data object;

assigning a second type ID to the data object;

storing the second type ID in a second lock object, indicating that the data object is being accessed;

determining whether the second type ID was stored successfully in the second lock object, and upon a successful storage, storing the first type ID in a first lock object, indicating that the data object is being moved;

storing the data object at a second storage location;

deleting the data object from the first storage location; and

deleting the second type ID from the second lock object, indicating that the data object is no longer being accessed, after the first type ID has been stored in the first lock object.

3. The computerized system of claim 2, the method further comprising:

deleting the first type ID from the first lock object, indicating that the data object is no longer being moved, after the data object has been deleted from the first storage location.

4. The computerized system of claim 2, wherein the data object comprises one or more fields of one or more tables, and wherein the first type ID and the second type ID comprise one or more key fields of the one or more tables.

5. The computerized system of claim 2, wherein the data object is stored in a file and wherein an assignment of the first type ID to the file or to a name of the file is stored in the first lock object.

6. The computerized system of claim 2, wherein the first lock object is stored on a nonvolatile storage means.

7. The computerized system of claim 2, wherein the second type ID is stored in the second lock object after assigning the second type ID to the data object.

8. The computerized system of claim 2, wherein the second type ID is stored in the second lock object before the data object is stored at the second storage location.

9. The computerized system of claim 2, wherein storing the first type ID in the first lock object further comprises:

storing first type IDs of all selected data objects before storing the data object at the second storage location.

10. The computerized system of claim 2, the method further comprising:

checking whether the first type ID has been stored in the first lock object, and if the first type ID has been stored, skipping storing the data object at the second storage location.

11. The computerized system of claim 2, the method further comprising:

checking whether the data object is contained in the second storage location, and if the data object is contained in the second storage location, skipping storing the data object at the second storage location.

12. The computerized system of claim 11, wherein the checking is performed by querying the first lock object.

13. The computerized system of claim 2, the method further comprising:

checking whether the data object has been completely stored in the second storage location, and if not completely stored, skipping deleting the data object from the first storage location and deleting the second type ID from the second lock object, and deleting the first type ID from the first lock object.

14. A method for moving data objects in a computer system from a first storage location to a second storage location, comprising:

selecting a data object from the first storage location;

assigning a first type identifier (ID) to the data object;

assigning a second type ID to the data object;

storing the second type ID in a second lock object, indicating that the data object is being accessed;

determining whether the second type ID was stored successfully in the second lock object, and upon a successful storage, storing the first type ID in a first lock object, indicating that the data object is being moved;

storing the data object at the second storage location;

deleting the data object from the first storage location; and

deleting the second type ID from the second lock object, indicating that the data object is no longer being accessed, after the first type ID has been stored in the first lock object.

15. The method of claim 14, further comprising:

deleting the first type ID from the first lock object, indicating that the data object is no longer being moved, after the data object has been deleted from the first storage location.

16. The method of claim 14, wherein the data object comprises one or more fields of one or more tables, and wherein the first type ID and the second type ID comprise one or more key fields of the one or more tables.

17. The method of claim 14, wherein the data object is stored in a file and wherein an assignment of the first type ID to the file or to a name of the file is stored in the first lock object.

18. The method of claim 14, wherein the first lock object is stored on a nonvolatile storage means.

19. The method of claim 14, wherein the second type ID is stored in the second lock object after assigning the second type ID to the data object.

20. The method of claim 14, wherein the second type ID is stored in the second lock object before the data object is stored at the second storage location.

21. The method of claim 14, wherein storing the first type ID in the first lock object further comprises:

storing first type IDs of all selected data objects before storing the data object at the second storage location.

22. The method of claim 14, further comprising:

checking whether the first type ID has been stored in the first lock object, and if the first type ID has been stored, skipping at least storing the data object at the second storage location.

23. The method of claim 14, further comprising:

checking whether the data object is contained in the second storage location, and if the data object is contained in the second storage location, skipping at least storing the data object at the second storage location.

24. The method of claim 23, wherein checking whether the data object is contained in the second storage location is performed by querying the first lock object.

25. The method of claim 14, further comprising:

checking whether the data object has been completely stored in the second storage location, and if not completely stored, skipping at least deleting the data object from the first storage location and deleting the second type ID from the second lock object, and deleting the first type ID from the first lock object.

26. The method of claim 14 for use in an enterprise resource planning software.

27. A computer readable storage medium comprising instructions for performing a method for moving data objects in a computer system from a first storage location to a second storage location, the method comprising:

selecting a data object from the first storage location;

assigning a first type identifier (ID) to the data object;

assigning a second type ID to the data object;

storing the second type ID in a second lock object, indicating that the data object is being accessed;

determining whether the second type ID was stored successfully in the second lock object, and upon a successful storage, storing the first type ID in a first lock object, indicating that the data object is being moved;

storing the data object at the second storage location;

deleting the data object from the first storage location; and

deleting the second type ID from the second lock object, indicating that the data object is no longer being accessed, after the first type ID has been stored in the first lock object.

28. The computer readable storage medium of claim 27, the method further comprising:

deleting the first type ID from the first lock object, indicating that the data object is no longer being move, after the data object has been deleted from the first storage location.

29. The computer readable storage medium of claim 27, wherein the data object comprises one or more fields of one or more tables, and wherein the first type ID and the second type ID comprise one or more key fields of the one or more tables.

30. The computer readable storage medium of claim 27, wherein the data object is stored in a file and wherein an assignment of the first type ID to the file or to a name of the file is stored in the first lock object.

31. The computer readable storage medium of claim 27, wherein the first lock object is stored on a nonvolatile storage means.

32. The computer readable storage medium of claim 27, wherein the second type ID is stored in the second lock object after assigning the second type ID to the data object.

33. The computer readable storage medium of claim 27, wherein the second type ID is stored in the second lock object before the data object is stored at the second storage location.

34. The computer readable storage medium of claim 27, wherein storing the first type ID in the first lock object further comprises:

storing first type IDs of all selected data objects before storing the data object at the second storage location.

35. The computer readable storage medium of claim 27, the method further comprising:

checking whether the first type ID has been stored in the first lock object, and if the first type ID has been stored, skipping storing the data object at the second storage location.

36. The computer readable storage medium of claim 27, the method further comprising:

checking whether the data object is contained in the second storage location, and if the data object is contained in the second storage location, skipping storing the data object at the second storage location.

37. The computer readable storage medium of claim 36, wherein the checking is performed by querying the first lock object.

38. The computer readable storage medium of claim 27, the method further comprising:

checking whether the data object has been completely stored in the second storage location, and if not completely stored, skipping deleting the data object from the first storage location and deleting the second type ID from the second lock object, and deleting the first type ID from the first lock object.