CN114490882B - Heterogeneous database data synchronization analysis method - Google Patents
Heterogeneous database data synchronization analysis method Download PDFInfo
- Publication number
- CN114490882B CN114490882B CN202210396566.5A CN202210396566A CN114490882B CN 114490882 B CN114490882 B CN 114490882B CN 202210396566 A CN202210396566 A CN 202210396566A CN 114490882 B CN114490882 B CN 114490882B
- Authority
- CN
- China
- Prior art keywords
- synchronization
- database
- synchronous
- complexity
- source
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a heterogeneous database data synchronization analysis method, which relates to the field of data synchronization correlation, and comprises the following steps: obtaining a first source database and a first target database through user configuration; judging the types of the multiple source databases in the first source database and the first target database to obtain a first synchronization complexity; if the first synchronization complexity is not in the preset synchronization complexity, performing database type unified interface processing on the first target database to obtain a synchronization mapping template; obtaining a first variation source data set; synchronizing the first change source data group into a distributed message queue; and mapping conversion is carried out on the first change source data group according to the synchronous mapping template, and a synchronous mapping result is output to realize data synchronization of the first target database. The method achieves the purpose of realizing multi-source unified processing and synchronous mode conversion and improving the synchronous effect by analyzing the synchronous complexity of the multi-source database.
Description
Technical Field
The invention relates to the field of data synchronization, in particular to a heterogeneous database data synchronization analysis method.
Background
The data synchronization function is used for helping a user to realize real-time data synchronization between two data sources, data of different systems are synchronized, database synchronization related to a service system is important, at present, most databases provide leading-in and leading-out tools, but data are stored in different databases, the data need to be synchronized in a multi-source database, along with the increase of service scale, the time spent by data synchronization can be increased, particularly for the synchronization of a multi-source heterogeneous database, the synchronization effect is easily influenced, and therefore the service synchronization requirement cannot be met.
However, the synchronization method for the multi-source heterogeneous database is not perfect in the prior art, and the synchronization mode cannot be converted according to the real-time synchronization requirement, so that the synchronization effect is influenced.
Disclosure of Invention
Aiming at the defects in the prior art, the application aims to solve the technical problems that in the prior art, a synchronization method for a multi-source heterogeneous database is not perfect, the synchronization mode cannot be converted according to the real-time synchronization requirement, and the synchronization effect is influenced, and achieve the technical effects that the synchronization complexity analysis is carried out on the multi-source database synchronized in real time, the multi-source unified processing is realized according to the analysis result, and the synchronization effect is improved.
In one aspect, the present application provides a method for synchronous analysis of data in a heterogeneous database, where the method includes: obtaining a first source database and a first target database through user configuration, wherein the first source database is a synchronous transmission object database, and the first target database is a synchronous receiving object database; judging the types of the multiple source databases in the first source database and the first target database to obtain a first synchronization complexity; if the first synchronization complexity is not in the preset synchronization complexity, performing database type unified interface processing on the first target database to obtain a synchronization mapping template, wherein the synchronization mapping template is used for performing statement mapping conversion on data in a synchronization manner; capturing change data according to the filing log of the first source database to obtain a first change source data group; synchronizing the first change source data group into a distributed message queue; mapping conversion is carried out on the first change source data group according to the synchronous mapping template, and a synchronous mapping result is output; and realizing the data synchronization of the first target database according to the synchronous mapping result.
In another aspect, the present application further provides a system for analyzing data synchronization of heterogeneous databases, where the system includes: a first obtaining unit, configured to obtain, through user configuration, a first source database and a first target database, where the first source database is a synchronous transmission object database, and the first target database is a synchronous reception object database; a first determining unit, configured to determine types of the multiple source databases in the first source database and the first target database, and obtain a first synchronization complexity; a second obtaining unit, configured to perform database type uniform interface processing on the first target database to obtain a synchronous mapping template if the first synchronization complexity is not within a preset synchronization complexity, where the synchronous mapping template is used to perform statement mapping conversion on data in a synchronous manner; a third obtaining unit, configured to capture change data according to the archive log of the first source database, and obtain a first change source data group; a first synchronization unit to synchronize the first change source data set into a distributed message queue; the first output unit is used for carrying out mapping conversion on the first change source data set according to the synchronous mapping template and outputting a synchronous mapping result; and the second synchronization unit is used for realizing the data synchronization of the first target database according to the synchronization mapping result.
In a third aspect, the present application provides a heterogeneous database data synchronization analysis system, including a memory, a processor, and a computer program stored on the memory and executable on the processor, wherein the processor implements the steps of the method according to any one of the first aspect when executing the program.
One or more technical solutions provided in the present application have at least the following technical effects or advantages:
1. because the method of transmitting a source database and receiving a database by acquiring a first source database and a first target database through user configuration, further performing synchronization complexity calculation by judging the type, the number and the like of the databases for synchronizing the first target database, outputting a first synchronization complexity, comparing preset synchronization complexities according to the first synchronization complexity, performing uniform interface processing of a database source if the complexities are higher, acquiring a synchronization mapping template for performing sentence mapping conversion on data in a same step, further synchronizing the data into a distributed message queue by capturing filing log change data in the first source database, realizing that the synchronization mapping template operates sentence conversion mapping in the synchronization mapping template based on the queue, and outputting a synchronization mapping result to realize data synchronization is adopted, the technical effects that the synchronous complexity analysis is carried out on the real-time synchronous multi-source database, multi-source unified processing is realized according to the analysis result, and the synchronous effect is further improved are achieved.
The foregoing description is only an overview of the technical solutions of the present application, and the present application can be implemented according to the content of the description in order to make the technical means of the present application more clearly understood, and the following detailed description of the present application is given in order to make the above and other objects, features, and advantages of the present application more clearly understandable.
Drawings
Other features, objects and advantages of the invention will become more apparent upon reading of the detailed description of non-limiting embodiments with reference to the following drawings:
fig. 1 is a schematic flowchart illustrating a method for synchronously analyzing data of heterogeneous databases according to an embodiment of the present disclosure;
fig. 2 is a schematic flowchart illustrating a first synchronization complexity obtaining method for a data synchronization analysis method of a heterogeneous database according to an embodiment of the present application;
fig. 3 is a schematic flowchart illustrating a synchronization offset calculation and analysis of a heterogeneous database data synchronization analysis method according to an embodiment of the present application;
fig. 4 is a schematic structural diagram of a data synchronization analysis system for heterogeneous databases according to an embodiment of the present application;
fig. 5 is a schematic structural diagram of an exemplary electronic device according to an embodiment of the present application.
Description of reference numerals: a first obtaining unit 11, a first judging unit 12, a second obtaining unit 13, a third obtaining unit 14, a first synchronizing unit 15, a first output unit 16, a second synchronizing unit 17, a bus 300, a receiver 301, a processor 302, a transmitter 303, a memory 304, and a bus interface 305.
Detailed Description
The embodiment of the application provides a heterogeneous database data synchronization analysis method, solves the technical problems that in the prior art, a synchronization method for a multi-source heterogeneous database is not perfect enough, the synchronization mode cannot be converted according to the real-time synchronization requirement, and the synchronization effect is affected, achieves the technical effects that the synchronization complexity analysis is performed on the real-time synchronized multi-source database, multi-source unified processing is realized according to the analysis result, and the synchronization effect is improved.
Hereinafter, example embodiments according to the present application will be described in detail with reference to the accompanying drawings. It should be apparent that the described embodiments are merely some embodiments of the present application and not all embodiments of the present application, and it should be understood that the present application is not limited to the example embodiments described herein.
According to the technical scheme, the data acquisition, storage, use, processing and the like meet relevant regulations of national laws and regulations.
The heterogeneous database system is a set of a plurality of related database systems and can realize sharing and transparent access of data, and aims to realize combination and sharing of data information resources, hardware equipment resources and human resources among different databases.
In view of the above technical problems, the technical solution provided by the present application has the following general idea:
the application provides a heterogeneous database data synchronization analysis method, a first source database and a first target database are obtained through user configuration to transmit the source database and receive the database for configuration, further, synchronization complexity calculation is carried out through judging the type, the number and the like of the databases for synchronizing the first target database, a first synchronization complexity is output, preset synchronization complexity is compared according to the first synchronization complexity, if the complexity is higher, a database source unified interface processing is carried out, a synchronization mapping template for carrying out synchronous statement mapping conversion on data is obtained, further, filing log change data in the first source database is captured, the data is synchronized into a distributed message queue, and the statement conversion mapping operation of the synchronization mapping template in the synchronization mapping template is realized based on the queue, the system has the characteristics of durability, high expansibility, strong universality and the like, achieves the technical effects of analyzing the synchronization complexity of the real-time synchronous multi-source databases, realizing multi-source unified processing according to the analysis result and further improving the synchronization effect.
For better understanding of the above technical solutions, the following detailed descriptions will be provided in conjunction with the drawings and the detailed description of the embodiments.
Example one
As shown in fig. 1, an embodiment of the present application provides a method for synchronous analysis of heterogeneous database data, where the method includes:
step S100: obtaining a first source database and a first target database through user configuration, wherein the first source database is a synchronous transmission object database, and the first target database is a synchronous receiving object database;
specifically, the heterogeneous database system is a collection of related multiple database systems, and can implement sharing and transparent access of data, and the heterogeneous database system aims to implement merging and sharing of data information resources, hardware equipment resources and human resources among different databases. The synchronous analysis method for the data of the heterogeneous databases solves the technical problems that in the prior art, a synchronous method for a multi-source heterogeneous database is not perfect enough, the conversion of a synchronous mode cannot be carried out according to real-time synchronous requirements, and the synchronous effect is further influenced, achieves the technical effects that the synchronous complexity analysis is carried out on the real-time synchronous multi-source databases, the multi-source unified processing is realized according to the analysis result, and the synchronous effect is further improved.
Further, analyzing and synchronously configuring the database and the resource data in the management system through user configuration, and determining a first source database and a first target database, wherein the first source database and the first target database both comprise a plurality of database sets, the first source database is a basis for synchronously transmitting the object database, and the first target database is a data receiving database which needs to be synchronized.
Therefore, the database transmitted and received by the database in the system is divided by the user, and then the subsequent number synchronization and data transmission are realized on the basis of the corresponding synchronous database, so that the basic database synchronized by the two parties is provided.
Step S200: judging the types of the multiple source databases in the first source database and the first target database to obtain a first synchronization complexity;
specifically, based on the first source database and the first target database obtained by user configuration, a multi-source database set of the first source database is further obtained, database types are further distinguished, and corresponding database type information is output; on the other hand, a multi-source database set in the first target database is obtained, and corresponding database type information is output through further database types; therefore, synchronization complexity analysis is carried out according to the obtained database type, and then data synchronization is carried out in advance and complexity processing is carried out, so that the prerequisite condition of synchronization mode conversion is provided for the synchronization.
The first synchronization complexity is complexity of identifying a data synchronization process from the first source database to the first target database, and when the types of the databases are various and the number of the databases is large, synchronization efficiency is low and synchronization errors are easy to occur.
Step S300: if the first synchronization complexity is not in the preset synchronization complexity, performing database type unified interface processing on the first target database to obtain a synchronization mapping template, wherein the synchronization mapping template is used for performing statement mapping conversion on data in a synchronization manner;
further, if the first synchronization complexity is not within the preset synchronization complexity, performing a unified interface processing on the database type on the first target database to obtain a synchronization mapping template, where step S300 in this embodiment of the present application further includes:
step S310: if the first synchronization complexity is not between the preset synchronization complexities, obtaining a first batch classification instruction;
step S320: performing library type identification on the first target database according to the first batch classification instruction, performing batch classification by using the library types with the same attribute as a library of the same class, and outputting a first library type classification result;
step S330: and carrying out interface matching marking according to the first library type classification result, and carrying out uniform interface replacement on each library type in the first library type classification result according to the marking content.
Specifically, after the first synchronization complexity is obtained, the first synchronization complexity is used as a variable condition input in real time to judge, a uniform interface of a same-attribute database is performed according to a judgment result, and a synchronization mapping template for performing sentence mapping conversion on data in the same step is output.
The specific process comprises the following step of comparing and judging the first synchronization complexity with the preset synchronization complexity according to a judgment execution instruction, wherein the preset synchronization complexity is a synchronization requirement index which is set individually based on system configuration and user configuration, so that the effective degree of synchronous execution can be effectively analyzed, and targeted processing is realized.
Further, whether the first synchronization complexity is in the preset synchronization complexity is judged, if the first synchronization complexity is in the synchronization complexity, the current synchronization execution efficiency meets the requirements of users, the efficiency is normal, and the error rate is low, so that the next operation step can be performed through a synchronization execution instruction.
In addition, if the first synchronization complexity is not within the preset synchronization complexity, a first batch classification instruction is obtained, and database type identification, for example, data phenotype identification in a database, is performed on all database sets in the first target database that need to be synchronized according to the first batch classification instruction.
Based on enterprise environment requirements of users, the data storage phenotypes in the databases have certain specifications, so attribute analysis is required to be performed according to the stored phenotypes, tabulations with the same function attributes are used as databases with the same attributes for classification, corresponding library type identification results are output, namely first library type classification results are output, interface matching marking is performed according to the first library type classification results, then a unified interface is performed on each library type in the first library type classification results according to marking contents, and as the same function attributes are matched with the corresponding interfaces, the interfaces of the corresponding library types are identified according to the table attributes, and further interface calling replacement is completed.
In the unified interface type processing, different interfaces are adopted aiming at different database types at present, and the access interfaces are independent, so that the problems of multiple database types and complex interfaces are easily caused.
And a user-defined distinguishing unit is additionally arranged to analyze the small table type difference existing between the databases with the same source attributes, so that the data can be synchronized in the interface with limited configuration, and the synchronous mapping template is obtained, wherein the synchronous mapping template aims at the database type in the first target database and the statement conversion template after the interface is processed uniformly.
Step S400: capturing change data according to the filing log of the first source database to obtain a first change source data group;
step S500: synchronizing the first change source data group into a distributed message queue;
further, the process of capturing the change data according to the archive log of the first source database is as follows: the filing log of the first original database comprises all data of the first source database, and the log-based data storage is more complete, so that the changed data is captured based on the first source database, the first change source data group is obtained, the basic data source needing to be synchronously changed is realized based on the first change source data group, and synchronous execution statement conversion mapping can be carried out according to the first change source data group.
Furthermore, based on the first change source data group, in order to ensure the one-to-one correspondence and accuracy of the synchronous fields, the first change source data group is synchronized into the distributed message queue, and because the asynchronization enables time-consuming synchronous operation to be performed through synchronization into the distributed message queue, the asynchronous processing can be performed in a message sending mode, and the time of synchronous waiting is reduced. Therefore, the further processing of the first change source data group can be facilitated, the influence caused by asynchronism is reduced, and the efficiency of message synchronization is improved.
Step S600: mapping conversion is carried out on the first change source data group according to the synchronous mapping template, and a synchronous mapping result is output;
step S700: and realizing the data synchronization of the first target database according to the synchronous mapping result.
Specifically, the synchronous mapping template is a synchronous statement template obtained after performing relevant processing based on the first target database, and a type mapping relationship and a type processing statement between the source database and the target database are obtained from a type mapping table to obtain a statement template and a type processing statement; and converting the Data in the distributed message queue into Data Definition Language (DDL) and Data Manipulation Language (DML) statements suitable for the first target database, so as to output the converted suitable statements as a synchronization mapping result, thereby realizing Data synchronization from the first change source Data group to the first target database.
For example, when performing synchronous conversion, it is first necessary to analyze the table type, structure, field, and find the corresponding relationship between tables, and whether the field needs to perform binary conversion, for example, the limited character string stored by one party is in a binary manner, e.g., 111111, while the decimal value corresponding to the binary is stored by the other party, and for example, a time (time division) of 6 bits is stored by one party and only a time (time division) of 4 bits is stored by the other party, then a custom substr operation can be performed. Therefore, effective synchronization can be performed based on the processed synchronous mapping template, and the technical effects of performing synchronous complexity analysis on the real-time synchronous multi-source database, realizing multi-source unified processing according to the analysis result and further improving the synchronization effect are achieved.
Further, as shown in fig. 2, the determining the types of the multiple source databases in the first source database and the first target database to obtain a first synchronization complexity, in step S200 of this embodiment of the present application, further includes:
step S210: building a synchronous complexity analysis model;
step S220: based on the synchronous complexity analysis model, synchronously analyzing the first change source data group captured and obtained in the first source database to obtain the synchronous complexity of the source database;
step S230: obtaining a multi-source database set of the first target database;
step S240: based on the synchronous complexity analysis model, carrying out synchronous analysis on the multi-source database set to obtain the synchronous complexity of a target database;
step S250: and calculating according to the synchronization complexity of the source database and the synchronization complexity of the target database, and outputting the first synchronization complexity.
Further, building a synchronization complexity analysis model, step S210 in the embodiment of the present application further includes:
step S211: obtaining a plurality of groups of synchronization complexity analysis indexes, wherein the plurality of groups of synchronization complexity analysis indexes comprise synchronization quantization indexes, synchronization frequency indexes and synchronization type indexes;
step S212: taking the synchronous quantization index, the synchronous frequency index and the synchronous type index as three dimensions, and building the synchronous complexity analysis model;
step S213: and obtaining the first synchronization complexity according to the synchronization complexity analysis model.
Specifically, the synchronization complexity analysis is an execution difficulty analysis process obtained by analyzing based on multiple source database types, and the real-time synchronization process can be subjected to targeted analysis and synchronization mode conversion through the complexity analysis, so as to improve the synchronization effect, and the process of performing the synchronization complexity analysis according to the multiple source database types in the first source database and the first target database is as follows:
firstly, a synchronization complexity analysis model is built, wherein the synchronization complexity analysis model is a data model and is used for carrying out data analysis on real-time synchronization configuration so as to obtain the complexity of executing the synchronization process, and the process of building the synchronization complexity analysis model is as follows: obtaining the multiple groups of synchronous complexity analysis indexes, including synchronous quantization indexes, synchronous frequency indexes and synchronous type indexes, wherein the synchronous quantization indexes are the size of data volume required to be processed in the process of executing synchronization; the synchronization frequency index is the size of synchronization frequency caused by the dynamic change degree of the change data in the synchronization executing process; the synchronization type index is based on the size of the heterogeneity of a synchronization object in the synchronization executing process, so that the synchronization quantization index, the synchronization frequency index and the synchronization type index are used as three dimensions, a synchronization complexity analysis model is built, further the model calculation output of the first synchronization complexity is realized, and the effectiveness and the accuracy of output data can be guaranteed through the model.
After the synchronization complexity analysis model is successfully built, the synchronization execution parties are respectively used as input for analysis, namely, the related information of the first source database is input into the synchronization complexity analysis model, and the source database synchronization complexity of the first source database is output; and inputting the relevant information of the first target database into the synchronization complexity analysis model, and outputting the synchronization complexity of the target database related to the first target database.
On one hand, since the synchronous execution process is performed based on the changed data source in the first source database, complexity analysis needs to be performed on the changed data captured and obtained in the first source database according to the synchronous complexity analysis model, for example, quantization information of the changed data, a type of the changed data, and the like, so that the synchronous execution complexity can be determined according to the analysis of the changed data, and further, the synchronous complexity of the source database is obtained and used for representing the synchronous complexity caused by the changed data in the first source database.
On the other hand, because the synchronization object executed synchronously relates to the complexity of the conversion of the synchronization statement, the type analysis is performed on all database sets in the first target database to determine the number of corresponding database types, the number of databases of each type, and the conversion difficulty of the databases, wherein the conversion difficulty of the databases is determined according to the conversion of the statement, for example, the conversion difficulty of the same attribute data is smaller than that of different attribute data, for example, in the binary conversion, the binary conversion is decimal conversion into the same attribute conversion. And then, the synchronization complexity caused by the multi-source heterogeneity of the first target database is output by calculating the synchronization execution complexity of the feature data of the analysis database.
And performing comprehensive calculation processing on the source database synchronization complexity of the first source database and the target database synchronization complexity of the first target database, and further outputting the first synchronization complexity, so that the purpose of performing complexity analysis respectively based on both synchronization parties is achieved, further performing information output by using a three-dimensional analysis model, and outputting a secondary comprehensive calculation result of the information as the first synchronization complexity is achieved, the accuracy of a synchronization complexity analysis result is improved, and a reliable process is further provided for improving the synchronization judgment accuracy and the execution flow.
Further, as shown in fig. 3, the step of implementing data synchronization of the first target database according to the synchronization mapping result further includes S700:
step S710: according to the synchronous mapping result, realizing data synchronization of the first target database to obtain a first recording instruction;
step S720: recording the synchronized data according to the first recording instruction, and performing data offset calculation according to the synchronized data to obtain a first offset calculation result;
step S730: performing synchronous abnormal positioning according to the first offset calculation result to obtain a first positioning abnormal database, wherein the first positioning abnormal database is an abnormal database with increased synchronous offset;
step S740: and performing secondary synchronization according to the first positioning anomaly database.
Specifically, the synchronous mapping result is a statement conversion result obtained by performing adaptive statement conversion on the type of the multi-source heterogeneous database in the first target database based on the change data of the first source database, so that after data synchronization is performed according to the first synchronous mapping result, recording of synchronous data is performed according to the first recording instruction, and data query and synchronous quality analysis are facilitated later.
The embodiment of the application is mainly used for realizing the calculation of the synchronous offset based on the recorded data, and the process comprises the steps of firstly, obtaining the synchronized data according to the first recording instruction. And calculating the data offset of the synchronized data, wherein the calculation of the data offset is a process of calculating data missing or error in the synchronization process so as to obtain a first offset calculation result, if the first offset calculation result is larger, the result is in a continuously increasing trend along with the synchronization, the synchronization process is positioned and then paused, abnormal synchronization data positioning is performed according to the offset data of the offset calculation, the synchronous offset of the corresponding database is larger, the synchronization quality is lower, and after self-checking, the first positioning abnormal database is subjected to secondary synchronization of abnormal data, so that data loss caused by system abnormality is avoided, and the operability and the synchronization quality of the synchronization are improved.
Further, the mapping conversion is performed on the first change source data group according to the synchronous mapping template, and a synchronous mapping result is output, in step S600 in this embodiment of the present application, the method further includes:
step S610: obtaining statement types in the synchronous mapping template according to the first change source data group;
step S620: building a first synchronous screening module, wherein the first synchronous screening module comprises a first specific sentence;
step S630: recognizing the statement type in the synchronous mapping template according to the first synchronous screening module, and judging whether the statement type in the synchronous mapping template is the same as the first specific statement or not;
step S640: and if the statement type in the synchronous mapping template is the same as the first peculiar statement, outputting a second target database, wherein the operation statement of the second target database does not comprise the first peculiar statement.
Specifically, since the synchronous mapping template is a synchronous statement transformation mapping template obtained based on the first target database, statement transformation of change data can be realized based on the template; and the first synchronous screening module is used for screening the databases which need to be subjected to synchronous statement conversion in the first target database.
Recognizing the statement type in the synchronous mapping template according to the first synchronous screening module, judging whether the statement type in the synchronous mapping template is the same as the first specific statement, if so, indicating that the operation statement in the database does not need to be subjected to synchronous statement conversion at present, and taking the operation statement as an independent synchronous database to carry out direct data synchronization, and if not, indicating that the operation statement in the database needs to be subjected to synchronous statement conversion, thereby taking the different database as the second target database to output.
In other words, it is only necessary to synchronize the INSERT, UPDATE and DELETE operations to determine which tables need to be synchronized (since the SELECT statement does not affect the change of table data, by analyzing the statement types in the synchronization mapping template, the databases which do not need to be converted are removed, thereby improving the synchronization efficiency.
Further, step S240 in the embodiment of the present application further includes:
step S241: grading the databases in the first target database according to the server grade, and outputting a first grading result;
step S242: obtaining a first-level database according to the first grading result, wherein the first-level database is the database with the lowest grade in the first grading result;
step S243: obtaining dynamic coefficients of data in the first-level database;
step S244: and updating the synchronization complexity of the target database according to the dynamic coefficient of the data in the first-stage database.
Specifically, the databases in the first target database are classified into databases of different levels according to different servers, for example, data between upper level databases and lower level databases also have a certain relation, so that the upper level databases change with the change of the lower level databases, the databases in the first target database are classified according to the server levels, a first classification result is output, the databases of the lowest levels are obtained according to the first classification result, and the synchronization complexity of the target databases is updated according to the dynamic change degree of the data in the first level databases, so that a more accurate complexity calculation result can be output.
Compared with the prior art, the invention has the following beneficial effects:
1. because the method of transmitting a source database and receiving a database by acquiring a first source database and a first target database through user configuration, further performing synchronization complexity calculation by judging the type, the number and the like of the databases for synchronizing the first target database, outputting a first synchronization complexity, comparing preset synchronization complexities according to the first synchronization complexity, performing uniform interface processing of a database source if the complexities are higher, acquiring a synchronization mapping template for performing sentence mapping conversion on data in a same step, further synchronizing the data into a distributed message queue by capturing filing log change data in the first source database, realizing that the synchronization mapping template operates sentence conversion mapping in the synchronization mapping template based on the queue, and outputting a synchronization mapping result to realize data synchronization is adopted, the technical effects that multi-source unified processing is realized according to the analysis result by analyzing the synchronization complexity of the real-time synchronized multi-source database, and the synchronization effect is further improved are achieved.
2. Due to the adoption of the mode that the source database synchronization complexity of the first source database and the target database synchronization complexity of the first target database are subjected to comprehensive calculation processing, and then the first synchronization complexity is output, the purposes that the synchronization sides respectively analyze the complexities, further the three-dimensional analysis model is used for outputting information, and the secondary comprehensive calculation result of the output information is used as the first synchronization complexity are achieved, the accuracy of the analysis result of the synchronization complexity is improved, and a reliable process is further provided for improving the synchronization judgment accuracy and executing the process.
3. The statement types in the synchronous mapping template are analyzed, so that databases which do not need to be converted are removed, and the synchronization efficiency is improved.
Example two
Based on the same inventive concept as the synchronous analysis method for data of the heterogeneous database in the foregoing embodiment, the present invention further provides a synchronous analysis system for data of the heterogeneous database, as shown in fig. 4, the system includes:
a first obtaining unit 11, where the first obtaining unit 11 is configured to obtain, through user configuration, a first source database and a first target database, where the first source database is a synchronous transmission object database, and the first target database is a synchronous reception object database;
a first determining unit 12, where the first determining unit 12 is configured to determine types of the multiple source databases in the first source database and the first target database, and obtain a first synchronization complexity;
a second obtaining unit 13, where the second obtaining unit 13 is configured to perform a unified interface processing on a database type on the first target database to obtain a synchronous mapping template if the first synchronization complexity is not within a preset synchronization complexity, where the synchronous mapping template is used to perform statement mapping conversion on data in a synchronous manner;
a third obtaining unit 14, where the third obtaining unit 14 is configured to capture change data according to an archive log of the first source database, and obtain a first change source data group;
a first synchronization unit 15, where the first synchronization unit 15 is configured to synchronize the first change source data group into a distributed message queue;
a first output unit 16, where the first output unit 16 is configured to perform mapping conversion on the first change source data set according to the synchronous mapping template, and output a synchronous mapping result;
a second synchronization unit 17, where the second synchronization unit 17 is configured to implement data synchronization of the first target database according to the synchronization mapping result.
Further, the system further comprises:
the first building unit is used for building a synchronous complexity analysis model;
a fourth obtaining unit, configured to perform synchronous analysis on the first change source data group captured and obtained in the first source database based on the synchronous complexity analysis model, so as to obtain the source database synchronous complexity;
a fifth obtaining unit, configured to obtain a multi-source database set of the first target database;
a sixth obtaining unit, configured to perform synchronous analysis on the multi-source database set based on the synchronous complexity analysis model to obtain a target database synchronous complexity;
and the second output unit is used for calculating according to the synchronization complexity of the source database and the synchronization complexity of the target database and outputting the first synchronization complexity.
Further, the system further comprises:
a seventh obtaining unit, configured to obtain multiple groups of synchronization complexity analysis indicators, where the multiple groups of synchronization complexity analysis indicators include a synchronization quantization indicator, a synchronization frequency indicator, and a synchronization type indicator;
the second building unit is used for building the synchronous complexity analysis model by taking the synchronous quantization index, the synchronous frequency index and the synchronous type index as three dimensions;
an eighth obtaining unit, configured to obtain the first synchronization complexity according to the synchronization complexity analysis model.
Further, the system further comprises:
a ninth obtaining unit, configured to obtain a first batch classification instruction if the first synchronization complexity is not between the preset synchronization complexities;
the first identification unit is used for carrying out library type identification on the first target database according to the first batch classification instruction, carrying out batch classification on libraries with the same attribute as a library with the same class, and outputting a first library type classification result;
and the first marking unit is used for carrying out interface matching marking according to the first library type classification result and carrying out unified interface replacement on each library type in the first library type classification result according to the marking content.
Further, the system further comprises:
a tenth obtaining unit, configured to implement data synchronization of the first target database according to the synchronization mapping result, and obtain a first record instruction;
an eleventh obtaining unit, configured to record synchronized data according to the first recording instruction, perform data offset calculation according to the synchronized data, and obtain a first offset calculation result;
a twelfth obtaining unit, configured to perform synchronous abnormal positioning according to the first offset calculation result, and obtain a first positioning abnormal database, where the first positioning abnormal database is an abnormal database with an increased synchronous offset;
and the third synchronization unit is used for carrying out secondary synchronization according to the first positioning anomaly database.
Further, the system further comprises:
a thirteenth obtaining unit, configured to obtain, according to the first change source data group, a statement type in the synchronization mapping template;
the third building unit is used for building a first synchronous screening module, wherein the first synchronous screening module comprises a first specific sentence;
the second identification unit is used for identifying the statement type in the synchronous mapping template according to the first synchronous screening module and judging whether the statement type in the synchronous mapping template is the same as the first specific statement or not;
a third output unit, configured to output a second target database if the statement type in the synchronous mapping template is the same as the first peculiar statement, where an operation statement of the second target database does not include the first peculiar statement.
Further, the system further comprises:
a fourth output unit, configured to grade the databases in the first target database according to the server grade, and output a first grading result;
a fourteenth obtaining unit, configured to obtain a first-level database according to the first classification result, where the first-level database is a database with a lowest level in the first classification result;
a fifteenth obtaining unit, configured to obtain a dynamic coefficient of data in the first-level database;
and the first updating unit is used for updating the synchronization complexity of the target database according to the dynamic coefficient of the data in the first-level database.
Various variations and specific examples of the aforementioned heterogeneous database data synchronization analysis method in the first embodiment of fig. 1 are also applicable to the heterogeneous database data synchronization analysis system of the present embodiment, and through the foregoing detailed description of the heterogeneous database data synchronization analysis method, those skilled in the art can clearly know the implementation method of the heterogeneous database data synchronization analysis system in the present embodiment, so for the brevity of the description, detailed descriptions are not repeated here.
EXAMPLE III
The electronic device of the present application is described below with reference to fig. 5.
Fig. 5 illustrates a schematic structural diagram of an electronic device according to the present application.
Based on the inventive concept of a method for synchronous analysis of heterogeneous database data in the foregoing embodiments, the present invention further provides a system for synchronous analysis of heterogeneous database data, on which a computer program is stored, and the computer program, when executed by a processor, implements the steps of any one of the methods of the system for synchronous analysis of heterogeneous database data described above.
Wherein in fig. 5 a bus architecture (represented by bus 300), bus 300 may include any number of interconnected buses and bridges, bus 300 linking together various circuits including one or more processors, represented by processor 302, and memory, represented by memory 304. The bus 300 may also link together various other circuits such as peripherals, voltage regulators, power management circuits, and the like, which are well known in the art, and therefore, will not be described any further herein. A bus interface 305 provides an interface between the bus 300 and the receiver 301 and transmitter 303. The receiver 301 and the transmitter 303 may be the same element, i.e., a transceiver, providing a means for communicating with various other systems over a transmission medium. The processor 302 is responsible for managing the bus 300 and general processing, and the memory 304 may be used for storing data used by the processor 302 in performing operations.
The embodiment of the application provides a heterogeneous database data synchronization analysis method, which is applied to a heterogeneous database data synchronization analysis system and comprises the following steps: the method comprises the following steps: obtaining a first source database and a first target database through user configuration, wherein the first source database is a synchronous transmission object database, and the first target database is a synchronous receiving object database; judging the types of the multiple source databases in the first source database and the first target database to obtain a first synchronization complexity; if the first synchronization complexity is not in the preset synchronization complexity, performing database type unified interface processing on the first target database to obtain a synchronization mapping template, wherein the synchronization mapping template is used for performing statement mapping conversion on data in a synchronization manner; capturing change data according to the filing log of the first source database to obtain a first change source data group; synchronizing the first change source data group into a distributed message queue; mapping conversion is carried out on the first change source data group according to the synchronous mapping template, and a synchronous mapping result is output; and realizing the data synchronization of the first target database according to the synchronous mapping result. The technical problems that in the prior art, a synchronization method for a multi-source heterogeneous database is not perfect enough, and synchronization mode conversion cannot be performed according to real-time synchronization requirements, so that the synchronization effect is influenced are solved, and the technical effects that synchronization complexity analysis is performed on the real-time synchronized multi-source database, multi-source unified processing is realized according to the analysis result, and the synchronization effect is improved are achieved.
Those of ordinary skill in the art will understand that: the various numbers of the first, second, etc. mentioned in this application are only used for the convenience of description and are not used to limit the scope of the embodiments of this application, nor to indicate the order of precedence. "and/or" describes the association relationship of the associated objects, meaning that there may be three relationships, e.g., a and/or B, which may mean: a exists alone, A and B exist simultaneously, and B exists alone. The character "/" generally indicates that the former and latter associated objects are in an "or" relationship. "at least one" means one or more. At least two means two or more. "at least one," "any," or similar expressions refer to any combination of these items, including any combination of singular or plural items. For example, at least one (one ) of a, b, or c, may represent: a, b, c, a-b, a-c, b-c, or a-b-c, wherein a, b, c may be single or multiple.
In the above embodiments, all or part of the implementation may be realized by software, hardware, firmware, or any combination thereof. The computer may be a general purpose computer, a special purpose computer, a network of computers, or other programmable system. The computer instructions may be stored in a computer readable storage medium or transmitted from one computer readable storage medium to another, for example, from one website site, computer, server, or data center to another website site, computer, server, or data center via wired (e.g., coaxial cable, fiber optic, Digital Subscriber Line (DSL)) or wireless (e.g., infrared, wireless, microwave, etc.). The computer-readable storage medium can be any available medium that can be accessed by a computer or a data storage device including one or more available media integrated servers, data centers, and the like. The usable medium may be a magnetic medium (e.g., floppy Disk, hard Disk, magnetic tape), an optical medium (e.g., DVD), or a semiconductor medium (e.g., Solid State Disk (SSD)), among others.
The various illustrative logical units and circuits described in connection with the embodiments disclosed herein may be implemented or performed with a general purpose processor, a digital signal processor, an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other programmable logic system, discrete gate or transistor logic, discrete hardware components, or any combination thereof designed to perform the functions described herein. A general-purpose processor may be a microprocessor, but in the alternative, the processor may be any conventional processor, controller, microcontroller, or state machine. A processor may also be implemented as a combination of computing systems, e.g., a digital signal processor and a microprocessor, a plurality of microprocessors, one or more microprocessors in conjunction with a digital signal processor core, or any other similar configuration.
Although the present application has been described in conjunction with specific features and embodiments thereof, it will be evident that various modifications and combinations can be made thereto without departing from the spirit and scope of the application. Accordingly, the specification and figures are merely exemplary of the application as defined in the appended claims and are intended to cover any and all modifications, variations, combinations, or equivalents within the scope of the application. It will be apparent to those skilled in the art that various changes and modifications may be made in the present application without departing from the scope of the application. Thus, if such modifications and variations of the present application fall within the scope of the present application and its equivalent technology, it is intended that the present application include such modifications and variations.
Claims (7)
1. A heterogeneous database data synchronization analysis method is characterized by comprising the following steps:
obtaining a first source database and a first target database through user configuration, wherein the first source database is a synchronous transmission object database, and the first target database is a synchronous receiving object database;
judging the types of the multiple source databases in the first source database and the first target database to obtain a first synchronization complexity;
if the first synchronization complexity is not in the preset synchronization complexity, performing database type unified interface processing on the first target database to obtain a synchronization mapping template, wherein the synchronization mapping template is used for performing statement mapping conversion on data in a synchronization manner;
capturing change data according to the filing log of the first source database to obtain a first change source data group;
synchronizing the first change source data group into a distributed message queue;
mapping conversion is carried out on the first change source data set according to the synchronous mapping template, and a synchronous mapping result is output;
realizing data synchronization of the first target database according to the synchronous mapping result;
the determining the types of the multiple source databases in the first source database and the first target database to obtain a first synchronization complexity, the method further includes:
building a synchronous complexity analysis model;
based on the synchronous complexity analysis model, synchronously analyzing the first change source data group captured and obtained in the first source database to obtain the synchronous complexity of the source database;
obtaining a multi-source database set of the first target database;
based on the synchronous complexity analysis model, carrying out synchronous analysis on the multi-source database set to obtain the synchronous complexity of a target database;
calculating according to the source database synchronization complexity and the target database synchronization complexity, and outputting the first synchronization complexity;
the method for constructing the synchronous complexity analysis model further comprises the following steps:
obtaining a plurality of groups of synchronization complexity analysis indexes, wherein the plurality of groups of synchronization complexity analysis indexes comprise synchronization quantization indexes, synchronization frequency indexes and synchronization type indexes;
taking the synchronous quantization index, the synchronous frequency index and the synchronous type index as three dimensions, and building the synchronous complexity analysis model;
and obtaining the first synchronization complexity according to the synchronization complexity analysis model.
2. The method of claim 1, wherein if the first synchronization complexity is not within a preset synchronization complexity, performing a database type uniform interface process on the first target database to obtain a synchronization mapping template, the method further comprising:
if the first synchronization complexity is not between the preset synchronization complexities, obtaining a first batch classification instruction;
performing library type identification on the first target database according to the first batch classification instruction, performing batch classification by using the library types with the same attribute as a library of the same class, and outputting a first library type classification result;
and carrying out interface matching marking according to the first library type classification result, and carrying out uniform interface replacement on each library type in the first library type classification result according to the marking content.
3. The method of claim 1, wherein the data synchronization of the first target database is achieved according to the synchronization mapping result, the method further comprising:
according to the synchronous mapping result, realizing data synchronization of the first target database to obtain a first recording instruction;
recording the synchronized data according to the first recording instruction, and performing data offset calculation according to the synchronized data to obtain a first offset calculation result;
performing synchronous abnormal positioning according to the first offset calculation result to obtain a first positioning abnormal database, wherein the first positioning abnormal database is an abnormal database with increased synchronous offset;
and performing secondary synchronization according to the first positioning abnormal constant database.
4. The method of claim 1, wherein the map-converting the first change source data set according to the synchronization mapping template outputs a synchronization mapping result, the method further comprising:
obtaining statement types in the synchronous mapping template according to the first change source data group;
building a first synchronous screening module, wherein the first synchronous screening module comprises a first specific sentence;
recognizing the statement type in the synchronous mapping template according to the first synchronous screening module, and judging whether the statement type in the synchronous mapping template is the same as the first specific statement or not;
and if the statement type in the synchronous mapping template is the same as the first peculiar statement, outputting a second target database, wherein the operation statement of the second target database does not comprise the first peculiar statement.
5. The method of claim 1, wherein the method further comprises:
grading the databases in the first target database according to the server grade, and outputting a first grading result;
obtaining a first-level database according to the first grading result, wherein the first-level database is the database with the lowest grade in the first grading result;
obtaining dynamic coefficients of data in the first-level database;
and updating the synchronization complexity of the target database according to the dynamic coefficient of the data in the first-stage database.
6. A heterogeneous database data synchronization analysis system, the system comprising:
a first obtaining unit, configured to obtain, through user configuration, a first source database and a first target database, where the first source database is a synchronous transmission object database, and the first target database is a synchronous reception object database;
a first determining unit, configured to determine types of the multiple source databases in the first source database and the first target database, and obtain a first synchronization complexity;
a second obtaining unit, configured to perform database type uniform interface processing on the first target database to obtain a synchronous mapping template if the first synchronization complexity is not within a preset synchronization complexity, where the synchronous mapping template is used to perform statement mapping conversion on data in a synchronous manner;
a third obtaining unit, configured to capture change data according to the archive log of the first source database, and obtain a first change source data group;
a first synchronization unit to synchronize the first change source data set into a distributed message queue;
the first output unit is used for carrying out mapping conversion on the first change source data set according to the synchronous mapping template and outputting a synchronous mapping result;
the second synchronization unit is used for realizing the data synchronization of the first target database according to the synchronization mapping result;
the first building unit is used for building a synchronous complexity analysis model;
a fourth obtaining unit, configured to perform synchronous analysis on the first change source data group captured and obtained in the first source database based on the synchronous complexity analysis model, so as to obtain the source database synchronous complexity;
a fifth obtaining unit, configured to obtain a multi-source database set of the first target database;
a sixth obtaining unit, configured to perform synchronous analysis on the multi-source database set based on the synchronous complexity analysis model to obtain a target database synchronous complexity;
the second output unit is used for calculating according to the synchronization complexity of the source database and the synchronization complexity of the target database and outputting the first synchronization complexity;
a seventh obtaining unit, configured to obtain multiple groups of synchronization complexity analysis indicators, where the multiple groups of synchronization complexity analysis indicators include a synchronization quantization indicator, a synchronization frequency indicator, and a synchronization type indicator;
the second building unit is used for building the synchronous complexity analysis model by taking the synchronous quantization index, the synchronous frequency index and the synchronous type index as three dimensions;
an eighth obtaining unit, configured to obtain the first synchronization complexity according to the synchronization complexity analysis model.
7. A heterogeneous database data synchronization analysis system, comprising: a processor coupled to a memory, the memory for storing a program that, when executed by the processor, causes a system to perform the method of any of claims 1-5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210396566.5A CN114490882B (en) | 2022-04-15 | 2022-04-15 | Heterogeneous database data synchronization analysis method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210396566.5A CN114490882B (en) | 2022-04-15 | 2022-04-15 | Heterogeneous database data synchronization analysis method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114490882A CN114490882A (en) | 2022-05-13 |
| CN114490882B true CN114490882B (en) | 2022-06-21 |
Family
ID=81489616
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210396566.5A Active CN114490882B (en) | 2022-04-15 | 2022-04-15 | Heterogeneous database data synchronization analysis method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114490882B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115048912A (en) * | 2022-08-12 | 2022-09-13 | 成都锐菲网络科技有限公司 | Expressway driving data sharing method and application |
| CN117745472B (en) * | 2023-12-21 | 2024-06-25 | 江苏省工程勘测研究院有限责任公司 | River management method and system based on lightweight sensing model |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110377666A (en) * | 2019-07-26 | 2019-10-25 | 浪潮软件股份有限公司 | Based on the synchronous method of data between CMSP message-oriented middleware progress different source data library |
| CN112800150A (en) * | 2021-02-25 | 2021-05-14 | 浪潮云信息技术股份公司 | Automatic mapping and table building method for heterogeneous database |
Family Cites Families (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100388289C (en) * | 2006-09-14 | 2008-05-14 | 东北大学 | Complex equipment faced multi-subject design software integrated parameter mapping method |
| CN104346377B (en) * | 2013-07-31 | 2017-08-08 | 克拉玛依红有软件有限责任公司 | A kind of data integration and transfer method based on unique mark |
| CN103617176B (en) * | 2013-11-04 | 2017-03-15 | 广东电子工业研究院有限公司 | One kind realizes the autosynchronous method of multi-source heterogeneous data resource |
| US20170308606A1 (en) * | 2016-04-22 | 2017-10-26 | Quest Software Inc. | Systems and methods for using a structured query dialect to access document databases and merging with other sources |
| CN108647237A (en) * | 2018-03-30 | 2018-10-12 | 厦门海迈科技股份有限公司 | Method of data synchronization between isomeric relationship type database |
| CN111881209A (en) * | 2020-06-29 | 2020-11-03 | 平安国际智慧城市科技股份有限公司 | Data synchronization method and device for heterogeneous database, electronic equipment and medium |
| CN112905595A (en) * | 2021-03-05 | 2021-06-04 | 腾讯科技（深圳）有限公司 | Data query method and device and computer readable storage medium |
| CN113707339B (en) * | 2021-08-02 | 2022-12-09 | 西安交通大学 | Method and system for concept alignment and content inter-translation among multi-source heterogeneous databases |
-
2022
- 2022-04-15 CN CN202210396566.5A patent/CN114490882B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110377666A (en) * | 2019-07-26 | 2019-10-25 | 浪潮软件股份有限公司 | Based on the synchronous method of data between CMSP message-oriented middleware progress different source data library |
| CN112800150A (en) * | 2021-02-25 | 2021-05-14 | 浪潮云信息技术股份公司 | Automatic mapping and table building method for heterogeneous database |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114490882A (en) | 2022-05-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN114490882B (en) | Heterogeneous database data synchronization analysis method | |
| CN107506451B (en) | Abnormal information monitoring method and device for data interaction | |
| CN111177134B (en) | Data quality analysis method, device, terminal and medium suitable for mass data | |
| CN103513983A (en) | Method and system for predictive alert threshold determination tool | |
| US10810225B2 (en) | System and method for large scale data processing of source data | |
| WO2019050624A1 (en) | Processing of computer log messages for visualization and retrieval | |
| CN111190792A (en) | Log storage method and device, electronic equipment and readable storage medium | |
| CN111627552A (en) | Medical streaming data blood relationship analysis and storage method and device | |
| CN111427974A (en) | Data quality evaluation management method and device | |
| CN114461644A (en) | Data acquisition method and device, electronic equipment and storage medium | |
| CN114880405A (en) | Data lake-based data processing method and system | |
| CN115509797A (en) | Method, device, equipment and medium for determining fault category | |
| CN113138906A (en) | Call chain data acquisition method, device, equipment and storage medium | |
| CN116432092A (en) | Index system and method for fusing model data | |
| CN114580915B (en) | Intelligent evaluation method and system for hair planting effect of novel microneedle technology | |
| CN116204428A (en) | Test case generation method and device | |
| WO2022068348A1 (en) | Relational graph construction method and apparatus, electronic device, and storage medium | |
| CN115345600A (en) | RPA flow generation method and device | |
| CN113128848B (en) | Data quality monitoring method of all-service index, electronic equipment and storage medium | |
| CN110955709B (en) | Data processing method and device and electronic equipment | |
| CN112435151A (en) | Government affair information data processing method and system based on correlation analysis | |
| CN113380414A (en) | Data acquisition method and system based on big data | |
| CN112579673A (en) | Multi-source data processing method and device | |
| CN118069701B (en) | Reverse query link construction method, reverse query link construction device, computer equipment and storage medium | |
| CN114564853B (en) | Evaluation report generation method based on FMEA data and electronic equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |