Software tool for generating technical business data requirements

• US 8,688,626 B2
• Filed: 01/27/2011
• Issued: 04/01/2014
• Est. Priority Date: 01/27/2011
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Marrelli, Carl Michael, Oberhofer, Martin, Rashidi, Solmaz, Narayanan, Ram S
• Primary Examiner(s): Jalil, Neveen Abel
• Assistant Examiner(s): TORGRIMSON, TYLER J
• Application Number:
  US13/014,913
• Publication Number:
  US 20120197681A1
• Time in Patent Office: 1,160 Days
• Field of Search: None
• US Class Current: 707/603
• CPC Class Codes: G06Q 10/0633 Workflow analysis
• CPC Class Codes: G06Q 10/067 Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

A computer implemented method, system, and/or computer program product generates technical business data requirements from functional process requirements. Such method, system, and/or computer program product include data processing infrastructure. The data processing infrastructure may further include at least one data persistence component and at least one business process hierarchy. The computer implemented method, system, and/or computer program product obtain a set of technical elements concerning functional process requirements for each business process within the business process hierarchy. Such method, system, and/or computer program product classify technical elements into functional objects, link each of the functional objects to at least one process within the business process hierarchy and generate a plurality of business data roadmap templates in the data processing infrastructure. The generated business data roadmap templates are stored in the persistence component of the data processing infrastructure.

Claims

1. A computer implemented method for deriving technical data requirements from functional process requirements, the computer implemented method comprising the steps of:

providing a data processing infrastructure, wherein the data processing infrastructure comprises at least one data persistence component and at least one business process hierarchy defining a scope of a business transformation project;

a processor obtaining a plurality of technical elements defining functional process requirements of one or more business process within the at least one business process hierarchy;

the processor classifying the plurality of technical elements into functional objects and linking the classified plurality of technical elements to at least one process within the business process hierarchy;

the processor extracting metadata from at least one metadata source system, wherein the extracted metadata comprises metadata associated with each technical element contained within each functional object;

the processor generating a plurality of user-editable business data roadmap templates based on the extracted metadata, wherein the plurality of user-editable business data roadmap templates defines technical data requirements that are used in the business transformation project;

the processor storing the plurality of user-editable business data roadmap templates in the persistence component; and

wherein the metadata associated with each technical element includes all attributes associated with the technical element, and wherein for each attribute the processor;

determines if the attribute is present in a lookup table and extracts information associated with the attribute from the lookup table;

determines a foreign-key relationship associated with the attribute; and

determines a constraint associated with the attribute.

2. The computer implemented method of claim 1, wherein the data processing infrastructure further comprises a graphical user interface configured to facilitate modification of the plurality of user-editable business data roadmap templates.

3. The computer implemented method of claim 1, wherein the data processing infrastructure further comprises a report generator, wherein the report generator is operative to communicate with the data persistence component and wherein the report generator is adapted for generating a plurality of reports, wherein the plurality of reports provides a process-centric view of data within the business transformation project.

4. The computer implemented method of claim 1, wherein the plurality of technical elements comprises a plurality of tables, table descriptions, table fields, or client-specific system information.

5. The computer implemented method of claim 1, wherein the processor classifying the plurality of technical elements further comprises establishing an association between the plurality of technical elements and the functional objects based on a plurality of business process definitions.

17. The computer implemented method of claim 1, wherein classifying the plurality of technical elements into functional objects comprises storing the classified plurality of technical elements in a table.

6. A computer system comprising:

a central processing unit (CPU), a computer readable memory, and a computer readable storage medium;

a data processing infrastructure, wherein the data processing infrastructure comprises at least one data persistence component and at least one business process hierarchy defining a scope of a business transformation project;

first program instructions to acquire a plurality of technical elements defining functional process requirements of one or more process within the at least one business process hierarchy;

second program instructions to classify the plurality of technical elements into functional objects and to link the classified plurality of technical elements to at least one process within the business process hierarchy;

