Database association and real-time computing fusion method and device applied to ERPOA system

Abstract

The present invention relates to a method and device for integrating database association and real-time computing applied to an ERPOA system, belonging to the technical field of data exchange networks, obtaining real-time database authority information and real-time database plug-in information, designing ERPOA according to the real-time database authority information and real-time database plug-in information, and generating an ERPOA design table; identifying information from the ERPOA design table to automatically design a dashboard to obtain ERPOA configuration information, and generating an ERPOA center IP-ERPOA configuration table; encapsulating the ERPOA center IP-ERPOA configuration table to obtain an ERPOA configuration file and sending it to the ERPOA center; obtaining new database plug-in information and new database authority information, and verifying and updating the ERPOA configuration information. The present invention designs and uses network ERPOA resources together with service resources, dynamically calculates the ERPOA design distribution, and visually designs the ERPOA configuration of the entire network based on the real needs of the open ERPOA of the database and service resources, ensuring the timeliness, accuracy and efficient visual operation and maintenance of the open ERPOA.

Description

Technical Field

[0001] The present invention belongs to the technical field of data exchange network, and in particular to a method and device for integrating database association and real-time calculation applied to an ERPOA system. Background Art

[0002] Currently, the performance management function of the network management system can realize real-time monitoring of the performance data reported by the device. The performance data reported by the device side is directly displayed to the user, or the performance data reported by the device is logically calculated and the calculation result value is displayed to the user, so that the user can clearly observe the operation status of each device. The topology management function of the network management system supports the physical management of the device, as well as obtaining device attribute information and displaying it to the user.

[0003] The topology interface of the existing network management system only focuses on the physical connection between devices and the properties of the devices themselves, and does not focus on performance data information. When the performance data of the device needs to be known, it can only be achieved through performance monitoring. Topology management and performance management are independent of each other, and there is no connection between the functions of the two. Users cannot directly obtain the performance data of the device through the topology map, which brings great inconvenience to user operations. However, in the huge ERPOA center resource system of CDN, if the ERPOA reuse configuration is not reasonably designed, it will lead to a large amount of manual maintenance and difficulty in ERPOA maintenance. Ultimately, it will lead to a poor experience and a decline in business quality when using database security products, which may cause user loss. Summary of the invention

[0004] In view of the above deficiencies in the prior art, the purpose of the invention is to provide a method and device for integrating database association and real-time computing applied to the ERPOA system, which transforms the network ERPOA into resources, designs and uses them together with service resources, dynamically calculates the ERPOA design distribution, and then visually designs the ERPOA configuration of the entire network based on the actual needs of the database's open ERPOA and service resources, to ensure that the ERPOA open to the outside world is timely and accurate, and has efficient visual operation and maintenance.

[0005] The first aspect of the present invention provides a method for integrating database association and real-time computing applied to an ERPOA system, comprising:

[0006] S1, obtaining real-time database authority information and real-time database plug-in information, designing ERPOA according to the real-time database authority information and real-time database plug-in information, and generating an ERPOA design table;

[0007] S2, identifying ERPOA information, ERPOA center IP information and MAC address information from the ERPOA design table, automatically designing the dashboard to obtain ERPOA configuration information, and generating an ERPOA center IP-ERPOA configuration table;

[0008] S3, encapsulating the ERPOA center IP-ERPOA configuration table to obtain an ERPOA configuration file, and sending the ERPOA configuration file to the ERPOA center;

[0009] S4, obtaining the newly added database plug-in information and the newly added database permission information, and verifying and updating the ERPOA configuration information according to the newly added database plug-in information and the newly added database permission information.

[0010] Furthermore, the step of acquiring the real-time database permission information and the real-time database plug-in information in S1 further includes:

[0011] The real-time database authority information at least includes:

[0012] Are the database name, database domain name, database STRUTSERPOA, and database SPRINGERPOA all 0?

[0013] The real-time database plug-in information at least includes:

[0014] ERPOA center host group information, MAC address resource information, ERPOA center information;

[0015] The ERPOA center host group information includes the ERPOA center group name and the corresponding ERPOA center host group code;

[0016] The MAC address resource information includes the MAC address information and the corresponding ERPOA center host group code and resource ERPOA tag;

[0017] The ERPOA center information includes the ERPOA center IP information and the corresponding ERPOA center host group code;

[0018] ERPOA centers in the same ERPOA center host group share the same set of MAC address data;

[0019] The S1 designs ERPOA according to the real-time database authority information and the real-time database plug-in information to generate an ERPOA design table, and also includes:

[0020] Design and configure the resource tag information table and the MAC address resource information table for ERPOA according to the real-time database permission information and the real-time database plug-in information;

[0021] The configuration resource tag information table includes tag names and corresponding allocated STRUTSERPOA and SPRINGERPOA;

[0022] The configured MAC address resource information table includes MAC address information and the corresponding ERPOA center host group code and allocated ERPOA label.

[0023] Furthermore, the S2 identifies ERPOA information, ERPOA center IP information and MAC address information from the ERPOA design table, obtains ERPOA configuration information by automatic dashboard design, and generates an ERPOA center IP-ERPOA configuration table, and also includes:

[0024] Obtain an ERPOA label corresponding to the MAC address information according to the ERPOA center host group code corresponding to the ERPOA center IP information;

[0025] According to the ERPOA tag, the configuration resource tag information table is matched to obtain STRUTSERPOA and SPRINGERPOA of the ERPOA center IP information;

[0026] The MAC address information of the ERPOA center IP information is designed by the dashboard together with STRUTSERPOA and SPRINGERPOA to obtain the ERPOA configuration information of the ERPOA center IP information, and the format is converted to generate the ERPOA center IP-ERPOA configuration table.

[0027] Furthermore, the S3 encapsulates the ERPOA center IP-ERPOA configuration table to obtain an ERPOA configuration file, and sends the ERPOA configuration file to the ERPOA center, further comprising:

[0028] The cloud platform service encapsulates the ERPOA center IP-ERPOA configuration table, obtains the ERPOA configuration file and loads it;

[0029] The ERPOA configuration file is sent to the corresponding ERPOA center, and the sending result is recorded, the sending result is counted, and the final sending data is notified to the relevant person in charge.

[0030] Furthermore, the newly added database plug-in information and the newly added database permission information are obtained in S4, and the ERPOA configuration information is verified and updated according to the newly added database plug-in information and the newly added database permission information, and further includes:

[0031] Perform ERPOA configuration on the newly added ERPOA center IP information of the newly added database plug-in information according to the real-time generated ERPOA center IP-ERPOA configuration table, obtain the newly added ERPOA configuration file of the newly added database plug-in information and send it to the newly added ERPOA center;

[0032] Get the database name, database domain name, database STRUTSERPOA, and database SPRINGERPOA of the newly added database permission information;

[0033] Determine whether the database STRUTSERPOA and the database SPRINGERPOA of the newly added database authority information have been occupied by the real-time database authority information. If they have been occupied, external services are not allowed to be provided, and the newly added database can be directly notified to make adjustments;

[0034] If it is not occupied, check the database STRUTSERPOA and the database SPRINGERPOA that allocate the newly added database permission information, and update the design configuration resource label information table and the configuration MAC address resource information table.

[0035] According to the second aspect of the present invention, the present invention claims protection for a database association and real-time computing fusion device applied to an ERPOA system, comprising: a database authority information module, a database plug-in information module, a service resource and ERPOA design module, an automatic generation ERPOA configuration module, an automatic distribution ERPOA configuration module, and an ERPOA center;

[0036] The database authority information module obtains real-time database authority information and newly added database authority information;

[0037] The database plug-in information module obtains real-time database plug-in information and newly added database plug-in information;

[0038] The service resource and ERPOA design module designs ERPOA according to the real-time database permission information and the real-time database plug-in information to generate an ERPOA design table;

[0039] The automatic generation of ERPOA configuration module identifies ERPOA information, ERPOA center IP information and MAC address information from the ERPOA design table, obtains ERPOA configuration information by automatic kanban design, and generates an ERPOA center IP-ERPOA configuration table;

[0040] The automatically generated ERPOA configuration module verifies and updates the ERPOA configuration information according to the newly added database permission information of the newly added database plug-in information;

[0041] The automatic ERPOA configuration sending module encapsulates the ERPOA center IP-ERPOA configuration table, obtains the ERPOA configuration file and sends the ERPOA configuration file to the ERPOA center.

[0042] Furthermore, the device also includes:

[0043] The real-time database authority information at least includes:

[0044] Are the database name, database domain name, database STRUTSERPOA, and database SPRINGERPOA all 0?

[0045] The real-time database plug-in information at least includes:

[0046] ERPOA center host group information, MAC address resource information, ERPOA center information;

[0047] The ERPOA center host group information includes the ERPOA center group name and the corresponding ERPOA center host group code;

[0048] The MAC address resource information includes the MAC address information and the corresponding ERPOA center host group code and resource ERPOA tag;

[0049] The ERPOA center information includes the ERPOA center IP information and the corresponding ERPOA center host group code;

[0050] ERPOA centers in the same ERPOA center host group share the same set of MAC address data;

[0051] The service resource and ERPOA design module designs ERPOA according to the real-time database authority information and the real-time database plug-in information to generate an ERPOA design table, and also includes:

[0052] Design and configure the resource tag information table and the MAC address resource information table for ERPOA according to the real-time database permission information and the real-time database plug-in information;

[0053] The configuration resource tag information table includes tag names and corresponding allocated STRUTSERPOA and SPRINGERPOA;

[0054] The configured MAC address resource information table includes MAC address information and the corresponding ERPOA center host group code and allocated ERPOA label.

[0055] Furthermore, the automatic generation of ERPOA configuration module identifies ERPOA information, ERPOA center IP information and MAC address information from the ERPOA design table, automatically obtains ERPOA configuration information through kanban design, and generates an ERPOA center IP-ERPOA configuration table, and further includes:

[0056] Obtain an ERPOA label corresponding to the MAC address information according to the ERPOA center host group code corresponding to the ERPOA center IP information;

[0057] According to the ERPOA tag, the configuration resource tag information table is matched to obtain STRUTSERPOA and SPRINGERPOA of the ERPOA center IP information;

[0058] The MAC address information of the ERPOA center IP information is designed by the dashboard together with STRUTSERPOA and SPRINGERPOA to obtain the ERPOA configuration information of the ERPOA center IP information, and the format is converted to generate the ERPOA center IP-ERPOA configuration table.

[0059] Furthermore, the automatic ERPOA configuration module encapsulates the ERPOA center IP-ERPOA configuration table to obtain an ERPOA configuration file and sends the ERPOA configuration file to the ERPOA center, and further includes:

[0060] The cloud platform service encapsulates the ERPOA center IP-ERPOA configuration table, obtains the ERPOA configuration file and loads it;

[0061] The ERPOA configuration file is sent to the corresponding ERPOA center, and the sending result is recorded, the sending result is counted, and the final sending data is notified to the relevant person in charge.

[0062] Furthermore, the automatically generated ERPOA configuration module verifies and updates the ERPOA configuration information according to the newly added database plug-in information and the newly added database permission information, and also includes:

[0063] Perform ERPOA configuration on the newly added ERPOA center IP information of the newly added database plug-in information according to the real-time generated ERPOA center IP-ERPOA configuration table, obtain the newly added ERPOA configuration file of the newly added database plug-in information and send it to the newly added ERPOA center;

[0064] Get the database name, database domain name, database STRUTSERPOA, and database SPRINGERPOA of the newly added database permission information;

[0065] Determine whether the database STRUTSERPOA and the database SPRINGERPOA of the newly added database authority information have been occupied by the real-time database authority information. If they have been occupied, external services are not allowed to be provided, and the newly added database can be directly notified to make adjustments;

[0066] If it is not occupied, check the database STRUTSERPOA and the database SPRINGERPOA that allocate the newly added database permission information, and update the design configuration resource label information table and the configuration MAC address resource information table.

[0067] The beneficial effects of the present invention are as follows:

[0068] The method and device described in the present invention transform the network ERPOA into resources, design and use them together with service resources, dynamically calculate the ERPOA design distribution, and then visually design the ERPOA configuration of the entire network based on the actual needs of the open ERPOA of the database and service resources, to ensure timely and accurate opening of the ERPOA to the outside world, as well as efficient visual operation and maintenance. BRIEF DESCRIPTION OF THE DRAWINGS

[0069] The accompanying drawings are only used to illustrate specific embodiments and are not considered to limit the present invention. In the entire drawings, the same reference symbols represent the same components. Obviously, the drawings described below are only some embodiments recorded in the embodiments of the present invention. For those of ordinary skill in the art, other drawings can also be obtained based on these drawings.

[0070] Figure 1 A flowchart of a method for integrating database association and real-time computing applied to an ERPOA system according to an embodiment of the present invention;

[0071] Figure 2 This is a data flow diagram of a database association and real-time computing fusion device applied to an ERPOA system in an embodiment of the present invention. DETAILED DESCRIPTION

[0072] The first embodiment of the present invention proposes a database association and real-time computing fusion method applied to the ERPOA system, referring to Figure 1 ,include:

[0073] S1, obtaining real-time database authority information and real-time database plug-in information, designing ERPOA according to the real-time database authority information and real-time database plug-in information, and generating an ERPOA design table;

[0074] S2, identifying ERPOA information, ERPOA center IP information and MAC address information from the ERPOA design table, automatically designing the dashboard to obtain ERPOA configuration information, and generating an ERPOA center IP-ERPOA configuration table;

[0075] S3, encapsulating the ERPOA center IP-ERPOA configuration table to obtain an ERPOA configuration file, and sending the ERPOA configuration file to the ERPOA center;

[0076] S4, obtaining the newly added database plug-in information and the newly added database permission information, and verifying and updating the ERPOA configuration information according to the newly added database plug-in information and the newly added database permission information.

[0077] Furthermore, the step of acquiring the real-time database permission information and the real-time database plug-in information in S1 further includes:

[0078] The real-time database authority information at least includes:

[0079] Are the database name, database domain name, database STRUTSERPOA, and database SPRINGERPOA all 0?

[0080] The struts and spring in STRUTSERPOA and SPRINGERPOA are java web development tools, indicating that the ERPOA systems adopt the corresponding frameworks respectively;

[0081] The real-time database plug-in information at least includes:

[0082] ERPOA center host group information, MAC address resource information, ERPOA center information;

[0083] The ERPOA center host group information includes the ERPOA center group name and the corresponding ERPOA center host group code;

[0084] The MAC address resource information includes the MAC address information and the corresponding ERPOA center host group code and resource ERPOA tag;

[0085] The ERPOA center information includes the ERPOA center IP information and the corresponding ERPOA center host group code;

[0086] ERPOA centers in the same ERPOA center host group share the same set of MAC address data;

[0087] The S1 designs ERPOA according to the real-time database authority information and the real-time database plug-in information to generate an ERPOA design table, and also includes:

[0088] Design and configure the resource tag information table and the MAC address resource information table for ERPOA according to the real-time database permission information and the real-time database plug-in information;

[0089] The configuration resource tag information table includes tag names and corresponding allocated STRUTSERPOA and SPRINGERPOA;

[0090] The configured MAC address resource information table includes MAC address information and the corresponding ERPOA center host group code and allocated ERPOA label.

[0091] Furthermore, the S2 identifies ERPOA information, ERPOA center IP information and MAC address information from the ERPOA design table, obtains ERPOA configuration information by automatic dashboard design, and generates an ERPOA center IP-ERPOA configuration table, and also includes:

[0092] Obtain an ERPOA label corresponding to the MAC address information according to the ERPOA center host group code corresponding to the ERPOA center IP information;

[0093] According to the ERPOA tag, the configuration resource tag information table is matched to obtain STRUTSERPOA and SPRINGERPOA of the ERPOA center IP information;

[0094] The MAC address information of the ERPOA center IP information is designed by the dashboard together with STRUTSERPOA and SPRINGERPOA to obtain the ERPOA configuration information of the ERPOA center IP information, and the format is converted to generate the ERPOA center IP-ERPOA configuration table.

[0095] Among them, in this embodiment:

