Data query method, device, equipment and storage medium

Abstract

The present application provides a data query method, device, equipment and storage medium. It relates to the field of data processing technology. The method includes: obtaining a query request for user portrait data of M corporate organizations; the query request includes the identification of the M corporate organizations and the type of portrait label, the type of portrait label includes an independent portrait label or a shared portrait label, the independent portrait label is a portrait label owned by one corporate organization in the corporate group, and the shared portrait label is a portrait label owned by at least two corporate organizations in the corporate group; M is an integer greater than or equal to 1; if the type of the portrait label is a shared portrait label, the shared portrait data of users of the M corporate organizations is obtained and output according to the identification of the M corporate organizations and the first user information table; the first user information table includes the identification of users of multiple corporate organizations and the user portrait data corresponding to the shared portrait labels of users of multiple corporate organizations. Thereby improving the query efficiency of user portrait data.

Description

Technical Field

[0001] The present application relates to data processing technology, and in particular to a data query method, device, equipment and storage medium. Background Art

[0002] In the era of big data, corporate groups also have the need to store and query user portrait data.

[0003] At present, each independent legal entity within an enterprise group stores user portrait data on its own. When it is necessary to query the user portrait data of multiple independent legal entities, it is necessary to query the user portrait data of multiple independent legal entities separately, which makes the query efficiency of the enterprise group for user portrait data low. Summary of the invention

[0004] The present application provides a data query method, apparatus, device and storage medium to solve the problem of low query efficiency of enterprise groups on user portrait data.

[0005] In a first aspect, the present application provides a data query method, comprising: obtaining a query request for user portrait data of M corporate organizations; the query request includes the identifiers of the M corporate organizations and the type of portrait tags, the type of portrait tags includes independent portrait tags or shared portrait tags, the independent portrait tag is a portrait tag owned by one corporate organization in the corporate group, and the shared portrait tag is a portrait tag owned by at least two corporate organizations in the corporate group; M is an integer greater than or equal to 1; determining whether the type of the portrait tag is a shared portrait tag or an independent portrait tag; if the type of the portrait tag is a shared portrait tag, querying the user portrait data according to the identifiers of the M corporate organizations and a first user information table, obtaining and outputting the shared portrait data of the users of the M corporate organizations; the first user information table includes the identifiers of users of multiple corporate organizations and the user portrait data corresponding to the shared portrait tags of users of multiple corporate organizations.

[0006] In one implementation, the query of user portrait data is performed based on the identifiers of the M enterprise organizations and the first user information table to obtain shared portrait data of users of the M enterprise organizations, including: determining a user identification set of each of the M enterprise organizations based on the identifiers of the M enterprise organizations and a preset user relationship mapping table; the user relationship mapping table includes identifiers of multiple enterprise organizations and an identifier of at least one user corresponding to each enterprise organization; deduplicating the user identification sets of the M enterprise organizations based on identical user identifiers in the user identification sets of the M enterprise organizations to obtain deduplicated M user identification sets; querying user portrait data in the first user information table based on the identifiers of users in the deduplicated M user identification sets to obtain shared portrait data of the M enterprise organizations.

[0007] In one implementation, the query of user portrait data based on the identifiers of users of the M enterprise organizations and the first user information table to obtain shared portrait data of the M enterprise organizations includes: determining the user identifier set of each of the M enterprise organizations based on the identifiers of the M enterprise organizations and a preset user relationship mapping table; determining whether the value of M is a preset value; if the value of M is a non-preset value, deduplicating the user identifier sets of the M enterprise organizations based on the same user identifiers in the user identifier sets of the M enterprise organizations to obtain deduplicated M user identifier sets, and querying user portrait data in the first user information table based on the identifiers of users in the deduplicated M user identifier sets to obtain shared portrait data of the M enterprise organizations; if the value of M is a preset value, querying user portrait data in the first user information table based on the identifiers of users in the M user identifier sets to obtain shared portrait data of the M enterprise organizations.

[0008] In one implementation, the method also includes: obtaining a first portrait request for portraits of users of each corporate organization within a corporate group; the first portrait request includes portrait data corresponding to a shared portrait tag of each corporate organization and a user identifier; and generating the first user information table based on the identifier of the user of each corporate organization and the portrait data corresponding to the shared portrait tag.

[0009] In one implementation, the method also includes: if the type of the portrait tag is an independent portrait tag, querying the user portrait data based on the identifier of each enterprise organization in the M enterprise organizations, the identifier of the user of each enterprise organization and the second user information table of each enterprise organization, obtaining and outputting the independent portrait data of the users of the M enterprise organizations; the second user information table of each enterprise organization includes the identifier of each enterprise organization and the identifier of the user of each enterprise organization and the user portrait data corresponding to the independent portrait tag of the user of each enterprise organization.

[0010] In one implementation, the method also includes: obtaining a second portrait request for portraiting users of each corporate organization within the corporate group; the second portrait request includes portrait data corresponding to the independent portrait tags of each corporate organization, the identification of each corporate organization and the identification of the user; and generating the first user information table of each corporate organization based on the portrait data corresponding to the independent portrait tags of each corporate organization, the identification of each corporate organization and the identification of the user.

[0011] In a second aspect, the present application provides a data query device, comprising: an acquisition module, used to obtain a query request for user portrait data of M corporate organizations; the query request includes the identifiers of the M corporate organizations and the type of portrait tags, the type of portrait tags includes an independent portrait tag or a shared portrait tag, the independent portrait tag is a portrait tag owned by an corporate organization in an enterprise group, and the shared portrait tag is a portrait tag owned by at least two corporate organizations in the enterprise group; M is an integer greater than or equal to 1; a determination module, used to determine whether the type of the portrait tag is a shared portrait tag or an independent portrait tag; a query module, used to query the user portrait data according to the identifiers of the M corporate organizations and a first user information table when the type of the portrait tag is a shared portrait tag, to obtain and output the shared portrait data of the users of the M corporate organizations; the first user information table includes the identifiers of users of multiple corporate organizations and the user portrait data corresponding to the shared portrait tags of users of multiple corporate organizations.

[0012] In a third aspect, the present application provides an electronic device, comprising: a processor, and a memory communicatively connected to the processor; the memory stores computer-executable instructions; the processor executes the computer-executable instructions stored in the memory to implement the method described in the first aspect.

[0013] In a fourth aspect, the present application provides a computer-readable storage medium, wherein the computer-readable storage medium stores computer-executable instructions, and when the computer-executable instructions are executed by a processor, they are used to implement the method described in the first aspect.

[0014] In a fifth aspect, the present application provides a computer program product, including a computer program, which implements the method described in the first aspect when executed by a processor.

[0015] The data query method, apparatus, device and storage medium provided in the embodiments of the present application obtain a query request for user portrait data of M enterprise organizations; the query request includes the identifiers of the M enterprise organizations and the type of portrait tag, the type of portrait tag includes an independent portrait tag or a shared portrait tag, the independent portrait tag is a portrait tag owned by one enterprise organization in the enterprise group, and the shared portrait tag is a portrait tag owned by at least two enterprise organizations in the enterprise group; M is an integer greater than or equal to 1; it is determined whether the type of the portrait tag is a shared portrait tag or an independent portrait tag; if the type of the portrait tag is a shared portrait tag, the user portrait data is queried according to the identifiers of the M enterprise organizations and the first user information table, and the shared portrait data of the users of the M enterprise organizations is obtained and output; the first user information table includes the identifiers of users of multiple enterprise organizations and the user portrait data corresponding to the shared portrait tags of users of multiple enterprise organizations. Since portrait tags are distinguished and a first user information table is set for shared portrait tags, the first user information table includes the identifications of users of multiple enterprise organizations and user portrait data corresponding to the shared portrait tags of users of multiple enterprise organizations. It can uniformly store the user portrait data corresponding to the shared portrait tags of multiple enterprise organizations and realize unified query, thereby reducing the number of queries and improving query efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and, together with the description, serve to explain the principles of the present application.

[0017] Figure 1 A schematic diagram of an application scenario provided in an embodiment of the present application;

[0018] Figure 2 A data query method process provided in the embodiment of the present application Figure 1 ;

[0019] Figure 3 A data query method process provided in the embodiment of the present application Figure 2 ;

[0020] Figure 4 A data query method process provided in the embodiment of the present application Figure 3 ;

[0021] Figure 5 A data query method process provided in the embodiment of the present application Figure 4 ;

[0022] Figure 6 A schematic diagram of the structure of a data query device provided in an embodiment of the present application;

[0023] Figure 7 A schematic diagram of the structure of an electronic device provided in an embodiment of the present application.

[0024] The above drawings have shown clear embodiments of the present application, which will be described in more detail later. These drawings and text descriptions are not intended to limit the scope of the present application in any way, but to illustrate the concept of the present application to those skilled in the art by referring to specific embodiments. DETAILED DESCRIPTION

[0025] Exemplary embodiments will be described in detail herein, examples of which are shown in the accompanying drawings. When the following description refers to the drawings, the same numbers in different drawings represent the same or similar elements unless otherwise indicated. The implementations described in the following exemplary embodiments do not represent all implementations consistent with the present application. Instead, they are merely examples of devices and methods consistent with some aspects of the present application as detailed in the appended claims.

[0026] Terminology explanation:

[0027] Multiple legal entities: refers to the existence of multiple independent corporate legal entities within a corporate group.

[0028] User portrait: refers to the label data generated by using big data technology based on the user's identity information, account information, transaction information, etc., which can reflect the user's basic attributes, consumption habits, credit risk and other information.

[0029] In the context of the big data era, user information is flooding the Internet. Abstracting each specific information of a user into a label and using these labels to concretize the user's image can provide users with targeted services.

[0030] With the development of information technology and big data, all industries are gradually implementing big data application systems. In the case of multiple independent legal entities within a group organization, how to uniformly build, store and apply user data within the enterprise to reduce the overall construction cost of the group while achieving mutual isolation of data applications between legal entities has become an important issue that needs to be solved.

[0031] Figure 1 A schematic diagram of an application scenario provided by an embodiment of the present application. Figure 1 As shown, the electronic device 11 receives a query request for user portrait data, and queries the user portrait data in the database server 12 according to the query request, and returns the query result of the user portrait data.

[0032] In the related technology, each independent legal entity within an enterprise group has an independent front-end page, database, and physical resources. In actual applications, when it is necessary to query the user portrait data of all enterprise organizations under the group, it is necessary to enter the query system of each enterprise organization respectively, enter the query conditions, and then obtain the user portrait data of each enterprise organization. For example, when it is necessary to query the male users of all enterprise organizations under the group, it is necessary to enter the query system of each enterprise organization respectively, enter the query conditions of male users respectively, and obtain the query results of male users of each enterprise organization. This method has the problem of a large number of queries and low query efficiency.

[0033] In response to the above-mentioned technical problems, the inventor of the present application proposed the following technical concept: in response to a query request for shared portrait data of multiple enterprise organizations within an enterprise group, a query is performed from a first user information table storing the shared portrait data of multiple enterprise organizations. The first user information table includes the identifiers of users of multiple enterprise organizations and user portrait data corresponding to the shared portrait tags of users of multiple enterprise organizations, thereby achieving unified storage and unified query and improving data query efficiency.

[0034] The technical solution of the present application and how the technical solution of the present application solves the above-mentioned technical problems are described in detail below with specific embodiments. The following specific embodiments can be combined with each other, and the same or similar concepts or processes may not be repeated in some embodiments. The embodiments of the present application will be described below in conjunction with the accompanying drawings.

[0035] Figure 2 A data query method process provided in the embodiment of the present application Figure 1 .like Figure 2 As shown, the method comprises the following steps:

[0036] S201. A query request for obtaining user portrait data of M enterprise organizations; the query request includes the identifiers of the M enterprise organizations and the types of portrait tags, the types of portrait tags include independent portrait tags or shared portrait tags, an independent portrait tag is a portrait tag owned by one enterprise organization in the enterprise group, and a shared portrait tag is a portrait tag owned by at least two enterprise organizations in the enterprise group; M is an integer greater than or equal to 1.

[0037] The execution subject of the method of this embodiment may be a server.

[0038] The M corporate organizations in this embodiment refer to M independent legal entities within the corporate group. Query conditions can be entered through the query page for user portrait data to generate a query request for user portrait data. Exemplarily, options for all corporate organizations within the corporate group, as well as options for independent portrait data and shared portrait data can be displayed through the query page. When the user selects the options of M corporate organizations and independent portrait data from the options of all corporate organizations within the corporate group displayed on the query page, and clicks the "Confirm" button, a query request for independent portrait data of the M corporate organizations within the corporate group is generated and sent to the server. Accordingly, the server receives the query request for independent portrait data of the M corporate organizations within the corporate group to obtain the query request for user portrait data of the M corporate organizations.

[0039] Optionally, the type of the portrait tag can be determined according to the number of corporate organizations in the enterprise group that have the portrait tag. Specifically, if the number of corporate organizations in the enterprise group that have the portrait tag is greater than a preset number, the type of the portrait tag is determined to be a shared portrait tag; if the number of corporate organizations in the enterprise group that have the portrait tag is less than or equal to the preset number, the type of the portrait tag is an independent portrait tag. Optionally, the preset number can be 1, that is, when one corporate organization in the enterprise group has a portrait tag, the portrait tag is an independent portrait tag. When at least two corporate organizations in the enterprise group have the same portrait tag, the portrait tag is a shared portrait tag. The shared portrait tag can be the user's name, gender, age, height, weight, ethnicity, etc. For example, when a user opens an account in only one of the corporate organizations in the enterprise group, the account category, account balance information, account opening date, account status information, etc. are independent portrait tags of the corporate organization. When a user opens an account in at least two corporate organizations in the enterprise group, the account category, account balance information, account opening date, account status information, etc. are shared portrait tags of the corporate organization.

[0040] S202: Determine whether the type of the portrait tag is a shared portrait tag or an independent portrait tag.

[0041] S203. If the type of the portrait tag is a shared portrait tag, the user portrait data is queried based on the identifiers of the M enterprise organizations and the first user information table to obtain and output the shared portrait data of the users of the M enterprise organizations; the first user information table includes the identifiers of users of multiple enterprise organizations and the user portrait data corresponding to the shared portrait tags of users of multiple enterprise organizations.

[0042] Optionally, querying user portrait data according to the identifiers of the M enterprises and organizations and the first user information table to obtain shared portrait data of users of the M enterprises and organizations includes:

[0043] Step a1: Determine a user identification set of each enterprise organization in the M enterprise organizations according to the identifications of the M enterprise organizations and a preset user relationship mapping table.

[0044] Step a2: query the user portrait data according to the user identification set of M enterprises and the first user information table to obtain the shared portrait data of the M enterprises. The user relationship mapping table includes the identifications of multiple enterprises and the identification of at least one user corresponding to each enterprise.

[0045] Exemplarily, the format of the user relationship mapping table is shown in Table 1 below:

[0046] Table 1 User relationship mapping table

[0047] Corporate logo User's ID

[0048] Table 1 includes the IDs of all users of all enterprise organizations within the enterprise group, where "enterprise organization ID + user ID" is the main keyword.

[0049] According to the identifications of the M enterprise organizations, the identifications of the multiple enterprise organizations in Table 1, and the identification of at least one user corresponding to each enterprise organization, a user identification set of each enterprise organization in the M enterprise organizations can be screened out. The user identification set of each enterprise organization includes the identification of at least one user of each enterprise organization.

[0050] Among them, Table 1 is intended to set up a data model for the situation where a user has some portrait values, or a customer has some portrait data under a certain enterprise organization of the enterprise group, but no portrait values ​​under other enterprise organizations, or when all portrait values ​​of a user do not exist and the total number of people in the M enterprise organizations of the enterprise group cannot be queried. Through Table 1, the total number of people in the M enterprise organizations of the enterprise group can be queried and returned.

[0051] Exemplarily, the format of the first user information table is shown in Table 2 below:

[0052] Table 2 First user information table

[0053] User's ID Shared image data 1 Shared image data 2 Shared image data 3

[0054] The data in Table 2 is shared among multiple corporate organizations, and its data model is {shared portrait unique identification number: shared portrait data 1, shared portrait data 2, shared portrait data 3, …}.

[0055] Furthermore, according to the user identification set of each enterprise organization in the M enterprise organizations, the query condition and Table 2, users in the M enterprise organizations that meet the query condition can be screened out.

[0056] Afterwards, the portrait data of the users of the M enterprises and organizations are returned to the electronic device. Optionally, when the portrait data of the users of the M enterprises and organizations are obtained, information can also be recommended to the user based on the portrait data of the users of the M enterprises and organizations.

[0057] This embodiment obtains a query request for user portrait data of M enterprise organizations; the query request includes the identifiers of the M enterprise organizations and the type of portrait tags, the type of portrait tags includes independent portrait tags or shared portrait tags, the independent portrait tags are portrait tags owned by one enterprise organization in the enterprise group, and the shared portrait tags are portrait tags owned by at least two enterprise organizations in the enterprise group; M is an integer greater than or equal to 1; it is determined whether the type of the portrait tag is a shared portrait tag or an independent portrait tag; if the type of the portrait tag is a shared portrait tag, the user portrait data is queried according to the identifiers of the M enterprise organizations and the first user information table, and the shared portrait data of the users of the M enterprise organizations is obtained and output; the first user information table includes the identifiers of the users of multiple enterprise organizations and the user portrait data corresponding to the shared portrait tags of the users of multiple enterprise organizations. Since the portrait tags are distinguished and the first user information table is set for the shared portrait tags, the first user information table includes the identifiers of the users of multiple enterprise organizations and the user portrait data corresponding to the shared portrait tags of the users of multiple enterprise organizations, which can uniformly store the user portrait data corresponding to the shared portrait tags of multiple enterprise organizations and realize unified query, thereby reducing the number of queries and improving the query efficiency.

[0058] In one or more embodiments of the present application, optionally, in step a2, querying user portrait data according to the user identification set of M enterprise organizations and the first user information table to obtain shared portrait data of the M enterprise organizations includes:

[0059] Step a2-11: based on the same user IDs in the user ID sets of the M enterprises and organizations, deduplicate the user ID sets of the M enterprises and organizations to obtain deduplicated M user ID sets.

[0060] Step a2-12: query the user portrait data in the first user information table according to the user's ID in the deduplicated set of M user IDs to obtain the shared portrait data of M enterprise organizations.

[0061] This step is to query the first user information table for the portrait data corresponding to the identifier of each user in the deduplicated set of M user identifiers, thereby obtaining the shared portrait data of users of M corporate organizations.

[0062] This embodiment can avoid repeated queries for the same user by deduplicating the identifiers of the same user in the M user identifier sets of M enterprise organizations, thereby further improving the query efficiency.

[0063] Among them, in the embodiments shown in steps a21-11 and a21-12, when the value of M is 1, the deduplication step will still be performed, resulting in an empty program run. To address this problem, in another optional embodiment of the present application, in step a2, the user portrait data is queried based on the user identification set of M enterprise organizations and the first user information table to obtain the shared portrait data of M enterprise organizations, which may also include:

[0064] Step a2-21, determine whether the value of M is a preset value.

[0065] Optionally, the preset value may be 1.

[0066] Step a2-22, if the value of M is a non-preset value, then based on the same user IDs in the user ID sets of the M enterprise organizations, the user ID sets of the M enterprise organizations are deduplicated to obtain M deduplicated user ID sets, and based on the IDs of the users in the deduplicated user ID sets, user portrait data is queried in the first user information table to obtain shared portrait data of the M enterprise organizations.

[0067] When the value of M is greater than 1, that is, the number of enterprise organizations in the query request is greater than 1, it is first necessary to deduplicate the user identification sets of the M enterprise organizations, and then perform data query based on the deduplicated results.

[0068] Step a2-23: If the value of M is a preset value, the user portrait data is queried in the first user information table according to the user's identifier in the M user identifier set to obtain the shared portrait data of the M enterprise organizations.

[0069] When the value of M is 1, data query can be performed directly based on the user identifiers in the M user identifier sets, eliminating the deduplication step, thereby further improving data query efficiency.

[0070] Figure 3 A data query method process provided in the embodiment of the present application Figure 2 .like Figure 3 As shown, the method comprises the following steps:

[0071] S301. Obtain a first portrait request for portraiting users of each enterprise organization within the enterprise group; the first portrait request includes portrait data corresponding to the shared portrait tags of each enterprise organization and the user's identifier.

[0072] Among them, when the first portrait request for user data of each enterprise organization within an enterprise group is received based on the shared portrait tag, an empty table is set up for the enterprise group to store the shared portrait data of users of each enterprise organization, that is, the portrait data corresponding to the shared portrait tags of users of each enterprise organization are stored uniformly for unified query.

[0073] S302. Generate a first user information table based on the identification of users of each enterprise organization and the portrait data corresponding to the shared portrait tag.

[0074] The first user information table is a table constructed based on enterprise groups, that is, one enterprise group corresponds to the same first user information table, and the user portrait data of the multiple enterprise organizations are all stored in the first user information table.

[0075] Exemplarily, according to whether the value corresponding to the user's identifier in the first user information table is unique, the first user information table may include the following Table 3 and Table 4:

[0076] Table 3 The first user information table with unique value corresponding to the user's identifier

[0077] User's ID Name gender age height weight nationality

[0078] In Table 3, the user's ID is a unique identification number for sharing portrait data among multiple enterprises and organizations, which serves as the primary keyword of the data model; name, gender, age, height, weight, and ethnicity are portraits at the user granularity, and only one record is stored for the basic information of a user in multiple enterprises and organizations.

[0079] Table 4 The first user information table whose value corresponding to the user's identifier is not unique

[0080] User's ID years Annual income Annual expenditure Annual tax

[0081] In Table 4, the user ID + year is the unique identification number for sharing portrait data among multiple corporate organizations, and serves as the primary keyword of the data model; annual income, annual expenditure, and annual tax are the user's portrait data at the year granularity, and at most one record is stored for each user each year.

[0082] Figure 4 A data query method process provided in the embodiment of the present application Figure 3 .like Figure 4 As shown, after step S203, the method of this embodiment includes the following steps:

[0083] S401. If the type of the portrait tag is an independent portrait tag, the user portrait data is queried based on the identifier of each enterprise organization in the M enterprise organizations, the identifier of the user of each enterprise organization and the second user information table of each enterprise organization, and the independent portrait data of the users of the M enterprise organizations are obtained and output; the second user information table of each enterprise organization includes the identifier of each enterprise organization and the identifier of the user of each enterprise organization and the user portrait data corresponding to the independent portrait tag of the user of each enterprise organization.

[0084] In this embodiment, each enterprise organization corresponds to a second user information table, and the second user information table corresponding to each enterprise organization can be directly associated with the identification of each enterprise organization, and then the independent portrait data of the user of each enterprise organization can be obtained according to the identification of the user of each enterprise organization and the corresponding second user information table. In this way, the mutual isolation of data applications among multiple enterprise organizations is ensured.

[0085] Figure 5 A data query method process provided in the embodiment of the present application Figure 4 .like Figure 5 As shown, the method comprises the following steps:

[0086] S501. Obtain a second portrait request for portraiting users of each enterprise organization within the enterprise group; the second portrait request includes portrait data corresponding to independent portrait tags of each enterprise organization, identifiers of each enterprise organization and identifiers of users.

[0087] S502. Generate a second user information table for each enterprise organization based on the portrait data corresponding to the independent portrait tag of each enterprise organization, the identification of each enterprise organization and the identification of the user.

[0088] The users of each enterprise organization refer to users who have business in each enterprise organization, and can be understood as the customer resources of each enterprise organization. For example, users who make deposits in each bank branch of the group are users of each bank branch.

[0089] Optionally, the portrait data of the users of each enterprise organization can be obtained according to the portrait data generation method. For example, according to the user data of the users of each enterprise organization and a preset label model, the user data of the users of each enterprise organization is labeled to obtain the label features of the users of each enterprise organization; according to the label features of the users of each enterprise organization, the portrait data of the users of each enterprise organization is generated.

[0090] Exemplarily, the format of the second user information table is shown in Table 5 below:

[0091] Table 5 Second user information table

[0092]

[0093] In Table 5, the enterprise organization's identifier is the enterprise's unique identification number, and a copy of the data is stored in the database for each enterprise organization. The data model of each enterprise organization is {independent portrait unique identification number: independent portrait data 1, independent portrait data 2, independent portrait data 3, ...}. Among them, if the value corresponding to the user's identifier is a unique value, the independent portrait unique identification number is determined based on the enterprise organization's identifier and the user's identifier; if the value corresponding to the user's identifier is a non-unique value, the independent portrait unique identification number is determined based on the enterprise organization's identifier, the enterprise organization's user identifier, and other fields set based on business needs.

[0094] Exemplarily, the second user information table in which the value corresponding to the user's identifier is a unique value may refer to the following Table 6:

[0095] Table 6 The second user information table with unique user value

[0096]

[0097] In Table 6, the enterprise organization ID + user ID is the unique identification number of the independent portrait of the enterprise organization, which serves as the primary keyword of the data model; user level, total assets, and total liabilities are the portraits of users at the enterprise organization granularity, and each user and each enterprise organization corresponds to at most one piece of portrait data.

[0098] The second user information table whose value corresponding to the user's identifier is not unique can refer to the following Table 7:

[0099] Table 7 The second user information table where the user value is not unique

[0100]

[0101] In Table 7, the enterprise organization ID + user ID + account number is the unique identification number of the independent portrait of the enterprise organization, which serves as the primary keyword of the data model; the account category, account balance, account opening date and account status are the user's portrait data at the enterprise organization + account granularity. Each user and each account under each enterprise organization corresponds to at most one piece of portrait data.

[0102] In the technical solution of this application, the collection, storage, use, processing, transmission, provision and disclosure of information such as financial data or user data involved shall comply with the provisions of relevant laws and regulations and shall not violate public order and good morals.

[0103] Based on the above method embodiment, Figure 6 This is a schematic diagram of the structure of a data query device provided in an embodiment of the present application. Figure 6As shown, the device includes: an acquisition module 61, a determination module 62 and a query module 63; wherein the acquisition module 61 is used to obtain a query request for user portrait data of M enterprise organizations; the query request includes the identifiers of the M enterprise organizations and the type of portrait tags, the type of portrait tags includes independent portrait tags or shared portrait tags, the independent portrait tags are portrait tags owned by one enterprise organization in the enterprise group, and the shared portrait tags are portrait tags owned by at least two enterprise organizations in the enterprise group; M is an integer greater than or equal to 1; the determination module 62 is used to determine whether the type of the portrait tag is a shared portrait tag or an independent portrait tag; the query module 63 is used to query the user portrait data according to the identifiers of the M enterprise organizations and the first user information table when the type of the portrait tag is a shared portrait tag, to obtain and output the shared portrait data of the users of the M enterprise organizations; the first user information table includes the identifiers of users of multiple enterprise organizations and the user portrait data corresponding to the shared portrait tags of users of multiple enterprise organizations.

[0104] In one possible implementation, the query module 63 is specifically used to: determine a user identification set of each of the M enterprise organizations based on the identifications of the M enterprise organizations and a preset user relationship mapping table; the user relationship mapping table includes identifications of multiple enterprise organizations and an identification of at least one user corresponding to each enterprise organization; deduplicate the user identification sets of the M enterprise organizations based on identical user identifications in the user identification sets of the M enterprise organizations to obtain deduplicated M user identification sets; query user portrait data in the first user information table based on the identifications of the users in the deduplicated M user identification sets to obtain shared portrait data of the M enterprise organizations.

[0105] In one possible implementation, the query module 63 is specifically used to: determine the user identification set of each of the M enterprise organizations based on the identifications of the M enterprise organizations and a preset user relationship mapping table; determine whether the value of M is a preset value; if the value of M is a non-preset value, deduplicate the user identification sets of the M enterprise organizations based on the same user identifications in the user identification sets of the M enterprise organizations to obtain deduplicated M user identification sets, and query user portrait data in the first user information table based on the identifications of the users in the deduplicated M user identification sets to obtain shared portrait data of the M enterprise organizations; if the value of M is a preset value, query user portrait data in the first user information table based on the identifications of the users in the M user identification sets to obtain shared portrait data of the M enterprise organizations.

[0106] In a possible implementation, the device also includes: a first generation module 64; an acquisition module 61, used to obtain a first portrait request for portraiting users of each corporate organization within the corporate group; the first portrait request includes portrait data corresponding to the shared portrait tags of the each corporate organization and the user's identifier; the first generation module 64, used to generate the first user information table based on the identifier of the user of each corporate organization and the portrait data corresponding to the shared portrait tag.

[0107] In one possible implementation, the query module 63 is specifically used to: if the type of the portrait tag is an independent portrait tag, query the user portrait data based on the identifier of each enterprise organization in the M enterprise organizations, the identifier of the user of each enterprise organization and the second user information table of each enterprise organization, obtain the independent portrait data of the users of the M enterprise organizations and output it; the second user information table of each enterprise organization includes the identifier of each enterprise organization and the identifier of the user of each enterprise organization and the user portrait data corresponding to the independent portrait tag of the user of each enterprise organization.

[0108] In a possible implementation, the device also includes: a second generation module 65; an acquisition module 61, used to obtain a second portrait request for portraiting users of each corporate organization within the corporate group; the second portrait request includes portrait data corresponding to the independent portrait tags of each corporate organization, the identification of each corporate organization and the identification of the user; the second generation module 65 is used to generate the first user information table of each corporate organization based on the portrait data corresponding to the independent portrait tags of each corporate organization, the identification of each corporate organization and the identification of the user.

[0109] The data query device provided in the embodiment of the present application can be used to execute the technical solution of the data query method in the above embodiment. Its implementation principle and technical effect are similar and will not be repeated here.

[0110] It should be noted that it should be understood that the division of the various modules of the above device is only a division of logical functions. In actual implementation, they can be fully or partially integrated into one physical entity, or they can be physically separated. And these modules can all be implemented in the form of software calling through processing elements; they can also be all implemented in the form of hardware; some modules can also be implemented in the form of software calling through processing elements, and some modules can be implemented in the form of hardware. In addition, all or part of these modules can be integrated together, or they can be implemented independently. The processing element here can be an integrated circuit with signal processing capabilities. In the implementation process, each step of the above method or each module above can be completed by an integrated logic circuit of hardware in the processor element or instructions in the form of software.

[0111] Figure 7This is a schematic diagram of the structure of an electronic device provided in an embodiment of the present application. Figure 7 As shown, the electronic device may include: a transceiver 71 , a processor 72 , and a memory 73 .

[0112] The processor 72 executes the computer execution instructions stored in the memory, so that the processor 72 executes the scheme in the above embodiment. The processor 72 can be a general-purpose processor, including a central processing unit CPU, a network processor (NP), etc.; it can also be a digital signal processor DSP, an application-specific integrated circuit ASIC, a field programmable gate array FPGA or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware components.

[0113] The memory 73 is connected to the processor 72 via a system bus and completes communication between them. The memory 73 is used to store computer program instructions.

[0114] The transceiver 71 can be used to obtain query requests for user portrait data of M corporate organizations, and output the portrait data of users of the M corporate organizations.

[0115] The system bus can be a peripheral component interconnect (PCI) bus or an extended industry standard architecture (EISA) bus, etc. The system bus can be divided into an address bus, a data bus, a control bus, etc. For ease of representation, only one thick line is used in the figure, but it does not mean that there is only one bus or one type of bus. The transceiver is used to realize the communication between the database access device and other computers (such as clients, read-write libraries, and read-only libraries). The memory may include random access memory (RAM) and may also include non-volatile memory.

[0116] The electronic device provided in the embodiment of the present application may be the server in the above embodiment.

[0117] An embodiment of the present application also provides a chip for executing instructions, which is used to execute the technical solution of the data query method in the above embodiment.

[0118] An embodiment of the present application further provides a computer-readable storage medium, in which computer instructions are stored. When the computer instructions are executed on a computer, the computer executes the technical solution of the data query method in the above embodiment.

[0119] An embodiment of the present application also provides a computer program product, which includes a computer program stored in a computer-readable storage medium. At least one processor can read the computer program from the computer-readable storage medium. When at least one processor executes the computer program, it can implement the technical solution of the data query method in the above embodiment.

[0120] Those skilled in the art will readily appreciate other embodiments of the present application after considering the specification and practicing the invention disclosed herein. The present application is intended to cover any modification, use or adaptation of the present application, which follows the general principles of the present application and includes common knowledge or customary techniques in the art that are not disclosed in the present application. The specification and examples are intended to be exemplary only, and the true scope and spirit of the present application are indicated by the following claims.

[0121] It should be understood that the present application is not limited to the precise structures that have been described above and shown in the drawings, and that various modifications and changes may be made without departing from the scope thereof. The scope of the present application is limited only by the appended claims.

Claims

1. A data query method, characterized in that: include: A query request to obtain user profile data of M enterprises and organizations; The query request includes the identifiers of the M enterprise organizations and the types of portrait tags, the types of portrait tags include independent portrait tags or shared portrait tags, the independent portrait tags are portrait tags owned by one enterprise organization in the enterprise group, and the shared portrait tags are portrait tags owned by at least two enterprise organizations in the enterprise group; M is an integer greater than or equal to 1; Determine whether the type of the portrait tag is a shared portrait tag or an independent portrait tag; If the type of the portrait tag is a shared portrait tag, the user portrait data is queried according to the identifiers of the M enterprise organizations and the first user information table, and the shared portrait data of the users of the M enterprise organizations is obtained and output; the first user information table includes the identifiers of users of multiple enterprise organizations and the user portrait data corresponding to the shared portrait tags of users of multiple enterprise organizations; The method further comprises: Obtaining a first portrait request for a user of each enterprise organization within the enterprise group; the first portrait request includes portrait data corresponding to a shared portrait tag of each enterprise organization and an identifier of the user; The first user information table is generated based on the identification of the users of each of the enterprise organizations and the portrait data corresponding to the shared portrait tags.

2. The method according to claim 1, characterized in that The querying of user portrait data according to the identifiers of the M enterprise organizations and the first user information table to obtain shared portrait data of users of the M enterprise organizations includes: Determine a user identification set of each of the M enterprise organizations according to the identifications of the M enterprise organizations and a preset user relationship mapping table; the user relationship mapping table includes identifications of multiple enterprise organizations and an identification of at least one user corresponding to each enterprise organization; According to the same user identifiers in the user identifier sets of the M enterprise organizations, deduplication of the user identifier sets of the M enterprise organizations is performed to obtain deduplication of the M user identifier sets; User portrait data is queried in the first user information table based on the user's identifier in the deduplicated set of M user identifiers to obtain shared portrait data of the M enterprise organizations.

3. The method according to claim 1, characterized in that The querying of user portrait data according to the identifiers of users of the M enterprises and organizations and the first user information table to obtain shared portrait data of the M enterprises and organizations includes: Determine a user identification set of each enterprise organization in the M enterprise organizations according to the identifications of the M enterprise organizations and a preset user relationship mapping table; Determine whether the value of M is a preset value; If the value of M is a non-preset value, then based on the same user identifiers in the user identifier sets of the M enterprise organizations, the user identifier sets of the M enterprise organizations are deduplicated to obtain deduplicated M user identifier sets, and based on the identifiers of the users in the deduplicated M user identifier sets, user portrait data is queried in the first user information table to obtain shared portrait data of the M enterprise organizations; If the value of M is a preset value, user portrait data is queried in the first user information table based on the user's identifier in the M user identifier set to obtain shared portrait data of the M enterprise organizations.

4. The method according to any one of claims 1 to 3, characterized in that: The method further comprises: If the type of the portrait tag is an independent portrait tag, the user portrait data is queried based on the identifier of each enterprise organization in the M enterprise organizations, the identifier of the user of each enterprise organization and the second user information table of each enterprise organization to obtain and output the independent portrait data of the users of the M enterprise organizations; the second user information table of each enterprise organization includes the identifier of each enterprise organization and the identifier of the user of each enterprise organization and the user portrait data corresponding to the independent portrait tag of the user of each enterprise organization.

5. The method according to claim 4, characterized in that The method further comprises: Obtain a second portrait request for portraits of users of each enterprise organization within the enterprise group; the second portrait request includes portrait data corresponding to independent portrait tags of each enterprise organization, identifiers of each enterprise organization, and identifiers of users; The first user information table of each enterprise organization is generated based on the portrait data corresponding to the independent portrait tag of each enterprise organization, the identifier of each enterprise organization and the identifier of the user.

6. A data query device, characterized in that: include: An acquisition module is used to obtain a query request for user portrait data of M enterprises and organizations; The query request includes the identifiers of the M enterprise organizations and the types of portrait tags, the types of portrait tags include independent portrait tags or shared portrait tags, the independent portrait tags are portrait tags owned by one enterprise organization in the enterprise group, and the shared portrait tags are portrait tags owned by at least two enterprise organizations in the enterprise group; M is an integer greater than or equal to 1; A determination module, used to determine whether the type of the portrait tag is a shared portrait tag or an independent portrait tag; A query module, for querying user portrait data according to the identifiers of the M enterprise organizations and the first user information table when the type of the portrait tag is a shared portrait tag, obtaining and outputting the shared portrait data of the users of the M enterprise organizations; the first user information table includes the identifiers of users of multiple enterprise organizations and the user portrait data corresponding to the shared portrait tags of the users of multiple enterprise organizations; The device also includes a first generating module, The acquisition module is also used to acquire a first portrait request for a user of each enterprise organization within the enterprise group; the first portrait request includes portrait data corresponding to the shared portrait tag of each enterprise organization and the user's identifier; The first generating module is used to generate the first user information table according to the identification of the users of each enterprise organization and the portrait data corresponding to the shared portrait tag.

7. An electronic device, characterized in that: include: A processor, and a memory communicatively connected to the processor; The memory stores computer-executable instructions; The processor executes the computer-executable instructions stored in the memory to implement the method according to any one of claims 1 to 5.

8. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer-executable instructions, which are used to implement the method according to any one of claims 1 to 5 when executed by a processor.

9. A computer program product, characterized in that The invention comprises a computer program, which implements the method according to any one of claims 1 to 5 when being executed by a processor.

Images