Methods, systems and computer program products for spreadsheet-based autonomic management of computer systems

• US 8,276,150 B2
• Filed: 10/12/2004
• Issued: 09/25/2012
• Est. Priority Date: 10/12/2004
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Chavoustie, Michael D., Eberbach, Andrew M., Montgomery, Trevor L., Woods, Joshua M.
• Primary Examiner(s): Truong, Camquy
• Application Number:
  US10/962,866
• Publication Number:
  US 20060080665A1
• Time in Patent Office: 2,905 Days
• Field of Search: 718/104, 715/212
• US Class Current: 718/104
• CPC Class Codes: G06F 2209/482 Application
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06F 9/4843 by program, e.g. task dispatcher, supervisor, operating system
• CPC Class Codes: G06F 9/543 User-generated data transfer, e.g. clipboards, dynamic data exchange [DDE], object linking and embedding [OLE]

Abstract

Methods, systems, and computer program products for managing a resource include using a first object to obtain data associated with the resource that is being managed. The first object may be embedded in a cell of a spreadsheet running on a spreadsheet application. Formula in the spreadsheet are executed, where at least some of the formulas reference at least some of the data obtained by the first object. The operation of the resource may then be altered based on the results of the executed formula.

Claims

1. A computer implemented method of managing a resource, the method comprising:

using a first object embedded in a cell of a spreadsheet, the spreadsheet running on a spreadsheet application operating on a processor, the first object including data gathering routines adapted to obtain data associated with the resource that is being managed;

executing one or more formulas embedded in another cell of the spreadsheet running on the spreadsheet application, wherein at least one of the one or more formulas reference the data obtained by the first object; and

using at least one resource management routine included in the first object to alter the operation of the resource based on the results of at least one of the one or more formulas being executed, wherein the spreadsheet running on the spreadsheet application forms an autonomic manager for autonomically managing the resource,

wherein the first object is configured to change the value of a notification cell in the spreadsheet in response to a communication from the resource that is being managed, and

wherein at least one of the formulas embedded in another cell of the spreadsheet comprises a conditional statement that calls for the execution of the at least one resource management routine associated with the first object if the notification cell in the spreadsheet has a certain value;

wherein a plurality of second objects are embedded into the spreadsheet that accept the obtained data.

2. The method of claim 1, wherein the data comprises metrics associated with the managed resource.

3. The method of claim 1, wherein the operation of the resource is automatically altered based on the results of the executed formula.

4. The method of claim 1, wherein the spreadsheet application runs the spreadsheet separately as a background process independent of a display interface of the spreadsheet application.

5. The method of claim 1, wherein the first object obtains data on a periodic basis.

6. The method of claim 5, further comprising a timer embedded in a cell of the spreadsheet.

7. The method of claim 1, wherein the one or more formulas in the spreadsheet are automatically executed by the spreadsheet application on a periodic basis and/or in response to a cell value change in the spreadsheet.

8. The method of claim 1, wherein altering the operation of the resource based on the results of the executed formula comprises executing one or more routines associated with the first object in response to execution of the formula, wherein the execution of the routine(s) acts to alter the operation of the resource.

9. The method of claim 1, wherein the spreadsheet application is the J2 spreadsheet application.

10. The method of claim 1, wherein at least some of the formula comprise conditional statements that call for the execution of one or more routines associated with the first object if the conditional statement is satisfied.

11. The method of claim 10, wherein execution of the one or more routines associated with the first object initiates the alteration of the operation of the resource.

12. The method of claim 1, further comprising a plurality of third objects associated with the resource that is being managed that obtain the data associated with the resource in response to a routine run by the first object and which deliver the obtained data to respective of the plurality of second objects.

13. An autonomic resource manager, comprising:

a processor;

a spreadsheet running on a spreadsheet application operating on the processor, the spreadsheet including;

one or more first objects that are embedded into one or more respective cells of the spreadsheet, wherein the one or more first objects including data gathering routines to provide data associated with a resource that is being managed; and

a plurality of formulas embedded in another cell of the spreadsheet, wherein the at least some of the plurality of formulas reference at least some of the data provided by the one or more first objects;

