CN110515979B - Data query method, device, device and storage medium - Google Patents

Abstract

Embodiments of the present invention disclose a data query method, device, device and storage medium, wherein the method includes: acquiring a target activity pre-cached in a storage space according to a data query request; acquiring data to be queried in a database according to the target activity The target business data in the table. In the embodiment of the present invention, the target activity to be queried is stored in the cache area in advance, which reduces the data transmission amount in the data query process, does not need to filter the data according to the data query request, reduces the computing overhead of the server, and improves the data query in the database. s efficiency.

Description

Data query method, device, device and storage medium

technical field

Embodiments of the present invention relate to the technical field of computer applications, and in particular, to a data query method, apparatus, device, and storage medium.

Background technique

With the development of Internet technology, data has become an important resource for Internet companies. When existing Internet companies store business data, they store different types of data in different database tables. For example, business activity rules and user business information are stored separately. to the activity rules table and the user business table. The personal business information corresponding to the business activity rules stored in the activity rule table and the user business table and the user business is generated and displayed to the user's personal center.

In the prior art, business activity rules and user business information are stored in an activity rule table and a user business table, respectively. Referring to Figure 1, an activity number and a user number are stored in the user business table, and a rule number and an order type are stored in the activity rule table. When it is necessary to query user business data, all business data of the user is found in the user business data table according to the user ID, activity rules are obtained according to the order type and rule ID, and all business data are filtered according to the found activity rules in the cache to obtain the matching User business data requested by the activity. The above technical solution has two problems. First, all business data of the user needs to be read from the database, and the network data transmission overhead is high; second, all business data needs to be filtered in the memory according to the activity rules. For a long time, it consumes a lot of server computing resources.

SUMMARY OF THE INVENTION

The present invention provides a data query method, device, equipment and storage medium, so as to realize efficient query of database data, reduce server computing overhead, and improve data transmission efficiency.

In a first aspect, an embodiment of the present invention provides a data query method, which includes:

Obtain the target activities pre-cached in the storage space according to the data query request;

The target business data in the data table to be checked in the database is acquired according to the target activity.

In a second aspect, an embodiment of the present invention further provides a data query device, the device comprising:

The cache matching module is used to obtain the target activities pre-cached in the storage space according to the data query request;

The database matching module is used for acquiring the target business data in the data table to be checked in the database according to the target activity.

In a third aspect, an embodiment of the present invention further provides a device, and the device includes:

one or more processors;

memory for storing one or more programs,

When the one or more programs are executed by the one or more processors, the one or more processors implement the data query method according to any one of the embodiments of the present invention.

In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium on which a computer program is stored, and when the program is executed by a processor, implements the data query method according to any one of the embodiments of the present invention.

According to the technical solution of the embodiment of the present invention, the target activity cached in the storage space is obtained through a data query request, the corresponding target service data is searched in the database according to the target activity, and the activity data is cached in the storage space in advance, thereby shortening the time for obtaining service. The query time of data is reduced, the computing overhead of the server is reduced, and the efficiency of data query can be improved.

Description of drawings

Fig. 1 is an example diagram of data query in the prior art;

2 is a flowchart of steps of a data query method provided in Embodiment 1 of the present invention;

3 is a flow chart of steps of a data query method provided in Embodiment 2 of the present invention;

4 is an exemplary diagram of a data query method provided in Embodiment 2 of the present invention;

5 is a schematic structural diagram of a data query device according to Embodiment 3 of the present invention;

FIG. 6 is a schematic structural diagram of a device according to Embodiment 4 of the present invention.

Detailed ways

The present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention, but not to limit the present invention. In addition, it should be noted that, for the convenience of description, the drawings only show some but not all of the structures related to the present invention. In addition, the embodiments of the present invention and the features of the embodiments will not conflict with each other. can be combined with each other.

Example 1

FIG. 2 is a flowchart of steps of a data query method provided by an embodiment of the present invention. This embodiment is applicable to the case of querying business data stored in sub-tables. The method can be executed by a data query device, and the device can use hardware and/or software. Referring to FIG. 2, the method provided by the embodiment of the present invention includes the following steps:

Step 101: Acquire the target activity pre-cached in the storage space according to the data query request.

Wherein, the data query request may be a request sent by a user to obtain data, for example, it may be a user's click command or a display interface opening command, etc., and the storage space may be a space in which activity information is pre-stored, or a high-speed data exchange. The memory can directly exchange data with the central processor, the target activity can be the original data of the target data obtained by the data query request, and the target activity can be the target data of the data query request after filtering or combining.