third program instructions to extract metadata from at least one metadata source system, wherein the extracted metadata comprises metadata associated with each technical element contained within each functional object;

fourth program instructions to generate a plurality of user-editable business data roadmap templates based on the extracted metadata, wherein the plurality of user-editable business data roadmap templates defines technical data requirements that are used in the business transformation project;

fifth program instructions to store the plurality of user-editable business data roadmap templates in the persistence component; and

wherein the first, second, third, fourth and fifth program instructions are stored on the computer readable storage medium for execution by the CPU via the computer readable memory;

wherein the metadata associated with each technical element includes all attributes associated with the technical element, and wherein for each attribute the third or fourth program instructions include instructions to;

determine if the attribute is present in a lookup table, and extract information associated with the attribute from the lookup table;

determine a foreign-key relationship associated with the attribute; and

determine a constraint associated with the attribute.

7. The system of claim 6, wherein the data processing infrastructure further comprises a graphical user interface configured to facilitate modification of the plurality of user-editable business data roadmap templates.

8. The system of claim 6, wherein the data processing infrastructure further comprises a report generator, wherein the report generator is operative to communicate with the data persistence component and wherein the report generator is adapted for generating a plurality of reports, wherein the plurality of reports provides a process-centric view of data within the business transformation project.

9. The system of claim 6, wherein the plurality of technical elements comprises a plurality of tables, table descriptions, table fields, or client-specific system information.

10. The system of claim 6, wherein the second program instructions further comprise instructions to establish an association between the plurality of technical elements and the functional objects based on a plurality of business process definitions.

11. The system of claim 6, wherein the data processing infrastructure is pre-configured to communicate with an external enterprise system via at least one middleware component.

18. The system of claim 6, wherein the second program instructions further comprise instructions to store the classified plurality of technical elements in a table.

12. A computer program product for deriving technical data requirements from functional process requirements, the computer program product comprising:

a computer readable storage medium;

a data processing infrastructure, wherein the data processing infrastructure comprises at least one data persistence component and at least one business process hierarchy defining a scope of a business transformation project;

first program instructions to acquire a plurality of technical elements defining functional process requirements of one or more process within the at least one business process hierarchy;

second program instructions to classify the plurality of technical elements into functional objects and to link the classified plurality of technical elements to at least one process within the business process hierarchy;

third program instructions to extract metadata from at least one metadata source system, wherein the extracted metadata comprises metadata associated with each technical element contained within each functional object;

fourth program instructions to generate a plurality of user-editable business data roadmap templates based on the extracted metadata, wherein the plurality of user-editable business data roadmap templates defines technical data requirements that are used in the business transformation project; and

fifth program instructions to store the plurality of user-editable business data roadmap templates in the persistence component; and

wherein the first, second, third, fourth and fifth program instructions are stored on the computer readable storage medium;

wherein the metadata associated with each technical element includes all attributes associated with the technical element, and wherein for each attribute the third or fourth program instructions include instructions to;

determine if the attribute is present in a lookup table, and extract information associated with the attribute from the lookup table;

determine a foreign-key relationship associated with the attribute; and

determine a constraint associated with the attribute.

13. The computer product of claim 12, wherein the data processing infrastructure further comprises a graphical user interface configured to facilitate modification of the plurality of user-editable business data roadmap templates.

14. The computer product of claim 12, wherein the data processing infrastructure further comprises a report generator, wherein the report generator is operative to communicate with the data persistence component and wherein the report generator is adapted for generating a plurality of reports, wherein the plurality of reports provides a process-centric view of data within the business transformation project.

15. The computer product of claim 12, wherein the plurality of technical elements comprises a plurality of tables, table descriptions, table fields, or client-specific system information.

16. The computer product of claim 12, wherein the second program instructions further comprise instructions to establish an association between the plurality of technical elements and the functional objects based on a set of business process definitions.

19. The computer product of claim 12, wherein the second program instructions further comprise instructions to store the classified plurality of technical elements in a table.