Determining mappings for application integration based on user contributions

• US 9,244,949 B2
• Filed: 06/27/2013
• Issued: 01/26/2016
• Est. Priority Date: 06/27/2013
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Jin, Qian Li, Li, Zheng, Liu, Jian, Ma, Ji rong, Partridge, Lucas W.
• Primary Examiner(s): Stevens, Robert
• Application Number:
  US13/928,600
• Publication Number:
  US 20150006543A1
• Time in Patent Office: 943 Days
• Field of Search: 707/748
• US Class Current: 1/1
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases

Abstract

A method for determining mappings for application integration. The method includes identifying a plurality of integration templates that each contains a mapping of a first data field to another data field, wherein at least two of the plurality of integration templates map the first data field to different other data fields. The method includes receiving a ranking of each of the plurality of integration templates. The method includes determining a preferred mapping of the first data field to a second data field, based, at least in part, on the received ranking.

Claims

1. A method for determining mappings for application integration, the method comprising:

identifying, by one or more computer processors, a plurality of integration templates that each contain a mapping of a first data field to another data field, wherein at least two of the plurality of integration templates map the first data field to different other data fields, and wherein each of the plurality of integration templates is published to a community of users within an application integration environment by at least one user in the community of users;

receiving, by the one or more computer processors, a ranking of each of the plurality of integration templates; and

determining, by the one or more computer processors, a preferred mapping of the first data field to a second data field, based, at least in part, on the received ranking.

2. The method of claim 1, wherein said receiving the ranking of the each of the plurality of integration templates includes receiving a ranking from the community of users.

3. The method of claim 1, further comprising:

determining, by the one or more computer processors, a weight of each of the mappings of the first data field to each of the different other data fields, based, at least in part, on the received ranking of each of the plurality of integration templates; and

determining, by the one or more computer processors, the preferred mapping of the first data field to the second data field, based, at least in part, on the determined weight.

4. The method of claim 3, wherein said determining the weight of the mapping of the first data field to each of the different other data fields further comprises:

determining, by the one or more computer processors, an overall ranking for each of the plurality of integration templates, wherein the overall ranking is an average ranking for each of the plurality of integration templates containing a mapping of the first data field to each one of the different other data fields; and

summing the overall rankings of each of the plurality of integration templates containing the mapping of the first data field to each one of the different other data fields.

5. The method of claim 1, wherein said determining a preferred mapping of the first data field to the second data field further comprises:

determining, by the one or more computer processors, a weight of each of the mappings of the first data field to each of the different other data fields, based, at least in part, on the received ranking of each of the plurality of integration templates;

comparing a determined weight of the mapping of the first data field to the second data field to each of a determined weight of the mapping of the first data field to each of the different other data fields; and

determining, by the one or more computer processors, the determined weight of the mapping of the first data field to the second data field is higher than each of the determined weight of the mapping for the first data field to each of the different other data fields.

6. The method of claim 1, wherein an integration template includes mappings for a first data field determined by the at least one user operating within the application integration environment.

7. The method of claim 1, further comprising presenting the determined preferred mapping of the first data field to the at least one user operating within the application integration environment.

8. The method of claim 1, further comprising:

determining, by the one or more computer processors, at least one additional integration template containing the mapping of the first data field to another data field is published to the community of users; and

updating, by the one or more computer processors, stored data of the plurality of integration templates with data of the at least one additional integration template.

9. A computer program product for determining mappings for application integration, the computer program product comprising:

one or more non-transitory computer-readable tangible storage devices media and program instructions stored on the one or more non-transitory computer-readable tangible storage devices media, the program instructions comprising;

program instructions to identify a plurality of integration templates containing a mapping of a first data field to another data field, wherein at least two of the plurality of integration templates map the first data field to different other data fields, and wherein each of the plurality of integration templates is published to a community of users within an application integration environment by at least one user in the community of users;

program instructions to receive a ranking of each of the plurality of integration templates; and

program instructions to determine a preferred mapping of the first data field to a second data field, based, at least in part, on the received ranking.

10. The computer program product of claim 9, wherein said program instructions to receive the ranking of the each of the plurality of integration templates include program instructions to receive a ranking from the community of users.

11. The computer program product of claim 9, further comprising:

program instructions to determine a weight of each of the mappings of the first data field to each of the different other data fields, based, at least in part, on the received ranking of each of the plurality of integration templates; and

program instructions to determine the preferred mapping of the first data field to the second data field, based, at least in part, on the determined weight.

12. The computer program product of claim 11, wherein said program instructions to determine the weight of each of the mappings of the first data field to each of the different other data fields further comprise:

program instructions to determine an overall ranking for each of the plurality of integration templates, wherein the overall ranking is an average ranking for each of the plurality of integration templates containing a mapping of the first data field to each one of the different other data fields; and

program instructions to sum the overall rankings of each of the plurality of integration templates containing the mapping of the first data field to each one of the different other data fields.

13. The computer program product of claim 9, wherein said program instructions to determine a preferred mapping of the first data field to the second data field further comprise:

program instructions to determine a weight of each of the mappings of the first data field to each of the different other data fields, based, at least in part, on the received ranking of each of the plurality of integration templates;

program instructions to compare a determined weight of the mapping of the first data field to the second data field to each of a determined weight of the mapping of the first data field to each of the different other data fields; and

program instructions to determine that the determined weight of the mapping of the first data field to the second data field is higher than each of the determined weight of the mapping for the first data field to each of the different other data fields.

14. The computer program product of claim 9, wherein an integration template includes mappings for a first data field determined by the at least one user operating within the application integration environment.

15. The computer program product of claim 9, further comprising program instructions to perform the determined preferred mapping of the first data field within the application integration environment.

16. A computer system for determining mappings for application integration, the computer system comprising:

one or more computer processors;

one or more computer-readable tangible storage media;

program instructions stored on the one or more computer-readable tangible storage media for execution by at least one of the one or more computer processors, the program instructions comprising;

program instructions to identify a plurality of integration templates containing a mapping of a first data field to another data field, wherein at least two of the plurality of integration templates map the first data field to different other data fields, and wherein each of the plurality of integration templates is published to a community of users within an application integration environment by at least one user in the community of users;

program instructions to receive a ranking of each of the plurality of integration templates; and

program instructions to determine a preferred mapping of the first data field to a second data field, based, at least in part, on the received ranking.

17. The computer system of claim 16, wherein said program instructions to receive the ranking of the each of the plurality of integration templates include program instructions to receive a ranking from the community of users.

18. The computer system of claim 16, further comprising:

program instructions to determine a weight of each of the mappings of the first data field to each of the different other data fields, based, at least in part, on the received ranking of each of the plurality of integration templates; and

program instructions to determine the preferred mapping of the first data field to the second data field, based, at least in part, on the determined weight.

19. The computer system of claim 18, wherein said program instructions to determine the weight of each of the mappings of the first data field to each of the different other data fields further comprise:

program instructions to determine an overall ranking for each of the plurality of integration templates, wherein the overall ranking is an average ranking for each of the plurality of integration templates containing a mapping of the first data field to each one of the different other data fields; and

program instructions to sum the overall rankings of each of the plurality of integration templates containing the mapping of the first data field to each one of the different other data fields.

20. The computer system of claim 16, wherein said program instructions to determine a preferred mapping of the first data field to the second data field further comprise:

program instructions to determine a weight of each of the mappings of the first data field to each of the different other data fields, based, at least in part, on the received ranking of each of the plurality of integration templates;

program instructions to compare a determined weight of the mapping of the first data field to the second data field to each of a determined weight of the mapping of the first data field to each of the different other data fields; and

program instructions to determine that the determined weight of the mapping of the first data field to the second data field is higher than each of the determined weight of the mapping for the first data field to each of the different other data fields.