Object oriented based, business class methodology for performing data metric analysis

• US 7,386,571 B2
• Filed: 12/21/2004
• Issued: 06/10/2008
• Est. Priority Date: 08/30/2000
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Gupta, Arun K.
• Primary Examiner(s): MIZRAHI, DIANE D
• Application Number:
  US11/019,924
• Publication Number:
  US 20050102273A1
• Time in Patent Office: 1,267 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/24573 using data annotations, e.g. user-defined metadata
• CPC Class Codes: G06F 16/2465 Query processing support for facilitating data mining operations in structured databases
• CPC Class Codes: Y10S 707/954 Relational
• CPC Class Codes: Y10S 707/955 Object-oriented
• CPC Class Codes: Y10S 707/99936 Pattern matching access
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A method for extracting desired data from a digital database comprising the steps of specifying desired data elements to be extracted from an operational database, generating executable code from the identified data elements for extracting the identified data elements from the database, and executing the executable code thereby extracting the identified data elements from the database.

Claims

1. A method for developing a metric analysis profile and retrieving data elements of interest in accordance with the metric analysis profile, comprising:

modeling business activities as interactions and relationships between a plurality of business classes, wherein a business class includes attributes, processes and sub-processes corresponding to data elements of the business activities;

storing the plurality of business classes and the data elements in an operational database, including storing the plurality of business classes and data elements as a repository based aggregation in accordance with the modeled interactions and relationships;

specifying attributes, processes, sub-processes and data elements for inclusion within a metric analysis profile; and

automatically generating executable code from the specified attributes, processes, sub-processes and data elements, the generated executable code for (i) retrieving the specified data elements from the operational database and (ii) for storing the specified data elements in a staging database, in accordance with the metric analysis profile.

2. The method of claim 1, upon receipt of a request to delete one of the plurality of business classes, the method further comprising:

automatically generating executable code for deleting the specified attributes, processes and sub-processes corresponding to the requested business class; and

for at least one of the plurality of business classes depending from the requested business class, propagating the generated code to effectively delete the at least one dependent business class from the metric analysis profile resulting in deletion of both persistent and transient data composing the at least one dependent business class.

3. The method of claim 2 wherein the code for deleting includes code for de-allocating memory storage space in the operational database associated to the deleted business class.

4. The method of claim 2 wherein the request for deletion is automatically generated in response to a change in the metric analysis profile.

5. A system for developing a metric analysis profile and retrieving data elements of interest in accordance with said metric analysis profile, comprising:

a graphical user interface for modeling business activities as interactions and relationships between a plurality of business classes, wherein a business class includes attributes, processes and sub-processes corresponding to data elements of said business activities, said graphical user interface for specifying attributes, processes, sub-processes and data elements for inclusion within a metric analysis profile;

an operational database for storing said plurality of business classes and said data elements;

a staging database;

executable code automatically generated from said specified attributes, processes, sub-processes and data elements, said code for retrieving said specified data elements from said operational database and for storing said data elements in said staging database for analysis thereon in accordance with the metric analysis profile; and

executable code automatically generated upon receipt of a request to delete one of said plurality of business classes, said executable code for deleting said specified attribute, processes and sub-processes corresponding to said requested business class.

6. The system of claim 5 wherein when at least one of said plurality of business classes depends from said requested business class, said executable code includes logic for propagating to said at least one dependent business class and deleting said at least one dependent business class.

7. The system of claim 5 wherein said request for deletion is automatically generated in response to a change in said metric analysis profile.

8. Computer program product including a computer readable medium encoded with a computer program comprising:

a computer usable medium for developing a metric analysis profile and retrieving data elements of interest in accordance with the metric analysis profile, the computer useable medium being a part of the computer readable medium;

computer program instructions embodied on the computer usable medium, including instructions which when executed by a computer causes the computer to;

model business activities as interactions and relationships between a plurality of business classes, wherein a business class includes attributes, processes and sub-processes corresponding to data elements of the business activities;

store the plurality of business classes and the data elements in an operational database including storing the plurality of business classes and data elements as a repository based aggregation in accordance with the modeled interactions and relationships;

specify attributes, processes, sub-processes and data elements for inclusion within a metric analysis profile; and

automatically generate executable code from the specified attributes, processes, sub-processes and data elements, the generated executable code for (i) retrieving the specified data elements from the operational database and (ii) for storing the specified data elements in a staging database, in accordance with the metric analysis profile.

9. Computer program product of claim 8 wherein the instructions further include, upon receipt of a request to delete one of the plurality of business classes, instructions to:

automatically generate executable code for deleting the specified attributes, processes and sub-processes corresponding to the requested business class; and

for at least one of the plurality of business classes depending from the requested business class, propagating the generated code to effectively delete the at least one dependent business class including deleting both persistent and non-persistent data forming the at least one dependent business class.

10. Computer program product of claim 9 wherein the code for deleting includes code for de-allocating memory storage space in the operational database associated to the deleted business class.

11. Computer program product of claim 9 wherein the request for deletion is automatically generated in response to a change in the metric analysis profile.

12. A computer system for developing a metric analysis profile and retrieving data elements of interest in accordance with said metric analysis profile, comprising:

user interface means for modeling business activities as interactions and relationships between a plurality of business classes, wherein a business class includes attributes, processes and sub-processes corresponding to data elements of said business activities, said user interface means for specifying processes, sub-processes and data elements for inclusion within a metric analysis profile;

means for storing said plurality of business classes and said data elements, including storing the plurality of business classes and data elements as a repository based aggregation in accordance with the modeled interactions and relationships; and

automatic code generation means for generating application code from said specified attributes, processes, sub-processes and data elements, said code for retrieving said specified data elements from said operational database and for storing said data elements in a staging database for analysis thereon in accordance with the metric analysis profile.