CN110737675A - Association ID query method and device, electronic equipment and storage medium - Google Patents
Association ID query method and device, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN110737675A CN110737675A CN201910987223.4A CN201910987223A CN110737675A CN 110737675 A CN110737675 A CN 110737675A CN 201910987223 A CN201910987223 A CN 201910987223A CN 110737675 A CN110737675 A CN 110737675A
- Authority
- CN
- China
- Prior art keywords
- original
- ids
- identification information
- association
- information
- 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
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/242—Query formulation
-
- 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/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention provides associated ID query methods, devices, electronic equipment and storage media, and relates to the technical field of data processing, wherein the associated ID query methods, the devices, the electronic equipment and the storage media provided by the embodiment of the invention store the associated original IDs in a database and the association relation between the associated original IDs and system identification information, further, after the original ID to be queried is obtained, the system identification information associated with the original ID to be queried can be searched in the database according to the original ID to be queried, all target original IDs associated with the system identification information are searched in the database according to the system identification information, and all the searched target original IDs are used as the associated IDs of the original ID to be queried, so that convenient query of all the associated IDs is realized.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to associated ID query methods, devices, electronic equipment and storage media.
Background
With the increasing rise of digitization, more and more behaviors of consumers, such as advertising marketing behaviors, purchasing behaviors, social behaviors and the like, can be collected and recorded in a digitized form, but due to the independence of each domain, the original IDs of the consumers recorded in logs of different domains are different, and the original IDs of the consumers are often correlated to facilitate the analysis of the full-path behavior of a single consumer across the domains.
At present, most of ID data is relational data and is stored in a relational database, and in relation to generation of ID association relations, relationships between certain IDs and other IDs are often established according to specific conditions, and the result is also relational data, so that when ID association data is queried, the ID correspondence relations can be obtained only on the basis of fixed orders, and thus all associated IDs cannot be obtained conveniently.
Disclosure of Invention
Based on the above research, the invention provides kinds of associated ID query methods, apparatuses, electronic devices, and storage media.
Embodiments of the invention may be implemented as follows:
, an embodiment of the present invention provides method for querying associate IDs, the method including:
acquiring an original ID to be queried, and searching identification information of a system associated with the original ID to be queried in a database according to the original ID to be queried;
and searching all target original IDs associated with the identification information of the system from the database according to the identification information of the system , and taking all the searched target original IDs as association IDs of the original IDs to be inquired, wherein the database comprises the original IDs which are associated with each other and the association relation between the original IDs which are associated with each other and the identification information of the system which is .
In an alternative embodiment, the original IDs associated with each other in the database are obtained by the following steps;
receiving at least ID binding information, wherein each ID binding information at least comprises two different original IDs;
and judging whether each original ID in the ID binding information is associated or not based on a graph calculation engine Gelly, and establishing an association relation between the associated original IDs to obtain the associated original IDs after the association relation is established.
In an optional embodiment, the step of determining, based on the graph computation engine Gelly, whether each original ID in each ID binding information is associated, establishing an association relationship between the associated original IDs, and obtaining each original ID associated with each other after the association relationship is established, includes:
judging whether the same original ID exists in the ID binding information or not, and if so, judging that the original IDs in the ID binding information with the same original ID are associated;
and connecting the associated original IDs by lines by taking the associated original IDs as points to establish an association relationship to obtain the associated original IDs.
In an alternative embodiment, the system identification information is obtained by:
assigning original IDs in the correlated original IDs to obtain identification information of the original IDs;
the identification information is taken as the system identification information of all the original IDs associated with each other, and the system identification information is associated with all the original IDs associated with each other.
In an optional embodiment, the step of assigning original IDs in the mutually associated original IDs to obtain the identification information of the original IDs includes:
and on the basis of a hash algorithm, carrying out hash operation on original ID values in the correlated original IDs to obtain the identification information of the original ID.
In an alternative embodiment, the method further comprises:
receiving new ID binding information, and judging whether an original ID in the new ID binding information is associated with each original ID which is associated with each other;
and if the new ID binding information is associated with the original ID, establishing the association relationship between the original ID in the new ID binding information and the associated original IDs, and updating the association relationship between the associated original IDs and the identification information of the same and .
In an optional implementation manner, each piece of ID binding information further includes information corresponding to each original ID; before determining whether each original ID in each ID binding information is associated, the method further includes:
and filtering the ID binding information based on set conditions according to the information corresponding to each original ID.
In a second aspect, an embodiment of the present invention provides kinds of association ID query apparatuses, where the apparatus includes a lookup module and a processing module;
the searching module is used for acquiring an original ID to be queried and searching the identification information of the system associated with the original ID to be queried in a database according to the original ID to be queried;
the processing module is used for searching all target original IDs associated with the system identification information from the database according to the system identification information, taking all the searched target original IDs as association IDs of the original IDs to be inquired, wherein the database comprises the original IDs which are associated with each other and the association relation between the original IDs which are associated with each other and the identification information of the system which is identical to .
In a third aspect, an embodiment of the present invention provides electronic devices, including a processor and a non-volatile memory storing computer instructions, where the computer instructions, when executed by the processor, cause the electronic device to perform the associate ID query method described in any of of the foregoing embodiments.
In a fourth aspect, an embodiment of the present invention provides storage media, where the storage media includes a computer program, and the computer program controls, when running, a computer device on which the storage media is located to execute the association ID query method described in any of the foregoing embodiments.
According to the association ID query method, the association ID query device, the electronic equipment and the storage medium provided by the embodiment of the invention, the original IDs which are mutually associated are stored in the database, the association relation between the original IDs which are mutually associated and the identification information of the same system is further obtained, then the identification information of the system which is associated with the original ID to be queried can be searched in the database according to the original ID to be queried, all the target original IDs which are associated with the identification information of the system can be searched in the database according to the identification information of the system , and all the searched target original IDs are used as the association IDs of the original IDs to be queried, so that the convenient query of all the association IDs is realized.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the embodiments will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present invention and therefore should not be considered as limiting the scope, and for those skilled in the art, other related drawings can be obtained according to the drawings without inventive efforts.
Fig. 1 is a block diagram of types of electronic devices according to an embodiment of the present invention.
Fig. 2 is a schematic flow chart of types of methods for querying an association ID according to an embodiment of the present invention.
Fig. 3 is another kinds of flow diagrams of the association ID query method according to the embodiment of the present invention.
Fig. 4 is a schematic flow chart of another methods for querying an association ID according to the embodiment of the present invention.
Fig. 5 is schematic diagrams of association IDs provided by the embodiment of the present invention.
Fig. 6 is another schematic diagrams of association IDs provided by the embodiment of the invention.
Fig. 7 is a schematic diagram of kinds of association relationships of association IDs provided in the embodiment of the present invention.
Fig. 8 is a schematic flow chart of another methods for querying an association ID according to the embodiment of the present invention.
Fig. 9 is another kinds of flow diagrams of the association ID query method according to the embodiment of the present invention.
Fig. 10 is a schematic diagram of associations between association IDs and identification information of a system according to an embodiment of the present invention.
Fig. 11 is a block diagram of kinds of blocks of an association ID query apparatus according to an embodiment of the present invention.
Icon: 100-an electronic device; 10-associate ID querying means; 11-a lookup module; 12-a processing module; 20-a memory; 30-a processor; 40-a communication unit.
Detailed Description
To further clarify the objects, aspects and advantages of embodiments of the present invention, reference will now be made in detail to the present embodiments of the invention as illustrated in the accompanying drawings, which are incorporated in this specification, and it is to be understood that the embodiments illustrated and described are some, but not all, of the embodiments of the invention.
Thus, the following detailed description of the embodiments of the present invention, presented in the figures, is not intended to limit the scope of the invention, as claimed, but is merely representative of selected embodiments of the invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that like reference numerals and letters refer to like items in the following figures, and thus once a item is defined in figures, it need not be further defined and explained by in subsequent figures.
In the description of the present invention, it should be noted that if the terms "upper", "lower", "inside", "outside", etc. indicate an orientation or a positional relationship based on that shown in the drawings or that the product of the present invention is used as it is, this is only for convenience of description and simplification of the description, and it does not indicate or imply that the device or the element referred to must have a specific orientation, be constructed in a specific orientation, and be operated, and thus should not be construed as limiting the present invention.
Moreover, the appearances of the terms "," "second," and the like, if any, are only used to distinguish one description from another and are not to be construed as indicating or implying relative importance.
It should be noted that the features of the embodiments of the present invention may be combined with each other without conflict.
With the increasing rise of digitization, more and more actions of consumers, such as advertising marketing actions, purchasing actions, social actions, etc., can be recorded in a collected and digitized form, but due to the independence of each domain, the original IDs of consumers recorded in logs of different domains are different, for example, advertising marketing action is based on International Mobile Equipment Identity (IMEI), advertising Identifier (IDFA), and Cookie (data stored on the user's local terminal) as the original ID of the consumer ( Identifier only), and purchasing action is based on a member number as the original ID of the consumer.
Without "user ID association," i.e., all IDs of a single consumer are not associated, an enterprise owner cannot concatenate consumer data of various fields, that is, cannot analyze the full-path behavior of a single consumer across IDs, thereby forming more accurate insights and policies. Thus, to facilitate analysis of full path behavior of a single consumer across domains, multiple original IDs of consumers are often associated.
At present, most ID data are relational data and are stored in a relational database, and the generation of ID association relation is related, relations between type IDs and other type IDs are established according to specific conditions, and the result is also relational data, so when the ID association data are inquired, the corresponding relation of the IDs can be obtained only based on fixed sequences, but in practical application, the ID association relation is complex and various, the sequence is complex and various, all the associated IDs cannot be conveniently obtained based on the fixed sequence, and the cross-domain analysis is carried out on the whole-path behavior of a single consumer.
Based on the above research, the embodiment of the present invention provides kinds of association ID query methods to improve the above problem.
Referring to fig. 1, the association ID query method provided in the embodiment of the present invention is applied to the electronic device 100 shown in fig. 1, and the electronic device 100 executes the association ID query method provided in the embodiment. In the embodiment, the electronic device 100 may be, but is not limited to, an electronic device 100 with a processing capability, such as a Personal Computer (PC), a notebook Computer, a Personal Digital Assistant (PDA), or a server.
The electronic device 100 comprises an association ID inquiry apparatus 10, a memory 20, a processor 30 and a communication unit 40, wherein the memory 20, the processor 30 and the communication unit 40 are directly or indirectly electrically connected with each other to realize data transmission or interaction, for example, the elements are directly electrically connected with each other through communication buses or signal lines, the association ID inquiry apparatus 10 comprises at least software functional modules which can be stored in the memory 20 in the form of software or Firmware (Firmware), and the processor 30 executes software programs and modules stored in the memory 20 to execute various functional applications and data processing.
The Memory 20 may be, but is not limited to, a Random Access Memory (RAM), a Read Only Memory (ROM), a Programmable Read-Only Memory (PROM), an Erasable Read-Only Memory (EPROM), an electrically Erasable Read-Only Memory (EEPROM), and the like.
The processor 30 may be an type integrated circuit chip having signal Processing capabilities, and the processor 30 may be a general purpose processor including a Central Processing Unit (CPU), a Network Processor (NP), and the like.
The communication unit 40 is configured to establish a communication connection between the electronic device 100 and another external device through a network, and perform data transmission through the network.
It is to be understood that the configuration shown in fig. 1 is merely exemplary, and that the electronic device 100 may include more or fewer components than shown in fig. 1, or have a different configuration than shown in fig. 1. The components shown in fig. 1 may be implemented in hardware, software, or a combination thereof.
Based on the architecture diagram of the electronic device 100, please refer to fig. 2, fig. 2 is a flowchart illustrating the association ID query method provided in this embodiment, which is executed by the electronic device 100 shown in fig. 1, and the flowchart shown in fig. 2 is described in detail below.
And S10, acquiring the original ID to be queried, and searching the identification information of the system associated with the original ID to be queried in a database according to the original ID to be queried.
And step S20, according to the system identification information, searching all target original IDs associated with the system identification information from the database, and taking all the searched target original IDs as the associated IDs of the original IDs to be inquired.
The database comprises the original IDs which are mutually associated and the association relation between the original IDs which are mutually associated and the identification information of the system of , so that after the original ID to be queried is obtained, the identification information of the system which is mutually associated with the original ID to be queried can be searched in the database according to the original ID to be queried, then all the target original IDs which are mutually associated with the identification information of the system can be searched in the database according to the identification information of the system , and all the searched target original IDs are all the original IDs which are mutually associated with the original ID to be queried, so that convenient query of all the associated IDs is realized, and further analysis of cross-channel behaviors of consumers is realized.
As optional embodiments, in order to improve query efficiency, the database provided by this embodiment is a Redis database, and the Redis database makes a quick response to a query requirement, thereby implementing a quick query of an original ID and identification information of the system .
As another optional embodiments, the embodiment may further employ a file storage system (e.g., a Hadoop distributed file system) to store the original IDs associated with each other and the association relationship between the original IDs associated with each other and the identification information of the system , or the embodiment may further employ an HDFS file system and a database to store the original IDs associated with each other and the association relationship between the original IDs associated with each other and the identification information of the system at the same time.
According to the association ID query method provided by this embodiment, the association relationship between the identification information of the system and the original IDs associated with each other is established, and then, according to the identification information of the system , all the associated original IDs can be quickly and conveniently found.
In an alternative embodiment, please refer to fig. 3 in combination, each original ID associated with each other in the database is obtained through steps S30 to S40.
Step S30, receiving at least ID binding information.
For example, when a user performs a WeChat registration, a mobile phone number is often filled in, and after binding a micro signal and the mobile phone number, the ID binding information in the following format is formed:
{"source":"register","time":"2019-01-01","status":"active","binding":[{"idType":"mobile_no","idValue":["138xxxx9237"]},{"idType":"open_id","idValue":["OPjxikdil02931"]}]}。
in this embodiment, each original ID included in each ID binding information is the original ID of the same consumer.
As optional embodiments, in order to reduce the amount of computation and improve the work efficiency, the original ID in the ID binding information provided in this embodiment may also be in a relationship corresponding to , that is, the ID binding information provided in this embodiment may be set to include only two corresponding original IDs, if a plurality of original IDs exist in the ID binding information, the plurality of original IDs are split into a relationship corresponding to , so as to form a plurality of pieces of sub-ID binding information, for example, if a certain ID binding information includes an original ID, an original ID b, and an original ID c, for convenience of computation, the original ID a, the original ID b, and the original ID c are split, the original ID a and the original ID b are corresponding, so as to form pieces of sub-ID binding information, the original ID a and the original ID c are corresponding, another pieces of sub-ID binding information is formed, and so on the basis of the sub-ID binding information in the subsequent computation process.
Step S40: and judging whether each original ID in the ID binding information is associated or not based on a graph calculation engine Gelly, and establishing an association relation between the associated original IDs to obtain the associated original IDs after the association relation is established.
In an optional embodiment, referring to fig. 4, the step of determining whether each original ID in each ID binding information is associated based on the graph computation engine Gelly, and establishing an association relationship between each associated original ID to obtain each original ID associated with each other after establishing the association relationship includes steps S41 to S42.
Step S41: and judging whether the same original ID exists in the ID binding information, and if so, judging that each original ID in the ID binding information with the same original ID is associated.
For example, as shown in fig. 5, th ID binding information includes a original ID and a original ID, second ID binding information includes c original ID and a original ID, and third ID binding information includes e original ID and f original ID, since all the th ID binding information includes a original ID, b original ID can be associated with c original ID through a original ID, and a original ID, b original ID and c original ID are determined to be associated with each other and not associated with e original ID and f original ID.
However, as shown in fig. 6, if the fourth ID binding information includes the a original ID and the e original ID, since the fourth ID binding information and the th ID binding information both include the a original ID, and the fourth ID binding information and the third ID binding information both include the e original ID, the e original ID can be respectively associated with the b original ID and the c original ID through the a original ID, and the f original ID can be respectively associated with the a original ID, the b original ID and the c original ID through the e original ID, and it is determined that the a original ID, the b original ID, the c original ID, the e original ID and the f original ID are associated with each other.
Step S42: and connecting the associated original IDs by lines by taking the associated original IDs as points to establish an association relationship to obtain the associated original IDs.
As shown in fig. 7, after obtaining the associated original IDs, the associated original IDs are connected by lines with the associated original IDs as points, and a mesh relationship diagram between the original IDs is constructed to establish an association relationship between the original IDs, so as to obtain the associated original IDs.
In this embodiment, the original IDs associated with each other after the association relationship is established are regarded as the original IDs of the same consumers.
After obtaining the original IDs associated with each other, please refer to fig. 8, the identification information of the system is obtained through steps S50 to S60.
And step S50, assigning values to original IDs in the associated original IDs to obtain the identification information of the original IDs.
For example, in the above exemplary ID binding information, the ID type (idType) of the mobile phone number is mobile _ no, the ID value (idValue) is the mobile phone number, the ID type (idType) of the micro signal is open _ ID, and the ID value (idValue) is the micro signal code.
Based on the ID value of each original ID, original IDs are arbitrarily selected from the associated original IDs, and the ID value of the original ID is assigned, and the operation result is the identification information of the original ID.
Step S60, the identification information is used as the system identification information of all the original IDs associated with each other, and the system identification information is associated with all the original IDs associated with each other.
After the identification information of original IDs is obtained, the identification information is used as the identification information of the system of all the associated original IDs, that is, the identification information of all the associated original IDs is the same, and the identification information of the system is associated with all the associated original IDs to form the association relationship between each original ID and the identification information of the system , so as to achieve the communication of a plurality of original IDs, and further obtain all the associated original IDs according to the identification information of the system .
After the association relationship between each original ID and the identification information of the system of the same is obtained, a standardized interface is provided to the outside, and then, the external service (user side) can obtain the identification information of the system corresponding to the original ID only by submitting original ID (original ID to be queried), and then all the original IDs associated with the original ID are obtained based on the identification information of the system , so that the quick query of the association ID is realized.
In the present embodiment, please refer to fig. 9 in combination, in practical applications, the original ID of the consumer may be generated continuously, and therefore, in order to ensure the timeliness of the identification information of the system , the method provided in the present embodiment further includes steps S70 to S80.
Step S70: and receiving new ID binding information, and judging whether the original ID in the new ID binding information is associated with each original ID which is associated with each other.
And step S80, if the new ID binding information is associated, establishing the association relationship between the original ID in the new ID binding information and the original IDs associated with each other, and updating the association relationship between the original IDs associated with each other and the identification information of the same system.
After the consumer generates new original IDs, new ID binding information is generated , similarly, after the generated new ID binding information also includes at least two original ID., after receiving the new ID binding information, it is determined whether the original ID in the new ID binding information is associated with each original ID associated with each other, that is, it is determined whether the same original ID exists in the new ID binding information as each original ID associated with each other, if the same original ID exists, it is determined that the original ID in the new ID binding information is associated with each original ID associated with each other, then an association relationship between the original ID in the new ID binding information and each original ID associated with each other is established, and meanwhile, the association relationship between each original ID associated with the system identification information is updated.
For example, as shown in fig. 10, a original ID, b original ID, c original ID, e original ID and f original ID are associated with each other, the system identification information is M, the new ID binding information includes a original ID and h original ID, and since the new ID binding information and the new ID binding information in each of the associated original IDs all include a original ID, it is determined that the original ID in the new ID binding information is associated with each of the associated original IDs, that is, the a original ID, b original ID, c original ID, e original ID, f original ID and h original ID are associated with each other, and meanwhile, the system identification information M is associated with the h original ID, the association relationship between the system identification information M and the h original ID is increased, and further, the association relationship between each of the associated original ID and the system identification information M is updated.
Optionally, in this embodiment, a message queue, for example, the message queue Kafka, is adopted to update the association relationship between each original ID and the identification information of the system and the system in a stream processing manner.
Optionally, in this embodiment, if a certain original ID after the association relationship is established needs to be unbound, only the original ID needs to be unbound separately and stored in another table in the database, and other original IDs in the association relationship are still associated with each other, and other original IDs in the association relationship are still associated with the corresponding identification information of the system .
In practical applications, because the data size of the received ID binding information is large, in order to reduce the calculation amount and improve the accuracy of data processing, before determining whether each original ID in each piece of ID binding information is associated, the received ID binding information needs to be filtered to remove invalid ID binding information.
Specifically, each piece of ID binding information further includes information corresponding to each original ID, and each piece of ID binding information is filtered based on a set condition according to the information corresponding to each original ID.
The information corresponding to each original ID included in each ID binding information may be time when the original ID is generated, a source of the original ID, and the like, and the setting condition is set based on the information corresponding to each original ID, and may be a time filtering condition, or a source filtering condition, and the like, for example, the setting condition is a time filtering condition, and the time limit is 2019, month 1 and day, the original ID generated before 2019, month 1 and day is filtered, and the original ID generated after 2019, month 1 and day is retained, that is, the ID binding information generated after 2019, month 1 and day is retained, so that filtering of invalid ID binding information is realized, and accuracy of data processing is improved.
Meanwhile, the correlation ID query method provided by the embodiment establishes the correlation between the original IDs correlated with the identification information of the system in a batch processing mode, and updates the correlation between the original IDs correlated with the identification information of the system in a stream processing mode, thereby ensuring the timeliness of the identification information of the system .
In addition, the association ID query method provided in this embodiment is based on a distributed architecture, and is easier to expand by implementing establishment and storage of association relationships between the identification information of the system and the original IDs associated with each other.
On the basis, please refer to fig. 11 in combination, the embodiment further provides kinds of association ID query devices 10, which include a search module 11 and a processing module 12.
The search module 11 is configured to obtain an original ID to be queried, and search, according to the original ID to be queried, identification information of a system associated with the original ID to be queried in a database.
The processing module 12 is configured to search all target original IDs associated with the system identification information from the database according to the system identification information, and use all the searched target original IDs as association IDs of the original IDs to be queried, where the database includes the original IDs associated with each other and association relationships between the original IDs associated with each other and the identification information of the system of .
It can be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working process of the above-described association ID query apparatus 10 may refer to the corresponding process in the foregoing method, and will not be described in too much detail herein.
On the basis, the embodiment further provides electronic devices, including a processor and a non-volatile memory storing computer instructions, where the computer instructions, when executed by the processor, the electronic devices execute the association ID query method.
On the basis of the above, this embodiment further provides storage media, where the storage media include a computer program, and the computer program controls, when running, a computer device on which the storage media are located to execute the above-mentioned association ID query method.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the electronic device and the storage medium described above may refer to the corresponding processes in the foregoing method, and will not be described in too much detail herein.
In summary, according to the association ID query method, apparatus, electronic device and storage medium provided in this embodiment, by storing the original IDs associated with each other and the association relationship between each original ID associated with each other and the identification information of the system of in the database, after obtaining the original ID to be queried, the system identification information associated with the original ID to be queried may be searched in the database according to the original ID to be queried, all the target original IDs associated with the identification information of the system may be searched in the database according to the identification information of the system , and all the target original IDs found may be used as the association IDs of the original ID to be queried, so that convenient query of all the association IDs is achieved, and the full-path behavior of a single consumer may be analyzed across fields more easily.
The above description is only for the specific embodiment of the present invention, but the scope of the present invention is not limited thereto, and any changes or substitutions that can be easily conceived by those skilled in the art within the technical scope of the present invention are included in the scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the appended claims.
Claims (10)
1, A method for querying association ID, the method comprises:
acquiring an original ID to be queried, and searching identification information of a system associated with the original ID to be queried in a database according to the original ID to be queried;
and searching all target original IDs associated with the identification information of the system from the database according to the identification information of the system , and taking all the searched target original IDs as association IDs of the original IDs to be inquired, wherein the database comprises the original IDs which are associated with each other and the association relation between the original IDs which are associated with each other and the identification information of the system which is .
2. The associate ID query method of claim 1, wherein each original ID associated with each other in the database is obtained by the following steps;
receiving at least ID binding information, wherein each ID binding information at least comprises two different original IDs;
and judging whether each original ID in the ID binding information is associated or not based on a graph calculation engine Gelly, and establishing an association relation between the associated original IDs to obtain the associated original IDs after the association relation is established.
3. The method according to claim 2, wherein the step of determining whether each original ID in each ID binding information is associated based on a graph computation engine Gelly, establishing an association relationship between the associated original IDs, and obtaining each original ID associated with each other after the association relationship is established, comprises:
judging whether the same original ID exists in the ID binding information or not, and if so, judging that the original IDs in the ID binding information with the same original ID are associated;
and connecting the associated original IDs by lines by taking the associated original IDs as points to establish an association relationship to obtain the associated original IDs.
4. The associate ID query method of claim 3, wherein said system identification information is obtained by:
assigning original IDs in the correlated original IDs to obtain identification information of the original IDs;
the identification information is taken as the system identification information of all the original IDs associated with each other, and the system identification information is associated with all the original IDs associated with each other.
5. The method as claimed in claim 4, wherein the step of assigning original IDs of the associated original IDs to obtain the identification information of the original IDs comprises:
and on the basis of a hash algorithm, carrying out hash operation on original ID values in the correlated original IDs to obtain the identification information of the original ID.
6. The associate ID query method of claim 4, further comprising:
receiving new ID binding information, and judging whether an original ID in the new ID binding information is associated with each original ID which is associated with each other;
and if the new ID binding information is associated with the original ID, establishing the association relationship between the original ID in the new ID binding information and the associated original IDs, and updating the association relationship between the associated original IDs and the identification information of the same and .
7. The method of claim 2, wherein each ID binding information further includes information corresponding to each original ID; before determining whether each original ID in each ID binding information is associated, the method further includes:
and filtering the ID binding information based on set conditions according to the information corresponding to each original ID.
8, kinds of correlation ID inquiry device, characterized in that, the device includes a search module and a processing module;
the searching module is used for acquiring an original ID to be queried and searching the identification information of the system associated with the original ID to be queried in a database according to the original ID to be queried;
the processing module is used for searching all target original IDs associated with the system identification information from the database according to the system identification information, taking all the searched target original IDs as association IDs of the original IDs to be inquired, wherein the database comprises the original IDs which are associated with each other and the association relation between the original IDs which are associated with each other and the identification information of the system which is identical to .
An electronic device of , comprising a processor and a non-volatile memory having computer instructions stored thereon, wherein when the computer instructions are executed by the processor, the electronic device performs the associate ID query method of any of of claims 1-7.
Storage medium , wherein the storage medium comprises a computer program, and the computer program controls a computer device in which the storage medium is located to execute the association ID query method according to any of claims 1 to 7 when running.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910987223.4A CN110737675A (en) | 2019-10-16 | 2019-10-16 | Association ID query method and device, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910987223.4A CN110737675A (en) | 2019-10-16 | 2019-10-16 | Association ID query method and device, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110737675A true CN110737675A (en) | 2020-01-31 |
Family
ID=69269193
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910987223.4A Pending CN110737675A (en) | 2019-10-16 | 2019-10-16 | Association ID query method and device, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110737675A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112601215A (en) * | 2020-12-01 | 2021-04-02 | 深圳市和讯华谷信息技术有限公司 | Method and device for unifying equipment identifications |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107193894A (en) * | 2017-05-05 | 2017-09-22 | 北京小度信息科技有限公司 | Data processing method, individual discrimination method and relevant apparatus |
| CN109800335A (en) * | 2019-01-23 | 2019-05-24 | 平安科技（深圳）有限公司 | Generation method, device, computer equipment and the storage medium of enterprise's map |
-
2019
- 2019-10-16 CN CN201910987223.4A patent/CN110737675A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107193894A (en) * | 2017-05-05 | 2017-09-22 | 北京小度信息科技有限公司 | Data processing method, individual discrimination method and relevant apparatus |
| CN109800335A (en) * | 2019-01-23 | 2019-05-24 | 平安科技（深圳）有限公司 | Generation method, device, computer equipment and the storage medium of enterprise's map |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112601215A (en) * | 2020-12-01 | 2021-04-02 | 深圳市和讯华谷信息技术有限公司 | Method and device for unifying equipment identifications |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107844634B (en) | Modeling method of multivariate general model platform, electronic equipment and computer readable storage medium | |
| CN111046237B (en) | User behavior data processing method and device, electronic equipment and readable medium | |
| CN103544220B (en) | Using recommendation method and apparatus | |
| CN111831548A (en) | Method and device for drawing dependency relationship topological graph | |
| CN108170578B (en) | Log collection method and device | |
| CN113364853A (en) | Business service system, business request method and gateway equipment | |
| CN109669980B (en) | Cross-database access method and device for data | |
| CN113434910A (en) | Business data chaining method and device | |
| CN108415925B (en) | Electronic device, data call log generation and query method and storage medium | |
| CN112579898A (en) | Enterprise information management method and device and server | |
| CN109981349A (en) | Call chain information query method and equipment | |
| CN110502692B (en) | Information retrieval method, device, equipment and storage medium based on search engine | |
| CN108920592B (en) | Database field association method and device | |
| CN115221119A (en) | File searching method and device, storage medium and electronic equipment | |
| CN110807050B (en) | Performance analysis method, device, computer equipment and storage medium | |
| CN111221742A (en) | Test case updating method and device, storage medium and server | |
| CN110737675A (en) | Association ID query method and device, electronic equipment and storage medium | |
| CN114238767A (en) | Service recommendation method and device, computer equipment and storage medium | |
| CN106790380A (en) | Data reporting method and device | |
| CN110427538B (en) | Data query method, data storage method, data query device, data storage device and electronic equipment | |
| CN113918835A (en) | Item reminding method, item reminding system, terminal device and storage medium | |
| CN116933316A (en) | Method and device for analyzing consistency of intelligent terminal application sensitive behavior and privacy policy | |
| CN110874365A (en) | Information query method and related equipment thereof | |
| CN108377357B (en) | Visual platform call method and device | |
| CN110796532B (en) | Credit risk processing method, terminal equipment, server and system |
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: 20200131 |
|
| RJ01 | Rejection of invention patent application after publication |