[0096] Service resources and ERPOA design:

[0097] ERPOA resource design needs to meet the following conditions:

[0098] The same ERPOA allows different IP addresses to be bound;

[0099] For the same ERPOA, the monitoring priority of all 0 ERPOA is the highest;

[0100] The same ERPOA and the same MAC address can only be bound to one protocol;

[0101] Furthermore, the S3 encapsulates the ERPOA center IP-ERPOA configuration table to obtain an ERPOA configuration file, and sends the ERPOA configuration file to the ERPOA center, further comprising:

[0102] The cloud platform service encapsulates the ERPOA center IP-ERPOA configuration table, obtains the ERPOA configuration file and loads it;

[0103] The ERPOA configuration file is sent to the corresponding ERPOA center, and the sending result is recorded, the sending result is counted, and the final sending data is notified to the relevant person in charge.

[0104] Furthermore, the newly added database plug-in information and the newly added database permission information are obtained in S4, and the ERPOA configuration information is verified and updated according to the newly added database plug-in information and the newly added database permission information, and further includes:

[0105] Perform ERPOA configuration on the newly added ERPOA center IP information of the newly added database plug-in information according to the real-time generated ERPOA center IP-ERPOA configuration table, obtain the newly added ERPOA configuration file of the newly added database plug-in information and send it to the newly added ERPOA center;

[0106] Get the database name, database domain name, database STRUTSERPOA, and database SPRINGERPOA of the newly added database permission information;

[0107] Determine whether the database STRUTSERPOA and the database SPRINGERPOA of the newly added database authority information have been occupied by the real-time database authority information. If they have been occupied, external services are not allowed to be provided, and the newly added database can be directly notified to make adjustments;

[0108] If it is not occupied, check the database STRUTSERPOA and the database SPRINGERPOA that allocate the newly added database permission information, and update the design configuration resource label information table and the configuration MAC address resource information table.

[0109] According to the second embodiment of the present invention, the present invention claims a database association and real-time computing fusion device applied to the ERPOA system, referring to Figure 2 , including: database permission information module, database plug-in information module, service resource and ERPOA design module, automatic generation of ERPOA configuration module, automatic distribution of ERPOA configuration module, ERPOA center;

[0110] The database authority information module obtains real-time database authority information and newly added database authority information;

[0111] The database plug-in information module obtains real-time database plug-in information and newly added database plug-in information;

[0112] The service resource and ERPOA design module designs ERPOA according to the real-time database permission information and the real-time database plug-in information to generate an ERPOA design table;

[0113] The automatic generation of ERPOA configuration module identifies ERPOA information, ERPOA center IP information and MAC address information from the ERPOA design table, obtains ERPOA configuration information by automatic kanban design, and generates an ERPOA center IP-ERPOA configuration table;

[0114] The automatically generated ERPOA configuration module verifies and updates the ERPOA configuration information according to the newly added database permission information of the newly added database plug-in information;

[0115] The automatic ERPOA configuration sending module encapsulates the ERPOA center IP-ERPOA configuration table, obtains the ERPOA configuration file and sends the ERPOA configuration file to the ERPOA center.

[0116] Furthermore, the device also includes:

[0117] The real-time database authority information at least includes:

[0118] Are the database name, database domain name, database STRUTSERPOA, and database SPRINGERPOA all 0?

[0119] The real-time database plug-in information at least includes:

[0120] ERPOA center host group information, MAC address resource information, ERPOA center information;

[0121] The ERPOA center host group information includes the ERPOA center group name and the corresponding ERPOA center host group code;

[0122] The MAC address resource information includes the MAC address information and the corresponding ERPOA center host group code and resource ERPOA tag;

[0123] The ERPOA center information includes the ERPOA center IP information and the corresponding ERPOA center host group code;

[0124] ERPOA centers in the same ERPOA center host group share the same set of MAC address data;

[0125] The service resource and ERPOA design module designs ERPOA according to the real-time database authority information and the real-time database plug-in information to generate an ERPOA design table, and also includes:

[0126] Design and configure the resource tag information table and the MAC address resource information table for ERPOA according to the real-time database permission information and the real-time database plug-in information;