at least one resource management routine included in the one or more first objects to alter the operation of the resource that is being managed based on the results of at least one of the plurality of formulas being executed, wherein the spreadsheet running on the spreadsheet application forms the autonomic resource manager for autonomically managing the resource that is being managed; and

an interface between the spreadsheet and the resource that is being managed over which the data is transmitted,

wherein the spreadsheet includes at least one notification cell that has a data value that may be changed in response to a communication from the resource that is being managed, and

wherein at least one of the plurality of formulas comprises a conditional statement that calls for the execution of the at least one resource management routine associated with one of the one or more first objects if one of the notification cells has a certain value;

wherein a plurality of second objects are embedded into the spreadsheet that accept the obtained data.

14. The autonomic resource manager of claim 13, wherein at least some of the plurality of formula execute one or more routines associated with respective of the one or more first objects in response to a condition of the formula being satisfied.

15. The autonomic resource manager of claim 14, wherein the execution of the one or more routines acts to alter the operation of the resource that is being managed.

16. The autonomic resource manager of claim 13, further comprising a plurality of second objects that are embedded into the spreadsheet that accept the data provided by the one or more first objects.

17. The autonomic resource manager of claim 13, wherein the formula are automatically executed by the spreadsheet application.

18. The autonomic resource manager of claim 13, wherein the formula are automatically executed by the spreadsheet application in response to a detected change in the value of a cell of the spreadsheet.

19. The autonomic resource manager of claim 13, wherein the spreadsheet runs on the spreadsheet application as a background process and executes the formula in response to detected changes in the values of cells of the spreadsheet.

20. The autonomic resource manager of claim 13, wherein at least some of the formula comprise conditional statements that call for the execution of one or more routines associated with at least one of the first objects if the conditional statement is satisfied.

21. A computer program product for autonomic management of a resource, comprising:

a computer readable storage device having computer readable program code embodied therein, the computer readable program code comprising;

computer readable program code configured to obtain data associated with the resource that is being managed by a spreadsheet, the spreadsheet including a first object embedded in a cell of the spreadsheet, the first object including data gathering routines adapted to obtain data associated with the resource that is being managed;

the spreadsheet running on a spreadsheet application, the spreadsheet including one or more formulas embedded in at least one other cell of the spreadsheet, wherein at least one of the formulas reference the obtained data; and

computer readable program code included in the first object and configured to alter the operation of the resource based on the results of the executed one or more formulas, wherein the spreadsheet forms an autonomic manager for autonomically managing the resource,

wherein the first object is configured to change the value of a notification cell in the spreadsheet in response to a call initiated by the computer resource that is being managed, and

wherein at least one of the formulas embedded in another cell of the spreadsheet comprises a conditional statement that calls for the execution of a routine associated with the first object if the notification cell in the spreadsheet has a certain value;

wherein a plurality of second objects are embedded into the spreadsheet that accept the obtained data.

22. The computer program product of claim 21, wherein the computer readable program code that is configured to alter the operation of the resource based on the results of the executed formula comprises one or more routines associated with the object that communicate with the resource that is being managed.

23. A computer implemented method of creating an autonomic manager for a computer resource, the method comprising:

using a first object embedded in a cell of a spreadsheet, the spreadsheet running on a spreadsheet application operating on a processor, the first object including data gathering routines adapted to obtain data associated with the resource that is being managed;

executing one or more formulas embedded in another cell of the spreadsheet running on the spreadsheet application, wherein at least one of the one or more formulas reference the data obtained by the first object; and

using at least one resource management routine included in the first object to alter the operation of the resource based on the results of at least one of the one or more formulas being executed, wherein the spreadsheet running on the spreadsheet application forms an autonomic manager for autonomically managing the resource,

wherein the first object is configured to change the value of a notification cell in the spreadsheet in response to a communication from the resource that is being managed, and

wherein at least one of the formulas embedded in another cell of the spreadsheet comprises a conditional statement that calls for the execution of the at least one resource management routine associated with the first object if the notification cell in the spreadsheet has a certain value;

wherein a plurality of second objects are embedded into the spreadsheet that accept the obtained data.

24. The method of claim 23, wherein the at least one of the formulas calls for execution of one of the one or more second routines in response to the conditional statement being satisfied.

25. The method of claim 24, wherein the data comprises performance metrics associated with the computer resource that is to be managed.