CN111143426A - Multi-system user information association method and device - Google Patents
Multi-system user information association method and device Download PDFInfo
- Publication number
- CN111143426A CN111143426A CN201911157854.XA CN201911157854A CN111143426A CN 111143426 A CN111143426 A CN 111143426A CN 201911157854 A CN201911157854 A CN 201911157854A CN 111143426 A CN111143426 A CN 111143426A
- Authority
- CN
- China
- Prior art keywords
- user
- record
- identification
- main
- internal
- 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 42
- 230000008859 change Effects 0.000 claims description 21
- 238000004590 computer program Methods 0.000 claims description 9
- 230000001360 synchronised effect Effects 0.000 claims description 5
- 238000010586 diagram Methods 0.000 description 14
- 238000004891 communication Methods 0.000 description 7
- 230000006870 function Effects 0.000 description 6
- 238000012217 deletion Methods 0.000 description 5
- 230000037430 deletion Effects 0.000 description 5
- 230000003287 optical effect Effects 0.000 description 4
- 238000012545 processing Methods 0.000 description 4
- 230000004048 modification Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 239000000835 fiber Substances 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 239000004065 semiconductor Substances 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000015572 biosynthetic process Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000002349 favourable effect Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000003786 synthesis reaction Methods 0.000 description 1
Images
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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method and a device for associating multi-system user information, and relates to the technical field of computers. One embodiment of the method comprises: obtaining a plurality of user internal identifications corresponding to the same characteristic dimension information in a plurality of source systems; and creating a user unified identification, and establishing an association relation between the user unified identification and each user internal identification in the plurality of user internal identifications. The embodiment can associate the user records in each source system according to the user unified identification.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a multi-system user information association method and device.
Background
At present, a same user may interact with a plurality of service systems, which are relatively independent, each service system often stores the information of the user independently and allocates an internal user identifier for the user to identify in the service system, which results in duplication of user information in each service system, and is not favorable for statistics of real user information and decision-making based on the same.
Disclosure of Invention
In view of this, embodiments of the present invention provide a method and an apparatus for associating multi-system user information, which can associate user records in each source system according to a user uniform identifier.
To achieve the above object, according to one aspect of the present invention, a method for associating multi-system user information is provided.
The multi-system user information correlation method is used for correlating user records stored in a plurality of source systems; wherein the user record contains information for uniquely identifying at least one characteristic dimension of a user; in each source system, any user record contains a pre-allocated user internal identifier; the method comprises the following steps: obtaining a plurality of user internal identifications corresponding to the same characteristic dimension information in the source systems; and creating a user unified identification, and establishing an association relation between the user unified identification and each user internal identification in the plurality of user internal identifications.
Optionally, each user uniform identifier is stored in a main record of a main data table of a pre-established central system, and the main record further stores characteristic dimension information corresponding to the user uniform identifier; any two main records of the main data table contain different user unified identifications; the association relation between each user uniform identification and the user internal identification is stored in the central system.
Optionally, the method further comprises: when any source system adds a new user record, judging whether a main record containing the characteristic dimension information in the newly added user record is stored in the main data table; when the main data table does not store the main record containing the characteristic dimension information: creating a user uniform identifier, adding a main record containing the created user uniform identifier in a main data table, and creating an association relation between the created user uniform identifier and a user internal identifier in a user record newly added by the source system; when the main data table stores the main record containing the characteristic dimension information, the incidence relation between the user uniform identification in the main record and the user internal identification in the user record newly added by the source system is established.
Optionally, the method further comprises: when the characteristic dimension information of any user record of any source system is changed, acquiring a main record containing the characteristic dimension information before change in a main data table, and deleting the association relation between the user uniform identification in the main record and the user internal identification in the user record; judging whether the association relation between the user unified identification and any user internal identification in the main record is stored in the central system at present: if not, deleting the main record.
Optionally, the method further comprises: when the characteristic dimension information of any user record of any source system is changed, judging whether a main record containing the changed characteristic dimension information is stored in a main data table: if yes, establishing an association relation between the user unified identification in the main record and the user internal identification in the user record; otherwise, a user unified identification is newly built, a main record containing the newly built user unified identification is added in the main data table, and the association relationship between the newly built user unified identification and the user internal identification in the user record is established.
Optionally, the central system further comprises a backup system for each source system; the information recorded in a preset dimension by a user of each backup system is kept synchronous with a source system corresponding to the backup system, and the preset dimension comprises the at least one characteristic dimension; the method further comprises: and acquiring the internal identification of the user in the source system corresponding to the backup system and the addition and change information recorded by the user in the source system through each backup system.
Optionally, the at least one feature dimension comprises: name and mobile terminal number; or, name, credential type, and credential number; or name, gender, date of birth, credential type, and credential number.
To achieve the above object, according to another aspect of the present invention, a multi-system user information associating apparatus is provided.
The multi-system user information correlation device is used for correlating user records stored in a plurality of source systems; wherein the user record contains information for uniquely identifying at least one characteristic dimension of a user; in each source system, any user record contains a pre-allocated user internal identifier; the apparatus may comprise: the user internal identification acquisition unit is used for acquiring a plurality of user internal identifications corresponding to the same characteristic dimension information in the source systems; and the association unit is used for creating a user unified identifier and establishing an association relation between the user unified identifier and each user internal identifier in the plurality of user internal identifiers.
To achieve the above object, according to still another aspect of the present invention, there is provided an electronic apparatus.
An electronic device of the present invention includes: one or more processors; the storage device is used for storing one or more programs, and when the one or more programs are executed by the one or more processors, the one or more processors realize the multi-system user information association method provided by the invention.
To achieve the above object, according to still another aspect of the present invention, there is provided a computer-readable storage medium.
The invention relates to a computer readable storage medium, on which a computer program is stored, which when executed by a processor implements the multi-system user information association method provided by the invention.
According to the technical scheme of the invention, one embodiment of the invention has the following advantages or beneficial effects:
firstly, because the user records in each source system have the characteristic dimension information capable of uniquely identifying the user, the user internal identification corresponding to the same characteristic dimension information in each source system is determined, and the user unified identification is established to be associated with the user internal identification, namely, the records of the same user in each source system can be associated according to the user unified identification, and the user unified identification can be utilized to determine the effective user number so as to facilitate subsequent statistics.
Secondly, the invention uses the main data table in the central system to store the main record containing the user uniform identification, and acquires the user record newly-increased or changed condition in the source system through each source system backup system arranged in the central system. When a user record is newly added to the source system or characteristic dimension information in the user record is changed, the central system can automatically complete the addition or deletion of the main record according to preset logic and automatically adjust the association relationship between the user uniform identifier and the user internal identifier, so that the real-time dynamic update of the central system information along with the source system is realized.
Further effects of the above-mentioned non-conventional alternatives will be described below in connection with the embodiments.
Drawings
The drawings are included to provide a better understanding of the invention and are not to be construed as unduly limiting the invention. Wherein:
FIG. 1 is a schematic diagram illustrating major steps of a multi-system user information association method according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of a system component for a multi-system user information association method according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of components of a multi-system user information association apparatus according to an embodiment of the present invention;
FIG. 4 is an exemplary system architecture diagram in which embodiments of the present invention may be employed;
fig. 5 is a schematic structural diagram of an electronic device for implementing the multi-system user information association method in the embodiment of the present invention.
Detailed Description
Exemplary embodiments of the present invention are described below with reference to the accompanying drawings, in which various details of embodiments of the invention are included to assist understanding, and which are to be considered as merely exemplary. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.
It should be noted that the embodiments of the present invention and the technical features of the embodiments may be combined with each other without conflict.
Fig. 1 is a schematic diagram illustrating main steps of a multi-system user information association method according to an embodiment of the present invention.
As shown in fig. 1, the method for associating multi-system user information according to the embodiment of the present invention may be specifically executed according to the following steps:
step S101: and acquiring a plurality of user internal identifications corresponding to the same characteristic dimension information in a plurality of source systems.
In the embodiment of the present invention, the source system is a service system that executes a specific service, a data table of each source system stores a plurality of user records, and each user record of each data source may include data of a plurality of dimensions required by the source system, such as a user internal identifier, where the user internal identifier is used to uniquely identify a user inside the data source. Preferably, the user internal identification format is arranged to be associated with a corresponding source system, whereby the corresponding data source is determined in accordance with the content of the user internal identification. For example, the user internal identification in the source system a may be set to start with "a".
Each user record may also include at least one characteristic dimension that uniquely identifies the user in the plurality of systems. In practical application, the feature dimension can be flexibly set according to the application environment, for example, the feature dimension can be set as: the combination of the user name and the number of the mobile terminal (such as a mobile phone) of the user, or the combination of the user name, the certificate type and the certificate number, or the combination of the user name, the gender, the birth date, the certificate type and the certificate number can also be set as the certificate number of a single dimension, such as the number of the mobile terminal of the user or a determined certificate type (such as an identity card). For feature dimension information including a plurality of dimensions, a change in any one dimension information means a change in the feature dimension information. In the following description, a combination of a user's name and his mobile terminal number will be introduced as a feature dimension.
In this step, a plurality of user internal identifiers corresponding to the same feature dimension information in a plurality of source systems can be obtained for subsequent association. It is understood that the same feature dimension information refers to having the same value in each feature dimension.
Step S102: and establishing a user unified identification, and establishing an association relation between the user unified identification and each user internal identification in the plurality of user internal identifications.
For the multiple user internal identifiers corresponding to the same feature dimension information obtained in the multiple source systems in step S101, in this step, a user uniform identifier may be created and an association relationship between the user uniform identifier and each of the multiple user internal identifiers may be established, so as to implement association between each user internal identifier and the corresponding user record. The user uniform identification corresponds to the characteristic dimension information corresponding to the internal identification of each user one by one, and the user uniform identification can be used as a real and effective user identification to perform user quantity statistics.
Preferably, each user uniform identifier is stored in a main record of a main data table of the pre-established central system. The central system can be used for realizing the synthesis and association of user information among the source systems and can also be used for data backup of the source systems. Fig. 2 is a schematic diagram of a system composition used in the multi-system user information association method in the embodiment of the present invention, as shown in fig. 2, a backup system of each source system may be set in a central system (a backup system a is set for a source system a, a backup system B is set for a source system B, and a backup system C is set for a source system C), and information recorded in a preset dimension by a user of each backup system is kept synchronous with the source system corresponding to the backup system. It is to be understood that the preset dimension may be a partial dimension or a full dimension that the user records have in the source system corresponding to the backup system, and generally, the preset dimension may include a user internal identification dimension and a full feature dimension so that each record of the backup system can uniquely identify the user. Through the arrangement, the central system can acquire the information change condition of the corresponding source system through the backup system. The above is only preferred, and it is understood that the central system can also directly communicate with the source system to obtain the information change thereof.
The central system can store the user uniform identification through a main data table, records of the main data table are called as main records, and each main record can store characteristic dimension information corresponding to the user uniform identification. In addition, any two main records of the main data table contain different user unified identifications, so that user authentication based on the user unified identifications is realized. In a specific application, the central system may further store an association relationship between each user uniform identifier and the user internal identifier, where the association relationship may be stored in a main record of the main data table or in an association relationship data table of the central system. For example, if a user is identified as A1 inside the user of source system A, B1 inside the user of source system B, C1 inside the user of source system C, and his users are collectively identified as U1, the master record may be as follows:
| user uniform identification | Name (I) | Mobile terminal number | Associated user internal identification |
| U1 | Wangsan | 123 | A1、B1、C1 |
Wherein, "wang di" and "123" are information of feature dimension "name" and "mobile terminal number", respectively (for example only). The above is the case where the association between the user uniform identifier and the user internal identifier is stored in the master record. In a specific application, the association relationship may also be stored in an association relationship data table, in this case, the main record may be as follows:
| user uniform identification | Name (I) | Mobile terminal number |
| U1 | Wangsan | 123 |
The corresponding records in the association data table are:
| user uniform identification | Source system identification | User internal identification |
| U1 | A | A1 |
| U1 | B | B1 |
| U1 | C | C1 |
In the following, a case where the association relationship between the user unified identifier and the user internal identifier is stored in the master record will be described as an example.
In the embodiment of the invention, when the user record in the source system changes, the records in the backup system can be synchronized in real time, and at the moment, the central system can update the main data table or update both the main data table and the association relation data table according to the data change in the backup system. In the embodiment of the present invention, dynamic adjustment logics of the main record and the association relationship are respectively set for two scenarios, i.e., a user record addition scenario and a user record change scenario, which will be described below.
When any source system adds a new user record, the central system can acquire the internal user identifier and the characteristic dimension information in the new user record from the corresponding backup system, and judge whether the main data table stores the main record containing the characteristic dimension information in the new user record. If the main data table does not store the main record containing the characteristic dimension information (the main record of a newly added user does not exist in the main data table), a user unified identifier is newly created, the main record containing the newly created user unified identifier is added in the main data table, and the association relationship between the newly created user unified identifier and the user internal identifier in the user record newly added by the source system is established. If the main data table stores the main record containing the characteristic dimension information (which indicates that the main record of the newly added user exists in the main data table), the association relationship between the user uniform identifier in the main record and the user internal identifier in the user record newly added by the source system is established.
For example, if the source system a newly adds a user record containing the following information:
| user internal identification | Name (I) | Mobile terminal number |
| A2 | Zhang three | 456 |
The central system acquires the information from the backup system A, and inquires whether a main record with a name field of 'Zhang III' and a mobile terminal number field of '456' exists in a main data table: if a matching record is found in the master data table as follows:
| user uniform identification | Name (I) | Mobile terminal number | Associated user internal identification |
| U2 | Zhang three | 456 | B2 |
Then the association relationship between "U2" and "a 2" is established and stored in the matching record, and the record formed finally is as follows:
| user uniform identification | Name (I) | Mobile terminal number | Associated user internal identification |
| U2 | Zhang three | 456 | A2、B2 |
If no matching record is inquired in the main data table, adding a main record with the user uniform identifier of 'U100' (U100 is different from any user uniform identifier in the main data table before), establishing the association relation between 'U100' and 'A2' and storing the association relation in the main record, wherein the main record is finally as follows:
| user uniform identification | Name (I) | Mobile terminal number | Associated user internal identification |
| U100 | Zhang three | 456 | A2 |
When the characteristic dimension information recorded by any user of any source system is changed, the central system can obtain the changed characteristic dimension information through a corresponding backup system, then, firstly, a main record containing the characteristic dimension information before the change in a main data table is determined, and the incidence relation between the user uniform identifier in the main record and the user internal identifier in the user record is deleted. Then, whether the incidence relation between the user uniform identification and any user internal identification in the main record is stored in the central system is judged: if yes, the user unified identification in the main record is also associated with other user internal identifications, and the main record is kept; otherwise, the user uniform identification in the main record is not associated with any user internal identification, and the main record is deleted.
After the above steps are executed according to the characteristic dimension information before the change, the central system can judge whether the main data table stores the main record containing the characteristic dimension information after the change: if yes, establishing an association relation between the user unified identification in the main record and the user internal identification in the user record; otherwise, a user unified identification is newly built, a main record containing the newly built user unified identification is added in the main data table, and the association relationship between the newly built user unified identification and the user internal identification in the user record is established. It is to be understood that the steps performed according to the altered feature dimension information may occur before, after, or simultaneously with the steps performed according to the pre-altered feature dimension information, and the present invention does not limit the order of execution of the two.
For example, if the mobile terminal number information in the following user record in the source system a is changed to "654" by the client:
| user internal identification | Name (I) | Mobile terminal number |
| A2 | Zhang three | 456 |
The characteristic data information before the change is { "name": "zhang san" and "mobile terminal number": "456", the changed information is: { "name": "zhang san" and "mobile terminal number": "654"}. The central system firstly learns the above changes through the backup system a, if the main records of the main data table with the "name" field of "zhang san" and the "mobile terminal number" field of "456" are determined as follows:
| user uniform identification | Name (I) | Mobile terminal number | Associated user internal identification |
| U2 | Zhang three | 456 | A2 |
At this time, the value "a 2" of the "associated internal user identifier" field in the main record may be deleted (i.e. the association relationship between U2 and a2 is deleted), and the main record may be deleted from the main data table because the association relationship between "U2" and any internal user identifier does not exist in the central system after the deletion is performed.
If the central system determines that the main records of the main data table with the 'name' field of 'zhang san' and the 'mobile terminal number' field of '456' are as follows after learning the above change of the source system a:
| user uniform identification | Name (I) | Mobile terminal number | Associated user internal identification |
| U2 | Zhang three | 456 | A2、B2 |
Deleting the value "A2" of the "associated internal user identifier" field in the main record, and then retaining the main record, wherein the formed main record is as follows:
| user uniform identification | Name (I) | Mobile terminal number | Associated user internal identification |
| U2 | Zhang three | 456 | B2 |
After the execution procedure based on the feature dimension information before change is completed, the central system determines whether the main record with the "name" field of "zhangsan" and the "mobile terminal number" field of "654" exists in the data table. If the following matching records are queried:
| user uniform identification | Name (I) | Mobile terminal number | Associated user internal identification |
| U2 | Zhang three | 654 | C2 |
Then an association between "U2" and "a 2" is established, forming the following master record:
| user uniform identification | Name (I) | Mobile terminal number | Associated user internal identification |
| U2 | Zhang three | 654 | A2、C2 |
If no matching record is inquired in the main data table, adding a main record of a main record with a user uniform identification of 'U200' (the U200 is different from any user uniform identification in the main data table before) in the main data table, and establishing and storing an association relation between 'U200' and 'A2' in the main record, wherein the main record is finally as follows:
| user uniform identification | Name (I) | Mobile terminal number | Associated user internal identification |
| U200 | Zhang three | 654 | A2 |
Through the setting, the dynamic updating of the association relation between the main record and the user unified identification in the central system and the user internal identification can be realized. It is understood that the central system may also update the information in the main data table and the association data table in a similar manner when the source system deletes a certain user record.
In the technical scheme of the embodiment of the invention, because the user records in each source system have the characteristic dimension information capable of uniquely identifying the user, the internal user identification corresponding to the same characteristic dimension information in each source system is determined, the unified user identification is established to be associated with the internal user identification, the records of the same user in each source system can be associated according to the unified user identification, and the effective user number can be determined by utilizing the unified user identification so as to facilitate subsequent statistics. In addition, the invention uses the main data table in the central system to store the main record containing the user uniform identification, and obtains the new increase or change condition of the user record in the source system through the backup system of each source system arranged in the central system. When a user record is newly added to the source system or characteristic dimension information in the user record is changed, the central system can automatically complete the addition or deletion of the main record according to preset logic and automatically adjust the association relationship between the user uniform identifier and the user internal identifier, so that the real-time dynamic update of the central system information along with the source system is realized.
It should be noted that, for the convenience of description, the foregoing method embodiments are described as a series of acts, but those skilled in the art will appreciate that the present invention is not limited by the order of acts described, and that some steps may in fact be performed in other orders or concurrently. Moreover, those skilled in the art will appreciate that the embodiments described in the specification are presently preferred and that no acts or modules are necessarily required to implement the invention.
To facilitate a better implementation of the above-described aspects of embodiments of the present invention, the following also provides relevant means for implementing the above-described aspects.
Referring to fig. 3, a multi-system user information association apparatus 300 according to an embodiment of the present invention may be used to associate user records stored in a plurality of source systems; wherein the user record contains information for uniquely identifying at least one characteristic dimension of a user; in each source system, any user record contains the pre-assigned internal user identification. The apparatus 200 may include: a user internal identification obtaining unit 201 and an association unit 202.
The user internal identifier obtaining unit 201 may be configured to obtain a plurality of user internal identifiers corresponding to the same feature dimension information in the plurality of source systems; the associating unit 202 may be configured to create a user unified identifier, and establish an association relationship between the user unified identifier and each of the plurality of user internal identifiers.
In the embodiment of the invention, each user uniform identifier is stored in a main record of a main data table of a pre-established central system, and the main record further stores characteristic dimension information corresponding to the user uniform identifier; any two main records of the main data table contain different user unified identifications; the association relation between each user uniform identification and the user internal identification is stored in the central system.
In a specific application, the apparatus may further include a dynamic update unit configured to: when any source system adds a new user record, judging whether a main record containing the characteristic dimension information in the newly added user record is stored in the main data table; when the main data table does not store the main record containing the characteristic dimension information: creating a user uniform identifier, adding a main record containing the created user uniform identifier in a main data table, and creating an association relation between the created user uniform identifier and a user internal identifier in a user record newly added by the source system; when the main data table stores the main record containing the characteristic dimension information, the incidence relation between the user uniform identification in the main record and the user internal identification in the user record newly added by the source system is established.
In some embodiments, the dynamic update unit may be further configured to: when the characteristic dimension information of any user record of any source system is changed, acquiring a main record containing the characteristic dimension information before change in a main data table, and deleting the association relation between the user uniform identification in the main record and the user internal identification in the user record; judging whether the association relation between the user unified identification and any user internal identification in the main record is stored in the central system at present: if not, deleting the main record.
In an optional implementation, the dynamic update unit may be further configured to: when the characteristic dimension information of any user record of any source system is changed, judging whether a main record containing the changed characteristic dimension information is stored in a main data table: if yes, establishing an association relation between the user unified identification in the main record and the user internal identification in the user record; otherwise, a user unified identification is newly built, a main record containing the newly built user unified identification is added in the main data table, and the association relationship between the newly built user unified identification and the user internal identification in the user record is established.
As a preferred aspect, the central system may further include a backup system for each source system; the information recorded in a preset dimension by a user of each backup system is kept synchronous with a source system corresponding to the backup system, and the preset dimension can comprise the at least one characteristic dimension; the user internal identification obtaining unit 201 may be further configured to: and acquiring the internal identification of the user in the source system corresponding to the backup system and the addition and change information recorded by the user in the source system through each backup system.
Furthermore, in an embodiment of the present invention, the at least one feature dimension includes: name and mobile terminal number; or, name, credential type, and credential number; or name, gender, date of birth, credential type, and credential number.
In the technical scheme of the embodiment of the invention, because the user records in each source system have the characteristic dimension information capable of uniquely identifying the user, the internal user identification corresponding to the same characteristic dimension information in each source system is determined, the unified user identification is established to be associated with the internal user identification, the records of the same user in each source system can be associated according to the unified user identification, and the effective user number can be determined by utilizing the unified user identification so as to facilitate subsequent statistics. In addition, the invention uses the main data table in the central system to store the main record containing the user uniform identification, and obtains the new increase or change condition of the user record in the source system through the backup system of each source system arranged in the central system. When a user record is newly added to the source system or characteristic dimension information in the user record is changed, the central system can automatically complete the addition or deletion of the main record according to preset logic and automatically adjust the association relationship between the user uniform identifier and the user internal identifier, so that the real-time dynamic update of the central system information along with the source system is realized.
Fig. 4 illustrates an exemplary system architecture 400 to which a multi-system user information association method or a multi-system user information association apparatus of an embodiment of the present invention may be applied.
As shown in fig. 4, the system architecture 400 may include terminal devices 401, 402, 403, a network 404, and a server 405 (this architecture is merely an example, and the components included in a particular architecture may be adapted according to application specific circumstances). The network 404 serves as a medium for providing communication links between the terminal devices 401, 402, 403 and the server 405. Network 404 may include various types of connections, such as wire, wireless communication links, or fiber optic cables, to name a few.
A user may use terminal devices 401, 402, 403 to interact with a server 405 over a network 404 to receive or send messages or the like. Various communication client applications, such as a user identity association application (for example only), may be installed on the terminal devices 401, 402, 403.
The terminal devices 401, 402, 403 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smart phones, tablet computers, laptop portable computers, desktop computers, and the like.
The server 405 may be a server providing various services, such as a calculation server (for example only) providing support for a user using a user identity correlation application operated by the terminal device 401, 402, 403. The server 405 may process the received user identifier association request and the like, and feed back the processing result (for example, the association relationship between the user identifiers, which is merely an example) to the terminal devices 401, 402, and 403.
It should be noted that the multi-system user information association method provided in the embodiment of the present invention is generally executed by the server 405, and accordingly, the multi-system user information association apparatus is generally disposed in the server 405.
It should be understood that the number of terminal devices, networks, and servers in fig. 4 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.
The invention also provides the electronic equipment. The electronic device of the embodiment of the invention comprises: one or more processors; the storage device is used for storing one or more programs, and when the one or more programs are executed by the one or more processors, the one or more processors realize the multi-system user information association method provided by the invention.
Referring now to FIG. 5, shown is a block diagram of a computer system 500 suitable for use in implementing an electronic device of an embodiment of the present invention. The electronic device shown in fig. 5 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present invention.
As shown in fig. 5, the computer system 500 includes a Central Processing Unit (CPU)501 that can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM)502 or a program loaded from a storage section 508 into a Random Access Memory (RAM) 503. In the RAM503, various programs and data necessary for the operation of the computer system 500 are also stored. The CPU501, ROM 502, and RAM503 are connected to each other via a bus 504. An input/output (I/O) interface 505 is also connected to bus 504.
The following components are connected to the I/O interface 505: an input portion 506 including a keyboard, a mouse, and the like; an output portion 507 including a display such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker; a storage portion 508 including a hard disk and the like; and a communication section 509 including a network interface card such as a LAN card, a modem, or the like. The communication section 509 performs communication processing via a network such as the internet. The driver 510 is also connected to the I/O interface 505 as necessary. A removable medium 511 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 510 as necessary, so that a computer program read out therefrom is mounted into the storage section 508 as necessary.
In particular, the processes described in the main step diagrams above may be implemented as computer software programs, according to embodiments of the present disclosure. For example, embodiments of the invention include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method illustrated in the main step diagram. In the above-described embodiment, the computer program can be downloaded and installed from a network through the communication section 509, and/or installed from the removable medium 511. The computer program performs the above-described functions defined in the system of the present invention when executed by the central processing unit 501.
It should be noted that the computer readable medium shown in the present invention can be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present invention, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In the present invention, a computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, fiber optic cable, RF, etc., or any suitable combination of the foregoing.
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The units described in the embodiments of the present invention may be implemented by software or hardware. The described units may also be provided in a processor, and may be described as: a processor includes a user internal identification acquisition unit and an association unit. The names of these units do not in some cases form a limitation to the unit itself, for example, the user internal identification obtaining unit may also be described as "a unit providing the user internal identification to the association unit".
As another aspect, the present invention also provides a computer-readable medium that may be contained in the apparatus described in the above embodiments; or may be separate and not incorporated into the device. The computer readable medium carries one or more programs which, when executed by the apparatus, cause the apparatus to perform steps comprising: obtaining a plurality of user internal identifications corresponding to the same characteristic dimension information in a plurality of source systems; and creating a user unified identification, and establishing an association relation between the user unified identification and each user internal identification in the plurality of user internal identifications.
In the technical scheme of the embodiment of the invention, because the user records in each source system have the characteristic dimension information capable of uniquely identifying the user, the internal user identification corresponding to the same characteristic dimension information in each source system is determined, the unified user identification is established to be associated with the internal user identification, the records of the same user in each source system can be associated according to the unified user identification, and the effective user number can be determined by utilizing the unified user identification so as to facilitate subsequent statistics. In addition, the invention uses the main data table in the central system to store the main record containing the user uniform identification, and obtains the new increase or change condition of the user record in the source system through the backup system of each source system arranged in the central system. When a user record is newly added to the source system or characteristic dimension information in the user record is changed, the central system can automatically complete the addition or deletion of the main record according to preset logic and automatically adjust the association relationship between the user uniform identifier and the user internal identifier, so that the real-time dynamic update of the central system information along with the source system is realized.
The above-described embodiments should not be construed as limiting the scope of the invention. Those skilled in the art will appreciate that various modifications, combinations, sub-combinations, and substitutions can occur, depending on design requirements and other factors. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (10)
1. A multi-system user information correlation method is used for correlating user records stored in a plurality of source systems; wherein the user record contains information for uniquely identifying at least one characteristic dimension of a user; in each source system, any user record contains a pre-allocated user internal identifier;
characterized in that the method comprises:
obtaining a plurality of user internal identifications corresponding to the same characteristic dimension information in the source systems;
and creating a user unified identification, and establishing an association relation between the user unified identification and each user internal identification in the plurality of user internal identifications.
2. The method according to claim 1, wherein each user uniform identifier is stored in a main record of a pre-established main data table of the central system, and the main record further stores characteristic dimension information corresponding to the user uniform identifier; any two main records of the main data table contain different user unified identifications;
and the association relation between each user uniform identification and the user internal identification is stored in the central system.
3. The method of claim 2, further comprising:
when any source system adds a new user record, judging whether a main record containing the characteristic dimension information in the newly added user record is stored in the main data table;
when the main data table does not store the main record containing the characteristic dimension information: creating a user uniform identifier, adding a main record containing the created user uniform identifier in a main data table, and creating an association relation between the created user uniform identifier and a user internal identifier in a user record newly added by the source system;
when the main data table stores the main record containing the characteristic dimension information, the incidence relation between the user uniform identification in the main record and the user internal identification in the user record newly added by the source system is established.
4. The method of claim 2, further comprising:
when the characteristic dimension information of any user record of any source system is changed, acquiring a main record containing the characteristic dimension information before change in a main data table, and deleting the association relation between the user uniform identification in the main record and the user internal identification in the user record; and
judging whether the association relation between the user unified identification and any user internal identification in the main record is stored in the central system at present: if not, deleting the main record.
5. The method of claim 4, further comprising:
when the characteristic dimension information of any user record of any source system is changed, judging whether a main record containing the changed characteristic dimension information is stored in a main data table:
if yes, establishing an association relation between the user unified identification in the main record and the user internal identification in the user record;
otherwise, a user unified identification is newly built, a main record containing the newly built user unified identification is added in the main data table, and the association relationship between the newly built user unified identification and the user internal identification in the user record is established.
6. The method of claim 2, wherein the central system further comprises a backup system for each source system; the information recorded in a preset dimension by a user of each backup system is kept synchronous with a source system corresponding to the backup system, and the preset dimension comprises the at least one characteristic dimension; and, the method further comprises:
and acquiring the internal identification of the user in the source system corresponding to the backup system and the addition and change information recorded by the user in the source system through each backup system.
7. The method of any of claims 1-6, wherein the at least one feature dimension comprises:
name and mobile terminal number;
or, name, credential type, and credential number;
or name, gender, date of birth, credential type, and credential number.
8. A multi-system user information correlation device is used for correlating user records stored in a plurality of source systems; wherein the user record contains information for uniquely identifying at least one characteristic dimension of a user; in each source system, any user record contains a pre-allocated user internal identifier; characterized in that the device comprises:
the user internal identification acquisition unit is used for acquiring a plurality of user internal identifications corresponding to the same characteristic dimension information in the source systems;
and the association unit is used for creating a user unified identifier and establishing an association relation between the user unified identifier and each user internal identifier in the plurality of user internal identifiers.
9. An electronic device, comprising:
one or more processors;
a storage device for storing one or more programs,
when executed by the one or more processors, cause the one or more processors to implement the method of any one of claims 1-7.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the method according to any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911157854.XA CN111143426A (en) | 2019-11-22 | 2019-11-22 | Multi-system user information association method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911157854.XA CN111143426A (en) | 2019-11-22 | 2019-11-22 | Multi-system user information association method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111143426A true CN111143426A (en) | 2020-05-12 |
Family
ID=70517265
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911157854.XA Pending CN111143426A (en) | 2019-11-22 | 2019-11-22 | Multi-system user information association method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111143426A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112597159A (en) * | 2020-12-22 | 2021-04-02 | 深圳集智数字科技有限公司 | Method and device for maintaining unique user identification information |
| CN113094370A (en) * | 2021-04-13 | 2021-07-09 | 北京精鸿软件科技有限公司 | Data index construction method and device, storage medium and electronic equipment |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106934509A (en) * | 2015-12-30 | 2017-07-07 | 平安科技（深圳）有限公司 | Customer information merging method and system |
| CN109446197A (en) * | 2018-09-26 | 2019-03-08 | 深圳壹账通智能科技有限公司 | User information processing method, device, computer 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 |
| CN109542894A (en) * | 2018-10-22 | 2019-03-29 | 平安科技（深圳）有限公司 | User data concentrates storage method, device, medium and computer equipment |
-
2019
- 2019-11-22 CN CN201911157854.XA patent/CN111143426A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106934509A (en) * | 2015-12-30 | 2017-07-07 | 平安科技（深圳）有限公司 | Customer information merging method and system |
| CN109446197A (en) * | 2018-09-26 | 2019-03-08 | 深圳壹账通智能科技有限公司 | User information processing method, device, computer equipment and storage medium |
| CN109542894A (en) * | 2018-10-22 | 2019-03-29 | 平安科技（深圳）有限公司 | User data concentrates storage method, device, medium and computer equipment |
| CN109522332A (en) * | 2018-11-22 | 2019-03-26 | 泰康保险集团股份有限公司 | Customer profile data merging method, device, equipment and readable storage medium storing program for executing |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112597159A (en) * | 2020-12-22 | 2021-04-02 | 深圳集智数字科技有限公司 | Method and device for maintaining unique user identification information |
| CN113094370A (en) * | 2021-04-13 | 2021-07-09 | 北京精鸿软件科技有限公司 | Data index construction method and device, storage medium and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11146502B2 (en) | Method and apparatus for allocating resource | |
| CN107666525B (en) | Method and device for IP allocation of cluster container | |
| CN109413127B (en) | Data synchronization method and device | |
| CN108959292B (en) | Data uploading method, system and computer readable storage medium | |
| CN108846753B (en) | Method and apparatus for processing data | |
| CN107302597B (en) | Message file pushing method and device | |
| CN109582873B (en) | Method and device for pushing information | |
| CN108965098B (en) | Message pushing method, device, medium and electronic equipment based on online live broadcast | |
| CN110895603B (en) | Multi-system account information integration method and device | |
| CN110019263B (en) | Information storage method and device | |
| CN111478781B (en) | Message broadcasting method and device | |
| CN110909521A (en) | Synchronous processing method and device for online document information and electronic equipment | |
| CN111460129A (en) | Method and device for generating identification, electronic equipment and storage medium | |
| US20190012362A1 (en) | Method and apparatus for processing information | |
| CN111143426A (en) | Multi-system user information association method and device | |
| CN110365745A (en) | Data processing system, method, apparatus, server and computer-readable medium | |
| CN110245014B (en) | Data processing method and device | |
| CN108520401B (en) | User list management method, device, platform and storage medium | |
| CN109150927B (en) | File issuing method and device for file storage system | |
| CN110300222B (en) | Short message display method, system, terminal equipment and computer readable storage medium | |
| CN110798358A (en) | Distributed service identification method and device, computer readable medium and electronic equipment | |
| CN112100168A (en) | Method and device for determining data association relationship | |
| US10680877B2 (en) | Information transmission, sending, and acquisition method and device | |
| CN112836201A (en) | Method, device, equipment and computer readable medium for multi-platform information intercommunication | |
| CN108494982B (en) | Method and apparatus for generating information |
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: 20200512 |
|
| RJ01 | Rejection of invention patent application after publication |