CN113987322A

CN113987322A - Index data query method, device, computer equipment and computer program product

Info

Publication number: CN113987322A
Application number: CN202111331360.6A
Authority: CN
Inventors: 夏鹏
Original assignee: Industrial and Commercial Bank of China Ltd ICBC
Current assignee: Industrial and Commercial Bank of China Ltd ICBC
Priority date: 2021-11-11
Filing date: 2021-11-11
Publication date: 2022-01-28

Abstract

The present application relates to an index data query method, apparatus, computer equipment, storage medium and computer program product. The indicator data query method of the present application can be applied to the financial field or other fields. The method includes: receiving an indicator data query request sent by a terminal, the indicator data query request carrying a target indicator keyword; in response to the indicator data query request, based on the target indicator key to obtain the target query key value; based on the target query key value, the indicator data query is performed in the indicator data cache to obtain the first indicator data group; when the first indicator data group is the sub-data group requested by the indicator data query request, the target The query key value performs index data query in the index database to obtain the second index data group; merges the first index data group and the second index data group, and obtains the target index data group based on the combined data; sends the target index data group to terminal. Using the method can improve the data query efficiency.

Description

Index data query method and device, computer equipment and computer program product

Technical Field

The present application relates to the field of internet technologies, and in particular, to a method, an apparatus, a computer device, and a computer program product for index data query.

Background

With the development of internet technology, more and more data are stored in an internet system, and when a user needs to acquire data, the user can send a data query request through a terminal to query and obtain the data to be acquired.

In the conventional technology, data can be uniformly stored in a plurality of data storage spaces, and when a query request is received, a data storage space which is searched preferentially is determined, and the data is queried in the data storage space. And if the data queried in the currently queried data storage space does not meet the query request, querying in other data storage spaces again until the data meeting the query request is queried in one data storage space, so that the query efficiency is low.

Disclosure of Invention

In view of the above, it is necessary to provide an index data query method, an apparatus, a computer device, a computer readable storage medium, and a computer program product, which can improve query efficiency.

In a first aspect, the present application provides an index data query method. The method comprises the following steps: receiving an index data query request sent by a terminal, wherein the index data query request carries a target index keyword; responding to the index data query request, and obtaining a target query key value based on the target index keyword; index data is queried in an index data cache based on the target query key value to obtain a first index data group; when the first index data group is the subdata group requested by the index data query request, performing index data query in an index database based on the target query key value to obtain a second index data group; merging the first index data set and the second index data set, and obtaining a target index data set based on merged data; and sending the target index data group to the terminal.

In a second aspect, the application further provides an index data query device. The device comprises: the index data query request receiving module is used for receiving an index data query request sent by a terminal, wherein the index data query request carries a target index keyword; a target query key value obtaining module, configured to respond to the index data query request and obtain a target query key value based on the target index keyword; a first index data group obtaining module, configured to perform index data query in an index data cache based on the target query key value to obtain a first index data group; a second index data set obtaining module, configured to, when the first index data set is a sub data set requested by the index data query request, perform index data query in an index database based on the target query key value to obtain a second index data set; the merging module is used for merging the first index data group and the second index data group and obtaining a target index data group based on merged data; and the first sending module is used for sending the target index data group to the terminal.

In one embodiment, the second index data set obtaining module is configured to: acquiring a target data time range corresponding to the index data query request and acquiring an index data time range corresponding to the first index data group; and when the index data time range is a sub time range of the target data time range, determining that the first index data group is a sub data group requested by the index data query request, and performing index data query in an index database based on the target query key value to obtain a second index data group.

In one embodiment, the target query key value obtaining module is configured to: acquiring derived index keywords and non-derived index keywords in the target index keywords; acquiring a parent index keyword set corresponding to the derived index keywords, wherein the parent index keyword set comprises a plurality of parent index keywords; combining each parent index keyword in the parent index keyword set with the non-derived index keyword respectively to obtain a plurality of index keyword combinations; acquiring query key values respectively corresponding to the index key combinations and respectively taking the query key values as the target query key values; the merging module is used for: merging the first index data set and the second index data set to obtain a query data set corresponding to the target query key value; and acquiring a data derivation mode corresponding to the derivation index keyword, and deriving the query data group obtained by query based on the data derivation mode to obtain a target index data group.

In one embodiment, the apparatus further includes a first caching module configured to: generating a first cache query key value corresponding to the target index data set based on the derived index key words and the non-derived index key words; and correspondingly storing the target index data group and the first cache query key value in the index data cache.

In one embodiment, the terminal displays a target index data map corresponding to the target index data set, and the apparatus further includes: an indicator map caching request receiving module, configured to receive an indicator map caching request sent by the terminal, where the indicator map caching request carries map operation record information corresponding to the target indicator data map; the second cache module is used for generating a second cache query key value corresponding to the graph operation record information and correspondingly storing the graph operation record information and the second cache query key value in the index data cache; the graph operation record information acquisition module is used for receiving a graph acquisition request corresponding to the target index data graph and sent by the terminal, and acquiring the graph operation record information based on the second cache query key value; and the second sending module is used for sending the graph operation record information and the target index data group to the terminal so that the terminal generates the target index data graph based on the target index data group, and operates the target index data graph based on the graph operation record information to obtain and display the operated target index data graph.

