Reinsurance policy data processing method and device, electronic equipment and storage medium

By screening and summarizing the initial reinsurance data table, the target reinsurance data table is formed, and the problem of low screening efficiency of reinsurance policy data in the big data architecture system is solved, and faster data screening and computing is achieved.

CN119477570AActive Publication Date: 2025-02-18CHINA PING AN LIFE INSURANCE CO LTD
View PDF 5 Cites 0 Cited by

Patent Information

Application Number
CN202411712620.8
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-11-26
Publication Date
2025-02-18
Estimated Expiration
2044-11-26

AI Technical Summary

Technical Problem

In big data architecture systems, the lack of indexing of reinsurance policy data leads to the need to scan all data before performing calculations on reinsurance policy data, which is less efficient when filtering target data.

Method used

By obtaining the initial restoration data table, filtering the data table according to the filtering rules, summarizing the target data, and adding the target field to the data table, adding the summary data to the field to form the target restoration data table.

Benefits of technology

Reduces the time to screen reinsurance policy data, improves the data screening efficiency, and reduces the number of data scans across fields.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119477570A_ABST
    Figure CN119477570A_ABST
Patent Text Reader

Abstract

The embodiment of the invention provides a reinsurance policy data processing method and device, electronic equipment and a storage medium, and relates to the technical field of data processing. The method comprises the following steps: acquiring an initial reinsurance data table; screening the initial reinsurance data table according to a first screening rule to obtain data of a plurality of first target insurance policies, the first screening rule comprising a first field in a plurality of fields and a field value of the first field; summarizing the data of the plurality of first target insurance policies to obtain target data; and newly adding a target field in the initial reinsurance data table, and adding the target data into the target field corresponding to the row where the data of the first target insurance policy in the initial reinsurance data table is located, thereby obtaining a target reinsurance data table. According to the embodiment of the invention, the target reinsurance data table can be obtained after the initial reinsurance data table is processed, so that cross-field data scanning is reduced, the time for screening the data of the reinsurance policy is shortened, and the screening efficiency of the data of the reinsurance policy is improved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present application relates to the field of data processing technology, and in particular to a reinsurance policy data processing method, device, electronic device and storage medium. Background Art

[0002] Reinsurance, also known as ceding, refers to the transfer of part of the risks and liabilities covered by an insurer to other insurers by signing a reinsurance policy based on an insurance contract. A reinsurance policy contains a lot of data (i.e., reinsurance policy data), such as the policy number, primary and secondary contract number, and insurance type number of the insurance contract. At present, the processing of reinsurance policy data is usually carried out in an Oracle database. In order to meet the needs of reducing operation and maintenance costs and software costs and improving the scalability of the system, transferring the processing of reinsurance policy data to a big data architecture system has become a new technological development trend. However, the reinsurance policy data stored in the big data architecture system usually does not have an index. Therefore, before operating the reinsurance policy data, all reinsurance policy data needs to be scanned to filter out the target reinsurance policy data. The screening time is long, and there is a problem of low efficiency when screening the target reinsurance policy data. Summary of the invention

[0003] The main purpose of the embodiments of the present application is to propose a reinsurance policy data processing method, device, electronic device and storage medium, which can obtain a target reinsurance data table by processing an initial reinsurance data table, thereby reducing the time for subsequent screening of reinsurance policy data, thereby improving the screening efficiency of reinsurance policy data.

[0004] To achieve the above objective, a first aspect of an embodiment of the present application provides a method for processing reinsurance policy data, the method comprising:

[0005] Acquire an initial reinsurance data table, wherein the initial reinsurance data table includes data of a plurality of reinsurance policies, and the data of each reinsurance policy includes field values ​​of a plurality of fields;

[0006] Screening the initial reinsurance data table according to a first screening rule to obtain data of a plurality of first target policies, wherein the first screening rule includes a first field among the plurality of fields and a field value of the first field;

[0007] Aggregating the data of the plurality of first target insurance policies to obtain target data, wherein the target data includes field values ​​of a plurality of fields in the data of the plurality of first target insurance policies;

[0008] A target field is added to the initial reinsurance data table, and the target data is added to the target field corresponding to the row where the data of the first target policy is located in the initial reinsurance data table, to obtain a target reinsurance data table.

[0009] In some embodiments, after adding the target data to the target field corresponding to the row where the data of the first target policy is located in the initial reinsurance data table to obtain the target reinsurance data table, the method further includes:

[0010] Acquire a second screening rule, where the second screening rule includes a second field among the multiple fields, and a field value of the second field;

[0011] According to the second screening rule, the target reinsurance data table is screened to obtain data of the second target insurance policy;

[0012] Acquire the field value of the target field corresponding to the row where the data of the second target insurance policy is located from the target reinsurance data table;

[0013] Determine a target operation rule according to the field value of the third field in the data of the second target insurance policy and a preset algorithm configuration table;

[0014] According to the target operation rule, calculation is performed based on the field value of the target field corresponding to the row where the data of the second target insurance policy is located, so as to obtain the reinsurance data corresponding to the second target insurance policy.

[0015] In some embodiments, when the target operation rule adopts the first operation rule, the target operation rule includes a fourth field among the plurality of fields;

[0016] The step of calculating according to the target operation rule and based on the field value of the target field corresponding to the row where the data of the second target insurance policy is located, to obtain the reinsurance data corresponding to the second target insurance policy includes:

[0017] According to the target operation rule, the field value of the target field corresponding to the row where the data of the second target insurance policy is located is screened to obtain a first screening result, wherein the first screening result is determined according to the field value of the fourth field in the data of the second target insurance policy;

[0018] Obtaining a target calculation value based on the data arrangement order of the field value of the target field and the first screening result;

[0019] The target calculation values ​​are added to obtain reinsurance data corresponding to the second target insurance policy.

[0020] In some embodiments, when the target operation rule adopts the second operation rule, the target operation rule includes a fifth field among the plurality of fields;

[0021] The step of calculating according to the target operation rule and based on the field value of the target field corresponding to the row where the data of the second target insurance policy is located, to obtain the reinsurance data corresponding to the second target insurance policy includes:

[0022] According to the target operation rule, the field value of the target field corresponding to the row where the data of the second target insurance policy is located is screened to obtain a second screening result, wherein the second screening result is determined according to the field value of the fifth field in the data of the second target insurance policy;

[0023] Based on the data arrangement order of the field value of the target field, the reinsurance data corresponding to the second target policy is determined according to the second screening result, and the data arrangement order is determined according to the arrangement order of the multiple fields in the initial reinsurance data table.

[0024] In some embodiments, when the second field is the same as the first field, acquiring the field value of the target field corresponding to the row where the data of the second target policy is located from the target reinsurance data table includes:

[0025] If the number of the second target insurance policy is one, then obtaining the field value of the target field corresponding to the row where the data of the second target insurance policy is located in the target reinsurance data table;

[0026] If there are multiple second target policies, the field values ​​of the target field corresponding to the rows where the data of multiple second target policies are located are deduplicated to obtain a field value of the target field corresponding to the row where the data of the second target policy is located.

[0027] In some embodiments, determining the target operation rule according to the field value of the third field in the data of the second target insurance policy and a preset algorithm configuration table includes:

[0028] Match the field value of the third field in the data of the second target policy with multiple preset field values ​​in the algorithm configuration table to obtain the target operation rule corresponding to the field value of the third field in the data of the second target policy. The algorithm configuration table includes multiple preset field values ​​and the operation rule corresponding to each of the preset field values.

[0029] In some embodiments, the third field includes an insurance type number field and a contract number field, the preset field value includes a preset insurance type number and a preset contract number, and matching the field value of the third field in the data of the second target insurance policy with a plurality of preset field values ​​in the algorithm configuration table to obtain a target operation rule corresponding to the field value of the third field in the data of the second target insurance policy includes:

[0030] Matching the field value of the insurance type number field in the data of the second target insurance policy with the plurality of preset insurance type numbers in the algorithm configuration table to obtain an initial operation rule;

[0031] The field value of the contract number field in the data of the second target insurance policy is matched with the preset contract number corresponding to the initial operation rule, and the initial operation rule with successful matching is determined as the target operation rule.

[0032] To achieve the above-mentioned purpose, a second aspect of an embodiment of the present application provides a reinsurance policy data processing device, the device comprising:

[0033] An acquisition module, used for acquiring an initial reinsurance data table, wherein the initial reinsurance data table includes data of a plurality of reinsurance policies, and the data of each reinsurance policy includes field values ​​of a plurality of fields;

[0034] a data screening module, configured to screen the initial reinsurance data table according to a first screening rule to obtain data of a plurality of first target policies, wherein the first screening rule includes a first field among the plurality of fields and a field value of the first field;

[0035] A data aggregation module, used for aggregating the data of the plurality of first target insurance policies to obtain target data, wherein the target data includes field values ​​of a plurality of fields in the data of the plurality of first target insurance policies;

[0036] The processing module is used to add a new target field in the initial reinsurance data table, and add the target data to the target field corresponding to the row where the data of the first target policy is located in the initial reinsurance data table, so as to obtain a target reinsurance data table.

[0037] To achieve the above-mentioned purpose, a third aspect of an embodiment of the present application proposes an electronic device, wherein the electronic device includes a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the reinsurance policy data processing method described in the first aspect is implemented.

[0038] To achieve the above-mentioned purpose, a fourth aspect of an embodiment of the present application proposes a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the reinsurance policy data processing method described in the first aspect is implemented.

[0039] The reinsurance policy data processing method, device, electronic device and storage medium proposed in the present application obtain an initial reinsurance data table including data of multiple reinsurance policies, and then filter the initial reinsurance data table according to a first screening rule to obtain data of multiple first target policies, and then aggregate the data of multiple first target policies to obtain target data, and finally add a target field to the initial reinsurance data table, and add the target data to the target field corresponding to the row where the data of the first target policy is located in the initial reinsurance data table, so as to obtain a target reinsurance data table. The present application filters the initial reinsurance data table according to the first screening rule to obtain data of multiple first target policies that meet the first screening rule, and aggregates the data of multiple first target policies to the target field corresponding to the row where the data of the newly added first target policy is located, so as to obtain a target reinsurance data table. In this way, when it is necessary to perform calculations based on the data of the reinsurance policies stored in the target reinsurance data table, the target field can be directly scanned, which reduces the data scanning across fields, thereby reducing the time for screening the data of the reinsurance policies and improving the screening efficiency of the data of the reinsurance policies. BRIEF DESCRIPTION OF THE DRAWINGS

[0040] Figure 1 is a flow chart of a reinsurance policy data processing method provided in an embodiment of the present application;

[0041] Figure 2 is another flow chart of the reinsurance policy data processing method provided by an embodiment of the present application;

[0042] Figure 3 yes Figure 2 A flow chart of step S209 in FIG.

[0043] Figure 4 yes Figure 2 Another flow chart of step S209 in FIG.

[0044] Figure 5 is a schematic diagram of the structure of a reinsurance policy data processing device provided in an embodiment of the present application;

[0045] Figure 6 It is a schematic diagram of the hardware structure of the electronic device provided in the embodiment of the present application. DETAILED DESCRIPTION

[0046] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0047] It should be noted that, although the functional modules are divided in the device schematic diagram and the logical order is shown in the flowchart, in some cases, the steps shown or described may be performed in a different order than the module division in the device or the order in the flowchart. The terms "first", "second", etc. in the specification, claims and the above drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence.

[0048] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as those commonly understood by those skilled in the art to which this application belongs. The terms used herein are only for the purpose of describing the embodiments of this application and are not intended to limit this application.

[0049] First, some nouns involved in this application are analyzed:

[0050] Reinsurance: It can also be called reinsurance. It means that on the basis of the insurance contract, the insurer transfers part of the risks and liabilities it insures to other insurers by signing a reinsurance policy.

[0051] Data table: It is a structure used to store and organize data, consisting of rows and columns. Each row represents an independent record or entity, and each column represents a specific attribute or feature. The structured way of rows and columns makes data easy to store, retrieve, and manage.

[0052] Field: A field is a column in a data table that can be used to store a specific type of data in the data table. Each field has a unique name (field name) and data type (such as integer, text, date, etc.) to describe the nature of the data stored in the field. In addition, a field can also contain some properties, such as field width (maximum length that can be stored), default value, whether to allow null, etc.

[0053] To solve the problems of the prior art, the embodiments of the present application provide a method, device, electronic device and storage medium for processing reinsurance policy data, aiming to improve the processing efficiency of reinsurance data.

[0054] The reinsurance policy data processing method, device, electronic device and storage medium provided in the embodiments of the present application are specifically described through the following embodiments. First, the reinsurance policy data processing method in the embodiments of the present application is described.

[0055] The embodiments of the present application can acquire and process relevant data based on artificial intelligence technology. Artificial Intelligence (AI) is the theory, method, technology and application system that uses digital computers or machines controlled by digital computers to simulate, extend and expand human intelligence, perceive the environment, acquire knowledge and use knowledge to obtain the best results.

[0056] AI basic technologies generally include sensors, dedicated AI chips, cloud computing, distributed storage, big data processing technology, operation / interaction systems, mechatronics, etc. AI software technologies mainly include computer vision technology, robotics technology, biometrics technology, speech processing technology, natural language processing technology, and machine learning / deep learning.

[0057] The reinsurance policy data processing method provided in the embodiment of the present application relates to the field of data processing technology. The reinsurance policy data processing method provided in the embodiment of the present application can be applied to a terminal, can be applied to a server side, or can be software running in a terminal or a server side. In some embodiments, the terminal can be a smart phone, a tablet computer, a laptop computer, a desktop computer, etc.; the server side can be configured as an independent physical server, or can be configured as a server cluster or a distributed system composed of multiple physical servers, and can also be configured as a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, CDN, and big data and artificial intelligence platforms; the software can be an application that implements the reinsurance policy data processing method, etc., but is not limited to the above forms.

[0058] The present application can be used in many general or special computer system environments or configurations. For example: personal computers, server computers, handheld or portable devices, tablet devices, multiprocessor systems, microprocessor-based systems, set-top boxes, programmable consumer electronics, network PCs, minicomputers, mainframe computers, distributed computing environments including any of the above systems or devices, etc. The present application can be described in the general context of computer-executable instructions executed by a computer, such as program modules. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform specific tasks or implement specific abstract data types. The present application can also be practiced in distributed computing environments, in which tasks are performed by remote processing devices connected through a communication network. In a distributed computing environment, program modules can be located in local and remote computer storage media including storage devices.

[0059] It should be noted that in each specific implementation of the present application, when it comes to the need to perform relevant processing based on data related to user identity or characteristics such as user information, user behavior data, user historical data, and user location information, the user's permission or consent will be obtained first, and the collection, use, and processing of these data will comply with relevant laws, regulations, and standards. In addition, when the embodiment of the present application needs to obtain the user's sensitive personal information, the user's separate permission or consent will be obtained through a pop-up window or by jumping to a confirmation page. After clearly obtaining the user's separate permission or consent, the necessary user-related data for the normal operation of the embodiment of the present application will be obtained.

[0060] Figure 1 is a flow chart of a reinsurance policy data processing method provided in an embodiment of the present application. Figure 1 The method may include but is not limited to steps S101 to S104.

[0061] Step S101, obtaining an initial reinsurance data table, wherein the initial reinsurance data table includes data of a plurality of reinsurance policies, and the data of each of the reinsurance policies includes field values ​​of a plurality of fields.

[0062] The initial reinsurance data table is a data table used to store data of multiple reinsurance policies. Each insurance contract may include at least one insurance product (such as serious illness, accident and medical treatment, etc.), and each insurance product has multiple liability clauses. Based on this, a reinsurance policy can be signed for each insurance product in each insurance contract. In addition, according to the liability clause number corresponding to each liability clause under each insurance product, the data of the reinsurance policy corresponding to each insurance product can be split into multiple pieces, and the data of each reinsurance policy after splitting can be stored in each row in the initial reinsurance data table, thereby obtaining the initial reinsurance data table. In this way, the electronic device can obtain the initial reinsurance data table containing the data of multiple reinsurance policies. In addition, the data of each reinsurance policy includes field values ​​of multiple fields. Exemplarily, the multiple fields may include a policy number field (used to store the identifier of the insurance product, i.e., the policy number), a main supplementary contract number field (used to store the identifier of the main contract of the insurance contract and the identifier of the supplementary contract of the insurance contract, i.e., the main supplementary contract number), a liability field (used to store the liability clause number corresponding to the liability clause in the insurance contract), a contract number field (used to store the identifier of the reinsurance policy, i.e., the contract number), a policy number field (used to store the identifier of the insurance contract, i.e., the policy number), a retention amount field (used to store the liability limit data that the original insurer should bear in the reinsurance policy) and a risk coverage field (used to store the maximum liability amount that the insurer should bear in the insurance contract), etc.

[0063] Step S102, screening the initial reinsurance data table according to a first screening rule to obtain data of a plurality of first target policies, wherein the first screening rule includes a first field among the plurality of fields and a field value of the first field.

[0064] According to the first screening rule, the electronic device can screen the initial reinsurance data table to obtain data of multiple first target policies. The first screening rule includes a first field among multiple fields, and a field value of the first field. The first field can be any one of the multiple fields, or any multiple fields. The number of fields is not limited and can be adjusted according to actual business needs. Exemplarily, assuming that the first field is the customer number field, and the field value of the customer number field is C01, then the data of the reinsurance policy with the field value of the customer number field being C01 can be screened out from the initial reinsurance data table, that is, the data of the first target policy. Alternatively, assuming that the first field is the policy number field, and the field value of the policy number field is A01, then the data of the reinsurance policy with the field value of the policy number field being A01 can be screened out from the initial reinsurance data table, that is, the data of the first target policy.

[0065] Step S103, aggregating the data of the multiple first target insurance policies to obtain target data, wherein the target data includes field values ​​of multiple fields in the data of the multiple first target insurance policies.

[0066] After obtaining the data of multiple first target policies, the electronic device can summarize the data of multiple first target policies to obtain target data. It can be understood that the target data is a collection of data of multiple first target policies, including field values ​​of multiple fields in the data of multiple first target policies. It should be noted that when summarizing the data of multiple first target policies, the data of multiple first target policies are separated by a first preset symbol to distinguish the data of different first target policies. In addition, for the data of each first target policy, the field values ​​of multiple fields in the data of each first target policy are separated by a second preset symbol to distinguish the field values ​​of different fields. The first preset symbol and the second preset symbol are determined according to actual conditions, and the two use different symbols. For example, the first preset symbol can use a semicolon, and the second preset symbol can use a comma.

[0067] Step S104, adding a target field to the initial reinsurance data table, and adding the target data to the target field corresponding to the row where the data of the first target policy is located in the initial reinsurance data table, to obtain a target reinsurance data table.

[0068] The electronic device can add a target field to the initial reinsurance data table. The number of target fields is the same as the number of fields included in the first field. That is, when the number of first fields is two, the number of newly added target fields is also two, so as to respectively store the data of multiple first target policies filtered out according to each first field. In this way, after adding a target field, the target data can be added to the target field corresponding to the row where the data of the first target policy is located in the initial reinsurance data table, so as to obtain the target reinsurance data table.

[0069] In the steps S101 to S104 shown in the embodiment of the present application, an initial reinsurance data table including data of multiple reinsurance policies is obtained, and then the initial reinsurance data table is screened according to the first screening rule to obtain data of multiple first target policies, and then the data of multiple first target policies are aggregated to obtain target data, and finally a target field is added to the initial reinsurance data table, and the target data is added to the target field corresponding to the row where the data of the first target policy is located in the initial reinsurance data table, so as to obtain the target reinsurance data table. The present application obtains data of multiple first target policies that meet the first screening rule by screening the initial reinsurance data table according to the first screening rule, and aggregates the data of multiple first target policies into the target field corresponding to the row where the data of the newly added first target policy is located, so as to obtain the target reinsurance data table. In this way, when it is necessary to perform calculations based on the data of the reinsurance policies stored in the target reinsurance data table, the target field can be directly scanned, which reduces the data scanning across fields, thereby reducing the time for screening the data of the reinsurance policies and improving the screening efficiency of the data of the reinsurance policies.

[0070] Figure 2 is another flow chart of the reinsurance policy data processing method provided in an embodiment of the present application. Figure 2 The method may include but is not limited to steps S201 to S209, wherein:

[0071] Step S201, obtaining an initial reinsurance data table, wherein the initial reinsurance data table includes data of a plurality of reinsurance policies, and the data of each of the reinsurance policies includes field values ​​of a plurality of fields.

[0072] Step S202, screening the initial reinsurance data table according to a first screening rule to obtain data of a plurality of first target policies, wherein the first screening rule includes a first field among the plurality of fields and a field value of the first field.

[0073] Step S203, aggregating the data of the multiple first target insurance policies to obtain target data, wherein the target data includes field values ​​of multiple fields in the data of the multiple first target insurance policies.

[0074] Step S204, adding a target field to the initial reinsurance data table, and adding the target data to the target field corresponding to the row where the data of the first target policy is located in the initial reinsurance data table, to obtain a target reinsurance data table.

[0075] The above steps S201 to S204 may refer to steps S101 to S104 for details, which will not be described in detail here.

[0076] Step S205, obtaining a second screening rule, where the second screening rule includes a second field among the multiple fields, and a field value of the second field;

[0077] Step S206, screening the target reinsurance data table according to the second screening rule to obtain data of the second target insurance policy;

[0078] Step S207, obtaining the field value of the target field corresponding to the row where the data of the second target insurance policy is located from the target reinsurance data table;

[0079] Step S208, determining a target operation rule according to the field value of the third field in the data of the second target insurance policy and a preset algorithm configuration table;

[0080] Step S209, according to the target operation rule, calculation is performed based on the field value of the target field corresponding to the row where the data of the second target insurance policy is located, to obtain the reinsurance data corresponding to the second target insurance policy.

[0081] After completing the processing of the initial reinsurance data table and obtaining the target reinsurance data table, the field value of the target field in the target reinsurance data table can be calculated to obtain the reinsurance data corresponding to the reinsurance policy. It should be noted that the reinsurance data here is the risk insurance amount or retention amount calculated according to the target operation rule. Specifically, the electronic device can filter the target reinsurance data table according to the second screening rule to obtain the data of the second target policy, that is, the data of the reinsurance policy that needs to perform reinsurance data calculation. The second screening rule is determined according to business needs, including the second field of multiple fields, such as the customer number field, the policy number field, the retention amount field, etc., and the field value of the second field. In addition, the number of the second field is not limited, and it can be any one of the multiple fields, or it can be any multiple fields.

[0082] Subsequently, according to the data of the second target policy, the target field corresponding to the row where the data of the second target policy is located in the target reinsurance data table can be determined, and the field value of the target field corresponding to the row where the data of the second target policy is located can be obtained. In addition, according to actual business needs, the electronic device can pre-build an algorithm configuration table. Exemplarily, the algorithm configuration table can be composed of a preset field value field (for storing the preset field value) and an operation rule field (for storing the operation rule). Among them, the number of preset field value fields can be multiple. For example, the algorithm configuration table can be a data table composed of a preset insurance type number field, a preset contract number field, and an operation rule field. Alternatively, the algorithm configuration table can also be composed of a preset insurance type number field, a preset contract number field, an operation rule field, and an algorithm number field. In this way, according to the data of the second target policy, the electronic device can obtain the field value of the third field in the data of the second target policy, and then determine the operation rule corresponding to the field value of the third field in the data of the second target policy, that is, the target operation rule, according to the field value of the third field in the data of the second target policy and the algorithm configuration table. According to the target operation rules, the electronic device can perform calculations based on the field value of the target field corresponding to the row where the data of the second target insurance policy is located to obtain the reinsurance data corresponding to the second target insurance policy.

[0083] Through the above-mentioned method, the electronic device can directly scan the field value of the target field corresponding to the row where the data of the second target insurance policy is located, and obtain the data required to calculate the reinsurance data according to the target operation rules, thereby reducing the scanning of data across fields, improving data screening efficiency, and thereby improving the calculation speed of the reinsurance data.

[0084] In some embodiments, when the second field is the same as the first field, acquiring the field value of the target field corresponding to the row where the data of the second target policy is located from the target reinsurance data table includes:

[0085] If the number of the second target insurance policy is one, then obtaining the field value of the target field corresponding to the row where the data of the second target insurance policy is located in the target reinsurance data table;

[0086] If there are multiple second target policies, the field values ​​of the target field corresponding to the rows where the data of multiple second target policies are located are deduplicated to obtain a field value of the target field corresponding to the row where the data of the second target policy is located.

[0087] In the process of obtaining the field value of the target field corresponding to the row where the data of the second target policy is located from the target reinsurance data table, if the second field (i.e., the field included in the second screening rule) is the same as the first field (i.e., the field included in the first screening rule), and the number of second target policies is multiple, then the field values ​​of the target field corresponding to the rows where the data of multiple second target policies are located can be screened out, and the field values ​​of the target field corresponding to the rows where the data of multiple second target policies are located are the same. In order to reduce the possibility of repeated processing of the same data and reduce the calculation cost, the field values ​​of the target field corresponding to the rows where the data of multiple second target policies are located can be deduplicated, and only the field value of the target field corresponding to the row where the data of one second target policy is located is retained, and then based on the field value of the target field corresponding to the row where the data of the one second target policy is retained, the reinsurance data corresponding to the multiple second target policies are respectively calculated. If the number of second target policies is one, the field value of the target field corresponding to the row where the data of the second target policy is located in the target reinsurance data table is obtained, and no deduplication processing is required.

[0088] In some embodiments, determining the target operation rule according to the field value of the third field in the data of the second target insurance policy and a preset algorithm configuration table includes:

[0089] Match the field value of the third field in the data of the second target policy with multiple preset field values ​​in the algorithm configuration table to obtain the target operation rule corresponding to the field value of the third field in the data of the second target policy. The algorithm configuration table includes multiple preset field values ​​and the operation rule corresponding to each of the preset field values.

[0090] The electronic device can determine the target operation rule according to the field value of the third field in the data of the second target insurance policy and the preset algorithm configuration table. Among them, the algorithm configuration table includes multiple preset field values ​​and the operation rules corresponding to each preset field value. Specifically, the field value of the third field in the data of the second target insurance policy can be matched with the multiple preset field values ​​in the algorithm configuration table, so as to obtain the target operation rule corresponding to the field value of the third field in the data of the second target insurance policy. Exemplarily, the multiple preset field values ​​include at least one preset insurance type number. Then, taking the third field as the insurance type number field as an example, assuming that the field value of the insurance type number field in the data of the second target insurance policy is 123, the field value 123 of the insurance type number field in the data of the second target insurance policy can be matched with the preset insurance type number in the algorithm configuration table, and the operation rule corresponding to the preset insurance type number that is successfully matched is determined as the target operation rule. In this way, the target operation rule can be determined so that the field value of the target field corresponding to the row where the data of the second target insurance policy is located can be operated according to the target operation rule later.

[0091] In some embodiments, the third field includes an insurance type number field and a contract number field, the preset field value includes a preset insurance type number and a preset contract number, and matching the field value of the third field in the data of the second target insurance policy with a plurality of preset field values ​​in the algorithm configuration table to obtain a target operation rule corresponding to the field value of the third field in the data of the second target insurance policy includes:

[0092] Matching the field value of the insurance type number field in the data of the second target insurance policy with the plurality of preset insurance type numbers in the algorithm configuration table to obtain an initial operation rule;

[0093] The field value of the contract number field in the data of the second target insurance policy is matched with the preset contract number corresponding to the initial operation rule, and the initial operation rule with successful matching is determined as the target operation rule.

[0094] When the third field includes an insurance type number field and a contract number field, and the preset field value includes a preset insurance type number and a preset contract number, the electronic device may first match the field value of the insurance type number field in the data of the second target insurance policy with a plurality of preset insurance type numbers in the algorithm configuration table, and determine the operation rule corresponding to the successfully matched preset insurance type number as the initial operation rule. Further, the field value of the contract number field in the data of the second target insurance policy may be matched with the preset contract number corresponding to the initial operation rule, and the successfully matched initial operation rule may be determined as the target operation rule. Exemplarily, assuming that the field value of the insurance type number field in the data of the second target insurance policy is 123, and the field value of the contract number field in the data of the second target insurance policy is S01, then the field value 123 of the insurance type number field in the data of the second target insurance policy may be matched with a plurality of preset insurance type numbers in the algorithm configuration table, and the operation rule corresponding to the successfully matched preset insurance type number may be determined as the initial operation rule, for example, the initial operation rule includes an operation rule with an algorithm number of CA01, an operation rule with an algorithm number of CA02, and an operation rule with an algorithm number of CA03. The electronic device can further match the field value S01 of the contract number field in the data of the second target insurance policy with the preset contract number corresponding to the initial operation rule (including the preset contract number S01 corresponding to the operation rule with algorithm number CA01, the preset contract number S02 corresponding to the operation rule with algorithm number CA02, and the preset contract number S03 corresponding to the operation rule with algorithm number CA03). At this time, it can be determined that the field value of the contract number field in the data of the second target insurance policy successfully matches the operation rule with algorithm number CA01, and then the operation rule is determined as the target operation rule.

[0095] In addition, when determining the target operation rules, it is not limited to the aforementioned matching order, and can be adjusted according to actual conditions. For example, the field value of the contract number field in the data of the second target insurance policy can be matched with multiple preset contract numbers in the algorithm configuration table to obtain the initial operation rules, and then the field value of the insurance type number field in the data of the second target insurance policy can be matched with the preset insurance type number corresponding to the initial operation rules, so as to determine the target operation rules. In addition, the third field is not limited to the insurance type number field and the contract number field, and can be adjusted, but the third field should match the preset field value field in the algorithm configuration table.

[0096] Figure 3 yes Figure 2 For a flowchart of step S209 in Figure 3 In some embodiments, when the target operation rule adopts the first operation rule, the target operation rule includes a fourth field among the multiple fields;

[0097] Step S209, performing calculation according to the target operation rule and the field value of the target field corresponding to the row where the data of the second target insurance policy is located, to obtain reinsurance data corresponding to the second target insurance policy, includes:

[0098] Step S301, according to the target operation rule, the field value of the target field corresponding to the row where the data of the second target policy is located is screened to obtain a first screening result, wherein the first screening result is determined according to the field value of the fourth field in the data of the second target policy;

[0099] Step S302, obtaining a target calculation value based on the data arrangement order of the field value of the target field and the first screening result;

[0100] Step S303, adding the target calculation values ​​to obtain reinsurance data corresponding to the second target insurance policy.

[0101] The operation rules include the first operation rules. If the target operation rules adopt the first operation rules, the target operation rules include the fourth field and the specific operation method. Therefore, according to the field value of the fourth field in the data of the second target policy, the field value of the target field corresponding to the row where the data of the second target policy is located can be screened to obtain the first screening result, and based on the data arrangement order of the field value of the target field and the first screening result, the target operation value can be obtained. By adding the target operation values, the reinsurance data corresponding to the second target policy can be obtained. It should be noted that the data arrangement order of the field value of the target field mentioned here refers to the arrangement order between the multiple specific data contained in the field value of the target field.

[0102] Exemplarily, the first operation rule can be divided into a first sub-rule, a second sub-rule and a third sub-rule. The first sub-rule refers to a rule that takes the retention amount in the data of the reinsurance policy with the same customer number and the same contract number, and uses the accumulated result as the reinsurance data corresponding to the second target policy, the second sub-rule refers to a rule that takes the risk coverage amount in the data of the reinsurance policy with the same customer number and the same liability clause number, and uses the accumulated result as the reinsurance data corresponding to the second target policy, and the third sub-rule refers to a rule that takes the retention amount in the data of the reinsurance policy with the same policy number and the main attachment number being the preset main attachment number, and uses the accumulated result as the reinsurance data corresponding to the second target policy. If the target operation rule adopts the first sub-rule, at this time, the fourth field includes the customer number field and the contract number field. In this way, according to the field value of the customer number field in the data of the second target policy (for example, C01) and the field value of the contract number field in the data of the second target policy (for example, S01), the data of the reinsurance policy containing both the data C01 and S01 can be obtained from the field value of the target field corresponding to the row where the data of the second target policy is located, and then the retention amount in the data of the reinsurance policy containing both the data C01 and S01 can be extracted as the target operation value.

[0103] Since the data of the reinsurance policy cannot be distinguished from which field value of each specific data in the data of the reinsurance policy after being aggregated into the target field, the electronic device can determine the data arrangement order in advance according to the arrangement order of multiple fields in the initial reinsurance data table. For example, in the initial reinsurance data table, multiple fields are arranged in the order of policy number field, customer number field, main and auxiliary contract number field, insurance type number field, contract number field, liability field, risk coverage field and retention field. Then, according to the aforementioned field arrangement order, the electronic device can determine the data arrangement order as: policy number, customer number, main and auxiliary contract number, insurance type number, contract number, liability clause number, risk coverage and retention. In this way, based on the data arrangement order, after determining the data of the reinsurance policy containing both C01 and S01, according to the positions of C01 and S01 in the data of the reinsurance policy, the position of the retention in the data of the reinsurance policy can be determined, and then the retention in the data of all reinsurance policies containing both C01 and S01, that is, the target calculation value, is obtained.

