Customer information model building method and device for insurance industry

Abstract

The invention relates to a customer information model building method and device for the insurance industry. The method comprises the steps that customer information in a data source is collected; filing by taking the unique identifier in the customer information as a main key to obtain a central dimension layer; collecting contact information in a data source, and establishing a foreign key table according to the contact information to obtain a first extension dimension layer; business information in a data source is collected, a foreign key table is established according to the business information, and a second extension dimension layer is obtained; and fusing the central dimension layer, the first extension dimension layer and the second dimension layer to obtain a customer information model. According to the invention, by unifying the filing standard, the data integration and analysis capability of the customer information is improved, and the business efficiency is improved.

Description

Technical Field

[0001] The present invention belongs to the technical field of information service systems, and in particular, relates to a method and device for building a customer information model in the insurance industry. Background Art

[0002] Traditional insurance companies establish individual information systems for each business process. Although these systems play a certain role in production and sales, due to the lack of unified design specifications, the data standards and logical relationships between them have become extremely complex after continuous iterations and upgrades. There is a lack of unified standards in customer file creation and service personnel allocation, and a lack of deep integration in dimensional portraits. The existing data architecture system is difficult to provide strong support for high-quality customer service. Summary of the invention

[0003] In view of the above deficiencies in the prior art, the purpose of the invention is to provide a method and device for building a customer information model in the insurance industry.

[0004] A first aspect of the present invention provides a method for building a customer information model in the insurance industry, comprising:

[0005] S1: Collect customer information from data sources;

[0006] S2: Using the unique identifier in the customer information as the primary key, create a file to obtain a central dimension layer;

[0007] S3: collecting contact information from the data source, establishing a foreign key table according to the contact information, and obtaining a first extended dimension layer;

[0008] S4: collecting business information from the data source, establishing a foreign key table according to the business information, and obtaining a second extended dimension layer;

[0009] S5: The central dimension layer, the first extended dimension layer, and the second dimension layer are integrated to obtain a customer information model.

[0010] According to a method for building a customer information model for the insurance industry provided by the present invention, the unique identifier in step S2 is identity information in the customer information.

[0011] According to a method for building a customer information model for the insurance industry provided by the present invention, step S3 further comprises:

[0012] S31: Collect contact information from data sources;

[0013] S32: Pulling multiple contact records from the contact information;

[0014] S33: Identify the latest contact record among multiple contact records;

[0015] S34: All contact records and the latest contact record are stored in corresponding foreign key tables based on the primary key information of the central dimension layer to obtain a first extended dimension layer.

[0016] According to a method for building a customer information model for the insurance industry provided by the present invention, step S33 also includes:

[0017] The latest contact record is marked.

[0018] According to a method for building a customer information model for the insurance industry provided by the present invention, step S4 further comprises:

[0019] S41: The business system in the data source collects business information; the business information is a business tag;

[0020] S42: storing the business information in corresponding foreign key tables based on the primary key information of the central dimension layer to obtain a second extended dimension layer.

[0021] According to a method for building a customer information model for the insurance industry provided by the present invention, the business system in step S41 is an OLTP system.

[0022] According to a method for building a customer information model for the insurance industry provided by the present invention, in step S5, the first extended dimension layer and the second dimension layer are connected to the central dimension layer by using the left connection method.

[0023] A second aspect of the present invention provides a device for building a customer information model in the insurance industry, comprising:

[0024] Collection module: collects customer information, contact information and business information from data sources;

[0025] Central dimension establishment module: used to establish a file with the unique identifier in the customer information as the primary key to obtain the central dimension layer;

[0026] A first extended dimension establishment module: used to establish a foreign key table according to the contact information to obtain a first extended dimension layer;

[0027] A second extended dimension establishment module: used to establish a foreign key table according to the business information to obtain a second extended dimension layer;

[0028] Fusion module: used to fuse the central dimension layer, the first extended dimension layer, and the second dimension layer to obtain a customer information model.

[0029] A third aspect of the present invention provides a customer information model building device for the insurance industry, comprising:

[0030] A memory and at least one processor, wherein instructions are stored in the memory;

[0031] At least one of the processors calls the instructions in the memory to enable the customer information model building device for the insurance industry to execute the customer information model building method for the insurance industry as described in any of the above items.

[0032] A fourth aspect of the present invention provides a computer-readable storage medium having instructions stored thereon, which, when executed by a processor, implements a method for building a customer information model for the insurance industry as described in any one of the above items.

[0033] The present invention provides a method, device, equipment and storage medium for building a customer information model for the insurance industry. By collecting and integrating customer information, contact information and business information from different data sources, a unified and standardized customer information model can be built, which helps to eliminate information islands, ensure the accuracy and consistency of data, and provide a solid foundation for business decision-making and customer service in the insurance industry; secondly, the present invention realizes multi-level and multi-dimensional management of customer information by establishing a central dimension layer, a first extended dimension layer and a second extended dimension layer, which not only improves the utilization rate of data, but also enables enterprises to more flexibly analyze and mine data according to business needs and discover potential business opportunities; the present invention can ensure that enterprises always have the latest contact records by identifying and marking them. Mastering the customer's latest contact information, so as to communicate with the customer in a timely and accurate manner, helps to improve customer satisfaction and loyalty and optimize customer experience; secondly, the customer information model building method of the present invention is highly scalable and flexible. With the development of the insurance industry, users can update new data sources or adjust existing data models to adapt to new business needs. At the same time, this also provides enterprises with more innovation space and promotes continuous innovation and optimization of business models; in addition, the present invention can significantly reduce the operating costs of enterprises in customer information management and maintenance through automated and standardized customer information management processes, which not only improves work efficiency, but also enables enterprises to invest more resources in core business and customer service to achieve sustainable development. BRIEF DESCRIPTION OF THE DRAWINGS

[0034] The accompanying drawings are only used to illustrate specific embodiments and are not considered to limit the present invention. In the entire drawings, the same reference symbols represent the same components. Obviously, the drawings described below are only some embodiments recorded in the embodiments of the present invention. For those of ordinary skill in the art, other drawings can also be obtained based on these drawings.

[0035] Figure 1 A flow chart of a method for building a customer information model for the insurance industry provided by an embodiment of the present invention;

[0036] Figure 2A schematic diagram of a device for building a customer information model for the insurance industry provided by an embodiment of the present invention.

[0037] Reference numerals:

[0038] 100. Collection module; 200. Central dimension establishment module; 300. First extension dimension establishment module; 400. Second extension dimension establishment module; 500. Fusion module. DETAILED DESCRIPTION

[0039] In order to enable those skilled in the art to better understand the technical solutions in the embodiments of the present invention, the technical solutions of the present invention will be clearly and completely described below in conjunction with the accompanying drawings. Obviously, the described embodiments are part of the embodiments of the present invention, rather than all of the embodiments. It should be understood that these descriptions are only exemplary and are not intended to limit the scope of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in the field without making creative work should fall within the scope of protection of the present invention.

[0040] Furthermore, in the following description, descriptions of well-known structures and technologies are omitted to avoid unnecessarily obscuring the concepts disclosed in the present invention.

[0041] In the description of the present invention, it should be noted that, unless otherwise clearly specified and limited, the orientation or position relationship indicated by the terms "center", "upper", "lower", "left", "right", "vertical", "horizontal", "inside", "outside", etc. is based on the orientation or position relationship shown in the drawings, which is only for the convenience of describing the present invention and simplifying the description, and does not indicate or imply that the device or element referred to must have a specific orientation, be constructed and operated in a specific orientation, and therefore cannot be understood as a limitation of the present invention. In addition, the terms "first", "second", and "third" are only used for descriptive purposes and cannot be understood as indicating or implying relative importance. The terms "installed", "connected", and "connected" should be understood in a broad sense, for example, it can be a fixed connection, a detachable connection, or an integral connection; it can be a mechanical connection or an electrical connection; it can be a direct connection, or it can be indirectly connected through an intermediate medium, or it can be a connection between the two elements. For those of ordinary skill in the art, the specific meanings of the above terms in the present invention can be understood according to specific circumstances.

[0042] Exemplary embodiments will be described in detail herein, examples of which are shown in the accompanying drawings. When the following description refers to the drawings, unless otherwise indicated, the same numbers in different drawings represent the same or similar elements. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present invention. Instead, they are merely examples of methods and systems consistent with some aspects of the present invention as detailed in the appended claims.

[0043] Combine the following Figure 1 to Figure 2 Embodiments of the present invention are described.

[0044] like Figure 1 As shown, the present invention provides a method for building a customer information model in the insurance industry, comprising:

[0045] S1: Collect customer information from data sources.

[0046] Step S1 is the starting point for building the customer information model of the present invention, and its main purpose is to collect customer information from various data sources. In this embodiment, since the built customer information model is used in the insurance industry, the customer information comes from multiple channels and systems, including sales systems, customer service systems, underwriting systems, claims systems, etc. These customer information usually includes basic customer information (such as name, gender, age, contact information, etc.), policy information (such as purchased insurance products, insured amount, premium, etc.) and other data related to insurance business.

[0047] The process of collecting customer information involves multiple links such as data extraction, data cleaning and data conversion. Data extraction refers to the process of obtaining customer information from various data sources through interfaces; data cleaning is to remove duplicate data, correct erroneous data, and process missing data to ensure data accuracy and consistency; data conversion is to convert data of different formats and standards into a unified format and standard for subsequent processing and analysis.

[0048] S2: Create a file using the unique identifier in the customer information as the primary key to obtain a central dimension layer.

[0049] The unique identifier in step S2 is the identity information in the customer information.

[0050] After collecting the customer information, in step S2, the identity information in the customer information is first obtained as a unique identifier and a primary key to perform a file creation operation. The identity information can be information that can uniquely identify a person, such as an ID card number and a passport number.

[0051] The file creation operation refers to storing customer information in the database according to certain rules and structures to form a customer information file. In this process, identity information serves as the primary key to uniquely identify customer information, ensuring that each customer has a unique record in the database.

[0052] The central dimension layer is obtained through the file creation operation. In this embodiment, the central dimension layer is the core part of the customer information model, which contains the basic information and identity information of the customer. It is the basis for the subsequent extended dimension layer (such as contact information, business information, etc.). The establishment of the central dimension layer provides strong support for subsequent data integration, analysis and application.

[0053] Specifically, we first define multiple business data sources in the enterprise. Each data source is based on the ID card (or other identity-proving codes such as passport). For each piece of certificate information, we follow the rules agreed upon with the business department, that is, the latest update date is used as the basis. For each piece of certificate information, add the customer's retained name, gender, birthday, annual income and other personal information to build the core dimension layer of the system.

[0054] The architecture of the central dimension layer obtained is: core dimension: certificate information; extended dimension: name, gender, birthday, annual income; update standard: based on the latest update date retained in each core system.

[0055] S3: Collect contact information from the data source, create a foreign key table according to the contact information, and obtain a first extended dimension layer.

[0056] Wherein, step S3 further comprises:

[0057] S31: Collect contact information from the data source.

[0058] In step S31, firstly, the customer's contact information is collected from various data sources, which may include sales records, customer service records, customer self-service platform records, etc. The collected information may include our business personnel, contact frequency, contact time, etc.

[0059] S32: Pulling multiple contact records from the contact information.

[0060] Furthermore, each customer may receive services from multiple sales staff in each business system. The present invention extracts all contact records from the contact information and retains all customer-sales staff correspondences and contact information in the foreign key table.

[0061] S33: Identify the latest contact record among the multiple contact records.

[0062] Wherein, step S33 also includes:

[0063] The latest contact record is marked.

[0064] In step S33, the system will analyze multiple contact records and identify the latest contact record, because the latest contact record is usually the most effective contact method, which helps to contact the customer in a timely manner based on the record. At the same time, the system will also mark the latest contact record so that it can be quickly identified and used in subsequent data processing and analysis.

