Methods, systems and computer program products for spreadsheet-based autonomic management of computer systems
First Claim
Patent Images
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, andwherein 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.
1 Assignment
0 Petitions
Accused Products
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.
-
Citations
25 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
-
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. - View Dependent Claims (14, 15, 16, 17, 18, 19, 20)
-
-
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. - View Dependent Claims (22)
-
-
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. - View Dependent Claims (24, 25)
-
Specification