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.