CN113344597A - Method, device, equipment and storage medium for managing client rights and interests - Google Patents
Method, device, equipment and storage medium for managing client rights and interests Download PDFInfo
- Publication number
- CN113344597A CN113344597A CN202110726592.5A CN202110726592A CN113344597A CN 113344597 A CN113344597 A CN 113344597A CN 202110726592 A CN202110726592 A CN 202110726592A CN 113344597 A CN113344597 A CN 113344597A
- Authority
- CN
- China
- Prior art keywords
- client
- interests
- rights
- data
- interest
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/01—Customer relationship services
- G06Q30/012—Providing warranty services
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- General Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Finance (AREA)
- Software Systems (AREA)
- Economics (AREA)
- Development Economics (AREA)
- Accounting & Taxation (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Storage Device Security (AREA)
Abstract
The application relates to the technical field of data processing, and discloses a method, a device, equipment and a storage medium for managing client rights and interests, wherein the method comprises the following steps: responding to a client right updating request, and acquiring client right initial data from a temporary storage table to obtain client right initial data to be processed, wherein the client right initial data in the temporary storage table is client rights obtained by settlement in a client right basic data table of a Hive library, and the client right basic data in the client right basic data table is data sent by each client service application system; carrying out data processing on the initial data of the client rights and interests to be processed to obtain a client rights and interests result to be stored; and storing the client interest result to be stored in a client interest result table of the HBase. Therefore, the calculation, storage, viewing and use of the client rights and interests are decoupled from the client service application system, and the client rights and interests are managed in real time and efficiently by adopting HBase.
Description
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a method, an apparatus, a device, and a storage medium for managing client rights and interests.
Background
The variety of customer services is diverse, such that there are multiple customer service applications per organization. The client rights and interests are related to the client services provided by the client service application system, so that the client rights and interests are seriously coupled with the client service application system, the client rights and interests are dispersed in each client service application system, and business personnel or clients need to log in each client service application system when needing to check and use the client rights and interests, so that the checking and the use of the client rights and interests are not facilitated.
Disclosure of Invention
The present application mainly aims to provide a method, an apparatus, a device and a storage medium for managing client rights and interests, and aims to solve the technical problem that in the prior art, the client rights and interests are seriously coupled with client service application systems, so that the client rights and interests are dispersed in each client service application system and are not favorable for viewing and using the client rights and interests.
In order to achieve the above object, the present application provides a method for managing customer rights, the method comprising:
acquiring a client rights and interests updating request;
responding to the client rights and interests updating request, acquiring client rights and interests initial data from a temporary storage table to obtain client rights and interests initial data to be processed, wherein the client rights and interests initial data in the temporary storage table are client rights and interests obtained by settlement in a client rights and interests basic data table of a Hive library, and the client rights and interests basic data in the client rights and interests basic data table are data sent by each client service application system;
performing data processing on the initial data of the client rights and interests to be processed to obtain a client rights and interests result to be stored;
and storing the client interest result to be stored in a client interest result table of the HBase.
Further, before the step of obtaining the initial data of the customer interest from the temporary storage table in response to the customer interest update request and obtaining the initial data of the customer interest to be processed, the method further includes:
sending the client rights and interests basic data of each client service application system to the client rights and interests basic data table of the Hive base through a first data transmission task to generate a data storage signal;
acquiring each client rights and interests calculation script according to the data warehousing signal;
acquiring one client interest computing script from each client interest computing script as a target client interest computing script;
acquiring a target client interest calculation rule by executing the target client interest calculation script, and acquiring the client interest basic data from the client interest basic data table of the Hive library according to the target client interest calculation rule to obtain a client interest basic data set to be calculated;
respectively carrying out the client rights and interests initial data calculation on the client rights and interests basic data set to be calculated according to the target client rights and interests calculation rule by executing the target client rights and interests calculation script to obtain a client rights and interests initial data set to be stored;
storing the customer interest initial data set to be stored into the temporary storage table through a second data transmission task;
and repeatedly executing the step of obtaining one client interest calculation script from each client interest calculation script as a target client interest calculation script until the obtaining of the client interest calculation script in each client interest calculation script is completed.
Further, the step of performing data processing on the to-be-processed customer interest initial data to obtain to-be-stored customer interest results includes:
performing default parameter supplement processing on the client rights and interests initial data to be processed by adopting a task of a distributed remote scheduling engine to obtain client rights and interests initial data after parameter supplement;
performing illegal data verification and correction processing on the client rights and interests initial data after the parameter supplement by adopting the task of the distributed remote scheduling engine to obtain client rights and interests initial data after the illegal data verification;
and performing repeated data combination on the client rights and interests initial data subjected to the illegal data verification by adopting the task of the distributed remote scheduling engine to obtain the client rights and interests result to be stored.
Further, after storing the client equity result to be stored in the client equity result table of the HBase, the method further includes:
acquiring a client rights and interests display request, wherein the client rights and interests display request carries a client identifier set to be displayed;
respectively acquiring a client interest result from the client interest result table according to each client identifier in the client identifier set to be displayed to obtain a client interest result set to be displayed;
and displaying a page according to the client rights and interests result set to be displayed to obtain a target client rights and interests display page.
Further, after the step of performing page display according to the set of client rights and interests result to be displayed to obtain a target client rights and interests display page, the method further comprises:
acquiring a sharing request according to the target client rights display page, wherein the sharing request carries a client rights identifier to be analyzed, a target sharing mode and a target sharing object identifier;
responding to the sharing request, and generating information to be shared according to the target sharing mode and the client rights and interests identifier to be analyzed;
and sending the information to be shared to a client corresponding to the target sharing object identifier according to the target sharing mode.
Further, after storing the client equity result to be stored in the client equity result table of the HBase, the method further includes:
the method comprises the steps of obtaining a client rights and interests application request sent by a target client, wherein the client rights and interests application request carries a client rights and interests identifier to be processed and client rights and interests application data to be updated;
checking the client rights and interests application data to be updated to obtain checked client rights and interests application data;
and updating the client rights and interests result table according to the client rights and interests identifier to be processed and the client rights and interests application data after the verification processing.
Further, the step of performing verification processing on the to-be-updated client rights and interests application data to obtain verified client rights and interests application data includes:
performing non-null value verification on the client rights and interests application data to be updated to obtain a non-null value verification result;
when the non-null value verification result is a non-null value, performing parameter validity verification on the client rights and interests application data to be updated to obtain a parameter validity verification result;
and when the parameter validity check result is in line, taking the client rights and interests application data to be updated as the client rights and interests application data after the check processing.
The present application also proposes a management apparatus of customer rights and interests, the apparatus comprising:
the request acquisition module is used for acquiring a client rights and interests updating request;
a to-be-processed client right initial data determining module, configured to respond to the client right update request, obtain client right initial data from a temporary storage table, and obtain the to-be-processed client right initial data, where the client right initial data in the temporary storage table is a client right obtained by settlement in a client right basic data table of a Hive library, and the client right basic data in the client right basic data table is data sent by each client service application system;
the client rights and interests result determining module is used for carrying out data processing on the client rights and interests initial data to be processed to obtain a client rights and interests result to be stored;
and the client interest result table updating module is used for storing the client interest result to be stored in the client interest result table of the HBase.
The present application further proposes a computer device comprising a memory and a processor, the memory storing a computer program, the processor implementing the steps of any of the above methods when executing the computer program.
The present application also proposes a computer-readable storage medium having stored thereon a computer program which, when being executed by a processor, carries out the steps of the method of any of the above.
The method comprises the steps of firstly obtaining initial data of client rights and interests from a temporary storage table to obtain initial data of the client rights and interests to be processed, wherein the initial data of the client rights and interests in the temporary storage table is obtained by settlement according to a basic data table of the client rights and interests of a Hive library, the basic data of the client rights and interests in the basic data table of the client rights and interests are data sent by each client service application system, then carrying out data processing on the initial data of the client rights and interests to be processed to obtain results of the client rights and interests to be stored, and finally storing the results of the client rights and interests to be stored in a result table of the client rights and interests of an HBase, thereby realizing the centralized management of the client rights and interests and decoupling the calculation, storage, viewing and use of the client rights and interests from the client service application systems, the HBase is adopted, so that the client rights and interests can be managed in real time and efficiently.
Drawings
FIG. 1 is a flow chart illustrating a method for managing customer rights according to an embodiment of the present application;
FIG. 2 is a block diagram illustrating a structure of a customer rights management device according to an embodiment of the present application;
fig. 3 is a block diagram illustrating a structure of a computer device according to an embodiment of the present application.
The implementation, functional features and advantages of the objectives of the present application will be further explained with reference to the accompanying drawings.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
Referring to fig. 1, in an embodiment of the present application, a method for managing customer rights is provided, where the method includes:
s1: acquiring a client rights and interests updating request;
s2: responding to the client rights and interests updating request, acquiring client rights and interests initial data from a temporary storage table to obtain client rights and interests initial data to be processed, wherein the client rights and interests initial data in the temporary storage table are client rights and interests obtained by settlement in a client rights and interests basic data table of a Hive library, and the client rights and interests basic data in the client rights and interests basic data table are data sent by each client service application system;
s3: performing data processing on the initial data of the client rights and interests to be processed to obtain a client rights and interests result to be stored;
s4: and storing the client interest result to be stored in a client interest result table of the HBase.
In this embodiment, initial client right and interest data is obtained from a temporary storage table, wherein the initial client right and interest data in the temporary storage table is client right and interest obtained by settlement according to a basic client right and interest data table in a Hive library, the basic client right and interest data in the basic client right and interest data table is data sent by each client service application system, then the initial client right and interest data to be processed is processed to obtain a result of the client right and interest to be stored, and finally the result of the client right and interest to be stored is stored in a result table of the client right and interest of an HBase, so that the client right and interest is centrally managed, the calculation, storage, viewing and use of the client right and interest are decoupled from the client service application system, and the HBase is adopted to facilitate the real-time implementation of the client right and interest, And (4) high-efficiency management.
For S1, the client right update request input by the user may be obtained, the client right update request sent by the third-party application system may also be obtained, or the client right update request generated by the program implementing the present application according to the preset condition may also be obtained. The preset conditions include, but are not limited to: and performing client rights and interests updating calculation according to preset time.
The client right update request is a request for updating the client right.
The client rights and interests are the rights and interests of the client. For example, in the insurance industry, customer benefits include, but are not limited to: the examples include, but are not limited to, expert registration, hospitalization, green admission, online inquiry, traditional Chinese medicine inquiry cards, traditional Chinese medicine coupons, VIP health examination cards, VIP accompanying and car washing coupons.
It will be appreciated that the underlying data used to calculate customer benefits is distributed among one or more customer service application systems.
The client service application system is an application system for providing services for clients.
For S2, in response to the client right update request, client right initial data is obtained from the temporary storage table, and each piece of the obtained client right initial data is used as one piece of client right initial data to be processed.
And a temporary storage table, namely adopting a PgSQL temporary table. PgSQL is an object relational database management system based on POSTGRES version 4.2.
The Hive library is a Hadoop big data Hive library.
The client interest initial data in the temporary storage table is client interest obtained by settlement in a client interest basic data table of the Hive library, and the client interest basic data in the client interest basic data table is data sent by each client service application system, that is, each client service application system sends client interest basic data used for client interest calculation to the client interest basic data table of the Hive library, then acquires data from the client interest basic data of the Hive library by adopting an execution script to perform client interest calculation, uses the calculated client interest as the client interest initial data, and finally stores the client interest initial data into the temporary storage table.
It is to be understood that each of said customer interest initial data corresponds to a customer interest of a customer.
And S3, performing data processing on the initial data of the client rights and interests to be processed by adopting the task of the distributed remote scheduling engine, and taking the initial data of the client rights and interests to be processed after the data processing as the result of the client rights and interests to be stored.
A Distributed remote Scheduling Engine, namely a Distributed Scheduling Engine.
The customer equity results to be stored, i.e., the customer equity results that need to be stored in the customer equity result table.
Customer equity results include, but are not limited to: the system comprises a client identification, a client mobile phone number, a client interest identification, a client interest name, a client interest type, a client interest effective starting time, a client interest effective ending time and a client interest creating time.
It will be appreciated that each customer entitlement result corresponds to a customer entitlement for a customer.
Optionally, the customer equity result further includes: the client rights and interests receiving state, the client rights and interests using state, the client rights and interests detail identification, the client rights and interests detail state and the client rights and interests detail using time.
For S4, the task of the distributed remote scheduling engine is used to store the customer equity results to be stored in the customer equity results table of the HBase.
HBase, is a distributed, column-oriented open-ended database.
The client equity result table, i.e. the data table of HBase, is used for storing the client equity results. The Hbase is characterized by being capable of storing mass data and supporting ms (millisecond) level query, so that real-time and efficient management of client rights and interests is facilitated.
In an embodiment, before the step of obtaining the initial data of the customer interest from the temporary storage table in response to the customer interest update request, the method further includes:
s21: sending the client rights and interests basic data of each client service application system to the client rights and interests basic data table of the Hive base through a first data transmission task to generate a data storage signal;
s22: acquiring each client rights and interests calculation script according to the data warehousing signal;
s23: acquiring one client interest computing script from each client interest computing script as a target client interest computing script;
s24: acquiring a target client interest calculation rule by executing the target client interest calculation script, and acquiring the client interest basic data from the client interest basic data table of the Hive library according to the target client interest calculation rule to obtain a client interest basic data set to be calculated;
s25: respectively carrying out the client rights and interests initial data calculation on the client rights and interests basic data set to be calculated according to the target client rights and interests calculation rule by executing the target client rights and interests calculation script to obtain a client rights and interests initial data set to be stored;
s26: storing the customer interest initial data set to be stored into the temporary storage table through a second data transmission task;
s27: and repeatedly executing the step of obtaining one client interest calculation script from each client interest calculation script as a target client interest calculation script until the obtaining of the client interest calculation script in each client interest calculation script is completed.
In this embodiment, first, the client equity basic data of each client service application system is sent to the client equity basic data table in the Hive library through a first data transfer task, then, a client equity calculation script is called to perform the client equity initial data calculation according to the client equity basic data table through the Hive task, and finally, the client equity initial data to be stored is stored in the temporary storage table through a second data transfer task in a set manner, so that the client equity calculation and the client service application system are decoupled, consumption of calculation resources of the client service application system is reduced, and the stability of providing client services by the client service application system is further improved.
For S21, the first data transfer task may employ the tasks of the Sqoop tool.
The Sqoop tool is a source opening tool, is mainly used for data transmission between Hadoop (hive) and traditional databases (MySQL, postgresql), and can guide data in a relational database (such as MySQL, Oracle, Postgres and the like) into an HDFS of Hadoop and also guide data of the HDFS into the relational database.
The method comprises the steps of acquiring data from a database corresponding to a target customer service application system through the target customer service application system according to a preset customer interest basic data preprocessing rule, preprocessing the acquired data, using the preprocessed data as customer interest basic data to be stored, storing the customer interest basic data to be stored in a customer interest basic data table corresponding to the target customer service application system in a Hive library, and generating a data storage signal after storage completion, wherein the target customer service application system is any one of the customer service application systems.
For S22, upon receiving the data-binning signal, obtaining, by the Hive task, each client rights calculation script from the Hive library.
The client rights calculation script is a script for calculating the client rights. The client rights calculation script is an sql statement of Hive written by Shell script. It will be appreciated that each customer interest corresponds to a customer interest calculation script.
sql statement, which is a structured query language.
The Shell script is similar to batch processing under Windows/Dos, namely, various commands are put into a file in advance, a program file which is convenient to execute at one time is convenient, and the Shell script is mainly convenient for an administrator to set or manage.
For S23, one of the client rights calculation scripts is sequentially obtained from each of the client rights calculation scripts, and the obtained client rights calculation script is used as a target client rights calculation script.
For step S24, by executing the target customer interest calculation script, the customer interest calculation rule corresponding to the target customer interest calculation script is obtained from the Hive library as the target customer interest calculation rule.
The customer rights calculation rule includes: customer equity matching rules, customer equity algorithm configuration data. And the client rights and interests matching rule is used for matching client rights and interests basic data. The customer equity algorithm configuration data includes: and the algorithm configuration data and the algorithm value requirement configuration data.
And acquiring the client interest basic data from the client interest basic data table of the Hive library by executing the target client interest calculation script according to a client interest matching rule of the target client interest calculation rule, and taking all the acquired client interest basic data as the to-be-calculated client interest basic data set.
For S25, by executing the target customer interest calculation script, according to the customer interest algorithm configuration data of the target customer interest calculation rule, performing the customer interest initial data calculation on the customer interest basic data set to be calculated, and taking all the customer interest initial data obtained by calculation as the customer interest initial data set to be stored.
For S26, the second data transfer task may employ the task of the Sqoop tool.
And storing the initial data set of the client rights and interests to be stored into the temporary storage table by adopting the task of the Sqoop tool.
For S27, the steps S23 to S27 are repeatedly executed until the acquisition of the client rights calculation script in each client rights calculation script is completed.
In an embodiment, the step of performing data processing on the to-be-processed customer interest initial data to obtain a to-be-stored customer interest result includes:
s31: performing default parameter supplement processing on the client rights and interests initial data to be processed by adopting a task of a distributed remote scheduling engine to obtain client rights and interests initial data after parameter supplement;
s32: performing illegal data verification and correction processing on the client rights and interests initial data after the parameter supplement by adopting the task of the distributed remote scheduling engine to obtain client rights and interests initial data after the illegal data verification;
s33: and performing repeated data combination on the client rights and interests initial data subjected to the illegal data verification by adopting the task of the distributed remote scheduling engine to obtain the client rights and interests result to be stored.
In the embodiment, the tasks of the distributed remote scheduling engine are adopted to sequentially perform default parameter supplementary processing, illegal data verification and repeated data merging on the client equity initial data to be processed, so that the data accuracy in the client equity result table is improved.
For step S31, a default parameter list is obtained by executing a task of the distributed remote scheduling engine, the default parameter list is adopted to perform default parameter supplementation processing on the to-be-processed client right initial data, and the to-be-processed client right initial data after completing default parameter supplementation is used as the client right initial data after parameter supplementation.
The default parameter list includes: parameter identifications and parameter values, wherein each parameter identification corresponds to one parameter value. The parameter identification may be a parameter name, a parameter ID, or the like, which uniquely identifies a parameter.
That is, the default values of the customer interest initial data to be processed are supplemented with the parameter values of the default parameter list. For example, the value of the parameter identifier C1 of the customer interest initial data to be processed is null, and the parameter value corresponding to the parameter identifier C1 in the default parameter list is updated to the value of the parameter identifier C1 of the customer interest initial data to be processed, so that the value of the parameter identifier C1 of the customer interest initial data to be processed is non-null, which is not limited in this example.
And S32, performing illegal data verification and correction processing on the client rights and interests initial data after the parameter supplement by executing the task of the distributed remote scheduling engine and adopting a preset illegal data verification model to obtain the client rights and interests initial data after the illegal data verification.
The preset illegal data verification model is a model obtained based on neural network training.
Illegal data is data that does not comply with the data specification. For example, when the illegal data is date data, when 2 months and 30 days appear in the customer interest initial data after the parameter is supplemented, the date data is not met by 2 months and 30 days, and thus the date data is illegal data by 2 months and 30 days. The examples are not particularly limited.
And (4) illegal data checking and correcting, namely finding out illegal data, and then modifying the illegal data by adopting a preset checking rule to ensure that the modified data conforms to the data specification.
For S33, performing duplicate data merging on the client rights and interests initial data after the illegal data verification by using the task of the distributed remote scheduling engine, and taking the client rights and interests initial data after the illegal data verification and completed by the duplicate data merging as the client rights and interests result to be stored.
In an embodiment, after the storing the customer interest result to be stored in the customer interest result table of the HBase, the method further includes:
s51: acquiring a client rights and interests display request, wherein the client rights and interests display request carries a client identifier set to be displayed;
s52: respectively acquiring a client interest result from the client interest result table according to each client identifier in the client identifier set to be displayed to obtain a client interest result set to be displayed;
s53: and displaying a page according to the client rights and interests result set to be displayed to obtain a target client rights and interests display page.
The embodiment realizes that the client interest result table based on the HBase responds to the client interest display request, and the HBase is adopted to be beneficial to real-time and efficient management of the client interest.
For S51, the client right showing request input by the service person through the client may be obtained, and the client right showing request input by the client may also be obtained.
The client comprises: a terminal of a mobile device, a web page of a mobile device, a terminal of a computer, a web page of a computer.
The set of customer identifications to be presented includes one or more customer identifications. The client identification may be a client ID for uniquely identifying a client.
For S52, respectively according to each client identifier in the set of client identifiers to be displayed, obtaining a client benefit result from the client benefit result table of the HBase, and taking all the obtained client benefit results as the set of client benefit results to be displayed.
And S53, displaying the visual page of the customer interest result set to be displayed, and taking the page which is successfully displayed as a target customer interest display page.
It is to be understood that the target customer interest presentation page may be a Web (global wide area network) page.
In an embodiment, after the step of performing page display according to the customer interest result set to be displayed to obtain the target customer interest display page, the method further includes:
s54: acquiring a sharing request according to the target client rights display page, wherein the sharing request carries a client rights identifier to be analyzed, a target sharing mode and a target sharing object identifier;
s55: responding to the sharing request, and generating information to be shared according to the target sharing mode and the client rights and interests identifier to be analyzed;
s56: and sending the information to be shared to a client corresponding to the target sharing object identifier according to the target sharing mode.
According to the embodiment, sharing is realized based on the target client rights and interests display page, so that the client contact is facilitated for business personnel, and the client can quickly know the own client rights and interests.
And S54, acquiring a sharing request sent by the user on the target client rights and interests display page.
The sharing request is a request for sharing the client rights and interests on the social software.
Target sharing modes include but are not limited to: wechat and short message.
And S55, responding to the sharing request, generating the information to be shared according to the client rights and interests result corresponding to the client rights and interests identifier to be analyzed by adopting the sharing information generation rule of the target sharing mode.
And S56, sending the information to be shared to a client corresponding to the target sharing object identifier by adopting the target sharing mode.
In an embodiment, after the storing the customer interest result to be stored in the customer interest result table of the HBase, the method further includes:
s61: the method comprises the steps of obtaining a client rights and interests application request sent by a target client, wherein the client rights and interests application request carries a client rights and interests identifier to be processed and client rights and interests application data to be updated;
s62: checking the client rights and interests application data to be updated to obtain checked client rights and interests application data;
s63: and updating the client rights and interests result table according to the client rights and interests identifier to be processed and the client rights and interests application data after the verification processing.
In this embodiment, the client right application data to be updated sent by the target client is checked first, and then the client right result table is updated, so that the accuracy of the client right result in the client right result table is further improved.
For S61, the client rights application request sent by the target client is obtained through the ESG interface.
ESG interface refers to an interface of an enhanced service gateway.
The client right application request is a request for receiving or using a client right.
The pending client interest identifier is the client interest identifier of the client interest result that the client corresponding to the target client wants to use.
The client equity application data to be updated is identification data using the client equity results.
The customer equity application data to be updated includes, but is not limited to: and (5) taking and using.
The target client, i.e. the client.
For step S62, performing non-null value check on the to-be-updated client right application data, performing parameter validity check on the to-be-updated client right application data when the non-null value check passes, and taking the to-be-updated client right application data as the client right application data after the check processing when the parameter validity check is qualified.
And if the parameter validity is qualified, the client rights and interests application data to be updated meet the data specification of the parameter.
For S63, the pending customer equity identifier is used to search in the customer equity result table of the HBase; and updating the client equity result corresponding to the client equity identification searched in the client equity result table of the HBase by adopting the client equity application data after the verification processing.
In an embodiment, the step of performing verification processing on the to-be-updated client right and interest application data to obtain verified client right and interest application data includes:
s621: performing non-null value verification on the client rights and interests application data to be updated to obtain a non-null value verification result;
s622: when the non-null value verification result is a non-null value, performing parameter validity verification on the client rights and interests application data to be updated to obtain a parameter validity verification result;
s623: and when the parameter validity check result is in line, taking the client rights and interests application data to be updated as the client rights and interests application data after the check processing.
In this embodiment, the non-null value verification is performed on the client rights and interests application data to be updated, and then the parameter validity verification is performed, so that the accuracy of the client rights and interests application data after the verification processing is improved.
For S621, performing non-null value check on the to-be-updated customer rights and interests application data, determining that the non-null value check result is a non-null value when the to-be-updated customer rights and interests application data is a non-null value, and determining that the non-null value check result is a null value when the to-be-updated customer rights and interests application data is a null value.
It is to be understood that, when the non-null value check result is a null value, which means that the customer right application data to be updated is a null value, a customer right application update end signal is generated.
For S622, when the non-null value check result is a non-null value, it means that the to-be-updated customer right and interest application data is a non-null value, performing parameter validity check on the to-be-updated customer right and interest application data, when the value of the to-be-updated customer right and interest application data conforms to the data specification of the parameter, determining that the parameter validity check result is in conformity, and when the value of the to-be-updated customer right and interest application data does not conform to the data specification of the parameter, determining that the parameter validity check result is in nonconformity.
It is understood that when the parameter validity check result is non-conformity, which means that the value of the customer interest application data to be updated does not conform to the data specification of the parameter, the customer interest application update end signal is generated.
For S623, when the result of the parameter validity check is yes, it means that the value of the to-be-updated customer right application data conforms to the data specification of the parameter, and is correct data, so that the to-be-updated customer right application data can be used as the customer right application data after the check processing.
With reference to fig. 2, the present application also proposes a device for managing customer rights, the device comprising:
a request obtaining module 100, configured to obtain a client rights and interests updating request;
a to-be-processed client right initial data determining module 200, configured to respond to the client right update request, and obtain client right initial data from a temporary storage table, so as to obtain the to-be-processed client right initial data, where the client right initial data in the temporary storage table is a client right obtained by settlement in a client right basic data table of a Hive library, and the client right basic data in the client right basic data table is data sent by each client service application system;
a to-be-stored client rights and interests result determining module 300, configured to perform data processing on the to-be-processed client rights and interests initial data to obtain to-be-stored client rights and interests results;
and a client equity result table updating module 400, configured to store the to-be-stored client equity result in the client equity result table of the HBase.
In this embodiment, initial client right and interest data is obtained from a temporary storage table, wherein the initial client right and interest data in the temporary storage table is client right and interest obtained by settlement according to a basic client right and interest data table in a Hive library, the basic client right and interest data in the basic client right and interest data table is data sent by each client service application system, then the initial client right and interest data to be processed is processed to obtain a result of the client right and interest to be stored, and finally the result of the client right and interest to be stored is stored in a result table of the client right and interest of an HBase, so that the client right and interest is centrally managed, the calculation, storage, viewing and use of the client right and interest are decoupled from the client service application system, and the HBase is adopted to facilitate the real-time implementation of the client right and interest, And (4) high-efficiency management.
Referring to fig. 3, a computer device, which may be a server and whose internal structure may be as shown in fig. 3, is also provided in the embodiment of the present application. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the computer designed processor is used to provide computational and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used for storing data such as management methods of client rights and interests. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a method of managing customer rights. The management method of the client rights and interests comprises the following steps: acquiring a client rights and interests updating request; responding to the client rights and interests updating request, acquiring client rights and interests initial data from a temporary storage table to obtain client rights and interests initial data to be processed, wherein the client rights and interests initial data in the temporary storage table are client rights and interests obtained by settlement in a client rights and interests basic data table of a Hive library, and the client rights and interests basic data in the client rights and interests basic data table are data sent by each client service application system; performing data processing on the initial data of the client rights and interests to be processed to obtain a client rights and interests result to be stored; and storing the client interest result to be stored in a client interest result table of the HBase.
In this embodiment, initial client right and interest data is obtained from a temporary storage table, wherein the initial client right and interest data in the temporary storage table is client right and interest obtained by settlement according to a basic client right and interest data table in a Hive library, the basic client right and interest data in the basic client right and interest data table is data sent by each client service application system, then the initial client right and interest data to be processed is processed to obtain a result of the client right and interest to be stored, and finally the result of the client right and interest to be stored is stored in a result table of the client right and interest of an HBase, so that the client right and interest is centrally managed, the calculation, storage, viewing and use of the client right and interest are decoupled from the client service application system, and the HBase is adopted to facilitate the real-time implementation of the client right and interest, And (4) high-efficiency management.
An embodiment of the present application further provides a computer-readable storage medium, on which a computer program is stored, the computer program, when executed by a processor, implementing a method for managing customer rights and interests, including the steps of: acquiring a client rights and interests updating request; responding to the client rights and interests updating request, acquiring client rights and interests initial data from a temporary storage table to obtain client rights and interests initial data to be processed, wherein the client rights and interests initial data in the temporary storage table are client rights and interests obtained by settlement in a client rights and interests basic data table of a Hive library, and the client rights and interests basic data in the client rights and interests basic data table are data sent by each client service application system; performing data processing on the initial data of the client rights and interests to be processed to obtain a client rights and interests result to be stored; and storing the client interest result to be stored in a client interest result table of the HBase.
The executed management method of the client rights and interests obtains initial data of the client rights and interests to be processed by acquiring initial data of the client rights and interests from a temporary storage table, wherein the initial data of the client rights and interests in the temporary storage table is obtained by settlement according to a basic data table of the client rights and interests of a Hive library, the basic data of the client rights and interests in the basic data table of the client rights and interests are data sent by each client service application system, then the initial data of the client rights and interests to be processed is subjected to data processing to obtain a result of the client rights and interests to be stored, and finally the result of the client rights and interests to be stored is stored in a result table of the client rights and interests of an HBase, so that the centralized management of the client rights and interests is realized, the calculation, the storage, the viewing and the use of the client rights and interests are decoupled from the client service application system, and the real-time management of the client rights and interests is facilitated by adopting the HBase, And (4) high-efficiency management.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium provided herein and used in the examples may include non-volatile and/or volatile memory. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), double-rate SDRAM (SSRSDRAM), Enhanced SDRAM (ESDRAM), synchronous link (Synchlink) DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and bus dynamic RAM (RDRAM).
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, apparatus, article, or method that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, apparatus, article, or method. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, apparatus, article, or method that includes the element.
The above description is only a preferred embodiment of the present application, and not intended to limit the scope of the present application, and all modifications of equivalent structures and equivalent processes, which are made by the contents of the specification and the drawings of the present application, or which are directly or indirectly applied to other related technical fields, are also included in the scope of the present application.
Claims (10)
1. A method for managing customer rights, the method comprising:
acquiring a client rights and interests updating request;
responding to the client rights and interests updating request, acquiring client rights and interests initial data from a temporary storage table to obtain client rights and interests initial data to be processed, wherein the client rights and interests initial data in the temporary storage table are client rights and interests obtained by settlement in a client rights and interests basic data table of a Hive library, and the client rights and interests basic data in the client rights and interests basic data table are data sent by each client service application system;
performing data processing on the initial data of the client rights and interests to be processed to obtain a client rights and interests result to be stored;
and storing the client interest result to be stored in a client interest result table of the HBase.
2. The method for managing customer benefits according to claim 1, wherein the step of obtaining the customer benefits initial data from the temporary storage table in response to the customer benefits update request, and obtaining the customer benefits initial data to be processed further comprises:
sending the client rights and interests basic data of each client service application system to the client rights and interests basic data table of the Hive base through a first data transmission task to generate a data storage signal;
acquiring each client rights and interests calculation script according to the data warehousing signal;
acquiring one client interest computing script from each client interest computing script as a target client interest computing script;
acquiring a target client interest calculation rule by executing the target client interest calculation script, and acquiring the client interest basic data from the client interest basic data table of the Hive library according to the target client interest calculation rule to obtain a client interest basic data set to be calculated;
respectively carrying out the client rights and interests initial data calculation on the client rights and interests basic data set to be calculated according to the target client rights and interests calculation rule by executing the target client rights and interests calculation script to obtain a client rights and interests initial data set to be stored;
storing the customer interest initial data set to be stored into the temporary storage table through a second data transmission task;
and repeatedly executing the step of obtaining one client interest calculation script from each client interest calculation script as a target client interest calculation script until the obtaining of the client interest calculation script in each client interest calculation script is completed.
3. The method for managing customer equity according to claim 1, wherein the step of performing data processing on the initial data of customer equity to be processed to obtain the result of customer equity to be stored comprises:
performing default parameter supplement processing on the client rights and interests initial data to be processed by adopting a task of a distributed remote scheduling engine to obtain client rights and interests initial data after parameter supplement;
performing illegal data verification and correction processing on the client rights and interests initial data after the parameter supplement by adopting the task of the distributed remote scheduling engine to obtain client rights and interests initial data after the illegal data verification;
and performing repeated data combination on the client rights and interests initial data subjected to the illegal data verification by adopting the task of the distributed remote scheduling engine to obtain the client rights and interests result to be stored.
4. The method for managing customer benefits according to claim 1, wherein after storing the customer benefits result to be stored in the customer benefits result table of the HBase, the method further comprises:
acquiring a client rights and interests display request, wherein the client rights and interests display request carries a client identifier set to be displayed;
respectively acquiring a client interest result from the client interest result table according to each client identifier in the client identifier set to be displayed to obtain a client interest result set to be displayed;
and displaying a page according to the client rights and interests result set to be displayed to obtain a target client rights and interests display page.
5. The method for managing customer rights and interests according to claim 4, wherein after the step of performing page display according to the customer rights and interests result set to be displayed to obtain the target customer rights and interests display page, the method further comprises:
acquiring a sharing request according to the target client rights display page, wherein the sharing request carries a client rights identifier to be analyzed, a target sharing mode and a target sharing object identifier;
responding to the sharing request, and generating information to be shared according to the target sharing mode and the client rights and interests identifier to be analyzed;
and sending the information to be shared to a client corresponding to the target sharing object identifier according to the target sharing mode.
6. The method for managing customer benefits according to claim 1, wherein after storing the customer benefits result to be stored in the customer benefits result table of the HBase, the method further comprises:
the method comprises the steps of obtaining a client rights and interests application request sent by a target client, wherein the client rights and interests application request carries a client rights and interests identifier to be processed and client rights and interests application data to be updated;
checking the client rights and interests application data to be updated to obtain checked client rights and interests application data;
and updating the client rights and interests result table according to the client rights and interests identifier to be processed and the client rights and interests application data after the verification processing.
7. The method for managing customer benefits according to claim 6, wherein the step of verifying the customer benefits application data to be updated to obtain the verified customer benefits application data comprises:
performing non-null value verification on the client rights and interests application data to be updated to obtain a non-null value verification result;
when the non-null value verification result is a non-null value, performing parameter validity verification on the client rights and interests application data to be updated to obtain a parameter validity verification result;
and when the parameter validity check result is in line, taking the client rights and interests application data to be updated as the client rights and interests application data after the check processing.
8. An apparatus for managing customer rights, the apparatus comprising:
the request acquisition module is used for acquiring a client rights and interests updating request;
a to-be-processed client right initial data determining module, configured to respond to the client right update request, obtain client right initial data from a temporary storage table, and obtain the to-be-processed client right initial data, where the client right initial data in the temporary storage table is a client right obtained by settlement in a client right basic data table of a Hive library, and the client right basic data in the client right basic data table is data sent by each client service application system;
the client rights and interests result determining module is used for carrying out data processing on the client rights and interests initial data to be processed to obtain a client rights and interests result to be stored;
and the client interest result table updating module is used for storing the client interest result to be stored in the client interest result table of the HBase.
9. A computer device comprising a memory and a processor, the memory storing a computer program, wherein the processor implements the steps of the method of any one of claims 1 to 7 when executing the computer program.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110726592.5A CN113344597B (en) | 2021-06-29 | 2021-06-29 | Method, device, equipment and storage medium for managing client rights and interests |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110726592.5A CN113344597B (en) | 2021-06-29 | 2021-06-29 | Method, device, equipment and storage medium for managing client rights and interests |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113344597A true CN113344597A (en) | 2021-09-03 |
| CN113344597B CN113344597B (en) | 2023-02-03 |
Family
ID=77481424
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110726592.5A Active CN113344597B (en) | 2021-06-29 | 2021-06-29 | Method, device, equipment and storage medium for managing client rights and interests |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113344597B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20160335722A1 (en) * | 2015-05-15 | 2016-11-17 | Joseph BOUS | System and method for assigning customer ownership based on profitability |
| CN107679868A (en) * | 2017-09-15 | 2018-02-09 | 平安科技（深圳）有限公司 | Benefits information management method, device, equipment and computer-readable recording medium |
| CN111782897A (en) * | 2020-07-07 | 2020-10-16 | 中国联合网络通信集团有限公司 | User rights management method, server, system, device, and medium |
| CN112102071A (en) * | 2020-09-24 | 2020-12-18 | 中国建设银行股份有限公司 | Client rights and interests matching method and device |
| CN113032583A (en) * | 2021-04-30 | 2021-06-25 | 中国工商银行股份有限公司 | User rights and interests matching method and device |
-
2021
- 2021-06-29 CN CN202110726592.5A patent/CN113344597B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20160335722A1 (en) * | 2015-05-15 | 2016-11-17 | Joseph BOUS | System and method for assigning customer ownership based on profitability |
| CN107679868A (en) * | 2017-09-15 | 2018-02-09 | 平安科技（深圳）有限公司 | Benefits information management method, device, equipment and computer-readable recording medium |
| CN111782897A (en) * | 2020-07-07 | 2020-10-16 | 中国联合网络通信集团有限公司 | User rights management method, server, system, device, and medium |
| CN112102071A (en) * | 2020-09-24 | 2020-12-18 | 中国建设银行股份有限公司 | Client rights and interests matching method and device |
| CN113032583A (en) * | 2021-04-30 | 2021-06-25 | 中国工商银行股份有限公司 | User rights and interests matching method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113344597B (en) | 2023-02-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9053231B2 (en) | Systems and methods for analyzing operations in a multi-tenant database system environment | |
| CN109766534B (en) | Report generation method and device, computer equipment and readable storage medium | |
| CN111143462A (en) | Data export method and device, computer equipment and storage medium | |
| CN111310427A (en) | Service data configuration processing method and device, computer equipment and storage medium | |
| CN108717426B (en) | Enterprise data updating method and device, computer equipment and storage medium | |
| CN110620812A (en) | Interactive information pushing method and device, computer equipment and storage medium | |
| WO2022105139A1 (en) | Database data object relation graph generation method and apparatus, and device, and medium | |
| CN110457401B (en) | Data storage method and device, computer equipment and storage medium | |
| CN111177121A (en) | Order data feedback method and device, computer equipment and storage medium | |
| CL2022001932A1 (en) | System and method for management system data aggregation and transformation using client-specific criteria | |
| CN113344597B (en) | Method, device, equipment and storage medium for managing client rights and interests | |
| CN112069223B (en) | Data acquisition demand processing method and device, computer equipment and storage medium | |
| CN113641712A (en) | Hit processing method, device and equipment for complex event and storage medium | |
| CN110648052B (en) | Wind control decision method and device, computer equipment and storage medium | |
| CN109271431B (en) | Data extraction method, device, computer equipment and storage medium | |
| CN111814174B (en) | Data access control method and device and computer equipment | |
| CN112559221B (en) | Intelligent list processing method, system, equipment and storage medium | |
| CN114020765A (en) | Performance data extraction method and device, computer equipment and storage medium | |
| CN110442703B (en) | Knowledge graph-based information recommendation method and device and computer equipment | |
| CN114064733A (en) | Database query method, device, equipment and medium suitable for local client | |
| CN112231377A (en) | Data mapping method, system, device, server and storage medium | |
| CN113761367A (en) | System, method and device for pushing robot process automation program and computing equipment | |
| CN113609174A (en) | Industry user data searching method and device, computer equipment and storage medium | |
| CN112463836A (en) | Data query method and device based on Django framework, computer equipment and medium | |
| CN108073626B (en) | Target customer group positioning method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |