Vehicle ID calculation methods, systems, and computer program products based on vehicle elements

Abstract

This invention discloses a method, system, and computer program product for calculating vehicle IDs based on vehicle elements. The method includes: extracting a list of vehicle elements; determining the validity of vehicle elements; extracting valid vehicle elements; adding license plate ID, VIN code ID, and chassis number ID; extracting matching relationships between valid vehicle elements; establishing matching relationships between first and second vehicle elements; grouping by second vehicle elements; calculating the row number within the group of first vehicle elements; extracting unique valid second vehicle elements; calculating the vehicle ID of the second vehicle element using the first row of first vehicle elements within the second vehicle element group; and generating a valid vehicle element vehicle ID. This invention calculates and generates unique vehicle IDs based on vehicle elements, which is used to accurately and efficiently remove duplicate vehicle counts and establish policy renewal relationships.

Description

Technical Field

[0001] This invention relates to the field of insurance data analysis technology, and in particular to a method, system, and computer program product for calculating vehicle IDs based on vehicle elements. Background Technology

[0002] In insurance data analysis, it is often necessary to statistically analyze auto insurance business indicators. For example, in addition to the number of policies and premiums, the number of vehicles is also considered when analyzing auto insurance underwriting indicators. To establish policy renewal relationships by matching new and old policies for the same vehicle, auto insurance renewal indicators include the number of renewed policies, policy renewal rate, renewal premiums, premium renewal rate, the number of renewed vehicles, and vehicle renewal rate.

[0003] A vehicle has three important attributes or elements: license plate (License = License No - License Type), VIN (Vin No), and vehicle identification number (Frame No). These are collectively known as the three elements of a vehicle, or simply vehicle elements. They are usually used to uniquely identify a vehicle. A common method is that if any one of the three elements is the same, the vehicle is considered to be the same vehicle.

[0004] Agreement: License plate number Yun A12345, license plate type 02, VIN code V1, vehicle identification number F1, license plate can be represented as: Yun A12345-02, vehicle three elements can be represented as: Yun A12345-02 / V1 / F1.

[0005] Examples of vehicles considered as the same:

[0006] Vehicles with the same license plate are considered the same vehicle. For example, if vehicle 1 has the following three vehicle information elements: Yun A12345-02 / V1 / F1, and vehicle 2 has the same three vehicle information elements: Yun A12345-02 / V2 / F2, then vehicle 1 and vehicle 2 have the same license plate, Yun A12345-02. Although their VIN and VIN numbers are different, they are considered the same vehicle.

[0007] Vehicles with the same VIN are considered the same vehicle. For example, if vehicle 1 has the following three vehicle information: Yun A12345-02 / V1 / F1, and vehicle 2 has the following three vehicle information: Yun A54321-02 / V1 / F2, then vehicle 1 and vehicle 2 have the same VIN (V1), and although their license plates and vehicle identification numbers (VINs) are different, they are considered the same vehicle.

[0008] Vehicles with the same VIN are considered the same vehicle. For example, if vehicle 1 has the following three vehicle information: Yun A12345-02 / V1 / F1, and vehicle 2 has the following three vehicle information: Yun A54321-02 / V2 / F1, then vehicle 1 and vehicle 2 have the same VIN (F1), and although their license plates and VINs are different, they are considered the same vehicle.

[0009] The three essential vehicle attributes may change. For the same vehicle, one or more of these attributes may differ at different times and be recorded in the insurance policy. For example, a policy taken out for a new car after purchase but before registration and application for a formal license plate, before it is driven on the road, might record a temporary license plate, the last 6 digits of the VIN code, or something similar to "new car not yet registered." Even after applying for a formal license plate, the policy might not be updated for that year. However, subsequent policies might record the formal license plate. Due to data quality issues in the information system, for the same vehicle, some policies might have all three essential vehicle attributes recorded accurately, while others might not, or some attributes might be entered incorrectly. After a vehicle is transferred, the original owner retains the original license plate, and the original insurance policy uses the original license plate. When the new owner applies for a new license plate, the new insurance policy uses the new license plate.

[0010] When counting the number of vehicles, duplicates must be removed. For example, if the same vehicle has one compulsory traffic accident liability insurance policy and one commercial insurance policy, totaling two policies, it can only be counted as one vehicle in the overall number of insured vehicles, not two.

[0011] When establishing a policy renewal relationship, accuracy and completeness are required. For example, if the vehicle in the new policy and the old policy is the same vehicle, a renewal relationship must be established between the new policy and the old policy. Even if the three elements of the vehicle in the new policy and the three elements of the vehicle in the old policy are not all the same, as long as one element is the same, a renewal relationship must be established.

[0012] In existing technologies, it is possible to use only one of the three vehicle elements (e.g., license plate or VIN code) to identify a vehicle, which may result in duplicate counting of vehicles and omission of policy renewal relationships, leading to inaccurate statistical results. Alternatively, it is possible to use the three vehicle elements to identify a vehicle at each step, which will not result in duplicate counting of vehicles or omission of policy renewal relationships, but will increase the complexity of the statistical procedure and reduce the execution speed of the statistical procedure. Summary of the Invention

[0013] The present invention aims to at least partially solve one of the technical problems in the related art.

[0014] Therefore, the first objective of this invention is to propose a vehicle ID calculation method based on vehicle elements, which can effectively calculate vehicle IDs based on vehicle elements to solve the problems of accuracy of statistical results and complexity of statistical procedures.

[0015] The second objective of this invention is to propose a vehicle ID calculation system based on vehicle elements.

[0016] The third objective of this invention is to provide a computer program product.

[0017] To achieve the above objectives, a first aspect of the present invention proposes a method for calculating vehicle ID based on vehicle elements, comprising:

[0018] A temporary table of vehicle elements is generated based on the vehicle element list extracted from the policy list, and a temporary table of vehicle element validity is generated based on the validity judgment results of the element attributes in the temporary table of vehicle elements. The element attribute ID is calculated based on the temporary table of vehicle element validity to generate a temporary table of valid vehicle elements.

[0019] A matching relationship between the first vehicle element and the second vehicle element is established based on the first state data of the vehicle and the first judgment result of the first vehicle element and the second vehicle element based on the temporary table of effective vehicle elements to generate a temporary table of matching first effective vehicle elements; wherein, the first judgment result includes at least one element attribute of the first vehicle element and the second vehicle element being valid and the same.

[0020] Based on the first valid vehicle element matching temporary table, calculate the row number of the first vehicle element in the second vehicle element group to generate the first valid vehicle element matching row number temporary table.

[0021] Valid second vehicle elements are extracted from the first valid vehicle element matching temporary table to generate a valid second vehicle element temporary table. The vehicle ID of the second vehicle element is calculated based on the valid second vehicle element temporary table and the first valid vehicle element matching row number temporary table. The obtained second vehicle element vehicle ID is used as the valid vehicle element vehicle ID result.

[0022] In addition, the vehicle ID calculation method based on vehicle elements in this embodiment of the invention also has the following additional technical features:

[0023] Optionally, the element attributes include multiple types such as license plate, VIN code, and vehicle identification number; wherein, the license plate includes license plate number and license plate type; the validity judgment results of the element attributes in the temporary table of vehicle elements include: validity judgment results of license plate, VIN code, and vehicle identification number.

[0024] Optionally, determining the validity of a license plate includes:

[0025] Check if the license plate number or license plate type is null; if yes, determine the license plate is invalid; otherwise,

[0026] Determine if the license plate number contains special characters; if so, the license plate is invalid; otherwise,

[0027] Determine if the length of the license plate number is less than a first preset threshold; if yes, the license plate is deemed invalid; otherwise, the license plate is deemed valid.

[0028] Optionally, before determining the validity of the VIN code, the method further includes:

[0029] Initialize VIN code related data to obtain VIN code initialization result; wherein, the VIN code related data includes VIN code character value, VIN code character position weight and check character corresponding to VIN code check value;

[0030] Calculate the weighted total of the VIN code character values ​​based on the VIN code initialization result, and calculate the VIN code check value based on the weighted total of the VIN code character values;

[0031] Find the check character corresponding to the VIN code check value.

[0032] Optionally, determining the validity of the VIN code includes:

[0033] Check if the VIN code is null. If it is, determine that the VIN code is invalid; otherwise, check if it is null.

[0034] Determine if the VIN code length is not equal to the second preset threshold. If yes, determine that the VIN code is invalid; otherwise, determine if the VIN code is invalid.

[0035] Calculate the check character of the VIN code, and compare the check character of the VIN code with the ninth character of the VIN code. If they are the same, the VIN code is qualified and the VIN code is determined to be valid; if they are different, the VIN code is unqualified and the VIN code is determined to be invalid.

[0036] Optionally, after calculating the feature attribute IDs based on the temporary table of vehicle feature validity to generate a temporary table of valid vehicle features, the method further includes:

[0037] The transfer record of the valid VIN code ID is extracted based on the vehicle's second state data and the temporary table of valid vehicle elements;

[0038] The start and end dates of valid vehicle elements are calculated based on the transfer records of valid VIN codes to generate a temporary table of start and end dates of valid vehicle elements.

[0039] A matching relationship between the first vehicle element and the second vehicle element is established based on the second judgment result of the first vehicle element and the second vehicle element based on the temporary table of valid vehicle elements and the temporary table of start and end dates of valid vehicle elements to generate a second temporary table of valid vehicle element matching; wherein, the second judgment result includes that at least one element attribute of the first vehicle element and the second vehicle element is valid and the same, and the start and end date intervals of the vehicle elements are the same.

[0040] Optionally, after generating a second valid temporary table for vehicle feature matching, the method further includes:

[0041] The second vehicle elements are grouped based on the second effective vehicle element matching temporary table, and the row number of the first vehicle element within the second vehicle element group is calculated to generate the second effective vehicle element matching row number temporary table.

[0042] Valid second vehicle elements are extracted from the second valid vehicle element matching temporary table, and the priority valid attribute ID of the first vehicle element in the first row of the valid second vehicle element group is selected as the temporary vehicle ID based on the order of the second valid vehicle element matching row number temporary table to generate a temporary vehicle ID table for valid vehicle elements; wherein, the valid attribute ID includes valid license plate ID, valid VIN code ID, and valid vehicle identification number ID; the priority valid attribute ID is: the first valid attribute ID is selected according to the order of the three attribute IDs, namely license plate ID, VIN code ID, and vehicle identification number ID.

[0043] Optionally, after generating a temporary table of valid vehicle IDs for temporary vehicle elements, the method further includes:

[0044] Group the temporary vehicle IDs;

[0045] Based on the temporary vehicle ID table of the effective vehicle elements, the sequence number of the effective vehicle elements in the same temporary vehicle ID group is calculated, and the sequence number is used as the number of effective vehicle elements to generate a temporary table of effective vehicle element numbers.

[0046] Based on the temporary table of valid vehicle element counts, the valid vehicle element counts are appended to the end of the temporary vehicle ID, so that the resulting second vehicle element vehicle ID is used as the valid vehicle element vehicle ID result.

[0047] A second aspect of the present invention provides a vehicle ID calculation system based on vehicle elements, comprising:

[0048] The effective vehicle element generation module is used to generate a temporary vehicle element table based on the vehicle element list extracted from the insurance policy list, and to generate a temporary vehicle element validity table based on the validity judgment results of the element attributes in the temporary vehicle element table, so as to calculate the element attribute ID according to the temporary vehicle element validity table to generate a temporary effective vehicle element table.

[0049] The effective vehicle element matching module is used to establish a matching relationship between the first vehicle element and the second vehicle element based on the first state data of the vehicle and the first judgment result of the first vehicle element and the second vehicle element based on the effective vehicle element temporary table to generate a first effective vehicle element matching temporary table; wherein, the first judgment result includes at least one element attribute of the first vehicle element and the second vehicle element being valid and the same.

[0050] The row number calculation module within the group is used to calculate the row number of the first vehicle element within the second vehicle element group based on the first effective vehicle element matching temporary table, so as to generate the first effective vehicle element matching row number temporary table.

[0051] The valid vehicle element vehicle ID calculation module is used to extract valid second vehicle elements from the first valid vehicle element matching temporary table to generate a valid second vehicle element temporary table, and calculate the vehicle ID of the second vehicle element based on the valid second vehicle element temporary table and the first valid vehicle element matching row number temporary table, so as to use the obtained second vehicle element vehicle ID as the valid vehicle element vehicle ID result.

[0052] Optionally, the effective vehicle element matching module may be used to: extract transfer records of valid VIN codes based on the second status data of the vehicle and the temporary table of effective vehicle elements; calculate the start and end dates of effective vehicle elements based on the transfer records of valid VIN codes to generate a temporary table of start and end dates of effective vehicle elements; establish a matching relationship between the first element and the second element based on the second judgment result of the first vehicle element and the second vehicle element in the temporary table of effective vehicle elements to generate a second temporary table of effective vehicle element matching; wherein, the second judgment result includes at least one element attribute of the first vehicle element and the second vehicle element being valid and the same, and the start and end date ranges of the vehicle elements being the same.

[0053] Optionally, the row number calculation module within the group may be used for:

[0054] The second vehicle elements are grouped based on the second effective vehicle element matching temporary table, and the row number of the first vehicle element within the second vehicle element group is calculated to generate the second effective vehicle element matching row number temporary table.

[0055] Optionally, the effective vehicle element vehicle ID calculation module may be used for:

[0056] Valid second vehicle elements are extracted from the second valid vehicle element matching temporary table, and the priority valid attribute ID of the first vehicle element in the first row of the valid second vehicle element group is selected as the temporary vehicle ID based on the order of the second valid vehicle element matching row number temporary table to generate a valid vehicle element temporary vehicle ID temporary table; wherein, the valid attribute ID includes valid license plate ID, valid VIN code ID, and valid vehicle identification number ID; the priority valid attribute ID is: the first valid attribute ID is selected according to the order of the three attribute IDs, license plate ID, VIN code ID, and vehicle identification number ID; the temporary vehicle IDs are grouped; the sequence number of the valid vehicle element in the same temporary vehicle ID group is calculated based on the valid vehicle element temporary vehicle ID temporary table, and the sequence number is used as the valid vehicle element lot number to generate a valid vehicle element lot number temporary table; the valid vehicle element lot number is added to the end of the temporary vehicle ID based on the valid vehicle element lot number temporary table, so that the obtained second vehicle element vehicle ID is the valid vehicle element vehicle ID result.

[0057] A third aspect of the present invention provides a computer program product that, when executed by an instruction processor, implements the vehicle ID calculation method based on vehicle elements as described in the foregoing method embodiments.

[0058] The vehicle ID calculation method and system based on vehicle elements in this invention determines whether a vehicle is considered the same vehicle if any one of its three elements is valid and identical, and calculates and generates a unique vehicle ID as a vehicle identifier. This invention can directly utilize vehicle IDs to accurately and efficiently remove duplicate entries and establish policy renewal relationships when subsequently counting vehicles and establishing policy renewal relationships, thereby fundamentally solving the problems of statistical accuracy and statistical program complexity.

[0059] Additional aspects and advantages of the invention will be set forth in part in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. Attached Figure Description

[0060] Figure 1 A flowchart illustrating the first vehicle ID calculation method based on vehicle elements provided in this embodiment of the invention;

[0061] Figure 2 A flowchart illustrating the second vehicle ID calculation method based on vehicle elements provided in this embodiment of the invention;

[0062] Figure 3 The flowchart for determining the validity of a license plate provided in this embodiment of the invention;

[0063] Figure 4The flowchart for calculating the VIN code verification character provided in this embodiment of the invention;

[0064] Figure 5 The flowchart for determining the validity of the VIN code provided in this embodiment of the invention;

[0065] Figure 6 A flowchart of the third vehicle ID calculation method based on vehicle elements provided in this embodiment of the invention;

[0066] Figure 7 A flowchart of the fourth vehicle ID calculation method based on vehicle elements provided in this embodiment of the invention;

[0067] Figure 8 A schematic diagram of the structure of the vehicle ID calculation system based on vehicle elements provided in this embodiment of the invention. Detailed Implementation

[0068] Embodiments of the present invention are described in detail below, examples of which are illustrated in the accompanying drawings, wherein the same or similar reference numerals denote the same or similar elements or elements having the same or similar functions throughout. The embodiments described below with reference to the accompanying drawings are exemplary and intended to explain the present invention, and should not be construed as limiting the present invention.

[0069] The vehicle ID calculation method and system based on vehicle elements according to embodiments of the present invention are described below with reference to the accompanying drawings.

[0070] Figure 1 This is a flowchart illustrating a vehicle ID calculation method based on vehicle elements provided in an embodiment of the present invention. Figure 1 As shown, the method includes the following steps:

[0071] S101, generate a temporary vehicle element table based on the vehicle element list extracted from the policy list, and generate a temporary vehicle element validity table based on the validity judgment results of the element attributes in the temporary vehicle element table, so as to calculate the element attribute ID based on the temporary vehicle element validity table to generate a temporary valid vehicle element table.

[0072] It is understandable that vehicle ownership transfer involves different vehicle status data in different application scenarios, and the business logic may differ.

[0073] Specifically, in some application scenarios, the business logic assumes that since the vehicle brand and model have not changed, and the vehicle's initial state data and the three key elements of the vehicle have not all changed, the vehicle is considered the same vehicle before and after the ownership transfer. This application scenario is called Application Scenario A. The vehicle ID is irrelevant to whether the vehicle has been transferred, and no special processing is required for the vehicle transfer. As long as one of the three key elements of the vehicle is valid and the same, it is considered the same vehicle and is identified by the same vehicle ID.

[0074] Specifically, the actual situation is as follows: Owner: Zhang San (original owner), vehicle three elements: Yun A12345 - 02 / V1 / F1. On December 30, 2022 (4 - digit year - 2 - digit month - 2 - digit day, the same hereinafter), this vehicle together with the license plate was transferred to the owner Li Si (new owner). The original owner had 2 insurance policies P2021 and P2022 (original policies). The insurance period of P2021 was from January 1, 2021 to December 31, 2021, and the insurance period of P2022 was from January 1, 2022 to December 31, 2022. The new owner insured the insurance policy P2023 (new policy), and entered the vehicle transfer flag and vehicle transfer date. The insurance period was from January 1, 2023 to December 31, 2023.

[0075] Specifically, the business logic believes that the vehicles insured by the original policies P2021, P2022 and the new policy P2023 are the same vehicle, and the vehicle ID is L - Yun 12345 - 02.

[0076] Figure 2 It is a logic flow chart of a vehicle ID calculation method based on vehicle elements according to an embodiment of the present invention. As Figure 2 shown, it includes the following steps:

[0077] Among them, Figure 2 Step 1: Extract the vehicle element list from the insurance policy list and generate a temporary vehicle element table, which at least contains the following attributes after removing duplicates: license plate number, license plate type, VIN code and frame number, and the maximum start insurance date (this date is used to preferentially select the latest vehicle ID in the subsequent steps).

[0078] Exemplarily, if the attribute is null, it needs to be replaced with ”(i.e., a 0 - character string), because in the subsequent steps, null cannot make the connection condition hold.

[0079] For the convenience of subsequent description, assume that the 4 vehicle elements extracted from the insurance policy list after removing duplicates are shown in Table 1:

[0080] Table 1

[0081]

[0082] Among them, Figure 2 Step 2: For each attribute of the vehicle elements, judge the validity and generate a temporary vehicle element validity table.

[0083] In an embodiment of the present invention, judge the license plate validity. As Figure 3 shown:

[0084] 1) Check if the license plate number or license plate type is null; if yes, determine the license plate is invalid; if no,

[0085] 2) Determine if the license plate number contains special characters; if so, the license plate is invalid; otherwise,

[0086] 3) Determine if the length of the license plate number is less than the first preset threshold; if yes, determine that the license plate is invalid; if no, determine that the license plate is valid.

[0087] For example, 2), special characters include: not, none, temporarily, new car, transfer.

[0088] For example, 3), the length of the license plate number, is 1 for each Western character and 2 for each Chinese character.

[0089] For example, a stored function func_LicenseValid can be written to determine the validity of a license plate, so that it can be called.

[0090] In one embodiment of the present invention, the VIN code check character is calculated, such as... Figure 4 As shown:

[0091] 1) Initialize the values ​​corresponding to all VIN code characters. Character range: '0'-'9', 'A'-'Z' (excluding I, O, Q), 33 characters; corresponding value range: 0-9, 33 characters.

[0092] 2) Initialize the weights corresponding to all VIN code character positions. Position range: 1-17, quantity 17; corresponding weight range: 0-10, quantity 17, where the weight of the 9th position is 0, because the 9th character is the check character.

[0093] 3) Initialize all check characters corresponding to VIN code check values. Check value range: 0-10, quantity 11; Check character range corresponding to check values: '0'-'9', 'X', quantity 11.

[0094] 4) Calculate the weighted total of the VIN code character values. The formula is: Weighted total of character values ​​= sum(character value * weight of character position).

[0095] 5) Calculate the VIN code check value. Calculation formula: Check value = Weighted sum of character values ​​% 11.

[0096] 6) Locate the check character corresponding to the VIN code check value.

[0097] You can write a storage function `func_VinNoCheckChar` to calculate the VIN code check character as the first storage function for easy calling.

[0098] Figure 4 In the initialization steps 1)-3), Greenplum database supports arrays, so you can use either the array method, which is clearer and easier to understand, or you can use the string to simulate an array method. GBase database does not support arrays, so you can only use the string to simulate an array method.

[0099] In one embodiment of the present invention, the validity of the VIN code is determined, such as... Figure 5 As shown:

[0100] 1) Check if the VIN code is null. If it is, determine that the VIN code is invalid; otherwise,

[0101] 2) Determine if the VIN code length is not equal to the second preset threshold. If yes, determine that the VIN code is invalid; otherwise,

[0102] 3) Calculate the check character of the VIN code. Compare the check character of the VIN code with the ninth character of the VIN code. If they are the same, the VIN code is valid. If they are different, the VIN code is invalid.

[0103] For example, 3), the preset second storage function func_VinNoQualified is called to determine whether the VIN code is qualified. In the function, the VIN code check character is calculated (the preset first storage function can be called) and compared with the 9th character of the VIN code. If they are the same, the code is qualified; otherwise, it is unqualified.

[0104] For example, a stored function func_VinNoValid that checks the validity of the VIN code can be written as a third stored function for calling.

[0105] In one embodiment of this invention, the validity of the vehicle identification number (VIN) is determined. Currently, the actual stored value of the VIN is a VIN code, so the technical solution for determining the validity of the VIN is the same as the technical solution for determining the validity of the VIN code. Specifically, determining whether the VIN is valid can directly call the stored function for determining the validity of the VIN code, i.e., the preset second stored function. A fourth stored function, `func_FrameNoValid`, can be written to determine the validity of the VIN for later use.

[0106] To simplify the following explanation, we assume the results are as shown in Table 2:

[0107] Table 2