[0065] S34: All contact records and the latest contact record are stored in corresponding foreign key tables based on the primary key information of the central dimension layer to obtain a first extended dimension layer.

[0066] In step S34, the system will associate all collected contact records with the primary key information (i.e., identity information) of the central dimension layer, that is, all contact records corresponding to each customer will be placed under the name of the customer, that is, the corresponding primary keys will be stored in the corresponding foreign key tables. In this way, each customer record in the central dimension layer will have one or more associated contact information records in the foreign key table. These contact information records constitute the first extended dimension layer, which expands the dimension of the customer information model and provides a richer customer view.

[0067] Step S3 mainly integrates customers, that is, using information such as salesperson, mobile phone number, and contact information as the periphery, and building a contact layer in a one-to-many form. Each customer may receive services from multiple salespersons in each business system. The present invention retains all customer-salesperson correspondences and contact information in the foreign key table, and compares the update time in each business system. First, the salesperson who served the last time is determined, and the contact information of the last service is recorded as the main contact information of the customer. Other contact information is retained in the foreign key table and used.

[0068] The module architecture of the first extended dimension layer obtained is as follows: core dimension: certificate information; extended dimension: salesperson code, mobile phone number, landline number, address, zip code, etc.; update standard: based on the most recent service, all contact information is retained, and the latest updated records are marked.

[0069] S4: Collect business information from the data source, establish a foreign key table according to the business information, and obtain a second extended dimension layer.

[0070] Wherein, step S4 further comprises:

[0071] S41: The business system in the data source collects business information; the business information is a business tag.

[0072] The business information mentioned in step S41 specifically refers to business tags, which are keywords or phrases describing customer attributes, behaviors, etc., and are used for subsequent analysis and marketing. In step S41, these business tag information are extracted from the OLTP system for further processing and integration.

[0073] Wherein, the business system in step S41 is an OLTP system.

[0074] Furthermore, the business system in this embodiment refers to an OLTP (Online Transaction Processing) system. The OLTP system is mainly used to process daily business affairs, such as order processing, inventory management, customer record maintenance, etc. They usually contain rich business information, which in this embodiment is the corresponding label information for customer record maintenance.

[0075] S42: storing the business information in corresponding foreign key tables based on the primary key information of the central dimension layer to obtain a second extended dimension layer.

[0076] The purpose of step S4 is to merge customer labels, that is, to aggregate various types of label information in each oltp system according to the dimension layer, generate a label layer, generate labels for the key indicators of each system, and merge them according to the certificate information to generate a label foreign key table.

[0077] The structure of the second extended dimension layer obtained is: core dimension: certificate information; extended dimension: business system 1 label 1, business system 1 label 2, business system 1 label 3, business system 2 label 1, business system 2 label 2, business system 2 label 3...

[0078] S5: The central dimension layer, the first extended dimension layer, and the second dimension layer are integrated to obtain a customer information model.

[0079] Wherein, in step S5, the first extended dimension layer and the second dimension layer are connected to the central dimension layer by using the left connection method.

[0080] In steps S2 to S4, the central dimension layer structure obtained is: primary key: usually the unique identifier of the customer, such as certificate information (ID number, passport number, etc.); function: as the core of the customer information model, all other extended dimension layer information will be associated with it.

[0081] The first extended dimension layer (contact information): Foreign key: a field in the contact information table (usually the customer's ID information), which is used to match the primary key of the central dimension layer; Connection method: Use the left join (LEFT JOIN) method to match the records in the contact information table with the records in the central dimension layer. If a record in the central dimension layer has no corresponding record in the contact information table, the contact information part of the record in the result set will be empty (NULL).

[0082] The second extended dimension layer (business information / label): Foreign key: a field in the business information / label table (also the customer's ID information), used to match the primary key of the central dimension layer; Connection method: also use the left connection method to match the records in the business information / label table with the records in the central dimension layer, so that each customer's record in the central dimension layer will be associated with label information from different business systems.

[0083] In step S5, first prepare the data, namely the above-mentioned central dimension layer table, the first extended dimension layer table, and the second extended dimension layer table; then perform the connection, use the SQL query statement, and connect the three tables through the left connection method. The final result set is a table containing complete customer information.

[0084] like Figure 2 As shown, the present invention also provides a customer information model building device for the insurance industry, comprising:

[0085] Collection module 100: collects customer information, contact information and business information from data sources;

[0086] Central dimension building module 200: used to build a file using the unique identifier in the customer information as the primary key to obtain a central dimension layer;

[0087] The first extended dimension establishment module 300 is used to establish a foreign key table according to the contact information to obtain a first extended dimension layer;

[0088] The second extended dimension establishment module 400 is used to establish a foreign key table according to the business information to obtain a second extended dimension layer;

[0089] Fusion module 500: used to fuse the central dimension layer, the first extended dimension layer, and the second dimension layer to obtain a customer information model.

[0090] The present invention also provides a customer information model building device for the insurance industry, comprising:

[0091] A memory and at least one processor, wherein instructions are stored in the memory;

[0092] At least one of the processors calls the instructions in the memory to enable the customer information model building device for the insurance industry to execute the customer information model building method for the insurance industry as described in any of the above items.

[0093] The present invention also provides a computer-readable storage medium having instructions stored thereon, and when the instructions are executed by a processor, the method for building a customer information model for the insurance industry as described in any one of the above items is implemented.

[0094] Furthermore, a customer information model building device for the insurance industry provided by the present invention may have relatively large differences due to different configurations or performances, and may include one or more processors (central processing units, CPU), for example, one or more processors and memories, one or more storage media for storing applications or data, such as one or more massive storage devices, wherein the memories and storage media may be short-term storage or persistent storage, and the program stored in the storage medium may include one or more modules, each module may include a series of instruction operations in the customer information model building device for the insurance industry, and further, the processor may be configured to communicate with the storage medium to execute a series of instruction operations in the storage medium on the customer information model building device for the insurance industry.

[0095] It may also include one or more power supplies, one or more wired or wireless network interfaces, one or more input and output interfaces, and one or more operating systems, such as Windows Server, Mac OS X, Unix, Linux, FreeBSD, etc. Those skilled in the art will appreciate that the structure of the equipment for building a customer information model for the insurance industry provided by the present invention does not constitute a limitation on the equipment, and may include more or fewer components than shown in the figure, or combine certain components, or arrange components differently.

[0096] Firstly, the present invention aims to solve the problem that there is a lack of unified standards for customer file creation. Some applications use customer mobile phone numbers to create files, while some applications use customer ID numbers to create files. There is a lack of comparison between them, which makes it impossible to connect and share resources. Secondly, there is a lack of unified standards for the allocation of service personnel. For example, most business departments designate the salesperson who opened the most recent order as the customer service personnel, while other departments may designate the salesperson who opened the order in a specified scenario as the customer service personnel. As a result, the same customer may frequently change service personnel, which reduces customer satisfaction to a certain extent.

[0097] The present invention provides a method, device, equipment and storage medium for building a customer information model for the insurance industry, which first unifies the customer file creation standard: the present invention uses the unique identifier in the customer information (such as identity card number, passport number, etc.) as the primary key to create a file, thereby obtaining a central dimension layer, solving the problem of lack of unified standards for customer file creation, and enabling customer information between different applications and departments to be compared with each other, and resources to be connected and shared.

[0098] Secondly, the allocation of service personnel is optimized: by collecting and analyzing customer contact information, the present invention can identify the latest contact record of each customer and determine the main service personnel accordingly, thus avoiding the problem of customers frequently changing service personnel due to different departments allocating service personnel according to different standards, and improving customer satisfaction.

[0099] Third, it enriches the customer information dimension: the present invention not only establishes a central dimension layer including basic customer information and identity information, but also establishes a first extended dimension layer and a second extended dimension layer respectively by collecting contact information and business information. The extended dimension layer provides a richer customer view, which helps enterprises to understand customers more comprehensively.

[0100] Fourth, the data integration and analysis capabilities are improved: by integrating the central dimension layer, the first extended dimension layer and the second extended dimension layer, the present invention obtains a customer information model. This model supports multi-dimensional and multi-level analysis of customers, which helps enterprises accurately identify groups such as high-quality customers, low-heat customers, and dormant customers, so as to formulate targeted service methods and customer maintenance strategies.

[0101] Fifth, it improves business efficiency and decision-making support: The customer information model provided by the present invention can provide enterprises with a unified and comprehensive customer information view, which helps to improve business processing efficiency. At the same time, through in-depth analysis of customer information, enterprises can make more accurate decisions, optimize resource allocation, and improve market competitiveness.

[0102] Finally, it also supports flexible expansion and adaptability: the customer information model building method of the present invention has good flexibility and adaptability. As the business of an enterprise develops and changes, it is possible to easily add new dimension layers or adjust the content of existing dimension layers to meet the actual needs of the enterprise.

[0103] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the embodiments of the present invention, rather than to limit them. Although the present invention has been described in detail with reference to the above embodiments, those skilled in the art should understand that they can still modify the technical solutions recorded in the above embodiments, or replace some of the technical features therein by equivalents; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the embodiments of the present invention. Any changes or replacements that can be easily thought of by those skilled in the art within the technical scope disclosed in the present invention should be covered within the protection scope of the present invention.

Claims

1. A method for building a customer information model in the insurance industry, characterized in that: include: S1: Collect customer information from data sources; S2: Using the unique identifier in the customer information as the primary key, create a file to obtain a central dimension layer; S3: collecting contact information from the data source, establishing a foreign key table according to the contact information, and obtaining a first extended dimension layer; S4: collecting business information from the data source, establishing a foreign key table according to the business information, and obtaining a second extended dimension layer; S5: The central dimension layer, the first extended dimension layer, and the second dimension layer are integrated to obtain a customer information model.

2. A method for building a customer information model for the insurance industry according to claim 1, characterized in that: The unique identifier in step S2 is the identity information in the customer information.

3. A method for building a customer information model for the insurance industry according to claim 1, characterized in that: Step S3 further comprises: S31: Collect contact information from data sources; S32: Pulling multiple contact records from the contact information; S33: Identify the latest contact record among multiple contact records; S34: All contact records and the latest contact record are stored in corresponding foreign key tables based on the primary key information of the central dimension layer to obtain a first extended dimension layer.

4. A method for building a customer information model for the insurance industry according to claim 3, characterized in that: Step S33 also includes: The latest contact record is marked.

5. A method for building a customer information model for the insurance industry according to claim 1, characterized in that: Step S4 further comprises: S41: The business system in the data source collects business information; the business information is a business tag; S42: storing the business information in corresponding foreign key tables based on the primary key information of the central dimension layer to obtain a second extended dimension layer.

6. A method for building a customer information model for the insurance industry according to claim 5, characterized in that: The business system in step S41 is an OLTP system.

7. A method for building a customer information model for the insurance industry according to claim 1, characterized in that: In step S5, the first extended dimension layer and the second dimension layer are connected to the central dimension layer by using the left connection method.

8. A customer information model building device for the insurance industry, characterized in that: include: Collection module: collects customer information, contact information and business information from data sources; Central dimension establishment module: used to establish a file with the unique identifier in the customer information as the primary key to obtain the central dimension layer; A first extended dimension establishment module: used to establish a foreign key table according to the contact information to obtain a first extended dimension layer; A second extended dimension establishment module: used to establish a foreign key table according to the business information to obtain a second extended dimension layer; Fusion module: used to fuse the central dimension layer, the first extended dimension layer, and the second dimension layer to obtain a customer information model.

9. A customer information model building device for the insurance industry, characterized in that: include: A memory and at least one processor, wherein instructions are stored in the memory; At least one of the processors calls the instructions in the memory to enable the customer information model building device for the insurance industry to execute the customer information model building method for the insurance industry as described in any one of claims 1-7.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores instructions, and when the instructions are executed by the processor, the method for building a customer information model for the insurance industry according to any one of claims 1-7 is implemented.

Images