Customer archive data management method and device, equipment and medium

Abstract

The invention relates to the technical field of big data, and discloses a customer archive data management method, which comprises the steps of generating initial customer archive information based on acquired customer information; performing automatic verification on the initial customer archive information, and obtaining compliance archive information when a compliance requirement is met; performing consistency comparison on the compliance archive information and the existing information, and when the consistency comparison is passed, defining a verification task through a data verification model to verify the compliance archive information, and generating verification archive data; obtaining an abnormal problem in the verification process, analyzing the abnormal problem, tracking a data source and a data flow direction, and obtaining a data traceability record; and obtaining an analysis result of analyzing the abnormal problem, making a data governance plan in combination with the data traceability record, performing data governance through the data governance plan, and generating a data quality analysis result. The invention further provides a customer archive data management device and equipment and a storage medium. According to the invention, the data management efficiency can be improved.

Description

Technical Field

[0001] The present invention relates to the field of big data technology, and in particular to a customer profile data management method, device, equipment and medium. Background Art

[0002] The existing marketing customer data archives and distribution basic data are of low quality, which brings difficulties to the application of power grid data, marketing proactive services, precision services, and channel online services. Inaccurate basic customer information will cause the accuracy of customer tag information to decrease, and it will be impossible to obtain effective customer behavior analysis and attribute analysis results, and the corresponding personalized services and precision services will be difficult to carry out. For example, when implementing the phased reduction of corporate electricity costs and supporting enterprises to resume work and production, it is found that there are high-energy-consuming industries in the system that are actually non-high-energy-consuming industries, which will lead to problems in policy implementation, so data governance needs to be carried out in a timely manner.

[0003] However, the current data quality governance work is still mainly based on traditional quantitative statistics, lacking in-depth analysis of multiple dimensions and unable to trace the source of problems. After the business is deeply developed, the data problems found in the subject data and scenario data generated on the basic data cannot be tracked and traced. We can only passively wait for customer feedback and other channels to discover problems before making targeted rectifications, which makes data governance inefficient. Summary of the invention

[0004] The present invention provides a customer file data management method, device, equipment and medium, the main purpose of which is to improve the efficiency of data management.

[0005] To achieve the above object, the present invention provides a method for managing customer profile data, comprising:

[0006] Collect information provided by customers through the power grid's collection system, and enter the collected customer information into the power grid's marketing management system to generate initial customer file information;

[0007] Automatically verifying the initial customer file information through a preset data verification rule, and obtaining compliance file information based on the verified initial customer file information when the information in the initial customer file information meets the preset compliance requirements;

[0008] Compare the compliance file information with the existing information in the marketing management system for consistency, and when the consistency comparison passes, verify the compliance file information through a preset data verification model to define a verification task to generate verification file data;

[0009] By monitoring the compliance file information verification process, obtaining abnormal problems in the verification process, analyzing the abnormal problems, tracing the data source and flow, and obtaining data traceability records;

[0010] Obtain analysis results of the abnormal problem, formulate a data governance plan in combination with the data traceability record and the verification archive data, perform data governance through the data governance plan, and obtain data quality analysis results.

[0011] Optionally, the automatic verification of the initial customer file information by using a preset data verification rule, and when the information in the initial customer file information meets the preset compliance requirements, obtaining compliance file information based on the verified initial customer file information, includes:

[0012] Acquire various business requirements in the data verification rules, and automatically verify the initial customer file information according to the business requirements to obtain the initial customer file information that has passed the verification;

[0013] The system consistency verification rules in the compliance requirements are extracted, and the initial customer file information that has passed the verification is re-verified according to the system consistency verification rules, and when the verification passes, the compliance file information is obtained.

[0014] Optionally, the verifying the compliance file information by defining a verification task through a preset data verification model to generate verification file data includes:

[0015] Extracting the entity table in the data verification model to obtain model entity table information, and setting the parameters of the verification task according to the model entity table information;

[0016] The verification task is configured based on the data verification model, and the compliance file information is verified by setting the execution cycle and execution conditions of the verification task to generate the verification file data.

[0017] Optionally, configuring a verification task based on the data verification model, and verifying the compliance file information by setting an execution cycle and execution conditions of the verification task to generate the verification file data includes:

[0018] Automatically monitor the triggering conditions of the verification task through a preset verification task scheduling program, and when the verification task is satisfied, automatically execute the data verification task through the task scheduling program;

[0019] When the task scheduling program automatically executes the data verification task, if an exception occurs in the verification task, supplementary processing is automatically performed according to preset exception handling rules to generate verification file data, wherein the supplementary processing includes re-executing the verification task and notifying the system administrator to handle the exception.

[0020] Optionally, after monitoring the compliance file information verification process and obtaining abnormal problems in the verification process, the method further includes:

[0021] Performing quality monitoring on the abnormal problem and generating a quality monitoring result, wherein the quality monitoring result includes the object name, occurrence time, violation rule, level, and status;

[0022] A detailed result table is generated based on the quality monitoring results, and the user is allowed to customize the fields of the detailed result table according to analysis needs, providing data basis for the user to conduct rich and colorful data quality analysis.

[0023] Optionally, obtaining an analysis result of analyzing the abnormal problem includes:

[0024] Use the preset data quality monitoring tools to continuously monitor compliance file information to identify and mark abnormal data, and record all abnormal issues through the marketing management system, where the abnormal issues include the type of issue, the time of occurrence, and the affected data items;

[0025] For each abnormal problem, analyze the source and flow of data, identify the source table, source field and all related traceability tables, and obtain the data traceability flow;

[0026] Analyze the data change trends of the abnormal problems, identify the patterns and frequencies of data changes, and find out potential data processing bottlenecks and risk points;

[0027] The data traceability flow is analyzed based on the data processing bottlenecks and risk points to obtain analysis results of abnormal problems, wherein the abnormal analysis results include the cause of the abnormality, the scope of abnormal impact and the recommended repair measures for the abnormality.

[0028] Optionally, after analyzing the abnormal problem, tracing the data source and flow, and obtaining the data traceability record, the method further includes:

[0029] The entire life cycle process of data traceability is displayed through a graphical interface, making the data flow path visible, which helps managers directly understand the data change process, analyze data change trends, and identify potential data processing bottlenecks or risk points.

[0030] In order to solve the above problems, the present invention also provides a customer profile data management device, the device comprising:

[0031] The file generation module is used to collect information provided by customers through the power grid's collection system, and enter the collected customer information into the power grid's marketing management system to generate initial customer file information;

[0032] A file verification module is used to automatically verify the initial customer file information through preset data verification rules, and when the information in the initial customer file information meets the preset compliance requirements, obtain compliance file information based on the initial customer file information that has passed the verification; compare the compliance file information with the existing information in the marketing management system for consistency, and when the consistency comparison passes, verify the compliance file information through a preset data verification model definition verification task to generate verification file data;

[0033] The data tracing module is used to monitor the compliance file information verification process, obtain abnormal problems in the verification process, analyze the abnormal problems, track the source and flow of data, and obtain data tracing records;

[0034] The data governance module is used to obtain the analysis results of the abnormal problem, and formulate a data governance plan in combination with the data traceability record and the verification archive data, and perform data governance through the data governance plan to obtain data quality analysis results.

[0035] In order to solve the above problem, the present invention further provides an electronic device, the electronic device comprising:

[0036] at least one processor; and,

[0037] a memory communicatively connected to the at least one processor; wherein,

[0038] The memory stores a computer program that can be executed by the at least one processor, and the computer program is executed by the at least one processor to enable the at least one processor to perform the customer profile data governance method as described above.

[0039] In order to solve the above problems, the present invention also provides a computer-readable storage medium, including a data storage area and a program storage area, the data storage area stores created data, and the program storage area stores a computer program; wherein, when the computer program is executed by a processor, the customer profile data management method as described above is implemented.

[0040] The embodiment of the present invention generates initial customer file information by collecting information provided by customers and entering the collected customer information into the marketing management system of the power grid; automatically verifies the initial customer file information through data verification rules, and when the information in the initial customer file information meets the compliance requirements, obtains compliance file information based on the verified initial customer file information, thereby realizing compliance verification of the file information; compares the compliance file information with the existing information in the marketing management system for consistency, and when the consistency comparison passes, verifies the compliance file information through a verification task defined by a preset data verification model, thereby generating verification file data; monitors the verification process of the compliance file information, obtains abnormal problems in the verification process, analyzes the abnormal problems, tracks the source and flow of data, obtains data traceability records, and achieves the purpose of data traceability; finally, obtains the analysis results of the abnormal problems, and formulates a data governance plan in combination with the data traceability records and the verification file data, performs data governance through the data governance plan, and obtains data quality analysis results. Therefore, the customer file data governance method, device, electronic device and computer-readable storage medium proposed in the present invention obtain compliance file information by automatically verifying the initial customer file information, and verify the compliance file information again through the data verification model to build a verification task to generate verification file data, and build a data governance plan through the data traceability in the data verification process and the abnormal analysis results of abnormal problems to perform data governance, thereby improving the efficiency of data governance. BRIEF DESCRIPTION OF THE DRAWINGS

[0041] Figure 1 A schematic diagram of a process of a customer profile data management method provided by an embodiment of the present invention;

[0042] Figure 2 A schematic diagram of a module of a customer profile data management device provided by an embodiment of the present invention;

[0043] Figure 3 A schematic diagram of the internal structure of an electronic device for implementing a method for managing customer profile data provided by one embodiment of the present invention.

[0044] The realization of the purpose, functional features and advantages of the present invention will be further explained in conjunction with embodiments and with reference to the accompanying drawings. DETAILED DESCRIPTION

[0045] It should be understood that the specific embodiments described herein are only used to explain the present invention, and are not used to limit the present invention.

[0046] The embodiment of the present application provides a method for managing customer profile data. The execution subject of the customer profile data management method includes but is not limited to at least one of the electronic devices such as a server and a terminal that can be configured to execute the method provided by the embodiment of the present application. Among them, the server can be an independent server, or it can be 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, content delivery networks (Content Delivery Network, CDN), and big data and artificial intelligence platforms. In other words, the customer profile data management method can be executed by software or hardware installed on a remote device or a server device, and the software can be a blockchain platform. The server includes but is not limited to: a single server, a server cluster, a cloud server or a cloud server cluster, etc.

[0047] Reference Figure 1 FIG. 1 is a flow chart of a method for managing customer profile data provided by an embodiment of the present invention. In this embodiment, the method for managing customer profile data includes the following steps S1-S5:

[0048] S1. Collect the information provided by the customer through the power grid's collection system, and enter the collected customer information into the power grid's marketing management system to generate initial customer file information.

[0049] It is understandable that before managing customer file data, it is necessary to first obtain the customer file data, build a data management plan that matches the customer file data in the power grid based on the customer file data, and manage the customer file data according to the data management plan.

[0050] In an embodiment of the present invention, the customer profile data is a set of key information about power users collected and maintained by the power company, covering the user's basic information, electricity contract details, electricity metering data, power supply conditions, electricity usage behavior characteristics, asset information, service history, collection information, and data verification results, etc. These data are crucial for providing personalized services, ensuring the accuracy and efficiency of business processes, and conducting risk management.

[0051] Among them, the basic information includes the customer's name, contact information, address, electricity usage category, industry classification, etc., and electricity metering includes electricity meter information, metering point information, transformer information, wiring method, commissioning date, whether load control is installed, etc.

[0052] In an embodiment of the present invention, the marketing management system may also be referred to as an electric power marketing information management system, which is a comprehensive information platform specially designed for marketing and customer service activities in the electric power industry. It integrates customer relationship management, contract management, electricity price strategy, metering and billing, fee management, market analysis, marketing activity execution, service quality management, data collection and integration, and report generation, etc., aiming to improve the service efficiency of electric power companies, optimize customer experience, and support compliance management and decision making.

[0053] Furthermore, after obtaining the customer file data, on-site operation verification can be carried out, which is a method of verifying the accuracy and completeness of the data through on-site visits and inspections during the data collection, processing and storage process. This verification can ensure that the information in the customer file is the latest and most accurate, and it also helps to discover and solve problems that may arise during the data collection process.

[0054] S2. Automatically verify the initial customer file information using preset data verification rules, and when the information in the initial customer file information meets the preset compliance requirements, obtain compliance file information based on the verified initial customer file information.

[0055] In an embodiment of the present invention, the preset data verification rules are a set of clearly defined criteria or standards for checking the accuracy, completeness, consistency and timeliness of data. These rules may include data formats, value ranges, logical relationships, business rules, etc., which are usually formulated based on business requirements and best practices in data management. The purpose of data verification rules is to ensure that data meets specific quality requirements during entry, processing and storage.

[0056] Furthermore, the data verification rules can be divided into 12 major categories, including integrity and accuracy verification of basic files, integrity and accuracy verification of power receiving points, integrity and accuracy verification of metering points, integrity and accuracy verification of power supply and use contracts, integrity verification of collection points, integrity verification of high-voltage user transformers, and integrity verification of operating electricity meters and transformers.

[0057] Among them, the 12 major categories can be further divided into 178 subcategories, as shown in Table 1:

[0058]

[0059]

[0060]

[0061]

[0062]

[0063] Table 1

[0064] In the embodiment of the present invention, the compliance requirements refer to a series of predefined rules and standards to ensure the accuracy, completeness and consistency of customer profile information, and to comply with the business specifications and data quality requirements specified by the power company or related industries. The compliance requirements include the completeness of required fields, data logic correctness, format standardization, data consistency, data timeliness, data verifiability, compliance with specific business rules, data security and privacy protection.

[0065] The completeness of the required fields is used to ensure that all necessary customer information fields have been filled in without omission. The format standardization requirement is used to ensure that all input data must comply with specific format requirements, such as date, telephone number, voltage level, etc.

[0066] In another embodiment of the present invention, the compliance requirements can also be divided into 3 categories and 26 sub-items: consistency check between marketing management systems and marketing management systems (Marketing Management System, MDS), consistency check between marketing management systems and acquisition systems, and consistency check between marketing and production management systems (Production Management System, PMS). As shown in Table 2:

[0067]

[0068]

