ENTERPRISE PERFORMANCE MANAGEMENT SOFTWARE SYSTEM HAVING DYNAMIC CODE GENERATION

• US 20080092115A1
• Filed: 01/30/2007
• Published: 04/17/2008
• Est. Priority Date: 10/17/2006
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: Cognos Incorporated (International Business Machines Corporation)
• Inventors: Borgsmidt, Rasmus, Gould, Michael
• Granted Patent: US 8,918,755 B2
• Time in Patent Office: Days
• US Class Current: 717/108
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 9/45516 Runtime code conversion or optimisation

Abstract

An enterprise software system provides dynamic code generation techniques that facilitate quick and efficient resolution of multi-dimensional data demands. The system includes an object store that stores a first object that references multi-dimensional data and an object model that receives a request for multi-dimensional data referenced by the first object. The object model causes the first object to dynamically generate a portion of the executable software instructions for a second object in response to the request and instantiate the second object within the object store. The dynamically generated portion of the instructions enables the second object to calculate a memory address into the multi-dimensional data referenced by the first object. The second object utilizes the dynamically generated portion of the instructions to satisfy the request. Because the second object maintains direct access to the multi-dimensional data, it need not make costly and time consuming function calls to the first object.

Claims

1. A computer-implemented method comprising:

during the execution of an enterprise software application on a computer system, receiving a request for multi-dimensional data referenced by a first object;

dynamically generating at least a portion of executable software instructions for a second object with the first object in response to the request, wherein the portion of the executable software instructions enables the second object to calculate a memory address into the multi-dimensional data referenced by the first object; and

instantiating the second object within an object store of an enterprise planning system, wherein the second object includes the dynamically generated portion of the executable software instructions and utilizes the dynamically generated portion of the executable software instructions to satisfy the request.

2. The method of claim 1, wherein receiving the request for multi-dimensional data comprises receiving a request for multi-dimensional data referenced by one of a virtual dataset object, a virtual selection dataset object, and a dataset object.

3. The method of claim 1, wherein the portion of the executable software instructions enables the second object to further calculate the memory address into the multi-dimensional data referenced by the first object without having to make a function call to the first object.

4. The method of claim 1,

wherein dynamically generating the portion of the executable software instructions comprises dynamically generating a portion of the executable software instructions for an indexer object with the first object that references the multi-dimensional data in response to the request, and

wherein the portion of the executable software instructions enables the indexer object to calculate a memory address into the multi-dimensional data referenced by the first object.

5. The method of claim 4, wherein dynamically generating the portion of the executable software instructions comprises dynamically generating a portion of the executable software instructions for the indexer object with a virtual selection dataset object that references the multi-dimensional data in response to the request.

6. The method of claim 1, wherein dynamically generating the portion of the executable software instructions comprises dynamically generating a portion of the executable software instructions for a data provider element included within a virtual function dataset object with the first object that references the multi-dimensional data in response to the request, and

wherein the portion of the executable software instructions enables the data provider element to calculate a memory address into the multi-dimensional data referenced by the first object.

7. The method of claim 6, wherein dynamically generating the portion of the executable software instructions further comprises dynamically generating another portion of the executable software instructions for the data provider element included within the virtual function dataset object with a third object that references additional multi-dimensional data in response to the request, and

wherein the portion of the executable software instructions enables the data provider element to calculate a memory address into the additional multi-dimensional data referenced by the third object.

8. The method of claim 7, wherein dynamically generating the portion of the executable software instructions further comprises:

passing an executable software instructions object to the first object with the virtual function dataset object;

dynamically generating the portion of the executable software instructions for the data provider element of the virtual function dataset object with the first object;

writing the dynamically generated portion of the executable software instructions to the executable software instructions object with the first object;

passing the executable software instructions object to the third object with the virtual function dataset object;

dynamically generating the other portion of the executable software instructions for the data provider element of the virtual function dataset object with the third object; and

writing the dynamically generated other portion of the executable software instructions to the executable software instructions object with the third object.

9. The method of claim 1,

wherein dynamically generating the portion of the executable software instructions comprises dynamically generating a portion of the executable software instructions for a data provider element included within an aggregation dataset object with the first object that references the multi-dimensional data in response to the request, and

wherein the portion of the executable software instructions enables the data provider element to calculate a memory address into the multi-dimensional data referenced by the first object.

10. The method of claim 9,

wherein dynamically generating the portion of the executable software instructions further comprises dynamically generating another portion of the executable software instructions for the data provider element included within the aggregation dataset object with a third object that references additional multi-dimensional data in response to the request, and

wherein the portion of the executable software instructions enables the data provider element to calculate a memory address into the additional multi-dimensional data referenced by the third object.

11. The method of claim 10, wherein dynamically generating the portion of the executable software instructions further comprises:

passing an executable software instructions object to the first object with the aggregation dataset object;

dynamically generating the portion of the executable software instructions for the data provider element of the aggregation dataset object with the first object;

writing the dynamically generated portion of the executable software instructions to the executable software instructions object with the first object;

passing the executable software instructions object to the third object with the aggregation dataset object;

dynamically generating the other portion of the executable software instructions for the data provider element of the aggregation dataset object with the third object; and

writing the dynamically generated other portion of the executable software instructions to the executable software instructions object with the third object.

12. The method of claim 1,

wherein dynamically generating the portion of the executable software instructions comprises dynamically generating java byte-code executable software instructions for the second object with the first object that references the multi-dimensional data in response to the request, and

wherein the java byte-code executable software instructions enable the first object to calculate a memory address into the multi-dimensional data referenced by the first object.

13. A computing system comprising:

an object store that stores a first object that references multi-dimensional data;

an object model that receives a request for multi-dimensional data referenced by the first object and causes the first object to dynamically generate a portion of the executable software instructions for a second object in response to the request and instantiate the second object within the object store, wherein the portion of the executable software instructions enables the second object to calculate a memory address into the multi-dimensional data referenced by the first object, and further wherein the second object includes the dynamically generated portion of the executable software instructions and utilizes the dynamically generated portion of the executable software instructions to satisfy the request.

14. The computing system of claim 13,

wherein the object store stores the first object by storing one of a virtual dataset object, a virtual selection dataset object, and a dataset object that references the multi-dimensional data, and

wherein the object model receives the request for multi-dimensional data by receiving a request for multi-dimensional data referenced by one of a virtual dataset object, a virtual selection dataset object, and a dataset object.

15. The computing system of claim 13, wherein the portion of the executable software instructions enables the second object to further calculate the memory address into the multi-dimensional data referenced by the first object without having to make a function call to the first object.

16. The computing system of claim 13,

wherein the object model causes the first object to dynamically generate the portion of the executable software instructions by dynamically generating a portion of the executable software instructions for an indexer object in response to the request, and

wherein the portion of the executable software instructions enables the indexer object to calculate a memory address into the multi-dimensional data referenced by the first object.

17. The computing system of claim 16, wherein the object model that causes the first object to dynamically generate the portion of the executable software instructions comprises an object model that causes a virtual selection dataset object to dynamically generate a portion of the executable software instructions for the indexer object in response to the request.

18. The computing system of claim 13,

wherein the object model causes the first object to dynamically generate the portion of the executable software instructions by dynamically generating a portion of the executable software instructions for a data provider element included within a virtual function dataset object in response to the request, and

wherein the portion of the executable software instructions enables the data provider element to calculate a memory address into the multi-dimensional data referenced by the first object.

19. The computing system of claim 18,

wherein the object store further stores a third object that references additional multi-dimensional data, and

wherein the object model receives the request by receiving a request for the multi-dimensional data and additional multi-dimensional data referenced by the respective first and third objects and further causes the third object to dynamically generate another portion of the executable software instructions for the data provider element included within the virtual function dataset object in response to the request, and further wherein the portion of the executable software instructions enables the data provider element to calculate a memory address into the additional multi-dimensional data referenced by the third object.

20. The computing system of claim 19,

wherein the object model further causes the first object to dynamically generate the portion of the executable software instructions by:

receiving an executable software instructions object from the virtual function dataset object;

dynamically generating the portion of the executable software instructions for the data provider element of the virtual function dataset object;

writing the dynamically generated portion of the executable software instructions to the executable software instructions object; and

,

wherein the object model further causes the third object to dynamically generate the portion of the executable software instructions by;

receiving the executable software instructions object from the virtual function dataset object;

dynamically generating the other portion of the executable software instructions for the data provider element of the virtual function dataset object; and

writing the dynamically generated other portion of the executable software instructions to the executable software instructions object.

21. The computing system of claim 13,

wherein the object model causes the first object to dynamically generate the portion of the executable software instructions by dynamically generating a portion of the executable software instructions for a data provider element included within an aggregation dataset object in response to the request, and

wherein the portion of the executable software instructions enables the data provider element to calculate a memory address into the multi-dimensional data referenced by the first object.

22. The computing system of claim 21,

wherein the object store further stores a third object that references additional multi-dimensional data, and

wherein the object model receives the request by receiving a request for the multi-dimensional data and additional multi-dimensional data referenced by the respective first and third objects and further causes the third object to dynamically generate another portion of the executable software instructions for the data provider element included within the aggregation dataset object in response to the request, and further wherein the portion of the executable software instructions enables the data provider element to calculate a memory address into the additional multi-dimensional data referenced by the third object.

23. The computing system of claim 22,

wherein the object model causes the first object to dynamically generate the portion of the executable software instructions by:

receiving an executable software instructions object from the aggregation dataset object;

dynamically generating the portion of the executable software instructions for the data provider element of the aggregation dataset object;

writing the dynamically generated portion of the executable software instructions to the executable software instructions object; and

,

wherein the object model causes the third object to dynamically generate the portion of the executable software instructions by;

receiving the executable software instructions object from the aggregation dataset object;

dynamically generating the other portion of the executable software instructions for the data provider element of the aggregation dataset object; and

writing the dynamically generated other portion of the executable software instructions to the executable software instructions object.

24. The computing system of claim 13,

wherein the object model causes the first object to dynamically generate the portion of the executable software instructions by dynamically generating java byte-code executable software instructions for the second object in response to the request, and

wherein the java byte-code executable software instructions enables the first object to calculate a memory address into the multi-dimensional data referenced by the first object.

25. A computer-readable medium comprising instructions for causing a programmable processor to:

receive a request for multi-dimensional data referenced by a first object;

dynamically generate a portion of the executable software instructions for a second object with the first object that references the multi-dimensional data in response to the request, wherein the portion of the executable software instructions enables the second object to calculate a memory address into the multi-dimensional data referenced by the first object; and

instantiate the second object within an object store of an enterprise planning system, wherein the second object includes the dynamically generated portion of the executable software instructions and utilizes the dynamically generated portion of the executable software instructions to satisfy the request.

26. The computer-readable medium of claim 25, wherein the portion of the executable software instructions enables the second object to further calculate the memory address into the multi-dimensional data referenced by the first object without having to make a function call to the first object.

27. The computer-readable medium of claim 25, wherein the instructions cause the processor to dynamically generate the portion of the executable software instructions by dynamically generating a portion of the executable software instructions for an indexer object with the first object that references the multi-dimensional data in response to the request, wherein the portion of the executable software instructions enables the indexer object to calculate a memory address into the multi-dimensional data referenced by the first object.

28. The computer-readable medium of claim 25, wherein the instructions cause the processor to dynamically generate the portion of the executable software instructions by dynamically generating a portion of the executable software instructions for a data provider element included within a virtual function dataset object with the first object that references the multi-dimensional data in response to the request, wherein the portion of the executable software instructions enables the data provider element to calculate a memory address into the multi-dimensional data referenced by the first object.

29. The computer-readable medium of claim 25, wherein the instructions cause the processor to dynamically generate the portion of the executable software instructions by dynamically generating a portion of the executable software instructions for a data provider element included within an aggregation dataset object with the first object that references the multi-dimensional data in response to the request, wherein the portion of the executable software instructions enables the data provider element to calculate a memory address into the multi-dimensional data referenced by the first object.

30. The computer-readable medium of claim 25, wherein the instructions cause the processor to dynamically generate the portion of the executable software instructions by dynamically generating java byte-code executable software instructions for the second object with the first object that references the multi-dimensional data in response to the request, wherein the java byte-code executable software instructions enables the first object to calculate a memory address into the multi-dimensional data referenced by the first object.