SHARED TEMPORARY STORAGE MANAGEMENT IN A SHARED DISK DATABASE CLUSTER

• US 20130117526A1
• Filed: 11/08/2011
• Published: 05/09/2013
• Est. Priority Date: 11/08/2011
• Status: Active Grant

• Current Assignee: Sybase Incorporated (SAP SE)
• Original Assignee: Sybase Incorporated (SAP SE)
• Inventors: FLORENDO, Colin Joseph
• Granted Patent: US 9,047,019 B2
• Time in Patent Office: Days
• US Class Current: 711/171
• CPC Class Codes: G06F 3/0622 in relation to access
• CPC Class Codes: G06F 3/0637 Permissions
• CPC Class Codes: G06F 3/064 Management of blocks
• CPC Class Codes: G06F 3/067 Distributed or networked storage systems, e.g. storage area networks [SAN], network attached storage [NAS]

Abstract

System, method, computer program product embodiments and combinations and sub-combinations thereof for temporary storage management in a shared disk database cluster are provided. Included is the reserving of units on-demand and of variable size from shared temporary storage space in the SDC. The utilization of the reserved units of the shared temporary storage space is tracked, and the shared temporary storage space is administered based on the tracking.

Claims

1. A method for shared temporary storage management in a shared disk database cluster (SDC), the method comprising:

reserving units on-demand and of variable size from shared temporary storage space in the SDC;

tracking utilization of the reserved units of the shared temporary storage space; and

administering the shared temporary storage space based on the tracking.

2. The method of claim 1 wherein reserving units further comprises controlling a size of the reserved units based upon configuration of the SDC, remaining space of the shared temporary storage space, and a number of configured nodes.

3. The method of claim 1 wherein tracking utilization of reserved units further comprises tracking bitmaps within coordinator and secondary nodes of the SDC.

4. The method of claim 3 wherein tracking further comprises updating the bitmaps with respect to space allocation activity for chains of reserved units.

5. The method of claim 3 wherein tracking further comprises updating the bitmaps with respect to timed expiration periods.

6. The method of claim 1 wherein administering further comprises utilizing a garbage collection event.

7. The method of claim 6 wherein the garbage collection event handles expired reserved units and deallocated temporary storage space for reuse in the SDC.

8. A shared disk database cluster (SDC) system with temporary storage management comprising:

shared-disk storage; and

a plurality of data processing nodes reserving units on-demand and of variable size from shared temporary storage space of the shared-disk storage and administering the shared temporary storage space through tracked utilization of the reserved units.

9. The system of claim 8 wherein configuration of the SDC, remaining space of the shared temporary storage space, and a number of configured nodes control a size of the reserved units.

10. The system of claim 8 wherein updates to bitmaps within coordinator and secondary nodes of the SDC track the utilization of the reserved units.

11. The system of claim 10 wherein the updates to bitmaps include space allocation activity for chains of reserved units.

12. The system of claim 10 wherein the update to bitmaps include timed expiration periods.

13. The system of claim 8 wherein administering further comprises utilizing a garbage collection event.

14. The system of claim 13 wherein the garbage collection event handles expired reserved units and deallocated temporary storage space for reuse in the SDC.

15. A computer-usable medium having instructions recorded thereon that, if executed by a computing device, cause the computing device to perform a method comprising:

reserving units on-demand and of variable size from shared temporary storage space in a shared disk cluster (SDC);

tracking utilization of the reserved units of the shared temporary storage space; and

administering the shared temporary storage space based on the tracking.

16. The computer-usable medium of claim 15 wherein reserving units further comprises controlling a size of the reserved units based upon configuration of the SDC, remaining space of the shared temporary storage space, and a number of configured nodes.

17. The computer-usable medium of claim 15 wherein tracking utilization of reserved units further comprises tracking bitmaps within coordinator and secondary nodes of the SDC.

18. The computer-usable medium of claim 17 wherein tracking further comprises updating the bitmaps with respect to space allocation activity for chains of reserved units.

19. The computer-usable medium of claim 17 wherein tracking further comprises updating the bitmaps with respect to timed expiration periods.

20. The computer-usable medium of claim 15 wherein administering further comprises utilizing a garbage collection event to handle expired reserved units and deallocated temporary storage space for reuse in the SDC.