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

• US 6,853,994 B1
• Filed: 08/30/2000
• Issued: 02/08/2005
• Est. Priority Date: 08/30/2000
• Status: Expired due to Term

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Gupta, Arun K.
• Primary Examiner(s): Mizrahi, Diane D.
• Application Number:
  US09/651,226
• Time in Patent Office: 1,623 Days
• Field of Search: 707/1, 707/4, 707/6, 707/10, 707/104.1, 707/103.R, 707/103.Y, 707/103, 707/103.Z, 707/102, 707/101, 707/100
• US Class Current: 707/694
• 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 extracting desired data for metric analysis, the method comprising the steps of:

specifying desired data elements to be extracted from an operational database;

automatically generating executable code from said specified data elements, the generated code being for extracting said specified data elements from said operational database; and

executing said executable code thereby extracting said specified data elements from said operational database and storing said extracted data in a staging database.

2. The method of claim 1 wherein said step of specifying includes identifying attributes and processes related to said desired data elements.

3. The method of claim 1 wherein said operational database is a relational database.

4. The method of claim 1 wherein said staging database is a relational database.

5. The method of claim 2 wherein identifying the data elements, attributes and processes is performed utilizing a graphical user interface.

6. The method of claim 5 wherein the step of identifying includes deriving rules for extracting said desired data elements from graphical representations and manually defined values of said attributes and processes related to said desired data elements.

7. The method of claim 1 wherein the step of executing includes invoking a background process for extracting and storing said specified data elements.

8. A method for extracting desired data for metric analysis, the method comprising the steps of:

specifying data elements to be extracted from an operational database including identifying attributes and processes related to said data elements;

generating executable code from said data elements, the executable code being for extracting said data elements from said operational database; and

executing said executable code thereby extracting said data elements from said operational database.

9. The method of claim 8 further comprising storing said data elements that were extracted from said operational database in a staging database.

10. The method of claim 8 wherein said staging database is a relational database.

11. The method of claim 8 wherein said operational database is a relational database.

12. The method of claim 8 wherein specifying said data elements and identifying said attributes and processes is performed utilizing a graphical user interface.

13. The method of claim 12 wherein the step of identifying includes deriving rules for extracting said data elements from graphical representations and manually defined values of said attributes and processes related to said data elements.

14. The method of claim 8 wherein the step of executing includes invoking a background process for extracting and storing said data elements.