Reimbursement bill examination and approval query method and system

A query method and technology of a query system, applied in the field of reimbursement approval query method and system, capable of solving problems such as poor SQL performance and poor readability of query system codes

Pending Publication Date: 2021-09-03
杭州每刻科技有限公司
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] At present, the query method of reimbursement approval is mainly the real-time query implemented by the PostgreSQL database itself. The existing reimbursement system provides field dynamic query, fuzzy query and other query services. However, the reimbursement query through the PostgreSQ

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
  • Reimbursement bill examination and approval query method and system
  • Reimbursement bill examination and approval query method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] The following description serves to disclose the present invention to enable those skilled in the art to carry out the present invention. The preferred embodiments described below are only examples, and those skilled in the art can devise other obvious variations. The basic principles of the present invention defined in the following description can be applied to other embodiments, variations, improvements, equivalents and other technical solutions without departing from the spirit and scope of the present invention.

[0024] It can be understood that the term "a" should be understood as "at least one" or "one or more", that is, in one embodiment, the number of an element can be one, while in another embodiment, the number of the element The quantity can be multiple, and the term "a" cannot be understood as a limitation on the quantity.

[0025] The invention discloses a method and system for examining and approving an reimbursement form. The system is as follows: fi...

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 discloses a reimbursement bill examination and approval query method which is characterized by comprising the following steps: obtaining bi n log log data of a PostgreSQL (Structured Query Language) database, setting a Debezium monitoring plug-in, and monitoring reimbursement bill examination and approval core list data in the bi n log log data; synchronizing the reimbursement bill approval core list data to the kafka cluster for storage; establishing an ElasticSearch index, and synchronizing the stored reimbursement bill approval core list data to an ElasticSearch database; and inquiring the reimbursement bill approval core list data through the ElasticSearch index. According to the method and the system, a corresponding reimbursement bill examination and approval core data list in a PostgreSQL database is synchronized into a kafka cluster, query operation of the reimbursement bill examination and approval core data list is realized through an El last icSearch search engine, complex query logic does not need to be constructed in the PostgreSQL database in the query process, separated query of processing logic of a code level is realized, and thus the coupling degree of codes can be reduced, and maintenance of the PostgreSQL database is facilitated.

Description

technical field [0001] The invention relates to the field of financial inquiry, in particular to a method and system for examining and approving an reimbursement form. Background technique [0002] At present, the query method of reimbursement approval is mainly the real-time query implemented by the PostgreSQL database itself. The existing reimbursement system provides field dynamic query, fuzzy query and other query services. However, the reimbursement query through the PostgreSQL database requires multi-table association, subquery and Left and right matching fuzzy query methods are used to query. Only using PostgreSQL database requires some complex SQL such as multi-table association and nested query, which makes the code of the query system less readable. Difference. Contents of the invention [0003] One of the purposes of the present invention is to provide a reimbursement form approval query method and system. The method and system can meet the query requirements o...

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
IPC IPC(8): G06F16/2457G06F16/242G06F9/54G06Q10/10G06Q40/00
CPCG06F16/2457G06F16/2433G06Q10/10G06Q40/125G06F9/546G06F2209/548
Inventor 葛优
Owner 杭州每刻科技有限公司
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