Method, system, and program for restricting modifications to allocations of computational resources

• US 20050187935A1
• Filed: 02/24/2004
• Published: 08/25/2005
• Est. Priority Date: 02/24/2004
• Status: Active Grant

• Current Assignee: Google LLC (Alphabet Inc.)
• Original Assignee: International Business Machines Corporation
• Inventors: Kumar, Saji C.
• Granted Patent: US 7,257,580 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: Y10S 707/99939 Privileged access
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

Provided are a method, system, and program for allocating resources for computational resources. A request is received to modify a permitted resource allocation. A determination is made of a modification restriction providing a limit on modifications that may be made to permitted resource allocations and the requested modification to the permitted resource allocation is allowed if the determined modification restriction allows the requested modification.

Claims

1. A method, comprising:

receiving a request to modify a permitted resource allocation;

determining a modification restriction providing a limit on modifications that may be made to the permitted resource allocation; and

allowing the requested modification to the permitted resource allocation if the determined modification restriction allows the requested modification.

2. The method of claim 1, wherein the determination of the modification restriction comprises determining whether there is one modification restriction for the resource allocation to be modified for a user that initiated the request or for a database to which the resource allocation applies.

4. The method of claim 1, further comprising:

generating an error condition if the requested modification is not permitted by the modification restriction.

5. The method of claim 1, wherein the permitted resource allocation comprises an amount of memory or an amount of processor resources to use when processing the operation, and wherein the requested modification of the amount of memory or processor resources to use is permitted if the modification restriction indicates that the permitted resource allocation can be modified.

6. The method of claim 1, wherein the permitted resource allocation indicates a location where data structures may be created, and wherein the requested modification of the location where data structures may be created is permitted if the modification restriction indicates that the permitted resource allocation can be modified.

7. The method of claim 1, wherein the permitted resource allocation indicates a type limitation on the type of data structures that may be created, and wherein the requested modification of the type of data structures that may be created is permitted if the modification restriction indicates that the permitted resource allocation can be modified. by the request.

8. The method of claim 1, further comprising:

receiving a request to modify one modification restriction for one permitted resource allocation;

modifying the modification restriction as requested if the request is submitted by an administrator; and

denying the requested modification of the modification restriction if the request is not submitted by the administrator.

9. The method of claim 1, wherein the modification restriction comprises an immutable indicator indicating whether the modification restriction can be modified by someone other than the administrator.

10. The method of claim 1, wherein the modification restriction is maintained in a stored procedure program, and wherein the permitted resource allocations specify resource allocations to execute the stored procedure program in which the modification restrictions are maintained.

11. A system, comprising:

computational resources;

circuitry capable of causing operations to be performed, the operations comprising;

(i) receiving a request to modify a permitted resource allocation of the computational resources;

(ii) determining a modification restriction providing a limit on modifications that may be made to the permitted resource allocation; and

(iii) allowing the requested modification to the permitted resource allocation if the determined modification restriction allows the requested modification.

12. The system of claim 11, wherein the determination of the modification restriction comprises determining whether there is one modification restriction for the resource allocation to be modified for a user that initiated the request or for a database to which the resource allocation applies.

13. The system of claim 11, wherein the operations capable of being performed by the circuitry further comprise:

generating an error condition if the requested modification is not permitted by the modification restriction.

14. The system of claim 11, wherein the computational resources include memory and processor resources, wherein the permitted resource allocation comprises an amount of the memory or an amount of the processor resources to use when processing the operation, and wherein the requested modification of the amount of memory or processor resources to use is permitted if the modification restriction indicates that the permitted resource allocation can be modified.

15. The system of claim 11, wherein the permitted resource allocation indicates a location where data structures may be created, and wherein the requested modification of the location where data structures may be created is permitted if the modification restriction indicates that the permitted resource allocation can be modified.

16. The system of claim 11, wherein the permitted resource allocation indicates a type limitation on the type of data structures that may be created, and wherein the requested modification of the type of data structures that may be created is permitted if the modification restriction indicates that the permitted resource allocation can be modified. by the request.

17. The system of claim 11, wherein the operations capable of being performed by the circuitry further comprise:

receiving a request to modify one modification restriction for one permitted resource allocation;

modifying the modification restriction as requested if the request is submitted by an administrator; and

denying the requested modification of the modification restriction if the request is not submitted by the administrator.

18. The system of claim 11, wherein the modification restriction comprises an immutable indicator indicating whether the modification restriction can be modified by someone other than the administrator.

19. The system of claim 11, wherein the modification restriction is maintained in a stored procedure program, and wherein the permitted resource allocations specify resource allocations to execute the stored procedure program in which the modification restrictions are maintained.

20. An article of manufacture capable of causing operations to be performed, the operations comprising:

receiving a request to modify a permitted resource allocation;

determining a modification restriction providing a limit on modifications that may be made to the permitted resource allocation; and

allowing the requested modification to the permitted resource allocation if the determined modification restriction allows the requested modification.

21. The article of manufacture of claim 20, wherein the determination of the modification restriction comprises determining whether there is one modification restriction for the resource allocation to be modified for a user that initiated the request or for a database to which the resource allocation applies.

22. The article of manufacture of claim 20, wherein the operations further comprise:

generating an error condition if the requested modification is not permitted by the modification restriction.

23. The article of manufacture of claim 20, wherein the permitted resource allocation comprises an amount of memory or an amount of processor resources to use when processing the operation, and wherein the requested modification of the amount of memory or processor resources to use is permitted if the modification restriction indicates that the permitted resource allocation can be modified.

24. The article of manufacture of claim 20, wherein the permitted resource allocation indicates a location where data structures may be created, and wherein the requested modification of the location where data structures may be created is permitted if the modification restriction indicates that the permitted resource allocation can be modified.

25. The article of manufacture of claim 20, wherein the permitted resource allocation indicates a type limitation on the type of data structures that may be created, and wherein the requested modification of the type of data structures that may be created is permitted if the modification restriction indicates that the permitted resource allocation can be modified. by the request.

26. The article of manufacture of claim 20, wherein the operations further comprise:

receiving a request to modify one modification restriction for one permitted resource allocation;

modifying the modification restriction as requested if the request is submitted by an administrator; and

denying the requested modification of the modification restriction if the request is not submitted by the administrator.

27. The article of manufacture of claim 20, wherein the modification restriction comprises an immutable indicator indicating whether the modification restriction can be modified by someone other than the administrator.

28. The article of manufacture of claim 20, wherein the modification restriction is maintained in a stored procedure program, and wherein the permitted resource allocations specify resource allocations to execute the stored procedure program in which the modification restrictions are maintained.