[0104] In this way, when the target operation rule adopts the first operation rule, the reinsurance data corresponding to the second target policy can be obtained by calculation based on the field value of the target field corresponding to the row where the data of the second target policy is located.

[0105] Figure 4 yes Figure 2 For another flowchart of step S209 in Figure 4In some embodiments, when the target operation rule adopts the second operation rule, the target operation rule includes a fifth field among the multiple fields;

[0106] Step S209, performing calculation according to the target operation rule and the field value of the target field corresponding to the row where the data of the second target insurance policy is located, to obtain reinsurance data corresponding to the second target insurance policy, includes:

[0107] Step S401, according to the target operation rule, the field value of the target field corresponding to the row where the data of the second target insurance policy is located is screened to obtain a second screening result, wherein the second screening result is determined according to the field value of the fifth field in the data of the second target insurance policy;

[0108] Step S402, based on the data arrangement order of the field values ​​of the target field, determine the reinsurance data corresponding to the second target policy according to the second screening result, wherein the data arrangement order is determined according to the arrangement order of the plurality of fields in the initial reinsurance data table.

[0109] The operation rules include the second operation rules. When the target operation rules adopt the second operation rules, the target operation rules include the fifth field and the specific operation method. Therefore, according to the field value of the fifth and fourth fields in the data of the second target policy, the field value of the target field corresponding to the row where the data of the second target policy is located can be screened to obtain the second screening result, and based on the data arrangement order of the field value of the target field and the second screening result, the reinsurance data corresponding to the second target policy can be obtained. It should be noted that the data arrangement order of the field value of the target field mentioned here refers to the arrangement order between multiple specific data contained in the field value of the target field.

[0110] Exemplarily, the second operation rule can be divided into a fourth sub-rule and a fifth sub-rule. Among them, the fourth sub-rule refers to the rule of taking the risk amount in the data of the reinsurance policy with the same policy number, the same insurance type number, different contract number and the smallest liability share stipulated in the liability clause corresponding to the liability clause number, and taking the risk amount as the reinsurance data corresponding to the second target policy, and the fifth sub-rule refers to the rule of taking the retention amount in the data of the second target policy as the reinsurance data corresponding to the second target policy. If the target operation rule adopts the fourth sub-rule, at this time, the fifth field includes the policy number field, the insurance type number field and the contract number field. In this way, according to the field value of the policy number field in the data of the second target policy (for example, A01), the field value of the insurance type number field in the data of the second target policy (for example, 123), and the field value of the contract number field in the data of the second target policy (for example, S01), the field value of the target field corresponding to the row where the data of the second target policy is located can be obtained from the field value of the target field corresponding to the row where the data of the second target policy is located, which contains both A01 and 123 and does not contain S01. If there are multiple reinsurance policy data that contain both A01 and 123 but do not contain S01, compare the field values ​​of the liability fields in the multiple reinsurance policy data that contain both A01 and 123 but do not contain S01 to determine the reinsurance policy data with the smallest agreed liability share among the multiple reinsurance policy data that contain both A01 and 123 but do not contain S01, and then determine the risk insurance amount in the reinsurance policy data with the smallest agreed liability share as the reinsurance data corresponding to the second target policy.

[0111] Furthermore, since after the data of the reinsurance policy is aggregated to the target field, it is impossible to distinguish which field value of each specific data in the data of the reinsurance policy is, therefore, the electronic device can determine the data arrangement order in advance according to the arrangement order of multiple fields in the initial reinsurance data table. For example, in the initial reinsurance data table, multiple fields are arranged in the order of the policy number field, the customer number field, the main and auxiliary contract number field, the insurance type number field, the contract number field, the liability field, the risk coverage field and the retention amount field. Then, according to the aforementioned field arrangement order, the electronic device can determine the data arrangement order as: policy number, customer number, main and auxiliary contract number, insurance type number, contract number, liability clause number, risk coverage and retention amount. In this way, based on the data arrangement order, after determining the data of the reinsurance policy that contains both A01 and 123 and does not contain S01, according to the positions of A01 and 123 in the data of the reinsurance policy, the position of the liability clause number in the data of the reinsurance policy can be determined, and the position of the risk coverage in the data of the reinsurance policy can be determined.

[0112] In this way, when the target operation rule adopts the second operation rule, the reinsurance data corresponding to the second target insurance policy can be obtained by calculation based on the field value of the target field corresponding to the row where the data of the second target insurance policy is located.

[0113] Figure 5 This is a schematic diagram of the structure of the reinsurance policy data processing device provided in the embodiment of the present application. Figure 5 The embodiment of the present application further provides a reinsurance policy data processing device 500, which can implement the above reinsurance policy data processing method. The device 500 includes:

[0114] An acquisition module 501 is used to acquire an initial reinsurance data table, wherein the initial reinsurance data table includes data of a plurality of reinsurance policies, and the data of each reinsurance policy includes field values ​​of a plurality of fields;

[0115] A data screening module 502 is used to screen the initial reinsurance data table according to a first screening rule to obtain data of a plurality of first target policies, wherein the first screening rule includes a first field among the plurality of fields and a field value of the first field;

[0116] A data aggregation module 503 is used to aggregate the data of the plurality of first target insurance policies to obtain target data, wherein the target data includes field values ​​of a plurality of fields in the data of the plurality of first target insurance policies;

[0117] The processing module 504 is used to add a target field to the initial reinsurance data table, and add the target data to the target field corresponding to the row where the data of the first target policy is located in the initial reinsurance data table, so as to obtain a target reinsurance data table.

[0118] In some embodiments, the reinsurance policy data processing device 500 further includes a computing module for:

[0119] Acquire a second screening rule, where the second screening rule includes a second field among the multiple fields, and a field value of the second field;

[0120] According to the second screening rule, the target reinsurance data table is screened to obtain data of the second target insurance policy;

[0121] Acquire the field value of the target field corresponding to the row where the data of the second target insurance policy is located from the target reinsurance data table;

[0122] Determine a target operation rule according to the field value of the third field in the data of the second target insurance policy and a preset algorithm configuration table;

[0123] According to the target operation rule, calculation is performed based on the field value of the target field corresponding to the row where the data of the second target insurance policy is located, so as to obtain the reinsurance data corresponding to the second target insurance policy.

[0124] In some embodiments, the computing module is further configured to:

[0125] According to the target operation rule, the field value of the target field corresponding to the row where the data of the second target insurance policy is located is screened to obtain a first screening result, wherein the first screening result is determined according to the field value of the fourth field in the data of the second target insurance policy;

[0126] Obtaining a target calculation value based on the data arrangement order of the field value of the target field and the first screening result;

[0127] The target calculation values ​​are added to obtain reinsurance data corresponding to the second target insurance policy.