Specifically, when the data query request is obtained, the target activity can be searched in the pre-cached storage space according to the data query request. For example, the data query request is the activity discount information corresponding to the query order, and the order information in the data query request can be searched according to the data query request. Get the activities associated with the order information in the pre-cached storage space, and use the found activities as the target activities.

Step 102: Acquire the target business data in the data table to be checked in the database according to the target activity.

The database may be a data set storing target activity and business data, the target activity and business data may be stored in different data tables in the database, and the data table to be checked may be a data table storing target business data. It can be understood that the business data and the target activity in the data table to be checked may have an associated relationship, for example, the identification number of the target activity may have a corresponding relationship with the identification number of the business data.

In this embodiment of the present invention, the data table to be searched in the database can be searched according to the target activity, and when the target activity is found, the service data stored in association with the target activity can be used as the target service data. For example, the business data in the data table to be queried in the database can be stored in association with the identification number of the target activity. When the identification number of the target activity is queried, the business data corresponding to the identification number of the target activity can be used as the target business data.

According to the technical solution of the embodiment of the present invention, the target activity corresponding to the data query request is searched in the storage space with pre-cache, search is performed in the data table to be searched in the database according to the target activity, and the found data is used as the target business data, The activity data stored in the database is cached in the storage space, which improves the data search speed, and cross-table data query does not require data filtering in the cached data when the data query request is obtained, which reduces the technical overhead of the server and improves the data query efficiency. .

Embodiment 2

FIG. 3 is a flow chart of the steps of a data query method provided in Embodiment 2 of the present invention. The embodiment of the present invention is an embodiment based on the implementation of the above-mentioned invention. Referring to FIG. 3 , the data query method according to the embodiment of the present invention includes:

Step 201: Read the activity data in the database activity table and the rule data in the rule table respectively.

The activity table may be a data table storing activity information, the activity table may store relevant information of the activity, and may include the activity introduction and activity content of the activity, etc. The rule table may be a data table storing activity rules, and the rule table may store There are rules such as the effective time of the activity and participation requirements. The rule data can be the rules stored in the activity table. The activity data in the activity table can correspond to the data of different activities. The rule data can be rule data. It is understandable that in the rule table Multiple rule data of , can correspond to the same activity, and activities can be restricted.

Specifically, the activity data and rule data can be stored in the activity table and the rule table in the database, all the activity data and rule data stored in the data can be read in advance, and the read activity data and rule data can be cached in the storage space. For example, before a data query request is obtained, the rule data and activity data can be read, and when a data query request is obtained, the data stored in the cache can be directly read without having to cache from the database to the storage space.

In step 202, the activity data and the rule data are formed into a business activity, and the business activity is cached in the space storage.

The business activity may be an activity composed of activity data and rule data, the business activity may include activity content of the activity and corresponding activity rules, and the combination of activity data and rule data may be selected or automatically selected by the user.

In this embodiment of the present invention, activity data and rule data can be combined according to user needs or configuration files to generate business activities, and business activities can be generated in the activity space of the activity data and rule data caches. For example, the activity number and the rule number can be associated with the activity item number, and the activity item number can be used as the corresponding business activity. It can be understood that the activity data can correspond to multiple rule data, and the business activity can include one activity data and multiple rule data.

Step 203: Extract the attribute information to be checked in the data query request.

The attribute information to be queried may include user information and order types, etc. The attribute information to be queried can be obtained by the user for corresponding business activities. For example, different order types can correspond to different business activities.

In this embodiment of the present invention, the data query request may include the user's property information to be checked. When the data query request is obtained, the user information and order type included in the data query request may be extracted to wait for the property information to be checked.

Step 204 determines the target business activity corresponding to the rule data satisfied by the attribute information to be checked in the storage space.

The storage space may be a memory that directly interacts with the central processor, and business activities may be stored in the storage space. When a data query request is obtained, the corresponding target business activity may be queried according to the attribute information to be queried.

Specifically, the business activity can include the rule data, and the corresponding rule data can be searched according to the attribute information to be checked. If the attribute information to be checked satisfies the activity rules corresponding to the rule data, for example, the order type is the same as the order type in the rule data, it can be The business activity corresponding to the rule data is used as the target business activity to be queried in the data query request.

Step 205: Use the activity data corresponding to the target business activity as the target activity.

In this embodiment of the present invention, the target business activity may include rule data and business data. When the to-be-checked attribute in the data query request meets the requirements of the rule data, the activity data associated with the rule data can be obtained, for example, the activity data associated with the rule data can be obtained. The activity number stored in association with the rule data, and the acquired activity data can be used as the target activity of the data query request.

Step 206: Determine the data query quantity in the data query request.

The data query request may be a refresh request of the user information display interface, the query target data may be displayed in the user information display interface according to the data query request, and the data in the data query request may be determined according to the quantity of target data to be displayed in the user information display interface The number of queries, the number of data queries can be the number of query target data.

Specifically, the data query request includes the data query quantity that needs to query the target data, and the data query quantity can be extracted by analyzing the data query request. Further, the number of data queries may be related to the number of target data displayed in the user information display interface. For example, if 20 pieces of target data need to be displayed in the user information display interface, the number of data queries in the data query request may be determined as 20.

Step 207 : Search the data table to be searched in the database for business data of the number of data queries according to the target activity, wherein the data table to be searched stores the business data and the activity data in association.

The data table to be queried can store business data and activity data in association, for example, business data can be stored in association with the activity number of the target activity, and corresponding business data can be queried according to the activity data of the target activity.

Specifically, after the target activity is obtained according to the data query request, the corresponding business data can be searched in the database according to the target activity, and the business data of the data query quantity is obtained as the target business data. For example, according to the activity number of the target activity, the business data can be searched in the data table to be searched in the database, the business data of the data query quantity can be obtained as the target business data, and the business data of the data query quantity can be directly searched without obtaining all the business data that meet the requirements. business data, which improves the speed of data query.

Step 208: Use the found service data as the target service data.

In this embodiment of the present invention, the service data queried according to the target activity may be used as the target service data.

The technical solution of the embodiment of the present invention is to obtain the activity data and the rule data by reading the database activity table and the rule table, compose the activity data and the rule data into a business activity, store the business activity in the storage space, and obtain the pending data in the data query request. Check the attribute information, determine the target business activity corresponding to the rule data satisfied in the storage space according to the attribute information to be checked, take the activity data of the target business activity as the target activity, and determine the number of data queries requested by the data query. The business data of the number of search data queries in the system is used as the target business data; by pre-caching business activities in the storage space, when obtaining data query requests, there is no need to search the database to obtain the activity data and rule data, which improves the data query efficiency, and does not need to be based on the activity data and the rule data. The rule data queries all business data, which reduces the computing overhead of the server and improves the data query efficiency.

Further, on the basis of the above embodiments of the invention, the activity data and the rule data are formed into business activities, including:

Obtain the association relationship pre-configured by the user; associate the activity data and the rule data according to the association relationship as a business activity.

In this embodiment of the present invention, the association relationship may be the corresponding relationship between activity data and rule data, one activity data may correspond to multiple rule data, and the association relationship may be pre-stored in a configuration file. When the activity data and the rule data need to be composed At the time, activity data and rule data can be composed according to the association relationship in the configuration file to generate an activity rule set, and the activity rule set can be regarded as a business activity.

Further, on the basis of the above embodiments of the invention, it also includes:

When the current time is not within the activity time range of the business activity in the storage space, the business activity is deleted from the storage space; when the database activity table is updated, the updated business activity cache is generated and stored in the storage space according to the updated data.

Wherein, the current time can be the time when the business activity in the storage space is updated, and the activity time range can be the rule data of the business activity. If the current time is not within the activity time range of the business activity, it can be determined that the business activity is invalid, or, when the database When the activity table is updated, for example, when new activity data is stored in the activity table, a new business activity can be formed according to the new activity data added to the storage space.

Specifically, the rule data of the business activities in the storage space is obtained, and if the current time is no longer within the range of the active time, the corresponding business activity can be deleted from the storage space; if the activity table in the database is stored in the update data, among them, The update data can be new activity data. When new activity data is stored in the activity table, the update business activity cache can be generated according to the activity data and stored in the storage space.

Further, on the basis of the above-mentioned embodiments of the invention, when the database activity table is updated, generating and updating the business activity cache to the storage space according to the update data, including:

Obtain the update activity data in the database activity table and the rule data in the rule table; generate the update business activity according to the update activity data and the rule data; cache the update business activity in the storage space.

Specifically, the update activity data newly added in the database activity table can be acquired, the update business activity can be formed according to the update activity data group and the rule data in the rule table, and the update business activity can be cached in the storage space.

Exemplarily, FIG. 4 is an example diagram of a data query method provided by Embodiment 2 of the present invention. Referring to FIG. 4 , the activity data in the activity table and the rule data in the rule table are formed into an activity of order type and activity number through a timing script. The activity item can be stored in the cache as a business activity. When a data query request is obtained, the activity number can be obtained by looking up the business activity in the cache, and the target business data can be searched in the data table to be checked according to the activity number. Realize fast search of target data.

Embodiment 3