[0069] Table 2

[0070] Furthermore, the main difference between the data verification rules and the compliance requirements is that the data verification rules are more specific and focus on the quality of the data itself to ensure the availability and reliability of the data, while the compliance requirements focus on the legality and standardization of the data.

[0071] In an embodiment of the present invention, the automatic verification of the initial customer file information by using a preset data verification rule, and when the information in the initial customer file information meets the preset compliance requirements, obtaining the compliance file information based on the verified initial customer file information, includes:

[0072] Acquire various business requirements in the data verification rules, and automatically verify the initial customer file information according to the business requirements to obtain the initial customer file information that has passed the verification;

[0073] The system consistency verification rules in the compliance requirements are extracted, and the initial customer file information that has passed the verification is re-verified according to the system consistency verification rules, and when the verification passes, the compliance file information is obtained.

[0074] S3. Compare the compliance file information with the existing information in the marketing management system for consistency. When the consistency comparison passes, define a verification task through a preset data verification model to verify the compliance file information and generate verification file data.

[0075] In the embodiment of the present invention, the data verification model is the basic unit of data quality analysis, which consists of a set of entity tables and a set of rules. When defining a verification task, the user formulates it based on the verification model to ensure that tasks are independent of each other and do not interfere with each other. By executing the verification task, the data quality analysis results that the user is concerned about can be obtained, such as detailed information of the problem data, data quality analysis results and analysis reports, etc.

[0076] Among them, the verification model includes multiple dimensions, such as the user side dimension (sudden increase and decrease of electricity, key users) and the grid side dimension (distribution network), etc., which are used to ensure the integrity, accuracy, logic, timeliness, etc. of the data, thereby improving the overall quality of the data.

[0077] Furthermore, the verification task is defined by a preset data verification model to verify the compliance file information and generate verification file data, including:

[0078] Extracting the entity table in the data verification model to obtain model entity table information, and setting the parameters of the verification task according to the model entity table information;

[0079] The verification task is configured based on the data verification model, and the compliance file information is verified by setting the execution cycle and execution conditions of the verification task to generate the verification file data.

[0080] In the embodiment of the present invention, by executing the verification task, the data quality analysis results that the user is concerned about can be obtained, such as detailed information of the problem data, data quality analysis results and analysis reports, etc.

[0081] Further, configuring the verification task based on the data verification model, and verifying the compliance file information by setting the execution cycle and execution conditions of the verification task to generate the verification file data, includes:

[0082] Automatically monitor the triggering conditions of the verification task through a preset verification task scheduling program, and when the verification task is satisfied, automatically execute the data verification task through the task scheduling program;

[0083] When the task scheduling program automatically executes the data verification task, if an exception occurs in the verification task, supplementary processing is automatically performed according to preset exception handling rules to generate verification file data, wherein the supplementary processing includes re-executing the verification task and notifying the system administrator to handle the exception.

[0084] In an embodiment of the present invention, the task scheduler is an automated system component that is responsible for monitoring trigger conditions, executing verification tasks, monitoring task status, handling abnormal situations, and can run automatically according to a periodic plan to ensure the continuity, accuracy and timeliness of the data quality management process.

[0085] S4. By monitoring the compliance file information verification process, abnormal problems in the verification process are obtained, and the abnormal problems are analyzed, the source and flow of data are tracked, and data traceability records are obtained.

[0086] It can be understood that by tracing the source of abnormal problems in the monitoring archive information, the entire life cycle of abnormal data from the source to the current state can be tracked and analyzed, including identifying the origin of the data, assessing the scope of impact, locating the root cause of the problem, managing risks, improving data quality, meeting compliance requirements, optimizing data governance processes, recording user operation behaviors, and enhancing the transparency and trust of data processing, thereby providing a solid foundation for data-driven decision-making.

[0087] In the embodiment of the present invention, after the compliance file information verification process is monitored and abnormal problems in the verification process are obtained, the method further includes:

[0088] Performing quality monitoring on the abnormal problem and generating a quality monitoring result, wherein the quality monitoring result includes the object name, occurrence time, violation rule, level, and status;

[0089] A detailed result table is generated based on the quality monitoring results, and the user is allowed to customize the fields of the detailed result table according to analysis needs, providing data basis for the user to conduct rich and colorful data quality analysis.

[0090] Furthermore, the results of the inspection can be used to warn through the interface, email, text message (text message equipment is required), etc., and the problem handling process can be automatically or manually initiated.

[0091] Furthermore, after the verification process of the compliance file information is monitored, abnormal problems in the verification process are obtained, and the abnormal problems are analyzed, the data source and flow are tracked, and the data traceability record is obtained, the method may also include:

[0092] After the abnormal problem verification task is completed, the processing results are counted and the completed abnormal problem is verified again. The verification results are displayed in a pass / fail format.

[0093] In another embodiment of the present invention, the data support items required for displaying various abnormal problems can be sorted out according to the abnormal content and display logic rules, the display content can be divided according to the user level, and the relevant abnormal problem discovery and processing process can be displayed.

[0094] In the embodiment of the present invention, after analyzing the abnormal problem, tracing the data source and flow, and obtaining the data traceability record, the method further includes:

[0095] The entire life cycle process of data traceability is displayed through a graphical interface, making the data flow path visible, which helps managers directly understand the data change process, analyze data change trends, and identify potential data processing bottlenecks or risk points.

[0096] S5. Obtain analysis results of the abnormal problem, formulate a data governance plan in combination with the data traceability record and the verification file data, perform data governance through the data governance plan, and obtain data quality analysis results.

[0097] In an embodiment of the present invention, the data governance plan is a comprehensive plan developed by an organization to ensure the effective management of data assets. It includes clarifying the goals, standards, monitoring, security, compliance, lifecycle management, technical architecture, personnel responsibilities, training, risk control and continuous improvement of data management, so as to improve data quality, ensure data security, and support the organization's business decisions and operational efficiency.

[0098] Further, the obtaining of the analysis result of the abnormal problem includes:

[0099] Use the preset data quality monitoring tools to continuously monitor compliance file information to identify and mark abnormal data, and record all abnormal issues through the marketing management system, where the abnormal issues include the type of issue, the time of occurrence, and the affected data items;

[0100] For each abnormal problem, analyze the source and flow of data, identify the source table, source field and all related traceability tables, and obtain the data traceability flow;

[0101] Analyze the data change trends of the abnormal problems, identify the patterns and frequencies of data changes, and find out potential data processing bottlenecks and risk points;

[0102] The data traceability flow is analyzed based on the data processing bottlenecks and risk points to obtain analysis results of abnormal problems, wherein the abnormal analysis results include the cause of the abnormality, the scope of abnormal impact and the recommended repair measures for the abnormality.

[0103] In another embodiment of the present invention, a data governance plan can be regularly specified, data governance work can be carried out regularly, and defects can be eliminated item by item by various methods such as system data rectification and on-site problem rectification. Data governance is divided by province, and on the provincial side, according to the data verification model and the verification rules under the model, special data verification and governance tasks are formulated on a monthly basis to verify the data of the whole province, and the verification results of abnormal problems can be viewed after the verification.

[0104] The embodiment of the present invention generates initial customer file information by collecting information provided by customers and entering the collected customer information into the marketing management system of the power grid; automatically verifies the initial customer file information through data verification rules, and when the information in the initial customer file information meets the compliance requirements, obtains compliance file information based on the verified initial customer file information, thereby realizing compliance verification of the file information; compares the compliance file information with the existing information in the marketing management system for consistency, and when the consistency comparison passes, verifies the compliance file information through a verification task defined by a preset data verification model, thereby generating verification file data; monitors the verification process of the compliance file information, obtains abnormal problems in the verification process, analyzes the abnormal problems, tracks the source and flow of data, obtains data traceability records, and achieves the purpose of data traceability; finally, obtains the analysis results of the abnormal problems, and formulates a data governance plan in combination with the data traceability records and the verification file data, performs data governance through the data governance plan, and obtains data quality analysis results. Therefore, the customer file data governance method, device, electronic device and computer-readable storage medium proposed in the present invention obtain compliance file information by automatically verifying the initial customer file information, and verify the compliance file information again through the data verification model to build a verification task to generate verification file data, and build a data governance plan through the data traceability in the data verification process and the abnormal analysis results of abnormal problems to perform data governance, thereby improving the efficiency of data governance.

[0105] like Figure 2 The figure is a schematic diagram of the modules of the customer profile data management device of the present invention.

[0106] The customer profile data management device 100 of the present invention can be installed in an electronic device. According to the functions to be implemented, the customer profile data management device can include a profile generation module 101, a profile verification module 102, a data tracing module 103 and a data management module 104. The module of the present invention can also be called a unit, which refers to a series of computer program segments that can be executed by an electronic device processor and can complete fixed functions, which are stored in the memory of the electronic device.

[0107] In this embodiment, the functions of each module / unit are as follows:

[0108] The file generation module 101 is used to collect information provided by customers through the collection system of the power grid, and enter the collected customer information into the marketing management system of the power grid to generate initial customer file information;

[0109] The file verification module 102 is used to automatically verify the initial customer file information through preset data verification rules, and when the information in the initial customer file information meets the preset compliance requirements, obtain compliance file information based on the initial customer file information that has passed the verification; compare the compliance file information with the existing information in the marketing management system for consistency, and when the consistency comparison passes, define a verification task through a preset data verification model to verify the compliance file information and generate verification file data;

[0110] The data tracing module 103 is used to monitor the compliance file information verification process, obtain abnormal problems in the verification process, analyze the abnormal problems, track the source and flow of data, and obtain data tracing records;

[0111] The data governance module 104 is used to obtain the analysis results of the abnormal problem, and formulate a data governance plan in combination with the data traceability record and the verification archive data, and perform data governance through the data governance plan to obtain data quality analysis results.

[0112] In detail, each module described in the customer profile data management device 100 in the embodiment of the present invention is used in the same manner as described above. Figure 1 The customer profile data management method has the same technical means and can produce the same technical effects, so they will not be repeated here.

[0113] like Figure 3 FIG. 1 is a schematic diagram of the structure of an electronic device for implementing the customer profile data management method of the present invention.

[0114] The electronic device may include a processor 10, a memory 11, a communication bus 12, and a communication interface 13, and may also include a computer program stored in the memory 11 and executable on the processor 10, such as a customer profile data management program.

[0115] In some embodiments, the processor 10 may be composed of an integrated circuit, for example, a single packaged integrated circuit, or a plurality of packaged integrated circuits with the same or different functions, including one or more central processing units (CPUs), microprocessors, digital processing chips, graphics processors, and combinations of various control chips. The processor 10 is the control core (ControlUnit) of the electronic device, and uses various interfaces and lines to connect various components of the entire electronic device, and executes various functions and processes data of the electronic device by running or executing programs or modules stored in the memory 11 (for example, executing customer profile data management programs, etc.), and calling data stored in the memory 11.

[0116] The memory 11 includes at least one type of readable storage medium, and the readable storage medium includes flash memory, mobile hard disk, multimedia card, card-type memory (for example: SD or DX memory, etc.), magnetic memory, disk, optical disk, etc. In some embodiments, the memory 11 can be an internal storage unit of an electronic device, such as a mobile hard disk of the electronic device. In other embodiments, the memory 11 can also be an external storage device of an electronic device, such as a plug-in mobile hard disk, a smart memory card (Smart Media Card, SMC), a secure digital (Secure Digital, SD) card, a flash card (Flash Card), etc. equipped on the electronic device. Further, the memory 11 can also include both an internal storage unit of the electronic device and an external storage device. The memory 11 can not only be used to store application software and various types of data installed in the electronic device, such as the code of the customer file data management program, but also can be used to temporarily store data that has been output or is to be output.

[0117] The communication bus 12 may be a Peripheral Component Interconnect (PCI) bus or an Extended Industry Standard Architecture (EISA) bus, etc. The bus may be divided into an address bus, a data bus, a control bus, etc. The bus is configured to realize connection and communication between the memory 11 and at least one processor 10, etc.

[0118] The communication interface 13 is used for communication between the above-mentioned electronic device and other devices, including a network interface and a user interface. Optionally, the network interface may include a wired interface and / or a wireless interface (such as a WI-FI interface, a Bluetooth interface, etc.), which is generally used to establish a communication connection between the electronic device and other electronic devices. The user interface may be a display (Display), an input unit (such as a keyboard (Keyboard)), and optionally, the user interface may also be a standard wired interface, a wireless interface. Optionally, in some embodiments, the display may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, and an OLED (Organic Light-Emitting Diode, organic light-emitting diode) touch device, etc. Among them, the display may also be appropriately referred to as a display screen or a display unit, which is used to display information processed in the electronic device and to display a visual user interface.

[0119] Figure 3 Only an electronic device with components is shown, and those skilled in the art will understand that Figure 3 The structure shown does not constitute a limitation on the electronic device, and may include fewer or more components than shown in the figure, or combine certain components, or arrange the components differently.

[0120] For example, although not shown, the electronic device may also include a power source (such as a battery) for supplying power to each component. Preferably, the power source may be logically connected to the at least one processor 10 through a power management device, so that the power management device can realize functions such as charging management, discharging management, and power consumption management. The power source may also include one or more DC or AC power sources, recharging devices, power failure detection circuits, power converters or inverters, power status indicators, and other arbitrary components. The electronic device may also include a variety of sensors, Bluetooth modules, Wi-Fi modules, etc., which will not be repeated here.

[0121] It should be understood that the embodiment is for illustration only and the scope of the patent application is not limited to this structure.

[0122] The customer profile data management program stored in the memory 11 in the electronic device is a combination of multiple computer programs. When running in the processor 10, it can achieve:

[0123] Collect information provided by customers through the power grid's collection system, and enter the collected customer information into the power grid's marketing management system to generate initial customer file information;

[0124] Automatically verifying the initial customer file information through a preset data verification rule, and obtaining compliance file information based on the verified initial customer file information when the information in the initial customer file information meets the preset compliance requirements;

[0125] Compare the compliance file information with the existing information in the marketing management system for consistency, and when the consistency comparison passes, verify the compliance file information through a preset data verification model to define a verification task to generate verification file data;

[0126] By monitoring the compliance file information verification process, obtaining abnormal problems in the verification process, analyzing the abnormal problems, tracing the data source and flow, and obtaining data traceability records;

[0127] Obtain analysis results of the abnormal problem, formulate a data governance plan in combination with the data traceability record and the verification archive data, perform data governance through the data governance plan, and obtain data quality analysis results.

[0128] Specifically, the specific implementation method of the processor 10 for the above computer program can refer to Figure 1 The description of the relevant steps in the corresponding embodiments will not be repeated here.

[0129] Furthermore, if the module / unit integrated in the electronic device is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a non-volatile computer-readable storage medium. The computer-readable storage medium can be volatile or non-volatile. For example, the computer-readable medium can include: any entity or device capable of carrying the computer program code, a recording medium, a USB flash drive, a mobile hard disk, a magnetic disk, an optical disk, a computer memory, and a read-only memory (ROM).

[0130] The present invention further provides 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 of an electronic device, the computer program can implement:

[0131] Collect information provided by customers through the power grid's collection system, and enter the collected customer information into the power grid's marketing management system to generate initial customer file information;

[0132] Automatically verifying the initial customer file information through a preset data verification rule, and obtaining compliance file information based on the verified initial customer file information when the information in the initial customer file information meets the preset compliance requirements;

[0133] Compare the compliance file information with the existing information in the marketing management system for consistency, and when the consistency comparison passes, verify the compliance file information through a preset data verification model to define a verification task to generate verification file data;

[0134] By monitoring the compliance file information verification process, obtaining abnormal problems in the verification process, analyzing the abnormal problems, tracing the data source and flow, and obtaining data traceability records;

[0135] Obtain analysis results of the abnormal problem, formulate a data governance plan in combination with the data traceability record and the verification archive data, perform data governance through the data governance plan, and obtain data quality analysis results.

[0136] In the several embodiments provided by the present invention, it should be understood that the disclosed devices, apparatuses and methods can be implemented in other ways. For example, the device embodiments described above are only schematic, for example, the division of the modules is only a logical function division, and there may be other division methods in actual implementation.

[0137] The modules described as separate components may or may not be physically separated, and the components shown as modules 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 modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0138] In addition, each functional module in each embodiment of the present invention may be integrated into one processing unit, 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 hardware plus software functional modules.

[0139] It is obvious to those skilled in the art that the present invention is not limited to the details of the above exemplary embodiments, and that the present invention can be implemented in other specific forms without departing from the spirit or essential characteristics of the present invention.

[0140] Therefore, no matter from which point of view, the embodiments should be regarded as illustrative and non-restrictive, and the scope of the present invention is limited by the appended claims rather than the above description, so it is intended that all changes falling within the meaning and scope of the equivalent elements of the claims are included in the present invention. Any attached figure mark in the claims should not be regarded as limiting the claims involved.

[0141] The blockchain referred to in this invention is a new application mode of computer technologies such as distributed data storage, peer-to-peer transmission, consensus mechanism, encryption algorithm, etc. Blockchain is essentially a decentralized database, a string of data blocks generated by cryptographic methods. Each data block contains a batch of network transaction information, which is used to verify the validity of its information (anti-counterfeiting) and generate the next block. Blockchain can include the underlying blockchain platform, platform product service layer, and application service layer.

[0142] The embodiments of the present application can acquire and process relevant data based on artificial intelligence technology. Among them, 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.

[0143] In addition, it is clear that the word "comprising" does not exclude other units or steps, and the singular does not exclude the plural. Multiple units or devices stated in the system claim can also be implemented by one unit or device through software or hardware. The second and other words are used to indicate names, but not to indicate any particular order.

[0144] Finally, it should be noted that the above embodiments are only used to illustrate the technical solution of the present invention rather than to limit it. Although the present invention has been described in detail with reference to the preferred embodiments, those skilled in the art should understand that the technical solution of the present invention can be modified or replaced by equivalents without departing from the spirit and scope of the technical solution of the present invention.

Claims

1. A customer file data management method, characterized in that: The method comprises: Collect information provided by customers through the power grid's collection system, and enter the collected customer information into the power grid's marketing management system to generate initial customer file information; Automatically verifying the initial customer file information through a preset data verification rule, and obtaining compliance file information based on the verified initial customer file information when the information in the initial customer file information meets the preset compliance requirements; Compare the compliance file information with the existing information in the marketing management system for consistency, and when the consistency comparison passes, verify the compliance file information through a preset data verification model to define a verification task to generate verification file data; By monitoring the compliance file information verification process, obtaining abnormal problems in the verification process, analyzing the abnormal problems, tracing the data source and flow, and obtaining data traceability records; Obtain analysis results of the abnormal problem, formulate a data governance plan in combination with the data traceability record and the verification archive data, perform data governance through the data governance plan, and obtain data quality analysis results.

2. The customer profile data management method according to claim 1, characterized in that: The automatic verification of the initial customer file information by using a preset data verification rule, and obtaining compliance file information based on the verified initial customer file information when the information in the initial customer file information meets the preset compliance requirements, includes: Acquire various business requirements in the data verification rules, and automatically verify the initial customer file information according to the business requirements to obtain the initial customer file information that has passed the verification; The system consistency verification rules in the compliance requirements are extracted, and the initial customer file information that has passed the verification is re-verified according to the system consistency verification rules, and when the verification passes, the compliance file information is obtained.

3. The customer profile data management method according to claim 1, characterized in that: The verification task is defined by a preset data verification model to verify the compliance file information and generate verification file data, including: Extracting the entity table in the data verification model to obtain model entity table information, and setting the parameters of the verification task according to the model entity table information; The verification task is configured based on the data verification model, and the compliance file information is verified by setting the execution cycle and execution conditions of the verification task to generate the verification file data.

4. The customer profile data management method according to claim 3, characterized in that: The configuring the verification task based on the data verification model, and verifying the compliance file information by setting the execution cycle and execution conditions of the verification task to generate the verification file data, includes: Automatically monitor the triggering conditions of the verification task through a preset verification task scheduling program, and when the verification task is satisfied, automatically execute the data verification task through the task scheduling program; When the task scheduling program automatically executes the data verification task, if an exception occurs in the verification task, supplementary processing is automatically performed according to preset exception handling rules to generate verification file data, wherein the supplementary processing includes re-executing the verification task and notifying the system administrator to handle the exception.

5. The customer profile data management method according to claim 1, characterized in that: After monitoring the compliance file information verification process and obtaining abnormal problems in the verification process, the method further includes: Performing quality monitoring on the abnormal problem and generating a quality monitoring result, wherein the quality monitoring result includes the object name, occurrence time, violation rule, level, and status; A detailed result table is generated based on the quality monitoring results, and the user is allowed to customize the fields of the detailed result table according to analysis needs, providing data basis for the user to conduct rich and colorful data quality analysis.

6. The method for managing customer file data according to claim 1, characterized in that: The obtaining of the analysis result of the abnormal problem includes: Use the preset data quality monitoring tools to continuously monitor compliance file information to identify and mark abnormal data, and record all abnormal issues through the marketing management system, where the abnormal issues include the type of issue, the time of occurrence, and the affected data items; For each abnormal problem, analyze the source and flow of data, identify the source table, source field and all related traceability tables, and obtain the data traceability flow; Analyze the data change trends of the abnormal problems, identify the patterns and frequencies of data changes, and find out potential data processing bottlenecks and risk points; The data traceability flow is analyzed based on the data processing bottlenecks and risk points to obtain analysis results of abnormal problems, wherein the abnormal analysis results include the cause of the abnormality, the scope of abnormal impact and the recommended repair measures for the abnormality.

7. The method for managing customer file data according to any one of claims 1 to 6, characterized in that: After analyzing the abnormal problem, tracing the data source and flow, and obtaining the data traceability record, the method further includes: The entire life cycle process of data traceability is displayed through a graphical interface, making the data flow path visible, which helps managers directly understand the data change process, analyze data change trends, and identify potential data processing bottlenecks or risk points.

8. A customer file data management device, characterized in that: The device comprises: The file generation module is used to collect information provided by customers through the power grid's collection system, and enter the collected customer information into the power grid's marketing management system to generate initial customer file information; A file verification module is used to automatically verify the initial customer file information through preset data verification rules, and when the information in the initial customer file information meets the preset compliance requirements, obtain compliance file information based on the initial customer file information that has passed the verification; compare the compliance file information with the existing information in the marketing management system for consistency, and when the consistency comparison passes, verify the compliance file information through a preset data verification model definition verification task to generate verification file data; The data tracing module is used to monitor the compliance file information verification process, obtain abnormal problems in the verification process, analyze the abnormal problems, track the source and flow of data, and obtain data tracing records; The data governance module is used to obtain the analysis results of the abnormal problem, and formulate a data governance plan in combination with the data traceability record and the verification archive data, and perform data governance through the data governance plan to obtain data quality analysis results.

9. An electronic device, characterized in that: The electronic device comprises: at least one processor; and, a memory communicatively connected to the at least one processor; wherein, The memory stores a computer program that can be executed by the at least one processor, and the computer program is executed by the at least one processor so that the at least one processor can execute the customer profile data governance method as described in any one of claims 1 to 7.

10. A computer-readable storage medium, comprising a data storage area and a program storage area, wherein the data storage area stores created data and the program storage area stores a computer program; wherein: When the computer program is executed by a processor, it implements the customer profile data management method as described in any one of claims 1 to 7.

Images