[0128] In some embodiments, the computing module is further configured to:

[0129] According to the target operation rule, the field value of the target field corresponding to the row where the data of the second target insurance policy is located is screened to obtain a second screening result, wherein the second screening result is determined according to the field value of the fifth field in the data of the second target insurance policy;

[0130] The reinsurance data is determined according to the second screening result based on the data arrangement order of the field values ​​of the target field, wherein the data arrangement order is determined according to the arrangement order of the plurality of fields in the initial reinsurance data table.

[0131] In some embodiments, the computing module is further configured to:

[0132] If the number of the second target insurance policy is one, then obtaining the field value of the target field corresponding to the row where the data of the second target insurance policy is located in the target reinsurance data table;

[0133] If there are multiple second target policies, the field values ​​of the target field corresponding to the rows where the data of multiple second target policies are located are deduplicated to obtain a field value of the target field corresponding to the row where the data of the second target policy is located.

[0134] In some embodiments, the computing module is further configured to:

[0135] Match the field value of the third field in the data of the second target policy with multiple preset field values ​​in the algorithm configuration table to obtain the target operation rule corresponding to the field value of the third field in the data of the second target policy. The algorithm configuration table includes multiple preset field values ​​and the operation rule corresponding to each of the preset field values.

[0136] In some embodiments, the computing module is further configured to:

[0137] Matching the field value of the insurance type number field in the data of the second target insurance policy with the plurality of preset insurance type numbers in the algorithm configuration table to obtain an initial operation rule;

[0138] The field value of the contract number field in the data of the second target insurance policy is matched with the preset contract number corresponding to the initial operation rule, and the initial operation rule with successful matching is determined as the target operation rule.

[0139] The specific implementation of the reinsurance policy data processing device 500 is substantially the same as the specific implementation of the above-mentioned reinsurance policy data processing method, and will not be described in detail herein.

[0140] The embodiment of the present application also provides an electronic device, the electronic device includes a memory and a processor, the memory stores a computer program, and the processor implements the above reinsurance policy data processing method when executing the computer program. The electronic device can be any smart terminal including a tablet computer, a car computer, etc.

[0141] Figure 6 This is a schematic diagram of the hardware structure of the electronic device provided in the embodiment of the present application. Figure 6 . Electronic equipment includes:

[0142] The processor 601 may be implemented by a general-purpose CPU (Central Processing Unit), a microprocessor, an application-specific integrated circuit (ASIC), or one or more integrated circuits, and is used to execute relevant programs to implement the technical solutions provided in the embodiments of the present application;

[0143] The memory 602 can be implemented in the form of a read-only memory (ROM), a static storage device, a dynamic storage device, or a random access memory (RAM). The memory 602 can store an operating system and other application programs. When the technical solution provided in the embodiment of this specification is implemented by software or firmware, the relevant program code is stored in the memory 602, and the processor 601 calls and executes the reinsurance policy data processing method of the embodiment of this application;

[0144] Input / output interface 603, used to implement information input and output;

[0145] Communication interface 604, used to realize communication interaction between the device and other devices, which can be realized through wired mode (such as USB, network cable, etc.) or wireless mode (such as mobile network, WI FI, Bluetooth, etc.);

[0146] Bus 605 , which transmits information between various components of the device (e.g., processor 601 , memory 602 , input / output interface 603 , and communication interface 604 );

[0147] The processor 601 , the memory 602 , the input / output interface 603 and the communication interface 604 are connected to each other in communication within the device via a bus 605 .

[0148] An embodiment of the present application further provides a computer-readable storage medium, which stores a computer program. When the computer program is executed by a processor, the above-mentioned reinsurance policy data processing method is implemented.

[0149] The memory, as a non-transient computer-readable storage medium, can be used to store non-transient software programs and non-transient computer executable programs. In addition, the memory may include a high-speed random access memory, and may also include a non-transient memory, such as at least one disk storage device, a flash memory device, or other non-transient solid-state storage device. In some embodiments, the memory may optionally include a memory remotely disposed relative to the processor, and these remote memories may be connected to the processor via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0150] The reinsurance policy data processing method, device, electronic device and storage medium proposed in the present application obtain an initial reinsurance data table including data of multiple reinsurance policies, and then filter the initial reinsurance data table according to a first screening rule to obtain data of multiple first target policies, and then aggregate the data of multiple first target policies to obtain target data, and finally add a target field to the initial reinsurance data table, and add the target data to the target field corresponding to the row where the data of the first target policy is located in the initial reinsurance data table, so as to obtain a target reinsurance data table. The present application filters the initial reinsurance data table according to the first screening rule to obtain data of multiple first target policies that meet the first screening rule, and aggregates the data of multiple first target policies to the target field corresponding to the row where the data of the newly added first target policy is located, so as to obtain a target reinsurance data table. In this way, when it is necessary to perform calculations based on the data of the reinsurance policies stored in the target reinsurance data table, the target field can be directly scanned, which reduces the data scanning across fields, thereby reducing the time for screening the data of the reinsurance policies and improving the screening efficiency of the data of the reinsurance policies.

[0151] The embodiments described in the embodiments of the present application are intended to more clearly illustrate the technical solutions of the embodiments of the present application and do not constitute a limitation on the technical solutions provided in the embodiments of the present application. Those skilled in the art will appreciate that with the evolution of technology and the emergence of new application scenarios, the technical solutions provided in the embodiments of the present application are also applicable to similar technical problems.

[0152] Those skilled in the art will appreciate that the technical solutions shown in the figures do not constitute a limitation on the embodiments of the present application, and may include more or fewer steps than shown in the figures, or a combination of certain steps, or different steps.

[0153] The device embodiments described above are merely illustrative, and the units described as separate components may or may not be physically separated, that is, they may be located in one place or distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0154] Those skilled in the art will appreciate that all or some of the steps in the methods disclosed above, and the functional modules / units in the systems and devices may be implemented as software, firmware, hardware, or a suitable combination thereof.

[0155] The terms "first", "second", "third", "fourth", etc. (if any) in the specification of the present application and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchangeable where appropriate, so that the embodiments of the present application described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any of their variations are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device comprising a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0156] It should be understood that in the present application, "at least one (item)" means one or more, and "plurality" means two or more. "And / or" is used to describe the association relationship of associated objects, indicating that three relationships may exist. For example, "A and / or B" can mean: only A exists, only B exists, and A and B exist at the same time, where A and B can be singular or plural. The character " / " generally indicates that the objects associated before and after are in an "or" relationship. "At least one of the following" or similar expressions refers to any combination of these items, including any combination of single or plural items. For example, at least one of a, b or c can mean: a, b, c, "a and b", "a and c", "b and c", or "a and b and c", where a, b, c can be single or multiple.

[0157] In the several embodiments provided in the present application, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of the above units is only a logical function division. There may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.