In one embodiment, the index map caching request further carries target map operation description information corresponding to the target index data map, and the apparatus further includes: a corresponding relation establishing module, configured to establish a corresponding relation between the target graph operation description information and the second cache query key value in the index data cache; a graph operation description information set sending module, configured to send a graph operation description information set to the terminal, so that the terminal displays the graph operation description information set, where the graph operation description information set includes the target graph operation description information; the map connecting operation record information acquisition module is used for: receiving a graph acquisition request corresponding to the target index data graph sent by the terminal, wherein the graph acquisition request carries the target graph operation description information, and the target graph operation description information is carried in the graph acquisition request when the graph description information selection operation selects the target graph operation description information in response to the graph description information selection operation of the terminal; and obtaining a corresponding second cache query key value according to the corresponding relation and the target graph operation description information, and obtaining the graph operation record information based on the second cache query key value.

In a third aspect, the present application also provides a computer device. The computer device comprises a memory storing a computer program and a processor implementing the following steps when executing the computer program: receiving an index data query request sent by a terminal, wherein the index data query request carries a target index keyword; responding to the index data query request, and obtaining a target query key value based on the target index keyword; index data is queried in an index data cache based on the target query key value to obtain a first index data group; when the first index data group is the subdata group requested by the index data query request, performing index data query in an index database based on the target query key value to obtain a second index data group; merging the first index data set and the second index data set, and obtaining a target index data set based on merged data; and sending the target index data group to the terminal.

In a fourth aspect, the present application further provides a computer-readable storage medium. The computer-readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of: receiving an index data query request sent by a terminal, wherein the index data query request carries a target index keyword; responding to the index data query request, and obtaining a target query key value based on the target index keyword; index data is queried in an index data cache based on the target query key value to obtain a first index data group; when the first index data group is the subdata group requested by the index data query request, performing index data query in an index database based on the target query key value to obtain a second index data group; merging the first index data set and the second index data set, and obtaining a target index data set based on merged data; and sending the target index data group to the terminal.

In a fifth aspect, the present application further provides a computer program product. The computer program product comprising a computer program which when executed by a processor performs the steps of: receiving an index data query request sent by a terminal, wherein the index data query request carries a target index keyword; responding to the index data query request, and obtaining a target query key value based on the target index keyword; index data is queried in an index data cache based on the target query key value to obtain a first index data group; when the first index data group is the subdata group requested by the index data query request, performing index data query in an index database based on the target query key value to obtain a second index data group; merging the first index data set and the second index data set, and obtaining a target index data set based on merged data; and sending the target index data group to the terminal.

According to the index data query method, the index data query device, the computer equipment, the storage medium and the computer program product, an index data query request sent by a terminal is received, and the index data query request carries a target index keyword; responding to the index data query request, and obtaining a target query key value based on the target index keyword; index data is queried in the index data cache based on the target query key value to obtain a first index data group; when the first index data group is a subdata group requested by the index data query request, performing index data query in an index database based on a target query key value to obtain a second index data group; merging the first index data set and the second index data set, and obtaining a target index data set based on merged data; the target index data group is sent to the terminal, and data to be inquired by one index data inquiry request is merged based on the index data cache and the data inquired in the index database, so that the data inquired in the index data cache does not need to be repeatedly inquired in the index database, the inquiry efficiency is improved, the data group is merged, the completeness of index data inquiry is ensured, the index data is preferably inquired in the index data cache, the inquiry speed in the index data cache is high, and the inquiry efficiency of the index data is further improved.

Drawings

FIG. 1 is a diagram of an exemplary implementation of a method for querying index data;

FIG. 2 is a flow diagram illustrating a method for index data lookup in one embodiment;

FIG. 3 is a flowchart illustrating a step of obtaining a target query key based on a target index key in one embodiment;

FIG. 4 is a flowchart illustrating a method for querying index data according to an embodiment;

FIG. 5 is a diagram illustrating a structure of a redis cluster in an embodiment;

FIG. 6 is a block diagram showing the structure of an index data searching apparatus according to an embodiment;

FIG. 7 is a diagram illustrating an internal structure of a computer device according to an embodiment.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.

The index data query method provided by the application can be used for index data query in the financial field, for example, the index data query method can be applied to index data query of financial service data, and can also be used for index data query in any field except the financial field, and the application field of the index data query method is not limited.

The index data query method provided by the embodiment of the application can be applied to the application environment shown in fig. 1. Wherein the terminal 102 communicates with the server 104 via a network. The data storage system may store data that the server 104 needs to process. The data storage system may be integrated on the server 104, or may be located on the cloud or other network server. The terminal 102 may send an index data query request to the server 104, and the server 104 executes the index data query method provided in the present application to query to obtain a query result, for example, a target index data set, and sends the query result to the terminal 102. The terminal 102 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, internet of things devices and portable wearable devices, and the internet of things devices may be smart speakers, smart televisions, smart air conditioners, smart car-mounted devices, and the like. The portable wearable device can be a smart watch, a smart bracelet, a head-mounted device, and the like. The server 104 may be implemented as a stand-alone server or as a server cluster comprised of multiple servers.

In an embodiment, as shown in fig. 2, a method for querying index data is provided, which is described by taking the method as an example applied to the server in fig. 1, and includes the following steps:

step S202, an index data query request sent by a terminal is received, and the index data query request carries a target index keyword.

The index data query request is used for requesting to query index data, and the index data is data related to indexes, such as at least one of index dimensions including user indexes or product indexes. The user index may be, for example, deposit data of the user, such as the total amount of the user's current deposit and the total amount of the user's regular deposit per month of a certain bank, and the business condition of the bank can be determined by these data. The product indicator may be, for example, indicator data of a certain business product, such as usage of the business product. The index key is used to identify the index, and is at least one of a name of the index or a number of the index, for example. The target index keyword may be one or more.

In the embodiment of the application, the terminal can receive index data query operation of a user, determine an index selected by the user, respond to the index data query operation, send an index data query request and carry an index keyword corresponding to the index selected by the user, and the server receives the index data query request sent by the terminal.

For example, the terminal may display an index selection page, and the user selects an index on the index selection page by operating, for example, the currency of the currency, the mechanism corresponding to the index, and the dimension of the index. Or, index keywords corresponding to each graph template are preset, and when the terminal receives graph generation operation corresponding to the graph template, the terminal generates an index data query request and carries the index keywords corresponding to the graph template.

Step S204, responding to the index data query request, and obtaining a target query key value based on the target index keyword.

The query key value is a key value for querying data. The data is stored in a data cache and a database in a key-value storage mode, the target query key value is a key value in the key-value storage mode, and the data is a value. The target query key value is obtained based on the target index key word, for example, the target index key word may be used as the key value, or the hash calculation may be performed on the target index key word, and the obtained hash value is used as the key value. For example, if the index includes key elements such as an index number, an index currency, an index mechanism, and time corresponding to the index, the index keywords corresponding to the key elements may be spliced, a separator "|" may be added between the index keywords, and the spliced character string is used as a target index query key value.

In the embodiment of the application, the server receives the index data query request, extracts the target index keyword from the index data query request, and obtains the target query key value based on the target index keyword.

Step S206, index data is queried in the index data cache based on the target query key value, and a first index data group is obtained.

The pointer data cache is a cache space for storing the pointer data, the cache is a high-speed memory with a faster access speed than a general Random Access Memory (RAM), and the pointer data cache may be, for example, a redis (remote directory server) cache. The first index data group is data obtained by querying in the index data cache based on the target query key value.

In this embodiment of the application, the server may query whether an index data group corresponding to the target query key value exists in the index data cache, and if so, use the corresponding index data group as the first index data group.

Step S208, when the first index data group is the sub data group requested by the index data query request, index data query is performed in the index database based on the target query key value, and a second index data group is obtained.

In this embodiment of the present application, the first index data group being the sub data group requested by the index data query request means: the first index data group is not a complete data group requested by the index data query request and corresponds to the target query key value, but only a part of data in the complete data group. The index database is a database for storing index data, is not stored in a cache manner, and has a slower access speed than the cache. The index data in the index database is stored in a key value pair storage mode, the server can inquire whether the index database has an index data group corresponding to the target inquiry key value, and if so, the corresponding index data group is used as a second index data group. When the second index data group is queried, the server takes the data corresponding to the first index data group as data which does not need to be queried, so that the data which is not queried in the live broadcast data cache is queried in the database.

It can be understood that, when the first index data group is a complete data group requested by the index data query request, the server does not execute the step of performing index data query in the index database based on the target query key value to obtain the second index data group any more, and the server may directly return the first index data group to the terminal.

In one embodiment, whether the first index data group is a sub data group requested by the index data query request may be determined according to a target data time range corresponding to the index data query request, or may be determined according to the data identifier. For example, the query request carries a plurality of data identifiers, and when it is determined that data corresponding to each data identifier is not all available for querying in the index data cache, the first index data group is determined to be the sub data group requested by the index data query request.

In one embodiment, the step of determining whether the first index data group is a sub data group requested by the index data query request according to the target data time range corresponding to the index data query request may include: acquiring a target data time range corresponding to the index data query request and acquiring an index data time range corresponding to the first index data group; and when the index data time range is the sub time range of the target data time range, determining that the first index data group is the sub data group requested by the index data query request, and performing index data query in the index database based on the target query key value to obtain a second index data group.

The target data time range corresponding to the index data query request refers to a time range corresponding to data to be queried by the index data query request, and the target data time range can be carried in the index data query request or can be automatically determined by the server. For example, when a service condition for inquiring the current balance is set in the server, the current balance of the last 10 years is automatically acquired. The index data time range corresponding to the first index data group is a time range corresponding to data in the first index data group, and the index data cache stores a corresponding relationship between the data and time, so that the time range corresponding to the first index data group obtained by query can be determined according to the corresponding relationship, for example, data in 2015 to 2021. And when the index data time range is a sub-time range of the target data time range, indicating that data of a part of time is not obtained in the index data cache. For example, assuming that the target data time range is 2010 to 2020 and the time range corresponding to the first index data group is 2015 to 2020 data, the index data time range is a sub-time range of the target data time range, and the first index data group is determined to be the sub-data group requested by the index data query request.

In the embodiment of the application, whether the first index data group is the sub data group requested by the index data query request is judged through the data time range, so that the judgment efficiency can be improved, and the judgment accuracy can be ensured.

And step S210, merging the first index data set and the second index data set, and obtaining a target index data set based on merged data.

In this embodiment of the application, the first index data group and the second index data group may be spliced to obtain the target index data group, or calculation, for example, summation calculation, may be performed based on the first index data group and the second index data group, and the calculated data group is used as the target index data group. The calculation mode is determined according to the relationship between the first index data group and the second index data group and the data to be acquired by the index data query request, for example, if the first index data group is the index data of the last two months of a year and the second index data group is the index data of 1-10 months, and when the data to be acquired by the index data query request is the year statistical data, the data of the first index data group and the second index data group are added to obtain the year statistical data of the year.

And step S212, transmitting the target index data set to the terminal.

In the embodiment of the application, the server sends the target index data group to the terminal, so that the terminal can display the data in the target index data group, and the display mode may be a chart mode or a text mode, and is not particularly limited. For example, the terminal may generate an index trend chart and display, for example, a change line chart of the total amount of the demand deposit to illustrate the change of the total amount of the demand deposit over time.

In one embodiment, the server may merge the first set of metric data and the second set of metric data into a json (JavaScript Object Notation) data Object. The terminal can obtain the json data object by using an ajax (Asynchronous JavaScript And XML) calling mode. Wherein json is a lightweight data exchange format. XML is short for extensible markup language.

In the index data query method, an index data query request sent by a terminal is received, and the index data query request carries a target index keyword; responding to the index data query request, and obtaining a target query key value based on the target index keyword; index data is queried in the index data cache based on the target query key value to obtain a first index data group; when the first index data group is a subdata group requested by the index data query request, performing index data query in an index database based on a target query key value to obtain a second index data group; merging the first index data set and the second index data set, and obtaining a target index data set based on merged data; and sending the target index data set to the terminal. Because the data to be queried of one index data query request is merged based on the index data cache and the data queried in the index database, the data queried in the cache does not need to be repeatedly queried in the index database, the query efficiency is improved, the completeness of index data query is guaranteed by merging data groups, the index data is preferentially queried in the index data cache, the query speed in the index data cache is high, and the query efficiency of the index data is further improved.

In one embodiment, the dimension of the index can be determined according to the attributes of the business field, for example, the dimension of the index can be summarized into a time dimension, a space dimension and a customer dimension according to the characteristics of the financial field, and the index of the time dimension comprises general day, month, season, year, ring ratio, year, month, yesterday and the like, and the current business index can be analyzed through the indexes. The spatial dimensions are classified according to the interior, province, city, etc., for example, 5-level classification is performed, and corresponding indexes are classified according to several regions and countries.

In one embodiment, the server provides data support for business analysis by combining with a time dimension, and performs business pushing through indexes of a client dimension such as assets and behaviors, and pushed contents can be related business products, so that the accuracy of content pushing is guaranteed.

In one embodiment, as shown in fig. 3, obtaining the target query key value based on the target index keyword includes:

step S302, a derived index keyword and a non-derived index keyword in the target index keyword are obtained.

The derived index data is obtained by combining a plurality of index data, and the index data from which the derived index data is obtained is called parent index data. For example, the total deposit sum may be the sum of the current deposit sum and the fixed deposit sum, the total deposit sum is a derivative index, and the current deposit sum and the fixed deposit sum are parent indexes.

In the embodiment of the application, the server can judge whether the data corresponding to the target index keyword is calculated and stored, if so, the target index keyword is a non-derivative index keyword, otherwise, the target index keyword is used as a derivative index keyword. For example, assuming that data of the total deposit sum has been previously calculated and stored based on the current deposit sum and the fixed deposit sum, the total deposit sum is a non-derivative index key. Assuming that the data of the total deposit sum is not calculated based on the current deposit sum and the fixed deposit sum, the total deposit sum is a derivative index key.

Step S304, a mother index keyword set corresponding to the derived index keywords is obtained, and the mother index keyword set comprises a plurality of mother index keywords.

The server may set a corresponding relationship between the index keywords, for example, when the total deposit sum is set as the derivative index, the corresponding parent indexes are the current deposit sum and the fixed deposit sum. The server may obtain a parent index keyword corresponding to the derived index keyword based on the correspondence and the derived index keyword, and since data corresponding to the derived index keyword is derived from a plurality of data, the parent index keyword set includes a plurality of parent index keywords, and "plurality" means at least two.

Step S306, combining each parent index keyword in the parent index keyword set with the non-derivative index keywords respectively to obtain a plurality of index keyword combinations.

For example, assuming that the non-derived index key includes index organization a and the parent index key set includes the total amount of the demand deposit and the total amount of the periodic deposit, the index organization a and the total amount of the demand deposit may be combined to obtain a first index key combination, and the index organization a and the total amount of the periodic deposit may be combined to obtain a second index key combination.

In one embodiment, when there are a plurality of derived index keywords, the parent index keywords in the parent index keyword sets corresponding to different derived index keywords are combined, that is, each time the combination is performed, a parent index keyword is selected from each parent index keyword set, and the selected parent index keywords are combined with the non-derived index keywords to obtain an index keyword combination. For example, assume that there are 4 target index keywords: a. b, c and d, wherein the derived index keywords are a and b, respectively, and the non-derived index keywords are c and d, respectively. a corresponding mother index keyword set includes a1 and a2, B corresponding mother index keyword set includes B1 and B2, when the combination is performed, a1 is selected from the mother index keyword set corresponding to a, B1 is selected from the mother index keyword set corresponding to B, a1, B1, c and d are combined to obtain an index keyword combination composed of a1, B1, c and d, it can be understood that, according to the above combination mode, the index keyword combination may further include: the index key combinations of A1, B2, c and d, the index key combinations of A2, B1, c and d, and the index key combinations of A2, B2, c and d.

Step S308, obtaining query key values respectively corresponding to each index keyword combination, and respectively using the query key values as target query key values.

The method includes the steps of obtaining index key combinations, obtaining query key values by splicing keywords of the index key combinations, obtaining query key values by performing hash calculation on the keyword combinations, obtaining the query key values by enabling each index key combination to correspond to one query key value, using the obtained query key values as target query key values respectively, and performing query based on each target query key value to obtain query data corresponding to each index key combination.

In one embodiment, merging the first index data set with the second index data set, and obtaining the target index data set based on the merged data includes: merging the first index data group and the second index data group to obtain a query data group corresponding to the target query key value; and acquiring a data derivation mode corresponding to the derivation index keyword, and deriving the query data group obtained by query based on the data derivation mode to obtain a target index data group.

The data derivation method may be a preset calculation method, and may be, for example, one or more of summation, difference, multiplication, or division. The server may merge the first index data group and the second index data group obtained by querying each target query key value to obtain a query data group corresponding to each target query key value. And then, carrying out derivation processing on the query data group corresponding to the derived index keyword to obtain a target index data group.

Taking the example of combining the organization a with the total amount of the current deposit to obtain the first index key combination, and combining the organization a with the total amount of the current deposit to obtain the second index key combination, the server may obtain the first index data group Z1 and the second index data group Z2 corresponding to the first index key combination by querying, and obtain the first index data group Z3 and the second index data group Z4 corresponding to the second index key combination by querying. Combining Z1 and Z2 to obtain the total of the current deposit of the mechanism A in each year 2010-2020, which is called data H1, and combining Z3 and Z4 to obtain the total of the periodic deposit of the mechanism A in each year 2010-2020, which is called data H2, and the data derivation mode corresponding to the total deposit is that the data of each year are respectively summed, so that the total of the periodic deposit of the same year in H1 and H2 and the total of the current deposit can be summed to obtain the total of the current deposit of the mechanism A in each year 2010-2020, which is used as a target index data set.

In the embodiment of the application, for data which is not directly stored in the index data cache, the target index keywords can be divided into derived index keywords and non-derived index keywords, and then the derived index keywords and the non-derived index keywords are combined to obtain a plurality of combinations to be respectively queried, and then the data requested by the index data query request is derived based on the queried data, so that the condition of index data query failure can be reduced, and the efficiency of index data query is improved.

In one embodiment, the index data query method further comprises: generating a first cache query key value corresponding to the target index data set based on the derived index key words and the non-derived index key words; and correspondingly storing the target index data group and the first cache query key value in the index data cache.

The method includes the steps of performing hash calculation on derived index keywords and non-derived index keywords or splicing the derived index keywords and the non-derived index keywords to obtain a first cache query key value, storing a target index data group and the first cache query key value in an index data cache by a server, and establishing a corresponding relation between the target index data group and the first cache query key value, namely, taking the first cache query key value as a key and the target index data group as a value, so that when the same index data query request is received subsequently, steps S302 to S304 do not need to be executed, the target index data group can be obtained by total query in the index data cache directly based on the first cache query key value, and the query efficiency is improved.

In one embodiment, after the terminal receives the target index data set, the terminal can perform rich graphical display on the target index data graph through the graphical plug-in, so that a corresponding index trend analysis function is realized. For example, a target index data graph corresponding to the target index data group is shown, and the specific form of the target index data graph may be different according to the actual situation, and may be, for example, a line graph or a bar graph. As shown in fig. 4, the index data query method further includes the following steps:

step S402, receiving an index map caching request sent by the terminal, wherein the index map caching request carries map operation record information corresponding to the target index data map.

The graph operation record information is record information for recording the operation on the target index data graph received in the terminal. The graph operation record information includes the type of operation and object information of the operation. The object information of the operation may include graph information before the operation and graph information after the operation. For example, when the terminal receives an information adding operation for adding the description information to the diagram, the type of the operation may be "insert operation", the diagram information before the operation is empty, the diagram information after the operation is the added description information, and the diagram operation record information may further include the position of the operation.

In this embodiment of the application, the terminal may send an index map caching request when receiving a storage operation for a target index data map, for example, a storage control on the terminal may display the target index data map, and when receiving a trigger operation for the storage control, send the index map caching request to indicate that a target index data map modified by a user is to be stored.

Step S404, generating a second cache query key corresponding to the graph operation record information, and storing the graph operation record information and the second cache query key in the index data cache correspondingly.

The second cache query key value may be obtained by performing hash calculation based on the graph operation record information, or may be randomly generated. The server stores the graph operation record information and a second cache query key value in the index data cache, and establishes a corresponding relation between the graph operation record information and the second cache query key value, namely, the second cache query key value is used as a key, and the graph operation record information is used as a value.

In one embodiment, the server may use a combination of the operation record information and the target index data set as a cache object, and store the second cache query key value and the cache object correspondingly.

Step S406, receiving a graph obtaining request corresponding to the target index data graph sent by the terminal, and obtaining graph operation record information based on the second cache query key value.

The graph obtaining request corresponding to the target index data graph is used for requesting to obtain the target index data graph modified by the user. Because the server correspondingly stores the graph operation record information and the second cache query key value in the index data cache, the graph operation record information corresponding to the second cache query key value can be obtained in the index data cache.

In an embodiment, when the server uses the combination of the operation record information and the target index data group as a cache object, the server may obtain the cache object corresponding to the second cache query key value, and extract the graph operation record information and the target index data group in the cache object, so that the target index data group and the graph operation record information may be obtained together, and the information obtaining efficiency is improved.

Step S408, sending the graph operation record information and the target index data set to the terminal so that the terminal generates a target index data graph based on the target index data set, and operating the target index data graph based on the graph operation record information to obtain and display the operated target index data graph.

In the embodiment of the application, the server sends the graph operation record information and the target index data set to the terminal, so that the terminal generates an original target index data graph according to an original graph generation mode, namely a graph generation mode before modification, and then operates the target index data graph based on the graph operation record information, so that the operated target index data graph displayed in the terminal is consistent with a graph obtained by modifying the original target index data graph by a user, and the efficiency of obtaining the target index data graph by the terminal is improved.

In an embodiment, the graph operation record information may include a plurality of graph operation records, and the target index data graph may be sequentially operated according to an operation sequence of the graph operation records, so as to obtain and display the operated target index data graph. When the target index data map is operated based on the map operation record, an operation may be performed at an operation position corresponding to the target index data map, for example, by adding explanatory information, based on the operation position in the map operation record.

