A method, system and electronic device for monitoring vehicle insurance renewal data
Through incremental technology monitoring of auto insurance renewal data, the problems of long-term calculation of auto insurance renewal rate and high resource consumption in the existing technology are solved, efficient and accurate renewal rate calculation is achieved, and data update timeliness is improved.
Patent Information
- Application Number
- CN202310115623.2
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2023-02-08
- Publication Date
- 2024-11-08
- Estimated Expiration
- 2043-02-08
AI Technical Summary
The existing auto insurance renewal rate calculation model is due to the large amount of data and complex calculations, which consumes time and resources. It cannot support multi-dimensional and high-frequency fine-grained updates, and the data quality is not high, which affects the accuracy and efficiency of calculations.
Use incremental technology to monitor auto insurance renewal data. By obtaining the data in the policy information table and vehicle information table, the new renewal and renewal policy data are determined, and the renewal relationship table is updated based on preset rules to achieve real-time monitoring and reduce Resource usage improves the timeliness of data updates.
It improves the monitoring efficiency and calculation accuracy of auto insurance renewal data, reduces resource consumption, realizes daily updates under fine-grained size, and improves the calculation efficiency and accuracy of renewal rates.
Smart Images

Figure CN116012173B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of insurance data statistical analysis, and in particular to a method, system and electronic equipment for monitoring vehicle insurance renewal data based on incremental technology. Background Art
[0002] Renewal business refers to the business of continuing to pay premiums and extending insurance liability to the next insurance period for the same insurance subject after the insurance expires, that is, the business of continuously underwriting the same subject. Renewal capacity reflects the ability of an insurance company to retain existing customers and business, and is a reflection of the core competitiveness of an insurance company. Generally speaking, for property insurance companies, the business with the highest proportion is vehicle insurance, and the insurance subject is the insured vehicle. The large base of renewal business can effectively alleviate the company's development pressure of new business. The high quality of renewal business can promote the achievement of efficiency indicators. The low cost of renewal business can significantly reduce the company's auto insurance operating costs. By increasing the vehicle renewal rate, the ability to select high-quality business and the overall business quality can be improved, so that the operating efficiency of the insurance company's auto insurance business can be generally improved. This is an important way for property insurance companies to improve their operating efficiency.
[0003] The vehicle renewal rate specifically refers to the ratio of the number of vehicles that have been renewed during the statistical period to the number of vehicles that should be renewed. The calculation formula is: renewal rate = number of vehicles renewed during the statistical period / number of vehicles that should be renewed during the statistical period * 100%. The existing solution adopts a full calculation mode, which calculates the renewal relationship of all policies after a certain year every month, and calculates the vehicle renewal rate of each institution, vehicle type, and CIRC classification. Figure 1 The figure shows the overall process of auto insurance renewal rate analysis. The policy information table and vehicle information table are sent to DWD (datawarehousedetail) through ODS (OperationalDataStore), and the [Termination Policy Information Table] and [Renewal Relationship Table] are generated from DWD. DWS (datawarehouse service) calculates the renewal quantity and the number of policies to be renewed. The data flows into APP (Application) to obtain relevant data and calculate the renewal rate index as needed.
[0004] This method has the following problems:
[0005] (1) The amount of basic data involved in the calculation, such as vehicle information and insurance information, is too large, the calculation takes a long time, and the database computing power and temporary storage space are limited, which cannot support multi-dimensional, fine-grained, and high-frequency renewal rate indicator updates.
[0006] (2) High computing volume and daily timeliness requirements lead to large consumption of cluster CPU (central processing unit) and memory resources, affecting the timely update of other tasks.
[0007] (3) When a task exception occurs, the calculation process is complex and has many steps, which makes it difficult to locate the problem and takes a long time to recover the data.
[0008] (4) The basic data such as vehicle information and underwriting information involved in the calculation of the renewal rate index have not been completely cleaned, and the data quality is not high enough.
[0009] Based on the above problems, there is an urgent need for a motor vehicle insurance renewal data monitoring method to improve the calculation accuracy and efficiency of the renewal rate. Summary of the invention
[0010] The purpose of the present invention is to provide a method, system and electronic equipment for monitoring motor vehicle insurance renewal data, which can improve the monitoring efficiency of motor vehicle insurance renewal data and improve the calculation accuracy and efficiency of renewal rate.
[0011] To achieve the above object, the present invention provides the following solutions:
[0012] A method for monitoring vehicle insurance renewal data, comprising:
[0013] Acquire data in the policy information table, renewal relationship table and vehicle information table according to a set time period; the policy information table stores multiple groups of policy data, each group of policy data includes the policy application number, policy number, policy start date and policy end date; the renewal relationship table stores multiple groups of renewal data, each group of renewal data includes the new renewal policy number, the renewed policy number, the new renewal policy application number, the renewed policy application number, the new renewal policy start date, the renewed policy start date, the new renewal policy end date and the renewed policy end date; the vehicle information table stores multiple groups of vehicle data, each group of vehicle data includes the policy application number and vehicle parameters;
[0014] Obtaining the policy data whose policy start date is within the statistical date range from the policy information table to obtain the new policy data;
[0015] Determine new renewal policy data according to the new initiation policy data, the renewal data in the renewal relationship table and the vehicle data in the vehicle information table, and store the new renewal policy data in the incremental initiation policy table;
[0016] Obtaining the policy data whose policy expiration date is within the statistical date range from the policy information table to obtain the policy expiration data;
[0017] Determine the policy data to be renewed based on the final insurance policy data, the vehicle data in the vehicle information table and the new renewal policy data in the incremental initial insurance policy table, and store the renewed policy data in the incremental final insurance policy table;
[0018] Based on pre-set renewal rules, incremental renewal policy data is determined according to the incremental initial insurance policy table and the incremental final insurance policy table, and the incremental renewal policy data is stored in the renewal relationship table to monitor the motor vehicle insurance renewal data in real time.
[0019] Optionally, the new renewal policy data includes the insurance application number, policy number, policy start date, policy end date and vehicle parameters; the renewed policy data includes the insurance application number, policy number, policy start date, policy end date and vehicle parameters.
[0020] Optionally, determining new renewal policy data according to the new insurance policy data, the renewal data in the renewal relationship table and the vehicle data in the vehicle information table specifically includes:
[0021] Determine whether there is a renewal data in the renewal relationship table with a new renewal policy number that is the same as the policy number of the new starting policy data; if not, query the vehicle data with the same insurance policy number as the insurance policy number of the new starting policy data from the vehicle information table to obtain the starting vehicle data;
[0022] New renewal policy data is determined based on the insured vehicle data and the new insured policy data.
[0023] Optionally, determining the policy data to be renewed according to the final insurance policy data, the vehicle data in the vehicle information table and the new renewal policy data in the incremental insurance policy table specifically includes:
[0024] Searching the vehicle information table for vehicle data whose insurance policy number is the same as the insurance policy number of the final insurance policy data to obtain the final insurance vehicle data;
[0025] Determine whether there is new renewal policy data in the incremental insurance policy table whose vehicle parameters are the same as those of the final insurance vehicle data. If so, determine the renewed policy data based on the final insurance vehicle data and the final insurance policy data.
[0026] Optionally, the vehicle parameters include license plate number, license plate type, VIN code and vehicle frame number.
[0027] Optionally, based on a preset renewal rule, the incremental renewal policy data is determined according to the incremental initial insurance policy table and the incremental final insurance policy table, specifically including:
[0028] For any set of new renewal policy data in the incremental starting policy table, query the incremental ending policy table for the renewed policy data whose vehicle parameters are the same as those of the new renewal policy data, and obtain the renewed policy data corresponding to the new renewal policy data;
[0029] Determine whether the difference between the policy start date of the new renewal policy data and the policy expiration date of the corresponding renewed policy data is within a set time period, and whether the difference between the policy start date of the new renewal policy data and the policy start date of the corresponding renewed policy data is greater than a set interval number of days, and the difference between the policy start date of the new renewal policy data and the policy expiration date of the new renewal policy data is greater than a set number of long-term days, and the difference between the policy start date of the corresponding renewed policy data and the policy expiration date of the corresponding renewed policy data is greater than a set number of long-term days. If so, determine the incremental renewal policy data based on the new renewal policy data and the corresponding renewed policy data.
[0030] Optionally, each set of insurance policy data further includes insurance type; the insurance type is automobile insurance or personal insurance;
[0031] Obtain the policy data whose policy start date is within the statistical date range from the policy information table to obtain the new policy data, specifically including:
[0032] Obtain the policy data of the policy starting date within the statistical date range and the insurance type of motor vehicle insurance from the policy information table to obtain the new starting policy data.
[0033] Optionally, each set of insurance policy data further includes an insurance policy underwriting flag; the insurance policy underwriting flag is passed or failed;
[0034] Obtain the policy data whose policy start date is within the statistical date range from the policy information table to obtain the new policy data, specifically including:
[0035] Obtain the policy data from the policy information table, whose policy start date is within the statistical date range and whose policy underwriting is indicated as passed, to obtain new policy data.
[0036] To achieve the above object, the present invention also provides the following solution:
[0037] A motor vehicle insurance renewal data monitoring system, comprising:
[0038] A data acquisition unit is used to acquire data in a policy information table, a renewal relationship table and a vehicle information table according to a set time period; the policy information table stores multiple groups of policy data, each group of policy data includes an application number, a policy number, a policy start date and a policy end date; the renewal relationship table stores multiple groups of renewal data, each group of renewal data includes a new renewal policy number, a renewed policy number, a new renewal application number, a renewed application number, a new renewal policy start date, a renewed policy start date, a new renewal policy end date and a renewed policy end date; the vehicle information table stores multiple groups of vehicle data, each group of vehicle data includes an application number and vehicle parameters;
[0039] A new insurance start data determination unit, connected to the data acquisition unit, for acquiring the insurance policy data whose insurance start date is within the statistical date range from the insurance policy information table to obtain the new insurance start policy data;
[0040] A new renewal data determination unit, connected to the data acquisition unit and the new insurance start data determination unit, respectively, for determining new insurance renewal policy data according to the new insurance start policy data, the renewal data in the renewal relationship table and the vehicle data in the vehicle information table, and storing the new insurance renewal policy data in the incremental insurance start policy table;
[0041] A termination data determination unit, connected to the data acquisition unit, is used to acquire the policy data whose policy termination date is within the statistical date range from the policy information table to obtain the termination policy data;
[0042] The insured data determination unit is connected to the data acquisition unit, the new insurance renewal data determination unit and the final insurance data determination unit respectively, and is used to determine the insured policy data to be renewed according to the final insurance policy data, the vehicle data in the vehicle information table and the new insurance renewal policy data in the incremental insurance policy table, and store the insured policy data to the incremental final insurance policy table;
[0043] The incremental renewal determination unit is connected to the new renewal data determination unit and the renewed data determination unit respectively, and is used to determine the incremental renewal policy data based on the pre-set renewal rules, according to the incremental starting policy table and the incremental ending policy table, and store the incremental renewal policy data in the renewal relationship table, so as to monitor the motor vehicle insurance renewal data in real time.
[0044] To achieve the above object, the present invention also provides the following solution:
[0045] An electronic device includes a memory and a processor, wherein the memory is used to store a computer program, and the processor runs the computer program to enable the electronic device to execute the above-mentioned vehicle insurance renewal data monitoring method.
[0046] According to the specific embodiments provided by the present invention, the present invention discloses the following technical effects:
[0047] The present invention monitors the renewal data of motor vehicle insurance in an incremental manner. First, the policy data whose policy start date or policy end date is within the statistical date range are obtained from the policy information table to obtain new start policy data and end policy data. Then, the new renewal policy data is determined according to the new start policy data, the renewal data in the renewal relationship table and the vehicle data in the vehicle information table, and stored in the incremental start policy table. The renewed policy data is determined according to the end policy data, the vehicle data in the vehicle information table and the new renewal policy data in the incremental start policy table, and stored in the incremental end policy table. Finally, based on the preset renewal rules, the incremental renewal policy data is determined according to the incremental start policy table and the incremental end policy table, and stored in the renewal relationship table. Incremental data monitoring of large data volume and complex logical indicators is realized. While realizing the daily update of renewal data at a fine granularity, the use of resources is reduced, and the timeliness of data update is improved, that is, the detection efficiency of motor vehicle insurance renewal data is improved, thereby improving the accuracy and efficiency of subsequent renewal rate calculation. BRIEF DESCRIPTION OF THE DRAWINGS
[0048] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.
[0049] Figure 1 It is a schematic diagram of the overall process of analyzing the renewal rate of motor insurance in the prior art;
[0050] Figure 2 This is a flow chart of the method for monitoring the renewal data of automobile insurance of the present invention;
[0051] Figure 3 This is a schematic diagram of the overall architecture of the renewal rate analysis process;
[0052] Figure 4 This is a schematic diagram of the overall architecture of the renewal rate analysis process and a module diagram of the system.
[0053] Explanation of symbols:
[0054] Data acquisition unit-1, new insurance start data determination unit-2, new insurance renewal data determination unit-3, insurance termination data determination unit-4, insurance renewal data determination unit-5, incremental insurance renewal determination unit-6. DETAILED DESCRIPTION
[0055] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.
[0056] The purpose of the present invention is to provide a method, system and electronic device for monitoring auto insurance renewal data, establish auto insurance renewal rules around the core renewal rate algorithm, improve the process of auto insurance data monitoring, integrate the processes of data synchronization, cleaning, calculation and presentation, and combine multiple statistical dimensions and application scenarios, so that the renewal rate core algorithm and the supporting auto insurance data monitoring method can meet the statistical analysis of complex renewal rates in the TB order of magnitude and multiple dimensions updated daily, and ultimately provide users with multi-dimensional renewal rate analysis services.
[0057] In order to make the above-mentioned objects, features and advantages of the present invention more obvious and easy to understand, the present invention is further described in detail below with reference to the accompanying drawings and specific embodiments.
[0058] Embodiment 1
[0059] like Figure 2 As shown, this embodiment provides a method for monitoring auto insurance renewal data, including:
[0060] S1: Acquire data in the policy information table, renewal relationship table, and vehicle information table according to a set time period. The set time period may be one day, that is, acquire data in the policy information table, renewal relationship table, and vehicle information table every day.
[0061] The policy information table stores multiple sets of policy data, each set of policy data includes the policy number, policy number, policy start date and policy end date. In addition, each set of policy data also includes the district agency code.
[0062] The renewal relationship table stores multiple groups of renewal data, each group of renewal data includes the new renewal policy number, the renewed policy number, the new renewal application number, the renewed application number, the new renewal policy start date, the renewed policy start date, the new renewal policy end date and the renewed policy end date.
[0063] The vehicle information table stores multiple sets of vehicle data, each set of vehicle data includes an insurance policy number and vehicle parameters, including license plate number, license plate type, VIN code and vehicle frame number.
[0064] The data source involved in the present invention is the massive policy data and vehicle data involved in the renewal rate calculation, which are reflected in the policy information table and the vehicle information table. All data tables are stored in the database.
[0065] In this embodiment, the data source is first synchronized to the data computing platform GBase. Connect to the data source through the dbaccess unload tool, unload the data into unl files, and then import the data into the GBase library through the gbaseload tool for subsequent calculations. To ensure the effectiveness of data synchronization, before data synchronization, first attempt to connect to the source library to determine whether the source library can be connected. After the data is synchronized to GBase, the logarithm program is automatically scheduled to compare the data volumes before and after synchronization to ensure that there is no omission of data. A full-scale synchronization is performed once a week to ensure the integrity of the data.
[0066] After obtaining the data, first clean the dirty data in the vehicle data, remove the dirty data that does not meet the specifications, improve the calculation accuracy of the renewal rate index, and ensure the availability of the data. Specifically, it includes:
[0067] (1)剔除车辆数据,其中车牌号条件包括:车牌号长度≥8(一个汉字长度计为2);车牌号中不包含“未”、“无”、“暂”、“新车”、“过户”字样;同一车牌号在同一年起保的长期单小于或等于2条或短期单小于或等于6条。
[0068] (2)剔除车辆数据,其中VIN条件包括:长度=17位;同一VIN码在同一年起保的长期单小于或等于2条或短期单小于或等于6条。
[0069] (3)剔除车辆数据,其中车架号条件包括:长度=17位;同一车架号在同一年起保的长期单小于或等于2条或短期单小于或等于6条。
[0070] S2: Obtain the policy data with the policy start date within the statistical date range from the policy information table to obtain the newly started policy data.
[0071] To further improve the monitoring efficiency of auto insurance renewal data, each group of policy data also includes the type of insurance. The type of insurance is auto insurance or personal insurance. Auto insurance is further divided into commercial insurance and compulsory insurance. The types of insurance in the present invention may also include other types of insurance, not limited to auto insurance and personal insurance. S2 specifically includes: Obtain the policy data with the policy start date within the statistical date range and the type of insurance being auto insurance from the policy information table to obtain the newly started policy data.
[0072] Furthermore, each group of policy data also includes the policy underwriting flag and the policy underwriting completion time. The policy underwriting flag is passed or not passed. S2 specifically includes: Obtain the policy data with the policy start date within the statistical date range and the policy underwriting indication being passed from the policy information table to obtain the newly started policy data.
[0073] In addition, the insurance type and policy underwriting identifiers may exist at the same time, in which case S2 includes: obtaining from the policy information table the policy data whose policy start date is within the statistical date range and whose insurance type is auto insurance, and whose policy underwriting is indicated as passed, and obtaining new policy data.
[0074] S3: Determine new renewal policy data based on the new policy data, the renewal data in the renewal relationship table, and the vehicle data in the vehicle information table, and store the new renewal policy data in the incremental policy table. Specifically, the new renewal policy data includes the application number, policy number, policy start date, policy end date, and vehicle parameters.
[0075] Furthermore, S3 specifically includes:
[0076] Determine whether there is a renewal data in the renewal relationship table whose new renewal policy number is the same as the policy number of the new starting policy data. If not, query the vehicle data whose insurance application number is the same as the insurance application number of the new starting policy data from the vehicle information table to obtain the starting vehicle data. Determine the new renewal policy data based on the starting vehicle data and the new starting policy data.
[0077] If there is renewal data in the renewal relationship table whose new renewal policy number is the same as the policy number of the newly initiated policy data, it means that the new renewal policy number is not a new policy added within the current statistical date range and will not participate in subsequent data processing to reduce the processing of redundant data and further improve monitoring efficiency.
[0078] S4: Obtain the policy data whose policy expiration date is within the statistical date range from the policy information table to obtain the policy expiration data.
[0079] S5: Determine the policy data to be renewed based on the final policy data, the vehicle data in the vehicle information table, and the new policy data in the incremental policy table, and store the policy data to be renewed in the incremental final policy table. Specifically, the policy data to be renewed includes the application number, policy number, policy start date, policy end date, and vehicle parameters.
[0080] Furthermore, S5 specifically includes:
[0081] The vehicle data whose insurance policy number is the same as the insurance policy number of the final insurance policy data is searched from the vehicle information table to obtain the final insurance vehicle data.
[0082] Determine whether there is new renewal policy data in the incremental policy table whose vehicle parameters are the same as those of the final policy data. If so, determine the policy data to be renewed based on the final policy data and the final policy data. Specifically, since vehicle parameters include license plate number, VIN code and frame number, as long as any one of the conditions (license plate number, VIN code or frame number) matches, it can be determined that the vehicle parameters are the same.
[0083] S6: Based on the pre-set renewal rules, the incremental renewal policy data is determined according to the incremental initial insurance policy table and the incremental final insurance policy table, and the incremental renewal policy data is stored in the renewal relationship table to monitor the motor vehicle insurance renewal data in real time.
[0084] Furthermore, S6 specifically includes:
[0085] For any set of new renewal policy data in the incremental starting policy table, query the renewed policy data whose vehicle parameters are the same as the vehicle parameters of the new renewal policy data from the incremental ending policy table to obtain the renewed policy data corresponding to the new renewal policy data.
[0086] Determine whether the difference between the policy start date of the new renewal policy data and the policy expiration date of the corresponding renewed policy data is within a set time period, and whether the difference between the policy start date of the new renewal policy data and the policy start date of the corresponding renewed policy data is greater than a set interval number of days, and the difference between the policy start date of the new renewal policy data and the policy expiration date of the new renewal policy data is greater than a set number of long-term days, and the difference between the policy start date of the corresponding renewed policy data and the policy expiration date of the corresponding renewed policy data is greater than a set number of long-term days. If so, determine the incremental renewal policy data based on the new renewal policy data and the corresponding renewed policy data.
[0087] In this embodiment, the set time period is -90 days to 180 days, the interval days are 90 days, and the long-term single days are 365 days.
[0088] In order to better understand the solution of the present invention, the renewal rules set in this embodiment are introduced below by taking the overall car insurance as an example:
[0089] (1) Insurance policies that were insured and renewed during the statistical period.
[0090] (2) All policies are motor vehicle insurance policies.
[0091] (3) All policies are approved.
[0092] (4) The new policy is for the same vehicle as the policy being renewed, i.e. the vehicle parameters of the new policy data and the policy being renewed are the same: the VIN code is the same or the frame number is the same or the license plate number and the type of license plate are the same. Furthermore, when using the VIN code for judgment, the non-standard VIN codes are removed before judging whether the VIN codes are consistent, without considering whether the license plate and frame number are standard (the same applies when judging using other factors).
[0093] (5) -90 days <= the start date of the new policy - the end date of the policy being renewed <= 180 days. That is, the new policy shall start 90 days (inclusive) before the end date of the policy being renewed or 180 days (inclusive) after the end date of the policy being renewed.
[0094] (6) The starting date of the new policy - the starting date of the policy being renewed > 90 days.
[0095] (7) Both the newly renewed policy and the policy being renewed are long-term policies, i.e. the policy expiration date - policy commencement date + 1 >= 365 days, and mobility vehicles are excluded.
[0096] (8) The starting date of the new policy is greater than the starting date of the policy being renewed.
[0097] (9) Neither the newly renewed policies nor the policies being renewed contain any irregular data.
[0098] (10) If the business affiliation of the newly renewed policy and the policy being renewed belongs to the same county branch, it is considered as renewal within the county branch; if they belong to the same prefecture-level city (including the same county branch under the same prefecture-level city, or different county branches under the same prefecture-level city), it is considered as renewal within the prefecture-level city; if they belong to the same province (including the same prefecture-level city under the same province, or different prefecture-level cities under the same province), it is considered as renewal within the province. The business affiliation of the policy can be determined based on the sub-district agency code.
[0099] (11) The expiration date of the policy being renewed is between [start date of statistical period - 1] and [end date of statistical period - 1].
[0100] (12) Number of commercial insurance policies renewed: both the newly renewed policies and the policies being renewed are commercial insurance.
[0101] (13) Number of renewals of compulsory traffic insurance: both the new policy and the policy being renewed are for compulsory traffic insurance.
[0102] (14) Overall auto insurance renewal rules: If both compulsory traffic insurance and commercial insurance of the whole vehicle are renewed, the renewal number is counted as 1. The following rules are used to judge in order: A. The policy with the same major category as the newly renewed policy has priority. B. The policy with the earliest termination has priority. C. The policy with the largest policy number has priority. Only compulsory traffic insurance can be counted.
[0103] In addition, the final insurance policy information table can be generated through the incremental final insurance policy table. The incremental data (data in the incremental initial insurance policy table and the incremental final insurance policy table) can also be updated to the historical data base table.
[0104] The policy information table, vehicle information table, incremental starting policy table, incremental final policy table, renewal relationship table, and final policy information table involved in the present invention are all data tables. In order to better understand the solution of the present invention, the fields of each data table are comprehensively introduced below:
[0105] [Insurance Policy Information Table] fields: application number, policy number, policy start date, policy signing date, policy end date, district agency code, insurance type, policy underwriting identification, and policy underwriting completion time.
[0106] [Vehicle Information Table] Fields: insurance policy number, license plate number, license plate type, VIN code, frame number, and vehicle age.
[0107] [Incremental policy start] fields: application number, policy number, policy start date, policy signing date, policy end date, zone agency code, insurance type, license plate number, license plate type, VIN code, and vehicle frame number.
[0108] [Incremental Termination Policy] fields: application number, policy number, policy start date, policy signing date, policy termination date, zone agency code, insurance type, license plate number, license plate type, VIN code, and vehicle frame number.
[0109] [Renewal Relationship Table] fields: new renewal policy number, renewed policy number, new renewal application number, renewed application number, new renewal policy start date, renewed policy start date, new renewal policy end date, renewed policy end date, major category of auto insurance, new renewal policy partition agency code, renewed policy partition agency code, data statistics period.
[0110] [Termination Policy Information Table] Fields: application number, policy number, policy start date, policy signing date, policy termination date, district agency code, insurance type, license plate number, license plate type, VIN code, and vehicle frame number.
[0111] After the present invention stores the incremental renewal policy data in the renewal relationship table, the DWS and APP can calculate the renewal rate index on demand and update it to the front-end index report, such as supporting "Daily Report of Brand Renewal Rate of Scale Benefit", "Daily Report of Renewal Rate Progress of This Month and Next Month", "Renewal Progress Monitoring", "Pre-signing Completion Rate", "Team and Individual Group Tracker Self-renewal Full Renewal Rate", "Daily Report of Renewal Rate Progress of This Month and Next Month", "Daily Report of Self-renewal Rate of Tracker", etc., adding multiple statistical dimensions such as renewal rate indicators under large dimensions such as service manager and brand, users can analyze the renewal rate indicators from different perspectives through fixed reports or multi-dimensional analysis, and in order to further facilitate user data, some high-frequency key focus data can also be sent to customers in the form of SMS or email, and RestApi is provided for use by other systems.
[0112] In the scenario where GBase provides both computing and query capabilities, if there are many computing tasks, GBase resource consumption will be large, which will affect the user's query and use of the renewal rate indicator. Therefore, the present invention synchronizes the calculated renewal rate indicator to the Oracle database or Clickhouse library to support user query operations.
[0113] In order to ensure the security of data, IceCode transcoding is used to encrypt and store data when connecting to the database to ensure database access security.
[0114] The present invention also schedules data synchronization, data cleaning, and data calculation tasks on a regular basis, and calculates and pushes renewal rate indicators every day according to a pre-set scheduling plan. In order to improve the stability of scheduling tasks, a workflow running lock mechanism is also designed to ensure that when tasks are running, the workflow will not be repeatedly scheduled due to misoperation.
[0115] In addition, when an error occurs during the operation of a data monitoring task, SMS messages are used to promptly notify the operation and maintenance personnel for rapid response and processing. In addition, the operation log of each task is recorded to ensure that the problem can be located and resolved in a timely manner.
[0116] like Figure 3 Shown is a schematic diagram of the overall architecture of the renewal rate analysis process of the present invention.
[0117] In summary, compared with the prior art, the present invention can achieve the following beneficial effects:
[0118] 1. Data timeliness. The present invention uses an incremental method to monitor data, which can realize T+1 incremental calculation of large data volumes and complex logical indicators. While updating the renewal rate series indicators on a daily basis at a fine-grained level, it reduces resource usage and improves the timeliness of data updates.
[0119] 2. Rule integrity. On the basis of supplementing and improving historical statistical rules, the present invention further refines and considers the complex business logic in the calculation of various renewal rates. For example, when searching for old policies (policies to be renewed), the same major category of auto insurance for old policies is given priority, and the influence of junk data is eliminated to obtain more accurate data.
[0120] Embodiment 2
[0121] In order to execute the method corresponding to the above-mentioned embodiment 1 and realize the corresponding functions and technical effects, a motor vehicle insurance renewal data monitoring system is provided below.
[0122] like Figure 4 As shown, the motor vehicle insurance renewal data monitoring system provided in this embodiment includes: a data acquisition unit 1, a new insurance start data determination unit 2, a new insurance renewal data determination unit 3, an insurance termination data determination unit 4, an insurance renewal data determination unit 5 and an incremental renewal determination unit 6.
[0123] The data acquisition unit 1 is used to acquire data in the policy information table, the renewal relationship table and the vehicle information table according to a set time period. The policy information table stores multiple groups of policy data, each group of policy data includes the policy application number, the policy number, the policy start date and the policy end date; the renewal relationship table stores multiple groups of renewal data, each group of renewal data includes the new renewal policy number, the renewed policy number, the new renewal policy application number, the renewed policy application number, the new renewal policy start date, the renewed policy start date, the new renewal policy end date and the renewed policy end date; the vehicle information table stores multiple groups of vehicle data, each group of vehicle data includes the policy application number and vehicle parameters.
[0124] The new insurance start data determination unit 2 is connected to the data acquisition unit 1, and is used to obtain the policy data whose policy start date is within the statistical date range from the policy information table to obtain the new insurance start policy data.
[0125] The new renewal data determination unit 3 is connected to the data acquisition unit 1 and the new insurance start data determination unit 2 respectively, and the new renewal data determination unit 3 is used to determine the new renewal policy data according to the new insurance start policy data, the renewal data in the renewal relationship table and the vehicle data in the vehicle information table, and store the new renewal policy data in the incremental insurance start policy table.
[0126] The insurance termination data determination unit 4 is connected to the data acquisition unit 1, and is used to obtain the policy data whose policy termination date is within the statistical date range from the policy information table to obtain the insurance termination policy data.
[0127] The insured data determination unit 5 is respectively connected to the data acquisition unit 1, the new renewal data determination unit 3 and the terminal insurance data determination unit 4. The insured data determination unit 5 is used to determine the insured policy data according to the terminal insurance policy data, the vehicle data in the vehicle information table and the new renewal policy data in the incremental insured policy table, and store the renewed policy data in the incremental terminal insurance policy table.
[0128] The incremental renewal determination unit 6 is connected to the new renewal data determination unit 3 and the renewed data determination unit 5 respectively. The incremental renewal determination unit 6 is used to determine the incremental renewal policy data based on the pre-set renewal rules, according to the incremental starting policy table and the incremental ending policy table, and store the incremental renewal policy data in the renewal relationship table to monitor the motor insurance renewal data in real time.
[0129] Compared with the prior art, the motor vehicle insurance renewal data monitoring system provided in this embodiment has the same beneficial effects as the motor vehicle insurance renewal data monitoring method provided in the first embodiment, which will not be described in detail here.
[0130] Embodiment 3
[0131] This embodiment provides an electronic device, including a memory and a processor, the memory is used to store a computer program, and the processor runs the computer program to enable the electronic device to execute the motor vehicle insurance renewal data monitoring method of the first embodiment.
[0132] Optionally, the above-mentioned electronic device may be a server.
[0133] In addition, an embodiment of the present invention further provides a computer-readable storage medium storing a computer program, which, when executed by a processor, implements the method for monitoring vehicle insurance renewal data of the first embodiment.
[0134] The various embodiments in this specification are described in a progressive manner, and each embodiment focuses on the differences from other embodiments. The same or similar parts between the various embodiments can be referenced to each other.
[0135] The principles and implementation methods of the present invention are described in this article using specific examples. The description of the above embodiments is only used to help understand the method and core idea of the present invention. At the same time, for those skilled in the art, according to the idea of the present invention, there will be changes in the specific implementation methods and application scope. In summary, the content of this specification should not be understood as limiting the present invention.
Claims
1. A method for monitoring auto insurance renewal data, characterized in that: The motor vehicle insurance renewal data monitoring method comprises: Acquire data in the policy information table, renewal relationship table and vehicle information table according to a set time period; the policy information table stores multiple groups of policy data, each group of policy data includes the policy application number, policy number, policy start date and policy end date; the renewal relationship table stores multiple groups of renewal data, each group of renewal data includes the new renewal policy number, the renewed policy number, the new renewal policy application number, the renewed policy application number, the new renewal policy start date, the renewed policy start date, the new renewal policy end date and the renewed policy end date; the vehicle information table stores multiple groups of vehicle data, each group of vehicle data includes the policy application number and vehicle parameters; Obtaining the policy data whose policy start date is within the statistical date range from the policy information table to obtain the new policy data; Determine new renewal policy data according to the new policy data, the renewal data in the renewal relationship table and the vehicle data in the vehicle information table, and store the new renewal policy data in the incremental policy data table; the new renewal policy data includes the application number, the policy number, the policy start date, the policy end date and the vehicle parameters; Determining new renewal policy data according to the new policy data, the renewal data in the renewal relationship table and the vehicle data in the vehicle information table specifically includes: Determine whether there is a renewal data in the renewal relationship table with a new renewal policy number that is the same as the policy number of the new starting policy data; if not, query the vehicle data with the same insurance policy number as the insurance policy number of the new starting policy data from the vehicle information table to obtain the starting vehicle data; Determining new renewal policy data based on the insured vehicle data and the new insured policy data; Obtaining the policy data whose policy expiration date is within the statistical date range from the policy information table to obtain the policy expiration data; Determine the policy data to be renewed based on the final insurance policy data, the vehicle data in the vehicle information table and the new renewal policy data in the incremental insurance policy table, and store the policy data to be renewed in the incremental final insurance policy table; the policy data to be renewed includes the application number, policy number, policy start date, policy end date and vehicle parameters; Determine the policy data to be renewed based on the final insurance policy data, the vehicle data in the vehicle information table and the new insurance renewal policy data in the incremental insurance policy table, specifically including: Searching the vehicle information table for vehicle data whose insurance policy number is the same as the insurance policy number of the final insurance policy data to obtain the final insurance vehicle data; Determine whether there is new renewal policy data in the incremental starting policy table with the same vehicle parameters as the vehicle parameters of the final insurance vehicle data; if so, determine the renewed policy data based on the final insurance vehicle data and the final insurance policy data; Based on the preset renewal rules, incremental renewal policy data is determined according to the incremental initial insurance policy table and the incremental final insurance policy table, and the incremental renewal policy data is stored in the renewal relationship table to monitor the motor vehicle insurance renewal data in real time; Based on the preset renewal rules, the incremental renewal policy data is determined according to the incremental initial policy table and the incremental final policy table, specifically including: For any set of new renewal policy data in the incremental starting policy table, query the incremental ending policy table for the renewed policy data whose vehicle parameters are the same as those of the new renewal policy data, and obtain the renewed policy data corresponding to the new renewal policy data; Determine whether the difference between the policy start date of the new renewal policy data and the policy expiration date of the corresponding renewed policy data is within a set time period, and whether the difference between the policy start date of the new renewal policy data and the policy start date of the corresponding renewed policy data is greater than a set interval number of days, and the difference between the policy start date of the new renewal policy data and the policy expiration date of the new renewal policy data is greater than a set number of long-term days, and the difference between the policy start date of the corresponding renewed policy data and the policy expiration date of the corresponding renewed policy data is greater than a set number of long-term days. If so, determine the incremental renewal policy data based on the new renewal policy data and the corresponding renewed policy data.
2. The method for monitoring auto insurance renewal data according to claim 1, characterized in that: The vehicle parameters include license plate number, license plate type, VIN code and vehicle frame number.
3. The method for monitoring auto insurance renewal data according to claim 1, characterized in that: Each set of insurance policy data also includes the type of insurance; the type of insurance is automobile insurance or personal insurance; Obtain the policy data whose policy start date is within the statistical date range from the policy information table to obtain the new policy data, specifically including: Obtain the policy data of the policy starting date within the statistical date range and the insurance type of motor vehicle insurance from the policy information table to obtain the new starting policy data.
4. The method for monitoring auto insurance renewal data according to claim 1, characterized in that: Each set of insurance policy data also includes an insurance policy underwriting flag; the insurance policy underwriting flag is passed or failed; Obtain the policy data whose policy start date is within the statistical date range from the policy information table to obtain the new policy data, specifically including: Obtain the policy data from the policy information table, whose policy start date is within the statistical date range and whose policy underwriting is indicated as passed, to obtain new policy data.
5. A car insurance renewal data monitoring system, characterized in that: The motor vehicle insurance renewal data monitoring system comprises: A data acquisition unit is used to acquire data in a policy information table, a renewal relationship table and a vehicle information table according to a set time period; the policy information table stores multiple groups of policy data, each group of policy data includes an application number, a policy number, a policy start date and a policy end date; the renewal relationship table stores multiple groups of renewal data, each group of renewal data includes a new renewal policy number, a renewed policy number, a new renewal application number, a renewed application number, a new renewal policy start date, a renewed policy start date, a new renewal policy end date and a renewed policy end date; the vehicle information table stores multiple groups of vehicle data, each group of vehicle data includes an application number and vehicle parameters; A new insurance start data determination unit, connected to the data acquisition unit, for acquiring the insurance policy data whose insurance start date is within the statistical date range from the insurance policy information table to obtain the new insurance start policy data; A new renewal data determination unit is connected to the data acquisition unit and the new insurance start data determination unit, respectively, and is used to determine new renewal policy data according to the new insurance start policy data, the renewal data in the renewal relationship table and the vehicle data in the vehicle information table, and store the new renewal policy data in the incremental insurance start policy table; the new renewal policy data includes the insurance application number, the policy number, the policy start date, the policy end date and the vehicle parameters; Determining new renewal policy data according to the new policy data, the renewal data in the renewal relationship table and the vehicle data in the vehicle information table specifically includes: Determine whether there is a renewal data in the renewal relationship table with a new renewal policy number that is the same as the policy number of the new starting policy data; if not, query the vehicle data with the same insurance policy number as the insurance policy number of the new starting policy data from the vehicle information table to obtain the starting vehicle data; Determining new renewal policy data based on the insured vehicle data and the new insured policy data; A termination data determination unit, connected to the data acquisition unit, is used to acquire the policy data whose policy termination date is within the statistical date range from the policy information table to obtain the termination policy data; The insured data determination unit is connected to the data acquisition unit, the new insurance renewal data determination unit and the final insurance data determination unit respectively, and is used to determine the insured policy data to be renewed according to the final insurance policy data, the vehicle data in the vehicle information table and the new insurance renewal policy data in the incremental insurance start policy table, and store the insured policy data to the incremental insurance end policy table; the insured policy data to be renewed includes the insurance application number, the policy number, the policy start date, the policy end date and the vehicle parameters; Determine the policy data to be renewed based on the final insurance policy data, the vehicle data in the vehicle information table and the new insurance renewal policy data in the incremental insurance policy table, specifically including: Searching the vehicle information table for vehicle data whose insurance policy number is the same as the insurance policy number of the final insurance policy data to obtain the final insurance vehicle data; Determine whether there is new renewal policy data in the incremental starting policy table with the same vehicle parameters as the vehicle parameters of the final insurance vehicle data; if so, determine the renewed policy data based on the final insurance vehicle data and the final insurance policy data; an incremental renewal determination unit, connected to the new renewal data determination unit and the renewed data determination unit, respectively, for determining incremental renewal policy data based on a preset renewal rule, according to the incremental starting policy table and the incremental ending policy table, and storing the incremental renewal policy data in the renewal relationship table, so as to monitor the motor vehicle insurance renewal data in real time; Based on the preset renewal rules, the incremental renewal policy data is determined according to the incremental initial policy table and the incremental final policy table, specifically including: For any set of new renewal policy data in the incremental starting policy table, query the incremental ending policy table for the renewed policy data whose vehicle parameters are the same as those of the new renewal policy data, and obtain the renewed policy data corresponding to the new renewal policy data; Determine whether the difference between the policy start date of the new renewal policy data and the policy expiration date of the corresponding renewed policy data is within a set time period, and whether the difference between the policy start date of the new renewal policy data and the policy start date of the corresponding renewed policy data is greater than a set interval number of days, and the difference between the policy start date of the new renewal policy data and the policy expiration date of the new renewal policy data is greater than a set number of long-term days, and the difference between the policy start date of the corresponding renewed policy data and the policy expiration date of the corresponding renewed policy data is greater than a set number of long-term days. If so, determine the incremental renewal policy data based on the new renewal policy data and the corresponding renewed policy data.
6. An electronic device, characterized in that: It includes a memory and a processor, the memory is used to store a computer program, and the processor runs the computer program to enable the electronic device to execute the motor vehicle insurance renewal data monitoring method according to any one of claims 1 to 4.
