CN112085488A - General point account management method and system - Google Patents
General point account management method and system Download PDFInfo
- Publication number
- CN112085488A CN112085488A CN202011044668.8A CN202011044668A CN112085488A CN 112085488 A CN112085488 A CN 112085488A CN 202011044668 A CN202011044668 A CN 202011044668A CN 112085488 A CN112085488 A CN 112085488A
- Authority
- CN
- China
- Prior art keywords
- rule
- integral
- calculation
- point
- transaction
- 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.)
- Pending
Links
- 238000007726 management method Methods 0.000 title claims abstract description 26
- 238000004364 calculation method Methods 0.000 claims abstract description 136
- 230000000694 effects Effects 0.000 claims abstract description 83
- 238000000034 method Methods 0.000 claims abstract description 38
- 238000012545 processing Methods 0.000 claims abstract description 26
- 230000000875 corresponding effect Effects 0.000 claims description 38
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 claims description 32
- 238000001914 filtration Methods 0.000 claims description 30
- 238000012216 screening Methods 0.000 claims description 27
- 238000007781 pre-processing Methods 0.000 claims description 10
- 238000012795 verification Methods 0.000 claims description 10
- 238000004590 computer program Methods 0.000 claims description 5
- 230000001360 synchronised effect Effects 0.000 claims description 3
- 238000005516 engineering process Methods 0.000 abstract description 5
- 230000010354 integration Effects 0.000 description 13
- 230000008569 process Effects 0.000 description 12
- 238000004891 communication Methods 0.000 description 9
- 230000015654 memory Effects 0.000 description 9
- 230000035508 accumulation Effects 0.000 description 8
- 238000009825 accumulation Methods 0.000 description 8
- 238000010586 diagram Methods 0.000 description 7
- 230000001186 cumulative effect Effects 0.000 description 6
- 238000013461 design Methods 0.000 description 6
- 238000004140 cleaning Methods 0.000 description 4
- 230000009471 action Effects 0.000 description 3
- 238000004458 analytical method Methods 0.000 description 3
- 238000003066 decision tree Methods 0.000 description 3
- 238000011144 upstream manufacturing Methods 0.000 description 3
- 238000004422 calculation algorithm Methods 0.000 description 2
- 238000001514 detection method Methods 0.000 description 2
- 238000000605 extraction Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000002955 isolation Methods 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 238000013507 mapping Methods 0.000 description 2
- 230000003936 working memory Effects 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000003247 decreasing effect Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000000977 initiatory effect Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 230000011218 segmentation Effects 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
- 230000007704 transition Effects 0.000 description 1
- 238000011282 treatment Methods 0.000 description 1
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
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/08—Payment architectures
- G06Q20/10—Payment architectures specially adapted for electronic funds transfer [EFT] systems; specially adapted for home banking systems
- G06Q20/102—Bill distribution or payments
-
- 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
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/38—Payment protocols; Details thereof
- G06Q20/40—Authorisation, e.g. identification of payer or payee, verification of customer or shop credentials; Review and approval of payers, e.g. check credit lines or negative lists
- G06Q20/405—Establishing or using transaction specific rules
-
- 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/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0207—Discounts or incentives, e.g. coupons or rebates
- G06Q30/0213—Consumer transaction fees
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Engineering & Computer Science (AREA)
- Development Economics (AREA)
- Strategic Management (AREA)
- Physics & Mathematics (AREA)
- Economics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Computer Security & Cryptography (AREA)
- Entrepreneurship & Innovation (AREA)
- Game Theory and Decision Science (AREA)
- Marketing (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the invention provides a universal point account management method and a universal point account management system, wherein the method comprises the following steps: setting an activity rule associated with the points; accessing each component to obtain the transaction flow of each component; performing point calculation on the transaction flow of the component according to a rule engine to generate a point result file; wherein, the rule engine is configured with part of activity rules associated with the points; and adjusting the corresponding account according to the account type and the account serial number in the point result file. The embodiment of the invention realizes the application of key technologies such as distributed park multi-activity architecture, stream type calculation, rule engine, sub-base and sub-table and the like, and greatly improves the data processing performance. The constructed integral account system has strong expansibility and can meet the rapid expansion of different scene integral types.
Description
Technical Field
The invention relates to point management, in particular to a universal point account management method and a universal point account management system.
Background
The existing platform credit account is independent from the traditional bank-building account and is directly linked to the customer information.
In the process of implementing the invention, the inventor finds that at least the following problems exist in the prior art:
in general, point accounts are independent from each other, different products correspond to different accounts, inquiring point transaction record information is complicated, and problem processing cost is high.
Disclosure of Invention
The embodiment of the invention provides a universal point account management method and a universal point account management system, which aim to solve the technical problems of more complicated point transaction record information query and higher problem processing cost.
In a first aspect, an embodiment of the present invention provides a method for managing a universal points account, including:
setting an activity rule associated with the points;
accessing each component to obtain the transaction flow of each component;
performing point calculation on the transaction flow of the component according to a rule engine to generate a point result file; wherein a portion of the activity rules associated with points are configured in the rules engine;
and adjusting the account according to the account type and the account serial number in the point result file.
In a second aspect, an embodiment of the present invention provides a universal points account management system, which includes:
a setting module for setting an activity rule associated with the score;
the access module is used for accessing each component to obtain the transaction flow of each component;
the calculation module is used for carrying out point calculation on the transaction flow of the assembly according to the rule engine to generate a point result file; wherein a portion of the activity rules associated with points are configured in the rules engine; and the reconciliation module is used for reconciling the corresponding account according to the account type and the account serial number in the point result file.
In a third aspect, an embodiment of the present invention provides a computer-readable storage medium, on which a computer program is stored, which when executed by a processor implements the universal points account management method.
In a fourth aspect, an embodiment of the present invention provides a computer device, including:
one or more processors;
storage means for storing one or more programs;
the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the universal points account management method.
The technical scheme has the following beneficial effects:
the embodiment of the invention adopts the database and the table, the affairs are completely isolated, the complicated affairs of the affair isolation do not need to be considered, and the error is low; the universality is strong, and the extraction of public unification is easy to realize; the service operation is simple and pure; the method can support parameterized adjustment of the validity period, has a simple integral cleaning algorithm, supports the design of servitization, basically does not relate to batch operation on the accounts in calculation and batch processing, can be completely converted into operation of a single account, and supports a scheme of 7 × 24 hours, so that the influence of the setting of the validity period parameters on a system implementation scheme is reduced, and the complexity of integral cleaning is reduced; the data size of the main file of the point account is convenient to control.
The embodiment of the invention realizes the application of key technologies such as distributed park multi-activity architecture, stream type calculation, rule engine, sub-base and sub-table and the like, and greatly improves the data processing performance. The constructed integral account system has strong expansibility and can meet the rapid expansion of different scene integral types.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a general flowchart of a method for managing a universal points account according to an embodiment of the invention;
FIG. 2 is an overall layout of an integration calculation of an embodiment of the present invention;
FIG. 3 is a flowchart of a specific process of pre-processing according to an embodiment of the present invention;
FIG. 4 is a diagram of a process for calculating a basis integral according to an embodiment of the present invention;
FIG. 5 is a diagram of the processing logic of a rules engine of an embodiment of the present invention;
FIG. 6 is a functional block diagram of a universal points account management system according to an embodiment of the present invention;
FIG. 7 is a functional block diagram of a computing module provided by an embodiment of the present invention;
fig. 8 is a functional block diagram of an electronic device provided by an embodiment of the invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The following first makes a term explanation:
turning out: and at the service initiation point, a final consistency scheme is adopted to control the cross-library operation flow of the main body.
Turning into a method: and positive transactions and corresponding negative transactions are provided, and the positive reversal function under the abnormal condition is met. There is also a need to provide a transaction that queries for transition to a state.
One of the technical problems solved by the embodiment of the invention is as follows: the method supports the comprehensive point calculation of different products, opens multi-channel point use, centrally manages the feedback activities of customers, realizes the combination and use with the point accounts in rows, and simultaneously supports the inquiry of the total point transaction records.
The embodiment of the invention supports the comprehensive point calculation of different products, opens the multi-channel point use, and the traditional accounts are mutually independent and are directly linked to the customer information. The point account management method and the point account management system distinguish corresponding products and activities according to the point account types and the point account serial numbers, realize accumulation of customer points, support comprehensive point calculation of different products, open multi-channel point use, realize combination and use with point accounts in rows, and simultaneously can inquire full-amount point transaction records.
Fig. 1 is an overall flowchart of a general points account management method according to an embodiment of the present invention. As shown in fig. 1, the method comprises the steps of:
s110: an activity rule associated with the points is set.
In this embodiment, the activity rule associated with the score may include: the system comprises a calculation rule for calculating points, and any one or more of a customer screening rule for screening customers, a filtering rule for filtering invalid transaction water flows and a verification rule for verifying capping values of the points.
The point customer service management system supports flexible configuration of activities, can set basic point rules, point reward activity rules and point feedback activity rules, corresponds to point accumulation and point exchange scenes, and can set the activity rules according to different conditions. In this embodiment, the credit customer service management system, whose function is to configure credit activity rules, includes: a basal point rule, a point reward activity rule, and a point reward activity rule. The integral feedback rule corresponds to the integral feedback activity and is mainly a rule for exchanging the integral, such as a rule for using the integral, such as an integral exchange proportion, an integral exchange lower limit and the like. The activity rules associated with points are primarily used to filter the transaction pipeline to calculate the value of the accumulable points. Specifically, setting the calculation rule for performing the integral calculation in step S110 may include steps S112 to S116.
Step S112: and setting a basic integration rule.
The underlying point rules are oriented to daily point calculations for products and transactions, are effective for a long time, increase as new marketable products increase, and do not add features to customers and contracts. The basis integrals have no active constraints and are directly applicable to the rules. A basic rule of a saleable product, and the source of the rule elements is mainly transaction information generated by the product.
Step S114: and setting a point reward activity rule.
And calculating the reward points facing a specific marketing activity, and limiting the activity time, the client range and the product range. The dimension of the reward rule comprises a plurality of layers of time, products, customers, transactions and the like, and the source of the rule element also relates to a plurality of components of the comprehensive points, the customer information, the products and the like. The reward rule is a corresponding rule under the bonus point activity, and a plurality of reward rules can be set in the same bonus activity.
Step S116: and setting an integral feedback activity rule.
The ranges of time, client and service contents fed back by integration are limited through activities, and the regular dimension is mainly the time, client and service contents fed back. The rule elements are derived from respective online transactions. The third party fixes the points that are rolled out, the elements being derived from the product number and time.
S120: and accessing each component to obtain the transaction flow of each component.
The point calculation management system supports data access of different scenes, can be flexibly set according to the current scene, receives running data of each component after corresponding activities are set, matches reward activity rules according to information configured with different components, and calculates points according to the matched corresponding activity rules. The reward activity rule can be associated with the basic point rule, and the running water matched with the basic point rule can be matched with the corresponding reward activity rule. And matching the values of the corresponding fields in the running data with the values set in the reward rules. For example, when a rule sets the transaction type to consume, the rule will only be matched if the transaction type in the stream is consume.
The data sources are differentiated for different scenarios, such as credit card component, dragon payment component, etc.
The data of each component is the transaction flow of the corresponding channel, and the acquisition channel of the points is expanded by accessing each component.
The credit card consumption is the trade flow paid by using the credit card, wherein, the trade can be divided into the use of the credit card by a micro messenger and the use of the credit card by a payment device, and the activities can be respectively set according to the trade channels.
After filtering the invalid running water, matching the basic point rule and the point reward activity rule according to the data in the valid running water, and generating a piece of data with a rule number when the data in the running water completely accords with the data set in the rule engine. Specifically, the values in the data are transmitted to a rule engine, the rule engine returns the matched rule number, and the rule number is associated with the flow to generate a new piece of data.
For example: when the point rule is set, the consumption with the transaction type of 4 can obtain 2 times of points of the transaction amount, only the running water with the transaction type of 4 in the running water data can be matched with the point rule, and the accumulative point value is calculated according to the transaction amount.
In this embodiment, invalid running water may be filtered according to some general rules, such as conditions of merchant without counting points, blacklist customer, and the like.
S130: and (4) calculating by a rule engine. In the step, the transaction flow of the components is subjected to point calculation according to a rule engine to generate a point result file.
Optionally, this step may specifically include the following processing steps: screening the transaction flow of the components, and filtering the transaction flow without recording points to generate an effective transaction flow; matching corresponding integral calculation rules in the rule engine according to the effective transaction running water; and performing integral calculation according to the matched integral calculation rule to generate an integral result file.
S140: and adjusting accounts of the points. And in the step, the corresponding account is adjusted according to the account type and the account serial number in the point result file.
In some embodiments, the account category and account number may be used to determine an individual account. Points earned by the same customer in different channels may not be common and need to be differentiated by account type and account needs. This is also true when using integrals, and an integral obtained in one channel can only be used in the current scenario.
In this embodiment, the activity rules associated with the points include rules in a rules engine, where the rules stored in the rules engine are only a portion of the rule information for the activity rules associated with the points.
The rule engine is only a part of the score activity rule and is also generated in configuring the activity rule associated with the score, and the transaction pipelines of different components are also combined with the rule not in the rule engine (namely, the rule except the rule engine in the activity rule associated with the score) to perform score calculation to generate a score result file. The calculation according to the rules engine is only part of the integral calculation. And subsequently, carrying out a capping value check, and when the reward point capping value is set in the activity, subsequently checking whether the accumulated value of the customer in the current activity reaches the capping value.
A rule engine: the design aim is to strip the point calculation and point activity configuration part from the application code, so that the calculation/configuration activity part is not bound with the business logic, thereby achieving dynamic maintenance and facilitating expansion. In some exemplary embodiments, the calculation part of the rule engine uses the jexl3 expression, and the jexl3 supports many grammar rules, so that many requirements which may be involved in calculation, logic judgment, circulation and the like can be met. When the rule engine is accessed for the first time, the rule engine can read all the templates (formula templates used in integral calculation) into the working memory at one time, and then the memory is read instead of repeatedly loading, so that the execution efficiency is improved. The rule engine is a limiting condition when a rule is set, and calculates an integral value according to a set formula when the rule is satisfied.
In this embodiment, the rule engine calculates that at the end of each day, the rule file is unloaded, the upstream component transaction running water is screened, the unrecognized point running water is filtered, and after the effective running water file is generated, the rule matching calculation is performed to generate the point result file. The above-mentioned rule matching calculation means: when the rules are set, a corresponding calculation rule is generated at the same time, the corresponding calculation rule is found through the rule number and the flow data, and the accumulative integral value is calculated according to the transaction amount in the flow data. Specifically, when the rule is set, conditions for matching the rule, such as transaction amount, transaction channel, transaction mode, etc., are set, and the conditions are stored in the rule engine; meanwhile, the number of points can be accumulated under the condition of meeting the conditions, for example, the points are multiplied according to the consumption amount or accumulated according to the consumption times, which is a calculation rule, and the calculation rule are related through a rule number. Firstly, matching qualified data in the rule engine, and then calculating an accumulative integral value through a formula.
The integral calculation is characterized by large calculation amount, high concurrency, high requirements on flexibility and expandability and high calculation logic complexity. The integral calculation includes four processes: preprocessing, screening of integral rules, integral calculation and updating of integral calculation results. The point calculation comprises a rule engine calculation, and the rule engine calculation is only used for calculating the point value which is obtained by the current transaction flow according to the rule. The point calculation includes the rules engine calculation and the checking of the subsequent capping value to calculate the point finally available to the customer in the transaction in this activity, i.e. the final accumulated point value. FIG. 2 is an overall layout of the integral calculation of an embodiment of the present invention. As shown in fig. 2, the integral calculation specifically includes the following steps:
s132: step 1, a preprocessing step, which is to preprocess the input data of the integral calculation.
FIG. 3 is a flowchart illustrating exemplary pre-processing according to an embodiment of the present invention. As shown in fig. 3, in some exemplary embodiments, the preprocessing step S132 may include the following processing sub-steps:
s132_ 1: and mapping product component data fields. The step processes the product source data files from each channel into a unified interface file. As an example, this step can be further refined to the following steps:
s132_ 11: a product source data file is entered or obtained.
S132_ 12: and carrying out field mapping processing on the product source data file to obtain an integral calculation unified interface file. In this embodiment, since each component data field is different, it needs to be processed separately, and the component number is used to identify the data source, and the data is processed into the required data format.
S132_ 13: and outputting the integral calculation unified interface file.
S132_ 14: and calculating a unified interface file according to the points, and judging the transaction type. In this embodiment, the transaction type is determined by the corresponding component according to the requirements of each component. For example: dragon payments include recharge, cash withdrawal, face-to-face transfer, payment, refund (return transaction), ATM cash withdrawal, cash withdrawal application, red envelope, etc.
S132_ 15: when the transaction type is a return transaction, the accumulated point value is eliminated according to the original transaction serial number. Specifically, one field in the flow data is a transaction type, and whether the transaction is a return transaction can be judged according to different values of the transaction type.
S132_ 16: when the transaction type does not belong to a return transaction and the transaction type matches the transaction type set in the rule, it is determined to perform the point calculation. Specifically, when the reward activity rule is set, the transaction type is set, subsequent calculation is performed only when the transaction type in the running water is matched with the transaction type set in the point rule, and otherwise, the running water is set as invalid running water.
S132_ 2: and (5) screening the clients. In this step, the customer information data is screened according to the customer screening rule to form a customer list conforming to the customer screening rule. As an example, the client screening rule may be set when the rule is set, for example, the client star level may be set to be greater than 3 for matching, and the client star level may be queried in the subsequent calculation and then it is determined whether the accumulated points are met.
S132_ 3: and (5) integrating rule loading. In this step, all the required integration rules are calculated by the rule engine and the online library to obtain the integration. The loading process of the point activity and the rule is to load some data in the online library to the rule engine. Optionally, rules that are validated on the current day are filtered out in the online library at the time of initialization each day and loaded into the rule engine. In this embodiment, the integral activity is added first, and the rule corresponding to the integral activity is configured on the basis of the integral activity, that is, the integral activity is first followed by the rule. The integration activities include: the rule comprises rule information such as a capping value and customer information.
Preferably, the sub-steps included in the step S132 may be executed in the order of S132_3, S132_2, and S132_ 1.
S134: and 2, screening an integral rule, namely screening a data range for integral calculation from the preprocessed data according to a filtering rule for filtering invalid transaction flow. As an example, this step filters out credit flows, such as blacklisted merchants, blacklisted customers, etc.
In some exemplary embodiments, step S134 may include the following sub-steps:
s134_ 1: one or more scoring rules are obtained from a rules engine. As an example, the one or more integration rules may be selected from one or more of the following: basic point rules, reward point rules corresponding to single transaction and reward point rules corresponding to accumulated transaction.
S134_ 2: and according to the acquired one or more integral rules, performing one or more filtering treatments on the preprocessed input data to obtain a screened data range. As an example, in this step, any one or any plurality of the following filtering processes are performed:
filtering the preprocessed input data according to a basic integral rule;
filtering the preprocessed input data according to a reward point rule corresponding to a single transaction;
and filtering the preprocessed input data according to the reward point rule corresponding to the accumulated transaction.
In this embodiment, the bonus point rules may be divided into separate bonus rules and bonus rules associated with the base points.
S134_ 3: and outputting the screened data range.
S136: and step 3, an integral calculation step, wherein the integral calculation step is to calculate the integral according to a calculation formula. In step (c), a specific calculation formula is associated with a rule set, and for example, a ratio of the amount to the point may be set according to the amount of money, or a fixed point value may be awarded according to the number of times of consumption. In the step, the integral is calculated according to a calculation formula, and an integral original value is generated (including the calculation of the basic integral and the reward integral); the final accumulatable integration value is determined according to an integration upper limit set in the rule.
The above-described awarding of the fixed point value according to the number of consumption is as follows as an example: for example, three thousand points may be accumulated by accumulating three times of consumption at a point-counting merchant through a dragon payment. Only the customer accumulates three purchases at the point-counting merchant through long payment during the event, and the corresponding three thousand points are accumulated after the third purchase.
In some exemplary embodiments, step S136 may include the following sub-steps:
s136_ 1: and calculating the basic integral according to the basic integral rule.
S136_ 2: and calculating the reward point rule corresponding to the single transaction according to the point reward activity rule.
S136_ 3: and calculating the reward point rule corresponding to the accumulated transaction according to the point reward activity rule.
S136_ 4: and (4) integral adjustment. This step is an optional step and may be omitted in some embodiments.
S136_ 5: the integration calculation raw value is obtained. The integral calculation original value is calculated according to the data in the flowing water by finding a corresponding calculation formula through a matched rule. The credit calculation original value depends on how the rule is set, and the credit calculation original value may be set to a fixed value or may be set in proportion to the transaction amount to calculate the credit value.
S136_ 6: and obtaining a final integral calculation result. In this step, a final integral calculation result is determined from the integral calculation original value, the accumulated integral value, and an integral upper limit determined by a check rule for performing integral capping value check. Specifically, the integral capping value may be set at the time of setting the rule. And comparing the sum of the calculated original value and the accumulated integral value under the rule with the set capping value to calculate a final integral calculation result. The step is online transaction, which is data batch processing, and after the data is processed into a required format, the task automatically calls the online transaction to determine a final calculation result so as to adjust the account balance and generate the point details.
S138: and 4, updating the integral calculation result, wherein the integral calculation result is synchronized to an online library through an online service.
In some exemplary embodiments, step S138 may include the following sub-steps:
s138_ 1: and performing detail collection to obtain the final accumulative integral value of the customer.
S138_ 2: and calling a synchronous online point data service to update the account.
FIG. 4 is a process for basis integral calculation according to an embodiment of the present invention. As shown in fig. 4, the integral in fig. 4 includes a basic integral, and taking the basic integral as an example, the integral calculation is a process of filtering according to a rule by unifying interface files, and generating integral details by combining an integral calculation formula. And calculating the value of the integral obtained by the single-stroke running data through the single-stroke transaction integral calculation.
The point result updating is to collect the point accumulations of the respective rules and adjust the point balance of the customer and other related information. Thus, complex accounts and detailed update business logic are controlled through unified online service. The updating logic is prevented from being distributed at both online and batch positions, and the subsequent maintenance complexity is increased. Through online transaction, the updated unit is controlled in the account of a single client, 365 x 24 can be better supported, the problem of complexity caused by batch operation of batch data is avoided, and the client experience is improved.
The batch processing is mainly the filtering and screening of running water, the matching rule and the integral value calculation.
The online is a calculated point result file, online services are called one by one, a final point calculation result is determined according to the upper limit of the point, and then the balance of the account point is adjusted.
The processing procedure of the basic integral calculation of fig. 4 mainly includes the following steps:
s210: the method comprises the steps of receiving transaction running water pushed by an upstream component, namely a unified interface file, and processing invalid transaction running water filtering on the unified interface file, for example, processing invalid running water filtering can be performed according to a non-counting point rule, or processing invalid running water filtering according to a product dimension point rule (distinguished according to a saleable product number), or according to a blacklist customer rule. After invalid transaction running water is filtered, specified condition data (such as transaction types, transaction times, transaction channels, transaction amounts, transaction modes and the like) in the valid transaction running water is transmitted to a rule engine, the rule engine returns matched rule numbers, and the rule numbers are associated with the valid transaction running water to generate new running water data. The source data filtering rule in fig. 4 refers to filtering the original pipeline pushed by the upstream component.
S220: and acquiring an integral calculation formula or method corresponding to the rule number according to the matched rule number. And then, calculating a single transaction point according to the obtained corresponding point calculation formula to generate an initial point accumulation detail. The initial integral accumulation detail may include: customer number, rule number, cumulative time, initial cumulative point value, source transaction serial number, etc.
S230: an online service is invoked to calculate the value of credit that is ultimately available. The calling online service adjusts the upper limit of the integral according to the initial integral accumulated detail and the accumulated integral statistical information, and calculates the final integral value, namely the adjusted integral accumulated detail is obtained. The accumulated point statistic information may include: customer number, rule number, current day cumulative value, current month cumulative value, etc. The adjusted integral accumulation schedule may include: customer number, rule number, cumulative point value, etc. The accumulated integral value here is an integral value that the customer finally obtains after passing the verification. The current day total is how many points the client has accumulated in the current day under the activity. The current month accumulation is how many points the client accumulates in the current month under the activity. The current year's cumulative is how many points the client has accumulated in the current year under the activity.
S240: in the online service, the final integral value is calculated, so that the account integral balance can be adjusted subsequently, and the integral details can be generated or updated.
FIG. 5 is the processing logic and execution of a rules engine of an embodiment of the present invention. As shown in FIG. 5, the campaign rules, date filter rules, product transaction filter rules, and customer filter rules are placed in the points rules engine. The rules engine makes the setting of rules more flexible. One integration activity corresponds to one rule group, the rule group comprises a plurality of rules, a plurality of limiting conditions can be configured under one activity through the rule group, one activity corresponds to one rule group, and the conditions which can be matched with the activity are in the rule group. The transaction type of the date rule can be set when the rule is set, and after the date rule is set, the rule can be matched only if the transaction date meets the condition. Fig. 5 is a diagram mainly illustrating a rule engine node, a rule engine client, and a matching rule. The rule engine comprises a rule base storing a plurality of integration rules.
And the rule assembly module is used for carrying out domain analysis on the data in the domain field table and carrying out analysis on the data in the rule table to form a rule decision tree. Rule decision tree: the structure of a tree formed by rule conditions.
And the rule analysis module is used for analyzing the data in the rule table.
And the query and storage engine module is used for querying and storing the rule engine information.
And the working memory is used for storing information such as domain fields, rule sets, rule decision trees and the like. One reward point activity corresponds to one rule group, the rule group comprises a plurality of rules, and the same reward point activity can be configured through the rule group. A rule set is a set of rules corresponding to an activity. A domain field: the values of the set rule conditions, for example: transaction type equals 4, and 4 exists in the domain field.
And the rule base is used for storing related information such as a rule table, a domain field table and the like.
And the execution engine module is used for loading a rule set and analyzing the rule. And simultaneously, executing the analyzed rules to the specific input data object according to a rule reasoning engine.
A pattern matcher for deciding which rule to execute and when to execute the rule.
And the agenda manager is used for determining the execution sequence of the rules selected by the pattern matcher.
And the design engine module is used for setting the conflict detection module and the rule verification module.
And the conflict detection module is used for solving conflicts and putting the activated rules in sequence.
And the rule verification module is used for verifying whether the data is matched with the rule or not.
S140: and adjusting accounts of the points.
In the step, the corresponding account can be adjusted according to the account type and the account serial number in the point result file, so that the adjustment of the account point balance is realized.
The embodiment of the invention adopts a database and table dividing technology to realize the support of large data volume and high concurrency. And carrying out data segmentation design according to a hashing scheme of the client number. The embodiment of the invention is oriented to all personal customers and 27 asset products in the whole row, has large data volume, and reduces the processing pressure of a single database by adopting a database-dividing and table-dividing technology; the database and table division is carried out in a mode of dividing vertically and then horizontally, wherein vertically means that the inside of the comprehensive integration is divided into basic modules which are isolated from each other, and horizontally means that the table is divided horizontally inside each module.
The account structure is characterized in that: each account record only stores accumulated data in the current validity period;
account balancing relationship: the points can be used for calculating the points, increasing the points, decreasing the points and exchanging the points.
The core of the cross-library operation lies in the control of data consistency and integrity, and is divided into an outward party and an inward party from a participating body.
The embodiment of the invention has the advantages that:
the embodiment of the invention adopts the database and the table, the affairs are completely isolated, the complicated affairs of the affair isolation do not need to be considered, and the error is low; the universality is strong, and the extraction of public unification is easy to realize; the service operation is simple and pure; the method can support parameterized adjustment of the validity period, has a simple integral cleaning algorithm, supports the design of servitization, basically does not relate to batch operation on the accounts in calculation and batch processing, can be completely converted into operation of a single account, and supports a scheme of 7 × 24 hours, so that the influence of the setting of the validity period parameters on a system implementation scheme is reduced, and the complexity of integral cleaning is reduced; the data size of the main file of the point account is convenient to control.
The embodiment of the invention realizes the application of key technologies such as distributed park multi-activity architecture, stream type calculation, rule engine, sub-base and sub-table and the like, and greatly improves the data processing performance. The constructed integral account system has strong expansibility and can meet the rapid expansion of different scene integral types.
Fig. 6 is a functional block diagram of a general points account management system according to an embodiment of the present invention. As shown in fig. 6, it includes:
a setting module for setting an activity rule associated with the score;
the access module is used for accessing each component to obtain the transaction flow of each component;
the calculation module is used for carrying out point calculation on the transaction flow of the assembly according to the rule engine to generate a point result file; wherein a portion of the activity rules associated with points are configured in the rules engine;
and the reconciliation module is used for reconciling the corresponding account according to the account type and the account serial number in the point result file.
In an alternative embodiment, the activity rule associated with the score includes: the system comprises a credit calculation rule for carrying out credit calculation, and any one or more of a customer screening rule for screening customers, a filtering rule for filtering invalid transaction running water and a verification rule for carrying out credit capping value verification; when setting a calculation rule for performing integral calculation, the setting module is specifically configured to execute any one or more of the following: setting a basic integral rule; setting a point reward activity rule; and setting an integral feedback activity rule.
In an alternative embodiment, the access module may specifically be configured to: and (3) butting the data of each component, matching the reward rule according to the information of different configured components, and calculating the integral according to the matched activity rule.
In an alternative embodiment, the calculation module may be specifically configured to: screening the transaction flow of the components, and filtering the transaction flow without recording points to generate an effective transaction flow; matching corresponding integral calculation rules in the rule engine according to the effective transaction running water; and performing integral calculation according to the matched integral calculation rule to generate an integral result file.
In an alternative embodiment, as shown in fig. 7, the calculation module may specifically include:
a pretreatment unit: the system comprises a preprocessing module, a data acquisition module, a data processing module and a data processing module, wherein the preprocessing module is used for preprocessing input data of integral calculation;
an integral rule screening unit: the data processing device is used for screening out a data range for integral calculation from the preprocessed data according to a filtering rule for filtering invalid transaction running water;
an integral calculation unit: the system comprises a rule engine, a rule engine and a data processing module, wherein the rule engine is used for matching the integral calculation rule contained in the rule engine with the data range to obtain a data range;
an integral calculation result update unit: for synchronizing the point calculation results to an online repository through an online service.
In an optional embodiment, the preprocessing unit is specifically configured to: processing the product source data file into a uniform interface file; screening the customer information data according to the customer screening rule to form a customer list conforming to the customer screening rule; and obtaining points through the rule engine and the online library to calculate all needed point rules.
In an alternative embodiment, the integral calculation unit may specifically include:
the first calculating subunit is used for calculating the basic integral according to the basic integral rule;
the second calculation subunit is used for calculating the reward point rule corresponding to the single transaction according to the point reward activity rule;
the third calculation subunit is used for calculating the reward point rule corresponding to the accumulated transaction according to the point reward activity rule;
the acquisition subunit is used for acquiring an integral calculation original value;
and the final integral calculation subunit is used for determining a final integral calculation result according to the integral calculation original value, the accumulated integral value and an integral upper limit determined by the verification rule for verifying the integral capping value.
An embodiment of the present invention further provides an electronic device, as shown in fig. 8, including one or more processors 301, a communication interface 302, a memory 303, and a communication bus 304, where the processors 301, the communication interface 302, and the memory 303 complete communication with each other through the communication bus 304.
A memory 303 for storing a computer program;
the processor 301 is configured to implement the steps of any one of the above-described methods for managing a universal points account when executing the program stored in the memory 303.
The point account management method of the embodiment of the invention distinguishes corresponding products and activities through the point account types and the point account serial numbers, realizes the accumulation of customer points, supports the comprehensive point calculation of different products, opens multi-channel point use, and realizes the combination and use with in-line point accounts.
The communication bus mentioned in the electronic device may be a Peripheral Component Interconnect (PCI) bus, an Extended Industry Standard Architecture (EISA) bus, or the like. The communication bus may be divided into an address bus, a data bus, a control bus, etc. For ease of illustration, only one thick line is shown, but this does not mean that there is only one bus or one type of bus. The communication interface is used for communication between the electronic equipment and other equipment.
The Memory may include a Random Access Memory (RAM) or a Non-Volatile Memory (NVM), such as at least one disk Memory. Optionally, the memory may also be at least one memory device located remotely from the processor.
The Processor may be a general-purpose Processor, including a Central Processing Unit (CPU), a Network Processor (NP), and the like; but also Digital Signal Processors (DSPs), Application Specific Integrated Circuits (ASICs), Field Programmable Gate Arrays (FPGAs) or other Programmable logic devices, discrete Gate or transistor logic devices, discrete hardware components.
The embodiment of the invention also provides a computer readable storage medium, wherein a computer program is stored in the computer readable storage medium, and when being executed by a processor, the computer program realizes the steps of any one of the above general point account management methods.
Those of skill in the art will further appreciate that the various illustrative logical blocks, units, and steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, computer software, or combinations of both. To clearly illustrate the interchangeability of hardware and software, various illustrative components, elements, and steps have been described above generally in terms of their functionality. Whether such functionality is implemented as hardware or software depends upon the particular application and design requirements of the overall system. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present embodiments.
It is noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus 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, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
All the embodiments in the present specification are described in a related manner, and the same and similar parts among the embodiments may be referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, as for the device, the electronic device and the readable storage medium embodiments, since they are substantially similar to the method embodiments, the description is simple, and the relevant points can be referred to the partial description of the method embodiments.
The above description is only for the preferred embodiment of the present invention, and is not intended to limit the scope of the present invention. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention shall fall within the protection scope of the present invention.
Claims (10)
1. A method for universal points account management, comprising:
setting an activity rule associated with the points;
accessing each component to obtain the transaction flow of each component;
performing point calculation on the transaction flow of the component according to a rule engine to generate a point result file; wherein a portion of the activity rules associated with points are configured in the rules engine;
and adjusting the account according to the account type and the account serial number in the point result file.
2. The method of claim 1, wherein the activity rules associated with points comprise: the system comprises a credit calculation rule for carrying out credit calculation, and any one or more of a customer screening rule for screening customers, a filtering rule for filtering invalid transaction running water and a verification rule for carrying out credit capping value verification; the calculation rule set for performing the integral calculation specifically includes any one or more of the following:
setting a basic integral rule; setting a point reward activity rule; and setting an integral feedback activity rule.
3. The method according to claim 2, wherein the accessing each component to obtain the transaction flow of each component specifically comprises:
and receiving the running data of each component after setting corresponding activities, matching the point reward activity rules according to the information of different configured components, and calculating points according to the matched activity rules.
4. The method according to claim 2, wherein the performing a point calculation on the transaction pipeline of the component according to a rules engine to generate a point result file specifically comprises:
screening the transaction flow of the components, and filtering the transaction flow without recording points to generate an effective transaction flow;
matching corresponding integral calculation rules in the rule engine according to the effective transaction running water;
and performing integral calculation according to the matched integral calculation rule to generate an integral result file.
5. The method of claim 4, wherein the filtering is performed on a transaction pipeline of the components, and the filtering is performed on an importation transaction pipeline to generate an effective transaction pipeline; matching corresponding integral calculation rules in the rule engine according to the effective transaction running water; according to the matched integral calculation rule, integral calculation is carried out to generate an integral result file, and the method specifically comprises the following steps:
a pretreatment step: preprocessing input data of integral calculation;
and (3) screening an integral rule: screening a data range for integral calculation from the preprocessed data according to a filtering rule for filtering invalid transaction running water;
and an integral calculation step: calculating an integral according to the screened data range and a calculation formula contained in an integral calculation rule matched from the rule engine to obtain an integral calculation result;
and updating an integral calculation result: the point calculation results are synchronized to an online repository through an online service.
6. The method according to claim 5, wherein the step of pre-treating comprises in particular:
processing the product source data file into a uniform interface file;
screening the customer information data according to the customer screening rule to form a customer list conforming to the customer screening rule;
and obtaining points through the rule engine and the online library to calculate all needed point rules.
7. The method according to claim 5, wherein the calculating the integral according to the selected data range and a calculation formula included in the integral calculation rule matched from the rule engine, and obtaining the integral calculation result specifically includes:
calculating a basic integral according to the basic integral rule;
calculating an award point rule corresponding to a single transaction according to the point award activity rule;
calculating an award point rule corresponding to accumulated transaction according to the point award activity rule;
obtaining an integral calculation original value;
and determining a final integral calculation result according to the integral calculation original value, the accumulated integral value and an integral upper limit determined by the verification rule for verifying the integral capping value.
8. A universal points account management system, comprising:
a setting module for setting an activity rule associated with the score;
the access module is used for accessing each component to obtain the transaction flow of each component;
the calculation module is used for carrying out point calculation on the transaction flow of the assembly according to the rule engine to generate a point result file; wherein a portion of the activity rules associated with points are configured in the rules engine;
and the reconciliation module is used for reconciling the corresponding account according to the account type and the account serial number in the point result file.
9. A computer-readable storage medium, on which a computer program is stored, which program, when being executed by a processor, carries out a method of universal points account management according to any one of claims 1 to 7.
10. A computer device, comprising:
one or more processors;
storage means for storing one or more programs;
the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the universal points account management method of any of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011044668.8A CN112085488A (en) | 2020-09-28 | 2020-09-28 | General point account management method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011044668.8A CN112085488A (en) | 2020-09-28 | 2020-09-28 | General point account management method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112085488A true CN112085488A (en) | 2020-12-15 |
Family
ID=73739926
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011044668.8A Pending CN112085488A (en) | 2020-09-28 | 2020-09-28 | General point account management method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112085488A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112883313A (en) * | 2021-02-24 | 2021-06-01 | 上海浦东发展银行股份有限公司 | Intelligent monitoring system for business data of credit card |
| CN113947446A (en) * | 2021-12-21 | 2022-01-18 | 深圳前海移联科技有限公司 | Member point accumulating and consuming method, member point accumulating and consuming device, computer equipment and storage medium |
| CN115311028A (en) * | 2022-10-12 | 2022-11-08 | 神州数码融信云技术服务有限公司 | Data processing method and device, computer equipment and computer readable storage medium |
| CN116308522A (en) * | 2023-03-03 | 2023-06-23 | 深圳市优讯信息技术有限公司 | Realization method and system for rapidly calculating integral |
| TWI825411B (en) * | 2021-04-29 | 2023-12-11 | 中華電信股份有限公司 | Preferential processing system and method and computer readable medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105843959A (en) * | 2016-04-18 | 2016-08-10 | 中国建设银行股份有限公司 | Bonus point calculation method and system based on processing of big data |
| CN106097001A (en) * | 2016-06-07 | 2016-11-09 | 中国建设银行股份有限公司 | Integration data treating method and apparatus |
| CN108564413A (en) * | 2018-04-23 | 2018-09-21 | 深圳市超智慧信息科技有限公司 | Integration managing method, equipment and computer readable storage medium |
| CN111369302A (en) * | 2020-03-17 | 2020-07-03 | 中国邮政储蓄银行股份有限公司 | Method, system and computer readable storage medium for generating points in real time |
| CN111611612A (en) * | 2020-04-28 | 2020-09-01 | 广州华工中云信息技术有限公司 | Block chain-based integrating system, device, storage medium and operation method thereof |
-
2020
- 2020-09-28 CN CN202011044668.8A patent/CN112085488A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105843959A (en) * | 2016-04-18 | 2016-08-10 | 中国建设银行股份有限公司 | Bonus point calculation method and system based on processing of big data |
| CN106097001A (en) * | 2016-06-07 | 2016-11-09 | 中国建设银行股份有限公司 | Integration data treating method and apparatus |
| CN108564413A (en) * | 2018-04-23 | 2018-09-21 | 深圳市超智慧信息科技有限公司 | Integration managing method, equipment and computer readable storage medium |
| CN111369302A (en) * | 2020-03-17 | 2020-07-03 | 中国邮政储蓄银行股份有限公司 | Method, system and computer readable storage medium for generating points in real time |
| CN111611612A (en) * | 2020-04-28 | 2020-09-01 | 广州华工中云信息技术有限公司 | Block chain-based integrating system, device, storage medium and operation method thereof |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112883313A (en) * | 2021-02-24 | 2021-06-01 | 上海浦东发展银行股份有限公司 | Intelligent monitoring system for business data of credit card |
| TWI825411B (en) * | 2021-04-29 | 2023-12-11 | 中華電信股份有限公司 | Preferential processing system and method and computer readable medium |
| CN113947446A (en) * | 2021-12-21 | 2022-01-18 | 深圳前海移联科技有限公司 | Member point accumulating and consuming method, member point accumulating and consuming device, computer equipment and storage medium |
| CN115311028A (en) * | 2022-10-12 | 2022-11-08 | 神州数码融信云技术服务有限公司 | Data processing method and device, computer equipment and computer readable storage medium |
| CN116308522A (en) * | 2023-03-03 | 2023-06-23 | 深圳市优讯信息技术有限公司 | Realization method and system for rapidly calculating integral |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112085488A (en) | General point account management method and system | |
| US11100435B2 (en) | Machine learning artificial intelligence system for predicting hours of operation | |
| CN111699486B (en) | Accounting method, accounting system, account system and payment system | |
| US7092905B2 (en) | Systems and methods for the processing of financial transactions | |
| WO2021169659A1 (en) | Resource information pushing method and device, server, and storage medium | |
| CN112686746A (en) | Credit flow configuration method, device and equipment | |
| CN110727857A (en) | Method and device for identifying key features of potential users aiming at business objects | |
| CN110807643A (en) | User trust evaluation method, device and equipment | |
| CN112232950A (en) | Loan risk assessment method and device, equipment and computer-readable storage medium | |
| CN112925664A (en) | Target user determination method and device, electronic equipment and storage medium | |
| CN115545886A (en) | Overdue risk identification method, overdue risk identification device, overdue risk identification equipment and storage medium | |
| KR101927578B1 (en) | System for providing enterprise information and method | |
| CN110852809A (en) | Data processing method, device, equipment and medium | |
| CN112035681B (en) | Method and device for determining credit card rate information based on knowledge graph | |
| Nwosu et al. | Is there discrimination against women entrepreneurs in formal credit markets in Nigeria? | |
| CN111095328A (en) | System and method for detecting and responding to transaction patterns | |
| US10664742B1 (en) | Systems and methods for training and executing a recurrent neural network to determine resolutions | |
| CN117094764A (en) | Bank integral processing method and device | |
| US10235719B2 (en) | Centralized GAAP approach for multidimensional accounting to reduce data volume and data reconciliation processing costs | |
| US20170148098A1 (en) | Data creating, sourcing, and agregating real estate tool | |
| CN112907361A (en) | Method and device for processing loan application | |
| CN112348657A (en) | Method and device for determining target credit user, computer equipment and storage medium | |
| CN111935363A (en) | Call routing method and system | |
| CN116151948A (en) | Novel bill black intermediary identification method and system | |
| CN113342855B (en) | Data matching method and device based on big data |
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 |