WO2022160373A1

WO2022160373A1 - Method and system for solving multi-region certificate data conflict based on flexible rules

Info

Publication number: WO2022160373A1
Application number: PCT/CN2021/075451
Authority: WO
Inventors: 吴志雄; 黄文峰; 汪翔; 吴名耀
Original assignee: 南威软件股份有限公司
Priority date: 2021-01-27
Filing date: 2021-02-05
Publication date: 2022-08-04
Also published as: CN112650865A; CN112650865B

Abstract

The present invention relates to a method and system for solving a multi-region certificate data conflict based on flexible rules. The method comprises the following steps: 1) certificate information of data sources is first entered into an intermediate table using an update or newly add format and by means of a certificate identifier; 2) the certificate information in the intermediate table is processed according to a required field cleanup rule, and if required field determination is passed, same enters into the next step, otherwise same is entered into an index error table; 3) cleanup is performed on certificate information that passed required field determination according to a certificate feature repeat cleanup rule, and if certificate information needs to be updated or newly added, same is entered into an index table, other same is not entered into an index table. The present method and system facilitate solving a multi-region certificate data conflict, and improve the accuracy and efficiency of a certificate information index.

Description

A method and system for resolving multi-region license data conflicts based on flexible rules

technical field

The invention belongs to the technical field of electronic licenses, and in particular relates to a method and a system for resolving multi-region license data conflicts based on flexible rules.

Background technique

With the development of electronic license informatization, electronic license platforms have been established in many areas, and a large amount of electronic license data has been accumulated. However, the electronic license data standards in these areas may be different, and the system design architecture may also be different. Different departments are involved in There are many types of electronic licenses, how to realize the information sharing and standard unification of electronic licenses nationwide is a problem.

The license index table is a data table that records the index information and routing information of the licenses held by the user. It is used to quickly locate and route the license source when querying the user's specific license information. The content of the license routing table includes: user ID number, license name, the identification of the electronic license in the data source (preferably conforming to the national standard), license type, license type code in the data source, license type code in the license cloud service platform , The license issuing unit, the license issuing time, the license validity period, and the area code where the data source is located. When updating the license index table, it is also the prefecture-level database. The index priority of lower prefectures and cities is higher than that of higher prefectures. For example, Nanping prefecture is lower than the provincial database, so the index level is higher, and Nanping database data can be imported, but the provincial database Library data cannot be accessed. However, there are still some problems in the existing license information index: 1) The requirements of the index information management rules are unstable; 2) Now the same features of different data sources will enter the index table at the same time; 3) The feature identification is not accurate, and the features of a license will change. 4) There is a situation where one certificate replaces multiple certificates of the same characteristics; 5) The requirements for merging relevant information of certificates and licenses are not perfect. Therefore, it is necessary to design a method to solve the problem of multi-region license data conflict.

technical problem

The purpose of the present invention is to provide a method and system for resolving multi-region license data conflicts based on flexible rules, the method and system are conducive to resolving multi-region license data conflicts and improve the accuracy and efficiency of license information indexing.

technical solutions

In order to achieve the above object, the technical solution adopted in the present invention is: a method for solving multi-region license data conflicts based on flexible rules, comprising the following steps: 1) the license information of the data source, first pass the license identification, to update or add the license information; form into the intermediate table; 2) Process the license information in the intermediate table according to the required field cleaning rules, if the required field is judged to pass, go to the next step, otherwise enter the index error table; 3) For the required fields The certificate information that is judged to be passed is cleaned according to the characteristics of the certificate and the cleaning rules are repeated. If the certificate information needs to be updated or added, it will be entered into the index table, otherwise it will not be entered into the index table.

Further, in the step 2, the specific method of processing the license information according to the required field cleaning rules is: 201) First, the required fields are judged for the new license information, and it is judged whether there is an ID card, a license name and a license issue. Unit information, if yes, go to the next step, otherwise it is judged that the required fields of the certificate are not passed, enter the index error table, do not update the certificate, and the process ends; 202) Execute the judgment of the data source certificate type field, and judge whether the data source certificate type name is empty, If yes, then the data source license type is equal to the license name, and go to the next step, otherwise, go to the next step directly; 203) Determine whether the data source license type number is empty, if yes, go to the next step, otherwise go to step 205; 204) Determine whether it already exists The same data source license type, if yes, obtain the data source license type code with the same data source license type name and the same name, and then go to the next step, otherwise the data source license type name and the data source license type code are the same, and then go to the next step; 205 ) to bind the certificate type, and then judge whether the certificate type is successfully bound. If it is, it will be judged by the required fields of the certificate, otherwise it will enter the index error table, but the certificate update will not be affected by judging by the required fields of the certificate.

Further, in the step 3, the specific method for cleaning the license information according to the license characteristics repeated cleaning rules is: 301) For the new license information, determine whether there is a license with the same license identification in the index table, and if so, go to step 302. , otherwise go to step 303; 302) Determine whether the update time of the new license information is relatively new, if so, update the license information, otherwise the index table does not change, and the process ends; 303) Determine whether there are licenses with the same characteristics in the index table, then Go to the next step, otherwise add the license information, and the process ends; 304) Take the licenses with the same characteristics from the index table, and judge whether the licenses with the repeated characteristics are the same and consistent with the new licenses, if yes, add the license information, and the process ends, otherwise Go to the next step; 305) Enter the priority judgment process to judge whether the data source of the new license is of high priority, if so, replace the old license with the same characteristics with the new license, leaving only one license of the data source, otherwise the index table does not change.

Further, the priority judging process includes the following steps: A1) For the license A and the license B of two different data sources, judge whether they are the same access library type, if so, go to the next step, otherwise, according to the data of the unit type. According to the principle that the source priority is greater than the data source of the regional type, confirm the license that needs to be updated; A2) Determine whether it is the same access city level, if yes, confirm the license that needs to be updated, otherwise go to the next step; A3) Determine whether it is unit data The source is still a regional data source. If it is a unit data source, the higher the unit level, the higher the priority of the license is to confirm the license that needs to be updated; if it is a regional data source, the lower the unit level, the higher the priority of the license. The higher the principle, the confirmation of the license that needs to be renewed.

The present invention also provides a system for resolving multi-region license data conflicts based on flexible rules, including a memory, a processor, and a computer program stored in the memory and capable of running on the processor. When the processor runs the computer program, the above method steps.

beneficial effect

Compared with the prior art, the present invention has the following beneficial effects: a. It is easier to handle if the license update rules are changed, and if the license rules change under the existing mechanism, it is necessary to obtain the license from the data source again, and then re-update according to the new rules. The license form is a lot of work, and it is prone to problems. If there is a license for the intermediate table, the index table can be updated through the data collected before the intermediate table, without the need to obtain data from the data source, which is faster and more convenient. In this way, the cost of modifying the rules in the future is relatively low.

b. The switch of the data source is more convenient. Closing the data source currently only deactivates the certificate used by the data source, but such an operation is not reasonable enough. For example, both the provincial library and the Nanping library pass ID cards with the same characteristics. According to the existing rules, the ID card of the Nanping library is used. If the Nanping library is now closed, the user will not be able to see the ID card, and the correct identification of the provincial library should be displayed. ID card. If the existing situation needs to be modified, it is necessary to obtain and judge data from each data source; if there is an intermediate table, the index table can be updated by relying on the previously collected data, and there is no need to obtain data from the data source.

c. The operation of deleting the certificate can be completed. Under the current function, we only add new certificates and will not delete them. Even if the data source deletes this certificate (not void), we will not delete the certificate. We need an intermediate library for regular comparison. When the data source deletes the license, we can compare whether to delete or reference data from other data sources.

d. Pave the way for big data license processing, add intermediate tables, and update them according to the steps in the flow chart below. In fact, first collect data, and then clean it according to the rules to generate index tables; the current process lacks data collection part. It is in line with the changes in the way of big data processing in the future.

Description of drawings

FIG. 1 is a flow chart of a method implementation according to an embodiment of the present invention.

FIG. 2 is a flowchart of cleaning a required field in an embodiment of the present invention.

FIG. 3 is a flowchart of repeated cleaning of certificate features in an embodiment of the present invention.

FIG. 4 is a flowchart of priority determination in an embodiment of the present invention.

Embodiments of the present invention

The present invention will be further described in detail below with reference to the accompanying drawings and specific embodiments.

As shown in FIG. 1 , the present invention provides a method for resolving multi-region license data conflicts based on flexible rules, which is characterized in that it includes the following steps: 1) The license information of the data source is first passed through the license identification to update or add a new license. form into the intermediate table. The data is directly stored, and there is no need to judge the duplicate data for the validity field.

2) The license information in the intermediate table is processed according to the required field cleaning rules. If the required field is judged to pass, go to the next step, otherwise it will enter the index error table.

As shown in Figure 2, the specific method of processing license information according to the required field cleaning rules is: 201) First, determine the required fields for the new license information, and determine whether there is an ID card, license name and license issuing unit information. If yes, go to the next step, otherwise it is judged that the required fields of the certificate are not passed, enter the index error table, do not update the certificate, and the process ends; 202) Execute the judgment of the data source certificate type field, and judge whether the name of the data source certificate type is empty, if yes, the data The source license type is equal to the license name, and go to the next step, otherwise, go to the next step directly; 203) Determine whether the data source license type number is empty, then go to the next step, otherwise go to step 205; 204) Determine whether the same data already exists If the source license type is yes, then obtain the data source license type code with the same data source license type name and the same name, and then go to the next step, otherwise the data source license type name and the data source license type code are the same, and then go to the next step; 205) Carry out the license Type binding, and then judge whether the certificate type is successfully bound. If yes, it will be judged by the required fields of the certificate, otherwise it will enter the index error table, but the certificate update will not be affected by judging by the required fields of the certificate.

3) For the license information that has passed the judgment of the required fields, the cleaning rules are repeated according to the characteristics of the license. If the license information needs to be updated or added, it will be entered into the index table, otherwise it will not be entered into the index table.

As shown in Figure 3, the specific method for cleaning the license information according to the license characteristics repeated cleaning rules is: 301) For the new license information, determine whether there is a license with the same license identification in the index table, if yes, go to step 302, otherwise go to step 302 Step 303.

302) Determine whether the update time of the new license information is relatively new, and if so, update the license information, otherwise the index table does not change, and the process ends.

303) Determine whether there are licenses with the same characteristics in the index table, if yes, go to the next step, otherwise add license information, and the process ends.

304) Take out the licenses with the same features from the index table, and judge whether the licenses with the repeated features are the same and consistent with the new licenses, if yes, add the license information, and the process ends, otherwise, go to the next step.

305) Enter the priority judgment process to judge whether the data source of the new license is of high priority, and if so, replace the old license with the same characteristics with the new license, leaving only the license of one data source, otherwise the index table will not change.

As shown in Figure 4, the priority judgment process includes the following steps: A1) For the license A and license B of two different data sources, determine whether they are the same access library type, if so, go to the next step, otherwise, according to the unit According to the principle that the priority of the type of data source is higher than that of the regional type of data source, confirm the license that needs to be updated; A2) Judge whether it is the same access city level, if yes, confirm the license that needs to be updated, otherwise go to the next step; A3) Judge Whether it is a unit data source or a regional data source, if it is a unit data source, the higher the unit level, the higher the priority of the license, confirm the license that needs to be updated; if it is a regional data source, according to the lower unit level, The higher the priority of the license, the confirmation of the license that needs to be renewed.

The present invention adds an intermediate table to clean, screen and employ the conflicting data of licenses in multiple regions. The intermediate table is the record table that pushes all the certificates to us for all data sources (non-log table, the same data source does not have the same certificate ID). The index table is a record table that we show to our customers, using valid multiple data source features with the same certificate. The index table is a table generated after the intermediate table is processed by rules, and the intermediate table should contain all the data of the index table.

