US-12625989-B2 - Configuration method, data integration method, apparatus, device, and storage medium of data integration strategy

US12625989B2US 12625989 B2US12625989 B2US 12625989B2US-12625989-B2

Abstract

The disclosure provides a configuration method, data integration method, apparatus, device and storage medium of data integration strategy. The method includes obtaining a data structure of a data source based on an access credential of the data source; and configuring a data structure of an external object for the data structure of the data source, wherein there is a mapping relationship between the data structure of the external object and the data structure of the data source.

Inventors

Xiaoyi Peng
Yaoxuan Wang
Ying Lian

Assignees

BEIJING ZITIAO NETWORK TECHNOLOGY CO., LTD.

Dates

Publication Date: 20260512
Application Date: 20231110
Priority Date: 20221111

Claims (19)

1 . A method for integrating data by a data integration platform, comprising: receiving input by the data integration platform, wherein the input is indicative of an access credential for accessing a data source; reading a data structure of the data source by the data integration platform based on the access credential being verified, wherein the data structure of the data source comprises a plurality of first data attributes; creating an external object by the data integration platform based on the data structure of the data source, wherein a data structure of the external object comprises one or more second data attributes, and wherein there is a mapping relationship between the one or more second data attributes and one or more of the first plurality of data attributes; in response to a completion operation associated with configuring the data structure of the external object, displaying an object editing interface, wherein the object editing interface displays a reference list and related information of the external object, wherein the reference list comprises a list of the one or more second data attributes having a mapping relationship with the one or more first data attributes; in response to input associated with the reference list, editing the mapping relationship between the one or more second data attributes and the one or more first data attributes; obtaining data from the data source by the data integration platform based on the mapping relationship between the one or more second data attributes and the one or more first data attributes; and displaying the data obtained from the data source by the data integration platform in accordance with the data structure of the external object.
2 . The method according to claim 1 , wherein the access credential of the data source comprises a credential identification and credential information, and the credential information comprises a data location parameter and verification information of permission.
3 . The method according to claim 1 , wherein reading the data structure of the data source comprises: determining a target data table of the data source based on the access credential in a case where the access credential is a valid access credential; and obtaining a data structure of the target data table based on the access credential, wherein the data structure of the target data table is the data structure of the data source.
4 . The method according to claim 3 , wherein there are a plurality of data tables of the data source, and determining the target data table of the data source based on the access credential comprises: displaying at least the plurality of data tables of the data source based on the access credential, wherein the plurality of data tables comprise selectable data tables and unselectable data tables; and determining the target data table of the data source corresponding to the external object in response to a selection operation on one selectable data table among the plurality of data tables.
5 . The method according to claim 1 , wherein the one or more second data attributes contain a second data attribute of at least one associated object type; and/or the plurality of first data attributes contain a unique key data attribute, and the one or more second data attributes contains a system default attribute which has a mapping relationship with the unique key data attribute.
6 . The method according to claim 5 , further comprising: in response to a deletion operation on the one or more second data attributes mapped by the one or more first data attributes, removing a reference relationship of the one or more second data attributes based on reference relationship information of the one or more second data attributes in a case where the one or more second data attributes is referenced, and deleting the one or more second data attributes mapped by the one or more first data attributes in a case where the one or more second data attributes is not referenced.
7 . The method according to claim 1 , further comprising configuring the data structure of the external object based on the data structure of the data source, wherein the configuring the data structure of the external object based on the data structure of the data source comprises: displaying the plurality of first data attributes of the data source based on the data structure of the data source; determining at least one target data attribute of the data source in response to a selection operation on at least one of the plurality of first data attributes; and configuring the one or more second data attributes of the external object for each target data attribute, wherein there is a corresponding relationship between each target data attribute and the one or more second data attributes.
8 . The method according to claim 7 , further comprising: in response to a deletion operation on the one or more second data attributes mapped by the one or more first data attributes, removing a reference relationship of the one or more second data attributes based on reference relationship information of the one or more second data attributes in a case where the one or more second data attributes is referenced, and deleting the one or more second data attributes mapped by the one first data attribute in a case where the one or more second data attributes is not referenced.
9 . The method according to claim 1 , further comprising: editing the related information of the external object and related information corresponding to the one or more second data attributes in response to a completion operation of configuration of the mapping relationship between the one or more first data attributes and the one or more second data attributes, wherein the related information of the external object comprises an identification of the external object and/or a data display way corresponding to the external object, and the related information corresponding to the one or more second data attributes comprises a data type corresponding to the one or more second data attributes and/or a data display way corresponding to the one or more second data attributes.
10 . The method according to claim 9 , further comprising: in response to a deletion operation on the one or more second data attributes mapped by the one or more first data attributes, removing a reference relationship of the one or more second data attributes based on reference relationship information of the one or more second data attributes in a case where the one or more second data attributes is referenced, and deleting the one or more second data attributes mapped by the one or more first data attributes in a case where the one or more second data attributes is not referenced.
11 . The method according to claim 9 , wherein the object editing interface further displays the related information corresponding to the one or more second data attributes.
12 . The method according to claim 1 , wherein the object editing interface is further used for displaying a non-reference list, and the non-reference list comprises at least one other first data attribute of the plurality of the first data attributes that does not have a mapping relationship with the one or more second data attributes, and the method further comprises: updating the non-reference list based on a newly added first data attribute when detecting that there is the newly added first data attribute in the data source; and/or updating the non-reference list based on a reduced first data attribute in a case where there is no mapping relationship between the at least one other first data attribute and the one or more second data attributes when detecting that there is the reduced first data attribute in the data source; and/or in response to an operation on the at least one other first data attribute in the non-reference list, adding the at least one other first data attribute to the reference list, and configuring the one or more second data attributes of the external object corresponding to the at least one other first data attribute, so that the at least one other first data attribute in the reference list is transformed into the one or more second data attributes which has the mapping relationship with the at least one other first data attribute.
13 . The method according to claim 1 , further comprising: displaying a prompt message with an object editing interface portal when detecting that there is a changed first data attribute in the data source and in a case where the changed first data attribute contains a first data attribute with which the one or more second data attributes has the mapping relationship, wherein the prompt message is used for prompting that the data source is changed; displaying the object editing interface in response to an operation on the object editing interface portal; and deleting the one or more second data attributes mapped by the changed first data attribute in the object editing interface, wherein the at least one second data attribute mapped by the changed first data attribute has invalidation indication information for indicating that the mapping relationship between the one or more second data attributes and the first data attribute is invalid.
14 . The method according to claim 1 , further comprising: in response to a deletion operation on the one or more second data attributes mapped by the one or more first data attributes, removing a reference relationship of the one or more second data attributes based on reference relationship information of the one or more second data attributes in a case where the one or more second data attributes is referenced, and deleting the one or more second data attributes mapped by the one or more first data attributes in a case where the one or more second data attributes is not referenced.
15 . The method according to claim 14 , wherein removing the reference relationship of the one or more second data attributes based on the reference relationship information of the one or more second data attributes comprises: displaying the reference relationship information of the one or more second data attributes, wherein the reference relationship information at least comprises reference indication information and a reference editing interface portal, and the reference indication information is used for indicating module description information that references the one or more second data attributes; displaying a module editing interface referencing the one or more second data attributes in response to an operation on the reference editing interface portal; and deleting the one or more second data attributes in the module editing interface.
16 . A method for integrating data using a data integration platform, comprising: generating request parameters of a data query request associated with an external object based on a mapping relationship between one or more second data attributes of a data structure of the external object and one or more of a first plurality of data attributes of a data structure of a data source, wherein the parameters comply with requirements of a common protocol, wherein the external object is created by the data integration platform based on the data structure of the data source, and wherein the mapping relationship is edited in response to input associated with a reference list displayed on an object editing interface, wherein the object editing interface displays the reference list and related information of the external object, wherein the reference list comprises a list of the one or more second data attributes having the mapping relationship with the one or more first data attributes; requesting the data source to return the data by the data integration platform based on an access credential of the data source being verified and the request parameters; and displaying the data returned from the data source by the data integration platform in the data structure of the external object based on the mapping relationship between the data structure of the external object and the data structure of the data source.
17 . A configuration apparatus for a data integration strategy, comprising: an obtaining module, used for reading a data structure of a data source by a data integration platform based on an access credential for accessing the data source being verified, wherein input indicative of the access credential is received by the data integration platform; and a configuring module, used for creating an external object based on the data structure of the data source, wherein a data structure of the external object comprises one or more second data attributes and corresponds to the data structure of the data source, wherein there is a mapping relationship between the one or more second data attributes and one or more of a first plurality of data attributes of the data structure of the data source, and wherein the mapping relationship is edited in response to input associated with a reference list displayed on an object editing interface, wherein the object editing interface displays the reference list and related information of the external object, wherein the reference list comprises a list of the one or more second data attributes having the mapping relationship with the one or more first data attributes; and wherein the data integration platform is configured to obtain data from the data source based on the mapping relationship between the data structure of the external object and the data structure of the data source, and wherein the data integration platform is configured to display the data obtained from the data source in accordance with the data structure of the external object.
18 . An electronic device, comprising: a processor; and a memory for storing programs, wherein the programs comprise instructions which, when executed by the processor, cause the processor to perform the method according to claim 1 .
19 . A non-transitory computer-readable storage medium, wherein the non-transitory computer-readable storage medium stores computer instructions for causing a computer to execute the method according to claim 1 .

Description

CROSS REFERENCE TO RELATED APPLICATIONS This disclosure claims the priority of the Chinese Patent Application filed to the China Patent Office on Nov. 11, 2022, with the application number 202211415828.4 and the invention name of “CONFIGURATION METHOD, DATA INTEGRATION METHOD, APPARATUS, DEVICE AND STORAGE MEDIUM OF DATA INTEGRATION STRATEGY”, the entire disclosures of which are incorporated by reference as part of the disclosure of this application. TECHNICAL FIELD The disclosure relates to the technical field of the Internet, in particular to a configuration method, data integration method, apparatus, device, and storage medium of data integration strategy. BACKGROUND Developers may need to consume data from other systems when setting up data management systems. In the related technology, the interactive interface between the data management system and other systems may be agreed in advance, and data interaction may be performed through network communication or other means. However, the versatility of this data interaction scheme is relatively poor, if other systems that interact data with the data management system need to be changed, the interface needs to be redesigned and developed, resulting in a high cost of virtual integration. SUMMARY According to one aspect of the present disclosure, a configuration method for a data integration strategy is provided, comprising: obtaining a data structure of a data source based on an access credential of the data source; and configuring a data structure of an external object for the data structure of the data source. There is a mapping relationship between the data structure of the external object and the data structure of the data source. According to another aspect of the present disclosure, a data integration method is provided, comprising: generating request parameters of a data query request that comply with requirements of a common protocol based on a mapping relationship between a data structure of an external object and a data structure of a data source in response to the data query request for the external object; requesting the data source to return data from the data source based on an access credential of the data source and the request parameters that comply with the requirements of the common protocol; and displaying the data returned from the data source in the data structure of the external object based on the mapping relationship between the data structure of the external object and the data structure of the data source. According to another aspect of the present disclosure, a configuration apparatus for a data integration strategy is provided, comprising: an obtaining module, used for obtaining a data structure of a data source based on an access credential of the data source; and a configuring module, used for configuring a data structure of an external object for the data structure of the data source. There is a mapping relationship between the data structure of the external object and the data structure of the data source. According to another aspect of the present disclosure, a data integration apparatus is provided, comprising: a generating module, used for generating request parameters of a data query request that comply with requirements of a common protocol based on a mapping relationship between a data structure of an external object and a data structure of a data source in response to the data query request for the external object; a communicating module, used for requesting the data source to return data from the data source based on an access credential of the data source and the request parameters that comply with the requirements of the common protocol; a displaying module, used for displaying the data returned from the data source in the data structure of the external object based on the mapping relationship of the data structure of the external object and the data structure of the data source. According to another aspect of the present disclosure, an electronic device is provided, comprising: a processor and a memory for storing programs. The programs comprise instructions that, when executed by the processor, cause the processor to perform the methods according to the embodiments of the present disclosure. In one or more technical solutions provided in the embodiments of the present disclosure, when a data structure of a data source is obtained based on an access credential of the data source, the system where the data source is located may be entered through the access credential under the condition of satisfying the requirements of the data source for access permission, thus, the data structure of the data source may be read from the data source utilizing the common data interface. On this basis, a data structure of an external object is configured for the data structure of the data source, such that there is a mapping relationship between the data structure of the external object and the data structure of the data source. At