For example, when a user sees a target index data map, the map may be modified according to actual needs, for example, specification information is inserted or a pattern of a chart is adjusted, the terminal may record operation information of the user operating the index data map, after the user modification is completed, the terminal may automatically or according to the user operation send an index map caching request to the server, and the server may store the map operation record information and the target index data map and generate a corresponding second caching query key value. Therefore, when the user needs to check the modified target index data graph next time, the terminal receives the graph obtaining operation of the user, and triggers to send a graph obtaining request to the server in response to the graph obtaining operation, so that the server can return the graph operation record information and the target index data set, the target index data graph displayed at the terminal is the graph modified by the user, the display of the target index data graph is more flexible, and the requirements of the user are better met.

In one embodiment, the index map caching request further carries target map operation description information corresponding to the target index data map, and the index data query method further includes: establishing a corresponding relation between the operation description information of the target graph and a second cache query key value in the index data cache; sending the graph operation description information set to a terminal so that the terminal displays a graph operation description information set, wherein the graph operation description information set comprises target graph operation description information; receiving a graph obtaining request corresponding to a target index data graph sent by a terminal, and obtaining graph operation record information based on a second cache query key value comprises the following steps: receiving a graph acquisition request corresponding to a target index data graph sent by a terminal, wherein the graph acquisition request carries target graph operation description information, and the target graph operation description information is carried in the graph acquisition request when the terminal responds to graph description information selection operation and the graph description information selection operation selects the target graph operation description information; and obtaining a corresponding second cache query key value according to the corresponding relation and the target graph operation description information, and obtaining graph operation record information based on the second cache query key value.

The graph operation description information is information that generally describes one or more operations performed on the graph, and may be automatically generated based on a user operation on the graph, and may be capable of summarizing the graph operation, for example, if the user adds an explanation on a broken line graph in the graph, the graph operation description information may be: "adding an index map of explanatory information". The graph operation description information may also be input by a user, for example, when it is detected that the user operates the target index data graph and the operation is completed, the terminal may display a description information input box to receive the graph operation description information input by the user. The diagram operation description information input by the user is a general description, and may be a description of what diagram is generated or what operation is specifically performed after a series of operations performed by the user, for example, when the first modification is completed, the user may input diagram operation description information "index diagram modification version 1". When the second modification is completed, the user may input the graph operation description information "index graph modification version 2".

The graph operation description information set is a set of operation description information of the target index data graph modified by the user, for example, if the user modifies twice, the graph operation description information may be two. A modification may include one or more operations.

The server may use the graph operation description information and the graph operation record information as cache objects, and store a corresponding relationship between the cache objects and the second cache query key values in the index data cache. When the terminal requests a page for displaying the index data diagram, the server can send the graph operation description information set to the terminal together, so that the terminal can display the graph operation description information set on the page for displaying the index data diagram, a user can see the graph operation description information set and can select graph operation description information from the graph operation description information set, and when the graph operation description information selection operation executed by the user selects target graph operation description information, the terminal carries the target graph operation description information in the graph acquisition request.

Because the corresponding relationship between the target graph operation description information and the second cache query key value is established in the index data cache, the cache query key value corresponding to the target graph operation description information, namely the second cache query key value, can be obtained based on the corresponding relationship, and thus the server can obtain the graph operation record information based on the second cache query key value.

For example, assuming that the graph operation description information set includes "index map modification version 1" and "index map modification version 2", the two pieces of description information are displayed on a page in a list form, when a user wants to view a target index data map corresponding to "index map modification version 1", the user may select, for example, to click "index map modification version 1", and send a map acquisition request carrying "index map modification version 1", and since a second cache query key value corresponding to "index map modification version 1" is stored in the server, the second cache query key value may be acquired, and a target index data map corresponding to "index map modification version 1" is acquired.

In the embodiment of the application, the corresponding relation between the target graph operation description information and the second cache query key value is stored, and the operation description information is obtained based on the operation of the user or is input by the user, so that the user can know the modification condition of the target index data graph corresponding to the operation description information, the user can know the graph to be checked based on the graph operation description information, the server can acquire the corresponding graph based on the selection operation of the graph operation description information, and the efficiency and the accuracy of acquiring the modified graph by the user are improved.

In one embodiment, the graph template may also be generated based on the graph operation record information and cached. When a chart generation request carrying the chart template is received, an index data chart is generated based on the chart template and data to be acquired.

In one embodiment, different categories of index data may also be selected for caching based on the time dimension. That is, the data query frequency of various data corresponding to each time dimension may be obtained, the high-frequency access data corresponding to each time dimension is obtained therefrom, and is stored in the index data cache, for example, for a time dimension of the year, the high-frequency access data corresponding to the time dimension is data of the organization a, and the annual service data of the organization a is stored in the index data cache. For the time dimension of the quarter, the corresponding high-frequency access data is the data of the B organization, the quarter service data of the B organization is stored in the index data cache,

the index data query method provided by the embodiment of the application can be applied to the business fields of banks, security dealers, insurance and the like, graphs for trend analysis of the indexes can be generated based on the dimension indexes, corresponding prediction can be made on the future development of enterprises through the index trend graphs, and for example, the operation profits of the enterprises or the operation directions of the enterprises can be predicted through the analysis of the indexes. The index data can be stored in the distributed cluster cache, and the efficiency of repeatedly reading the index data can be effectively improved through the distributed cluster cache.

In one embodiment, the method and the device can adopt a redis cluster as index data cache, and can directly query data from a memory, so that the access efficiency is improved, multiple accesses to a database are reduced, and the stability of the system is guaranteed. As shown in fig. 5, a cache environment may be established in a cluster mode, a zookeeper is used to manage a redis cluster, and a zookeeper election mechanism is used to ensure that a cluster can still normally operate after a single node is down, thereby ensuring high availability of the cluster. The redis is based on memory operation, so that timeliness of data transmission display is guaranteed, and the method is suitable for a system with high concurrency of big data. Meanwhile, a mechanism for clearing cache is provided for dormant data redis, so that high-frequency index access is preferentially ensured. zookeeper is a distributed service framework.

It should be understood that, although the steps in the flowcharts related to the embodiments are shown in sequence as indicated by the arrows, the steps are not necessarily executed in sequence as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least a part of the steps in the flowcharts related to the above embodiments may include multiple steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of performing the steps or stages is not necessarily sequential, but may be performed alternately or alternately with other steps or at least a part of the steps or stages in other steps.

Based on the same inventive concept, the embodiment of the application also provides an index data query device for realizing the index data query method. The implementation scheme for solving the problem provided by the device is similar to the implementation scheme described in the above method, so that specific limitations in one or more embodiments of the index data query device provided below can be referred to the limitations of the index data query method in the above, and details are not described herein again.

In one embodiment, as shown in fig. 6, there is provided a metric data query apparatus including:

the index data query request receiving module 602 is configured to receive an index data query request sent by a terminal, where the index data query request carries a target index keyword.

A target query key value obtaining module 604, configured to, in response to the index data query request, obtain a target query key value based on the target index keyword.

A first index data set obtaining module 606, configured to perform index data query in the index data cache based on the target query key value, so as to obtain a first index data set.

A second index data set obtaining module 608, configured to, when the first index data set is a sub data set requested by the index data query request, perform index data query in the index database based on the target query key value to obtain a second index data set.

And a merging module 610, configured to merge the first index data set and the second index data set, and obtain a target index data set based on the merged data.

A first sending module 612, configured to send the target indicator data set to the terminal.

In one embodiment, the second index data set obtaining module is configured to: acquiring a target data time range corresponding to the index data query request and acquiring an index data time range corresponding to the first index data group; and when the index data time range is the sub time range of the target data time range, determining that the first index data group is the sub data group requested by the index data query request, and performing index data query in the index database based on the target query key value to obtain a second index data group.

In one embodiment, the target query key value obtaining module is configured to: acquiring derived index keywords and non-derived index keywords in the target index keywords; acquiring a parent index keyword set corresponding to the derivative index keywords, wherein the parent index keyword set comprises a plurality of parent index keywords; combining each parent index keyword in the parent index keyword set with a non-derivative index keyword respectively to obtain a plurality of index keyword combinations; acquiring query key values respectively corresponding to each index keyword combination and respectively taking the query key values as target query key values;

the merging module is used for: merging the first index data group and the second index data group to obtain a query data group corresponding to the target query key value; and acquiring a data derivation mode corresponding to the derivation index keyword, and deriving the query data group obtained by query based on the data derivation mode to obtain a target index data group.

In one embodiment, the terminal displays a target index data graph corresponding to the target index data set, and the apparatus further includes: the index map caching request receiving module is used for receiving an index map caching request sent by a terminal, and the index map caching request carries map operation record information corresponding to a target index data map; the second cache module is used for generating a second cache query key value corresponding to the graph operation record information and correspondingly storing the graph operation record information and the second cache query key value in the index data cache; the graph operation record information acquisition module is used for receiving a graph acquisition request corresponding to the target index data graph sent by the terminal and acquiring graph operation record information based on a second cache query key value; and the second sending module is used for sending the graph operation record information and the target index data group to the terminal so that the terminal generates a target index data graph based on the target index data group, and operates the target index data graph based on the graph operation record information to obtain and display the operated target index data graph.

In one embodiment, the index map caching request further carries target map operation description information corresponding to the target index data map, and the apparatus further includes: the corresponding relation establishing module is used for establishing the corresponding relation between the target graph operation description information and the second cache query key value in the index data cache; the terminal comprises a graph operation description information set sending module, a graph operation description information set sending module and a graph operation description information set sending module, wherein the graph operation description information set sending module is used for sending the graph operation description information set to the terminal so as to enable the terminal to display the graph operation description information set, and the graph operation description information set comprises target graph operation description information; the map connecting operation record information acquisition module is used for: receiving a graph acquisition request corresponding to a target index data graph sent by a terminal, wherein the graph acquisition request carries target graph operation description information, and the target graph operation description information is carried in the graph acquisition request when the terminal responds to graph description information selection operation and the graph description information selection operation selects the target graph operation description information; and obtaining a corresponding second cache query key value according to the corresponding relation and the target graph operation description information, and obtaining graph operation record information based on the second cache query key value.

All or part of the modules in the index data query device can be realized by software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.

In one embodiment, a computer device is provided, which may be a server, the internal structure of which may be as shown in fig. 7. The computer device includes a processor, a memory, and a network interface connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The database of the computer device is used for storing the index data. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a method of index data query.

Those skilled in the art will appreciate that the architecture shown in fig. 7 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.

In one embodiment, a computer device is provided, comprising a memory and a processor, the memory having stored therein a computer program, the processor implementing the steps of the above-described method embodiments when executing the computer program.

In an embodiment, a computer-readable storage medium is provided, on which a computer program is stored, which computer program, when being executed by a processor, carries out the steps of the above-mentioned method embodiments.

In an embodiment, a computer program product is provided, comprising a computer program which, when being executed by a processor, carries out the steps of the above-mentioned method embodiments.