The above are the preferred embodiments of the present invention, all changes made according to the technical solutions of the present invention, when the resulting functional effects do not exceed the scope of the technical solutions of the present invention, belong to the protection scope of the present invention.

Claims

A method for resolving multi-region license data conflicts based on flexible rules, comprising the following steps:

1) The license information of the data source is first passed through the license identification and entered into the intermediate table in the form of update or new addition;

2) The license information in the intermediate table is processed according to the required field cleaning rules. If the required field is judged to pass, it will go to the next step, otherwise it will enter the index error table;

3) For the license information that has passed the judgment of the required fields, the cleaning rules are repeated according to the characteristics of the license. If the license information needs to be updated or added, it will be entered into the index table, otherwise it will not be entered into the index table.
The method for resolving multi-region license data conflicts based on flexible rules according to claim 1, wherein, in the step 2, the specific method for processing license information according to the required field cleaning rules is:

201) For the new license information, first make a judgment on the required fields, and judge whether there is an ID card, license name and license issuing unit information. If yes, go to the next step. Otherwise, it is judged that the mandatory fields of the license are not passed, and the index error table is entered, and the update is not performed. Certificate, the process is over;

202) Judging the data source license type field to determine whether the data source license type name is empty, if yes, the data source license type is equal to the license name, and go to the next step, otherwise, directly go to the next step;

203) Determine whether the data source license type number is empty, if yes, go to the next step, otherwise go to step 205;

204) Determine whether the same data source license type already exists, if yes, obtain 1) the same data source license type name and 2) the same data source license type code, and then go to the next step, otherwise the data source license type name and data source The license type code is the same, and then go to the next step;

205) Bind the certificate type, and then judge whether the certificate type is successfully bound. If yes, it is judged by the required fields of the certificate, otherwise it will enter the index error table.
The method for resolving multi-region license data conflicts based on flexible rules according to claim 1, wherein, in the step 3, the specific method for cleaning the license information according to the license characteristics repeated cleaning rules is:

301) For the new license information, determine whether there is a license with the same license ID in the index table, if yes, go to step 302; otherwise, go to step 303;

302) Determine whether the update time of the new license information is relatively new, and if so, update the license information, otherwise the index table does not change, and the process ends;

303) Determine whether there are licenses with the same characteristics in the index table, if yes, go to the next step, otherwise add license information, and the process ends;

304) Take out the licenses with the same characteristics from the index table, and judge whether the licenses with the same characteristics in the index table have the same data source as the new licenses. If they have the same characteristics and there is no license with the same identification, then add the license information, and the process ends. Otherwise, go to the next step;

305) Enter the priority judgment process to judge whether the data source of the new license is of high priority, and if so, replace the old license with the same characteristics with the new license, leaving only the license of one data source, otherwise the index table will not change.
The method for resolving multi-area license data conflicts based on flexible rules according to claim 3, wherein the priority judging process comprises the following steps:

A1) For licenses A and B of two different data sources, determine whether they are the same type of access database, and if so, go to the next step; otherwise, according to the principle that the data source of the unit type has a higher priority than the data source of the regional type, determine If the priority of the new license is high, it will be updated, and if the priority of the old license is high, it will not be updated. ;

A2) Determine whether it is the same access city level, if yes, confirm the license that needs to be updated, otherwise go to the next step;

A3) Determine whether it is a unit data source or a regional data source. If it is a unit data source, confirm the license that needs to be updated according to the principle that the higher the unit level, the higher the priority of the license; if it is a regional data source, the unit level The lower the priority, the higher the priority of the license, and the license that needs to be updated is confirmed.
A system based on flexible rules for resolving multi-region license data conflicts, characterized in that it comprises a memory, a processor, and a computer program stored on the memory and capable of running on the processor, when the processor runs the computer program, the The method steps of any one of claims 1-4.