Enterprise performance management software system having dynamic code generation

• US 8,918,755 B2
• Filed: 01/30/2007
• Issued: 12/23/2014
• Est. Priority Date: 10/17/2006
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Borgsmidt, Rasmus, Gould, Michael
• Primary Examiner(s): Dao, Thuy
• Assistant Examiner(s): BUI, HANH THI MINH
• Application Number:
  US11/668,937
• Publication Number:
  US 20080092115A1
• Time in Patent Office: 2,884 Days
• US Class Current: 717/106
• 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, the first object being maintained by an object model within an object store of an enterprise planning system;

in response to receiving the request, the object model causing the first object to dynamically generate at least a portion of executable software instructions for a second object, wherein the portion of the executable software instructions is based on at least one of a dimensionality and arrangement of the multi-dimensional data referenced by the first object, 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, by the first object, the second object within the object store of the 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:

at least one processor;

an object model operable by the at least one processor to, during execution of an enterprise software application on the computer system, receive a request for multi-dimensional data referenced by a first object, the first object being maintained by the object model within an object store of an enterprise planning system;

wherein in response to receiving the request, the object model causes the first object to dynamically generate at least a portion of executable software instructions for a second object, wherein the portion of the executable software instructions is based on at least one of a dimensionality and arrangement of the multi-dimensional data referenced by the first object, wherein at least 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

wherein the first object instantiates the second object within the object store of the enterprise planning system, wherein the second object includes at least the portion of the executable software instructions and utilizes at least the 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 memory comprising instructions for causing a programmable processor to:

receive a request for multi-dimensional data referenced by a first object, the first object being maintained by an object model within an object store of an enterprise planning system;

in response to receiving the request, the object model causing the first object to dynamically generate a portion of the executable software instructions for a second object that references the multi-dimensional data, wherein the portion of the executable software instructions is based on at least one of a dimensionality and arrangement of the multi-dimensional data referenced by the first object, 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, by the first object, the second object within the object store of the 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 memory 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 memory 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 memory 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 memory 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 memory 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.