FIG. 5 is a schematic structural diagram of a data query apparatus provided by Embodiment 3 of the present invention. Referring to FIG. 5 , the data query apparatus provided by the embodiment of the present invention can execute the data query method provided by any embodiment of the present invention, and has corresponding execution methods. Functional modules and beneficial effects, the apparatus can be implemented by software and/or hardware, and specifically includes: a cache matching module 301 and a database matching module 302 .

The cache matching module 301 is configured to acquire the target activity pre-cached in the storage space according to the data query request.

The database matching module 302 is configured to obtain the target business data in the data table to be checked in the database according to the target activity.

In the technical solution of the embodiment of the present invention, the cache matching module searches for the target activity corresponding to the data query request in the pre-cached storage space, and the database matching module searches the data table to be searched in the database according to the target activity, and searches the found data The data is used as the target business data, and the activity data stored in the database is cached in the storage space, which improves the data search speed. Cross-table data query does not need to filter the data in the cached data when the data query request is obtained, which reduces the technical overhead of the server. , which improves the data query efficiency.

Further, on the basis of the above embodiments of the invention, the data query device further includes:

The data reading module is used to read the activity data in the database activity table and the rule data in the rule table respectively.

The activity cache module is used to compose activity data and rule data into business activities, and cache the business activities to the storage space.

Further, on the basis of the above embodiments of the invention, the active cache module includes:

The configuration obtaining unit is used to obtain the association relationship preconfigured by the user.

The activity determination unit is used for associating activity data and rule data as business activities according to the association relationship.

Further, on the basis of the above embodiments of the invention, the cache matching module includes:

The information extraction unit is used to extract the attribute information to be checked in the data query request.

The cache search unit is used to determine the target business activity corresponding to the rule data satisfied by the attribute information to be searched in the storage space.

The target activity unit is configured to use the activity data corresponding to the target business activity as the target activity.

Further, on the basis of the above embodiments of the invention, the database matching module includes:

The quantity determining unit is used to determine the data query quantity in the data query request.

The data search unit is configured to search for the business data of the data query quantity in the data table to be searched in the database according to the target activity, wherein the data table to be searched stores the business data and the activity data in association.

The target data determination unit is used for taking the found business data as the target business data.

Further, on the basis of the above embodiments of the invention, it also includes:

The activity deletion module is used to delete the business activity from the storage space when the current time is not within the activity time range of the business activity in the storage space.

The business update module is used to generate and update the business activity cache to the storage space according to the update data when the database activity table is updated.

Further, on the basis of the above embodiments of the invention, the service update module includes:

The update data unit is used to obtain the update activity data in the database activity table and the rule data in the rule table.

The update business activity unit is used to generate the update business activity according to the update activity data and the rule data;

An update cache unit, configured to cache the update service activity in the storage space.

Embodiment 4

FIG. 6 is a schematic structural diagram of a device according to Embodiment 4 of the present invention. As shown in FIG. 6 , the device includes a processor 40, a memory 41, an input device 42 and an output device 43; the number of processors 40 in the device may be One or more, a processor 40 is taken as an example in FIG. 6; the processor 40, memory 41, input device 42 and output device 43 in the device can be connected through a bus or other means, and the connection through a bus is taken as an example in FIG. 6 .

As a computer-readable storage medium, the memory 71 can be used to store software programs, computer-executable programs, and modules, such as program modules corresponding to the data query method in the embodiment of the present invention (for example, the cache matching module 301 in the data query module). and database matching module 302). The processor 40 executes various functional applications and data processing of the device by running the software programs, instructions and modules stored in the memory 41 , that is, implements the above-mentioned data query method.

The memory 41 may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function; the storage data area may store data created according to the use of the terminal, and the like. In addition, memory 41 may include high-speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other non-volatile solid-state storage device. In some instances, memory 41 may further include memory located remotely from processor 40, which may be connected to the device through a network. Examples of such networks include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

The input device 42 may be used to receive input numerical or character information and to generate key signal input related to user settings and function control of the device. The output device 73 may include a display device such as a display screen.

Embodiment 5

Embodiment 5 of the present invention further provides a storage medium containing computer-executable instructions, where the computer-executable instructions are used to execute a data query method when executed by a computer processor, and the method includes:

Obtain the target activities pre-cached in the storage space according to the data query request;

The target business data in the data table to be checked in the database is acquired according to the target activity.

Of course, a storage medium containing computer-executable instructions provided by an embodiment of the present invention, the computer-executable instructions of the storage medium are not limited to the above-mentioned method operations, and can also execute any of the data query methods provided by any embodiment of the present invention. related operations.

