TASK MANAGEMENT INTEGRATED DESIGN ENVIRONMENT FOR COMPLEX DATA INTEGRATION APPLICATIONS

• US 20150309769A1
• Filed: 04/24/2014
• Published: 10/29/2015
• Est. Priority Date: 04/24/2014
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: GREENE, Lawrence A., JACOBSON, Eric A., LI, Yong, PU, Xiaoyan
• Granted Patent: US 9,805,326 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/06316 Sequencing of tasks or work

Abstract

Embodiments presented herein provide task management capabilities for designing a complex data integration workflow in an integrated design environment (IDE). A task management tool of the IDE allows a developer to tag various stages of a data integration workflow in a non-linear manner. When the task management tool receives a tag for a given stage, the task management tool identifies incomplete tasks associated with the stage and generates a task list that includes the incomplete tasks. The developer may return to completing any of the tasks in the workflow in any sequence as desired.

Claims

1. A method for managing a design process of a data integration workflow, the method comprising:

presenting a design representation of the data integration workflow, wherein the design representation shows each of a plurality of stages included in the data integration workflow and wherein each stage is associated with a set of tasks performed as part of the data integration workflow;

receiving a tag to associate with a first one of the stages, wherein the tag indicates that at least a first task associated with the first stage is incomplete;

updating, based on the received tag, the design representation to reflect that the first stage has at least one incomplete development task.

2. The method of claim 1, further comprising, presenting, as part of the design representation, stages of the data integration workflow which have incomplete development tasks.

3. The method of claim 2, further comprising:

receiving input completing the set of tasks associated with the first stage; and

updating the design representation with an indication that the set of tasks associated with the first stage has been completed.

4. The method of claim 2, further comprising:

receiving a selection of one of the stages presented in the graphical representation;

presenting a list of incomplete development tasks associated with the selected stage in the graphical representation.

5. The method of claim 1, further comprising, storing the at least the first task in a task repository.

6. The method of claim 1, further comprising, upon receiving an indication that a database table shared with the stage has been modified, updating metadata for the stage with information of the modification.

7. The method of claim 1, wherein the data integration workflow is an extract, transform, and load workflow.

8. A computer program product, comprising:

a computer-readable storage medium having computer-readable program code embodied therewith, the computer-readable program code configured to perform an operation for managing a design process of a data integration workflow, the operation comprising;

presenting a design representation of the data integration workflow, wherein the design representation shows each of a plurality of stages included in the data integration workflow and wherein each stage is associated with a set of tasks performed as part of the data integration workflow;

receiving a tag to associate with a first one of the stages, wherein the tag indicates that at least a first task associated with the first stage is incomplete;

updating, based on the received tag, the design representation to reflect that the first stage has at least one incomplete development task.

9. The computer program product of claim 8, wherein the operation further comprises, presenting, as part of the design representation, stages of the data integration workflow which have incomplete development tasks.

10. The computer program product of claim 9, wherein the operation further comprises:

receiving input completing the set of tasks associated with the first stage; and

updating the design representation with an indication that the set of tasks associated with the first stage has been completed.

11. The computer program product of claim 9, wherein the operation further comprises:

receiving a selection of one of the stages presented in the graphical representation;

presenting a list of incomplete development tasks associated with the selected stage in the graphical representation.

12. The computer program product of claim 8, wherein the operation further comprises, storing the at least the first task in a task repository.

13. The computer program product of claim 8, wherein the operation further comprises, upon receiving an indication that a database table shared with the stage has been modified, updating metadata for the stage with information of the modification.

14. The computer program product of claim 8, wherein the data integration workflow is an extract, transform, and load workflow.

15. A system, comprising:

a processor; and

a memory storing a program, which, when executed on the processor, performs an operation for managing a design process of a data integration workflow, the operation comprising;

presenting a design representation of the data integration workflow, wherein the design representation shows each of a plurality of stages included in the data integration workflow and wherein each stage is associated with a set of tasks performed as part of the data integration workflow;

receiving a tag to associate with a first one of the stages, wherein the tag indicates that at least a first task associated with the first stage is incomplete;

updating, based on the received tag, the design representation to reflect that the first stage has at least one incomplete development task.

16. The system of claim 15, wherein the operation further comprises, presenting, as part of the design representation, stages of the data integration workflow which have incomplete development tasks.

17. The system of claim 16, wherein the operation further comprises:

receiving input completing the set of tasks associated with the first stage; and

updating the design representation with an indication that the set of tasks associated with the first stage has been completed.

18. The system of claim 16, wherein the operation further comprises:

receiving a selection of one of the stages presented in the graphical representation;

presenting a list of incomplete development tasks associated with the selected stage in the graphical representation.

19. The system of claim 15, wherein the operation further comprises, upon receiving an indication that a database table shared with the stage has been modified, updating metadata for the stage with information of the modification.

20. The system of claim 15, wherein the data integration workflow is an extract, transform, and load workflow.