[0108] Vehicle elements License plate validity VIN code validity VIN validity Cloud A12345-02 / V1 / F1 true true true Cloud A12345-02 / V1 / F2 true true true New car not yet registered - 02 / V3 / F3 false true true Cloud A54321-02 / V3 / F3 true true true

[0109] in, Figure 2Step 3: If any one attribute of a vehicle element is valid, the entire vehicle element is considered valid. The license plate ID, VIN ID, and chassis number ID are calculated using the vehicle attributes, generating a temporary table of valid vehicle elements. The ID for valid vehicle attributes is generated by concatenating these attributes, while the ID for invalid vehicle attributes is "NoId". The results are shown in Table 3.

[0110] Table 3

[0111] Vehicle elements License Plate ID VIN code ID VIN Cloud A12345-02 / V1 / F1 L-Cloud A12345-02 V-V1 F-F1 Cloud A12345-02 / V1 / F2 L-Cloud A12345-02 V-V1 F-F2 New car not yet registered - 02 / V3 / F3 NoId V-V3 F-F3 Cloud A54321-02 / V3 / F3 L-Cloud A54321-02 V-V3 F-F3

[0112] S102, establish a matching relationship between the first vehicle element and the second vehicle element based on the first state data of the vehicle and the first judgment result of the first vehicle element and the second vehicle element based on the temporary table of valid vehicle elements to generate a temporary table of matching first valid vehicle elements; wherein, the first judgment result includes at least one element attribute of the first vehicle element and the second vehicle element being valid and the same.

[0113] in, Figure 2 Step 4, based on the vehicle transfer application scenario determined in step S101, the corresponding first state data of the vehicle is that not all three vehicle elements have changed. A self-join of the valid vehicle element temporary table is established, and valid vehicle elements are used as vehicle element 1 (first vehicle element) and vehicle element 2 (second vehicle element). Both vehicle element 1 and vehicle element 2 are vehicle elements. If at least one attribute (i.e., one of the three elements) of vehicle element 1 and vehicle element 2 is valid and the same, they are the same vehicle. A matching relationship between vehicle element 1 and vehicle element 2 is established, generating a first valid vehicle element matching temporary table.

[0114] Specifically, the results of matching the first effective vehicle element to the temporary table are shown in Table 4:

[0115] Table 4

[0116]

[0117]

[0118] Explanation of the results:

[0119] 1) There is a matching relationship between vehicle element 1 and vehicle element 2, and at least one of their vehicle attributes is valid and the same.

[0120] 2) Vehicle element 1 and vehicle element 2 may be the same or different.

[0121] 3) A specific vehicle element in vehicle element 1 may be matched with other specific vehicle elements in vehicle element 2. Therefore, a specific vehicle element may appear repeatedly in vehicle element 1.

[0122] 4) A specific vehicle element in vehicle element 1 and all vehicle elements 2 that match that vehicle element are the same vehicle.

[0123] 5) A specific vehicle element in vehicle element 2 may be matched with other specific vehicle elements in vehicle element 1. Therefore, a specific vehicle element may appear repeatedly in vehicle element 2.

[0124] 6) A specific vehicle element in vehicle element 2 and all vehicle elements 1 that match that vehicle element are the same vehicle.

[0125] S103, calculate the row number of the first vehicle element in the second vehicle element group based on the first valid vehicle element matching temporary table, so as to generate the first valid vehicle element matching row number temporary table.

[0126] in, Figure 2 Step 5: Group by vehicle element 2, calculate the row number of vehicle element 1 within the same vehicle element 2 group, and generate a temporary table of the first valid vehicle element matching row numbers.

[0127] The grouping criteria are: ① License plate number of vehicle element 2. ② License plate type of vehicle element 2. ③ VIN code of vehicle element 2. ④ Vehicle identification number (VIN) of vehicle element 2.

[0128] The sorting rules for the group numbers are as follows: ① The latest warranty start date for vehicle element 1, in descending order, with later dates listed first, because the later the warranty start date, the newer, more specific, and more accurate the vehicle elements may be. ② The license plate number for vehicle element 1, in descending order, with later dates listed first, because official license plate numbers (e.g., Yun A12345) are greater than temporary license plate numbers (e.g., 12345678, Yun 123456). ③ The license plate type for vehicle element 1. ④ The VIN code for vehicle element 1. ⑤ The vehicle identification number (VIN) for vehicle element 1.

[0129] For example, the row number within a group can be calculated using the window function row_number of the database system.

[0130] A temporary table of valid vehicle element matching row numbers is generated, as shown in Table 5:

[0131] Table 5

[0132] Vehicle Element 2 Vehicle Element 1 Maximum warranty start date 1 Grouping line numbers Cloud A12345-02 / V1 / F1 Cloud A12345-02 / V1 / F1 2022-01-01 2 Cloud A12345-02 / V1 / F1 Cloud A12345-02 / V1 / F2 2023-01-01 1 Cloud A12345-02 / V1 / F2 Cloud A12345-02 / V1 / F1 2022-01-01 2 Cloud A12345-02 / V1 / F2 Cloud A12345-02 / V1 / F2 2023-01-01 1 New car not yet registered - 02 / V3 / F3 New car not yet registered - 02 / V3 / F3 2023-01-01 2 New car not yet registered - 02 / V3 / F3 Cloud A54321-02 / V3 / F3 2024-01-01 1 Cloud A54321-02 / V3 / F3 New car not yet registered - 02 / V3 / F3 2023-01-01 2 Cloud A54321-02 / V3 / F3 Cloud A54321-02 / V3 / F3 2024-01-01 1

[0133] S104, extract valid second vehicle elements from the first valid vehicle element matching temporary table to generate a valid second vehicle element temporary table, and calculate the vehicle ID of the second vehicle element based on the valid second vehicle element temporary table and the first valid vehicle element matching row number temporary table, so as to use the obtained second vehicle element vehicle ID as the valid vehicle element vehicle ID result.

[0134] in, Figure 2 Step 6 involves extracting the unique valid vehicle element 2 and generating a temporary table for valid vehicle element 2. These valid vehicle elements are the vehicle elements for which valid vehicle IDs can be calculated.

[0135] For example, the specific extraction method is to match the temporary table of valid vehicle elements and remove the attributes of duplicate extracted vehicle element 2.

[0136] The results of the provisional table of valid vehicle element 2 are shown in Table 6:

[0137] Table 6

[0138] Effective vehicle element 2 Cloud A12345-02 / V1 / F1 Cloud A12345-02 / V1 / F2 New car not yet registered - 02 / V3 / F3 Cloud A54321-02 / V3 / F3

[0139] in, Figure 2 Step 7: Calculate the vehicle ID of vehicle element 2 using the first row of vehicle element 1 within the vehicle element 2 group. Select one of the valid license plate ID, valid VIN code ID, or valid vehicle identification number ID of the first row of vehicle element 1 as the vehicle ID in sequence. Generate a temporary table of valid vehicle element vehicle IDs to obtain the final result of calculating the vehicle IDs, which includes the vehicle IDs of valid vehicle elements but does not include the vehicle IDs of invalid vehicle elements.

[0140] The results are shown in Table 7:

[0141] Table 7

[0142] Vehicle elements Vehicle ID type Vehicle ID Cloud A12345-02 / V1 / F1 License L-Cloud A12345-02 Cloud A12345-02 / V1 / F2 License L-Cloud A12345-02 New car not yet registered - 02 / V3 / F3 License L-Cloud A54321-02 Cloud A54321-02 / V3 / F3 License L-Cloud A54321-02

[0143] Therefore, in the application of this invention, assuming the policy list table is PolicyList and the temporary table of valid vehicle element vehicle ID is temp_ValidVehicleId, the vehicle ID can be queried by the policy license plate, VIN code, and vehicle identification number.

[0144] According to the vehicle ID calculation method based on vehicle elements of this invention, in application scenario A, vehicle IDs can be calculated for valid vehicle elements. When counting the number of vehicles and establishing policy renewal relationships, vehicle IDs can be directly used to accurately and efficiently remove duplicate statistics and establish policy renewal relationships, thereby fundamentally solving the problems of accuracy of statistical results and complexity of statistical procedures. Notably, no special processing is performed on vehicle ownership transfers; the vehicle ID is unrelated to vehicle ownership transfer status.

[0145] This invention also proposes another method for calculating vehicle ID based on vehicle elements. Figure 6 This is a flowchart illustrating another vehicle ID calculation method based on vehicle elements provided in an embodiment of the present invention. Figure 6 As shown, it includes:

[0146] S201, generate a temporary vehicle element table based on the vehicle element list extracted from the policy list, and generate a temporary vehicle element validity table based on the validity judgment results of the element attributes in the temporary vehicle element table, and calculate the element attribute ID based on the temporary vehicle element validity table to generate a temporary valid vehicle element table.

[0147] Understandably, in other application scenarios, the business logic assumes that after a vehicle transfer, its purpose changes, the owner's driving habits change, and therefore the vehicle's risk profile changes. Thus, the vehicle before and after the transfer is not the same vehicle. This application scenario is called Application Scenario B. The vehicle ID is related to whether a vehicle transfer has occurred and requires special handling. Multiple start and end date ranges for vehicle elements are defined based on the transfer date. When one of the three vehicle elements is valid and identical, the policy start date must also fall within the same start and end date range of the vehicle elements to be considered the same vehicle and use the same vehicle ID. Otherwise, they are considered different vehicles and use different vehicle IDs. The vehicle ID includes the number of ownership transfers: 1 transfer before the first transfer (i.e., never transferred); 2 transfers after the first transfer and before the second transfer.

[0148] In one embodiment of the present invention, application scenario B is exemplified as follows:

[0149] Specifically, the actual situation is as follows: Vehicle owner: Zhang San (original owner); vehicle registration information: Yun A12345-02 / V1 / F1; on December 30, 2022 (4-digit year - 2-digit month - 2-digit day, the same below), the vehicle, along with its license plate, was transferred to vehicle owner Li Si (new owner). The original owner had two insurance policies, P2021 and P2022 (original policies). The insurance period for P2021 is from January 1, 2021 to December 31, 2021, and the insurance period for P2022 is from January 1, 2022 to December 31, 2022. The new owner has taken out insurance policy P2023 (new policy), and the vehicle transfer mark and transfer date have been entered. The insurance period is from January 1, 2023 to December 31, 2023.

[0150] Three vehicle elements: Yun A12345-02 / V1 / F1. Due to vehicle transfer, with the transfer date of December 30, 2022 as the boundary, the start and end dates of the vehicle elements are divided into two intervals (abbreviated as periods, and using the open interval and closed interval representation methods in mathematics): [infinity early, December 29, 2022], which is the first-hand period of the vehicle; [December 30, 2022, infinity late], which is the second-hand period of the vehicle.

[0151] The business logic believes that: the start date of the original insurance policy P2011 is January 1, 2021, and the start date of P2022 is January 1, 2022, within the first-hand period of the vehicle. The insured vehicle is the same vehicle, and the vehicle ID is L-Yun 12345-02-1, where the last 1 represents the first hand; the start date of the new insurance policy P2023 is January 1, 2023, within the second-hand period of the vehicle and not within the first-hand period of the vehicle. Therefore, the vehicle insured by the new insurance policy P2023 is not the same vehicle as the vehicles insured by the original insurance policies P2011 and P2022. The vehicle ID of the new insurance policy P2023 is L-Yun 12345-02-2, where the last 2 represents the second hand.

[0152] Specifically, the specific steps of another method in the embodiments of the present invention are as Figure 7 shown:

[0153] Among them, <​​​​​​​​​​​​​​​​​​​​​

[0160] To simplify the following explanation, we assume the results are as shown in Table 9:

[0161] Table 9

[0162] Vehicle elements License plate validity VIN code validity VIN validity Cloud A12345-02 / V1 / F1 true true true Cloud A12345-02 / V1 / F2 true true true New car not yet registered - 02 / V3 / F3 false true true Cloud A54321-02 / V3 / F3 true true true

[0163] in, Figure 7 Step 3: If any one attribute of a vehicle element is valid, the entire vehicle element is considered valid. The license plate ID, VIN ID, and chassis number ID are calculated using the vehicle attributes, generating a temporary table of valid vehicle elements. The ID of a valid vehicle attribute is generated by concatenating these attributes, while the ID of an invalid vehicle attribute is "NoId". The results are shown in Table 10:

[0164] Table 10

[0165]

[0166]

[0167] S202, extract the transfer record of valid VIN code ID based on the vehicle's second state data and the temporary table of valid vehicle elements.

[0168] Specifically, based on the vehicle's second state data, that is, after the vehicle is transferred, the vehicle's use changes, the owner's driving habits change, and therefore the vehicle's risk status has changed.

[0169] in, Figure 7 Step 4 involves extracting valid VIN ID transfer records and generating a temporary table of valid VIN ID transfer records. It's understandable that if any attribute of a vehicle element is valid and identical, it should be considered the same vehicle. However, vehicle elements are not yet used to identify the same vehicle here. Since the VIN code rarely changes during vehicle transfers, and usually only the license plate may change, a compromise is made when extracting and using vehicle transfer records: using only the VIN ID as the unique identifier for the vehicle.

[0170] The results are shown in Table 11:

[0171] Table 11

[0172] Valid VIN ID Transfer date V-V1 2022-12-30

[0173] S203, Calculate the start and end dates of valid vehicle elements based on the transfer records of valid VIN IDs to generate a temporary table of start and end dates of valid vehicle elements.

[0174] in, Figure 7Step 5 involves calculating the start and end dates of valid vehicle elements and generating a temporary table of valid vehicle element start and end dates. The period prior to the vehicle transfer date (excluding the transfer date) constitutes one start and end date interval for the vehicle element; the period from the vehicle transfer date (including the transfer date) constitutes another.

[0175] The following is for cars

[0176] Another start and end date range for vehicle elements. The results are shown in Table 12: (Note: Some columns have been deleted; 0001-01-01 is the origin date, representing infinitely early; 9999-12-31 is the infinity date, representing infinitely late):

[0177] Table 12

[0178]

[0179] S204, establish a matching relationship between the first vehicle element and the second vehicle element based on the second judgment result of the first vehicle element and the second vehicle element in the temporary table of effective vehicle element start and end dates to generate a second effective vehicle element matching temporary table; wherein, the second judgment result includes that at least one element attribute of the first vehicle element and the second vehicle element is valid and the same, and the start and end date intervals of the vehicle elements are the same.

[0180] in, Figure 7 Step 6 involves a self-join of the temporary table of valid vehicle elements. Simultaneously, valid vehicle elements are used as Vehicle Element 1 (first vehicle element) and Vehicle Element 2 (second vehicle element). Both Vehicle Element 1 and Vehicle Element 2 are vehicle elements. If at least one attribute (i.e., one of the three elements) of Vehicle Element 1 and Vehicle Element 2 is valid and identical, and the start and end date ranges of the vehicle elements are the same, then they are considered the same vehicle. A matching relationship is established between Vehicle Element 1 and Vehicle Element 2, generating a temporary table of valid vehicle element matching. The results are shown in Table 13.

[0181] Table 13

[0182]

[0183] Specifically, the explanation of the results:

[0184] 1) There is a matching relationship between vehicle element 1 and vehicle element 2. At least one of their vehicle attributes is valid and the same, and the start and end dates of the vehicle elements are the same.

[0185] 2) Vehicle element 1 and vehicle element 2 may be the same or different.

