Transaction data query method, device and terminal of credit card management systemTechnical Field
The invention relates to the technical field of transaction data query, in particular to a transaction data query method, a device, a terminal and a storage medium of a credit card management system.
Background
Currently, most international large business fields (such as banks and telecommunications) use a mainframe parallel coupling system to operate their core business systems. In using a mainframe, a transaction data query of a credit card management system is typically involved. To improve data storage and retrieval efficiency, many companies utilize databases to store transaction data, for example, some transaction platforms set up databases to record each transaction of a merchant in real time. However, as the amount of data stored increases dramatically, many databases store a very large amount of data.
Therefore, when a data server built on a mainframe processes a transaction data query request, the data server is required to consume a large amount of resources to find target data from huge data. In addition, when a large number of users query data simultaneously, the data server needs to process the transaction data query request of each user, which also causes the data server to have too high load and too large resource consumption, and affects the processing of other tasks.
Disclosure of Invention
The invention provides a transaction data query method, a device, a terminal and a storage medium of a credit card management system, which aim to solve the problems that the processing of other tasks is influenced due to overhigh load and overlarge resource consumption when a current data server processes transaction data query.
In order to solve the problems, the invention adopts the following technical scheme:
the invention provides a transaction data query method of a credit card management system, which comprises the following steps:
the method comprises the steps that transaction data generated by each client side are obtained in real time through a data server, first transaction data with historical query frequency larger than a preset value are screened out from the transaction data, and the first transaction data are backed up to a cache of a service system; the service system comprises a database and a cache;
screening first transaction data with transaction time before a preset transaction time node from a cache of the service system, backing up the first transaction data to a database, and periodically clearing the first transaction data backed up to the database in the cache;
and responding to a transaction data query request of a client, acquiring target transaction data from the cache, the data server or the database according to preset conditions, and returning the target transaction data to the client.
In an embodiment, the step of obtaining the target transaction data from the cache, the data server or the database according to a preset condition includes:
calculating the current CPU utilization rate of the data server; the CPU utilization rate of the data server is the average CPU utilization rate of the data server in a preset period;
and when the CPU utilization rate of the data server is lower than a preset value, acquiring the target transaction data from the data server.
In an embodiment, after calculating the current CPU utilization of the data server, the method further includes:
when the CPU utilization rate of the data server is higher than a preset value, extracting the transaction time of the target transaction data to be acquired from the transaction data query request;
and acquiring target transaction data from a cache or a database according to the transaction time.
In one embodiment, the step of obtaining the target transaction data from the cache or the database according to the transaction time includes:
when the transaction time is before a preset transaction time node, acquiring the target transaction data from the database;
otherwise, the target transaction data is obtained from the cache of the service system.
In one embodiment, the step of backing up the first transaction data to a cache of the service system includes:
acquiring a data type of first transaction data;
inquiring a target service system corresponding to the data type from a pre-configured list according to the data type;
and backing up the first transaction data to a cache of a target service system.
In one embodiment, the step of backing up the first transaction data to a cache of the target service system includes:
monitoring the running state of the data server regularly;
when the data server is monitored to be in an idle state, backing up the first transaction data to a cache of a target service system;
in the process of backing up the first transaction data to the cache of the target service system, when the situation that the data server enters a busy state from an idle state is monitored, a backup breakpoint of the current first transaction data backup to the cache of the target service system is recorded;
and when the data server is monitored to be in an idle state again, the first transaction data is continuously backed up to the cache of the target service system from the backup breakpoint.
In an embodiment, before backing up the first transaction data to the cache of the service system, the method further includes:
establishing a transmission network taking a data server as a center;
each service system is accessed to the network node of the transmission network nearby; wherein the number of service systems accessed by each network node is less than a predetermined threshold.
The invention provides a transaction data inquiry device of a credit card management system, which comprises:
the backup module is used for acquiring transaction data generated by each client in real time through the data server, screening out first transaction data with historical query frequency larger than a preset value from the transaction data, and backing up the first transaction data to a cache of the service system; the service system comprises a database and a cache;
the clearing module is used for screening out first transaction data, the transaction time of which is before a preset transaction time node, from a cache of the service system and backing up the first transaction data to a database, and regularly clearing the first transaction data backed up to the database in the cache;
and the acquisition module is used for responding to a transaction data query request of a client, acquiring target transaction data from the cache, the data server or the database according to preset conditions, and returning the target transaction data to the client.
The invention provides a terminal comprising a memory and a processor, wherein the memory stores computer readable instructions, and the computer readable instructions, when executed by the processor, cause the processor to execute the steps of the transaction data query method of the credit card management system.
The present invention provides a storage medium having stored thereon a computer program which, when executed by a processor, implements a transaction data inquiry method of a credit card management system as set forth in any one of the above.
Compared with the prior art, the technical scheme of the invention at least has the following advantages:
the invention provides a transaction data query method of a credit card management system, which comprises the steps of acquiring transaction data generated by each client in real time through a data server, screening out first transaction data with historical query frequency larger than a preset value from the transaction data, and backing up the first transaction data with higher query frequency to a cache of a service system; the service system comprises a database and a cache; then, first transaction data with the transaction time before a preset transaction time node is screened from a cache of the service system and backed up in a database, and the first transaction data backed up in the database in the cache is periodically cleared so as to improve the data storage and query efficiency; when a client initiates a transaction data query request, responding to the transaction data query request of the client, acquiring target transaction data from the cache, the data server or the database according to preset conditions, and returning the target transaction data to the client, so that part of transaction data query is transferred to a service system, and the target transaction data is acquired through the cache or the database of the service system, so that the load of the data server is reduced, and the problem that the resource consumption of the data server is too large to influence the processing of other tasks is avoided.
Drawings
FIG. 1 is a diagram of an environment for implementing a transaction data query method of a credit card management system according to an embodiment of the present invention;
FIG. 2 is a block diagram illustrating a transaction data query method of the credit card management system according to an embodiment of the present invention;
FIG. 3 is a block diagram of a transaction data query device of the credit card management system according to an embodiment of the present invention;
fig. 4 is a block diagram of the internal structure of the terminal in one embodiment of the present invention.
The implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
In order to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention.
In some of the flows described in the present specification and claims and in the above-described figures, a number of operations are included that occur in a particular order, but it should be clearly understood that these operations may be performed out of order or in parallel as they occur herein, with the order of the operations being numbered, e.g., S11, S12, etc., merely to distinguish between various operations, and the order of the operations by themselves is not meant to imply any order of execution. Additionally, the flows may include more or fewer operations, and the operations may be performed sequentially or in parallel. It should be noted that, the descriptions of "first", "second", etc. in this document are used for distinguishing different messages, devices, modules, etc., and do not represent a sequential order, nor limit the types of "first" and "second" to be different.
As used herein, the singular forms "a", "an", "the" and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise. It will be further understood that the terms "comprises" and/or "comprising," when used in this specification, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof. It will be understood that when an element is referred to as being "connected" or "coupled" to another element, it can be directly connected or coupled to the other element or intervening elements may also be present. Further, "connected" or "coupled" as used herein may include wirelessly connected or wirelessly coupled. As used herein, the term "and/or" includes all or any element and all combinations of one or more of the associated listed items.
It will be understood by those of ordinary skill in the art that, unless otherwise defined, all terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. It will be further understood that terms, such as those defined in commonly used dictionaries, should be interpreted as having a meaning that is consistent with their meaning in the context of the prior art and will not be interpreted in an idealized or overly formal sense unless expressly so defined herein.
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, wherein the same or similar reference numerals denote the same or similar elements or elements having the same or similar functions throughout. It is to be understood that the described embodiments are merely exemplary of the invention, and not restrictive of the full scope of the invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Fig. 1 is a diagram of an implementation environment of a transaction data query method of a credit card management system provided in an embodiment, as shown in fig. 1, in which a data server 100 and a service system 200 are included. The data server 100 is connected to a service system 200 through a network for data transmission, and the service system 200 includes a cache 2001 and a database 2002 connected to the cache 2001. The network may include the internet, 2G/3G/4G, wifi, etc.
The data server 100 and the service system 200 may be independent physical servers or terminals, may be a server cluster composed of a plurality of physical servers, and may be cloud servers that provide basic cloud computing services such as a cloud server, a cloud database, a cloud storage, and a CDN.
Referring to fig. 2, the transaction data query method of the credit card management system provided by the present invention is to solve the problem that the processing of other tasks is affected due to the excessive load and the excessive resource consumption when the current data server processes the transaction data query of the credit card management system. In one embodiment, the method comprises the following steps:
s21, acquiring transaction data generated by each client in real time through a data server, screening out first transaction data with historical query frequency larger than a preset value from the transaction data, and backing up the first transaction data to a cache of a service system; the service system comprises a database and a cache;
in this embodiment, the data server is connected to each client, and acquires transaction data generated by each client in real time. The first transaction data with the historical query frequency larger than the preset value are screened out from the transaction data, then the first transaction data with the higher data query frequency are backed up to a cache of a service system, and as the running speed of the cache is much higher than that of a memory, the target transaction data can be quickly obtained during subsequent query.
S22, screening out first transaction data with transaction time before a preset transaction time node from a cache of the service system, backing up the first transaction data in the database, and periodically clearing the first transaction data backed up in the database in the cache;
in the embodiment, the first transaction data stored in the cache is screened to obtain the first transaction data with the transaction time before the preset transaction time node, the first transaction data is backed up to the database, and the first transaction data backed up to the database in the cache is periodically cleared, so that only the first transaction data generated in the near time of the client is reserved in the cache, and the cache is prevented from being full to influence the backup of the subsequent first transaction data to the cache. It should be noted that the preset transaction time node may be a transaction time node that is self-adjusted according to an actual application scenario and situation, which is not limited in this embodiment.
And S23, responding to a transaction data query request of the client, acquiring target transaction data from the cache, the data server or the database according to preset conditions, and returning the target transaction data to the client.
In this embodiment, when one or more clients initiate a transaction data query request, target transaction data is queried and obtained from a cache, a data server or a database according to preset conditions in response to the query request of each client, and the obtained target transaction data is returned to the client, so that a transaction data query task is prevented from being centralized on the data server to process, and the data server is prevented from influencing other tasks. The preset condition may set an optimal acquisition mode of the target transaction data according to the type of the transaction data query request, for example, when the transaction data query request is relatively urgent, the data server is considered to suspend processing of other tasks, and the transaction data query task is preferentially processed.
In order to better understand the technical scheme, the following description takes bank transaction data query as an example:
in an embodiment, the data server downloads the first transaction data with a higher query frequency generated by each bank client transaction to a cache of the service system (which may include multiple servers) in real time, then screens out the first transaction data with a transaction time before a preset transaction time node from the cache of the service system, for example, the first transaction data before a day, a week or a month, and backs up the first transaction data to a database of the service system. When a client initiates a transaction data query request, responding to the transaction data query request of the client, and judging whether a current service system downloads transaction data to a cache in batches or whether a data server backs up the transaction data in batches; when the data server downloads the transaction data to the cache of the service system in batch, the target transaction data is inquired from the cache or the database of the service system and is sent to the client, so that the transaction data inquiry task proportion of the data server is not more than 10%, and 90% of the transaction data inquiry tasks are borne by the service system.
The invention provides a transaction data query method of a credit card management system, which comprises the steps of acquiring transaction data generated by each client in real time through a data server, screening out first transaction data with historical query frequency larger than a preset value from the transaction data, and backing up the first transaction data with higher query frequency to a cache of a service system; the service system comprises a database and a cache; then, first transaction data with the transaction time before a preset transaction time node is screened from a cache of the service system and backed up in a database, and the first transaction data backed up in the database in the cache is periodically cleared so as to improve the data storage and query efficiency; when a client initiates a transaction data query request, responding to the transaction data query request of the client, acquiring target transaction data from the cache, the data server or the database according to preset conditions, and returning the target transaction data to the client, so that part of transaction data query is transferred to a service system, and the target transaction data is acquired through the cache or the database of the service system, so that the load of the data server is reduced, and the problem that the resource consumption of the data server is too large to influence the processing of other tasks is avoided.
In an embodiment, in step S23, the step of obtaining the target transaction data from the cache, the data server, or the database according to the preset condition may specifically include:
a1, calculating the current CPU utilization rate of the data server; the CPU utilization rate of the data server is the average CPU utilization rate of the data server in a preset period;
in this embodiment, the utilization rate of the CPU of the data server can be monitored in real time by the system monitoring tool. Glitches may occur at some point due to CPU usage, but this is not really an overload of the data server. To avoid misleading of these glitches, the system monitoring tool needs to make a decision based on an average of the CPU utilization of the data server over a period of time, so the CPU utilization of the data server refers to the average CPU utilization of the data server over a predetermined period. For example, at a certain time point Z, the average value of all sampling points from Z-1 minute to Z is calculated, and the current CPU usage of the data server is calculated based on this average value.
And A2, when the CPU utilization rate of the data server is lower than a preset value, acquiring the target transaction data from the data server.
In this embodiment, after the CPU utilization of the data server is obtained through calculation, it is determined whether the CPU utilization is lower than a preset CPU utilization, and if so, it indicates that the processing pressure of the current data server is still relatively low, and other tasks can be processed.
In an embodiment, in step a1, after the calculating the current CPU utilization of the data server, the method may further include:
a3, when the CPU utilization rate of the data server is higher than a preset value, extracting the transaction time of the target transaction data to be acquired from the transaction data query request;
and A4, acquiring target transaction data from a cache or a database according to the transaction time.
In this embodiment, when the CPU utilization of the data server is higher than the preset CPU utilization, the pressure of the data server may be large, which results in slow operation of the data server, at this time, the transaction data query task needs to be distributed to the service system for processing, the transaction time of the target transaction data to be obtained is extracted from the transaction data query request, and the target transaction data is obtained from the cache or the database of the service system according to the transaction time.
When the load of the data server is recovered to be normal, namely the CPU utilization rate is lower than a preset value, part of tasks of transaction data query can be automatically returned to the data server for processing. By the method, the requirement of rapid increase of transaction data query request in short time can be met, the resources of the data server are flexibly and effectively utilized, and the overall processing capacity of the system is improved. In the embodiment of the present invention, the preset CPU utilization may be set to 40%, but the present invention is not limited thereto.
In an embodiment, in step a4, the step of obtaining the target transaction data from the cache or the database according to the transaction time may specifically include:
a41, when the transaction time is before a preset transaction time node, acquiring the target transaction data from the database;
a42, otherwise, obtaining the target transaction data from the cache of the service system.
In this embodiment, since the front and back of the transaction time have a certain relationship with the frequency of the subsequent use of the data, the longer the transaction data generation time is, the lower the frequency of the subsequent use is, and the shorter the transaction data generation time is, the higher the frequency of the subsequent use is. Therefore, in this embodiment, data is classified according to the sequence of the transaction time, data with a previous transaction time is stored in the database, and data with a later transaction time is stored in the cache. When the transaction time of the target transaction data to be acquired is before the preset transaction time node, the data with the transaction time before the preset transaction time node is backed up in the database in advance, so the target transaction data needs to be acquired from the database. When the transaction time is behind a preset transaction time node, the target transaction data can be directly acquired from a cache of a service system, and the data acquisition efficiency is improved.
In an embodiment, in step S21, the step of backing up the first transaction data to the cache of the service system may specifically include:
b1, acquiring the data type of the first transaction data;
b2, inquiring a target service system corresponding to the data type from a pre-configured list according to the data type;
b3, backing up the first transaction data to a cache of a target service system.
Each service system can handle different services, such as a service system for handling account opening services, a service system for sales service, a service system for startup services, a service system for shutdown services, and the like. In the process of backing up the first transaction data to the cache of the service system, the data can be classified according to the data type, the first transaction data is backed up to the corresponding service system according to the classification result, and the different service systems manage the corresponding data. During query, analyzing the obtained transaction data query request, extracting the data type of the transaction data, searching a corresponding target service system from a pre-configured list according to the data type, and obtaining the target transaction data from the target service system. Wherein, the list records the service system corresponding to each transaction data type. For example, when the information of the quota needs to be inquired, the quota inquiry request is distributed to the quota management service system, the quota inquiry is performed through the quota management service system, and the inquiry result is returned to the client.
In an embodiment, in step S21, the step of backing up the first transaction data to the cache of the target service system may specifically include:
(1) monitoring the running state of the data server regularly;
(2) when the data server is monitored to be in an idle state, backing up the first transaction data to a cache of a target service system;
(3) in the process of backing up the first transaction data to the cache of the target service system, when the situation that the data server enters a busy state from an idle state is monitored, a backup breakpoint of the current first transaction data backup to the cache of the target service system is recorded;
(4) and when the data server is monitored to be in an idle state again, the first transaction data is continuously backed up to the cache of the target service system from the backup breakpoint.
In this embodiment, the data server may need to process various tasks in some time periods of a day, which results in that the data server is relatively busy, so that the time for backing up the first transaction data to the cache of the target service system is usually set to be performed in a time period in which the data server is relatively idle, so as to reduce the response time of the data server for processing other tasks, and further improve the processing speed and efficiency of the data server.
In addition, the data server of this embodiment also supports breakpoint resume, and records a backup breakpoint when it is monitored that the data server enters a busy state from an idle state in a process of backing up the first transaction data to the cache of the target service system, where the current first transaction data is backed up to the cache of the target service system; when the data server is monitored to be in an idle state again, the first transaction data is continuously backed up to the cache of the target service system from the backup breakpoint without being backed up again from the beginning, so that the pressure of the data server is prevented from being increased due to repeated backup in the data backup process.
In an embodiment, before backing up the first transaction data to the cache of the service system in the step S21, the method may further include:
establishing a transmission network taking a data server as a center;
each service system is accessed to the network node of the transmission network nearby; wherein the number of service systems accessed by each network node is less than a predetermined threshold.
In this embodiment, a transmission network between the data server and each service system is pre-established, any network node is loaded with the service systems in a balanced manner, and each service system is accessed to the network node nearby, so as to quickly respond to a transaction data query task allocated by the data server, thereby improving the data query efficiency.
Referring to fig. 3, an embodiment of the present invention further provides a transaction data query device of a credit card management system, and in one embodiment, the transaction data query device includes a backup module 31, a clearing module 32, and an obtaining module 33. Wherein,
the backup module 31 is used for acquiring transaction data generated by each client in real time through the data server, screening first transaction data with historical query frequency larger than a preset value from the transaction data, and backing up the first transaction data to a cache of the service system; the service system comprises a database and a cache;
in this embodiment, the data server is connected to each client, and acquires transaction data generated by each client in real time. The first transaction data with the historical query frequency larger than the preset value are screened out from the transaction data, then the first transaction data with the higher data query frequency are backed up to a cache of a service system, and as the running speed of the cache is much higher than that of a memory, the target transaction data can be quickly obtained during subsequent query.
The clearing module 32 is configured to screen a first transaction data backup of transaction time before a preset transaction time node from a cache of the service system, and periodically clear the first transaction data backup of the first transaction time before the preset transaction time node from the cache;
in the embodiment, the first transaction data stored in the cache is screened to obtain the first transaction data with the transaction time before the preset transaction time node, the first transaction data is backed up to the database, and the first transaction data backed up to the database in the cache is periodically cleared, so that only the first transaction data generated in the near time of the client is reserved in the cache, and the cache is prevented from being full to influence the backup of the subsequent first transaction data to the cache. It should be noted that the preset transaction time node may be a transaction time node that is self-adjusted according to an actual application scenario and situation, which is not limited in this embodiment.
The obtaining module 33 is configured to, in response to a transaction data query request of a client, obtain target transaction data from the cache, the data server, or the database according to a preset condition, and return the target transaction data to the client.
In this embodiment, when one or more clients initiate a transaction data query request, target transaction data is queried and obtained from a cache, a data server or a database according to preset conditions in response to the query request of each client, and the obtained target transaction data is returned to the client, so that a transaction data query task is prevented from being centralized on the data server to process, and the data server is prevented from influencing other tasks. The preset condition may set an optimal acquisition mode of the target transaction data according to the type of the transaction data query request, for example, when the transaction data query request is relatively urgent, the data server is considered to suspend processing of other tasks, and the transaction data query task is preferentially processed.
Taking the bank transaction data query as an example, the data server downloads the first transaction data with higher query frequency generated by each bank client transaction to the cache of the service system (which may include a plurality of servers) in real time, then screens out the first transaction data with transaction time before the preset transaction time node, such as the first transaction data before one day, one week or one month, from the cache of the service system, and backs up the first transaction data to the database of the service system. When a client initiates a transaction data query request, responding to the transaction data query request of the client, and judging whether a current service system downloads transaction data to a cache in batches or whether a data server backs up the transaction data in batches; when the data server downloads the transaction data to the cache of the service system in batch, the target transaction data is inquired from the cache or the database of the service system and is sent to the client, so that the transaction data inquiry task proportion of the data server is not more than 10%, and 90% of the transaction data inquiry tasks are borne by the service system.
The invention provides a transaction data query device of a credit card management system, which is characterized in that a data server acquires transaction data generated by each client in real time, screens out first transaction data with historical query frequency greater than a preset value from the transaction data, and backs up the first transaction data with higher query frequency to a cache of a service system; the service system comprises a database and a cache; then, first transaction data with the transaction time before a preset transaction time node is screened from a cache of the service system and backed up in a database, and the first transaction data backed up in the database in the cache is periodically cleared so as to improve the data storage and query efficiency; when a client initiates a transaction data query request, responding to the transaction data query request of the client, acquiring target transaction data from the cache, the data server or the database according to preset conditions, and returning the target transaction data to the client, so that part of transaction data query is transferred to a service system, and the target transaction data is acquired through the cache or the database of the service system, so that the load of the data server is reduced, and the problem that the resource consumption of the data server is too large to influence the processing of other tasks is avoided.
With regard to the apparatus in the above-described embodiment, the specific manner in which each module performs the operation has been described in detail in the embodiment related to the method, and will not be elaborated here.
The invention provides a terminal, which comprises a memory and a processor, wherein the memory is stored with computer readable instructions, and the computer readable instructions, when executed by the processor, cause the processor to execute the steps of the transaction data query method of the credit card management system.
In one embodiment, the terminal is a computer device, as shown in fig. 4. The computer device described in this embodiment may be a server, a personal computer, a network device, and other devices. The computer device comprises a processor 402, a memory 403, an input unit 404, and a display unit 405. Those skilled in the art will appreciate that the device configuration means shown in fig. 4 do not constitute a limitation of all devices and may include more or less components than those shown, or some components in combination. The memory 403 may be used to store the computer program 401 and the functional modules, and the processor 402 runs the computer program 401 stored in the memory 403 to execute various functional applications of the device and data processing. The memory may be internal or external memory, or include both internal and external memory. The memory may comprise read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), flash memory, or random access memory. The external memory may include a hard disk, a floppy disk, a ZIP disk, a usb-disk, a magnetic tape, etc. The disclosed memory includes, but is not limited to, these types of memory. The disclosed memory is by way of example only and not by way of limitation.
The input unit 404 is used for receiving input of signals and receiving keywords input by a user. The input unit 404 may include a touch panel and other input devices. The touch panel can collect touch operations of a user on or near the touch panel (for example, operations of the user on or near the touch panel by using any suitable object or accessory such as a finger, a stylus and the like) and drive the corresponding connecting device according to a preset program; other input devices may include, but are not limited to, one or more of a physical keyboard, function keys (e.g., play control keys, switch keys, etc.), a trackball, a mouse, a joystick, and the like. The display unit 405 may be used to display information input by a user or information provided to a user and various menus of the computer device. The display unit 405 may take the form of a liquid crystal display, an organic light emitting diode, or the like. The processor 402 is a control center of the computer device, connects various parts of the entire computer using various interfaces and lines, and performs various functions and processes data by operating or executing software programs and/or modules stored in the memory 402 and calling data stored in the memory.
As one embodiment, the computer device includes: one or more processors 402, a memory 403, one or more computer programs 401, wherein the one or more computer programs 401 are stored in the memory 403 and configured to be executed by the one or more processors 402, the one or more computer programs 401 being configured to perform the transaction data query method of the credit card management system described in the above embodiment.
In one embodiment, the present invention also provides a storage medium storing computer-readable instructions, which when executed by one or more processors, cause the one or more processors to execute the transaction data query method of the credit card management system. For example, the storage medium may be a ROM, a Random Access Memory (RAM), a CD-ROM, a magnetic tape, a floppy disk, an optical data storage device, and the like.
It will be understood by those skilled in the art that all or part of the processes of the methods of the above embodiments may be implemented by a computer program, which may be stored in a storage medium and executed by a computer, and the processes of the embodiments of the methods may be included. The storage medium may be a non-volatile storage medium such as a magnetic disk, an optical disk, a Read-Only Memory (ROM), or a Random Access Memory (RAM).
The embodiment is combined to show that the invention has the following maximum beneficial effects:
the invention provides a transaction data query method, a device, a terminal and a storage medium of a credit card management system, which are characterized in that a data server acquires transaction data generated by each client in real time, first transaction data with historical query frequency larger than a preset value are screened out from the transaction data, and the first transaction data with higher query frequency are backed up to a cache of a service system; the service system comprises a database and a cache; then, first transaction data with the transaction time before a preset transaction time node is screened from a cache of the service system and backed up in a database, and the first transaction data backed up in the database in the cache is periodically cleared so as to improve the data storage and query efficiency; when a client initiates a transaction data query request, responding to the transaction data query request of the client, acquiring target transaction data from the cache, the data server or the database according to preset conditions, and returning the target transaction data to the client, so that part of transaction data query is transferred to a service system, and the target transaction data is acquired through the cache or the database of the service system, so that the load of the data server is reduced, and the problem that the resource consumption of the data server is too large to influence the processing of other tasks is avoided.
The technical features of the embodiments described above may be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the embodiments described above are not described, but should be considered as being within the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present invention, and the description thereof is more specific and detailed, but not construed as limiting the scope of the present invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the inventive concept, which falls within the scope of the present invention. Therefore, the protection scope of the present patent shall be subject to the appended claims.