[0127] The configuration resource tag information table includes tag names and corresponding allocated STRUTSERPOA and SPRINGERPOA;

[0128] The configured MAC address resource information table includes MAC address information and the corresponding ERPOA center host group code and allocated ERPOA label.

[0129] Furthermore, the automatic generation of ERPOA configuration module identifies ERPOA information, ERPOA center IP information and MAC address information from the ERPOA design table, automatically obtains ERPOA configuration information through kanban design, and generates an ERPOA center IP-ERPOA configuration table, and further includes:

[0130] Obtain an ERPOA label corresponding to the MAC address information according to the ERPOA center host group code corresponding to the ERPOA center IP information;

[0131] According to the ERPOA tag, the configuration resource tag information table is matched to obtain STRUTSERPOA and SPRINGERPOA of the ERPOA center IP information;

[0132] The MAC address information of the ERPOA center IP information is designed by the dashboard together with STRUTSERPOA and SPRINGERPOA to obtain the ERPOA configuration information of the ERPOA center IP information, and the format is converted to generate the ERPOA center IP-ERPOA configuration table.

[0133] Furthermore, the automatic ERPOA configuration module encapsulates the ERPOA center IP-ERPOA configuration table to obtain an ERPOA configuration file and sends the ERPOA configuration file to the ERPOA center, and further includes:

[0134] The cloud platform service encapsulates the ERPOA center IP-ERPOA configuration table, obtains the ERPOA configuration file and loads it;

[0135] The ERPOA configuration file is sent to the corresponding ERPOA center, and the sending result is recorded, the sending result is counted, and the final sending data is notified to the relevant person in charge.

[0136] Furthermore, the automatically generated ERPOA configuration module verifies and updates the ERPOA configuration information according to the newly added database plug-in information and the newly added database permission information, and also includes:

[0137] Perform ERPOA configuration on the newly added ERPOA center IP information of the newly added database plug-in information according to the real-time generated ERPOA center IP-ERPOA configuration table, obtain the newly added ERPOA configuration file of the newly added database plug-in information and send it to the newly added ERPOA center;

[0138] Get the database name, database domain name, database STRUTSERPOA, and database SPRINGERPOA of the newly added database permission information;

[0139] Determine whether the database STRUTSERPOA and the database SPRINGERPOA of the newly added database authority information have been occupied by the real-time database authority information. If they have been occupied, external services are not allowed to be provided, and the newly added database can be directly notified to make adjustments;

[0140] If it is not occupied, check the database STRUTSERPOA and the database SPRINGERPOA that allocate the newly added database permission information, and update the design configuration resource label information table and the configuration MAC address resource information table.

[0141] The applicant of the present invention has made a detailed explanation and description of the implementation examples of the present invention in conjunction with the drawings in the specification. However, those skilled in the art should understand that the above implementation examples are only preferred implementation schemes of the present invention, and the detailed description is only to help readers better understand the spirit of the present invention, but not to limit the scope of protection of the present invention. On the contrary, any improvements or modifications based on the inventive spirit of the present invention should fall within the scope of protection of the present invention.

Claims

