CN110321364A - Transaction data querying method, device and the terminal of credit card management system - Google Patents
Transaction data querying method, device and the terminal of credit card management system Download PDFInfo
- Publication number
- CN110321364A CN110321364A CN201910441417.4A CN201910441417A CN110321364A CN 110321364 A CN110321364 A CN 110321364A CN 201910441417 A CN201910441417 A CN 201910441417A CN 110321364 A CN110321364 A CN 110321364A
- Authority
- CN
- China
- Prior art keywords
- transaction data
- data
- caching
- service system
- database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1448—Management of the data involved in backup or backup restore
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24552—Database cache management
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to transaction data inquiring technology fields, provide transaction data querying method, device and the terminal of a kind of credit card management system.The transaction data querying method includes: the transaction data for obtaining each client in real time by data server and generating, the first transaction data that historical query frequency is greater than preset value is filtered out from transaction data, and the first transaction data is backed up to the caching of service system;It is backed up in database from first transaction data of the exchange hour before default exchange hour node is filtered out in the caching of service system;In response to the transaction data inquiry request of client, target transaction data are obtained from caching, data server or database according to preset condition, and target transaction data are returned into client.The present invention, which is realized, is transferred to service system processing for the part work of transaction data inquiry, to reduce the load of data server, avoids data server resource consumption excessive and influences the processing of other tasks.
Description
Technical field
The present invention relates to transaction data inquiring technology field more particularly to a kind of number of deals of credit card management system it is investigated that
Ask method, apparatus, terminal and storage medium.
Background technique
Currently, most large scale business field (such as bank and telecommunications) in the world, all uses mainframe Parallel coupled
System runs its core business system.During using mainframe, the transaction data of credit card management system is generally involved
Inquiry.In order to improve data storage and search efficiency, many companies save transaction data using database, for example, some transaction
Database is arranged in platform, for recording each transaction of trade company in real time.But as the data of storage increase severely, many data inventories
The data volume of storage is very huge.
Therefore, data are needed to take when handling transaction data inquiry request in the data server built based on mainframe
Business device consumes a large amount of resource and finds target data from huge data.In addition, when having a large number of users while inquiring data,
Data server needs to handle the transaction data inquiry request of each user, also results in data server load too high, resource
It consumes excessive, influences the processing of other tasks.
Summary of the invention
The present invention provides transaction data querying method, device, terminal and the storage medium of a kind of credit card management system, with
Current data service device is solved when handling transaction data inquiry, existing load too high, resource consumption are excessive, influence other
The problem of processing of business.
To solve the above problems, the present invention adopts the following technical scheme:
The present invention provides a kind of transaction data querying method of credit card management system, includes the following steps:
It obtains the transaction data that each client generates in real time by data server, filters out history from transaction data and look into
The first transaction data that frequency is greater than preset value is ask, and first transaction data is backed up to the caching of service system;Wherein,
The service system includes database and caching;
From filtering out first number of deals of the exchange hour before default exchange hour node in the caching of the service system
According to backing up in database, and periodically remove the first transaction data that database has been backed up in caching;
In response to the transaction data inquiry request of client, according to preset condition from the caching, data server or number
According to acquisition target transaction data in library, and the target transaction data are returned into the client.
In one embodiment, described that target is obtained from the caching, data server or database according to preset condition
The step of transaction data, comprising:
Calculate the current CPU usage of data server;Wherein, the CPU usage of the data server is data clothes
Average CPU usage of the business device in predetermined period;
When the CPU usage of data server is lower than preset value, the target is obtained from the data server and is handed over
Easy data.
In one embodiment, after the current CPU usage for calculating data server, further includes:
When the CPU usage of data server is higher than preset value, mesh to be obtained is extracted from transaction data inquiry request
Mark the exchange hour of transaction data;
Target transaction data are obtained from caching or database according to the exchange hour.
In one embodiment, the step for obtaining target transaction data from caching or database according to the exchange hour
Suddenly, comprising:
When the exchange hour is before default exchange hour node, the target transaction number is obtained from the database
According to;
Otherwise the target transaction data are obtained from the caching of service system.
In one embodiment, the step of caching that the first transaction data is backed up to service system, comprising:
Obtain the data type of the first transaction data;
The corresponding destination service system of the data type is inquired from preconfigured list according to the data type;
First transaction data is backed up in the caching of destination service system.
In one embodiment, the step in the caching that the first transaction data is backed up to destination service system, comprising:
The operating status of periodic monitoring data server;
When monitoring that data server is in idle condition, first transaction data is backed up into destination service system
Caching in;
During the first transaction data backs up to the caching of destination service system, when monitoring data server by sky
When not busy state enters busy state, the backup breakpoint that current first transaction data backs up to the caching of destination service system is recorded;
When monitoring that data server is in idle condition again, continue from the backup breakpoint by the first number of deals
According to backing up in the caching of destination service system.
It is in one embodiment, described to back up to first transaction data before the caching of service system, further includes:
Establish the transmission network centered on data server;
Each service system is accessed to the network node of the transmission network nearby;Wherein, the clothes of each network node access
The quantity of business system is less than predetermined threshold.
A kind of transaction data inquiry unit of credit card management system provided by the invention, comprising:
Backup module, for obtaining the transaction data that each client generates in real time by data server, from transaction data
In filter out historical query frequency be greater than preset value the first transaction data, and by first transaction data back up to service system
The caching of system;Wherein, the service system includes database and caching;
Module is removed, for from filtering out exchange hour in the caching of the service system before default exchange hour node
The first transaction data back up in database, and periodically remove and backed up to the first transaction data of database in caching;
Module is obtained, for the transaction data inquiry request in response to client, according to preset condition from the caching, number
According to acquisition target transaction data in server or database, and the target transaction data are returned into the client.
The present invention provides a kind of terminal, including memory and processor, is stored with computer-readable finger in the memory
It enables, when the computer-readable instruction is executed by the processor, so that the processor executes as above described in any item letters
The step of with the transaction data querying method of card management system.
The present invention provides a kind of storage medium, is stored thereon with computer program, and the computer program is held by processor
When row, the transaction data querying method of as above described in any item credit card management systems is realized.
Compared with the existing technology, technical solution of the present invention at least has following advantage:
The transaction data querying method of credit card management system provided by the invention is obtained each in real time by data server
The transaction data that client generates filters out the first transaction data that historical query frequency is greater than preset value from transaction data,
And higher first transaction data of enquiry frequency is backed up in the caching of service system;Wherein, the service system packet
Include database and caching;Then from filtering out exchange hour in the caching of the service system before default exchange hour node
First transaction data backs up in database, and periodically removes the first transaction data that database has been backed up in caching, to mention
The storage of high data and search efficiency;When client initiates transaction data inquiry request, in response to the transaction data of client
Inquiry request obtains target transaction data according to preset condition from the caching, data server or database, and will be described
Target transaction data return to the client, so that the part work of transaction data inquiry is transferred in service system, lead to
The caching or database for crossing service system obtain target transaction data and avoid data service to reduce the load of data server
Device resource consumption is excessive, influences the processing of other tasks.
Detailed description of the invention
Fig. 1 is the implementation ring of the transaction data querying method of the credit card management system provided in one embodiment of the invention
Border figure;
Fig. 2 is a kind of embodiment flow diagram of transaction data querying method of credit card management system of the present invention;
Fig. 3 is a kind of embodiment module frame chart of transaction data inquiry unit of credit card management system of the present invention;
Fig. 4 is the internal structure block diagram of terminal in one embodiment of the invention.
The embodiments will be further described with reference to the accompanying drawings for the realization, the function and the advantages of the object of the present invention.
Specific embodiment
In order to enable those skilled in the art to better understand the solution of the present invention, below in conjunction in the embodiment of the present invention
Attached drawing, technical scheme in the embodiment of the invention is clearly and completely described.
In some processes of the description in description and claims of this specification and above-mentioned attached drawing, contain according to
Multiple operations that particular order occurs, but it should be clearly understood that these operations can not be what appears in this article suitable according to its
Sequence is executed or is executed parallel, and the serial number of operation such as S11, S12 etc. be only used for distinguishing each different operation, serial number
It itself does not represent and any executes sequence.In addition, these processes may include more or fewer operations, and these operations can
To execute or execute parallel in order.It should be noted that the description such as " first " herein, " second ", is for distinguishing not
Same message, equipment, module etc., does not represent sequencing, does not also limit " first " and " second " and be different type.
It will appreciated by the skilled person that unless expressly stated, singular " one " used herein, " one
It is a ", " described " and "the" may also comprise plural form.It is to be further understood that being arranged used in specification of the invention
Diction " comprising " refer to that there are the feature, integer, step, operation, element and/or component, but it is not excluded that in the presence of or addition
Other one or more features, integer, step, operation, element, component and/or their group.It should be understood that when we claim member
Part is " connected " or when " coupled " to another element, it can be directly connected or coupled to other elements, or there may also be
Intermediary element.In addition, " connection " used herein or " coupling " may include being wirelessly connected or wirelessly coupling.It is used herein to arrange
Diction "and/or" includes one or more associated wholes for listing item or any cell and all combinations.
It will appreciated by the skilled person that unless otherwise defined, all terms used herein (including technology art
Language and scientific term), there is meaning identical with the general understanding of those of ordinary skill in fields of the present invention.Should also
Understand, those terms such as defined in the general dictionary, it should be understood that have in the context of the prior art
The consistent meaning of meaning, and unless idealization or meaning too formal otherwise will not be used by specific definitions as here
To explain.
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description in which the same or similar labels are throughly indicated same or similar element or has same or like function
Element.Obviously, described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.Based on this
Embodiment in invention, those skilled in the art's every other implementation obtained without creative efforts
Example, shall fall within the protection scope of the present invention.
Fig. 1 is the implementation environment figure of the transaction data querying method of the credit card management system provided in one embodiment,
As shown in Figure 1, in the implementation environment, including data server 100 and service system 200.Data server 100 passes through network
Connect with service system 200, to carry out the transmission of data, the service system 200 include caching 2001 and with the caching
The database 2002 of 2001 connections.Wherein, above-mentioned network may include internet, 2G/3G/4G, wifi etc..
It should be noted that data server 100 and service system 200 can be independent physical server or terminal,
Be also possible to the server cluster that multiple physical servers are constituted, can be to provide Cloud Server, cloud database, cloud storage and
The Cloud Server of the basis such as CDN cloud computing service.
Referring to Fig. 2, a kind of transaction data querying method of credit card management system provided by the present invention, to solve to work as
For preceding data server in the transaction data inquiry for handling credit card management system, existing load too high, resource consumption are excessive,
The problem of influencing the processing of other tasks.In one of embodiment, include the following steps:
S21, it obtains the transaction data that each client generates in real time by data server, filters out and go through from transaction data
History enquiry frequency is greater than the first transaction data of preset value, and first transaction data is backed up to the caching of service system;
Wherein, the service system includes database and caching;
In the present embodiment, data server is attached with each client, and obtains what each client generated in real time
Transaction data.The first transaction data that historical query frequency is greater than preset value is filtered out from transaction data, then looks into data
It askes higher first transaction data of frequency to back up in the caching of service system, be obtained since the speed of service of caching is faster than memory
It is more, therefore when subsequent query, it can quick obtaining target transaction data.
S22, from filtering out exchange hour first handing over before default exchange hour node in the caching of the service system
Easy data backup periodically removes the first transaction data that database has been backed up in caching into database;
The present embodiment screens the first transaction data of storage in the buffer, obtains exchange hour in default transaction
The first transaction data before intermediate node, is backed up in database, and is periodically removed and backed up to the of database in caching
One transaction data avoids caching from being occupied full to make the first transaction data for only retaining the generation of client proximal segment time in caching
And it influences subsequent first transaction data and backs up to caching.It should be noted that the default exchange hour node can be basis
The exchange hour node that practical application scene and situation voluntarily adjust, the present embodiment are without restriction to this.
S23, the transaction data inquiry request in response to client, according to preset condition from the caching, data server
Or target transaction data are obtained in database, and the target transaction data are returned into the client.
In the present embodiment, when one or more clients initiate transaction data inquiry request, in response to each client
Inquiry request, target transaction data are inquired and obtained from caching, data server or database according to preset condition, will be obtained
The target transaction data got return to client, to avoid concentrating on transaction data query task at data server
Reason, influences data server and handles other tasks.Wherein, the preset condition can be arranged according to transaction data inquiry request type
The best acquisition modes of target transaction data, for example, then considering data server when transaction data inquiry request is more urgent
Suspend the processing of other tasks, priority processing this transaction data query task.
The technical program in order to better understand is specifically described using bank transaction data query as embodiment below:
In one embodiment, the enquiry frequency higher first that data server can generate the transaction of each bank client
It is transmitted to the caching of service system (may include multiple servers) under transaction data is real-time, is then screened from the caching of service system
First transaction data of the exchange hour before default exchange hour node out, such as one day, one week or the first friendship before one month
Easy data, and first transaction data is backed up in the database of the service system.When client initiates transaction data inquiry
When request, in response to the transaction data inquiry request of client, judge whether current serving system under batch passes transaction data
Into caching or whether data server is in batch backup transaction data;When data server passes transaction data to clothes under batch
When the caching of business system, then target transaction data are inquired from the caching of service system or database, by the target transaction data
It is sent to client, to realize that the transaction data query task ratio of data server is no more than 10%, is held by service system
The transaction data query task of load 90%.
The transaction data querying method of credit card management system provided by the invention is obtained each in real time by data server
The transaction data that client generates filters out the first transaction data that historical query frequency is greater than preset value from transaction data,
And higher first transaction data of enquiry frequency is backed up in the caching of service system;Wherein, the service system packet
Include database and caching;Then from filtering out exchange hour in the caching of the service system before default exchange hour node
First transaction data backs up in database, and periodically removes the first transaction data that database has been backed up in caching, to mention
The storage of high data and search efficiency;When client initiates transaction data inquiry request, in response to the transaction data of client
Inquiry request obtains target transaction data according to preset condition from the caching, data server or database, and will be described
Target transaction data return to the client, so that the part work of transaction data inquiry is transferred in service system, lead to
The caching or database for crossing service system obtain target transaction data and avoid data service to reduce the load of data server
Device resource consumption is excessive, influences the processing of other tasks.
In one embodiment, in step S23, it is described according to preset condition from the caching, data server or data
The step of target transaction data are obtained in library, may particularly include:
A1, the current CPU usage for calculating data server;Wherein, the CPU usage of the data server is data
Average CPU usage of the server in predetermined period;
In the present embodiment, it can be monitored in real time by utilization rate of the system monitoring tool to data server CPU.By
Burr pulse may occur at certain time points in CPU usage, but this is not really the load excessive of data server.
In order to avoid the misleading of these burr pulses, the judgement of system monitoring tool is needed based on data server in a period of time
The average value of CPU usage, so the CPU usage of data server refers to data server being averaged in predetermined period
CPU usage.Such as Z at some time point, the Z-1 minutes average value to all sampled points between Z is calculated, according to this
The current CPU usage of mean value calculation data server.
A2, when the CPU usage of data server be lower than preset value when, the target is obtained from the data server
Transaction data.
In the present embodiment, after the CPU usage of data server is calculated, judge whether the CPU usage is lower than
Preset CPU usage can also handle other tasks if so, illustrating that the processing pressure of current data service device is also smaller,
Therefore, the target transaction data can be inquired and obtain, from data server to improve the acquisition efficiency of transaction data.
In one embodiment, it in step A1, after the current CPU usage for calculating data server, can also wrap
It includes:
A3, when the CPU usage of data server be higher than preset value when, extracted from transaction data inquiry request to be obtained
The exchange hour of target transaction data;
A4, target transaction data are obtained from caching or database according to the exchange hour.
In the present embodiment, when the CPU usage of data server is higher than preset CPU usage, data server
Pressure can be very big, cause the operation of data server slow, need to branch to transaction data query task service system at this time
System processing, extracts the exchange hour of target transaction data to be obtained, according to the exchange hour from transaction data inquiry request
Target transaction data are obtained from the caching or database of service system.
After the load restoration of data server is normal, i.e., when CPU usage is lower than preset value, and can be automatically by number of deals
It is investigated that the partial task ask return back to data server processing.In this way, it is short to can satisfy transaction data inquiry request
When the needs that increase rapidly, and the resource of data server is flexibly and effectively utilized, improves the entirety ability of system.
In embodiments of the present invention, preset CPU usage can be set as 40%, and the invention is not limited thereto.
In one embodiment, described that target is obtained from caching or database according to the exchange hour in step A4
The step of transaction data, may particularly include:
A41, when the exchange hour is before default exchange hour node, obtain the target from the database and hand over
Easy data;
A42, the target transaction data are otherwise obtained from the caching of service system.
In the present embodiment, it since the frequency that the front and back of exchange hour and data are subsequently to be used has certain relationship, such as hands over
Easy data generation time is more long, then the frequency being subsequently to be used can be lower, and the transaction data generation time is shorter, then subsequent to be made
Frequency can be higher.Therefore, the present embodiment classifies to data according to the successive of exchange hour, and exchange hour is preceding
Data are saved into database, and the posterior data of exchange hour are saved in the buffer.When the friendship of target transaction data to be obtained
When the easy time is before default exchange hour node, due to the data backup in advance by exchange hour before default exchange hour node
Into database, therefore, it is necessary to the target transaction data are obtained from database.When the exchange hour is in default transaction
When after intermediate node, then the target transaction data can be directly obtained from the caching of service system, improve data acquisition efficiency.
In one embodiment, in the step s 21, the step of the caching that the first transaction data is backed up to service system
Suddenly, it may particularly include:
B1, the data type for obtaining the first transaction data;
B2, the corresponding destination service system of the data type is inquired from preconfigured list according to the data type
System;
B3, first transaction data is backed up in the caching of destination service system.
Each service system can handle different business, such as handle the service system for the business of opening an account, cancellation industry
The service system of business, service system, the service system of shutdown service of the business that is switched on etc..The present embodiment is by the first transaction data
During the caching for backing up to service system, it can be classified according to data type to data, according to classification results by first
Transaction data backs up to corresponding service system, manages corresponding data by different service systems.In inquiry, analysis is obtained
The transaction data inquiry request arrived, extracts the data type of transaction data, is looked into from preconfigured list according to data type
Corresponding destination service system is looked for, target transaction data are obtained from destination service system.Wherein, each friendship is had recorded in list
The corresponding service system of easy data type.For example, then amount inquiry request is distributed to amount when needing to inquire amount information
Management service system carries out amount inquiry by quota control service system, and query result is returned to client.
In one embodiment, in the step s 21, in the caching that the first transaction data is backed up to destination service system
The step of, it may particularly include:
(1) operating status of periodic monitoring data server;
(2) when monitoring that data server is in idle condition, first transaction data is backed up into destination service
In the caching of system;
(3) during the first transaction data backs up to the caching of destination service system, when monitoring data server
When entering busy state by idle state, the backup for recording the caching that current first transaction data backs up to destination service system is disconnected
Point;
(4) when monitoring that data server is in idle condition again, continue to hand over first from the backup breakpoint
Easy data backup is into the caching of destination service system.
In the present embodiment, the data server may be needed to handle various tasks within one day certain period and be led
It causes the data server relatively busy, therefore the first transaction data is backed up to the time of the caching of destination service system
It is generally arranged at the more idle period progress of data server, to reduce the sound that the data server handles other tasks
Between seasonable, and then improve data server processing speed and efficiency.
In addition, the data server of the present embodiment also supports breakpoint transmission, destination service is backed up in the first transaction data
During the caching of system, when monitoring that data server enters busy state by idle state, records current first and hand over
The backup breakpoint of caching of the easy data backup to destination service system;When monitoring that data server is in idle condition again
When, continue in the caching that the first transaction data is backed up to destination service system from the backup breakpoint, is not necessarily to again from the beginning
Backup, avoids the pressure for needing to back up and increase repeatedly data server in data backup procedure.
In one embodiment, described that first transaction data is backed up into the slow of service system in the step S21
Before depositing, it may also include that
Establish the transmission network centered on data server;
Each service system is accessed to the network node of the transmission network nearby;Wherein, the clothes of each network node access
The quantity of business system is less than predetermined threshold.
The present embodiment pre-establishes the transmission network of data server Yu each service system, and any network node is balanced
Ground load services system, and each service system accesses the network node nearby, so as to the distribution of quick response data server
Transaction data query task, to improve the search efficiency of data.
Referring to FIG. 3, the embodiment of the present invention also provides a kind of transaction data inquiry unit of credit card management system, one
In kind the present embodiment, including backup module 31, removing module 32 and acquisition module 33.Wherein,
Backup module 31, for obtaining the transaction data that each client generates in real time by data server, from number of deals
The first transaction data that historical query frequency is greater than preset value is filtered out in, and first transaction data is backed up into service
The caching of system;Wherein, the service system includes database and caching;
In the present embodiment, data server is attached with each client, and obtains what each client generated in real time
Transaction data.The first transaction data that historical query frequency is greater than preset value is filtered out from transaction data, then looks into data
It askes higher first transaction data of frequency to back up in the caching of service system, be obtained since the speed of service of caching is faster than memory
It is more, therefore when subsequent query, it can quick obtaining target transaction data.
Module 32 is removed, for filtering out exchange hour from the caching of the service system in default exchange hour node
The first preceding transaction data backs up in database, and periodically removes the first transaction data that database has been backed up in caching;
The present embodiment screens the first transaction data of storage in the buffer, obtains exchange hour in default transaction
The first transaction data before intermediate node, is backed up in database, and is periodically removed and backed up to the of database in caching
One transaction data avoids caching from being occupied full to make the first transaction data for only retaining the generation of client proximal segment time in caching
And it influences subsequent first transaction data and backs up to caching.It should be noted that the default exchange hour node can be basis
The exchange hour node that practical application scene and situation voluntarily adjust, the present embodiment are without restriction to this.
Obtain module 33, for the transaction data inquiry request in response to client, according to preset condition from the caching,
Target transaction data are obtained in data server or database, and the target transaction data are returned into the client.
In the present embodiment, when one or more clients initiate transaction data inquiry request, in response to each client
Inquiry request, target transaction data are inquired and obtained from caching, data server or database according to preset condition, will be obtained
The target transaction data got return to client, to avoid concentrating on transaction data query task at data server
Reason, influences data server and handles other tasks.Wherein, the preset condition can be arranged according to transaction data inquiry request type
The best acquisition modes of target transaction data, for example, then considering data server when transaction data inquiry request is more urgent
Suspend the processing of other tasks, priority processing this transaction data query task.
By taking bank transaction data query as an example, data server can be by the enquiry frequency of each bank client transaction generation
The caching of service system (may include multiple servers) is transmitted under higher first transaction data is real-time, then from service system
Filter out first transaction data of the exchange hour before default exchange hour node in caching, such as one day, one week or one month it
The first preceding transaction data, and first transaction data is backed up in the database of the service system.When client is initiated to hand over
When easy data inquiry request, in response to the transaction data inquiry request of client, judge current serving system whether under batch
Transaction data is passed into caching or whether data server is in batch backup transaction data;When data server passes friendship under batch
Easy data to service system caching when, then target transaction data are inquired from the caching of service system or database, by the mesh
Mark transaction data is sent to client, thus realize that the transaction data query task ratio of data server is no more than 10%, by
Service system undertakes 90% transaction data query task.
The transaction data inquiry unit of credit card management system provided by the invention is obtained each in real time by data server
The transaction data that client generates filters out the first transaction data that historical query frequency is greater than preset value from transaction data,
And higher first transaction data of enquiry frequency is backed up in the caching of service system;Wherein, the service system packet
Include database and caching;Then from filtering out exchange hour in the caching of the service system before default exchange hour node
First transaction data backs up in database, and periodically removes the first transaction data that database has been backed up in caching, to mention
The storage of high data and search efficiency;When client initiates transaction data inquiry request, in response to the transaction data of client
Inquiry request obtains target transaction data according to preset condition from the caching, data server or database, and will be described
Target transaction data return to the client, so that the part work of transaction data inquiry is transferred in service system, lead to
The caching or database for crossing service system obtain target transaction data and avoid data service to reduce the load of data server
Device resource consumption is excessive, influences the processing of other tasks.
About the device in above-described embodiment, wherein modules execute the concrete mode of operation in related this method
Embodiment in be described in detail, no detailed explanation will be given here.
A kind of terminal provided by the invention, including memory and processor are stored in the memory computer-readable
Instruction, when the computer-readable instruction is executed by the processor, so that processor execution is as above described in any item
The step of transaction data querying method of credit card management system.
In one embodiment, the terminal is a kind of computer equipment, as shown in Figure 4.Computer described in the present embodiment
Equipment can be the equipment such as server, personal computer and the network equipment.The computer equipment includes processor 402, deposits
The devices such as reservoir 403, input unit 404 and display unit 405.It will be understood by those skilled in the art that the equipment shown in Fig. 4
Structure devices do not constitute the restriction to all devices, may include components more more or fewer than diagram, or combine certain
Component.Memory 403 can be used for storing computer program 401 and each functional module, and the operation of processor 402 is stored in memory
403 computer program 401, thereby executing the various function application and data processing of equipment.Memory can be interior storage
Device or external memory, or including both built-in storage and external memory.Built-in storage may include read-only memory (ROM),
Programming ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM), flash memory or
Random access memory.External memory may include hard disk, floppy disk, ZIP disk, USB flash disk, tape etc..Memory packet disclosed in this invention
Include but be not limited to the memory of these types.Memory disclosed in this invention is only used as example rather than as restriction.
Input unit 404 is used to receive the input of signal, and receives the keyword of user's input.Input unit 404 can
Including touch panel and other input equipments.Touch panel collects the touch operation of user on it or nearby and (for example uses
Family uses the operations of any suitable object or attachment on touch panel or near touch panel such as finger, stylus), and root
According to the corresponding attachment device of preset driven by program;Other input equipments can include but is not limited to physical keyboard, function
One of key (such as broadcasting control button, switch key etc.), trace ball, mouse, operating stick etc. are a variety of.Display unit
405 can be used for showing the information of user's input or be supplied to the information of user and the various menus of computer equipment.Display is single
The forms such as liquid crystal display, Organic Light Emitting Diode can be used in member 405.Processor 402 is the control centre of computer equipment, benefit
With the various pieces of various interfaces and the entire computer of connection, by running or executing the software being stored in memory 402
Program and/or module, and the data being stored in memory are called, perform various functions and handle data.
As one embodiment, the computer equipment includes: one or more processors 402, memory 403, and one
Or multiple computer programs 401, wherein one or more of computer programs 401 are stored in memory 403 and are matched
It is set to and is executed by one or more of processors 402, one or more of computer programs 401 are configured to carry out above
The transaction data querying method of credit card management system described in embodiment.
In one embodiment, the invention also provides a kind of storage medium for being stored with computer-readable instruction, the meters
When calculation machine readable instruction is executed by one or more processors, so that one or more processors execute above-mentioned credit card management system
The transaction data querying method of system.For example, the storage medium can be ROM, random access memory (RAM), CD-ROM, magnetic
Band, floppy disk and optical data storage devices etc..
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, which can be stored in a storage medium, the program
When being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein, storage medium above-mentioned can for magnetic disk, CD, only
Read non-volatile memory mediums or random access memory (Random such as storage memory (Read-Only Memory, ROM)
Access Memory, RAM) etc..
Based on the above embodiments it is found that the maximum beneficial effect of the present invention is:
Transaction data querying method, device, terminal and the storage medium of credit card management system provided by the invention, pass through
Data server obtains the transaction data that each client generates in real time, and historical query frequency is filtered out from transaction data and is greater than in advance
If the first transaction data of value, and higher first transaction data of enquiry frequency is backed up in the caching of service system;
Wherein, the service system includes database and caching;Then exchange hour is filtered out from the caching of the service system to exist
The first transaction data before default exchange hour node backs up in database, and periodically removes in caching and backed up to database
The first transaction data, to improve storage and the search efficiency of data;When client initiates transaction data inquiry request, response
In the transaction data inquiry request of client, mesh is obtained from the caching, data server or database according to preset condition
Transaction data is marked, and the target transaction data are returned into the client, so that the part of transaction data inquiry be worked
It is transferred in service system, target transaction data is obtained by the caching or database of service system, to reduce data server
Load, avoid data server resource consumption excessive, influence the processing of other tasks.
Each technical characteristic of embodiment described above can be combined arbitrarily, for simplicity of description, not to above-mentioned reality
It applies all possible combination of each technical characteristic in example to be all described, as long as however, the combination of these technical characteristics is not deposited
In contradiction, all should be considered as described in this specification.
The embodiments described above only express several embodiments of the present invention, and the description thereof is more specific and detailed, but simultaneously
Limitations on the scope of the patent of the present invention therefore cannot be interpreted as.It should be pointed out that for those of ordinary skill in the art
For, without departing from the inventive concept of the premise, various modifications and improvements can be made, these belong to guarantor of the invention
Protect range.Therefore, the scope of protection of the patent of the invention shall be subject to the appended claims.
Claims (10)
1. a kind of transaction data querying method of credit card management system characterized by comprising
It obtains the transaction data that each client generates in real time by data server, historical query frequency is filtered out from transaction data
Rate is greater than the first transaction data of preset value, and first transaction data is backed up to the caching of service system;Wherein, described
Service system includes database and caching;
From filtering out in the caching of the service system, first transaction data of the exchange hour before default exchange hour node is standby
Part periodically removes the first transaction data that database has been backed up in caching into database;
In response to the transaction data inquiry request of client, according to preset condition from the caching, data server or database
Middle acquisition target transaction data, and the target transaction data are returned into the client.
2. transaction data querying method according to claim 1, which is characterized in that described to be delayed according to preset condition from described
It deposits, obtain the step of target transaction data in data server or database, comprising:
Calculate the current CPU usage of data server;Wherein, the CPU usage of the data server is data server
Average CPU usage in predetermined period;
When the CPU usage of data server is lower than preset value, the target transaction number is obtained from the data server
According to.
3. transaction data querying method according to claim 2, which is characterized in that described to calculate the current of data server
After CPU usage, further includes:
When the CPU usage of data server is higher than preset value, target to be obtained is extracted from transaction data inquiry request and is handed over
The exchange hour of easy data;
Target transaction data are obtained from caching or database according to the exchange hour.
4. transaction data querying method according to claim 3, which is characterized in that described to be postponed according to the exchange hour
Deposit or database in obtain target transaction data the step of, comprising:
When the exchange hour is before default exchange hour node, the target transaction data are obtained from the database;
Otherwise the target transaction data are obtained from the caching of service system.
5. transaction data querying method according to claim 1, which is characterized in that described that first transaction data is standby
Part to service system caching the step of, comprising:
Obtain the data type of the first transaction data;
The corresponding destination service system of the data type is inquired from preconfigured list according to the data type;
First transaction data is backed up in the caching of destination service system.
6. transaction data querying method according to claim 5, which is characterized in that described that first transaction data is standby
Step of the part into the caching of destination service system, comprising:
The operating status of periodic monitoring data server;
When monitoring that data server is in idle condition, first transaction data is backed up into the slow of destination service system
In depositing;
During the first transaction data backs up to the caching of destination service system, when monitoring data server by idle shape
When state enters busy state, the backup breakpoint that current first transaction data backs up to the caching of destination service system is recorded;
When monitoring that data server is in idle condition again, continue from the backup breakpoint the first transaction data is standby
Part is into the caching of destination service system.
7. transaction data querying method according to claim 1, which is characterized in that described that first transaction data is standby
Before part to the caching of service system, further includes:
Establish the transmission network centered on data server;
Each service system is accessed to the network node of the transmission network nearby;Wherein, the service system of each network node access
The quantity of system is less than predetermined threshold.
8. a kind of transaction data inquiry unit of credit card management system characterized by comprising
Backup module is sieved from transaction data for obtaining the transaction data that each client generates in real time by data server
The first transaction data that historical query frequency is greater than preset value is selected, and first transaction data is backed up into service system
Caching;Wherein, the service system includes database and caching;
Module is removed, for from filtering out the of exchange hour before default exchange hour node in the caching of the service system
One transaction data backs up in database, and periodically removes the first transaction data that database has been backed up in caching;
Module is obtained, for the transaction data inquiry request in response to client, is taken according to preset condition from the caching, data
It is engaged in obtaining target transaction data in device or database, and the target transaction data is returned into the client.
9. a kind of terminal, which is characterized in that including memory and processor, computer-readable finger is stored in the memory
It enables, when the computer-readable instruction is executed by the processor, so that the processor is executed as appointed in claim 1 to 7
The step of transaction data querying method of credit card management system described in one.
10. a kind of storage medium, is stored thereon with computer program, which is characterized in that the computer program is held by processor
When row, the transaction data querying method of the credit card management system as described in any one of claims 1 to 7 is realized.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910441417.4A CN110321364B (en) | 2019-05-24 | 2019-05-24 | Transaction data query method, device and terminal of credit card management system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910441417.4A CN110321364B (en) | 2019-05-24 | 2019-05-24 | Transaction data query method, device and terminal of credit card management system |
Publications (2)
Publication Number | Publication Date |
---|---|
CN110321364A true CN110321364A (en) | 2019-10-11 |
CN110321364B CN110321364B (en) | 2023-07-25 |
Family
ID=68119087
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910441417.4A Active CN110321364B (en) | 2019-05-24 | 2019-05-24 | Transaction data query method, device and terminal of credit card management system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110321364B (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111104454A (en) * | 2019-12-19 | 2020-05-05 | 国网湖南省电力有限公司 | Multi-dimensional data processing method, system and medium for monitoring requirements of power grid on cloud |
CN113222735A (en) * | 2021-05-21 | 2021-08-06 | 中国农业银行股份有限公司 | Method for inquiring transaction associated information and related device |
WO2023241405A1 (en) * | 2022-06-16 | 2023-12-21 | International Business Machines Corporation | Database query processing with database clients |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20030200282A1 (en) * | 2002-04-18 | 2003-10-23 | International Business Machines Corporation | Optimization of database network traffic based upon data-use analysis |
US20180095835A1 (en) * | 2016-10-05 | 2018-04-05 | International Business Machines Corporation | Resilient analytics utilizing dark data |
CN109145020A (en) * | 2018-07-23 | 2019-01-04 | 程之琴 | Information query method, from server, client and computer readable storage medium |
CN109241067A (en) * | 2018-08-21 | 2019-01-18 | 中国平安人寿保险股份有限公司 | transaction data management method and device |
CN109739885A (en) * | 2018-12-12 | 2019-05-10 | 平安科技(深圳)有限公司 | Data query method, apparatus, equipment and storage medium based on local cache |
-
2019
- 2019-05-24 CN CN201910441417.4A patent/CN110321364B/en active Active
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20030200282A1 (en) * | 2002-04-18 | 2003-10-23 | International Business Machines Corporation | Optimization of database network traffic based upon data-use analysis |
US20180095835A1 (en) * | 2016-10-05 | 2018-04-05 | International Business Machines Corporation | Resilient analytics utilizing dark data |
CN109145020A (en) * | 2018-07-23 | 2019-01-04 | 程之琴 | Information query method, from server, client and computer readable storage medium |
CN109241067A (en) * | 2018-08-21 | 2019-01-18 | 中国平安人寿保险股份有限公司 | transaction data management method and device |
CN109739885A (en) * | 2018-12-12 | 2019-05-10 | 平安科技(深圳)有限公司 | Data query method, apparatus, equipment and storage medium based on local cache |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111104454A (en) * | 2019-12-19 | 2020-05-05 | 国网湖南省电力有限公司 | Multi-dimensional data processing method, system and medium for monitoring requirements of power grid on cloud |
CN113222735A (en) * | 2021-05-21 | 2021-08-06 | 中国农业银行股份有限公司 | Method for inquiring transaction associated information and related device |
CN113222735B (en) * | 2021-05-21 | 2024-03-29 | 中国农业银行股份有限公司 | Transaction associated information query method and related device |
WO2023241405A1 (en) * | 2022-06-16 | 2023-12-21 | International Business Machines Corporation | Database query processing with database clients |
Also Published As
Publication number | Publication date |
---|---|
CN110321364B (en) | 2023-07-25 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US11301136B2 (en) | Capacity forecasting based on capacity policies and transactions | |
US10904112B2 (en) | Automatic capture of detailed analysis information based on remote server analysis | |
CN102508709B (en) | Distributed-cache-based acquisition task scheduling method in purchase, supply and selling integrated electric energy acquiring and monitoring system | |
CN110321364A (en) | Transaction data querying method, device and the terminal of credit card management system | |
US8566527B2 (en) | System and method for usage analyzer of subscriber access to communications network | |
US20080109547A1 (en) | Method, system and program product for determining a number of concurrent users accessing a system | |
JP7254975B2 (en) | Key-based logging for processing structured data items with executable logic | |
CN106326068A (en) | Resource index monitoring method and device | |
CN111586126A (en) | Method, device and equipment for pre-downloading small program and storage medium | |
CN109522115A (en) | Resource allocation method, electronic equipment and storage medium | |
CN106815254A (en) | A kind of data processing method and device | |
CN110096521A (en) | Log information processing method and device | |
CN109474479A (en) | A kind of network equipment monitoring method and system | |
CN103729417A (en) | Method and device for data scanning | |
CN108696559B (en) | Stream processing method and device | |
CN108664322A (en) | Data processing method and system | |
CN110764985A (en) | Method, system, equipment and readable storage medium for recording command line | |
Bi et al. | Dynamic fine-grained resource provisioning for heterogeneous applications in virtualized cloud data center | |
CN115794545A (en) | Automatic processing method of operation and maintenance data and related equipment thereof | |
CN107147542A (en) | A kind of information generating method and device | |
Kanagasabai et al. | Ec2bargainhunter: It's easy to hunt for cost savings on amazon ec2! | |
US10298437B2 (en) | Distributed data collection in an enterprise network | |
CN109725994A (en) | Data pick-up task executing method, device, terminal and readable storage medium storing program for executing | |
Jin et al. | Information value evaluation model for ILM | |
CN115242799B (en) | Data reporting method, device, equipment, storage medium and program product |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |