Data interaction method among multiple systems in electricity transaction market, unified integration platform, device and storage medium
By building a unified integrated platform in the power trading market, configuring integration and standardized interfaces, the complexity and inconsistency of data interaction between systems are solved, low-cost and efficient data interaction is achieved, and data consistency and accuracy are ensured. sex.
Patent Information
- Application Number
- CN202411091610.7
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-09
- Publication Date
- 2024-11-08
AI Technical Summary
Existing data interaction methods between systems have problems such as low data acquisition efficiency, inconsistent data, and high complexity in development and maintenance. Especially in the power trading market, multiple data interaction methods and complex data links make it difficult to achieve data exchange by point-to-point interaction. Unification and standardization.
By building a unified integration platform, integrating configuration means and standardizing interfaces and forwarding mapping rules, unified access and mesh forwarding interactions of each system can be achieved, data interaction processes are simplified, development and maintenance costs are reduced, and data consistency and accuracy are ensured. .
It realizes low-cost and low-complex interaction between data between multiple systems, improves data transmission efficiency, ensures data consistency and accuracy, and provides unified access statistics.
Smart Images

Figure CN118916192A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of data interaction technology, and in particular to a data interaction method, a unified integration platform, a device and a storage medium between multiple systems in an electricity trading market, which can realize data exchange between systems at low cost. Background Art
[0002] In the power trading market, the power trading center usually manages multiple internal systems, covering medium- and long-term transactions, spot transactions, demand-side transactions, retail, unified certification, settlement, transaction service fees, risk control and other business systems. These internal business systems need to interact with external systems such as power grid marketing systems and power grid dispatching systems for data.
[0003] Data exchange between existing systems is generally completed through point-to-point interaction between two systems. Although this method is relatively simple to implement, it is difficult to take into account some characteristics and potential problems in the data exchange process:
[0004] 1. Complexity of data interaction logic: There is a need for data interaction between different business systems, but the data acquisition rules are different, the data links are complex, and point-to-point interaction between systems cannot eliminate the problem of repeated acquisition of the same data. This leads to low data acquisition efficiency and inconsistent data between systems;
[0005] 2. Diversity of data interaction methods: Data interaction methods include API, message queue, SFTP and other forms, and API interface standards also include RESTful, Webservice and other forms, which increases the complexity of point-to-point system interaction development and maintenance;
[0006] 3. Broadcast requirements in the data interaction process: In the data interaction process, there are many scenarios where data is broadcast one-to-many to multiple receivers. Point-to-point system interaction requires developers to connect and develop with each receiver separately, which results in a large workload of development, testing and joint debugging and low efficiency.
[0007] In order to overcome the shortcomings of the existing methods, the present invention proposes a data interaction method between multiple systems in the power trading market, which realizes the unified integration and standardized management of data transmission between various systems. Through this method, the data interaction process can be simplified, the development and maintenance costs can be reduced, the data transmission efficiency can be improved, the consistency and accuracy of the data can be ensured, and unified access statistics can be provided. Summary of the invention
[0008] The purpose of the present invention is to address the limitations and shortcomings of the existing technology and propose a data interaction method, unified integration platform, device and storage medium among multiple systems in the power trading market. By building a unified integration platform, the interfaces and forwarding mapping rules are integrated and standardized by configurable means to achieve unified access and mesh forwarding interaction of various systems.
[0009] The object of the present invention is achieved through the following technical solutions: In the first aspect, the present invention provides a data interaction method between multiple systems in an electricity trading market, comprising the following steps:
[0010] (1) Configure and register access to various system information;
[0011] (2) Configure and register interface information for use by the service caller (data sender);
[0012] (3) Configure the service provider (data receiver) to call the entry information and associate it with the access system information registered in step (1); one service provider can be associated with one access system information; one access system information can be associated with multiple service providers;
[0013] (4) Select the interface information configured in step (2) as the source and the call entry configured in step (3) as the target, form a forwarding rule, and configure the mapping relationship between the interface and the entry;
[0014] (5) The service caller (data sender) accesses the interface configured in step (2), finds all the rules with the interface information configured in step (2) as the source among all the forwarding rules configured in step (4), calls the target call entry (data receiver) of each forwarding rule in parallel, and returns it to the service caller based on the mapping relationship.
[0015] Furthermore, in step (1), the access system information is configured and registered, including the access system name, access system identifier, access system location (internal system / external system), access system type (backend service / file server / message queue), access system IP source whitelist, and the credential information of the access system access interface is generated.
[0016] Furthermore, in step (2), interface information is configured and registered, including interface address, interface communication protocol, interface input parameter data format, interface input parameter data field description, interface return value data format, interface return value data field description, and interface call timeout.
[0017] Furthermore, in step (3), the service provider (data receiver) call entry information is configured for pushing data, including the call entry address, the call entry communication protocol, the call entry input parameter data format, the call entry input parameter data field description, the call entry return value data format, the call entry return value data field description, and the call entry call timeout period.
[0018] Furthermore, in step (4), a new data forwarding rule is created, and any interface information configured in step (2) is selected as the source, and any calling entry configured in step (3) is selected as the target to form a forwarding rule, and a mapping relationship between the fields of the interface input parameters and the fields of the calling entry input parameters, and a mapping relationship between the fields of the calling entry return value and the fields of the interface return value are configured.
[0019] Furthermore, in step (5), the service caller (data sender) carries the credential information generated in step (1), accesses the interface configured in step (2), finds all rules with the interface information configured in step (2) as the source in all forwarding rules configured in step (4), calls the target call entry (data receiver) of each forwarding rule in parallel, and organizes the return value of each call into a complete return value according to the mapping from the access system identifier to the return value, and returns it to the service caller. Each forwarding rule configured in step (4) defines the mapping relationship between the fields of the interface input parameter and the fields of the call entry input parameter, and the mapping relationship between the fields of the call entry return value and the fields of the interface return value, and performs data and return value conversion according to the above mapping relationship.
[0020] In a second aspect, the present invention also provides a unified integrated platform for data interaction between multiple systems in an electricity trading market, the unified integrated platform comprising a system information configuration module, an interface information configuration module, a call entry information configuration module, a forwarding rule establishment module and a data interaction module;
[0021] The system information configuration module is used to configure and register access to various system information;
[0022] The interface information configuration module is used to configure and register interface information for use by the data sender;
[0023] The calling entry information configuration module is used to configure the calling entry information of the data receiver for pushing data and associating the access system information registered in the system information configuration module;
[0024] The forwarding rule establishment module is used to select the interface information configured in the interface information configuration module as the source, the call entry configured in the call entry information configuration module as the target, form a forwarding rule, and configure the mapping relationship between the interface and the entry;
[0025] The data interaction module is used for the data sender to access the interface configured in the interface information configuration module, find all rules with the interface information configured in the interface information configuration module as the source among the forwarding rules configured in all forwarding rule establishment modules, call the target call entry of each forwarding rule in parallel, and return it to the data sender based on the mapping relationship.
[0026] In the third aspect, the present invention also provides a data interaction device between multiple systems in an electricity trading market, including a memory and one or more processors, wherein the memory stores executable code, and when the processor executes the executable code, it implements the data interaction method between multiple systems in an electricity trading market.
[0027] In a fourth aspect, the present invention further provides a computer-readable storage medium having a program stored thereon, and when the program is executed by a processor, the method for data interaction between multiple systems in an electricity trading market is implemented.
[0028] In a fifth aspect, the present invention further provides a computer program product, including a computer program, which, when executed by a processor, implements the method for data interaction between multiple systems in an electricity trading market.
[0029] Beneficial effects of the present invention: The present invention completes the data forwarding work from the service caller (data sender) to all service providers (data receivers). Through the interface integration and standardization of the unified integration platform, the data forwarding work can be configured at a low cost, reducing the development, testing, and joint debugging costs of the service caller and service provider, ensuring the consistency and accuracy of the data, and providing unified access statistics. BRIEF DESCRIPTION OF THE DRAWINGS
[0030] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.
[0031] Figure 1 It is a data interaction architecture diagram between multiple systems in the power trading market;
[0032] Figure 2 It is a structural diagram of a data interaction device between multiple systems in an electricity trading market provided by the present invention. DETAILED DESCRIPTION
[0033] In order to make the purpose, technical solution and advantages of the present invention more clearly understood, the present invention is further described below in conjunction with the accompanying drawings and implementation examples. It should be understood that the specific implementation examples described herein are only used to explain the present invention and are not used to limit the present invention.
[0034] The present invention proposes a data interaction method among multiple systems in an electric power trading market. Figure 1 The data interaction architecture diagram between multiple systems in the power trading market. The embodiment of the present invention realizes the unified access and mesh forwarding interaction of each system by building a unified integrated platform, integrating and standardizing interfaces and forwarding mapping rules through configurable means. This embodiment takes the household number data interaction process between multiple systems in the power trading market as an example, and specifically explains the process of the marketing system pushing household number data to the retail system and settlement system via the unified integrated platform. It can be implemented according to the following steps:
[0035] (1) Configure the access system information on the unified integration platform as shown in Table 1, and randomly generate access credential information for each system:
[0036] Table 1
[0037]
[0038] (2) Configure the account number data interface information for marketing system push. The interface address is / push / company_info, the interface communication protocol is HTTPS, the input parameter data format is json, and the interface call timeout is 10 seconds. The interface input parameter data field description is shown in Table 2:
[0039] Table 2
[0040]
[0041]
[0042] The interface return value data field description is shown in Table 3:
[0043] Table 3
[0044] Field Name Field Type Field Description code Numeric Response code, 0: Success msg String Response description text
[0045] (3) Configure the call entry information of the retail system and the settlement system as the data receiver. The call entry address of the retail system is / receive / company_info, the call entry communication protocol is HTTPS, the call entry data format is json, the call entry call timeout is 5 seconds, and the call entry is associated with the retail system configured in step (1). The call entry input parameter data field description is shown in Table 4:
[0046] Table 4
[0047]
[0048]
[0049] The description of the call entry return value data field is shown in Table 5:
[0050] Table 5
[0051] Field Name Field Type Field Description code Numeric Response code, 0: Success msg String Response description text
[0052] The call entry address of the settlement system is / receive / company_info, the call entry communication protocol is Webservice, the call entry data format is xml, the call entry timeout is 10 seconds, and the call entry is associated with the settlement system configured in step (1). The call entry input parameter data field description is shown in Table 6:
[0053] Table 6
[0054] Field Name Field Type Field Description retail_company_id Numeric Enterprise ID company_no String Enterprise Number user_number String Account Number voltage String Voltage level elec_category String Electricity usage category settlement_flag Numeric Settlement Tag1: Yes0: No status Numeric Account number status 0: invalid 1: valid dissociate_flag Numeric Free account number 0: No 1: Yes create_time Date and Time Creation time file_update_time Date and Time File update time load_flag Numeric Flexible peak avoidance flag 0: No 1: Yes
[0055] The description of the call entry return value data field is shown in Table 7:
[0056] Table 7
[0057]
[0058]
[0059] (4) Create a new data forwarding rule 1, from the marketing system to the retail system. The source is the / push / company_info interface configured in step (2), and the target is the / receive / company_info interface associated with the retail system in step (3). The input parameter field mapping rule is to map by field name, and the return value field mapping rule is to map by field name.
[0060] Create a new data forwarding rule 2, from the marketing system to the settlement system. The source is the / push / company_info interface configured in step (2), and the target is the / receive / company_info interface associated with the settlement system in step (3). The input parameter field mapping rule is to map by field name, and the return value field mapping rule is to map by field name.
[0061] (5.1) The marketing system accesses the / push / company_info interface registered on the unified integration platform and sends the data shown in Table 8 in JSON format:
[0062] Table 8
[0063] Field Name Field Type Field Value retail_company_id Numeric 1001 company_no String A1001 user_number String P1001 unified_social_credit_code String S1234567 user_name String XX Co., Ltd. city_burean String XX City country_burean String XX County address String XXXX voltage String 220 elec_category String Commercial electricity settlement_flag Numeric 1 status Numeric 1 dissociate_flag Numeric 0 create_time Date and Time 2021-01-01 file_update_time Date and Time 2024-01-03 load_flag Numeric 1
[0064] (5.2) The unified integration platform finds forwarding rule 1 configured in step (4) and sends the data shown in Table 9 to the / receive / company_info interface of the retail system in JSON format. The data mapping method follows the configuration of forwarding rule 1:
[0065] Table 9
[0066] Field Name Field Type Field Value retail_company_id Numeric 1001 company_no String A1001 user_number String P1001 unified_social_credit_code String S1234567 user_name String XX Co., Ltd. city_burean String XX City country_burean String XX County address String XXXX voltage String 220 elec_category String Commercial electricity status Numeric 1 dissociate_flag Numeric 0 create_time Date and Time 2021-01-01 file_update_time Date and Time 2024-01-03
[0067] (5.3) The unified integration platform finds forwarding rule 2 configured in step (4) and sends the data shown in Table 10 to the settlement system / receive / company_info interface in XML format. The data mapping method follows the configuration of forwarding rule 2:
[0068] Table 10
[0069] Field Name Field Type Field Value retail_company_id Numeric 1001 company_no String A1001 user_number String P1001 voltage String 220 elec_category String Commercial electricity settlement_flag Numeric 1 status Numeric 1 dissociate_flag Numeric 0 create_time Date and Time 2021-01-01 file_update_time Date and Time 2024-01-03 load_flag Numeric 1
[0070] (5.4) The retail system and the settlement system return data to the unified integration platform respectively. The results are shown in Table 11:
[0071] Table 11
[0072] Field Name Retail system return value Settlement system return value code 0 0 msg success success
[0073] (5.5) The unified integration platform aggregates and maps the return values of each data recipient according to the access system identifier and sends them to the marketing system in JSON format. The results are as follows:
[0074]
[0075] After the above five steps, data interaction between multiple systems in the power trading market can be realized at low cost. The data sender and the data receiver are connected to the unified integration platform through configuration. To add new data reception subscriptions, only the system access and forwarding rules need to be configured, which ensures the consistency of data among systems and reduces the cost of data interaction.
[0076] Corresponding to the embodiment of the data interaction method between multiple systems in the power trading market, the present invention also provides an embodiment of a unified integrated platform for data interaction between multiple systems in the power trading market. The unified integrated platform includes a system information configuration module, an interface information configuration module, a call entry information configuration module, a forwarding rule establishment module and a data interaction module; the specific implementation process of each module can refer to the specific steps of the above data interaction method embodiment.
[0077] The system information configuration module is used to configure and register access to various system information;
[0078] The interface information configuration module is used to configure and register interface information for use by the data sender;
[0079] The calling entry information configuration module is used to configure the calling entry information of the data receiver for pushing data and associating the access system information registered in the system information configuration module;
[0080] The forwarding rule establishment module is used to select the interface information configured in the interface information configuration module as the source, the call entry configured in the call entry information configuration module as the target, form a forwarding rule, and configure the mapping relationship between the interface and the entry;
[0081] The data interaction module is used for the data sender to access the interface configured in the interface information configuration module, find all rules with the interface information configured in the interface information configuration module as the source among the forwarding rules configured in all forwarding rule establishment modules, call the target call entry of each forwarding rule in parallel, and return it to the data sender based on the mapping relationship.
[0082] Corresponding to the aforementioned embodiment of a method for data interaction between multiple systems in an electricity trading market, the present invention also provides an embodiment of a device for data interaction between multiple systems in an electricity trading market.
[0083] See also Figure 2 An embodiment of the present invention provides a data interaction device between multiple systems in an electricity trading market, including a memory and one or more processors, wherein the memory stores executable code, and when the processor executes the executable code, it is used to implement a data interaction method between multiple systems in an electricity trading market in the above embodiment.
[0084] An embodiment of a data interaction device between multiple systems in an electricity trading market provided by the present invention can be applied to any device with data processing capabilities, and the device with data processing capabilities can be a device or apparatus such as a computer. The device embodiment can be implemented through software, or through hardware or a combination of software and hardware. Taking software implementation as an example, as a device in a logical sense, it is formed by the processor of any device with data processing capabilities in which it is located reading the corresponding computer program instructions in the non-volatile memory into the internal memory for execution. From a hardware perspective, if Figure 2 As shown, it is a hardware structure diagram of a data interaction device between multiple systems in a power trading market provided by the present invention, in which any device with data processing capability is located, except Figure 2In addition to the processor, memory, network interface, and non-volatile memory shown, any device with data processing capabilities in which the apparatus in the embodiments is located may also include other hardware, generally based on the actual functions of the device with data processing capabilities, which will not be described in detail.
[0085] The implementation process of the functions and effects of each unit in the above-mentioned device is specifically described in the implementation process of the corresponding steps in the above-mentioned method, and will not be repeated here.
[0086] For the device embodiment, since it basically corresponds to the method embodiment, the relevant parts can refer to the partial description of the method embodiment. The device embodiment described above is only schematic, wherein the units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the scheme of the present invention. Ordinary technicians in this field can understand and implement it without paying creative work.
[0087] An embodiment of the present invention further provides a computer-readable storage medium having a program stored thereon. When the program is executed by a processor, a method for data interaction between multiple systems in a power trading market in the above embodiment is implemented.
[0088] The computer-readable storage medium may be an internal storage unit of any device with data processing capability described in any of the aforementioned embodiments, such as a hard disk or a memory. The computer-readable storage medium may also be an external storage device of any device with data processing capability, such as a plug-in hard disk, a smart media card (SMC), an SD card, a flash card, etc. equipped on the device. Furthermore, the computer-readable storage medium may also include both an internal storage unit and an external storage device of any device with data processing capability. The computer-readable storage medium is used to store the computer program and other programs and data required by any device with data processing capability, and may also be used to temporarily store data that has been output or is to be output.
[0089] The present invention also provides a computer program product, including a computer program, and when the computer program is executed by a processor, it implements the data interaction method between multiple systems in an electricity trading market.
[0090] The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the protection scope of the present invention.
Claims
1. A data interaction method between multiple systems in an electricity trading market, characterized in that: The method comprises the following steps: (1) Configure and register access to various system information; (2) Configure and register interface information for use by the data sender; (3) configuring the data receiver to call the entry information for pushing data and associating it with the access system information registered in step (1); (4) Select the interface information configured in step (2) as the source and the call entry configured in step (3) as the target, form a forwarding rule, and configure the mapping relationship between the interface and the entry; (5) The data sender accesses the interface configured in step (2), finds all rules with the interface information configured in step (2) as the source in all forwarding rules configured in step (4), calls the target call entry of each forwarding rule in parallel, and returns the results to the data sender based on the mapping relationship.
2. A data interaction method among multiple systems in a power trading market according to claim 1, characterized in that: In step (1), the access system information includes the access system name, access system identifier, access system location, access system type, access system IP source whitelist, and generates credential information for the access system access interface.
3. A data interaction method among multiple systems in a power trading market according to claim 1, characterized in that: In step (2), the interface information includes the interface address, interface communication protocol, interface input parameter data format, interface input parameter data field description, interface return value data format, interface return value data field description and interface call timeout.
4. A data interaction method among multiple systems in a power trading market according to claim 1, characterized in that: In step (3), the call entry information includes the call entry address, the call entry communication protocol, the call entry input parameter data format, the call entry input parameter data field description, the call entry return value data format, the call entry return value data field description and the call entry call timeout period.
5. The data interaction method among multiple systems in a power trading market according to claim 1 is characterized in that: In step (4), the mapping relationship between the configuration interface and the entry is specifically: the mapping relationship between the fields of the configuration interface input parameters to the fields of the call entry input parameters, and the mapping relationship between the fields of the call entry return value to the fields of the interface return value.
6. A data interaction method among multiple systems in a power trading market according to claim 1, characterized in that: In step (5), the specific process of returning to the service caller based on the mapping relationship is: converting data and return values according to the mapping relationship, organizing the return value of each call into a complete return value according to the mapping from the access system identifier to the return value, and returning it to the service caller.
7. A unified integrated platform for data interaction among multiple systems in the power trading market, characterized in that: The unified integration platform includes a system information configuration module, an interface information configuration module, a call entry information configuration module, a forwarding rule establishment module and a data interaction module; The system information configuration module is used to configure and register access to various system information; The interface information configuration module is used to configure and register interface information for use by the data sender; The calling entry information configuration module is used to configure the calling entry information of the data receiver for pushing data and associating the access system information registered in the system information configuration module; The forwarding rule establishment module is used to select the interface information configured in the interface information configuration module as the source, the call entry configured in the call entry information configuration module as the target, form a forwarding rule, and configure the mapping relationship between the interface and the entry; The data interaction module is used for the data sender to access the interface configured in the interface information configuration module, find all rules with the interface information configured in the interface information configuration module as the source among the forwarding rules configured in all forwarding rule establishment modules, call the target call entry of each forwarding rule in parallel, and return it to the data sender based on the mapping relationship.
8. A data interaction device between multiple systems in an electricity trading market, comprising a memory and one or more processors, wherein the memory stores executable code, characterized in that: When the processor executes the executable code, a data interaction method between multiple systems in a power trading market according to any one of claims 1-6 is implemented.
9. A computer-readable storage medium having a program stored thereon, characterized in that: When the program is executed by the processor, a method for data interaction between multiple systems in an electricity trading market as described in any one of claims 1-6 is implemented.
10. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, a method for data interaction between multiple systems in a power trading market as described in any one of claims 1 to 6 is implemented.
