CN110489438A - A kind of customer action information processing method and device - Google Patents
A kind of customer action information processing method and device Download PDFInfo
- Publication number
- CN110489438A CN110489438A CN201910794974.4A CN201910794974A CN110489438A CN 110489438 A CN110489438 A CN 110489438A CN 201910794974 A CN201910794974 A CN 201910794974A CN 110489438 A CN110489438 A CN 110489438A
- Authority
- CN
- China
- Prior art keywords
- field
- customer
- customer action
- information
- behavior
- 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
- 230000010365 information processing Effects 0.000 title claims abstract description 30
- 238000003672 processing method Methods 0.000 title claims abstract description 16
- 230000000694 effects Effects 0.000 claims abstract description 30
- 230000006399 behavior Effects 0.000 claims description 79
- 230000003542 behavioural effect Effects 0.000 claims description 59
- 238000007689 inspection Methods 0.000 claims description 18
- 239000000284 extract Substances 0.000 claims description 14
- 238000004590 computer program Methods 0.000 claims description 7
- 238000003860 storage Methods 0.000 claims description 7
- 230000001052 transient effect Effects 0.000 claims description 6
- 238000004080 punching Methods 0.000 claims description 3
- 238000000034 method Methods 0.000 abstract description 28
- 238000013499 data model Methods 0.000 abstract description 4
- 230000001737 promoting effect Effects 0.000 abstract description 2
- 238000010586 diagram Methods 0.000 description 16
- 238000000605 extraction Methods 0.000 description 9
- 238000012545 processing Methods 0.000 description 7
- 238000005516 engineering process Methods 0.000 description 5
- 230000006870 function Effects 0.000 description 5
- 238000012937 correction Methods 0.000 description 4
- 238000012360 testing method Methods 0.000 description 4
- 238000012546 transfer Methods 0.000 description 4
- 238000012954 risk control Methods 0.000 description 3
- 238000004458 analytical method Methods 0.000 description 2
- 230000015572 biosynthetic process Effects 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 239000000203 mixture Substances 0.000 description 2
- 230000005856 abnormality Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000004140 cleaning Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005304 joining Methods 0.000 description 1
- 230000002085 persistent effect Effects 0.000 description 1
- 238000000926 separation method Methods 0.000 description 1
- 238000012163 sequencing technique Methods 0.000 description 1
- 239000004575 stone Substances 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/18—File system types
- G06F16/1805—Append-only file systems, e.g. using logs or journals to store data
- G06F16/1815—Journaling file systems
-
- 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/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- 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/23—Updating
-
- 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/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/901—Indexing; Data structures therefor; Storage structures
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computer Security & Cryptography (AREA)
- Software Systems (AREA)
- Quality & Reliability (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The embodiment of the invention discloses a kind of customer action information processing method and device, method includes: the customer action information obtained in log, and generates customer action table according to the customer action information;Aiming field is extracted from the customer action table and basic database, and field relation table is generated according to the aiming field;The field in the customer action table is updated according to the field relation table, obtains updated customer action table.The embodiment of the present invention is by generating customer action table and field relation table, and the field in customer action table is updated by field relation table, the integrality and accuracy that can guarantee customer action data, meet the business demand under special scenes, while promoting the air control effect of data model.
Description
Technical field
The present invention relates to field of computer technology, and in particular to a kind of customer action information processing method and device.
Background technique
As Internet technology is in the application development of banking, financial revolution-internet finance of a new round is formd, is moved
The business such as dynamic terminal transaction, Yun Shanfu, online transaction are gradually popularized.While bringing convenience to people's lives, offender
Also become very rampant for bank, the fraud of client and theft infringement crime, customer information leakage, network finance swindle case
It takes place frequently.Great changes, APT (Advanced Persistent Threat, advanced duration also has occurred in security threat in recent years
Threatening) attack, emerging threats are more and more, and this proposes new challenge to the air control system of bank.Banking system
In behavioral data be the foundation stone for constructing customer action timeline, be that must be taken into consideration in air control system and especially important factor,
Such as comprising logging in a variety of user behaviors logs relevant to customer action information such as behavior, signing behavior, trading activity, a large amount of wind
The dangerous factor is characterized in what the behavioral data based on bank extracted for air control modeling.But under bank's air control scene,
Behavioral data often because artificial, technology or other can not resist factor cause to occur partial data missing, Information abnormity (mistake or
Conflict) and other issues, utilization of the behavioral data under practical bank's air control scene is greatly limited, the air control of model is reduced
Effect.
A kind of method of the prior art is: acquisition pending data first, then according to the attribute of the pending data,
Acquisition and the matched configuration file of the pending data, configuration file includes each step of pretreatment process, then according to institute
Each step for stating pretreatment process obtains the corresponding program of each step respectively, finally executes according to the execution sequence of each step
The corresponding program of each step, realizes the pretreatment to pending data.The data cleansing part of this method is just with difference
Cleaning rule carries out detection identification and violence rejecting abnormalities data, is individually stored in exception table, and there is no to this part exception
Data carry out corresponding corrigendum or processing, reduce the utilization rate of information.Another method is: obtaining first from banking system former
Beginning data extract the need for meeting data demand then according to the data demand information of the insurance company of acquisition from initial data
Data are sought, then according to multiple business demand dimensions of the insurance company of acquisition, corresponding each business is determined from demand data
The business datum of demand dimension finally gives each business data transmission determined to the insurance company.This method
The data in banking system merely only are handled extracting by way of being associated with matching business datum, there is no corresponding
Data cleansing module can not handle the bank's initial data for data quality problem occur, lead to subsequent extraction, association matching etc.
Sequence of operations can not carry out.
In the prior art when data quality problem occurs in customer information part in behavioral data, the subsequent user that can not connect
Complete behavior timeline, analysis and air control modeling to user behavior cause very big influence;To the core words in behavioral data
Duan Wufa does not have effective padding scheme, and in banking system, there are many core fields relevant to customer information, such as visitor
Family number, account and name, often there are certain missings, or even missing customer information in different fields for different banks
Major key;To core field wrong in behavioral data can not or not effective more direction-determining board, for example, being unsatisfactory for call format
The core field relevant to customer information such as identity client number, account or incomplete name;To what is conflicted in behavioral data
Core field can not or not effective more direction-determining board, in banking system, often there is certain pass between core field
Connection relationship, the relationship different from interfield normal association relationship is to conflict, for example, there are one-to-many between customer ID and account
Normal association relationship, i.e. corresponding multiple accounts of same customer ID (same person), but there are multiple customer IDs are (multiple
People) a corresponding account conflict.Therefore, the prior art is unable to satisfy the business demand under special scenes.
Summary of the invention
Since existing method is there are the above problem, the embodiment of the present invention proposes a kind of customer action information processing method and dress
It sets.
In a first aspect, the embodiment of the present invention proposes a kind of customer action information processing method, comprising:
The customer action information in log is obtained, and customer action table is generated according to the customer action information;
Aiming field is extracted from the customer action table and basic database, and field is generated according to the aiming field
Relation table;
The field in the customer action table is updated according to the field relation table, obtains updated client's row
For table.
Optionally, the customer action information obtained in log, and client's row is generated according to the customer action information
For table, specifically include:
It obtains the signing behavioural information in log, log in behavioural information, trading activity information and behavioural information of transferring accounts, and root
Corresponding signing is generated respectively according to the signing behavioural information, login behavioural information, trading activity information and behavioural information of transferring accounts
Behavior table logs in behavior table, trading activity table and behavior table of transferring accounts.
Optionally, described that aiming field is extracted from the customer action table and basic database, and according to the target
Field generates field relation table, specifically includes:
From the client information table of the customer action table and basic database, deposit card information table and credit card information table
Extract aiming field;
The aiming field combination of two is generated into field relation table.
Optionally, described that the field in the customer action table is updated according to the field relation table, it obtains more
Customer action table after new, specifically includes:
According to the field relation table, the correspondence word that is gradually associated in a manner of flared in the customer action table
Section, and the corresponding field is filled or is corrected, obtain updated customer action table.
Optionally, described that aiming field is extracted from the customer action table and basic database, and according to the target
Field generates after field relation table, further includes:
It carries out non-empty inspection, error checking and conflicting respectively to the field in the field relation table to examine, and right
It is not deleted by the field that non-empty inspection, error checking or conflicting are examined.
Second aspect, the embodiment of the present invention also propose a kind of customer action information processing unit, comprising:
Behavior table generation module, for obtaining the customer action information in log, and it is raw according to the customer action information
At customer action table;
Relation table generation module, for extracting aiming field from the customer action table and basic database, and according to
The aiming field generates field relation table;
Behavior table update module, for being carried out more according to the field relation table to the field in the customer action table
Newly, updated customer action table is obtained.
Optionally, the behavior table generation module is specifically used for:
It obtains the signing behavioural information in log, log in behavioural information, trading activity information and behavioural information of transferring accounts, and root
Corresponding signing is generated respectively according to the signing behavioural information, login behavioural information, trading activity information and behavioural information of transferring accounts
Behavior table logs in behavior table, trading activity table and behavior table of transferring accounts.
Optionally, the relation table generation module is specifically used for:
From the client information table of the customer action table and basic database, deposit card information table and credit card information table
Extract aiming field;
The aiming field combination of two is generated into field relation table.
Optionally, the behavior table update module is specifically used for:
According to the field relation table, the correspondence word that is gradually associated in a manner of flared in the customer action table
Section, and the corresponding field is filled or is corrected, obtain updated customer action table.
Optionally, the customer action information processing unit further include:
Field checking module, for carrying out non-empty inspection, error checking respectively to the field in the field relation table
With conflicting examine, and to do not pass through non-empty examine, error checking or conflicting inspection field delete.
The third aspect, the embodiment of the present invention also propose a kind of electronic equipment, comprising:
At least one processor;And
At least one processor being connect with the processor communication, in which:
The memory is stored with the program instruction that can be executed by the processor, and the processor calls described program to refer to
Order is able to carry out the above method.
Fourth aspect, the embodiment of the present invention also propose a kind of non-transient computer readable storage medium, the non-transient meter
Calculation machine readable storage medium storing program for executing stores computer program, and the computer program makes the computer execute the above method.
As shown from the above technical solution, the embodiment of the present invention is by generating customer action table and field relation table, and passes through
Field relation table is updated the field in customer action table, can guarantee the integrality and accuracy of customer action data,
Meet the business demand under special scenes, while promoting the air control effect of data model.
Detailed description of the invention
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Some embodiments of invention for those of ordinary skill in the art without creative efforts, can be with
Other attached drawings are obtained according to these figures.
Fig. 1 is a kind of flow diagram for customer action information processing method that one embodiment of the invention provides;
Fig. 2 be another embodiment of the present invention provides a kind of customer action information processing method flow diagram;
Fig. 3 be another embodiment of the present invention provides customer action table extraction flow diagram;
Fig. 4 be another embodiment of the present invention provides customer information structural schematic diagram;
Fig. 5 be another embodiment of the present invention provides field relation table extraction flow diagram;
Fig. 6 be another embodiment of the present invention provides data check flow diagram;
Fig. 7 be another embodiment of the present invention provides checker verify data flow diagram;
Fig. 8 be another embodiment of the present invention provides processor it is funneling processing data flow diagram;
Fig. 9 be another embodiment of the present invention provides processor carry out account relating flow diagram;
Figure 10 be another embodiment of the present invention provides processor carry out the associated flow diagram of customer ID;
Figure 11 be another embodiment of the present invention provides processor carry out another associated flow diagram of customer ID;
Figure 12 is a kind of structural schematic diagram for customer action information processing unit that one embodiment of the invention provides;
Figure 13 is the logic diagram for the electronic equipment that one embodiment of the invention provides.
Specific embodiment
With reference to the accompanying drawing, further description of the specific embodiments of the present invention.Following embodiment is only used for more
Technical solution of the present invention is clearly demonstrated, and not intended to limit the protection scope of the present invention.
Fig. 1 shows a kind of flow diagram of customer action information processing method provided in this embodiment, comprising:
Customer action information in S101, acquisition log, and customer action table is generated according to the customer action information.
Wherein, the log is the journal file automatically generated in each operation system.
The customer action information is information relevant to the various operation behaviors of client.
The customer action information includes signing behavioural information, logs in behavioural information, trading activity information and behavior of transferring accounts
Information.
The customer action table is to be counted relevant to the operation behavior of client according to customer action information
Table.
With behavioural information of contracting in the customer action information, login behavioural information, trading activity information and behavior of transferring accounts
Information is corresponding, and the customer action table includes signing behavior table, logs in behavior table, trading activity table and behavior table of transferring accounts.
S102, aiming field is extracted from the customer action table and basic database, and raw according to the aiming field
At field relation table.
Wherein, the basic database includes most available, most accurately client personal information, can be used for improving behavioral data
In client-related information.For example, the basic database of bank includes client information table, deposit card information table, credit card information
The basic informations table such as table.
The aiming field is the core field determined according to different business demand, for example, the customer action information of bank
In aiming field be these three core fields of customer ID relevant to customer information, account and name.
The field relation table is the table determined according to the relationship between each aiming field.
S103, the field in the customer action table is updated according to the field relation table, is obtained updated
Customer action table.
Specifically, according to the relationship between aiming field each in field relation table, to relevant mesh in customer action table
Marking-up section is updated, and can obtain integrity degree and the higher customer action table of accuracy.
The present embodiment passes through field relation table in customer action table by generating customer action table and field relation table
Field be updated, can guarantee the integrality and accuracy of customer action data, meet the business demand under special scenes,
The air control effect of data model is promoted simultaneously.
Further, on the basis of above method embodiment, S102 is specifically included:
From the client information table of the customer action table and basic database, deposit card information table and credit card information table
Extract aiming field;
The aiming field combination of two is generated into field relation table.
S103 is specifically included:
According to the field relation table, the correspondence word that is gradually associated in a manner of flared in the customer action table
Section, and the corresponding field is filled or is corrected, obtain updated customer action table.
After S102, further includes:
S1023, non-empty inspection, error checking and conflicting inspection are carried out respectively to the field in the field relation table
Test, and to do not examined by non-empty, the field that error checking or conflicting are examined is deleted.
Specifically, in bank finance field, the client information table is the table for storing client's essential information, and field includes
Customer ID, account, name, date of birth, gender etc.;Deposit card information table is the information table for storing deposit card, field packet
Include deposit card account, name, open the card date etc.;Credit card information table is the information table for storing credit card, and field includes letter
With card account, name, open the card date etc..
When determining the aiming field is these three core fields of customer ID, account and name, wrapped in field relation table
Include customer ID and account relationship, customer ID and name relationship and account and name relationship.
The present embodiment it is related can to extract customer information based on the basic database and user behaviors log in banking system
Keyword, combination of two constructs relation table, can be used for improving the customer information in behavioral data, independent of network environment or
Person's third party library.For missing, mistake or the data of conflict in behavioral data, examined by non-empty, mistake and conflicting
Relation table, in a manner of funneling ground, gradually associated client behavior table, missing in reversed filling or corrigendum behavioral data, mistake with
The customer information of conflict.
Below by taking the customer action information processing of bank as an example, customer action information processing side provided in this embodiment is introduced
Method.
In bank finance field, air control generally refers to risk control, i.e. risk managers adopt various measures and method, disappears
Go out or reduce risks event generation various possibilities or risk control person reduce risks event occur when caused by loss, will
The damage control in a certain range, to avoid the burdensome loss of bring when risk case occurs, risk control
System includes four kinds of basic skills: risk avertion, the damage control, risk transfer and risk retain.Behavioral data refers in banking
It include a variety of data relevant to customer action information such as login behavior, signing behavior, trading activity in system.Customer ID is each
The different operation system of bank, which has different customer IDs, indicates client identity information, such as customer ID, channel customer number, core
Customer ID etc. is hereafter indicated with customer ID i (i=1,2 ... N).Core field refer in commercial banks' behavior data with customer information
Relevant customer ID, account and name field.
As shown in Fig. 2, illustrating the entire flow of the present embodiment, key step is completed by following four units:
A1, extractor 1 are completed to a variety of and customer action such as login behavior, signing behavior, trading activity in user behaviors log
The extraction of information related data, merging form customer action table.
A2, extractor 2 are associated with basic database in the customer action table generated and bank based on step A1, extract core
Field constructs the relation table between field.
A3, verifier extract the inspection that field in the relation table generated carries out non-empty, mistake and conflicting to step A2
It tests.
A4, processor utilize the relation table after veritifying by step A3, in a manner of flared, gradually associated steps A1
Missing, mistake or the core field of conflict in the customer action table of generation, reversed filling or corrigendum customer action table.
Customer information part is improved using the data of high quality in basic database and user behaviors log, guarantees subsequent energy series connection
The complete behavior timeline of user promotes the effect of air control model;Using the relationship between multilist field, in a manner of flared,
Gradually associated client behavior table, the core field of excalation in reversed filling behavior data, while reducing information Loss Rate,
Guarantee the accuracy of filling data;Meet non-empty, the error resistance core field examined with conflicting, building by extracting simultaneously
Relation table while reducing information noise, is guaranteed using mistake or the core field of conflict in the reversed corrigendum behavioral data of association
The accuracy of more correction data.
Expansion description is carried out to aforementioned four unit below:
A1, extractor 1
The main function of extractor 1 is to extract customer action information, building based on the user behaviors log in banking system
Customer action table.
User behaviors log refers to daily record data relevant to bank client behavioural information, and main includes signing log, login day
Will, transaction log and log of transferring accounts.Wherein signing log recording client applies for that Web bank such as pays, transfers accounts at the functions, handles label
About formality correlation signing behavior;It logs in log recording client and bank APP associated login behavior is logged in by mobile phone or computer;Transaction
The behavior that log recording client and businessman trade;The behavior that the log recording client that transfers accounts transfers accounts with other people.Every kind of row
It include the different behavioural information of client for log, the log record of each bank will be different, but can be from these days
Corresponding data are extracted in will, by taking behavior table of contracting as an example, specific data format is as shown in table 1:
The signing behavior table of table 1
According to the data format of above-mentioned table 1, data are successively extracted from various logs, form various actions table, merge structure
Customer action table is built, the extraction process of extractor 1 is as shown in Figure 3: extraction behavioural information first, according to the data format in table 1
Successively extract behavioural information from log, formation contracts, logs in, paying, four kinds of behavior tables of transferring accounts;Then customer action is constructed
Table specifically merges four kinds of behavior tables of generation, constructs customer action table, partial data is as shown in table 2 below, wherein ai1
Middle i indicates multiple and different customer IDs, i=1,2 ... N, as a11 indicates some data of customer ID 1.
2 portions of client behavior table of table
As can be seen that an every a line i.e. user behavior sequence from upper 2 portions of client behavior table of table, by customer information,
Timestamp and behavioural information triple composition.Wherein there is the field i.e. shortage of data problem of NULL, occurs 1234,123 etc. no
The field for meeting normal format is Problem-Error, a occursi3And ai4Multiple customer IDs (multiple people) are a corresponding d4The pass of account
It is collision problem.There are quality problems in customer information part in behavior table, in the subsequent behavior table that can not be connected according to customer information
All behavioural informations, influence to establish the complete time of the act line of user.So subsequent operation would solve these problems.
A2, extractor 2
The main function of extractor 2 is to extract core words based on the customer action table of table 2 and the basic database of bank
Section constructs relation table, improves customer information for subsequent.
Basic database includes the basic informations tables such as client information table, deposit card information table, credit card information table in bank,
It can be used for extracting most available, most accurately customer information of bank, improve in table 2 missing in customer action table, mistake or conflict
Customer information.Customer information part includes customer ID i, account number field, customer information portion in customer action table in basic database
Divide including customer ID i, account and name field, i=1,2 ... N concrete structure diagrams are shown in Fig. 4.
According to the customer information structure chart of Fig. 4, from extracting critical field in the customer action table of basic database and table 2,
Form field relation table relevant to customer information.The process of extractor 2 is as shown in Figure 5: first extraction keyword, specially from
It is crucial that customer ID i relevant to customer information, account and name are extracted in bank in the customer action table of basic database and table 2
Field;Then association forms field relation table, forms field relation table and is largely divided into two parts:
First part: according to the keyword of extraction, combination of two forms customer ID i-account relation table 1, customer ID i-
Account relation table 2, account-name relation table and customer ID i-customer ID j relation table (i ≠ j);
Second part: according to the field relation table of extraction, association forms customer ID i-account relation table, customer ID two-by-two
I-customer ID j relation table and customer ID i-three kinds of forms of name relation table relation table, for subsequent to objective in 2 behavior table of table
Family message part carries out perfect.
A3, verifier
The main function of verifier is the field relation table extracted based on extractor 2, successively carries out non-empty, mistake and punching
Prominent property is examined, and guarantees the accuracy of customer information in relation table.
The field relation table that extractor 2 extracts is respectively customer ID i-account relation table, customer ID i-customer ID j relationship
Table and customer ID i-name relation table, wherein i ≠ j.Inspection for customer ID i, account and name field in relation table, core
The process for testing device is shown in as shown in Figure 6: progress field null value inspection first, i.e., each word of each row of data in veritification above-mentioned relation table
Whether section (customer ID i, account or name) is NULL or null character string, when each field of the row data is not NULL or empty word
When symbol string, retains the row data, otherwise delete;Then field errors inspection is carried out, that is, is veritified every in each row of data of reservation
Whether a field meets certain call format, mainly go to measure in terms of field length and composed structure two: 1) customer ID i
Length must be at least 18, and require to be made of number or letter;2) length of account must be at least 16, and require by
Number or letter composition;3) length of name is at least 2, and requires to be made of Chinese or English.When each word of the row data
When section meets above-mentioned correspondence and requires, retains the row data, otherwise delete.The inspection of field conflicting is finally carried out, that is, veritifies and retains
Each row of data in the relationship of each interfield whether conflict, wherein the relationship veritified is that the field that extractor 2 extracts is closed
It is table, is respectively present three kinds of normal field relationships: i) customer ID i-account: one-to-many (same person there are multiple accounts),
Ii) customer ID i-customer ID j (i ≠ j): one-to-many, iii) customer ID i-name: (different people has identical surname to many-one
Name).When the relationship of each interfield of the row data, which meets above-mentioned correspondence, to be required, retain the row data, otherwise delete, exports core
Input of the relation table as next module after testing.
Specifically, by taking customer ID i-account relation table that extractor 2 extracts as an example, it is illustrated in figure 7 the veritification of verifier
Process, table a are customer ID i-account relation table to be veritified, and table b is customer ID i-account relation table after non-empty is examined,
Table c is customer ID i-account relation table after error resistance inspection, and table d is customer ID i-account relationship after conflicting is examined
Table, wherein the field outlined is that every step veritifies unacceptable field: 1) NULL field cannot be examined by non-empty in table a;2)
1234 fields cannot pass through error resistance veritification in table b;3) a in table ci3And ai4The relationship punching of the corresponding account of multiple customer IDs
It is prominent to be veritified by conflicting.
A4, processor
The main function of processor is the relation table after being veritified using a upper module, gradually 2 customer action table of contingency table, instead
To filling or correcting customer information part, customer information in behavior table is improved.
Customer information part mainly includes customer ID, account and name field in the customer action table of table 2.In order to improve place
The efficiency for managing device, to the processing of these fields using gradually incidence relation table, the associated sequencing of relation table represent association
The priority of field determines that the relationship of interfield has many-to-one field relationship, such as with missing degree by the relationship between field
Account-customer ID i field relationship is many-one.
By taking the processing of customer ID i in the customer action table of table 2 as an example, illustrate the order determination side of relation table associate field
Method:
B1, associate field is determined.Since account, customer ID j (j ≠ i) are respectively many-one, institute with the relationship of customer ID i
There is uniqueness with customer ID i, belong to the major key of customer information, it can fill or correct by associated account number, customer ID j
Customer ID i.
B2, association order is determined.Account, miss rate=missing of customer ID j field in 2 customer action table of statistical form respectively
Number/data count;Associate field is ranked up by miss rate;Account miss rate is lower than customer ID j in ranking results, so closing
The priority for joining table associate field is account > customer ID j.
According to the order determining method of above-mentioned relation table associate field, processor successively funneling 2 customer action of processing table
Customer ID i, account and name in table.Wherein funneling mode refers mainly to rely on associate field, the upper module output of successively association
Relation table, by taking customer ID i as an example, as shown in Figure 8: by account relating customer ID i-account relation table, handle customer ID i,
Filter out the data of a large amount of processed customer ID i in customer action table;Data untreated for remaining small part, continue through
Customer ID j associated client i-customer ID j relation table handles customer ID i.
For the disposed of in its entirety process of customer ID i, account and name field in 2 customer action table of table are as follows: progress account first
Number association, reversed filling and corrigendum utilize the client in customer ID i-account relation table that is, by associate field account relating
Number i reversely fills or corrects the customer ID i of part to be processed in customer action table, the customer action table 1 that forms that treated;Then
Customer ID j (j ≠ i) association is carried out, reversed filling and corrigendum, the part are broadly divided into two steps:
1) relation table is updated.Customer ID i in processed customer action table 1-customer ID j (i ≠ j) relation table 1 is extracted,
It is merged with customer ID i-customer ID j (i ≠ j) relation table after being veritified by a upper module, forms customer ID i-client
Number j (i ≠ j) relation table 2, further improves information in relation table.
2) reversed filling and corrigendum.It is associated with by associate field customer ID j, is closed using customer ID i-customer ID j (i ≠ j)
It is the customer ID i in customer ID i in table 2 customer action table 1 of reversely filling or correct in step 1) that treated, formation processing
Customer action table 2 afterwards.
Customer ID i association is finally carried out, reversed filling and corrigendum, the part are also broadly divided into two steps:
1) relation table is updated.Customer action table 1 and 2 after merging treatment, forms treated customer action table 3, then from
Customer ID i-name relation table 1 is extracted in treated customer action table 3, and passes through the customer ID i-after a upper module is veritified
Name relation table merges, and forms customer ID i-name relation table 2, further improves information in relation table.
2) reversed filling and corrigendum.By the association of associate field customer ID i, using in customer ID i-name relation table 2
Name customer action table 3 of reversely filling or correct in step 3.1) that treated in name, form processed client
Behavior table, the output as processor.
Specifically, it when processor handles customer action information, may comprise steps of:
C1, in account relating, as shown in figure 9, table a is part to be processed in 2 customer action table of table, including customer ID i
(i=1,2 ... N), account and name field, are respectively present missing, mistake or collision problem, and table b is that the veritification of a upper module passes through
Customer ID i-account relation table.By associate field account relating, using in table b customer ID filling or correction sheet a in visitor
Family number generates treated customer action table c, solves the problems, such as that customer ID i is the field null value and a of NULLi3、ai4Multiple visitors
The corresponding same account d in family number (multiple people)4Conflict of relationships problem.
C2, the associated flow chart of customer ID j (j ≠ i) as shown in Figure 10, table e are that a upper module veritifies the client passed through
Number i-customer ID j relation table.Customer ID i-customer ID j table d is extracted from table c, is merged with table e and is generated customer ID i-
Customer ID j relation table f.By associate field customer ID j be associated with, using in table f customer ID filling or correction sheet c in client
Number, treated customer action table g is generated, solves the problems, such as that customer ID i is 1234 field errors.
C3, the associated flow chart of customer ID i (i=1,2,3) as shown in figure 11.The upper module veritification of table i passes through
Customer ID i-name relation table.Customer ID i-name relation table h is extracted from table g, merges generation customer ID with table i
I-name relation table j.Be associated with by associate field customer ID i, using in table j name filling or correction sheet g in name, it is raw
It at processed customer action table k, solves field null value and Problem-Error that name is NULL and 123, completes to 2 visitor of table
Customer information is perfect in family behavior table, the output as processor module.
Processing by processor module to problem in 2 customer action table of table, so that customer information improves, it is such as above-mentioned
Table k in example especially solves the data matter of the major key customer ID i (because the field has unique identification) of customer information
Amount problem, guarantees every kind of behavioural information of each client in the subsequent behavior table that can connect by client's major key, and building is complete
User behavior-timeline, help to carry out analysis based on this and further promote the effect of air control modeling.
The present embodiment extracts the keyword in banking system with high quality customer information, and building customer information is related
Relation table, improve customer information in behavioral data as subsequent and use, substantially increase customer information in air control modeling
Validity and availability, while the basic database inside Construction Bank and user behaviors log are only used, do not depend on network environment or third
Fang Ku has versatility, for other bank references or reference;Simultaneously in a manner of flared, gradually it is associated with using relation table
Missing, mistake or the customer information of conflict in customer action table, reversed filling or corrigendum behavioral data, reduce customer information
Miss rate also improves accuracy, is conducive to the subsequent complete behavior timeline of series connection client, promotes the effect of air control system.
Figure 12 shows a kind of structural schematic diagram of customer action information processing unit provided in this embodiment, described device
It include: behavior table generation module 1201, relation table generation module 1202 and behavior table update module 1203, in which:
The behavior table generation module 1201 is used to obtain the customer action information in log, and according to the customer action
Information generates customer action table;
The relation table generation module 1202 is used to extract aiming field from the customer action table and basic database,
And field relation table is generated according to the aiming field;
The behavior table update module 1203 is used for according to the field relation table to the field in the customer action table
It is updated, obtains updated customer action table.
Specifically, the behavior table generation module 1201 obtains the customer action information in log, and according to the client
Behavioural information generates customer action table;The relation table generation module 1202 is mentioned from the customer action table and basic database
Aiming field is taken, and field relation table is generated according to the aiming field;The behavior table update module 1203 is according to the word
Section relation table is updated the field in the customer action table, obtains updated customer action table.
The present embodiment passes through field relation table in customer action table by generating customer action table and field relation table
Field be updated, can guarantee the integrality and accuracy of customer action data, meet the business demand under special scenes,
The air control effect of data model is promoted simultaneously.
Further, on the basis of above-mentioned apparatus embodiment, the behavior table generation module 1201 is specifically used for:
It obtains the signing behavioural information in log, log in behavioural information, trading activity information and behavioural information of transferring accounts, and root
Corresponding signing is generated respectively according to the signing behavioural information, login behavioural information, trading activity information and behavioural information of transferring accounts
Behavior table logs in behavior table, trading activity table and behavior table of transferring accounts.
Further, on the basis of above-mentioned apparatus embodiment, the relation table generation module 1202 is specifically used for:
From the client information table of the customer action table and basic database, deposit card information table and credit card information table
Extract aiming field;
The aiming field combination of two is generated into field relation table.
Further, on the basis of above-mentioned apparatus embodiment, the behavior table update module 1203 is specifically used for:
According to the field relation table, the correspondence word that is gradually associated in a manner of flared in the customer action table
Section, and the corresponding field is filled or is corrected, obtain updated customer action table.
Further, on the basis of above-mentioned apparatus embodiment, the customer action information processing unit further include:
Field checking module, for carrying out non-empty inspection, error checking respectively to the field in the field relation table
With conflicting examine, and to do not pass through non-empty examine, error checking or conflicting inspection field delete.
Customer action information processing unit described in the present embodiment can be used for executing above method embodiment, principle and
Technical effect is similar, and details are not described herein again.
Referring to Fig.1 3, the electronic equipment, comprising: processor (processor) 1301,1302 He of memory (memory)
Bus 1303;
Wherein,
The processor 1301 and memory 1302 complete mutual communication by the bus 1303;
The processor 1301 is used to call the program instruction in the memory 1302, is implemented with executing above-mentioned each method
Method provided by example.
The present embodiment discloses a kind of computer program product, and the computer program product includes being stored in non-transient calculating
Computer program on machine readable storage medium storing program for executing, the computer program include program instruction, when described program instruction is calculated
When machine executes, computer is able to carry out method provided by above-mentioned each method embodiment.
The present embodiment provides a kind of non-transient computer readable storage medium, the non-transient computer readable storage medium
Computer instruction is stored, the computer instruction makes the computer execute method provided by above-mentioned each method embodiment.
The apparatus embodiments described above are merely exemplary, wherein described, unit can as illustrated by the separation member
It is physically separated with being or may not be, component shown as a unit may or may not be physics list
Member, it can it is in one place, or may be distributed over multiple network units.It can be selected according to the actual needs
In some or all of the modules achieve the purpose of the solution of this embodiment.Those of ordinary skill in the art are not paying creativeness
Labour in the case where, it can understand and implement.
Through the above description of the embodiments, those skilled in the art can be understood that each embodiment can
It realizes by means of software and necessary general hardware platform, naturally it is also possible to pass through hardware.Based on this understanding, on
Stating technical solution, substantially the part that contributes to existing technology can be embodied in the form of software products in other words, should
Computer software product may be stored in a computer readable storage medium, such as ROM/RAM, magnetic disk, CD, including several fingers
It enables and using so that a computer equipment (can be personal computer, server or the network equipment etc.) executes each implementation
Method described in certain parts of example or embodiment.
It is noted that the above embodiments are merely illustrative of the technical solutions of the present invention, rather than its limitations;Although reference
Invention is explained in detail for previous embodiment, those skilled in the art should understand that: it still can be right
Technical solution documented by foregoing embodiments is modified or equivalent replacement of some of the technical features;And this
It modifies or replaces, the spirit and model of technical solution of various embodiments of the present invention that it does not separate the essence of the corresponding technical solution
It encloses.
Claims (12)
1. a kind of customer action information processing method characterized by comprising
The customer action information in log is obtained, and customer action table is generated according to the customer action information;
Aiming field is extracted from the customer action table and basic database, and field relationship is generated according to the aiming field
Table;
The field in the customer action table is updated according to the field relation table, obtains updated customer action
Table.
2. customer action information processing method according to claim 1, which is characterized in that the client obtained in log
Behavioural information, and customer action table is generated according to the customer action information, it specifically includes:
It obtains the signing behavioural information in log, log in behavioural information, trading activity information and behavioural information of transferring accounts, and according to institute
It states signing behavioural information, login behavioural information, trading activity information and behavioural information of transferring accounts and generates corresponding signing behavior respectively
Table logs in behavior table, trading activity table and behavior table of transferring accounts.
3. customer action information processing method according to claim 1, which is characterized in that described from the customer action table
With extract aiming field in basic database, and field relation table is generated according to the aiming field, specifically included:
It is extracted from the client information table of the customer action table and basic database, deposit card information table and credit card information table
Aiming field;
The aiming field combination of two is generated into field relation table.
4. customer action information processing method according to claim 1, which is characterized in that described according to the field relationship
Table is updated the field in the customer action table, obtains updated customer action table, specifically includes:
According to the field relation table, the corresponding field being gradually associated in a manner of flared in the customer action table, and
The corresponding field is filled or is corrected, updated customer action table is obtained.
5. customer action information processing method according to claim 1-4, which is characterized in that described from the visitor
It extracts aiming field in family behavior table and basic database, and after generating field relation table according to the aiming field, also wraps
It includes:
Non-empty inspection is carried out respectively to the field in the field relation table, error checking and conflicting are examined, and to not leading to
The field that non-empty inspection, error checking or conflicting are examined is crossed to be deleted.
6. a kind of customer action information processing unit characterized by comprising
Behavior table generation module generates visitor for obtaining the customer action information in log, and according to the customer action information
Family behavior table;
Relation table generation module, for extracting aiming field from the customer action table and basic database, and according to described
Aiming field generates field relation table;
Behavior table update module is obtained for being updated according to the field relation table to the field in the customer action table
To updated customer action table.
7. customer action information processing unit according to claim 6, which is characterized in that the behavior table generation module tool
Body is used for:
It obtains the signing behavioural information in log, log in behavioural information, trading activity information and behavioural information of transferring accounts, and according to institute
It states signing behavioural information, login behavioural information, trading activity information and behavioural information of transferring accounts and generates corresponding signing behavior respectively
Table logs in behavior table, trading activity table and behavior table of transferring accounts.
8. customer action information processing unit according to claim 6, which is characterized in that the relation table generation module tool
Body is used for:
It is extracted from the client information table of the customer action table and basic database, deposit card information table and credit card information table
Aiming field;
The aiming field combination of two is generated into field relation table.
9. customer action information processing unit according to claim 6, which is characterized in that the behavior table update module tool
Body is used for:
According to the field relation table, the corresponding field being gradually associated in a manner of flared in the customer action table, and
The corresponding field is filled or is corrected, updated customer action table is obtained.
10. according to the described in any item customer action information processing units of claim 6-9, which is characterized in that client's row
For information processing unit further include:
Field checking module, for carrying out non-empty inspection, error checking and punching respectively to the field in the field relation table
Prominent property is examined, and non-empty is examined, the field of error checking or conflicting inspection is deleted to not passing through.
11. a kind of electronic equipment including memory, processor and stores the calculating that can be run on a memory and on a processor
Machine program, which is characterized in that the processor realizes client's row as claimed in claim 1 to 5 when executing described program
For information processing method.
12. a kind of non-transient computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer
Customer action information processing method as claimed in claim 1 to 5 is realized when program is executed by processor.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910794974.4A CN110489438A (en) | 2019-08-27 | 2019-08-27 | A kind of customer action information processing method and device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910794974.4A CN110489438A (en) | 2019-08-27 | 2019-08-27 | A kind of customer action information processing method and device |
Publications (1)
Publication Number | Publication Date |
---|---|
CN110489438A true CN110489438A (en) | 2019-11-22 |
Family
ID=68554394
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910794974.4A Pending CN110489438A (en) | 2019-08-27 | 2019-08-27 | A kind of customer action information processing method and device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110489438A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2022148302A1 (en) * | 2021-01-07 | 2022-07-14 | 苏州浪潮智能科技有限公司 | Information exchange method, system and device, and computer-readable storage medium |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2006010737A2 (en) * | 2004-07-30 | 2006-02-02 | Hewlett-Packard Development Company, L.P. | Methods, apparatus and software for validating entries made on a form |
CN107016548A (en) * | 2016-12-09 | 2017-08-04 | 阿里巴巴集团控股有限公司 | Client, information processing method and reading/writing method and device |
CN108255819A (en) * | 2016-12-27 | 2018-07-06 | 航天信息股份有限公司 | A kind of value-added tax data integration method and system based on analysis tool SPARK |
CN109634827A (en) * | 2018-12-12 | 2019-04-16 | 北京字节跳动网络技术有限公司 | Method and apparatus for generating information |
-
2019
- 2019-08-27 CN CN201910794974.4A patent/CN110489438A/en active Pending
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2006010737A2 (en) * | 2004-07-30 | 2006-02-02 | Hewlett-Packard Development Company, L.P. | Methods, apparatus and software for validating entries made on a form |
CN107016548A (en) * | 2016-12-09 | 2017-08-04 | 阿里巴巴集团控股有限公司 | Client, information processing method and reading/writing method and device |
CN108255819A (en) * | 2016-12-27 | 2018-07-06 | 航天信息股份有限公司 | A kind of value-added tax data integration method and system based on analysis tool SPARK |
CN109634827A (en) * | 2018-12-12 | 2019-04-16 | 北京字节跳动网络技术有限公司 | Method and apparatus for generating information |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2022148302A1 (en) * | 2021-01-07 | 2022-07-14 | 苏州浪潮智能科技有限公司 | Information exchange method, system and device, and computer-readable storage medium |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109242681B (en) | Asset data storage method, device, equipment and system | |
CN110717816A (en) | Artificial intelligence technology-based global financial risk knowledge graph construction method | |
WO2017106600A1 (en) | Analysis of transaction information using graphs | |
CN111145010A (en) | Credit granting and financing method and device | |
CN103605703A (en) | Method and system for data consistency detection among multiple platforms | |
CN110503564B (en) | Security case processing method, system, equipment and storage medium based on big data | |
CN107784075B (en) | Data processing method, device and computer equipment based on connected transaction | |
CN111833182B (en) | Method and device for identifying risk object | |
CN111179089B (en) | Money laundering transaction identification method, device and equipment | |
CN109600724A (en) | A kind of method and apparatus that short message is sent | |
CN111708897A (en) | Target information determination method, device and equipment | |
CN110009497B (en) | Block chain-based decision method and device and electronic equipment | |
CN113888278A (en) | Data analysis method and device based on enterprise credit line analysis model | |
CN113034275B (en) | Management system and method based on block chain network and terminal equipment | |
CN110489438A (en) | A kind of customer action information processing method and device | |
CN114185935A (en) | Social security data processing method and device combining RPA and AI and storage medium | |
CN108009916A (en) | A kind of method and system of the universal payment book keeping operation based on affairs dynamic adjustment | |
CN110619564B (en) | Anti-fraud feature generation method and device | |
CN114546872B (en) | Certificate management testing method and device, computer equipment and storage medium | |
CN110555589A (en) | Risk order identification method and device | |
CN111797590B (en) | Data checking method, device and equipment | |
CN109324963A (en) | The method and terminal device of automatic test profitable result | |
CN113344581A (en) | Service data processing method and device | |
CN113177840A (en) | Client risk identification method and device | |
CN112598428A (en) | Transaction data processing method and device, computer equipment and storage medium |
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 | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20191122 |
|
RJ01 | Rejection of invention patent application after publication |