1. A database association and real-time computing fusion method applied to ERPOA system, characterized in that: include: S1, obtaining real-time database authority information and real-time database plug-in information, designing ERPOA according to the real-time database authority information and real-time database plug-in information, and generating an ERPOA design table; S2, identifying ERPOA information, ERPOA center IP information and MAC address information from the ERPOA design table, automatically designing the dashboard to obtain ERPOA configuration information, and generating an ERPOA center IP-ERPOA configuration table; S3, encapsulating the ERPOA center IP-ERPOA configuration table to obtain an ERPOA configuration file, and sending the ERPOA configuration file to the ERPOA center; S4, obtaining the newly added database plug-in information and the newly added database permission information, and verifying and updating the ERPOA configuration information according to the newly added database plug-in information and the newly added database permission information; The acquisition of real-time database permission information and real-time database plug-in information in S1 also includes: The real-time database authority information at least includes the database name, database domain name, database STRUTSERPOA, database SPRINGERPOA, and whether all are 0 of the real-time database; The struts and spring in STRUTSERPOA and SPRINGERPOA are java web development tools, indicating that the ERPOA systems adopt the corresponding frameworks respectively; The real-time database plug-in information includes at least ERPOA center host group information, MAC address resource information, and ERPOA center information of real-time service resources; The ERPOA center host group information includes the ERPOA center host group name and the corresponding ERPOA center host group code; The MAC address resource information includes the MAC address information and the corresponding ERPOA center host group code and resource ERPOA tag; The ERPOA center information includes the ERPOA center IP information and the corresponding ERPOA center host group code; ERPOA centers in the same ERPOA center host group share the same set of MAC address data; The S1 designs ERPOA according to the real-time database authority information and the real-time database plug-in information to generate an ERPOA design table, and also includes: Design and configure the resource tag information table and the MAC address resource information table for ERPOA according to the real-time database permission information and the real-time database plug-in information; The configuration resource tag information table includes tag names and corresponding allocated STRUTSERPOA and SPRINGERPOA; The configuration MAC address resource information table includes MAC address information and the corresponding ERPOA center host group code and the allocated ERPOA label; The S2 identifies ERPOA information, ERPOA center IP information and MAC address information from the ERPOA design table, obtains ERPOA configuration information by automatic dashboard design, and generates an ERPOA center IP-ERPOA configuration table, and also includes: Obtain an ERPOA label corresponding to the MAC address information according to the ERPOA center host group code corresponding to the ERPOA center IP information; According to the ERPOA tag, the configuration resource tag information table is matched to obtain STRUTSERPOA and SPRINGERPOA of the ERPOA center IP information; The MAC address information of the ERPOA center IP information is designed by the dashboard together with STRUTSERPOA and SPRINGERPOA to obtain the ERPOA configuration information of the ERPOA center IP information, and the format is converted to generate the ERPOA center IP-ERPOA configuration table.

2. The method for integrating database association and real-time computing applied to ERPOA system according to claim 1, characterized in that: In the S3, the ERPOA center IP-ERPOA configuration table is encapsulated to obtain an ERPOA configuration file, and the ERPOA configuration file is sent to the ERPOA center, and further includes: The cloud platform service encapsulates the ERPOA center IP-ERPOA configuration table, obtains the ERPOA configuration file and loads it; The ERPOA configuration file is sent to the corresponding ERPOA center, and the sending result is recorded, the sending result is counted, and the final sending data is notified to the relevant person in charge.

3. The method for integrating database association and real-time computing applied to ERPOA system according to claim 2 is characterized in that: The step S4 acquires the newly added database plug-in information and the newly added database permission information, verifies and updates the ERPOA configuration information according to the newly added database plug-in information and the newly added database permission information, and further includes: Perform ERPOA configuration on the newly added ERPOA center IP information of the newly added database plug-in information according to the real-time generated ERPOA center IP-ERPOA configuration table, obtain the newly added ERPOA configuration file of the newly added database plug-in information and send it to the newly added ERPOA center; Get the database name, database domain name, database STRUTSERPOA, and database SPRINGERPOA of the newly added database permission information; Determine whether the database STRUTSERPOA and the database SPRINGERPOA of the newly added database authority information have been occupied by the real-time database authority information. If they have been occupied, external services are not allowed to be provided, and the newly added database can be directly notified to make adjustments; If it is not occupied, check the database STRUTSERPOA and the database SPRINGERPOA that allocate the newly added database permission information, and update the design configuration resource label information table and the configuration MAC address resource information table.

