Transaction query method and device, electronic equipment and readable storage medium thereof

A query method and technology of a query device, which are applied in the field of transaction query, can solve the problems of operation risk, high CPU utilization rate of the database, and become hot data, etc., and achieve the effect of avoiding slow query.

Pending Publication Date: 2020-11-06
CHINA CONSTRUCTION BANK
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

During the query process, the database will lock the data to ensure data consistency. If there are concurrent executions of query statements for the same data and conditions, multiple query statements will be queued for execution, causing high CPU usage in the database and slow query execution. problem, the data involved will become hot data, causing operational risks

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Transaction query method and device, electronic equipment and readable storage medium thereof
  • Transaction query method and device, electronic equipment and readable storage medium thereof
  • Transaction query method and device, electronic equipment and readable storage medium thereof

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0041] Embodiments of the present application are described in detail below, examples of which are shown in the drawings, wherein the same or similar reference numerals denote the same or similar elements or elements having the same or similar functions throughout. The embodiments described below by referring to the figures are exemplary only for explaining the present application, and should not be construed as limiting the present invention.

[0042] Those skilled in the art will understand that unless otherwise stated, the singular forms "a", "an", "said" and "the" used herein may also include plural forms. It should be further understood that the word "comprising" used in the specification of the present application refers to the presence of the features, integers, steps, operations, elements and / or components, but does not exclude the presence or addition of one or more other features, Integers, steps, operations, elements, components, and / or groups thereof. It will be u...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention relates to the field of bank transactions, in particular to a transaction query method and device, electronic equipment and a readable computer storage medium. The transaction query method comprises the following steps: receiving a first query request of a target merchant; retrieving a query request set cached by the target merchant in a preset time period; if the cached query request set meets a set first condition, performing transaction query according to the first query request; and if the cached query request set does not meet the set first condition, caching the first queryrequest, and updating the cached query request set. Based on the scheme disclosed by the invention, the query request in the cache can be queried according to the set query frequency to control the query of the database, so that the risk of slow query or query system crash caused by query hotspots due to a large number of queries is avoided.

Description

technical field [0001] The present invention relates to the field of bank transactions, in particular to a transaction inquiry method, device, electronic equipment and computer-readable storage medium Background technique [0002] At present, the common transaction inquiry services of merchants in the financial field are single inquiry and page-by-page inquiry. Single query is generally based on merchant number + merchant order number / bank serial number / retrieval reference number / terminal serial number and other elements to locate a certain transaction record for query. It is often used for asynchronous merchant query and confirmation of transaction results. Pagination query generally queries the results of large data sets based on elements such as merchant number + transaction date, and is used for transaction reconciliation, etc. The acquiring system generally uses a strongly consistent OLTP (On-Line Transaction Processing) database as the database for accounting records,...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/2453G06F16/2455G06F11/00
CPCG06F11/004G06F16/2453G06F16/24552
Inventor 邱文超揭育柱梁艳姬吴兴威李观钊尹智付小丽郑梓悫
Owner CHINA CONSTRUCTION BANK
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap