Advertisement information query method and device, computer equipment and storage medium

Abstract

The embodiment of the invention belongs to the field of financial science and technology, and relates to an advertisement information query method and device, computer equipment and a storage medium, and the method comprises the following steps: obtaining advertisement data query information; obtaining corresponding encryption state information according to the advertisement data query information; identifying an encryption key field corresponding to the encryption state information; according to the encrypted key field, respectively calling a corresponding first query component and a corresponding second query component to carry out data query to obtain effective advertisement query data and encrypted advertisement query data; and returning the effective advertisement query data and / or the encrypted advertisement query data to a user side corresponding to the data query information as advertisement information. According to the method and the device, encrypted and unencrypted advertisement information can be effectively, conveniently and quickly acquired, so that the query efficiency of the advertisement information is improved.

Description

Technical Field

[0001] The present application relates to the field of data processing technology, specifically to the field of financial technology, and in particular to an advertising information query method, device, computer equipment and storage medium. Background Art

[0002] With the deepening development of the market economy and the continuous innovation of the financial industry, the status of advertising business in the financial business field has become increasingly prominent and its proportion has continued to increase. This trend reflects the intensification of market competition and the high attention paid by financial service providers to brand image building, market expansion and customer attraction.

[0003] In the financial business, advertising has not only become an important channel for disseminating product information and promoting financial services, but also a key means to shape the brand image of financial institutions and enhance customer trust and loyalty. Through precise advertising strategies, financial institutions can effectively reach target customer groups, convey their core values ​​and service advantages, and thus stand out in the fierce market competition.

[0004] In the process of advertising planning, information such as advertising plans and advertising activities is generally stored in a database, and is extracted from the database only when the advertising plan or advertising activity needs to be adjusted or viewed. However, the traditional extraction method is to input certain advertising business query information in the advertising business system, such as a query string or a query address to make the advertising business system jump to the corresponding database page, and then traverse the query from the database through a specific advertising business name to find the corresponding advertising plan information or advertising activity information. However, the above method requires traversing the data stored in the entire database, which not only reduces the efficiency of data acquisition, but also because no encryption operation is performed during the entire process, it is easy to cause important advertising plan information or advertising activity information to be leaked, which brings certain security risks to the advertising business system. Summary of the invention

[0005] The purpose of the embodiments of the present application is to provide an advertisement information query method, apparatus, computer equipment and storage medium to solve the problem of being unable to query and obtain advertisement information safely and quickly.

[0006] In order to solve the above technical problems, the embodiment of the present application provides an advertisement information query method, which adopts the following technical solution:

[0007] Get advertising data query information;

[0008] Acquire corresponding encryption status information according to the advertisement data query information;

[0009] Identify an encryption key field corresponding to the encryption status information;

[0010] According to the encrypted key field, the corresponding first query component and the second query component are respectively called to perform data query to obtain valid advertisement query data and encrypted advertisement query data;

[0011] The effective advertisement query data and / or the encrypted advertisement query data are returned as advertisement information to the user terminal corresponding to the data query information.

[0012] Furthermore, the step of obtaining the advertisement data query information specifically includes:

[0013] Get advertisement query conditions;

[0014] Determine a target data table according to the semantic information of the advertisement query condition;

[0015] The data table identifier of the target data table is extracted, and the data table identifier and the advertisement query condition are packaged to generate the data query information.

[0016] Furthermore, the data query information includes an advertisement query condition and a data table identifier, and the step of acquiring corresponding encryption status information according to the advertisement data query information specifically includes:

[0017] Obtaining user terminal information corresponding to the advertisement query condition;

[0018] Obtaining a corresponding encryption status record table according to the data table identifier;

[0019] The encryption status information is obtained by searching the encryption status record table according to the user terminal information.

[0020] Furthermore, before the step of acquiring the corresponding encryption status record table according to the data table identifier, the following steps are also included:

[0021] Identify the data types stored in the preset data table, wherein the data types include text data, image data, and text image data;

[0022] Performing a first encryption operation on the text data and generating first encryption state information;

[0023] performing a second encryption operation on the image data and generating second encryption state information;

[0024] Performing a third encryption operation on the text image data and generating third encryption state information;

[0025] The first encryption state information, the second encryption state information, and the third encryption state information are integrated into the encryption state information, and recorded in the encryption state record table.

[0026] Furthermore, the step of identifying the encryption key field corresponding to the encryption status information specifically includes:

[0027] Obtaining the information field corresponding to the encryption status information;

[0028] Searching the encryption algorithm type, encryption mode, initialization vector, and key identifier in the information field according to a preset key field identification rule;

[0029] The encryption algorithm type, encryption mode, initialization vector and key identifier are used as the encryption key fields.

[0030] Furthermore, the step of respectively calling the corresponding first query component and the second query component to perform data query according to the encrypted key field to obtain valid advertisement query data and encrypted advertisement query data specifically includes:

[0031] Obtaining the field value corresponding to the encryption key field;

[0032] Identify whether the field value corresponding to the encryption key field is empty;

[0033] If the field value corresponding to the encrypted key field is empty, calling the first query component to perform data query according to the data query information to obtain the valid advertisement query data;

[0034] If the field value corresponding to the encrypted key field is not empty, the data query information is encrypted according to the encrypted key field to obtain encrypted data query information, and then the second query component is called to perform data query according to the encrypted data query information to obtain the encrypted advertising query data.

[0035] Furthermore, after the step of returning the effective advertisement query data and / or the encrypted advertisement query data as advertisement information to the user terminal corresponding to the data query information, the following steps are also included:

[0036] Obtaining first message generation information corresponding to the valid advertisement query data;

[0037] Writing the valid advertisement query data into a preset message template according to the first message generation information to obtain a first message;

[0038] Obtaining second message generation information corresponding to the encrypted advertisement query data;

[0039] The corresponding decryption component is called according to the second message generation information to decrypt the encrypted advertisement query data to obtain decrypted advertisement query data, and the decrypted advertisement query data is written into a preset message template to obtain a second message.

[0040] In order to solve the above technical problems, the embodiment of the present application further provides an advertisement information query device, which adopts the following technical solution:

[0041] A query information acquisition module, used to acquire advertisement data query information;

[0042] A status information acquisition module, used to acquire corresponding encryption status information according to the advertisement data query information;

[0043] A key field identification module, used to identify the encryption key field corresponding to the encryption status information;

[0044] A data query module, used to call the corresponding first query component and second query component respectively according to the encrypted key field to perform data query, and obtain valid advertisement query data and encrypted advertisement query data;

[0045] The information returning module is used to return the effective advertisement query data and / or the encrypted advertisement query data as advertisement information to the user terminal corresponding to the data query information.

[0046] In order to solve the above technical problems, the embodiment of the present application further provides a computer device, which adopts the following technical solution:

[0047] A computer device comprises a memory and a processor, wherein the memory stores computer-readable instructions, and the processor implements the steps of any one of the above advertising information query methods when executing the computer-readable instructions.

[0048] In order to solve the above technical problems, the embodiment of the present application further provides a computer-readable storage medium, which adopts the following technical solution:

[0049] A computer-readable storage medium stores computer-readable instructions, and when the computer-readable instructions are executed by a processor, the steps of the advertising information query method as described in any one of the above items are implemented.

[0050] Compared with the prior art, the embodiment of the present application has the following beneficial effects: the embodiment obtains advertisement data query information; obtains corresponding encryption status information according to the advertisement data query information; identifies the encryption key field corresponding to the encryption status information; calls the corresponding first query component and second query component to perform data query according to the encryption key field, and obtains valid advertisement query data and encrypted advertisement query data; returns the valid advertisement query data and / or the encrypted advertisement query data as advertisement information to the user end corresponding to the data query information. This effectively realizes convenient and rapid acquisition of encrypted and unencrypted advertisement information, so as to improve the query efficiency of advertisement information. BRIEF DESCRIPTION OF THE DRAWINGS

[0051] In order to more clearly illustrate the scheme in the present application, a brief introduction is given below to the drawings required for use in the description of the embodiments of the present application. Obviously, the drawings described below are some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0052] Figure 1 is an exemplary system architecture diagram to which the present application may be applied;

[0053] Figure 2 A flowchart of an embodiment of an advertisement information query method according to the present application;

[0054] Figure 3 yes Figure 2 A flowchart of a specific implementation of step S10;

[0055] Figure 4 yes Figure 2 A flowchart of a specific implementation of step S20;

[0056] Figure 5 yes Figure 2 A flowchart of a specific implementation of step S30;

[0057] Figure 6 yes Figure 2 A flowchart of a specific implementation of step S40;

[0058] Figure 7 is a structural schematic diagram of an embodiment of an advertisement information query device according to the present application;

[0059] Figure 8 It is a structural diagram of an embodiment of a computer device according to the present application. DETAILED DESCRIPTION

[0060] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as those commonly understood by technicians in the technical field of the present application; the terms used in the specification of the application herein are only for the purpose of describing specific embodiments and are not intended to limit the present application; the terms "including" and "having" and any variations thereof in the specification and claims of the present application and the above-mentioned drawings are intended to cover non-exclusive inclusions. The terms "first", "second", etc. in the specification and claims of the present application or the above-mentioned drawings are used to distinguish different objects, not to describe a specific order.

[0061] Reference to "embodiments" herein means that a particular feature, structure, or characteristic described in conjunction with the embodiments may be included in at least one embodiment of the present application. The appearance of the phrase in various locations in the specification does not necessarily refer to the same embodiment, nor does it refer to non-related or alternative embodiments that are mutually exclusive with other embodiments. It is explicitly and implicitly understood by those skilled in the art that the embodiments described herein may be combined with other embodiments.

[0062] In order to enable those skilled in the art to better understand the solution of the present application, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the accompanying drawings.

[0063] like Figure 1 As shown, the system architecture 100 may include terminal devices 101, 102, 103, a network 104 and a server 105. The network 104 is used to provide a medium for communication links between the terminal devices 101, 102, 103 and the server 105. The network 104 may include various connection types, such as wired, wireless communication links or optical fiber cables, etc.

[0064] Users can use terminal devices 101, 102, 103 to interact with server 105 through network 104 to receive or send messages, etc. Various communication client applications can be installed on terminal devices 101, 102, 103, such as web browser applications, shopping applications, search applications, instant messaging tools, email clients, social platform software, etc.

[0065] Terminal devices 101, 102, 103 can be various electronic devices with display screens and supporting web browsing, including but not limited to smart phones, tablet computers, e-book readers, MP3 players (Moving Picture Experts Group Audio Layer III), MP4 (Moving Picture Experts Group Audio Layer IV) players, laptop computers, desktop computers, etc.

[0066] The server 105 may be a server that provides various services, such as a background server that provides support for web pages displayed on the terminal devices 101 , 102 , and 103 .

[0067] It should be noted that the advertisement information query method provided in the embodiment of the present application is generally executed by a server, and accordingly, the advertisement information query device is generally arranged in the server.

[0068] It should be understood that Figure 1 The number of terminal devices, networks and servers in the embodiment is only for illustration. Any number of terminal devices, networks and servers may be provided according to implementation requirements.

[0069] Continue to refer Figure 2 , shows a flow chart of an embodiment of a method for querying advertisement information according to the present application. The method for querying advertisement information comprises the following steps:

[0070] Step S10, obtaining advertisement data query information;

[0071] In this embodiment, the advertisement data query information refers to the information based on which the user conducts advertisement information query, mainly including advertisement query conditions and data table identifiers. The advertisement query conditions may include advertisement type, advertisement delivery time, advertisement location, advertisement content keywords, advertisement theme name, etc. The data table identifier is the identifier information of the data table corresponding to the above advertisement information. The advertisement data query information comes from the user end. In specific implementation, the user end may generate the query information by inputting the query keyword on the system page of the advertisement business system.

[0072] Step S20, acquiring corresponding encryption status information according to the advertisement data query information;

[0073] In this embodiment, the encryption status information refers to the encryption status corresponding to the advertising information stored in the data table. The encryption status is divided into encrypted and unencrypted. The encryption status information corresponds to encrypted information and unencrypted information. The encryption status information is stored in the encryption status record table. The encryption status record table is generated by the system when the advertising information is stored in the data table. For example, when storing the car loan activity advertising information in the car loan advertising data table, first check whether the car loan advertising activity information is encrypted. The check can be performed by checking the corresponding log records of the car loan advertising activity information in the system. If encrypted, encrypted information is generated. If not encrypted, unencrypted information is generated, and the information identifiers of the encrypted information or unencrypted information and the car loan advertising activity information are stored in the car loan advertising data table. At the same time, the encryption status record table is also updated in real time when the encryption status of the advertising information stored in the data table by the system changes. The encryption status can be identified by checking the corresponding log records of the car loan advertising activity information in the system. For example, when the car loan activity advertising information in the car loan advertising data table changes from unencrypted to encrypted, the encryption status information corresponding to the car loan activity advertising information in the encryption status record table is changed to encrypted information; or, when the car loan activity advertising information in the car loan advertising data table changes from encrypted to unencrypted, the encryption status information corresponding to the car loan activity advertising information in the encryption status record table is changed to unencrypted information.

[0074] Step S30, identifying the encryption key field corresponding to the encryption status information;

[0075] In this embodiment, the encryption key field refers to the most critical field part in the encryption state information. The encryption key field includes the encryption algorithm type, encryption mode, initialization vector and key identifier. The encryption state information can be an information string about the encryption record. The encryption algorithm type refers to the type of encryption algorithm used in the encryption operation. The encryption mode refers to the mode of the encryption operation. The initialization vector is a random or pseudo-random bit string of a fixed size (usually a block size) used at the beginning of the encryption process. It is used together with the key to ensure that even if the same plaintext block is encrypted multiple times, different ciphertext blocks will be generated. This feature increases the complexity and security of the encryption process, especially when using block encryption modes (such as CBC, CFB, OFB and CTR). The key identifier is the identification information of the key corresponding to the encryption operation, which points to the corresponding key. The encryption state information may also include: encryption information identifier, encryption timestamp, encryption state, wherein the encryption information identifier is an identifier pointing to the advertising information, and the encryption information identifier can be used to determine which advertising information it corresponds to. The encryption timestamp is the specific time when the advertising information is encrypted. The encryption state corresponds to encrypted or unencrypted.

[0076] Step S40, calling the corresponding first query component and second query component respectively to perform data query according to the encrypted key field to obtain valid advertisement query data and encrypted advertisement query data;

[0077] In this embodiment, the first query component corresponds to valid advertising query data, which is unencrypted advertising information in the data table. The second query component corresponds to encrypted advertising query data, which is encrypted advertising query data in the data table. The first query component can be a SQL query component or a business logic query component, and the second query component can be an encrypted data query engine or a secure query API.

[0078] Step S50: returning the valid advertisement query data and / or the encrypted advertisement query data as advertisement information to the user terminal corresponding to the data query information.

[0079] In this embodiment, for the advertising data query information, the advertising information finally queried may include valid advertising query data or encrypted advertising query data, as well as valid advertising query data and encrypted advertising query data. Therefore, after the advertising information is returned to the user end, the data integrity of the valid advertising query data and / or the encrypted advertising query data can be verified. In this embodiment, the integrity of the valid advertising query data and / or the encrypted advertising query data during the data return process can be verified by a hash value. The verification by hash value includes the following steps: before the advertising information is returned to the user end, a hash value is generated for the valid advertising query data and / or the encrypted advertising query data (such as SHA-256, a hash value is a unique value of a fixed length, generated by the data content, and any slight change to the data will result in a significant change in the hash value); the generated hash value is sent to the user end together with the advertising information; after receiving the advertising information and the hash value, the user end can use the same hash algorithm to regenerate a hash value for the advertising information, and compare it with the received hash value. If the two match, the advertising information has not been tampered with during the transmission process. The above method is used to detect the data integrity of the advertising information during the transmission process of the advertising information returning to the user end.

