A method, apparatus and device for integrating customer portrait metrics
By sorting out the processing path and labeling of customer portrait indicators, and integrating the data view of customer portrait indicators, the problems of waste of processing resources of public customer indicators and unreliable indicators are solved, and data shareability and reusability are improved.
Patent Information
- Application Number
- CN202011472810.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2020-12-15
- Publication Date
- 2025-06-27
- Estimated Expiration
- 2040-12-15
AI Technical Summary
In the prior art, the processing of public customer indicators leads to waste of resources, and data indicators with different meanings and synonyms and names are common, resulting in unreliable indicators and affecting the effectiveness of data analysis.
By obtaining the processing path of customer portrait indicators, the key paths are sorted out based on preset processing rules and source table data, and labeling is performed based on the pre-constructed labeling system. Finally, the key paths and labeling processing results are integrated to obtain a data view of customer portrait indicators.
Reduce resource waste caused by indicator processing, improve data sharing and reusability, and ensure the ability to provide timely and stable data services.
Smart Images

Figure CN112579655B_ABST
Abstract
Description
Technical Field
[0001] This application relates to the technical field of data processing, and particularly to a method, device and equipment for integrating customer portrait indicators. Background Art
[0002] With the continuous development of fintech, big data technology will be more widely and deeply applied in the financial industry. Commercial banks have accumulated a large amount of valuable core data in the long-term business process, especially customer credit and behavior data, which lays a good foundation for the effective utilization of big data in the future.
[0003] In the prior art, for corporate customer indicator processing, mainly data analysts convert business requirements into data requirements according to the requirements specification, and then perform secondary processing by copying data indicators that can meet the business needs in the source system, access area, etc. However, with the continuous increase of business requirements, this method will not only cause the repeated development of basic derivative indicators with the same caliber in different interface tables, wasting computing resources, but also make data indicators with the same name but different meanings and different names but the same meaning widespread, resulting in untrustworthy indicators, thus affecting the application effect of data analysts.
[0004] Therefore, there is an urgent need in the industry for a technical solution that can solve the above problems. Summary of the Invention
[0005] The embodiments of this specification provide a method, device and equipment for integrating customer portrait indicators, which can reduce the resource waste caused by indicator processing and improve the shareability and reusability of data.
[0006] The method, device and equipment for integrating customer portrait indicators provided in this specification are implemented in the following ways.
[0007] A method for integrating customer portrait indicators includes: obtaining the processing path of customer portrait indicators; the processing path includes all data links of customer portrait indicators from the source table system to the completion of processing; sorting out the processing path according to preset processing rules and source table data to obtain the key path of the customer portrait indicators; wherein, the preset processing rules are used to unify the data caliber of customer portrait indicators at each level; the source table data includes the source information of the data required in the processing process of customer portrait indicators; performing tagging processing on the customer portrait indicators based on a pre-constructed tag system; the tag system is used to unify the business identifiers of customer portrait indicators at each level; integrating the key path of the customer portrait indicators and the tagging processing results to obtain a data view of the customer portrait indicators.
[0008] An apparatus for integrating customer portrait metrics, comprising: a processing path acquisition module for acquiring the processing path of customer portrait metrics; the processing path includes all data links of customer portrait metrics from the source table system to the completion of processing; a critical path obtaining module for sorting out the processing path according to preset processing rules and source table data to obtain the critical path of the customer portrait metrics; wherein the preset processing rules are used to unify the data caliber of customer portrait metrics at each level; the source table data includes the source information of the data required in the processing of customer portrait metrics; a tagging processing module for performing tagging processing on the customer portrait metrics based on a pre-constructed tag system; the tag system is used to unify the business identifiers of customer portrait metrics at each level; an integration module for integrating the critical path of the customer portrait metrics and the tagging processing result to obtain a data view of the customer portrait metrics.
[0009] An apparatus for integrating customer portrait metrics, comprising a processor and a memory for storing processor-executable instructions, and when the processor executes the instructions, the steps of any one of the method embodiments in the embodiments of the present specification are implemented.
[0010] A computer-readable storage medium, on which computer instructions are stored, and when the instructions are executed, the steps of any one of the method embodiments in the embodiments of the present specification are implemented.
[0011] A method, apparatus, and device for integrating customer portrait metrics provided in this specification. In some embodiments, by acquiring the processing path of customer portrait metrics, wherein the processing path includes all data links of customer portrait metrics from the source table system to the completion of processing; sorting out the processing path according to preset processing rules and source table data to obtain the critical path of the customer portrait metrics; wherein the preset processing rules are used to unify the data caliber of customer portrait metrics at each level; the source table data includes the source information of the data required in the processing of customer portrait metrics. Further, performing tagging processing on the customer portrait metrics based on a pre-constructed tag system; the tag system is used to unify the business identifiers of customer portrait metrics at each level; integrating the critical path of the customer portrait metrics and the tagging processing result to obtain a data view of the customer portrait metrics. By adopting the implementation scheme provided in this specification, resource waste caused by metric processing can be reduced, the shareability and reusability of data can be improved, and thus the ability to provide timely and stable data services can be guaranteed. Description of the Drawings
[0012] The drawings described herein are used to provide a further understanding of this specification, form a part of this specification, and do not limit this specification. In the drawings:
[0013] Figure 1It is a schematic flowchart of an embodiment of a method for integrating customer portrait metrics provided in this specification;
[0014] Figure 2 It is a schematic module structure diagram of an embodiment of a device for integrating customer portrait metrics provided in this specification;
[0015] Figure 3 It is a schematic hardware structure block diagram of an embodiment of a server for integrating customer portrait metrics provided in this specification. Detailed implementation manners
[0016] To enable those skilled in the art to better understand the technical solutions in this specification, the technical solutions in the embodiments of this specification will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of this specification. Obviously, the described embodiments are only some of the embodiments in this specification, rather than all the embodiments. Based on one or more embodiments in this specification, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the scope protected by the embodiments of this specification.
[0017] The implementation solutions of this specification will be described below by taking a specific application scenario as an example. Specifically, Figure 1 It is a schematic flowchart of an embodiment of a method for integrating customer portrait metrics provided in this specification. Although this specification provides method operation steps or device structures as shown in the following embodiments or drawings, more or fewer operation steps or module units may be included in the method or device based on routine or non-creative labor, or after partial combination.
[0018] An implementation solution provided in this specification can be applied to a client, a server, etc. The client may include terminal devices such as smartphones, tablets, etc. The server may include a single computer device, or a server cluster composed of multiple servers, or a server structure of a distributed system, etc.
[0019] It should be noted that the following description of the embodiments does not limit the technical solutions in other extensible application scenarios based on this specification. Specifically, in one embodiment, Figure 1 As shown, in an embodiment of a method for integrating customer portrait metrics provided in this specification, the method may include the following steps.
[0020] S0: Obtain the processing path of customer portrait metrics; the processing path includes all data links of customer portrait metrics from the source table system to the completion of processing.
[0021] Among them, customers can include corporate customers, individual customers, etc. Preferably, the customers refer to corporate customers. An indicator can be understood as a field in a data table or a data item. Customer portrait indicators can be used to describe a customer portrait. For example, the basic account flag, etc. Customer portrait indicators in the financial industry can cover multiple fields such as management accounting, corporate credit, asset-liability, and risk management. The processing path can include all data links of customer portrait indicators from the source table system to the completion of processing. The source table system is the system or component to which the source table required for processing the indicators describing the customer portrait belongs. It is the system where the data source first appears and can also be understood as the system that generates data. Usually, according to the requirements of the business scenario, after the customer portrait indicators are generated, many business parties, data users, and intermediate layers will use these indicators. Among them, when different systems or intermediate layers use these indicators, they usually habitually retrieve data from the access area or even from the interface tables of other projects, thus generating one or more processing paths of customer portrait indicators.
[0022] In some embodiments, the processing path may include the processing levels of the detail layer and the summary layer in the data link for processing customer portrait indicators.
[0023] In some embodiments, after obtaining the processing path of the customer portrait indicators, it can be stored in the database. In this way, when subsequent analysis of the indicator data is required, it can be directly obtained from the database, thereby improving the data processing efficiency. Of course, the above is only an exemplary illustration. The storage method of the processing path of the customer portrait indicators is not limited to the above examples. Those skilled in the art may make other changes under the inspiration of the technical essence of this application, but as long as the functions and effects achieved are the same or similar to those of this application, they should all be covered within the protection scope of this application.
[0024] S2: According to the preset processing rules and the source table data, sort out the processing path to obtain the key path of the customer portrait indicators; wherein, the preset processing rules are used to unify the data caliber of the customer portrait indicators at each level; the source table data includes the source information of the data required during the processing of the customer portrait indicators.
[0025] In the embodiments of this specification, after obtaining the processing path of the customer portrait indicators, the obtained processing path can be optimized according to the preset processing rules and the source table data, so as to obtain the key path of the customer portrait indicators.
[0026] In some embodiments, the preset processing rules can be used to unify the data caliber of customer portrait metrics at each level. The data caliber can be understood as a data extraction rule. In some implementation scenarios, the preset processing rules can include screening and filtering conditions for data tables at each level, aggregation rules, etc. In some implementation scenarios, each level can include an access layer and a calculation layer, and the calculation layer can include a detail layer and a summary layer. In some embodiments, the source table data can include the source information of the data required in the process of processing customer portrait metrics. In some embodiments, the source table data can be pre-stored in the source table system. The source table system can be understood as a system that summarizes the most original data sources and field descriptions required for metric processing by sorting out the data path.
[0027] It should be noted that the processing rules of metrics and the source table data can represent a certain business area and business meaning, and are the accumulation of data wealth in the long-term digital operation of the financial industry. In some implementation scenarios, to ensure the stable operation of financial services and the implementation effect of marketing activities, the metric attributes can be identified to unify the metric processing rules and source table data so that they conform to business logic, common industry experience, and data specifications. For example, for the metric of "basic account flag" of corporate customers' current deposit accounts, there are different business definitions and data extraction rules in different business departments and business requirements, and the screening rules and filtering conditions for the source table data are also inconsistent. Therefore, the business rules can be deeply understood to unify the processing rules of the "basic account flag" metric of corporate customers' current deposit accounts and the source table data, so as to ensure the key path for obtaining customer portrait metrics. Among them, the unified metric processing rules can be understood as the preset processing rules.
[0028] In some embodiments, after unifying the metric processing rules and the source table data, the processing path can be sorted out according to the unified metric processing rules and the source table data to obtain the key path of the customer portrait metrics.
[0029] In some embodiments, sorting out the processing path according to the preset processing rules and the source table data to obtain the key path of the customer portrait metrics can include: based on the source table data, filtering out the processing paths that do not meet the preset processing rules from the processing path to obtain the processing paths that meet the preset processing rules; screening out the shortest processing path from the processing paths that meet the preset processing rules as the key path of the customer portrait metrics. The key path can be understood as the optimal processing path among all data links from the source table system to the completion of processing for customer portrait metrics.
[0030] In some embodiments, the processing paths that do not meet the preset processing rules may at least include one of the following: the screening of the source table data by the customer portrait indicators during the processing does not conform to the business logic. For example, during the indicator processing, unreasonable screening is performed on the source table data; the aggregation rules for the customer portrait indicators do not conform to the business logic. For example, incorrect aggregation is performed on the data items during the indicator processing; there are multi-layer dependencies or repeated dependencies on the source table data. For example, meaningless multi-layer dependencies or repeated dependencies on the source table data; the customer portrait indicators are repeatedly processed in multiple target tables and multiple levels. For example, the indicators with inconsistent calibers are processed at multiple points. Of course, the above is only an illustrative description. The processing paths that do not meet the preset processing rules are not limited to the above examples. Those skilled in the art may make other changes under the inspiration of the technical essence of this application. However, as long as the functions and effects achieved are the same as or similar to those of this application, they should all be covered by the protection scope of this application.
[0031] In some embodiments, according to the preset processing rules and the source table data, the processing path can be shortened. For example, in some implementation scenarios, for a complex and unreasonable data link, the source table data can be traced back, the core processing path can be refined, the meaningless multi-layer dependencies and repeated dependencies between tables can be simplified, and the chaotic and directionless data flow can be changed, thereby improving the data application effect. For example, the data items required for the public indicators in the processing access layer should come from the detail layer or the summary layer in the calculation layer. However, as the demand increases, the processing path becomes chaotic, and the access models will fetch data from each other, resulting in the elongation of the data path and the reduction of data timeliness. At this time, the source table data can be traced back, the core processing path can be refined, and the meaningless multi-layer dependencies and repeated dependencies between tables can be simplified, thereby shortening the processing path.
[0032] In some embodiments, according to the preset processing rules and the source table data, single-point processing of indicators can be achieved. For example, in some implementation scenarios, the preset processing rules can follow the principle of global optimization, build a data model according to the data granularity, and achieve single-point processing of indicators by means of "combining like terms". The core of single-point processing of indicators lies in unifying the data caliber of the same indicator at each level and shortening the data path, identifying the data items with the same processing rules in the public customer indicators and the label domain but repeatedly processed in multiple data tables. For example, the same indicator may be repeatedly processed in multiple data tables in the calculation layer. By merging and removing duplicates of these repeatedly processed indicators, single-point processing of indicators can be ensured, avoiding business rule ambiguities in data caliber and wasteful consumption of resources, thereby improving data reusability and ensuring that data analysts have a clear and reliable data fetching source.
[0033] S4: Perform tagging processing on the customer portrait indicators based on the pre-constructed tag system; the tag system is used to unify the business identifiers of the customer portrait indicators at each level.
[0034] In the embodiments of this specification, after obtaining the critical path of the customer portrait metrics, the customer portrait metrics can be tagged based on a pre-constructed tag system.
[0035] In some embodiments, the tag system can be used to unify the business identifiers of customer portrait metrics at each level, and can also be used to unify the data types and naming methods of customer portrait metrics at each level.
[0036] In some embodiments, data standard specifications can be formed based on single-point processing of metrics and unified data caliber, that is, the constructed tag system. The tag system can include data types, naming methods, data extraction rules, etc., and assign unique and interpretable business meanings to the metrics.
[0037] In the embodiments of this specification, tagging the customer portrait metrics can mean that each metric represents its unique and distinguishable statistical caliber, data extraction source, business domain, and business meaning, so as to support the refined management of corporate customers and enhance the data value. For example, for the tag of "the flag of the corporate customer opening a basic account in our bank" for corporate customers, since an enterprise can only open a basic deposit account in one bank, then the corporate customer with the "flag of the corporate customer opening a basic account in our bank" is an enterprise user that has an account with the nature of "basic account" for corporate deposits in our bank and has no basic account in other banks.
[0038] S6: Integrate the critical path of the customer portrait metrics and the tagging result to obtain a data view of the customer portrait metrics.
[0039] In the embodiments of this specification, after tagging the customer portrait metrics, the critical path of the customer portrait metrics and the tagging result can be integrated to obtain a data view of the customer portrait metrics. Among them, the data view can be understood as a data table including customer portrait metric information.
[0040] In some embodiments, integrating the critical path of the customer portrait metrics and the tagging result can include correlating the critical path of the customer portrait metrics and the tagging result with each other. Since the tagging of the customer portrait metrics can uniquely identify the customer portrait metrics, in this way, when the customer portrait metrics are needed, the customer portrait metrics can be directly obtained through this critical path, thus avoiding duplicate development of the same metrics in different interface tables and wasting computing resources. Of course, the above is only an exemplary description, and the method of integrating the critical path of the customer portrait metrics and the tagging result is not limited to the above example. Those skilled in the art may make other changes under the inspiration of the technical essence of this application, but as long as the functions and effects achieved are the same or similar to those of this application, they should be covered within the protection scope of this application.
[0041] In some embodiments, after obtaining the data view of the customer portrait metrics, it may include: presenting the data view of the customer portrait metrics. For example, in some implementation scenarios, for the corporate customer portrait metrics within the data domain, after defining a unified data caliber and business rules, the data of each dimension can be abstracted to form a data view, and then presented to the user from a business perspective.
[0042] In some embodiments, the information of corporate customer portrait metrics can be integrated by concatenating the key information in each field according to specific business objectives and requirements, and customizing the customer portrait scenario, so as to realize the transformation of data into business and the tagging of scenarios, comprehensively perspective the whole picture of corporate customers of the whole bank, and enrich the data view centered on customers.
[0043] In some embodiments, after obtaining the data view of the customer portrait metrics, it may include: obtaining the data view of the whole-domain customer portrait metrics; based on the data view of the whole-domain customer portrait metrics, constructing the data view of the whole-domain customer portrait metrics. Among them, the data view of the whole-domain customer portrait metrics can also be called the whole-domain integration model, and can also be called the wide table of tags.
[0044] In some implementation scenarios, a set of enterprise data systems covering the whole domain and the whole history can be built based on the data view of the whole-domain customer portrait metrics. According to the needs of business fields and application scenarios, the data integration of corporate customers in the whole domain can be gradually realized, so as to improve data sharing. Among them, constructing a corporate customer financial ecosystem at the whole-bank level can support all-round multi-dimensional data analysis and efficient query of customers from different scenarios and business purposes.
[0045] In some implementation scenarios, the wide table of tags can be organized according to business objects based on the data view of the whole-domain customer portrait metrics to provide the overall picture of the data, so as to facilitate users to use the data intuitively and conveniently.
[0046] The embodiments of this specification can effectively integrate the platform, data and management together, gradually realize the integration of the whole-domain data, provide users with efficient data services and a comprehensive view of data assets, so as to meet the needs of different business scenarios, business innovation, data insight and precise decision-making.
[0047] The embodiments of this specification can not only identify unreasonable data processing links, reduce meaningless multi-layer dependencies and repeated dependencies between tables, so as to plan reasonable processing paths, but also standardize the data types, naming methods and data extraction rules of metrics, define the unique business fields and business meanings of tags, and can also construct a unified data view centered on customers and supporting multiple scenarios and dimensions.
[0048] Of course, the above is only an illustrative description. The embodiments of this specification are not limited to the above examples. Those skilled in the art may make other changes under the inspiration of the technical essence of this application. However, as long as the functions and effects achieved are the same as or similar to those of this application, they should all be covered within the protection scope of this application.
[0049] From the above description, it can be seen that the embodiments of this application can obtain the processing path of customer portrait indicators. Among them, the processing path includes all data links from the source table system to the completion of processing for customer portrait indicators; according to the preset processing rules and source table data, the processing path is sorted out to obtain the critical path of customer portrait indicators; among them, the preset processing rules are used to unify the data caliber of customer portrait indicators at each level; the source table data includes the source information of the data required during the processing of customer portrait indicators. Further, based on the pre-constructed label system, the customer portrait indicators are processed with labels; the label system is used to unify the business identifiers of customer portrait indicators at each level; the critical path of customer portrait indicators and the results of the labeling process are integrated to obtain the data view of customer portrait indicators. Since sorting out the processing path according to the preset processing rules and source table data can not only avoid duplicate development of indicators in different interface tables and waste computing resources, but also shorten the processing path, realize single-point processing of indicators, improve the timeliness of indicator delivery, and provide timely data response for establishing an all-round data product service system. Since the customer portrait indicators are processed with labels based on the pre-constructed label system, each indicator can represent its unique, distinguishable statistical caliber, data acquisition source, business field, and business meaning, thereby supporting the refined management of corporate customers and enhancing the data value.
[0050] Based on the above method for integrating customer portrait indicators, one or more embodiments of this specification also provide a device for integrating customer portrait indicators. The device may include a system (including a distributed system), software (application), module, component, server, client, etc. that uses the method described in the embodiments of this specification and combines the necessary implementation hardware. Based on the same innovative concept, the devices in one or more embodiments provided by the embodiments of this specification are as described in the following embodiments. Since the implementation solutions for the device to solve problems are similar to those of the method, the implementation of the specific device in the embodiments of this specification can refer to the implementation of the foregoing method, and the repeated parts will not be elaborated. As used hereinafter, the term "unit" or "module" may be a combination of software and / or hardware that can achieve a predetermined function. Although the devices described in the following embodiments are preferably implemented in software, implementation in hardware, or a combination of software and hardware is also possible and contemplated.
[0051] Specifically, Figure 2 is a schematic diagram of the module structure of an embodiment of a device for integrating customer portrait indicators provided by this specification, asFigure 2 As shown in Figure 2 , an apparatus for integrating customer portrait metrics provided in this specification may include: a processing path acquisition module 120, a critical path acquisition module 122, a tagging processing module 124, and an integration module 126.
[0052] The processing path acquisition module 120 may be used to acquire the processing path of customer portrait metrics; the processing path includes all data links of customer portrait metrics from the source table system to the completion of processing.
[0053] The critical path acquisition module 122 may be used to sort out the processing path according to preset processing rules and source table data to obtain the critical path of the customer portrait metrics; wherein, the preset processing rules are used to unify the data caliber of customer portrait metrics at each level; the source table data includes the source information of the data required during the processing of customer portrait metrics.
[0054] The tagging processing module 124 may be used to perform tagging processing on the customer portrait metrics based on a pre-constructed tagging system; the tagging system is used to unify the business identifiers of customer portrait metrics at each level.
[0055] The integration module 126 may be used to integrate the critical path and the tagging processing result of the customer portrait metrics to obtain a data view of the customer portrait metrics.
[0056] It should be noted that the above-described apparatus may also include other implementation manners according to the description of the method embodiments. The specific implementation manners may refer to the description of the relevant method embodiments and will not be elaborated here one by one.
[0057] This specification also provides an embodiment of a device for integrating customer portrait metrics, including a processor and a memory for storing processor-executable instructions. When the processor executes the instructions, it may implement any of the above method embodiments. For example, when the instructions are executed by the processor, the following steps are implemented: acquiring the processing path of customer portrait metrics; the processing path includes all data links of customer portrait metrics from the source table system to the completion of processing; sorting out the processing path according to preset processing rules and source table data to obtain the critical path of the customer portrait metrics; wherein, the preset processing rules are used to unify the data caliber of customer portrait metrics at each level; the source table data includes the source information of the data required during the processing of customer portrait metrics; performing tagging processing on the customer portrait metrics based on a pre-constructed tagging system; the tagging system is used to unify the business identifiers of customer portrait metrics at each level; integrating the critical path and the tagging processing result of the customer portrait metrics to obtain a data view of the customer portrait metrics.
[0058] It should be noted that the above-mentioned device may also include other implementation manners according to the description of the method or device embodiments. The specific implementation manners may refer to the description of the relevant method embodiments and will not be elaborated here one by one.
[0059] The method embodiments provided in this specification may be executed on a mobile terminal, a computer terminal, a server, or a similar computing device. Taking running on a server as an example, Figure 3 is a hardware structure block diagram of an embodiment of a server for integrating customer portrait metrics provided in this specification. The server may be the device or equipment for integrating customer portrait metrics in the above embodiments. As Figure 3 shown, the server 10 may include one or more (only one is shown in the figure) processors 100 (the processor 100 may include, but is not limited to, a processing device such as a microprocessor MCU or a programmable logic device FPGA), a memory 200 for storing data, and a transmission module 300 for communication functions. Those of ordinary skill in the art can understand that Figure 3 the structure shown is only schematic and does not limit the structure of the above electronic device. For example, the server 10 may further include more or fewer components than those Figure 3 shown, such as other processing hardware, such as a database or a multi-level cache, a GPU, or have a different configuration from that Figure 3 shown.
[0060] The memory 200 can be used to store software programs and modules of application software, such as the program instructions / modules corresponding to the method for integrating customer portrait metrics in the embodiments of this specification. The processor 100 executes various functional applications and data processing by running the software programs and modules stored in the memory 200. The memory 200 may include a high-speed random access memory and may also include a non-volatile memory, such as one or more magnetic storage devices, flash memories, or other non-volatile solid-state memories. In some instances, the memory 200 may further include a memory remotely disposed relative to the processor 100, and these remote memories may be connected to the computer terminal through a network. Examples of the above networks include, but are not limited to, the Internet, an enterprise intranet, a local area network, a mobile communication network, and combinations thereof.
[0061] The transmission module 300 is used to receive or send data via a network. Specific examples of the above-mentioned network may include a wireless network provided by a communication provider of a computer terminal. In one example, the transmission module 300 includes a network adapter (Network Interface Controller, NIC), which can be connected to other network devices through a base station and thus communicate with the Internet. In one example, the transmission module 300 can be a Radio Frequency (RF) module, which is used to communicate with the Internet wirelessly.
[0062] The above describes specific embodiments of this specification. Other embodiments are within the scope of the appended claims. In some cases, the actions or steps recited in the claims can be performed in a different order than in the embodiments and still achieve the desired result. Additionally, the processes depicted in the drawings do not necessarily require the specific order or sequential order shown to achieve the desired result. In certain embodiments, multitasking and parallel processing are also possible or may be advantageous.
[0063] The method or device described in the above embodiments provided in this specification can implement the business logic through a computer program and record it on a storage medium. The storage medium can be read and executed by a computer to achieve the effects of the solutions described in the embodiments of this specification. The storage medium can include physical devices for storing information, usually by digitizing the information and then storing it using media such as electricity, magnetism, or optics. The storage medium can include: devices that store information using electrical energy, such as various memories, such as RAM, ROM, etc.; devices that store information using magnetic energy, such as hard disks, floppy disks, magnetic tapes, magnetic core memories, bubble memories, USB flash drives; devices that store information using optical methods, such as CDs or DVDs. Of course, there are also other ways of readable storage media, such as quantum memories, graphene memories, and so on.
[0064] The method or device embodiments for integrating customer portrait metrics provided in this specification can be implemented by a processor executing corresponding program instructions in a computer, such as being implemented in a PC using the C++ language with the Windows operating system, being implemented in a Linux system, or being implemented in a smart terminal using programming languages such as Android or iOS, as well as being implemented based on the processing logic of a quantum computer, and so on.
[0065] It should be noted that the devices and equipment described above in the specification may also include other implementation manners according to the descriptions of the relevant method embodiments. The specific implementation manners can refer to the descriptions of the corresponding method embodiments and will not be elaborated here one by one.
[0066] The various embodiments in this application are all described in a progressive manner. For the same or similar parts among the various embodiments, reference can be made to each other. Each embodiment focuses on the differences from other embodiments. In particular, for the embodiments of hardware + program, since they are basically similar to the method embodiments, the description is relatively simple, and reference can be made to the corresponding parts of the method embodiments for the relevant content.
[0067] For the convenience of description, when describing the above device, it is divided into various modules according to functions for separate description. Of course, when implementing one or more of this specification, the functions of some modules can be implemented in the same or multiple software and / or hardware, or the modules implementing the same function can be realized by a combination of multiple sub-modules or sub-units, etc.
[0068] The present invention is described with reference to the flowcharts and / or block diagrams of methods, devices, and equipment according to the embodiments of the present invention. It should be understood that it can be implemented by computer program instructions. These computer program instructions can be provided to the processors of general-purpose computers, special-purpose computers, embedded processors, or other programmable data processing devices to generate a machine, so that the instructions executed by the processors of the computer or other programmable data processing devices generate a device for realizing the specified functions. These computer program instructions can also be stored in a computer-readable memory that can direct the computer or other programmable data processing devices to work in a specific manner, so that the instructions stored in the computer-readable memory generate a manufactured article including an instruction device, and the instruction device realizes the functions specified in one process Figure 1 one process or multiple processes and / or block Figure 1 specified in one block or multiple blocks.
[0069] Those skilled in the art should understand that one or more embodiments of this specification can be provided as a method, a system, or a computer program product. Therefore, one or more embodiments of this specification can take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware aspects.
[0070] The above description is only for the embodiments of one or more embodiments of this specification and is not intended to limit one or more embodiments of this specification. For those skilled in the art, one or more embodiments of this specification can have various changes and modifications. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of this application shall be included within the scope of the claims.
Claims
1. A method for integrating customer profile metrics, characterized in that, The method includes: Obtaining the processing path of customer portrait metrics; the customer portrait metrics and their processing paths already exist; the processing path includes all data links of the customer portrait metrics from the source table system to the completion of processing; the processing path corresponds to the inter-table dependency relationship, and different processing paths correspond to different inter-table dependency relationships; the processing path is formed by one or more customer portrait metrics and data links when multiple business parties, data users, or intermediate layers retrieve data from the access area or from the interface tables of other projects when they need to use the customer portrait metrics after a customer portrait metric is generated. According to the preset processing rules and source table data, sort out the processing path, shorten the processing path, and obtain the critical path of the customer portrait metrics; wherein, the preset processing rules are used to unify the data caliber of customer portrait metrics at each level; the source table data includes the source information of the data required in the processing process of customer portrait metrics; sorting out the processing path includes: simplifying multi-layer dependencies and repeated dependencies; changing the chaotic and directionless data flow; constructing a data model according to the data granularity, and by unifying the data caliber of the metrics at each level and shortening the data path, identifying the data items with the same processing rules in the corporate customer metrics and label domain but repeatedly processed in multiple data tables, and merging and de-duplicating the repeatedly processed metrics. Based on the pre-constructed label system, perform label processing on the customer portrait metrics; the label system is used to unify the business identifiers of customer portrait metrics at each level. Integrate the critical path of the customer portrait metrics and the result of label processing to obtain the data view of the customer portrait metrics.
2. The method according to claim 1, characterized in that The processing path includes the processing levels of the detail layer and the summary layer in the data link for processing customer portrait metrics.
3. The method according to claim 1, characterized in that The preset processing rules include the screening and filtering conditions and aggregation rules for data tables at each level.
4. The method according to claim 3, wherein The obtaining of the critical path of the customer portrait metrics by sorting out the processing path according to the preset processing rules and source table data includes: Based on the source table data, filter out the processing paths that do not meet the preset processing rules from the processing path to obtain the processing paths that meet the preset processing rules. Select the shortest processing path from the processing paths that meet the preset processing rules as the critical path of the customer portrait metrics.
5. The method according to claim 4, wherein The processing paths that do not meet the preset processing rules at least include one of the following: the screening of the source table data by the customer portrait metrics during the processing does not conform to the business logic; the aggregation rules for the customer portrait metrics do not conform to the business logic; the multi-layer dependencies or repeated dependencies on the source table data; the customer portrait metrics are repeatedly processed in multiple target tables and multiple levels.
6. The method according to claim 1, characterized in that, The pre-constructed label system is also used to unify the data types and naming methods of customer portrait metrics at each level.
7. The method according to claim 1, characterized in that After obtaining the data view of the customer portrait metrics, it includes: Displaying the data view of the customer portrait metrics.
8. The method according to claim 1, characterized in that After obtaining the data view of the customer portrait metrics, it includes: Obtaining the data view of the global customer portrait metrics. Based on the data view of the global customer portrait metrics, construct the data view of the global customer portrait metrics.
9. The method according to claim 1, wherein Each of the above levels includes an access layer and a computing layer.
10. An apparatus for integrating customer portrait metrics, characterized in that, It includes: A processing path acquisition module for acquiring the processing path of customer portrait metrics; the customer portrait metrics and their processing paths already exist; the processing path includes all data links of the customer portrait metrics from the source table system to the completion of processing; the processing path is used to form an inter-table dependency relationship, and different processing paths correspond to different inter-table dependency relationships; the processing path is a kind of one or more customer portrait metrics and data links formed when multiple business parties, data users or intermediate layers retrieve data from the access area or from the interface tables of other projects when they need to use the customer portrait metrics after a customer portrait metric is generated. A critical path obtaining module for sorting out the processing path according to preset processing rules and source table data, shortening the processing path, and obtaining the critical path of the customer portrait metrics; wherein, the preset processing rules are used to unify the data caliber of the customer portrait metrics at each level; the source table data includes the source information of the data required during the processing of the customer portrait metrics; the sorting out of the processing path includes: simplifying multi-layer dependencies and duplicate dependencies; changing the chaotic and directionless data flow; constructing a data model according to the data granularity, and by unifying the data caliber of the metrics at each level and shortening the data path, identifying the data items with the same processing rules in the corporate customer metrics and the label domain but repeatedly processed in multiple data tables, and merging and removing duplicates for the repeatedly processed metrics. A tagging processing module for performing tagging processing on the customer portrait metrics based on a pre-constructed tag system; the tag system is used to unify the business identifiers of the customer portrait metrics at each level. An integration module for integrating the critical path of the customer portrait metrics and the tagging processing result to obtain a data view of the customer portrait metrics.
11. An apparatus for integrating customer profile metrics, characterized in that, It includes a processor and a memory for storing processor-executable instructions, and when the processor executes the instructions, it implements the steps of the method according to any one of claims 1-9.
12. A computer-readable storage medium, characterized in that, Computer instructions are stored thereon, and when the instructions are executed, they implement the steps of the method according to any one of claims 1 to 9.
Citation Information
Patent Citations
Big data real-time computing platform and method based on sql
CN110333941A
Intelligent panoramic customer portrait linkage method and system based on stream platform
CN110766462A