CN106934509A - Customer information merging method and system - Google Patents
Customer information merging method and system Download PDFInfo
- Publication number
- CN106934509A CN106934509A CN201511022215.4A CN201511022215A CN106934509A CN 106934509 A CN106934509 A CN 106934509A CN 201511022215 A CN201511022215 A CN 201511022215A CN 106934509 A CN106934509 A CN 106934509A
- Authority
- CN
- China
- Prior art keywords
- customer
- user logging
- client
- essential information
- type
- 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
- 238000000034 method Methods 0.000 title claims abstract description 23
- 238000012216 screening Methods 0.000 claims description 15
- 230000008520 organization Effects 0.000 claims description 8
- 238000001914 filtration Methods 0.000 claims description 2
- 238000000605 extraction Methods 0.000 claims 1
- 239000000284 extract Substances 0.000 description 8
- 230000001788 irregular Effects 0.000 description 4
- 239000002699 waste material Substances 0.000 description 3
- 235000013399 edible fruits Nutrition 0.000 description 1
- 230000003442 weekly effect Effects 0.000 description 1
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
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
-
- 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/24—Querying
- G06F16/245—Query processing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Operations Research (AREA)
- Educational Administration (AREA)
- General Business, Economics & Management (AREA)
- Tourism & Hospitality (AREA)
- Development Economics (AREA)
- Computational Linguistics (AREA)
- Quality & Reliability (AREA)
- Game Theory and Decision Science (AREA)
- Marketing (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of customer information merging method, methods described includes：Irregularly customer table is scanned, read the customer type in the customer table, according to corresponding client's essential information in the customer type lookup customer table, client's essential information identical user logging is filtered out, the user logging that will be filtered out is recorded as waiting task；The waiting task is extracted, client's essential information identical user logging is merged according to the default rule that merges.Using the method, storage resource can be reduced and wasted and system platform operational efficiency can be improved.Additionally, additionally providing a kind of customer information combination system.
Description
Technical field
The present invention relates to field of computer technology, more particularly to a kind of customer information merging method and system.
Background technology
In some system platforms for needing managing customer information, it usually needs business personnel or operator pass through
System platform sets up customer profile and customer information is entered into system platform.For example, banking system platform
Need to set up customer profile and typing customer information after client opens an account, and for example, insurance system platform is in client
It is also required to set up customer profile and typing customer information after buying class insurance.
However, in conventional art, often because business personnel or operator's typing it is lack of standardization, can cause same
There is two or more customer profile in system platform in one client.Due to a system platform
The middle customer profile that can there are a large amount of clients, the situation of this Data duplication can cause additionally to take memory space,
The operational efficiency of system platform can be also influenceed simultaneously.
The content of the invention
Based on this, it is necessary to for above-mentioned technical problem, there is provided one kind can reduce storage resource and waste and can carry
The customer information merging method and system of system platform operational efficiency high.
A kind of customer information merging method, methods described includes：
Irregularly customer table is scanned, the customer type in the customer table is read, according to the client
Corresponding client's essential information in customer table described in type search, filters out client essential information identical client
Record, the user logging that will be filtered out is recorded as waiting task；
The waiting task is extracted, according to the default rule that merges by client's essential information identical user logging
Merge.
Wherein in one embodiment, the customer type includes individual client and corporate customer；Work as customer class
When type is individual client, according to customer type search corresponding client's essential information include customer name,
ID card No., type of credential, date of birth and sex；
When customer type is corporate customer, according to corresponding client's essential information that customer type is searched
Including organization mechanism code, industrial and commercial registration number and the tax registration number.
It is described to merge regular by client essential information identical client according to default wherein in one embodiment
The step of record is merged, including：
Client's essential information identical user logging is merged into a user logging, the client after merging
One customer ID of correspondence in record；
Wherein, if the respective field of customer information has content in a user logging, retaining should
Content described in bar user logging in respective field；
If the respective field of customer information has content in a plurality of user logging, latest update is extracted
User logging in the respective field in content.
It is described to merge regular by client essential information identical client according to default wherein in one embodiment
The step of record is merged, also includes：
A customer ID in client's essential information identical user logging is randomly selected, as merging
The customer ID of the user logging afterwards；Or
The earliest customer ID of creation time in client's essential information identical user logging is chosen, as
The customer ID of the user logging after merging.
Wherein in one embodiment, corresponding visitor in the lookup customer table according to the customer type
Family essential information, filters out client's essential information identical user logging, the user logging record that will be filtered out
The step of for waiting task, including：
If being searched less than corresponding client's essential information in the customer table according to the customer type, obtain
Search the user logging less than client's essential information, the user logging the first customer ID of correspondence, according to obtaining
The user logging for taking obtains father's customer ID with first customer ID with set membership；
The corresponding user logging of father's customer ID is obtained, according to the corresponding client's note of father's customer ID
Record obtains all sub- customer ID with father's customer ID with set membership, in the sub- customer ID
Non- first customer ID be the second customer ID；
The corresponding user logging of second customer ID is read, second customer ID is filtered out corresponding
Client essential information identical client in user logging in user logging corresponding with first customer ID
Record, the user logging that will be filtered out is recorded as waiting task.
A kind of customer information combination system, the system includes：
Screening module, for being irregularly scanned to customer table, reads the customer type in the customer table,
According to corresponding client's essential information in the customer type lookup customer table, filter out client and believe substantially
Breath identical user logging, the user logging that will be filtered out is recorded as waiting task；
Merging module, for extracting the waiting task, according to the default rule that merges by client's essential information
Identical user logging is merged.
Wherein in one embodiment, the customer type includes individual client and corporate customer；The screening
Module is used for when customer type is individual client, basic according to the corresponding client that customer type is searched
Information includes customer name, ID card No., type of credential, date of birth and sex；When customer type is
During corporate customer, according to customer type search corresponding client's essential information include organization mechanism code,
Industrial and commercial registration number and the tax registration number.
Wherein in one embodiment, the merging module is used for client's essential information identical client
Record is merged into a user logging, one customer ID of correspondence in the user logging after merging；Wherein, such as
The respective field of fruit customer information has content in a user logging, then in retaining this user logging
Content in the respective field；If in the respective field of customer information has in a plurality of user logging
Hold, then extract the content in the respective field in the user logging of latest update.
Wherein in one embodiment, the merging module is identical for randomly selecting client's essential information
User logging in a customer ID, as the customer ID of the user logging after merging；Or
Creation time is earliest during the merging module is used to choose client's essential information identical user logging
Customer ID, as the customer ID of the user logging after merging.
Wherein in one embodiment, the screening module includes：
First relation chain acquisition module, if for being searched less than phase in the customer table according to the customer type
The client's essential information answered, then obtain the user logging searched less than client's essential information, the user logging
The first customer ID of correspondence, being obtained according to the user logging for obtaining with first customer ID there is father and son to close
Father's customer ID of system；
Second relation chain acquisition module, for obtaining the corresponding user logging of father's customer ID, according to institute
State the corresponding user logging of father's customer ID and obtain all son visitors that there is set membership with father's customer ID
Family identifies, and non-first customer ID in the sub- customer ID is the second customer ID；
First screening module, for reading the corresponding user logging of second customer ID, filters out described
Client in the corresponding user logging of second customer ID in user logging corresponding with first customer ID
Essential information identical user logging, the user logging that will be filtered out is recorded as waiting task.
Above-mentioned customer information merging method and system, are scanned by irregular to customer table, read visitor
Customer type in the table of family, according to corresponding client's essential information in customer type lookup customer table, filters out
Client's essential information identical user logging, the user logging that will be filtered out is recorded as waiting task, extracts
Waiting task, merges client's essential information identical user logging according to the default rule that merges.This
Sample, can merge the user logging of the same client of correspondence, reduce the waste of storage resource and can carry
System platform operational efficiency high.
Brief description of the drawings
Fig. 1 is the flow chart of customer information merging method in one embodiment；
Fig. 2 is the flow chart of customer information merging method in another embodiment；
Fig. 3 is the structured flowchart of customer information combination system in one embodiment；
Fig. 4 is the structured flowchart of screening module in one embodiment.
Specific embodiment
In order to make the purpose , technical scheme and advantage of the present invention be clearer, below in conjunction with accompanying drawing and reality
Example is applied, the present invention will be described in further detail.It should be appreciated that specific embodiment described herein is only
Only it is used to explain the present invention, is not intended to limit the present invention.
As shown in figure 1, in one embodiment, there is provided a kind of customer information merging method, including：
Step 102, is irregularly scanned to customer table, the customer type in customer table is read, according to client
Corresponding client's essential information in type search customer table, filters out client's essential information identical user logging,
The user logging that will be filtered out is recorded as waiting task.
There is substantial amounts of customer table in the present embodiment, in system platform, at least one customer table constitutes a visitor
Family records, each user logging unique customer ID of correspondence.Customer information is have recorded in customer table, is wrapped
Include customer name, customer type, client's essential information (as type of credential, ID card No., the age,
The essential informations such as location, contact method) and the information relevant with business etc..Such as, insurance business system is put down
In platform, the client for buying insurance has corresponding user logging, each in insurance business system platform
To that should have unique customer ID, the customer information recorded in customer table includes customer name, visitor for user logging
Family type, client's essential information, purchase insurance type, insurance amount etc..
Specifically, irregular be scanned to customer table, the corresponding client's note of each customer ID is obtained
Record.For example, can daily, weekly or every month it is irregular customer table is scanned, or connecing
Customer table is scanned after the operational order for receiving administrator.Further, in reading customer table
Customer type, different customer type can get different client's essential informations.Here customer type bag
Include but be not limited to individual client, corporate users etc..Wherein, corporate users refer to be recorded in units of group
Client, such as, with the name purchase insurance business of business unit.
Further, client's essential information identical user logging is filtered out, for a plurality of user logging, such as
Client's essential information really therein is identical, then show that this plurality of user logging is likely to the client of same client
Record, it should which a user logging is merged into this plurality of user logging.Specifically, the visitor that will can be filtered out
Family is recorded as waiting task.
Step 104, extracts waiting task, according to the default rule that merges by client essential information identical client
Record is merged.
In the present embodiment, waiting task is extracted at default time point, according to the default rule that merges by client
Essential information identical user logging is merged into a user logging, the user logging one customer ID of correspondence.
Specifically, a plurality of user logging is merged into a record, the field in customer table can keep constant and retain
Content in field.
In the present embodiment, customer table is scanned by irregular, reads the customer type in customer table,
According to corresponding client's essential information in customer type lookup customer table, client's essential information identical is filtered out
User logging, the user logging that will be filtered out is recorded as waiting task, waiting task is extracted, according to pre-
If merging rule to merge client's essential information identical user logging.In such manner, it is possible to will be corresponding same
The user logging of client is merged, and is reduced the waste of storage resource and can be improved system platform operational efficiency.
Further, since the amount of the customer table stored in a system platform is than larger, therefore scanning process will compare
It is relatively time consuming, it is less by the request amount that to client's table scan, can irregularly select to receive in system platform
Period customer table is scanned, the data record that obtains of scanning is waiting task, in addition at certain
Between put extract waiting task merge treatment.This asynchronous process mode can improve combined efficiency.
In one embodiment, customer type includes individual client and corporate customer；When customer type is personal
During client, according to customer type search corresponding client's essential information include customer name, ID card No.,
Type of credential, date of birth and sex；When customer type is corporate customer, searched according to customer type
Corresponding client's essential information includes organization mechanism code, industrial and commercial registration number and the tax registration number.
Under normal circumstances, for individual client, when customer name, ID card No., type of credential, birth
In the case of date and sex are the same from, it is believed that be same client possibility it is very big.If specifically,
Customer type in customer table is read for individual client, then obtains the interior of corresponding these fields in customer table
Hold, so as to filter out these client's essential information identical user loggings.In other embodiments, can also increase
Plus client's essential information for using during screening, such as client's essential information may also include customer address, Ke Hulian
It is mode etc., client's essential information is more, then the same client for filtering out is more accurate.
In the present embodiment, client's essential information usually used when being screened for corporate customer is three card information,
Including organization mechanism code, industrial and commercial registration number and the tax registration number.If these client's essential informations are identical,
Then it is considered that the possibility of same group is very big.Further, when customer type is corporate customer according to
Corresponding client's essential information that customer type is searched may also include the unified credit code of society.
Further, in one embodiment, waiting task is also can extract, customer type therein is obtained
It is the waiting task of corporate customer, the interface display customer type provided by system platform is corporate customer
Client's essential information identical user logging.Administrator can be to client's essential information identical of display
User logging merges operation.When system platform receives merging of the administrator to multiple user loggings
During instruction, then the multiple user loggings for selecting are merged.In the present embodiment, realized for corporate customer
Manual intervention, improves the accuracy of customer information merging.
In one embodiment, client's essential information identical user logging is carried out according to the default rule that merges
The step of merging, including：Client's essential information identical user logging is merged into a user logging, is closed
And after user logging correspondence one ID；Wherein, if the respective field of customer information is in a visitor
There is content in the record of family, then retain the content in respective field in this user logging；If customer information
Respective field has content in a plurality of user logging, then extract the respective field in the user logging of latest update
In content.
In the present embodiment, for a plurality of user logging with same client essential information for needing to merge, sweep
The all fields in user logging are retouched, for certain field therein, if the field is remembered in this client
There is content in record, and there is no content in other at least one user loggings, then retain the content in the field.
If the field has content in a plurality of user logging, the latest update time of the field contents is obtained, carried
The content in the field of latest update is taken as the content in respective field in the user logging after merging.
Further, in one embodiment, according to the default rule that merges by client's essential information identical visitor
The step of family record is merged, including：Randomly select in client's essential information identical user logging
Individual customer ID, as the customer ID of the user logging after merging；Or, choose client's essential information phase
The earliest customer ID of creation time in same user logging, as the customer ID of the user logging after merging.
In the present embodiment, for needing to be merged into a client a plurality of visitor of essential information identical of user logging
Family records, the unique customer ID of each user logging correspondence, can randomly select one of customer ID
As the corresponding customer ID of user logging after merging.It is further preferred that can choose when wherein creating
Between earliest customer ID as the corresponding customer ID of user logging after merging.
In one embodiment, according to corresponding client's essential information, screening in customer type lookup customer table
Go out client's essential information identical user logging, wrap the step of the user logging that will be filtered out is waiting task
Include：If being searched less than corresponding client's essential information in customer table according to customer type, obtain lookup less than
The user logging of client's essential information, the user logging the first customer ID of correspondence, according to acquisition user logging
Obtain father's customer ID that there is set membership with the first customer ID；Obtain the corresponding client of father's customer ID
Record, has all of set membership according to the corresponding user logging acquisition of father's customer ID and father's customer ID
Sub- customer ID, non-first customer ID in the sub- customer ID is the second customer ID；Read the second visitor
Family identifies corresponding user logging, filters out the corresponding user logging of the second customer ID and neutralizes the first client mark
Know the client's essential information identical user logging in corresponding user logging, the user logging note that will be filtered out
It is waiting task to record.
In the present embodiment, as shown in Figure 2, there is provided a kind of customer information merging method, specifically include：
Step 202, is irregularly scanned to customer table, the customer type in customer table is read, according to client
Corresponding client's essential information in type search customer table.
Specifically, as described above, customer type include individual client and corporate users, if in customer table remember
Record be individual client, then search two user loggings in customer name, ID card No., type of credential,
Whether date of birth and sex are identical.If customer table record is corporate users, two client's notes are searched
Whether the organization mechanism code, industrial and commercial registration number and the tax registration number in record are identical.
Whether step 204, judges find corresponding client's essential information in customer table according to customer type, if
It is, then into step 206, otherwise into step 208.
In the present embodiment, if customer type is individual client, the corresponding client's essential information bag that should be searched
Include ID card No. and/or type of credential.If searched in user logging less than ID card No. or certificate class
Type, then into step 208, otherwise into step 206.
Step 206, filters out client's essential information identical user logging, the user logging record that will be filtered out
It is waiting task.
Step 208, obtains the user logging searched less than corresponding client's essential information, user logging correspondence
First customer ID, the father visitor for having set membership with the first customer ID is obtained according to the user logging for obtaining
Family identifies.
In the present embodiment, for individual client, if searched less than the ID card No. or card in user logging
Part type, that is, identification card number code field or type of credential field are sky in customer table, then show the individual
Client does not have corresponding certificate information.Such individual client then there may be father and son pass with other individual clients
System, i.e., the individual client is identified usually using the certificate information of the individual client of its last layer.Further
, the father visitor that there is set membership with the first customer ID is obtained according to the user logging with the first customer ID
Family identifies.
Step 210, obtains the corresponding user logging of father's customer ID, according to the corresponding client's note of father's customer ID
Record is obtained has all sub- customer ID of set membership with father's customer ID, and in the sub- customer ID non-the
One customer ID is the second customer ID.
In the present embodiment, the corresponding user logging of father's customer ID is obtained, can be obtained according to the user logging
All sub- customer ID under to father's customer ID, wherein the first customer ID is contained, all sub- client's marks
Except other of the first customer ID are the second customer ID in knowledge.
Step 212, reads the corresponding user logging of the second customer ID, filters out the second customer ID corresponding
User logging neutralizes the client's essential information identical client note in the corresponding user logging of the first customer ID
Record, the user logging that will be filtered out is recorded as waiting task.
In the present embodiment, used as the sub- customer ID under father's customer ID, its corresponding user logging is possible to
Actually correspond to a sub- client, it is therefore desirable to merge the user logging of same sub- client of correspondence.
Specifically, obtaining the client's essential information and the second customer ID in the corresponding user logging of the first customer ID
Client's essential information in corresponding user logging, by the client's essential information identical user logging in both
It is recorded as waiting task.
Step 214, extracts waiting task, according to the default rule that merges by client essential information identical client
Record is merged.
In the present embodiment, do not exist the individual client of respective client essential information for some, due to by visitor
Family essential information is inaccurate to screen identical individual client's meeting, by the last layer with it with set membership
The user logging of people client is identified so that some individual clients in the absence of respective client essential information
Also the merging treatment of identical individual client can be realized.
For example, in insurance business platform, some individual clients do not exist corresponding client's essential information,
Such as minor, the content of ID card No. and type of credential field in its user logging all may
It is empty.But in insurance business platform, this kind of individual client is likely to can the presence of the user logging for repeating,
Therefore need to be also carried out a plurality of user logging of this kind of individual client of identical to merge.Specifically, due to this
Class individual client can not directly buy insurance and be bought, it is necessary to pass through its guardian, therefore, for purchase
Insurance policy, guardian is that, used as main insurant, and its children under guardianship is also referred to as sub- insurant
It is the related insurer.That is, directly the individual client of purchase insurance can protect for other individual clients buy
Danger, both are related insurance relationships, are set membership on data mode.
Further, during irregularly scanning customer table, if find certain individual client do not deposited
In corresponding client's essential information, then the user logging of the main insurant of the individual client is obtained, according to master
The user logging of insurant obtains the every other sub- insurant of main insurant to search, and then obtains
Client's essential information is filtered out with other sub- insurants of client's essential information identical of the individual client.Will
The user logging of the sub- insurant with same client essential information is merged.Here same client base
This information can refer to customer name, ID card No., type of credential, date of birth identical with sex.
As shown in figure 3, in one embodiment, additionally providing a kind of customer information combination system, the system
Including：
Screening module 302, for being irregularly scanned to customer table, reads the customer type in customer table,
According to corresponding client's essential information in customer type lookup customer table, client's essential information identical is filtered out
User logging, the user logging that will be filtered out is recorded as waiting task.
Merging module 304, for extracting waiting task, according to the default rule that merges by client's essential information phase
Same user logging is merged.
In one embodiment, customer type includes individual client and corporate customer；Screening module 302 is used for
When customer type is individual client, included according to corresponding client's essential information that customer type is searched
Customer name, ID card No., type of credential, date of birth and sex；When customer type is corporate customer
When, the corresponding client's essential information searched according to customer type includes organization mechanism code, industrial and commercial note
Volume number and the tax registration number.
In one embodiment, merging module 304 is used for client's essential information identical user logging
A user logging is merged into, one customer ID of correspondence in the user logging after merging；Wherein, if objective
The respective field of family information has content in a user logging, then retain corresponding in this user logging
Content in field；If the respective field of customer information has content in a plurality of user logging, extract most
The content in the respective field in the new user logging for updating.
In one embodiment, merging module 304 is used to randomly select client's essential information identical client note
A customer ID in record, as the customer ID of the user logging after merging；Or
Merging module 304 is used to choose the earliest visitor of creation time in client's essential information identical user logging
Family identifies, used as the customer ID of the user logging after merging.
In one embodiment, as shown in figure 4, screening module 302 includes：
First relation chain acquisition module 302a, if corresponding less than in customer table for being searched according to customer type
Client's essential information, then obtain the user logging searched less than client's essential information, user logging correspondence the
One customer ID, the father client for having set membership with the first customer ID is obtained according to the user logging for obtaining
Mark.
Second relation chain acquisition module 302b, for obtaining the corresponding user logging of father's customer ID, according to father
The corresponding user logging acquisition of customer ID has all sub- customer ID of set membership with father's customer ID,
Non- first customer ID in the sub- customer ID is the second customer ID；
First screening module 302c, for reading the corresponding user logging of the second customer ID, filters out described
The client that the corresponding user logging of second customer ID is neutralized in the corresponding user logging of the first customer ID is basic
Information identical user logging, the user logging that will be filtered out is recorded as waiting task.
Each technical characteristic of embodiment described above can be combined arbitrarily, not right to make description succinct
The all possible combination of each technical characteristic in above-described embodiment is all described, as long as however, these skills
The combination of art feature does not exist contradiction, is all considered to be the scope of this specification record.
Embodiment described above only expresses several embodiments of the present invention, and its description is more specific and detailed,
But can not therefore be construed as limiting the scope of the patent.It should be pointed out that for this area
For those of ordinary skill, without departing from the inventive concept of the premise, some deformations can also be made and changed
Enter, these belong to protection scope of the present invention.Therefore, the protection domain of patent of the present invention should be with appended power
Profit requires to be defined.
Claims (10)
1. a kind of customer information merging method, it is characterised in that methods described includes：
Irregularly customer table is scanned, the customer type in the customer table is read, according to the client
Corresponding client's essential information in customer table described in type search, filters out client essential information identical client
Record, the user logging that will be filtered out is recorded as waiting task；
The waiting task is extracted, according to the default rule that merges by client's essential information identical user logging
Merge.
2. method according to claim 1, it is characterised in that the customer type includes individual client
And corporate customer；When customer type is individual client, according to the corresponding client that customer type is searched
Essential information includes customer name, ID card No., type of credential, date of birth and sex；
When customer type is corporate customer, according to corresponding client's essential information that customer type is searched
Including organization mechanism code, industrial and commercial registration number and the tax registration number.
3. method according to claim 1, it is characterised in that it is described according to the default rule that merges by visitor
The step of family essential information identical user logging is merged, including：
Client's essential information identical user logging is merged into a user logging, the client after merging
One customer ID of correspondence in record；
Wherein, if the respective field of customer information has content in a user logging, retaining should
Content described in bar user logging in respective field；
If the respective field of customer information has content in a plurality of user logging, latest update is extracted
User logging in the respective field in content.
4. method according to claim 3, it is characterised in that it is described according to the default rule that merges by visitor
The step of family essential information identical user logging is merged, also includes：
A customer ID in client's essential information identical user logging is randomly selected, as merging
The customer ID of the user logging afterwards；Or
The earliest customer ID of creation time in client's essential information identical user logging is chosen, as
The customer ID of the user logging after merging.
5. method according to claim 1, it is characterised in that described to be searched according to the customer type
Corresponding client's essential information in the customer table, filters out client's essential information identical user logging, will
The step of user logging for filtering out is recorded as waiting task, including：
If being searched less than corresponding client's essential information in the customer table according to the customer type, obtain
Search the user logging less than client's essential information, the user logging the first customer ID of correspondence, according to obtaining
The user logging for taking obtains father's customer ID with first customer ID with set membership；
The corresponding user logging of father's customer ID is obtained, according to the corresponding client's note of father's customer ID
Record obtains all sub- customer ID with father's customer ID with set membership, in the sub- customer ID
Non- first customer ID be the second customer ID；
The corresponding user logging of second customer ID is read, second customer ID is filtered out corresponding
Client essential information identical client in user logging in user logging corresponding with first customer ID
Record, the user logging that will be filtered out is recorded as waiting task.
6. a kind of customer information combination system, it is characterised in that the system includes：
Screening module, for being irregularly scanned to customer table, reads the customer type in the customer table,
According to corresponding client's essential information in the customer type lookup customer table, filter out client and believe substantially
Breath identical user logging, the user logging that will be filtered out is recorded as waiting task；
Merging module, for extracting the waiting task, according to the default rule that merges by client's essential information
Identical user logging is merged.
7. system according to claim 6, it is characterised in that the customer type includes individual client
And corporate customer；The screening module is used to, when customer type is individual client, be searched according to customer type
Corresponding client's essential information include customer name, ID card No., type of credential, date of birth
And sex；It is basic according to the corresponding client that customer type is searched when customer type is corporate customer
Information includes organization mechanism code, industrial and commercial registration number and the tax registration number.
8. system according to claim 6, it is characterised in that the merging module is used for the visitor
Family essential information identical user logging is merged into a user logging, correspondence one in the user logging after merging
Individual customer ID；Wherein, if the respective field of customer information has content in a user logging,
Then retain the content in respective field described in this user logging；If the respective field of customer information is more
There is content in user logging described in bar, then in the respective field in the user logging of extraction latest update
Content.
9. system according to claim 8, it is characterised in that the merging module is used to randomly select
A customer ID in client's essential information identical user logging, as the client after merging
The customer ID of record；Or
Creation time is earliest during the merging module is used to choose client's essential information identical user logging
Customer ID, as the customer ID of the user logging after merging.
10. system according to claim 6, it is characterised in that the screening module includes：
First relation chain acquisition module, if for being searched less than phase in the customer table according to the customer type
The client's essential information answered, then obtain the user logging searched less than client's essential information, the user logging
The first customer ID of correspondence, being obtained according to the user logging for obtaining with first customer ID there is father and son to close
Father's customer ID of system；
Second relation chain acquisition module, for obtaining the corresponding user logging of father's customer ID, according to institute
State the corresponding user logging of father's customer ID and obtain all son visitors that there is set membership with father's customer ID
Family identifies, and non-first customer ID in the sub- customer ID is the second customer ID；
First screening module, for reading the corresponding user logging of second customer ID, filters out described
Client in the corresponding user logging of second customer ID in user logging corresponding with first customer ID
Essential information identical user logging, the user logging that will be filtered out is recorded as waiting task.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201511022215.4A CN106934509A (en) | 2015-12-30 | 2015-12-30 | Customer information merging method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201511022215.4A CN106934509A (en) | 2015-12-30 | 2015-12-30 | Customer information merging method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106934509A true CN106934509A (en) | 2017-07-07 |
Family
ID=59442602
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201511022215.4A Pending CN106934509A (en) | 2015-12-30 | 2015-12-30 | Customer information merging method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106934509A (en) |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107798046A (en) * | 2017-07-25 | 2018-03-13 | 平安科技（深圳）有限公司 | Client identity information processing method, device, storage medium and computer equipment |
| CN108388675A (en) * | 2018-03-26 | 2018-08-10 | 深圳市买买提信息科技有限公司 | Circulation method and terminal device are drawn in a kind of identity |
| CN108536746A (en) * | 2018-03-12 | 2018-09-14 | 中国银行股份有限公司 | Customer information merging method and system |
| CN108805587A (en) * | 2018-06-14 | 2018-11-13 | 泰康保险集团股份有限公司 | A kind of customer information processing method, device, medium and electronic equipment |
| CN109064342A (en) * | 2018-07-20 | 2018-12-21 | 阳光保险集团股份有限公司 | Client identity recognition methods and device |
| CN109522332A (en) * | 2018-11-22 | 2019-03-26 | 泰康保险集团股份有限公司 | Customer profile data merging method, device, equipment and readable storage medium storing program for executing |
| WO2019056750A1 (en) * | 2017-09-20 | 2019-03-28 | 平安科技（深圳）有限公司 | Information uniqueness identification method, application server, system, and storage medium |
| CN109582806A (en) * | 2018-12-06 | 2019-04-05 | 上海合合信息科技发展有限公司 | A kind of personal information processing method and system calculated based on figure |
| CN109597804A (en) * | 2018-10-08 | 2019-04-09 | 中国平安人寿保险股份有限公司 | Client's merging method and device, electronic equipment and storage medium based on big data |
| CN111143426A (en) * | 2019-11-22 | 2020-05-12 | 泰康保险集团股份有限公司 | Multi-system user information association method and device |
| CN113468131A (en) * | 2021-07-14 | 2021-10-01 | 上海通联金融服务有限公司 | Batch processing and multi-dimensional storage method for merchant receipt flow |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7130867B2 (en) * | 2001-02-21 | 2006-10-31 | International Business Machines Corporation | Information component based data storage and management |
| CN103020119A (en) * | 2012-11-16 | 2013-04-03 | 北京北森测评技术有限公司 | Conversion method, device and system for converting paper edition resume into electronic edition resume |
| CN103136204A (en) * | 2011-11-23 | 2013-06-05 | 北大方正集团有限公司 | Client information duplication checking method and client information duplication checking system |
-
2015
- 2015-12-30 CN CN201511022215.4A patent/CN106934509A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7130867B2 (en) * | 2001-02-21 | 2006-10-31 | International Business Machines Corporation | Information component based data storage and management |
| CN103136204A (en) * | 2011-11-23 | 2013-06-05 | 北大方正集团有限公司 | Client information duplication checking method and client information duplication checking system |
| CN103020119A (en) * | 2012-11-16 | 2013-04-03 | 北京北森测评技术有限公司 | Conversion method, device and system for converting paper edition resume into electronic edition resume |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107798046B (en) * | 2017-07-25 | 2019-02-01 | 平安科技（深圳）有限公司 | Client identity information processing method, device, storage medium and computer equipment |
| CN107798046A (en) * | 2017-07-25 | 2018-03-13 | 平安科技（深圳）有限公司 | Client identity information processing method, device, storage medium and computer equipment |
| WO2019019767A1 (en) * | 2017-07-25 | 2019-01-31 | 平安科技（深圳）有限公司 | Client identity information processing method and apparatus, storage medium and computer device |
| WO2019056750A1 (en) * | 2017-09-20 | 2019-03-28 | 平安科技（深圳）有限公司 | Information uniqueness identification method, application server, system, and storage medium |
| CN108536746A (en) * | 2018-03-12 | 2018-09-14 | 中国银行股份有限公司 | Customer information merging method and system |
| CN108388675A (en) * | 2018-03-26 | 2018-08-10 | 深圳市买买提信息科技有限公司 | Circulation method and terminal device are drawn in a kind of identity |
| CN108805587A (en) * | 2018-06-14 | 2018-11-13 | 泰康保险集团股份有限公司 | A kind of customer information processing method, device, medium and electronic equipment |
| CN109064342A (en) * | 2018-07-20 | 2018-12-21 | 阳光保险集团股份有限公司 | Client identity recognition methods and device |
| CN109597804A (en) * | 2018-10-08 | 2019-04-09 | 中国平安人寿保险股份有限公司 | Client's merging method and device, electronic equipment and storage medium based on big data |
| CN109597804B (en) * | 2018-10-08 | 2023-10-03 | 中国平安人寿保险股份有限公司 | Customer merging method and device based on big data, electronic equipment and storage medium |
| CN109522332A (en) * | 2018-11-22 | 2019-03-26 | 泰康保险集团股份有限公司 | Customer profile data merging method, device, equipment and readable storage medium storing program for executing |
| CN109582806A (en) * | 2018-12-06 | 2019-04-05 | 上海合合信息科技发展有限公司 | A kind of personal information processing method and system calculated based on figure |
| CN111143426A (en) * | 2019-11-22 | 2020-05-12 | 泰康保险集团股份有限公司 | Multi-system user information association method and device |
| CN113468131A (en) * | 2021-07-14 | 2021-10-01 | 上海通联金融服务有限公司 | Batch processing and multi-dimensional storage method for merchant receipt flow |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106934509A (en) | Customer information merging method and system | |
| US9703985B1 (en) | Concealing a personal number | |
| US10454932B2 (en) | Search engine with privacy protection | |
| CN110309182B (en) | Information input method and device | |
| CN103761310B (en) | A kind of web page access record processing method, device and browser | |
| WO2020190309A1 (en) | Method and system for managing personal digital identifiers of a user in a plurality of data elements | |
| CN106933899A (en) | Form processing method and device | |
| CN109800747A (en) | Medical invoice recognition methods, user equipment, storage medium and device | |
| CN106803032A (en) | Realize method, device and client device that website fingerprint is logged in | |
| US8990676B2 (en) | Methods and systems for processing application forms | |
| CN108388672A (en) | Lookup method, device and the computer readable storage medium of video | |
| CN116089620A (en) | Electronic archive data management method and system | |
| JP2007114836A (en) | Information processor, control method for the same and control program | |
| US7756894B2 (en) | Use of keyword or access log information to assist a user with information search and retrieval | |
| JP6596560B1 (en) | Suggested keyword providing system, method, and program | |
| EP3924864A1 (en) | Computer systems and methods for assisting with the completion of online forms | |
| US20230351045A1 (en) | Scan surface reduction for sensitive information scanning | |
| JP5959456B2 (en) | Location information collection system and method for improving CS in travel industry | |
| JP7075855B2 (en) | Material development support system, material development support method | |
| CN112269974A (en) | Data management and control method and system | |
| JP2005182108A (en) | Electronic card reference system and medical examination history information leakage preventing filing system and electronic card reference method | |
| CN106649325A (en) | Recognition method and device for wrongly-written characters in website | |
| Martín et al. | Data management best practices and standards for biodiversity data applicable to bird monitoring data | |
| RU2778460C1 (en) | Method and apparatus for clustering phishing web resources based on an image of the visual content | |
| CN104603783B (en) | POI relevant informations processing system and method and its support device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170707 |