[0080] This embodiment obtains advertisement data query information; obtains corresponding encryption status information according to the advertisement data query information; identifies the encryption key field corresponding to the encryption status information; respectively calls the corresponding first query component and second query component according to the encryption key field to perform data query, thereby obtaining valid advertisement query data and encrypted advertisement query data; and returns the valid advertisement query data and / or the encrypted advertisement query data as advertisement information to the user end corresponding to the data query information. This effectively realizes convenient and rapid acquisition of encrypted and unencrypted advertisement information, thereby improving the query efficiency of advertisement information. This embodiment can be applied to the financial advertising industry, such as insurance advertisements. Through the method of this embodiment, insurance advertisement information can be effectively queried, and the efficiency of querying insurance advertisement information can be improved.

[0081] Continue to refer Figure 3 In some optional implementations of this embodiment, step S10 includes the following steps:

[0082] Step S101, obtaining advertisement query conditions;

[0083] In this embodiment, the advertising query conditions may exist in various forms, such as text input, form selection, API request parameters, etc. The advertising query conditions usually include keywords, ranges, sorting requirements, etc. of the advertising information that the user wants to retrieve from the database, and the user inputs or imports the information on the system page of the advertising business system.

[0084] Step S102, determining a target data table according to the semantic information of the advertisement query condition;

[0085] In this embodiment, the target data table is determined according to the semantic information of the advertising query conditions through semantic analysis. The semantic analysis is implemented by natural language processing (NLP) technology. Natural language processing (NLP) includes text preprocessing, word embedding, syntactic analysis, semantic analysis, text generation and other functions. Among them, semantic analysis is the process of understanding the deep meaning of a sentence or text, including entity recognition, relationship extraction, sentiment analysis, etc. Semantic analysis is used to understand and parse the natural language text in the query conditions, so as to determine the target data table pointed to by the advertising query conditions.

[0086] Step S103: extracting the data table identifier of the target data table, and packaging the data table identifier and the advertisement query condition to generate the data query information.

[0087] In this embodiment, the data table identifier is a name or identifier used to uniquely identify a target data table in a database. The system generates structured data query information by packaging the data table identifier and the advertisement query condition. In this embodiment, the data query information may be a SQL statement.

[0088] This embodiment obtains the advertisement query condition; determines the target data table according to the semantic information of the advertisement query condition; extracts the data table identifier of the target data table, and packages the data table identifier and the advertisement query condition to generate the data query information. Thus, the data query information including the data table identifier and the advertisement query condition is effectively obtained, so as to facilitate the subsequent acquisition of the encryption status information according to the data query information.

[0089] Continue to refer Figure 4 In some optional implementations of this embodiment, step S20 includes the following steps:

[0090] Step S201, obtaining user terminal information corresponding to the advertisement query condition;

[0091] In this embodiment, the user-side information includes the user-side ID, the user-side device information, the user-side geographic location information, the user-side access rights, etc., wherein the user-side ID is the unique identifier corresponding to the user-side, the user-side device information refers to the device model or operating system and other information of the user-side login device, the user-side geographic location information is the login location determined according to the user-side network status, and is used to ensure the security of the user-side login, and the user-side access rights refer to the advertising information rights that the user-side can access. If the advertising information rights that the user-side can access are exceeded, the user-side cannot access it, that is, the corresponding advertising information cannot be queried.

[0092] Step S202, obtaining a corresponding encryption status record table according to the data table identifier;

[0093] In this embodiment, the data table identifier corresponds to the target data table pointed to by the advertising data query information, the encryption status record table is an information record table corresponding to the target data table, the target data table and the encryption status record table are in a one-to-one correspondence, and the data table identifier also corresponds to the encryption status record table. By using the data table identifier as a parameter, the database architecture is queried to find the corresponding encryption status record table.

[0094] Step S203: search the encryption status record table according to the user terminal information to obtain the encryption status information.

[0095] In this embodiment, sequential search is a simple and direct search technology that checks each element in a data set (such as an array, list, or database table) one by one in sequence until the required element is found or all elements are searched. Through the traversal search method, the encryption status information can be accurately obtained in the encryption status record table, which facilitates subsequent processing.

[0096] This embodiment obtains the user-side information corresponding to the advertisement query condition; obtains the corresponding encryption status record table according to the data table identifier; traverses and searches in the encryption status record table according to the user-side information, thereby obtaining the encryption status information corresponding to the user-side information, so as to facilitate understanding of the encryption status of the data queried by the advertisement query condition, and facilitate effective identification of encryption key fields according to the encryption status information.

[0097] In some optional implementations of this embodiment, before step S202, the following steps are further included:

[0098] Identify the data types stored in the preset data table, wherein the data types include text data, image data, and text image data;

[0099] In this embodiment, identifying the data type stored in the preset data table refers to identifying the data type to which the advertising information stored in the preset data table belongs. The identification method can be achieved by reading the advertising information and determining the content of the advertising information. The data types include text data, image data, and text image data, wherein text data is data that only contains text bytes, such as advertising slogans, image data is data that only contains images (pixel images), such as advertising posters, and text image data is data that contains text and images, such as an advertising brochure consisting of an advertising background painting and advertising slogans.

[0100] Performing a first encryption operation on the text data and generating first encryption state information;

[0101] In this embodiment, the first encryption operation is to convert the text data into a byte stream for encryption through the AES encryption algorithm, and then convert the encrypted byte stream back to a storable format (such as a hexadecimal string or Base64 encoding). The first encryption status information includes the encryption algorithm type (AES encryption algorithm), encryption mode (converting text data into a byte stream for encryption), a first initialization vector, a first key identifier, a first encryption timestamp, and a first encryption status.

[0102] performing a second encryption operation on the image data and generating second encryption state information;

[0103] In this embodiment, the second encryption operation is to binary encrypt the image data through the AES encryption algorithm, and the second encryption status information includes the encryption algorithm type (AES encryption algorithm), encryption mode (binary encryption), a second initialization vector, a second key identifier, a second encryption timestamp, and a second encryption status.

[0104] Performing a third encryption operation on the text image data and generating third encryption state information;

[0105] In this embodiment, the third encryption operation is to separate the text data and the image data in the text image data, convert the text data into a byte stream for encryption through the AES encryption algorithm, and then convert the encrypted byte stream back to a storable format (such as a hexadecimal string or Base64 encoding), and perform binary encryption on the image data. The third encryption status information includes the encryption algorithm type (AES encryption algorithm), encryption mode (converting text data into a byte stream for encryption and performing binary encryption on the image data), a third initialization vector, a third key identifier, a third encryption timestamp, and a third encryption status.

[0106] The first encryption state information, the second encryption state information, and the third encryption state information are integrated into the encryption state information, and recorded in the encryption state record table.

[0107] In this embodiment, the generated first encryption state information, second encryption state information, and third encryption state information are integrated into a unified record to obtain encryption state information, which records data ID or file path, data type, encryption state information of each data type, etc. The encryption state information is inserted into the encryption state record table to complete the recording of the encryption state information.

[0108] This embodiment identifies the data types stored in the preset data table, wherein the data types include text data, image data, and text image data; performs a first encryption operation on the text data and generates first encryption status information; performs a second encryption operation on the image data and generates second encryption status information; performs a third encryption operation on the text image data and generates third encryption status information; integrates the first encryption status information, the second encryption status information, and the third encryption status information into the encryption status information, and records them in the encryption status record table. Thus, different encryption operations are effectively performed according to different types of data, and different encryption status information is generated and recorded in the encryption status record table, so as to complete the real-time update of the encryption status record table, which is convenient for subsequent extraction and viewing.

[0109] Continue to refer Figure 5 In some optional implementations of this embodiment, step S30 includes the following steps:

[0110] Step S301, obtaining the information field corresponding to the encryption status information;

[0111] In this embodiment, the information field corresponding to the encryption status information refers to the information string composed of the encryption algorithm type, encryption mode, initialization vector, key identifier, encryption information identifier, encryption timestamp, encryption status, data ID or file path, data type, and each data type in the above-mentioned encryption status information, or the above-mentioned information characters recorded in the information table. The information field corresponding to the encryption status information can be obtained by reading the text content of the encryption status information.

[0112] Step S302, searching the information field for the encryption algorithm type, encryption mode, initialization vector, and key identifier according to a preset key field identification rule;

[0113] In this embodiment, the key field identification rule is an information identification rule corresponding to the encryption algorithm type, encryption mode, initialization vector and key identifier, and the information identification rule identifies the above information through a specific identifier, wherein the encryption algorithm type is identified by keywords such as "algorithm" or "encryptionAlgorithm". The encryption mode is identified by keywords such as "mode" or "encryptionMode". The initialization vector (IV) is identified by keywords such as "iv" or "initializationVector" and exists in the form of a Base64-encoded string. The key identifier (Key Identifier) ​​is identified by keywords such as "keyId" or "keyIdentifier", and is usually a string or a numeric identifier.

[0114] The encryption algorithm type, encryption mode, initialization vector and key identifier are used as the encryption key fields.

[0115] In this embodiment, the encryption algorithm type, encryption mode, initialization vector and key identifier are extracted from the encryption state information to obtain the encryption key field. The extraction of the above encryption key field can be achieved through key access (such as dictionary access).

[0116] This embodiment obtains the information field corresponding to the encryption status information; searches for the encryption algorithm type, encryption mode, initialization vector and key identifier in the information field according to the preset key field identification rule; and uses the encryption algorithm type, encryption mode, initialization vector and key identifier as the encryption key field. Thus, the encryption key field including the encryption algorithm type, encryption mode, initialization vector and key identifier is effectively obtained, so as to facilitate the subsequent data query operation according to the encryption key field.

[0117] Continue to refer Figure 6In some optional implementations of this embodiment, step S40 includes the following steps:

[0118] Step S401, obtaining the field value corresponding to the encryption key field;

[0119] In this embodiment, the field value refers to the value corresponding to the encryption algorithm type, encryption mode, initialization vector and key identifier. The field value can be a null value. When the field value is a null value, it indicates that the encryption status information corresponding to the encryption key field does not exist, that is, the advertising information corresponding to the encryption status information has not performed an encryption operation or has not been encrypted.

[0120] Step S402, identifying whether the field value corresponding to the encryption key field is empty;

[0121] In this embodiment, whether the field value corresponding to the encryption key field is empty is identified by checking whether the variable values ​​of the encryption algorithm type, encryption mode, initialization vector and key identifier are undefined or null, are empty strings or contain other values ​​that are considered "empty".

[0122] Step S403: if the field value corresponding to the encrypted key field is empty, calling the first query component to perform data query according to the data query information to obtain the valid advertisement query data;

[0123] In this embodiment, the first query component can be a SQL query component or a business logic query component. In specific implementation, after valid query data is queried, the valid query data can be further detected. Since the valid query data is not encrypted, it is possible to directly detect whether the valid query data contains sensitive fields. If sensitive fields are contained, the data query information is encrypted and the current data query information is updated to new data query information to effectively protect the sensitive fields in the valid query data.

[0124] Step S404, if the field value corresponding to the encrypted key field is not empty, encrypt the data query information according to the encrypted key field to obtain encrypted data query information, and then call the second query component to perform data query according to the encrypted data query information to obtain the encrypted advertising query data.

[0125] In this embodiment, the second query component may be an encrypted data query engine or a secure query API. In this embodiment, the encrypted data query information is obtained by encrypting the data query information, thereby effectively protecting the encrypted query data and improving the security of advertising information query.

[0126] This embodiment obtains the field value corresponding to the encrypted key field; identifies whether the field value corresponding to the encrypted key field is empty; if the field value corresponding to the encrypted key field is empty, calls the first query component to perform data query according to the data query information to obtain the valid advertisement query data; if the field value corresponding to the encrypted key field is not empty, encrypts the data query information according to the encrypted key field to obtain encrypted data query information, and then calls the second query component to perform data query according to the encrypted data query information to obtain the encrypted advertisement query data. Thus, different query components are used to respectively obtain valid query data and encrypted query data, so as to effectively cover encrypted data and unencrypted data, and improve the data acquisition flexibility of the system.

[0127] In some optional implementations of this embodiment, after step S40, the following steps are further included:

[0128] Obtaining first message generation information corresponding to the valid advertisement query data;

[0129] In this embodiment, the first message generation information refers to the format and rules required to convert unencrypted valid advertisement query data into a message, which may include the format specification of the first message (such as XML, JSON), field mapping rules, necessary header information, etc.

[0130] Writing the valid advertisement query data into a preset message template according to the first message generation information to obtain a first message;

[0131] In this embodiment, the preset message template is a universal predefined message framework, which defines the structure and format of the message. The valid advertisement query data is filled into the preset message template by replacing the placeholders in the template, thereby obtaining the first message.

[0132] Obtaining second message generation information corresponding to the encrypted advertisement query data;

[0133] In this embodiment, the second message generation information includes not only the format specification of the second message (such as XML, JSON), field mapping rules, and necessary header information, but also a decryption key and a decryption algorithm, and the decryption key and the decryption algorithm are used to perform subsequent decryption operations on the encrypted advertising query data.

[0134] The corresponding decryption component is called according to the second message generation information to decrypt the encrypted advertisement query data to obtain decrypted advertisement query data, and the decrypted advertisement query data is written into a preset message template to obtain a second message.

[0135] In this embodiment, the preset message template is a universal predefined message framework, which defines the structure and format of the message. The decrypted advertisement query data is filled into the preset message template by replacing the placeholder in the template, thereby obtaining the second message.

[0136] This embodiment obtains the first message generation information corresponding to the effective advertisement query data; writes the effective advertisement query data into a preset message template according to the first message generation information to obtain the first message; obtains the second message generation information corresponding to the encrypted advertisement query data; calls the corresponding decryption component according to the second message generation information to decrypt the encrypted advertisement query data to obtain decrypted advertisement query data, and writes the decrypted advertisement query data into a preset message template to obtain the second message. Thus, the corresponding message is effectively generated and recorded according to the effective advertisement query data and the encrypted advertisement query data, so as to facilitate subsequent data viewing.

[0137] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiments can be implemented by instructing the relevant hardware through computer-readable instructions, and the computer-readable instructions can be stored in a computer-readable storage medium. When the program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, the aforementioned storage medium can be a non-volatile storage medium such as a disk, an optical disk, a read-only memory (ROM), or a random access memory (RAM).

[0138] It should be understood that, although the steps in the flowchart of the accompanying drawings are displayed in sequence as indicated by the arrows, these steps are not necessarily executed in sequence in the order indicated by the arrows. Unless otherwise specified herein, there is no strict order restriction on the execution of these steps, and they can be executed in other orders. Moreover, at least a part of the steps in the flowchart of the accompanying drawings may include multiple sub-steps or multiple stages, and these sub-steps or stages are not necessarily executed at the same time, but can be executed at different times, and their execution order is not necessarily sequential, but can be executed in turn or alternately with other steps or at least a part of the sub-steps or stages of other steps.

[0139] Further references Figure 7 , as a response to the above Figure 1 The present application provides an embodiment of an advertisement information query device, and the device embodiment is similar to Figure 1 Corresponding to the method embodiment shown, the device can be specifically applied to various electronic devices.

[0140] like Figure 7As shown, the advertisement information query device 600 described in this embodiment includes: a query information acquisition module 601, a state information acquisition module 602, a key field identification module 603, a data query module 604, and an information return module 605. Among them:

[0141] The query information acquisition module 601 is used to acquire advertisement data query information;

[0142] A status information acquisition module 602, configured to acquire corresponding encryption status information according to the advertisement data query information;

[0143] A key field identification module 603, used to identify the encryption key field corresponding to the encryption state information;

[0144] A data query module 604 is used to call the corresponding first query component and second query component respectively to perform data query according to the encrypted key field to obtain valid advertisement query data and encrypted advertisement query data;

[0145] The information returning module 605 is used to return the valid advertisement query data and / or the encrypted advertisement query data as advertisement information to the user terminal corresponding to the data query information.

[0146] This embodiment uses the above-mentioned advertisement information query device to obtain advertisement data query information; obtain corresponding encryption status information according to the advertisement data query information; identify the encryption key field corresponding to the encryption status information; call the corresponding first query component and second query component to perform data query according to the encryption key field, and obtain valid advertisement query data and encrypted advertisement query data; return the valid advertisement query data and / or the encrypted advertisement query data as advertisement information to the user terminal corresponding to the data query information. This effectively realizes convenient and rapid acquisition of encrypted and unencrypted advertisement information, so as to improve the query efficiency of advertisement information.

[0147] To solve the above technical problems, the present application also provides a computer device. Figure 8 , Figure 8 This is a basic structural block diagram of the computer device in this embodiment.

[0148] The computer device 7 includes a memory 71, a processor 72, and a network interface 73 that are interconnected through a system bus. It should be noted that the figure only shows a computer device 7 with components 71-73, but it should be understood that it is not required to implement all the components shown, and more or fewer components can be implemented instead. Among them, those skilled in the art can understand that the computer device here is a device that can automatically perform numerical calculations and / or information processing according to pre-set or stored instructions, and its hardware includes but is not limited to microprocessors, application specific integrated circuits (Application Specific Integrated Circuit, ASIC), programmable gate arrays (Field-Programmable Gate Array, FPGA), digital processors (Digital Signal Processor, DSP), embedded devices, etc.

[0149] The computer device may be a computing device such as a desktop computer, a notebook, a PDA, a cloud server, etc. The computer device may interact with a user through a keyboard, a mouse, a remote controller, a touch pad, or a voice control device.

[0150] The memory 71 includes at least one type of readable storage medium, and the readable storage medium includes flash memory, hard disk, multimedia card, card-type memory (for example, SD or DX memory, etc.), random access memory (RAM), static random access memory (SRAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), programmable read-only memory (PROM), magnetic memory, disk, optical disk, etc. In some embodiments, the memory 71 can be an internal storage unit of the computer device 7, such as a hard disk or memory of the computer device 7. In other embodiments, the memory 71 can also be an external storage device of the computer device 7, such as a plug-in hard disk, a smart memory card (Smart Media Card, SMC), a secure digital (Secure Digital, SD) card, a flash card (FlashCard), etc. equipped on the computer device 7. Of course, the memory 71 can also include both the internal storage unit of the computer device 7 and its external storage device. In this embodiment, the memory 71 is generally used to store the operating system and various application software installed on the computer device 7, such as computer-readable instructions of the advertising information query method, etc. In addition, the memory 71 can also be used to temporarily store various types of data that have been output or are to be output.

[0151] The processor 72 may be a central processing unit (CPU), a controller, a microcontroller, a microprocessor, or other data processing chips in some embodiments. The processor 72 is generally used to control the overall operation of the computer device 7. In this embodiment, the processor 72 is used to run the computer-readable instructions stored in the memory 71 or process data, such as computer-readable instructions for running the advertising information query method.

[0152] The network interface 73 may include a wireless network interface or a wired network interface. The network interface 73 is generally used to establish a communication connection between the computer device 7 and other electronic devices.

[0153] By adopting the above-mentioned computer device, this embodiment can obtain advertisement data query information; obtain corresponding encryption status information according to the advertisement data query information; identify the encryption key field corresponding to the encryption status information; call the corresponding first query component and second query component respectively according to the encryption key field to perform data query, and obtain valid advertisement query data and encrypted advertisement query data; return the valid advertisement query data and / or the encrypted advertisement query data as advertisement information to the user terminal corresponding to the data query information. Thus, it is effectively realized that the encrypted and unencrypted advertisement information can be obtained conveniently and quickly, so as to improve the query efficiency of advertisement information.

[0154] The present application also provides another embodiment, namely, providing a computer-readable storage medium, wherein the computer-readable storage medium stores computer-readable instructions, and the computer-readable instructions can be executed by at least one processor to enable the at least one processor to perform the steps of the above-mentioned advertising information query method.

[0155] This embodiment, by using the above-mentioned computer-readable storage medium, can obtain advertisement data query information; obtain corresponding encryption status information according to the advertisement data query information; identify the encryption key field corresponding to the encryption status information; call the corresponding first query component and second query component respectively according to the encryption key field to perform data query, and obtain valid advertisement query data and encrypted advertisement query data; return the valid advertisement query data and / or the encrypted advertisement query data as advertisement information to the user terminal corresponding to the data query information. This effectively realizes convenient and rapid acquisition of encrypted and unencrypted advertisement information, so as to improve the query efficiency of advertisement information.

[0156] Through the description of the above implementation methods, those skilled in the art can clearly understand that the above-mentioned embodiment methods can be implemented by means of software plus a necessary general hardware platform, and of course by hardware, but in many cases the former is a better implementation method. Based on such an understanding, the technical solution of the present application, or the part that contributes to the prior art, can be embodied in the form of a software product, which is stored in a storage medium (such as ROM / RAM, magnetic disk, optical disk), and includes a number of instructions for a terminal device (which can be a mobile phone, computer, server, air conditioner, or network device, etc.) to execute the methods described in each embodiment of the present application.

[0157] Obviously, the embodiments described above are only some embodiments of the present application, rather than all embodiments. The preferred embodiments of the present application are given in the accompanying drawings, but they do not limit the patent scope of the present application. The present application can be implemented in many different forms. On the contrary, the purpose of providing these embodiments is to make the understanding of the disclosure of the present application more thorough and comprehensive. Although the present application is described in detail with reference to the aforementioned embodiments, for those skilled in the art, it is still possible to modify the technical solutions recorded in the aforementioned specific implementation methods, or to perform equivalent replacement of some of the technical features therein. Any equivalent structure made using the contents of the specification and drawings of this application, directly or indirectly used in other related technical fields, is similarly within the scope of patent protection of this application.

Claims

1. An advertisement information query method, characterized in that: The steps include: Get advertising data query information; Acquire corresponding encryption status information according to the advertisement data query information; Identify an encryption key field corresponding to the encryption status information; According to the encrypted key field, the corresponding first query component and the second query component are respectively called to perform data query to obtain valid advertisement query data and encrypted advertisement query data; The effective advertisement query data and / or the encrypted advertisement query data are returned as advertisement information to the user terminal corresponding to the data query information.

2. The advertisement information query method according to claim 1, characterized in that: The step of obtaining advertisement data query information specifically includes: Get advertisement query conditions; Determine a target data table according to the semantic information of the advertisement query condition; The data table identifier of the target data table is extracted, and the data table identifier and the advertisement query condition are packaged to generate the data query information.

3. The advertisement information query method according to claim 1, characterized in that: The data query information includes an advertisement query condition and a data table identifier, and the step of acquiring corresponding encryption status information according to the advertisement data query information specifically includes: Obtaining user terminal information corresponding to the advertisement query condition; Obtaining a corresponding encryption status record table according to the data table identifier; The encryption status information is obtained by searching the encryption status record table according to the user terminal information.

4. The advertisement information query method according to claim 3, characterized in that: Before the step of obtaining the corresponding encryption status record table according to the data table identifier, the following steps are also included: Identify the data types stored in the preset data table, wherein the data types include text data, image data, and text image data; Performing a first encryption operation on the text data and generating first encryption state information; performing a second encryption operation on the image data and generating second encryption state information; Performing a third encryption operation on the text image data and generating third encryption state information; The first encryption state information, the second encryption state information, and the third encryption state information are integrated into the encryption state information, and recorded in the encryption state record table.

5. The advertisement information query method according to claim 1, characterized in that: The step of identifying the encryption key field corresponding to the encryption state information specifically includes: Obtaining the information field corresponding to the encryption status information; Searching the encryption algorithm type, encryption mode, initialization vector, and key identifier in the information field according to a preset key field identification rule; The encryption algorithm type, encryption mode, initialization vector and key identifier are used as the encryption key fields.

6. The advertisement information query method according to claim 1, characterized in that: The step of respectively calling the corresponding first query component and the second query component to perform data query according to the encrypted key field to obtain valid advertisement query data and encrypted advertisement query data specifically includes: Obtaining the field value corresponding to the encryption key field; Identify whether the field value corresponding to the encryption key field is empty; If the field value corresponding to the encrypted key field is empty, calling the first query component to perform data query according to the data query information to obtain the valid advertisement query data; If the field value corresponding to the encrypted key field is not empty, the data query information is encrypted according to the encrypted key field to obtain encrypted data query information, and then the second query component is called to perform data query according to the encrypted data query information to obtain the encrypted advertising query data.

7. The advertisement information query method according to claim 1, characterized in that: After the step of returning the effective advertisement query data and / or the encrypted advertisement query data as advertisement information to the user terminal corresponding to the data query information, the following steps are also included: Obtaining first message generation information corresponding to the valid advertisement query data; Writing the valid advertisement query data into a preset message template according to the first message generation information to obtain a first message; Obtaining second message generation information corresponding to the encrypted advertisement query data; The corresponding decryption component is called according to the second message generation information to decrypt the encrypted advertisement query data to obtain decrypted advertisement query data, and the decrypted advertisement query data is written into a preset message template to obtain a second message.

8. An advertisement information query device, characterized in that: include: A query information acquisition module, used to acquire advertisement data query information; A status information acquisition module, used to acquire corresponding encryption status information according to the advertisement data query information; A key field identification module, used to identify the encryption key field corresponding to the encryption status information; A data query module, used to call the corresponding first query component and second query component respectively according to the encrypted key field to perform data query, and obtain valid advertisement query data and encrypted advertisement query data; The information returning module is used to return the effective advertisement query data and / or the encrypted advertisement query data as advertisement information to the user terminal corresponding to the data query information.

9. A computer device, characterized in that: The method comprises a memory and a processor, wherein the memory stores computer-readable instructions, and the processor implements the steps of the advertising information query method according to any one of claims 1 to 7 when executing the computer-readable instructions.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer-readable instructions, and when the computer-readable instructions are executed by a processor, the steps of the advertising information query method according to any one of claims 1 to 7 are implemented.

Images