From the above description of the embodiments, those skilled in the art can clearly understand that the present invention can be realized by software and necessary general-purpose hardware, and of course can also be realized by hardware, but in many cases the former is a better embodiment . Based on such understanding, the technical solutions of the present invention can be embodied in the form of software products in essence or the parts that make contributions to the prior art, and the computer software products can be stored in a computer-readable storage medium, such as a floppy disk of a computer , read-only memory (Read-Only Memory, ROM), random access memory (Random Access Memory, RAM), flash memory (FLASH), hard disk or CD, etc., including several instructions to make a computer device (which can be a personal computer, A server, or a network device, etc.) executes the methods described in the various embodiments of the present invention.

It is worth noting that, in the above-mentioned embodiment of the data query apparatus, the units and modules included are only divided according to functional logic, but are not limited to the above-mentioned division, as long as the corresponding functions can be realized; The specific names of the functional units are only for the convenience of distinguishing from each other, and are not used to limit the protection scope of the present invention.

Note that the above are only preferred embodiments of the present invention and applied technical principles. Those skilled in the art will understand that the present invention is not limited to the specific embodiments described herein, and various obvious changes, readjustments and substitutions can be made by those skilled in the art without departing from the protection scope of the present invention. Therefore, although the present invention has been described in detail through the above embodiments, the present invention is not limited to the above embodiments, and can also include more other equivalent embodiments without departing from the concept of the present invention. The scope is determined by the scope of the appended claims.

Claims (7)

1. A method for querying data, comprising:

acquiring target activities cached in a storage space in advance according to the data query request;

acquiring target service data in a data table to be checked in a database according to the target activity;

the target activities pre-cached in the storage space include:

respectively reading activity data in an activity table of a database and rule data in a rule table, wherein the activity table storage information comprises activity content and activity introduction, and the rule table storage rule comprises participation requirements and effective time;

forming business activities by the activity data and the rule data, and caching the business activities into a storage space;

the acquiring target activities cached in a storage space in advance according to the data query request includes:

extracting attribute information to be checked in the data query request;

determining target business activities corresponding to the rule data satisfied by the attribute information to be checked in the storage space;

taking activity data corresponding to the target business activity as a target activity;

the obtaining of the target service data in the database to-be-searched data table according to the target activity includes:

determining the data query quantity in the data query request;

searching the service data of the data query quantity in a database to-be-searched data table according to the target activity, wherein the to-be-searched data table stores the service data and the activity data in an associated manner;

and taking the searched service data as target service data.

2. The method of claim 1, wherein composing the activity data and the rule data into a business activity comprises:

acquiring an incidence relation configured in advance by a user;

and associating the activity data with the rule data according to the association relation to serve as business activity.

3. The method of claim 1, further comprising:

when the current time is not in the activity time range of the business activity in the storage space, deleting the business activity from the storage space;

when the database activity table is updated, generating an updated service activity according to the updated data and caching the updated service activity in a storage space.

4. The method of claim 3, wherein generating an updated business activity cache to a storage space according to the update data when the database activity table is updated comprises:

acquiring updated activity data in a database activity table and rule data in a rule table;

generating an updating business activity according to the updating activity data and the rule data;

and caching the updated service activity into a storage space.

5. A data query apparatus, comprising:

the cache matching module is used for acquiring target activities cached in the storage space in advance according to the data query request;

the database matching module is used for acquiring target service data in a database to-be-checked data table according to the target activity;

the data reading module is used for respectively reading activity data in an activity table of a database and rule data in a rule table, wherein the activity table storage information comprises activity content and activity introduction, and the rule table storage rule comprises participation requirements and effective time;

the activity caching module is used for forming the activity data and the rule data into business activities and caching the business activities into a storage space;

the cache matching module specifically includes:

the information extraction unit is used for extracting attribute information to be checked in the data query request;

the cache searching unit is used for determining the target business activity corresponding to the rule data satisfied by the attribute information to be searched in the storage space;

the target activity unit is used for taking activity data corresponding to the target business activity as a target activity;

the database matching module specifically comprises:

the quantity determining unit is used for determining the data query quantity in the data query request;

the data searching unit is used for searching the service data of the data query quantity in a database to-be-searched data table according to the target activity, wherein the to-be-searched data table stores the service data and the activity data in an associated manner;

and the target data determining unit is used for taking the searched service data as target service data.

6. An electronic device, characterized in that the device comprises:

one or more processors;

a memory for storing one or more programs;

when executed by the one or more processors, cause the one or more processors to implement the data query method of any one of claims 1-4.

7. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the data query method according to any one of claims 1 to 4.

Images