4. A database association and real-time computing fusion device applied to ERPOA system, characterized in that: include: Database permission information module, database plug-in information module, service resource and ERPOA design module, automatic generation of ERPOA configuration module, automatic distribution of ERPOA configuration module, ERPOA center; The database authority information module obtains real-time database authority information and newly added database authority information; The database plug-in information module obtains real-time database plug-in information and newly added database plug-in information; The service resource and ERPOA design module designs ERPOA according to the real-time database permission information and the real-time database plug-in information to generate an ERPOA design table; The automatic generation of ERPOA configuration module identifies ERPOA information, ERPOA center IP information and MAC address information from the ERPOA design table, obtains ERPOA configuration information by automatic kanban design, and generates an ERPOA center IP-ERPOA configuration table; The automatically generated ERPOA configuration module verifies and updates the ERPOA configuration information according to the newly added database plug-in information and the newly added database permission information; The automatic ERPOA configuration module encapsulates the ERPOA center IP-ERPOA configuration table to obtain an ERPOA configuration file and sends the ERPOA configuration file to the ERPOA center; The device also includes: The real-time database authority information at least includes the database name, database domain name, database STRUTSERPOA, database SPRINGERPOA, and whether all are 0 of the real-time database; The struts and spring in STRUTSERPOA and SPRINGERPOA are java web development tools, indicating that the ERPOA systems adopt the corresponding frameworks respectively; The real-time database plug-in information includes at least ERPOA center host group information, MAC address resource information, and ERPOA center information of real-time service resources; The ERPOA center host group information includes the ERPOA center host group name and the corresponding ERPOA center host group code; The MAC address resource information includes the MAC address information and the corresponding ERPOA center host group code and resource ERPOA tag; The ERPOA center information includes the ERPOA center IP information and the corresponding ERPOA center host group code; ERPOA centers in the same ERPOA center host group share the same set of MAC address data; The service resource and ERPOA design module designs ERPOA according to the real-time database authority information and the real-time database plug-in information to generate an ERPOA design table, and also includes: Design and configure the resource tag information table and the MAC address resource information table for ERPOA according to the real-time database permission information and the real-time database plug-in information; The configuration resource tag information table includes tag names and corresponding allocated STRUTSERPOA and SPRINGERPOA; The configuration MAC address resource information table includes MAC address information and the corresponding ERPOA center host group code and the allocated ERPOA label; The automatic generation of ERPOA configuration module identifies ERPOA information, ERPOA center IP information and MAC address information from the ERPOA design table, automatically obtains ERPOA configuration information by kanban design, and generates an ERPOA center IP-ERPOA configuration table, and also includes: Obtain an ERPOA label corresponding to the MAC address information according to the ERPOA center host group code corresponding to the ERPOA center IP information; According to the ERPOA tag, the configuration resource tag information table is matched to obtain STRUTSERPOA and SPRINGERPOA of the ERPOA center IP information; The MAC address information of the ERPOA center IP information is designed by the dashboard together with STRUTSERPOA and SPRINGERPOA to obtain the ERPOA configuration information of the ERPOA center IP information, and the format is converted to generate the ERPOA center IP-ERPOA configuration table.

5. The database association and real-time computing fusion device applied to the ERPOA system according to claim 4 is characterized in that: The automatic ERPOA configuration module encapsulates the ERPOA center IP-ERPOA configuration table to obtain an ERPOA configuration file and sends the ERPOA configuration file to the ERPOA center, and further includes: The cloud platform service encapsulates the ERPOA center IP-ERPOA configuration table, obtains the ERPOA configuration file and loads it; The ERPOA configuration file is sent to the corresponding ERPOA center, and the sending result is recorded, the sending result is counted, and the final sending data is notified to the relevant person in charge.

6. The database association and real-time computing fusion device applied to the ERPOA system according to claim 5, characterized in that: The automatic generation of the ERPOA configuration module verifies and updates the ERPOA configuration information according to the newly added database plug-in information and the newly added database permission information, and further includes: Perform ERPOA configuration on the newly added ERPOA center IP information of the newly added database plug-in information according to the real-time generated ERPOA center IP-ERPOA configuration table, obtain the newly added ERPOA configuration file of the newly added database plug-in information and send it to the newly added ERPOA center; Get the database name, database domain name, database STRUTSERPOA, and database SPRINGERPOA of the newly added database permission information; Determine whether the database STRUTSERPOA and the database SPRINGERPOA of the newly added database authority information have been occupied by the real-time database authority information. If they have been occupied, external services are not allowed to be provided, and the newly added database can be directly notified to make adjustments; If it is not occupied, check the database STRUTSERPOA and the database SPRINGERPOA that allocate the newly added database permission information, and update the design configuration resource label information table and the configuration MAC address resource information table.

Images