System and method for providing recommended mappings for use by a mapper in an integration cloud service design time

Patent metadata

Field	Value
Publication number	US-10372773-B2
Application number	US-201615171900-A
Country	US
Kind code	B2
Filing date	Jun 2, 2016
Priority date	Jun 5, 2015
Publication date	Aug 6, 2019
Grant date	Aug 6, 2019

Abstract

In accordance with an embodiment, described herein is a system and method for providing recommended mappings to a mapper for use in designing an integration flow in a design time of a cloud-based integration service. A database can store mapping records from a plurality of sources, and mapping records inferred from the extracted mapping records. Each mapping record in the database can be associated with a rating generated by a ranking engine. A recommendation engine can be invoked to retrieve one or more mapping records from the database and an auto suggestion engine, for graphical display in the mapper. The integration flow can be published, and mapping information therein can be parsed by the recommendation engine into one or more mapping records, which are persisted into the database to update the mapping records in the database.

First claim

What is claimed is:

1. A system for providing recommended mappings for use in a cloud-based integration service, comprising:
a computer comprising one or more microprocessors;
a cloud service, executing on the computer, wherein the cloud service comprises:
a web interface application for creating an integration flow between a source application and a target application, the integration flow using an actual mapping between the source and target applications stored in a database; and
a runtime for executing the integration flow; and

a recommendation engine that is configured to parse files associated with the integration flow, and to store mapping information of the files associated with the integration flow as one or more parsed mapping records to the database, wherein the database stores one or more other mapping records from a plurality of sources associated with the system, wherein each of the one or more parsed and the one or more other mapping records are stored in the database associated with a rating based on their respective sources and use frequencies,
wherein the recommendation engine, when storing the one or more parsed mapping records to the database, operates to determine that a particular parsed mapping record to be stored exists in the database, and to update the particular parsed mapping record in the database by increasing its use frequency,
wherein the recommendation engine presents a recommended mapping between the source and target applications and a rating of the recommended mapping,
wherein the recommendation engine replaces the actual mapping between the source and target applications in the database with the recommended mapping as a new actual mapping between the source and target applications based on an acceptance of the recommended mapping.

2. The system of claim 1 , wherein the recommendation engine comprises one or more application programming interfaces operable to interact with the database, and one or more parsers operable to parse the files associated with the integration flow.

3. The system of claim 1 , wherein the web interface application is configured to display:
a source data object associated with the source application and including one or more source elements;
a target data object associated with the target application and including one or more target elements;
the actual mapping between the source and target applications using a first display format; and
the recommended mapping between the source and target applications using a second display format different than the first display format.

4. The system of claim 1 , wherein the recommendation engine retrieves the presented recommended mapping information between the source and target data objects from the database.

5. The system of claim 1 , wherein:
the recommendation engine further comprises an auto suggestion engine that generates one or more auto-recommended mappings based on a name match between elements of the source data object and the target data object;
the web interface application displays the one or more auto-recommended mappings generated by the auto suggestion engine graphically between the source data object and the target data object as the recommended mapping.

6. The system of claim 1 , wherein the database is configured to receive the one or more other mapping records from a plurality of sources comprising one or more developers, and one or more third-party companies that published their mapping information.

7. The system of claim 1 , further comprising:
an inferred mapping record generator comprising a daemon process in the database, the daemon process periodically executing to generate one or more mapping records inferred from the plurality of mapping records extracted from the plurality of sources,
wherein the database stores the one or more mapping records inferred from the plurality of mapping records extracted from the plurality of sources.

8. The system of claim 7 , wherein the database comprises:
a ranking engine that operating to generate the rating for each mapping record; and
a mapping record generator that operable to generate the one or more inferred mapping records using semantic inference logics.

9. A method for providing recommended mappings for use by a cloud-based integration service, comprising:
providing a cloud service, executing on the computer comprising one or more microprocessors, wherein the cloud service comprises:
a web interface application for creating an integration flow between a source application and a target application, the integration flow using an actual mapping between the source and target applications stored in a database; and
a runtime for executing the integration flow;

invoking, by the web interface application, a recommendation engine that parses files associated with the integration flow, and stores mapping information of the files associated with the integration flow as one or more mapping records to a database, wherein the database stores one or more other mapping records from a plurality of sources associated with the system, wherein each of the one or more parsed and the one or more other mapping records are stored in the database associated with a rating based on their sources and use frequencies;
determining, by the recommendation engine, that a particular parsed mapping record to be stored exists in the database;
updating the particular parsed mapping record in the database by increasing its use frequency;
presenting by the recommendation engine a recommended mapping between the source and target applications and a rating of the recommended mapping; and
replacing by the recommendation engine the actual mapping between the source and target applications in the database with the recommended mapping as a new actual mapping between the source and target applications based on an acceptance of the recommended mapping.

10. The method of claim 9 , wherein the recommendation engine comprises one or more application programming interfaces operable to interact with the database, and one or more parsers operable to parse the files associated with the integration flow.

11. The system of claim 9 , wherein the web interface application is configured to display:
a source data object associated with the source application and including one or more source elements;
a target data object associated with the target application and including one or more target elements:
the actual mapping between the source and target applications using a first display format; and
the recommended mapping between the source and target applications using a second display format different than the first display format.

12. The method of claim 9 , wherein the recommendation engine retrieves the presented recommended mapping information between the source and target data objects from the database.

13. The method of claim 12 , wherein the recommendation engine further comprises an auto suggestion engine that generates recommended mappings based on a name match between elements of the source data object and the target data object;
the web interface application displays the one or more auto-recommended mappings generated by the auto suggestion engine graphically between the source data object and the target data object as the recommended mapping.

14. The method of claim 9 , wherein the database is configured to receive the one or more other mapping records from a plurality of sources comprising one or more developers, and one or more third-party companies that published their mapping information.

15. The method of claim 9 , further comprising:
periodically execu

Assignees

• Oracle Int Corp

Inventors

• Raheja Rajesh
• Amin Viresh
• Vajragiri Virupaksha

Classifications

• G06F16/9537 Primary

  Spatial or temporal dependent retrieval, e.g. spatiotemporal queries · CPC title