[0186] 3) A specific vehicle element in vehicle element 1 may be matched with other specific vehicle elements in vehicle element 2. Therefore, a specific vehicle element may appear repeatedly in vehicle element 1.

[0187] 4) A specific vehicle element in vehicle element 1 and all vehicle elements 2 that match that vehicle element are the same vehicle.

[0188] 5) A specific vehicle element in vehicle element 2 may be matched with other specific vehicle elements in vehicle element 1. Therefore, a specific vehicle element may appear repeatedly in vehicle element 2.

[0189] 6) A specific vehicle element in vehicle element 2 and all vehicle elements 1 that match that vehicle element are the same vehicle.

[0190] 7) Vehicle element 1: Cloud A12345-02 / V1 / F1, due to a transfer of ownership on 2022-12-30, has a start and end date of [0001-01-01, 2022-12-29]. Vehicle element 2 after the transfer: Cloud A12345-02 / V1 / F2, has a start and end date of [2022-12-30, 9999-12-31]. Since the start and end dates of the two vehicle elements are different, they cannot be matched. Therefore, both vehicle elements Cloud A12345-02 / V1 / F1 and Cloud A12345-02 / V1 / F2 can only be matched with themselves separately.

[0191] S205, group the second vehicle elements based on the second effective vehicle element matching temporary table, and calculate the row number of the first vehicle element within the second vehicle element group to generate the second effective vehicle element matching row number temporary table.

[0192] in, Figure 7 Step 7: Group by vehicle element 2, calculate the row number of vehicle element 1 within the same vehicle element 2 group, and generate a temporary table of matching row numbers for the second valid vehicle element.

[0193] The grouping criteria are: ① License plate number of vehicle element 2. ② License plate type of vehicle element 2. ③ VIN code of vehicle element 2. ④ Vehicle identification number (VIN) of vehicle element 2. ⑤ Start date of vehicle element 2. ⑥ End date of vehicle element 2.

[0194] The sorting rules for the group numbers are as follows: ① Start date of vehicle element 1, descending order, with later dates listed first, because a later start date may indicate a newer, more specific, and more accurate vehicle element. ② Warranty start date of vehicle element 1, descending order, with later dates listed first, because a later warranty start date may indicate a newer, more specific, and more accurate vehicle element. ③ License plate number of vehicle element 1, descending order, with later dates listed first, because official license plate numbers (e.g., Yun A12345) are greater than temporary license plate numbers (e.g., 12345678, Yun 123456). ④ License plate type of vehicle element 1. ⑤ VIN code of vehicle element 1. ⑥ Vehicle identification number (VIN) of vehicle element 1.

[0195] Preferably, the row number within a group can be calculated using the window function row_number of the database system.

[0196] The results are shown in Table 14:

[0197] Table 14

[0198]

[0199] S206, extract valid second vehicle elements from the second valid vehicle element matching temporary table, and select the priority valid attribute ID of the first vehicle element in the first row of the valid second vehicle element group as the temporary vehicle ID based on the order of the second valid vehicle element matching row number temporary table, so as to generate a temporary vehicle ID temporary table for valid vehicle elements; wherein, the valid attribute ID includes valid license plate ID, valid VIN code ID and valid vehicle frame number ID; the priority valid attribute ID refers to: selecting the first valid attribute ID in the order of the three attribute IDs of license plate ID, VIN code ID and vehicle frame number ID.

[0200] in, Figure 7 Step 8 involves extracting the unique valid vehicle element 2 and generating a temporary table for valid vehicle element 2. These valid vehicle elements are the vehicle elements for which valid vehicle IDs can be calculated.

[0201] For example, the attributes of vehicle element 2 are extracted repeatedly from the temporary table of the second valid vehicle element.

[0202] Specifically, the results are shown in Table 15:

[0203] Table 15

[0204] Vehicle elements Vehicle element start date 2 Vehicle element expiration date 2 Cloud A12345-02 / V1 / F1 0001-01-01 2022-12-29 Cloud A12345-02 / V1 / F2 2022-12-30 9999-12-31 New car not yet registered - 02 / V3 / F3 0001-01-01 9999-12-31 Cloud A54321-02 / V3 / F3 0001-01-01 9999-12-31

[0205] in, Figure 7 Step 9: Calculate the vehicle ID of vehicle element 2 using the first row of vehicle element 1 within the vehicle element 2 group. Then, sequentially select one of the valid license plate ID, valid VIN code ID, or valid vehicle identification number ID from the first row of vehicle element 1 as a temporary vehicle ID. Generate a temporary table of temporary vehicle IDs for the second valid vehicle element group. This table contains temporary vehicle IDs for valid vehicle elements but not for invalid vehicle elements, as shown in Table 16.

[0206] Table 16

[0207]

[0208] S207, group the temporary vehicle IDs, calculate the sequence number of the valid vehicle element in the same temporary vehicle ID group based on the temporary table of valid vehicle element temporary vehicle IDs, and use the sequence number as the number of valid vehicle element lots to generate a temporary table of valid vehicle element lots.

[0209] in, Figure 7 Step 10: Group by temporary vehicle ID and calculate the valid vehicle elements within the same temporary vehicle ID.

[0210] The sequence number in the group is used as the valid vehicle element trading volume to generate a temporary table of valid vehicle element trading volumes. The grouping criteria are: ① Temporary vehicle ID type. ② Temporary vehicle ID.

[0211] The sorting rule within the group is: vehicle element start date, ascending order, with earlier ones listed first, because the earlier the vehicle element start date, the smaller the number of transactions.

[0212] For example, the dense_rank function of the database system can be used to calculate the indices within a group (closely ordered, possibly tandem).

[0213] The results are shown in Table 17:

[0214] Table 17

[0215] Vehicle elements Vehicle element start date Vehicle element expiration date Vehicle element lot Cloud A12345-02 / V1 / F1 0001-01-01 2022-12-29 1 Cloud A12345-02 / V1 / F2 2022-12-30 9999-12-31 2 New car not yet registered - 02 / V3 / F3 0001-01-01 9999-12-31 1 Cloud A54321-02 / V3 / F3 0001-01-01 9999-12-31 1

[0216] S208, based on the temporary table of valid vehicle element counts, add the valid vehicle element counts to the end of the temporary vehicle ID, so that the obtained second vehicle element vehicle ID is used as the valid vehicle element vehicle ID result.

[0217] in, Figure 7 Step 11: Add vehicle element hand count to the end of the temporary vehicle ID to generate a temporary table of valid vehicle element vehicle IDs, and obtain the final result of calculating vehicle IDs, which includes vehicle IDs of valid vehicle elements and does not include vehicle IDs of invalid vehicle elements.

[0218] The results are shown in Table 18:

[0219] Table 18

[0220]

[0221] The application in this embodiment of the invention can assume that the policy list table is PolicyList and the temporary table of valid vehicle element vehicle ID is temp_ValidVehicleId. Then, the vehicle ID can be queried based on the policy license plate, VIN code, vehicle identification number, and insurance start date.

[0222] The vehicle ID calculation method based on vehicle elements in this invention, in application scenario B, calculates vehicle IDs for valid vehicle elements. When counting vehicles and establishing policy renewal relationships, the vehicle IDs can be directly used to accurately and efficiently remove duplicates and establish policy renewal relationships, thus fundamentally solving the problems of statistical accuracy and statistical program complexity. Special handling is applied to vehicle transfers, as the vehicle ID is related to the vehicle transfer details.

[0223] To implement the above embodiments, this invention also proposes a vehicle ID calculation system based on vehicle elements, such as... Figure 8 As shown, the system 10 includes:

[0224] The effective vehicle element generation module 100 is used to generate a temporary table of vehicle elements based on the vehicle element list extracted from the insurance policy list, and to generate a temporary table of vehicle element validity based on the validity judgment results of the element attributes in the temporary table of vehicle elements, so as to calculate the element attribute ID based on the temporary table of vehicle element validity to generate a temporary table of effective vehicle elements.

[0225] The effective vehicle element matching module 200 is used to establish a matching relationship between the first vehicle element and the second vehicle element based on the first state data of the vehicle and the first judgment result of the first vehicle element and the second vehicle element based on the effective vehicle element temporary table to generate the first effective vehicle element matching temporary table; wherein, the first judgment result includes at least one element attribute of the first vehicle element and the second vehicle element being valid and the same.

[0226] The row number calculation module 300 is used to calculate the row number of the first vehicle element in the second vehicle element group based on the first effective vehicle element matching temporary table, so as to generate the first effective vehicle element matching row number temporary table.

[0227] The valid vehicle element vehicle ID calculation module 400 is used to extract valid second vehicle elements from the first valid vehicle element matching temporary table to generate a valid second vehicle element temporary table, and calculate the vehicle ID of the second vehicle element based on the valid second vehicle element temporary table and the first valid vehicle element matching row number temporary table, so as to use the obtained second vehicle element vehicle ID as the valid vehicle element vehicle ID result.

[0228] Optionally, the aforementioned effective vehicle element matching module 200 may be used for:

[0229] Extract the transfer record of valid VIN ID based on the vehicle's second status data and the temporary table of valid vehicle elements;

[0230] The start and end dates of valid vehicle elements are calculated based on the transfer records of valid VIN codes to generate a temporary table of start and end dates of valid vehicle elements.

[0231] A matching relationship between the first element and the second element is established based on the second judgment result of the first vehicle element and the second vehicle element in the temporary table of valid vehicle elements to generate a second temporary table of valid vehicle element matching; wherein, the second judgment result includes at least one element attribute of the first vehicle element and the second vehicle element being valid and the same, and the start and end date ranges of the vehicle elements being the same.

[0232] Optionally, the above-mentioned row number calculation module 300 within the group may be used for:

[0233] The second vehicle elements are grouped based on the second effective vehicle element matching temporary table, and the row number of the first vehicle element within the second vehicle element group is calculated to generate the second effective vehicle element matching row number temporary table.

[0234] Optionally, the above-mentioned valid vehicle element vehicle ID calculation module 400 may be used for:

[0235] Valid second vehicle elements are extracted from the second valid vehicle element matching temporary table, and the priority valid attribute ID of the first vehicle element in the first row of the valid second vehicle element group is selected as the temporary vehicle ID based on the order of the second valid vehicle element matching row number temporary table to generate a temporary vehicle ID temporary table for valid vehicle elements; wherein, the valid attribute ID includes valid license plate ID, valid VIN code ID, and valid vehicle identification number ID; the priority valid attribute ID is: the first valid attribute ID is selected in the order of the three attribute IDs of license plate ID, VIN code ID, and vehicle identification number ID;

[0236] Group temporary vehicle IDs;

[0237] Based on the temporary vehicle ID table of valid vehicle elements, the sequence number of valid vehicle elements in the same temporary vehicle ID group is calculated, and the sequence number is used as the number of valid vehicle element lots to generate a temporary table of valid vehicle element lots.

[0238] Based on the temporary table of valid vehicle element lots, the valid vehicle element lots are appended to the end of the temporary vehicle ID, so that the resulting second vehicle element vehicle ID is used as the valid vehicle element vehicle ID result.

[0239] It should be noted that the foregoing explanation of the vehicle ID calculation method based on vehicle elements also applies to the vehicle ID calculation system based on vehicle elements in this embodiment, and will not be repeated here.

[0240] In summary, the vehicle ID calculation system based on vehicle elements of this invention calculates and generates unique vehicle IDs based on vehicle elements, which are used to accurately and efficiently remove duplicate vehicle counts and establish policy renewal relationships, fundamentally solving the problems of accuracy of statistical results and complexity of statistical procedures.

[0241] To implement the above embodiments, this invention also proposes a computer program product that, when executed by an instruction processor, implements the vehicle ID calculation method based on vehicle elements as described in the foregoing method embodiments.

[0242] The computer program product of this invention fully utilizes the parallel processing performance of distributed databases in its data structure and program, enabling efficient calculation of massive amounts of data and implementation of various functions; at the same time, the data structure and program are universal and easily scalable, effectively reducing operation and maintenance costs and development and adjustment costs.

[0243] In the description of this invention, it should be understood that the terms "center," "longitudinal," "lateral," "length," "width," "thickness," "upper," "lower," "front," "rear," "left," "right," "vertical," "horizontal," "top," "bottom," "inner," "outer," "clockwise," "counterclockwise," "axial," "radial," and "circumferential" indicate the orientation or positional relationship based on the orientation or positional relationship shown in the accompanying drawings. They are used only for the convenience of describing this invention and simplifying the description, and are not intended to indicate or imply that the device or element referred to must have a specific orientation, or be constructed and operated in a specific orientation. Therefore, they should not be construed as limitations on this invention.

[0244] Furthermore, the terms "first" and "second" are used for descriptive purposes only and should not be construed as indicating or implying relative importance or implicitly specifying the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one of that feature. In the description of this invention, "a plurality of" means at least two, such as two, three, etc., unless otherwise explicitly specified.

[0245] In this invention, unless otherwise explicitly specified and limited, the terms "installation," "connection," "linking," and "fixing," etc., should be interpreted broadly. For example, they can refer to a fixed connection, a detachable connection, or an integral part; they can refer to a mechanical connection or an electrical connection; they can refer to a direct connection or an indirect connection through an intermediate medium; they can refer to the internal communication of two components or the interaction between two components, unless otherwise explicitly limited. Those skilled in the art can understand the specific meaning of the above terms in this invention according to the specific circumstances.

[0246] In this invention, unless otherwise explicitly specified and limited, "above" or "below" the second feature can mean that the first feature is in direct contact with the second feature, or that the first feature is in indirect contact with the second feature through an intermediate medium. Furthermore, "above," "over," and "on top" of the second feature can mean that the first feature is directly above or diagonally above the second feature, or simply that the first feature is at a higher horizontal level than the second feature. "Below," "below," and "under" the second feature can mean that the first feature is directly below or diagonally below the second feature, or simply that the first feature is at a lower horizontal level than the second feature.

[0247] In the description of this specification, the references to terms such as "one embodiment," "some embodiments," "example," "specific example," or "some examples," etc., indicate that a specific feature, structure, material, or characteristic described in connection with that embodiment or example is included in at least one embodiment or example of the present invention. In this specification, the illustrative expressions of the above terms do not necessarily refer to the same embodiment or example. Furthermore, the specific features, structures, materials, or characteristics described may be combined in any suitable manner in one or more embodiments or examples. Moreover, without contradiction, those skilled in the art can combine and integrate the different embodiments or examples described in this specification, as well as the features of different embodiments or examples.

[0248] Although embodiments of the present invention have been shown and described above, it is understood that the above embodiments are exemplary and should not be construed as limiting the present invention. Those skilled in the art can make changes, modifications, substitutions and variations to the above embodiments within the scope of the present invention.

Claims

1. A vehicle ID calculation method based on vehicle elements, characterized by, The method includes the following steps: A temporary table of vehicle elements is generated based on the vehicle element list extracted from the policy list, and a temporary table of vehicle element validity is generated based on the validity judgment results of the element attributes in the temporary table of vehicle elements. The element attribute ID is calculated based on the temporary table of vehicle element validity to generate a temporary table of valid vehicle elements. A matching relationship between the first vehicle element and the second vehicle element is established based on the first state data of the vehicle and the first judgment result of the first vehicle element and the second vehicle element based on the temporary table of effective vehicle elements to generate a temporary table of matching first effective vehicle elements; wherein, the first judgment result includes at least one element attribute of the first vehicle element and the second vehicle element being valid and the same. Based on the first valid vehicle element matching temporary table, calculate the row number of the first vehicle element in the second vehicle element group to generate the first valid vehicle element matching row number temporary table. Valid second vehicle elements are extracted from the first valid vehicle element matching temporary table to generate a valid second vehicle element temporary table. The vehicle ID of the second vehicle element is calculated based on the valid second vehicle element temporary table and the first valid vehicle element matching row number temporary table. The obtained second vehicle element vehicle ID is used as the valid vehicle element vehicle ID result. The transfer record of the valid VIN code ID is extracted based on the vehicle's second state data and the temporary table of valid vehicle elements; The start and end dates of valid vehicle elements are calculated based on the transfer records of valid VIN codes to generate a temporary table of start and end dates of valid vehicle elements. Based on the second judgment result of the first vehicle element and the second vehicle element in the temporary table of valid vehicle elements and the temporary table of start and end dates of valid vehicle elements, a matching relationship between the first vehicle element and the second vehicle element is established to generate a second temporary table of valid vehicle element matching; wherein, the second judgment result includes that at least one element attribute of the first vehicle element and the second vehicle element is valid and the same, and the start and end date range of the vehicle elements is the same. The second vehicle elements are grouped based on the second effective vehicle element matching temporary table, and the row number of the first vehicle element within the second vehicle element group is calculated to generate the second effective vehicle element matching row number temporary table. Valid second vehicle elements are extracted from the second valid vehicle element matching temporary table, and the priority valid attribute ID of the first vehicle element in the first row of the valid second vehicle element group is selected as the temporary vehicle ID based on the order of the second valid vehicle element matching row number temporary table to generate a temporary vehicle ID table for valid vehicle elements; wherein, the valid attribute ID includes valid license plate ID, valid VIN code ID, and valid vehicle identification number ID; the priority valid attribute ID is: the first valid attribute ID is selected according to the order of the three attribute IDs, namely license plate ID, VIN code ID, and vehicle identification number ID.

2. The method of claim 1, wherein, The attribute elements include multiple types of license plate, VIN code, and vehicle identification number; wherein, the license plate includes license plate number and license plate type; the validity judgment results of the attribute elements in the temporary table of vehicle elements include the validity judgment results of license plate, VIN code, and vehicle identification number.

3. The method of claim 2, wherein, Determining the validity of a license plate includes: Check if the license plate number or license plate type is null; if yes, determine the license plate is invalid; otherwise, Determine if the license plate number contains special characters; if so, the license plate is invalid; otherwise, Determine if the length of the license plate number is less than a first preset threshold; if yes, the license plate is deemed invalid; otherwise, the license plate is deemed valid.

4. The method of claim 2, wherein, Before determining the validity of the VIN code, the method further includes: Initialize VIN code related data to obtain VIN code initialization result; wherein, the VIN code related data includes VIN code character value, VIN code character position weight and check character corresponding to VIN code check value; Calculate the weighted total of the VIN code character values ​​based on the VIN code initialization result, and calculate the VIN code check value based on the weighted total of the VIN code character values; Find the check character corresponding to the VIN code check value.

5. The method according to claim 2, characterized in that, Determining the validity of a VIN code includes: Check if the VIN code is null. If it is, determine that the VIN code is invalid; otherwise, check if it is null. Determine if the VIN code length is not equal to the second preset threshold. If yes, determine that the VIN code is invalid; otherwise, determine if the VIN code is invalid. Calculate the check character of the VIN code, and compare the check character of the VIN code with the ninth character of the VIN code. If they are the same, the VIN code is qualified and the VIN code is determined to be valid; if they are different, the VIN code is unqualified and the VIN code is determined to be invalid.

6. The method according to claim 1, characterized in that, After generating a temporary table of valid vehicle IDs, the method further includes: Group the temporary vehicle IDs; Based on the temporary vehicle ID table of the effective vehicle elements, the sequence number of the effective vehicle elements in the same temporary vehicle ID group is calculated, and the sequence number is used as the number of effective vehicle elements to generate a temporary table of effective vehicle element numbers. Based on the temporary table of valid vehicle element counts, the valid vehicle element counts are appended to the end of the temporary vehicle ID, so that the resulting second vehicle element vehicle ID is used as the valid vehicle element vehicle ID result.

7. A vehicle ID calculation system based on vehicle elements, characterized in that, include: The effective vehicle element generation module is used to generate a temporary vehicle element table based on the vehicle element list extracted from the insurance policy list, and to generate a temporary vehicle element validity table based on the validity judgment results of the element attributes in the temporary vehicle element table, so as to calculate the element attribute ID according to the temporary vehicle element validity table to generate a temporary effective vehicle element table. The effective vehicle element matching module is used to establish a matching relationship between the first vehicle element and the second vehicle element based on the first state data of the vehicle and the first judgment result of the first vehicle element and the second vehicle element based on the effective vehicle element temporary table to generate a first effective vehicle element matching temporary table; wherein, the first judgment result includes at least one element attribute of the first vehicle element and the second vehicle element being valid and the same. The effective vehicle element matching module is further configured to extract transfer records of valid VIN IDs based on the vehicle's second status data and the effective vehicle element temporary table; calculate the start and end dates of effective vehicle elements based on the transfer records of valid VIN IDs to generate a temporary table of effective vehicle element start and end dates; and establish a matching relationship between the first element and the second element based on the second judgment result of the first vehicle element and the second vehicle element in the effective vehicle element temporary table to generate a second effective vehicle element matching temporary table; wherein, the second judgment result includes at least one element attribute of the first vehicle element and the second vehicle element being valid and identical, and the start and end date ranges of the vehicle elements being identical. The row number calculation module within the group is used to calculate the row number of the first vehicle element within the second vehicle element group based on the first effective vehicle element matching temporary table, so as to generate the first effective vehicle element matching row number temporary table. The row number calculation module within the group is also used to group the second vehicle elements based on the second effective vehicle element matching temporary table, and calculate the row number of the first vehicle element within the second vehicle element group to generate the second effective vehicle element matching row number temporary table. The effective vehicle element vehicle ID calculation module is used to extract effective second vehicle elements from the first effective vehicle element matching temporary table to generate an effective second vehicle element temporary table, and calculate the vehicle ID of the second vehicle element based on the effective second vehicle element temporary table and the first effective vehicle element matching row number temporary table, so as to use the obtained second vehicle element vehicle ID as the effective vehicle element vehicle ID result. The valid vehicle element vehicle ID calculation module is further configured to extract valid second vehicle elements from the second valid vehicle element matching temporary table, and select the priority valid attribute ID of the first vehicle element in the first row of the valid second vehicle element group as a temporary vehicle ID based on the order of the second valid vehicle element matching row number temporary table, so as to generate a valid vehicle element temporary vehicle ID temporary table; wherein, the valid attribute ID includes valid license plate ID, valid VIN code ID, and valid vehicle identification number ID; the priority valid attribute ID is: the first valid attribute ID is selected according to the order of the three attribute IDs: license plate ID, VIN code ID, and vehicle identification number ID; The effective vehicle element vehicle ID calculation module is further configured to group the temporary vehicle IDs; calculate the sequence number of the effective vehicle element in the same temporary vehicle ID group based on the temporary table of effective vehicle element temporary vehicle IDs, and use the sequence number as the effective vehicle element lot number to generate a temporary table of effective vehicle element lot numbers; add the effective vehicle element lot number to the end of the temporary vehicle ID based on the temporary table of effective vehicle element lot numbers, so as to use the obtained second vehicle element vehicle ID as the effective vehicle element vehicle ID result.

8. A computer program product, characterized in that, When the instruction processor in the computer program product executes, it implements the vehicle ID calculation method based on vehicle elements as described in any one of claims 1-6.

Images