[0158] The units described above as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0159] In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.

[0160] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application is essentially or the part that contributes to the prior art or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including multiple instructions to enable a computer device (which can be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods of various embodiments of the present application. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (Read-Only Memory, referred to as ROM), random access memory (Random Access Memory, referred to as RAM), disk or optical disk and other media that can store programs.

[0161] The preferred embodiments of the present invention are described above with reference to the accompanying drawings, but the scope of the rights of the present invention is not limited thereto. Any modification, equivalent substitution and improvement made by a person skilled in the art without departing from the scope and essence of the present invention should be within the scope of the rights of the present invention.

Claims

1. A method for processing reinsurance policy data, characterized in that: The method comprises: Acquire an initial reinsurance data table, wherein the initial reinsurance data table includes data of a plurality of reinsurance policies, and the data of each reinsurance policy includes field values ​​of a plurality of fields; Screening the initial reinsurance data table according to a first screening rule to obtain data of a plurality of first target policies, wherein the first screening rule includes a first field among the plurality of fields and a field value of the first field; Aggregating the data of the plurality of first target insurance policies to obtain target data, wherein the target data includes field values ​​of a plurality of fields in the data of the plurality of first target insurance policies; A target field is added to the initial reinsurance data table, and the target data is added to the target field corresponding to the row where the data of the first target policy is located in the initial reinsurance data table, to obtain a target reinsurance data table.

2. The method according to claim 1, characterized in that After adding the target data to the target field corresponding to the row where the data of the first target policy is located in the initial reinsurance data table to obtain the target reinsurance data table, the method further comprises: Acquire a second screening rule, where the second screening rule includes a second field among the multiple fields, and a field value of the second field; According to the second screening rule, the target reinsurance data table is screened to obtain data of the second target insurance policy; Acquire the field value of the target field corresponding to the row where the data of the second target insurance policy is located from the target reinsurance data table; Determine a target operation rule according to the field value of the third field in the data of the second target insurance policy and a preset algorithm configuration table; According to the target operation rule, calculation is performed based on the field value of the target field corresponding to the row where the data of the second target insurance policy is located, so as to obtain the reinsurance data corresponding to the second target insurance policy.

3. The method according to claim 2, characterized in that In the case where the target operation rule adopts the first operation rule, the target operation rule includes a fourth field among the multiple fields; The step of calculating according to the target operation rule and based on the field value of the target field corresponding to the row where the data of the second target insurance policy is located, to obtain the reinsurance data corresponding to the second target insurance policy includes: According to the target operation rule, the field value of the target field corresponding to the row where the data of the second target insurance policy is located is screened to obtain a first screening result, wherein the first screening result is determined according to the field value of the fourth field in the data of the second target insurance policy; Obtaining a target calculation value based on the data arrangement order of the field value of the target field and the first screening result; The target calculation values ​​are added to obtain reinsurance data corresponding to the second target insurance policy.

4. The method according to claim 2, characterized in that: In the case where the target operation rule adopts the second operation rule, the target operation rule includes a fifth field among the multiple fields; The step of calculating according to the target operation rule and based on the field value of the target field corresponding to the row where the data of the second target insurance policy is located, to obtain the reinsurance data corresponding to the second target insurance policy includes: According to the target operation rule, the field value of the target field corresponding to the row where the data of the second target insurance policy is located is screened to obtain a second screening result, wherein the second screening result is determined according to the field value of the fifth field in the data of the second target insurance policy; Based on the data arrangement order of the field value of the target field, the reinsurance data corresponding to the second target policy is determined according to the second screening result, and the data arrangement order is determined according to the arrangement order of the multiple fields in the initial reinsurance data table.

5. The method according to claim 2, characterized in that: In the case where the second field is the same as the first field, obtaining the field value of the target field corresponding to the row where the data of the second target policy is located from the target reinsurance data table includes: If the number of the second target insurance policy is one, then obtaining the field value of the target field corresponding to the row where the data of the second target insurance policy is located in the target reinsurance data table; If there are multiple second target policies, the field values ​​of the target field corresponding to the rows where the data of multiple second target policies are located are deduplicated to obtain a field value of the target field corresponding to the row where the data of the second target policy is located.

6. The method according to claim 2, characterized in that The step of determining the target operation rule according to the field value of the third field in the data of the second target insurance policy and a preset algorithm configuration table includes: Match the field value of the third field in the data of the second target policy with multiple preset field values ​​in the algorithm configuration table to obtain the target operation rule corresponding to the field value of the third field in the data of the second target policy. The algorithm configuration table includes multiple preset field values ​​and the operation rule corresponding to each of the preset field values.

7. The method according to claim 6, characterized in that The third field includes an insurance type number field and a contract number field, the preset field value includes a preset insurance type number and a preset contract number, and the field value of the third field in the data of the second target insurance policy is matched with a plurality of preset field values ​​in the algorithm configuration table to obtain a target operation rule corresponding to the field value of the third field in the data of the second target insurance policy, including: Matching the field value of the insurance type number field in the data of the second target insurance policy with the plurality of preset insurance type numbers in the algorithm configuration table to obtain an initial operation rule; The field value of the contract number field in the data of the second target insurance policy is matched with the preset contract number corresponding to the initial operation rule, and the initial operation rule with successful matching is determined as the target operation rule.

8. A reinsurance policy data processing device, characterized in that: The device comprises: An acquisition module, used for acquiring an initial reinsurance data table, wherein the initial reinsurance data table includes data of a plurality of reinsurance policies, and the data of each reinsurance policy includes field values ​​of a plurality of fields; a data screening module, configured to screen the initial reinsurance data table according to a first screening rule to obtain data of a plurality of first target policies, wherein the first screening rule includes a first field among the plurality of fields and a field value of the first field; A data aggregation module, used for aggregating the data of the plurality of first target insurance policies to obtain target data, wherein the target data includes field values ​​of a plurality of fields in the data of the plurality of first target insurance policies; The processing module is used to add a new target field in the initial reinsurance data table, and add the target data to the target field corresponding to the row where the data of the first target policy is located in the initial reinsurance data table, so as to obtain a target reinsurance data table.

9. An electronic device, characterized in that: The electronic device comprises a memory and a processor, the memory stores a computer program, and the processor implements the reinsurance policy data processing method according to any one of claims 1 to 7 when executing the computer program.

10. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the reinsurance policy data processing method according to any one of claims 1 to 7 is implemented.

Citation Information

Patent Citations

  • Insurance policy data extraction method and device, computer equipment and storage medium

    CN109815276A

  • Data submission method and device, electronic equipment and storage medium

    CN115238204A

  • Data storage method and device

    CN116049193A

  • Data version management method and device based on data warehouse and medium

    CN116107996A

  • Data processing method and device, computer equipment, storage medium and program product

    CN118377782A