It should be noted that, the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data for analysis, stored data, presented data, etc.) referred to in the present application are information and data authorized by the user or sufficiently authorized by each party.

It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware related to instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, database, or other medium used in the embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high-density embedded nonvolatile Memory, resistive Random Access Memory (ReRAM), Magnetic Random Access Memory (MRAM), Ferroelectric Random Access Memory (FRAM), Phase Change Memory (PCM), graphene Memory, and the like. Volatile Memory can include Random Access Memory (RAM), external cache Memory, and the like. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM), among others. The databases referred to in various embodiments provided herein may include at least one of relational and non-relational databases. The non-relational database may include, but is not limited to, a block chain based distributed database, and the like. The processors referred to in the embodiments provided herein may be general purpose processors, central processing units, graphics processors, digital signal processors, programmable logic devices, quantum computing based data processing logic devices, etc., without limitation.

The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.

The above examples only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the present application. It should be noted that various changes and modifications can be made by one skilled in the art without departing from the spirit of the invention, and these changes and modifications are all within the scope of the invention. Therefore, the protection scope of the present application shall be subject to the appended claims.

Claims

1. An index data query method, characterized in that the method comprises:

receiving an index data query request sent by a terminal, wherein the index data query request carries a target index keyword;

responding to the index data query request, and obtaining a target query key value based on the target index keyword;

index data is queried in an index data cache based on the target query key value to obtain a first index data group;

when the first index data group is the subdata group requested by the index data query request, performing index data query in an index database based on the target query key value to obtain a second index data group;

merging the first index data set and the second index data set, and obtaining a target index data set based on merged data;

and sending the target index data group to the terminal.

2. The method of claim 1, wherein, when the first index data group is the sub data group requested by the index data query request, performing index data query in an index database based on the target query key value to obtain a second index data group comprises:

acquiring a target data time range corresponding to the index data query request and acquiring an index data time range corresponding to the first index data group;

and when the index data time range is a sub time range of the target data time range, determining that the first index data group is a sub data group requested by the index data query request, and performing index data query in an index database based on the target query key value to obtain a second index data group.

3. The method of claim 1, wherein obtaining a target query key value based on the target index keyword comprises:

acquiring derived index keywords and non-derived index keywords in the target index keywords;

acquiring a parent index keyword set corresponding to the derived index keywords, wherein the parent index keyword set comprises a plurality of parent index keywords;

combining each parent index keyword in the parent index keyword set with the non-derived index keyword respectively to obtain a plurality of index keyword combinations;

acquiring query key values respectively corresponding to the index key combinations and respectively taking the query key values as the target query key values;

the merging the first index data set and the second index data set, and obtaining a target index data set based on merged data includes:

merging the first index data set and the second index data set to obtain a query data set corresponding to the target query key value;

and acquiring a data derivation mode corresponding to the derivation index keyword, and deriving the query data group obtained by query based on the data derivation mode to obtain a target index data group.

4. The method of claim 3, further comprising:

generating a first cache query key value corresponding to the target index data set based on the derived index key words and the non-derived index key words;

and correspondingly storing the target index data group and the first cache query key value in the index data cache.

5. The method according to claim 1, wherein the terminal displays a target index data graph corresponding to the target index data set, and the method further comprises:

receiving an index map caching request sent by the terminal, wherein the index map caching request carries map operation record information corresponding to the target index data map;

generating a second cache query key value corresponding to the graph operation record information, and correspondingly storing the graph operation record information and the second cache query key value in the index data cache;

receiving a graph acquisition request corresponding to the target index data graph sent by the terminal, and acquiring the graph operation record information based on the second cache query key value;

and sending the graph operation record information and the target index data group to the terminal so that the terminal generates the target index data graph based on the target index data group, and operating the target index data graph based on the graph operation record information to obtain and display the operated target index data graph.

6. The method of claim 5, wherein the indicator map caching request further carries target map operation description information corresponding to the target indicator data map, and the method further comprises:

establishing a corresponding relation between the target graph operation description information and the second cache query key value in the index data cache;

sending a graph operation description information set to the terminal so that the terminal displays the graph operation description information set, wherein the graph operation description information set comprises the target graph operation description information;

the receiving a graph obtaining request corresponding to the target index data graph sent by the terminal, and obtaining the graph operation record information based on the second cache query key value includes:

receiving a graph acquisition request corresponding to the target index data graph sent by the terminal, wherein the graph acquisition request carries the target graph operation description information, and the target graph operation description information is carried in the graph acquisition request when the graph description information selection operation selects the target graph operation description information in response to the graph description information selection operation of the terminal;

and obtaining a corresponding second cache query key value according to the corresponding relation and the target graph operation description information, and obtaining the graph operation record information based on the second cache query key value.

7. An index data query apparatus, comprising:

the index data query request receiving module is used for receiving an index data query request sent by a terminal, wherein the index data query request carries a target index keyword;

a target query key value obtaining module, configured to respond to the index data query request and obtain a target query key value based on the target index keyword;

a first index data group obtaining module, configured to perform index data query in an index data cache based on the target query key value to obtain a first index data group;

a second index data set obtaining module, configured to, when the first index data set is a sub data set requested by the index data query request, perform index data query in an index database based on the target query key value to obtain a second index data set;

the merging module is used for merging the first index data group and the second index data group and obtaining a target index data group based on merged data;

and the first sending module is used for sending the target index data group to the terminal.

8. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor, when executing the computer program, implements the steps of the method of any of claims 1 to 6.

9. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 6.

10. A computer program product comprising a computer program, characterized in that the computer program realizes the steps of the method of any one of claims 1 to 6 when executed by a processor.