CN116823436A - Credit data reporting method, device and equipment - Google Patents
Credit data reporting method, device and equipment Download PDFInfo
- Publication number
- CN116823436A CN116823436A CN202310665200.8A CN202310665200A CN116823436A CN 116823436 A CN116823436 A CN 116823436A CN 202310665200 A CN202310665200 A CN 202310665200A CN 116823436 A CN116823436 A CN 116823436A
- Authority
- CN
- China
- Prior art keywords
- reporting
- credit
- message
- database
- scene
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 49
- 238000011835 investigation Methods 0.000 claims abstract description 36
- 238000007781 pre-processing Methods 0.000 claims abstract description 36
- 238000004458 analytical method Methods 0.000 claims abstract description 10
- 230000009471 action Effects 0.000 claims description 17
- 230000008569 process Effects 0.000 claims description 12
- 230000005540 biological transmission Effects 0.000 claims description 9
- 238000012545 processing Methods 0.000 claims description 7
- 230000002085 persistent effect Effects 0.000 claims description 4
- 230000008878 coupling Effects 0.000 abstract description 3
- 238000010168 coupling process Methods 0.000 abstract description 3
- 238000005859 coupling reaction Methods 0.000 abstract description 3
- 230000008520 organization Effects 0.000 description 10
- 238000010586 diagram Methods 0.000 description 7
- 238000004891 communication Methods 0.000 description 6
- 230000004048 modification Effects 0.000 description 5
- 238000012986 modification Methods 0.000 description 5
- 230000009286 beneficial effect Effects 0.000 description 4
- 230000008859 change Effects 0.000 description 4
- 230000001360 synchronised effect Effects 0.000 description 4
- 208000000474 Poliomyelitis Diseases 0.000 description 3
- 230000000694 effects Effects 0.000 description 3
- 230000008901 benefit Effects 0.000 description 2
- 230000006872 improvement Effects 0.000 description 2
- 230000004044 response Effects 0.000 description 2
- 238000007792 addition Methods 0.000 description 1
- 238000007796 conventional method Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000002688 persistence Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 230000011664 signaling Effects 0.000 description 1
- 230000033772 system development Effects 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
- 238000011144 upstream manufacturing Methods 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/03—Credit; Loans; Processing thereof
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Engineering & Computer Science (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a credit investigation data reporting method, a credit investigation data reporting device and equipment, wherein the method comprises the following steps: the service data of the service system is persisted into a service database, and a corresponding logic log is formed; analyzing the logic log, and transmitting an analysis result to the first message middleware; consuming the message in the first message middleware through a credit preprocessing module, storing a record corresponding to the message into a credit reporting database, and judging a reporting scene; determining a reporting scene and transmitting credit investigation reporting scene characteristic data to a second message middleware when the reporting scene is determined to have reporting conditions; and consuming the information in the second message middleware through the credit reporting module, inquiring and acquiring data in the credit reporting database according to the consumption result, and reporting the information so as to finish credit reporting. The invention solves the problems of large pressure, low efficiency, complex work, high coupling degree between the credit reporting service and the service system and the like of the service system caused by credit reporting.
Description
Technical Field
The present invention relates to the field of service data reporting, and in particular, to a method, an apparatus, and a device for reporting credit information.
Background
The business system refers to a system for providing service for each business line in an organization, such as a system for underwriting, claiming, paying and the like in the insurance industry, and is a system for first appearance of business data in the organization.
The credit reporting is mainly to collect and process the financial related business information (including personal basic information, credit transaction information, guarantee information and the like of clients) in the organization into a message required by a bank and report the message to a credit reporting center. That is, the information displayed on the credit report is reported by each access organization, and the bank credit center is only responsible for summarizing and arranging, and relevant information is displayed on the credit report of each person. Credit reporting within an organization often involves multiple sources of multiple business systems (e.g., underwriting systems, claims systems, etc. in the insurance industry).
The business system in an organization (hereinafter, exemplified by insurance industry) is often complicated, each link data of the credit report is scattered in multiple data sources of multiple business systems in the organization, a corresponding logic topology diagram is shown in fig. 1, it can be seen from fig. 1 that the required elements of the credit report in the organization originate from multiple business systems (underwriting, claim settlement, etc.), and the trigger point of the credit report (when the credit report action is triggered, such as the passing of a nuclear insurance, the passing of a nuclear batch, the report settlement of a claim, the claim settlement, etc.) and the business process have a strong binding relationship.
Because the trigger point of the credit reporting is strongly bound with the business flow, the existing general scheme embeds the reporting action into the business flow, and the reporting element data query involved in the reporting is based on the business database, so that double pressure is brought to the application of business strip lines and the database, the response speed of the core system to the business request is slow, and the core service is unavailable and the business is interrupted when serious.
The method and the device evaluate the merits of the credit reporting scheme, and mainly complete the credit reporting action timely, accurately and comprehensively according to whether the scheme can be perceived by the service system in a zero mode. The conventional credit reporting scheme at present has the following defects: 1. the service core application host machine service is shared, so that the interaction of the reporting service and the service core service can be caused; 2. the business process is strongly bound, and the mutual influence during upgrading and deployment is involved, for example, the credit reporting related change needs to wait for the business process requirement to be on line in the same version, etc.; 3. the service system is strongly bound with the service flow, and the service system can slow the deployment of credit demand change in the whole country due to the phenomenon of provincial deployment caused by large service flow difference among the provinces; 4. because the credit triggering points and the credit reporting elements are scattered on each service system, the same check rule needs to be realized for a plurality of times on a plurality of service systems, and the phenomenon of repeatedly manufacturing wheels exists; 5. the credit reporting should be independent of the service system from the service side, and is not an essential action of the service, and the service system does not need to care about credit reporting related rules, reporting elements and the like.
Disclosure of Invention
The invention provides a method, a device and equipment for reporting credit information data, which solve the problems of high pressure, low efficiency, complex work, high coupling degree between credit information reporting service and a business system and the like of the business system caused by credit information reporting.
A credit investigation data reporting method comprises the following steps:
the service data of the service system is persisted into a service database, and a corresponding logic log is formed;
analyzing the logic log, and transmitting an analysis result to a first message middleware;
consuming the message in the first message middleware through a credit preprocessing module, storing a record corresponding to the message into a credit reporting database, and judging a reporting scene;
determining a reporting scene and transmitting credit investigation reporting scene characteristic data to a second message middleware when the reporting scene is determined to have reporting conditions;
and consuming the information in the second information middleware through the credit reporting module, inquiring and acquiring the data in the credit reporting database according to the consumption result, and carrying out reporting processing so as to finish credit reporting.
In one embodiment of the present invention, the storing the record corresponding to the message in the credit reporting database, and performing credit reporting scene judgment specifically includes: after the credit preprocessing module consumes the message in the insurance policy theme of the first message middleware, converting the message into a corresponding record and storing the record into an insurance policy main table of a credit reporting database; if the credit investigation preprocessing module determines that the consumed message contains a policy number, inquiring whether records related to the policy number exist in a policy applicant table and a policy applicant table sub-table in the credit investigation report database according to the policy number contained in the message; each insurance policy number corresponds to one insurance policy; after determining that the record related to the insurance policy number is stored in the credit reporting database, determining that the required business action and element record in the current reporting scene meet the reporting condition.
In one embodiment of the present invention, the storing the record corresponding to the message in the credit reporting database, and performing credit reporting scene judgment specifically includes: after the credit investigation preprocessing module consumes the message in the insurance policy relation subject of the first message middleware, converting the message into a corresponding record and storing the record into a credit investigation report database insurance policy relation table; when the fact that the information does not comprise the insurance policy number field is determined, inquiring an insurance policy main table in the credit reporting database according to the insurance policy number included in the record; if a record related to the insurance policy number is found in the insurance policy master table, judging whether the insurance policy number corresponding to the record in the insurance policy master table has a value or not; if the policy number has a value, inquiring whether a record related to the policy number is stored in a policy relation people table, and if so, determining that the service action and element record required in the current reporting scene accord with reporting conditions; if the policy number has no value, continuing to consume the next message.
In one embodiment of the present invention, the storing the record corresponding to the message in the credit reporting database, and performing credit reporting scene judgment specifically includes: after the credit investigation preprocessing module consumes the message in the insuring list relational person sub-theme of the first message middleware, converting the message into a corresponding record and storing the record into a credit investigation report database insuring list relational person table; when the fact that the information does not comprise the insurance policy number field is determined, inquiring an insurance policy main table in the credit reporting database according to the insurance policy number included in the record; if a record related to the insurance policy number is found in the insurance policy master table, judging whether the insurance policy number corresponding to the record in the insurance policy master table has a value or not; if the policy number has a value, inquiring whether records related to the policy number are stored in a policy relation person table, and if so, determining that the service action and element records required in the current reporting scene accord with reporting conditions; if the policy number has no value, continuing to consume the next message.
In one embodiment of the present invention, when the reporting scene is determined and the reporting condition is determined to be met in the reporting scene, the signaling reporting scene feature data is transmitted to the second message middleware, which specifically includes: when the report condition is determined to be met under the specific report scene, generating a credit reporting feature message corresponding to the specific report scene through the credit reporting preprocessing module; and transmitting the credit reporting feature message to a second message middleware.
In one embodiment of the present invention, the consuming the message in the second message middleware by the credit reporting module queries and obtains the data in the credit reporting database according to the consuming result to perform the reporting process, so as to complete the credit reporting, which specifically includes: consuming the message in the credit feature theme of the second message middleware through a credit reporting module, and determining a reporting scene and a service main key corresponding to the message; inquiring service elements required by reporting in the credit reporting database according to the reporting scene and the service primary key; and generating a corresponding text file by the service element, encrypting the text file, and reporting the encrypted text file by credit on a browser side.
In one embodiment of the present invention, the credit reporting database and the service database are in a relationship of homogeneous subsets, and only the data table involved in the credit reporting is stored.
A credit investigation data reporting device, comprising:
the service database is used for persisting service data of the service system into the service database and forming a corresponding logic log;
the first transmission module is used for analyzing the logic log and transmitting an analysis result to the first message middleware;
the credit investigation preprocessing module is used for consuming the messages in the first message middleware, storing records corresponding to the messages into a credit investigation report database and judging report scenes;
the second transmission module is used for determining a reporting scene and transmitting the characteristic data of the reporting scene with the credit to the second message middleware when the reporting scene is determined to have reporting conditions;
and the credit reporting module is used for consuming the information in the second information middleware, inquiring and acquiring the data in the credit reporting database according to the consumption result and carrying out reporting processing so as to finish credit reporting.
A credit standing data reporting device, comprising:
at least one processor; the method comprises the steps of,
a memory communicatively coupled to the at least one processor via a bus; wherein,,
the memory stores instructions executable by the at least one processor to implement the method of any of the above embodiments.
A non-volatile storage medium storing computer executable instructions for execution by a processor to implement the method of any of the above embodiments.
The invention provides a credit investigation data reporting method, a credit investigation data reporting device and credit investigation data reporting equipment, which at least comprise the following beneficial effects:
1. service system decoupling
Because the data is synchronized by analyzing the logic logs, the data synchronization action and all downstream credit reporting logic processes are not sensitive to the service core system, and the service system is not affected, and the conventional implementation scheme often embeds the credit reporting logic into a plurality of service systems, so that unnecessary burden of the service system is caused (credit reporting is not a ring necessary for the service).
2. High timeliness of data
The second level after the business database data is changed can be synchronized into the message middleware, and compared with the conventional T+1 reporting (reporting on transaction day+1), the timeliness is higher.
3. Credit reporting logic centralization
The logic processing related to credit reporting is completed in the credit preprocessing module, so that compared with the conventional method of realizing the reporting logic in a plurality of service systems (a plurality of systems are required to be upgraded simultaneously), the method has higher upgrading and deployment efficiency, and the response speed of the demand change is higher, so that the overall iteration speed is accelerated.
4. Original data holding
The original data of the service database is synchronized through the analysis of the logic log, and the original service data is stored in the credit reporting database, so that the problem can be conveniently checked and positioned when the objection occurs.
5. Report work chain minimization
The upstream and downstream chains corresponding to the additional work generated by the credit reporting do not need to bring the business system in, so that the workload of IT practitioners such as business system development, testing and the like is reduced.
6. Reducing duplication of work
The credit reporting requires the operations such as checking the elements, and compared with the scheme of reporting by each system itself, which requires the repeated implementation of the same check rule in each system, the scheme can be realized only once during the credit preprocessing, thereby reducing the repeated actions of wheel making.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the invention and do not constitute a limitation on the invention. In the drawings:
fig. 1 is a logic topology diagram of service data transmission provided in an embodiment of the present invention;
fig. 2 is a schematic diagram of steps of a credit information data reporting method according to an embodiment of the present invention;
fig. 3 is a schematic diagram of a credit reporting process according to an embodiment of the present invention;
fig. 4 is a schematic diagram of a credit investigation data reporting device according to an embodiment of the present invention;
fig. 5 is a schematic diagram of a credit information reporting device according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention will be clearly and completely described in connection with the following specific embodiments of the present invention. It will be apparent that the described embodiments are only some, but not all, embodiments of the invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
It should be noted that those skilled in the art explicitly and implicitly understand that the described embodiments of the invention can be combined with other embodiments without conflict. Unless defined otherwise, technical or scientific terms used herein should be given the ordinary meaning as understood by one of ordinary skill in the art to which this invention belongs. The terms "a," "an," "the," and similar referents in the context of the invention are not to be construed as limiting the quantity, but rather as singular or plural. The terms "comprising," "including," "having," and any variations thereof, are intended to cover a non-exclusive inclusion; the terms "first," "second," "third," and the like, as used herein, are merely distinguishing between similar objects and not representing a particular ordering of objects.
The following description is presented in terms of terms related to embodiments of the present disclosure:
term interpretation (interpretation of terms that should be considered to be listed):
the service database refers to a related service set for providing data persistence service for the service system, the service data often occur in the service database, and the common service database is a relational database supporting transactions, such as MySQL, oracle, and the like.
A relational database refers to a database that employs a relational model to organize data, which stores data in rows and columns for ease of user understanding, the series of rows and columns of the relational database being referred to as tables, a set of tables comprising the database. The user retrieves the data in the database by querying, which is an executable code that defines certain areas in the database. A relational model can be understood simply as a two-dimensional tabular model, and a relational database is a data organization consisting of two-dimensional tables and relationships between them.
Logical logging refers to logging database modification operations. The operation is often a simple variant of user input, is not analyzed in detail, is irrelevant to the data organization form of the bottom layer of the database, is only relevant to the logical view style provided by the database, and can 'restore' the corresponding add-delete-modify operation by analyzing the log.
The message middleware is a supporting software system for providing synchronous or asynchronous and reliable message transmission for an application system in a network environment based on a queue and message transmission technology, has the advantages of asynchronously improving performance, reducing coupling degree, reducing flow peak clipping and the like, and is widely applied to an information system.
The producer: i.e. the sender is responsible for creating the message and then delivering it to the message middleware.
The consumer: i.e. the party receiving the message. The consumer connects to the message middleware and receives the message, and then carries out corresponding business logic processing.
Subject matter: messages in message middleware are categorized in topic units, with the producer responsible for sending messages to a particular topic and the consumer responsible for subscribing to the topic and consuming.
The core point of the invention is to realize zero-perception credit reporting of a related service system based on service database logic log analysis and message middleware, and realize timely, accurate and comprehensive credit reporting and decoupling of the credit reporting and the service system. The following is a detailed description.
Fig. 2 is a schematic step diagram of a credit information data reporting method according to an embodiment of the present invention, which may include the following steps:
s210: and (3) persisting the service data of the service system into a service database and forming a corresponding logic log.
Specifically, as shown in fig. 3, the core service system (such as the underwriting core application and the claim core application) persists the service data into the service database, and the database is subjected to the operations of adding, deleting and checking in the persisting process, wherein only the operations of adding, deleting and checking related to the data change are recorded in the logic log.
S220: and analyzing the logic log, and transmitting the analysis result to the first message middleware.
Specifically, after the service data is persisted to the service database, the database service forms a corresponding logic log, and the corresponding modification (addition, deletion and modification) operation in the service database is translated into a corresponding json format by analyzing the logic log and is produced into the message middleware, and the names of the topics in the message middleware are consistent with the names of the service database and the table names of the service database so as to see the names.
For example, under the condition that the basic information scenario is reported by the core through time (this scenario is exemplified below), the related underwriting database is named prpc, and the database table is named prpcmain (policy main table), prpcinsuried (policy relational table) and prpc, prpcinsuried, and the subject recommendation in the message middleware is named prpc.
S230: and consuming the message in the first message middleware through a credit preprocessing module, storing a record corresponding to the message into a credit reporting database, and judging a reporting scene.
In one embodiment of the invention, the credit reporting database and the service database are in a relationship of isomorphic subsets, and only the data table related to the credit reporting is stored. On the one hand, the credit reporting and the decoupling of the service system are realized, the double pressure brought by the application of the service strip line and the database is reduced, and the corresponding speed of the service request is improved. And the special library is special, the read-write performance is improved, the delay is reduced, the cost is saved, and the efficient management is realized.
In one embodiment of the present invention, a record corresponding to a message is stored in a credit reporting database, and credit reporting scene judgment is performed, which specifically includes: after the credit preprocessing module consumes the message in the insurance policy theme of the first message middleware, converting the message into a corresponding record and storing the record into an insurance policy main table of a credit reporting database; if the credit investigation preprocessing module determines that the consumed message contains the insurance policy number, inquiring whether records related to the insurance policy number in the credit investigation report database exist in the insurance policy relational person table and the insurance policy relational person table according to the insurance policy number contained in the message; each insurance policy number corresponds to one insurance policy; after determining that the record related to the insurance policy number is stored in the credit reporting database, determining that the required business action and element record in the current reporting scene meet the reporting condition.
Specifically, the credit preprocessing module consumes the message in the message middleware theme, stores the corresponding message into the credit reporting database (the relation of the credit reporting database and the service database is isomorphic subset, only stores the table related to the credit reporting), and simultaneously judges the credit scene, if the prpc.prpcmain theme is consumed, one message is consumed, and the structure is as follows:
the message indicates that a record is inserted into a table prpcmain of a service database cq5000prp3gdb, and a policy number procasano is vexevjjjjjjm 1 mdaxtuemwradntc 2 ng=, and a policy number polio is uexejjjm 1 mdaxtuemwradntm 2 ng=, so that a policy-based pre-processing module stores the message into the table prpcmain of the service database, and if the policy number polio is contained in the message, the policy is indicated that the policy is applied to be guaranteed to pass (a core is generated, and a policy number is generated), and element information of the table prpc.prpcinsind and prpcinsrenatu needs to be simultaneously transmitted when the basic information is transmitted through the core, so that whether a policy-based relational person table and a policy-related person table of the security number anti-feature database of the message need to be utilized at this time need to be checked, and whether a policy-based pre-processing module is required to be preprocessed is confirmed to store the message into a table of the service database, and if the policy-based policy number polio is contained in the message, and if the policy number proclaim is indicated to pass, and the element information of the policy-based on the policy is required to be transmitted to be required to be compressed in a scene of the service database, and the security records of the policy and the security is required to be transmitted to be compressed by the security and the security records of the security and the security records; and if prpc.prpcinsuried or prpc.prpcinsuredsnature information of the corresponding application form is absent in the credit reporting database, continuing to consume the next message.
In one embodiment of the present invention, a record corresponding to a message is stored in a credit reporting database, and credit reporting scene judgment is performed, which specifically includes: after the credit investigation preprocessing module consumes the message in the insurance policy relation subject of the first message middleware, converting the message into a corresponding record and storing the record into a credit investigation report database insurance policy relation table; when the fact that the information does not include the insurance policy number field is determined, inquiring an insurance policy main table in the credit reporting database according to the insurance policy number included in the record; if a record related to the insurance policy number is found in the insurance policy master table, judging whether the insurance policy number corresponding to the record in the insurance policy master table has a value or not; if the insurance policy number has a value, inquiring whether the record related to the insurance policy number is stored in an insurance policy relational person table, and if so, determining that the service action and element record required under the current reporting scene accord with reporting conditions; if the policy number has no value, consumption of the next message is continued.
Specifically, if a message is consumed when the prpc.prpcinsuried theme is consumed, the structure is as follows:
the above message indicates that a record is inserted into a table prpcinsuried of a service database cq5000prp3gdb, the applied single number proposalno is vexevjjjjjjm 1 mdaxtuemmdawntc 2 ng= =, the identity card number identifynumber is mtemmtk 5MDAzMDc2ODUx, the name of the applied person is 5byg LiJ, the message is stored in a message pre-processing module, the message is sent to the message sending database prpcinsuried, and because the message does not contain a policy number polico field, the applied single number proposalno of the record needs to be used for reversely looking up the prpcmain table of the message sending database, if no relevant record is found in the prpcmain table according to the corresponding applied single number proposalno, the message pre-processing module is indicated that the subject is not consumed in the prpcmain subject, and the message is continued to be consumed in the next record corresponding to the single number;
if the corresponding insurance policy number proposalno finds a relevant record in a prpcmain table of the credit reporting database, judging whether the corresponding insurance policy number polisyno recorded in the prpcmain table has a value, if so, checking whether a relevant record exists in a prpcinsuredstate table of another table required by the credit reporting database for reporting, and if so, indicating that the required business action and element record in the current reporting scene accord with reporting conditions; if the corresponding record has no value of the policy number polisyno, the fact that the record passing through the Proposalno core of the application list number is not found in the records of the current consumption prpc.prpcmain theme is indicated.
In one embodiment of the present invention, a record corresponding to a message is stored in a credit reporting database, and credit reporting scene judgment is performed, which specifically includes: after the credit investigation preprocessing module consumes the message in the insuring list relational person sub-theme of the first message middleware, converting the message into a corresponding record and storing the record into a credit investigation report database insuring list relational person table; when the fact that the information does not include the insurance policy number field is determined, inquiring an insurance policy main table in the credit reporting database according to the insurance policy number included in the record; if a record related to the insurance policy number is found in the insurance policy master table, judging whether the insurance policy number corresponding to the record in the insurance policy master table has a value or not; if the insurance policy number has a value, inquiring whether the record related to the insurance policy number is stored in an insurance policy relationship person table, and if so, determining that the service action and element record required under the current reporting scene accord with reporting conditions; if the policy number has no value, consumption of the next message is continued.
Specifically, for example, a record is inserted into a table prpcinsurednaure of a service database cq5000prp3gdb, the application list number proposalno is vexevjjjjjjjm 1 mdaxtujmdadwntc 2 ng= =, the birth date birthday is MjAxOS0wNy0xMw =, the address is 5YyX5Lqs5biC6YCa5bee5 y46J 5bee5 y5Y 6546J5qGl Y2X6YeM, the credit preprocessing module stores the message into the credit report database prpcinsurednaure table, and because the message does not contain a policy number policyno field, the prpcn table of the credit report database needs to be reversely searched by using the application list number proposalno of the record, if no related record is not found in the application list according to the corresponding policy number proposal, and the credit preprocessing module indicates that the consumption of the message is continued until the message is not consumed in the corresponding list of the credit preprocessing module;
if the corresponding insurance policy number proposalno finds a related record in a prpcmain table of the credit reporting database, judging whether the policy number polisyno corresponding to the record in the prpcmain table has a value, if so, checking whether a related record exists in a prpcinsuried table of another table required by the credit reporting database, and if so, indicating that the required business action and element record in the current reporting scene accord with reporting conditions; if the corresponding recorded policy number polisyno has no value, the fact that the record passed by the Proposalno core of the applied policy number is not found in the record of the current consumption prpc.prpcmain theme is indicated, and the next message is continuously consumed.
S240: and when the reporting scene is determined and reporting conditions are determined to be met under the reporting scene, transmitting the credit investigation reporting scene characteristic data to the second message middleware.
In one embodiment of the present invention, when determining a reporting scene and determining that a reporting condition is provided in the reporting scene, transmitting credit reporting scene feature data to a second message middleware, specifically including: when the report condition is determined to be met under the specific report scene, generating a credit reporting feature message corresponding to the specific report scene through a credit reporting preprocessing module; and transmitting the credit reporting feature message to the second message middleware.
Specifically, when the credit preprocessing module has a reporting condition in a specific reporting scene, a credit reporting feature message is generated to indicate that a specific element is reported in the scene, and the structure is as follows:
{
"businessNo":"UExEVjIwMjM1MDAxTUEwMDAwNTM2Ng==",
"reportType" 110-personal basic information record "
}
The information indicates that the personal basic information scene is reported for the verification passing time (reportType is 110), the business main key produced into the theme is businessmen No, and the messages produced into the theme are all messages processed by the credit preprocessing module, namely, the messages entering the credit feature theme have reporting conditions in the credit reporting database.
S250: and consuming the information in the second message middleware through the credit reporting module, inquiring and acquiring data in the credit reporting database according to the consumption result, and reporting the information so as to finish credit reporting.
In one embodiment of the present invention, a message in the second message middleware is consumed by a credit reporting module, and data in a credit reporting database is queried and obtained according to a consumption result to perform reporting processing, so as to complete credit reporting, and the method specifically includes: consuming the message in the credit feature theme of the second message middleware through a credit reporting module, and determining a reporting scene and a service primary key corresponding to the message; inquiring service elements required by reporting in a credit reporting database according to the reporting scene and the service primary key; and generating a corresponding text file by the service element, encrypting the text file, and reporting the encrypted text file by credit on a browser side.
Specifically, the credit reporting module consumes credit feature topics, determines a reporting scene and a service primary key corresponding to a message in the credit feature topics, queries service elements required by reporting in credit reporting data according to the service primary key and the reporting scene (if the service elements are ensured to pass through a reporting personal basic information scene, the elements corresponding to three tables of prpc.prpcmain, prpc.prpcinsuried and prpc.prpcinslendnatural are collected according to a credit reporting database of the service primary key), generates a corresponding text file according to a structure specified by a bank, encrypts the corresponding text file, and finally performs credit reporting at a PC browser.
The above method for reporting credit information according to the embodiment of the present invention is based on the same inventive concept, and the embodiment of the present invention further provides a corresponding apparatus for reporting credit information, as shown in fig. 4.
A service database 402, configured to persist service data of a service system into the service database, and form a corresponding logical log; the first transmission module 404 is configured to parse the logic log, and transmit the parsing result to the first message middleware; the credit preprocessing module 406 is configured to consume a message in the first message middleware, store a record corresponding to the message in the credit report database, and perform report scene judgment; the second transmission module 408 is configured to determine a reporting scene and transmit the feature data of the reporting scene to the second message middleware when determining that the reporting scene has reporting conditions; and the credit reporting module 410 is used for consuming the message in the second message middleware, inquiring and acquiring the data in the credit reporting database according to the consumption result, and reporting the data to complete credit reporting.
The embodiment of the invention also provides a corresponding credit information data reporting device, as shown in fig. 5, comprising:
at least one processor 502 (processor), a communication interface 504 (Communications Interface), a memory 506 (memory), and a communication bus 508; wherein the processor 502, the communication interface 504, the memory 506 complete the communication with each other through the communication bus 508; the processor 502 may invoke logic instructions stored in the memory 506 to cause at least one processor 502 to execute:
the service data of the service system is persisted into a service database, and a corresponding logic log is formed; analyzing the logic log, and transmitting an analysis result to the first message middleware; consuming the message in the first message middleware through a credit preprocessing module, storing a record corresponding to the message into a credit reporting database, and judging a reporting scene; determining a reporting scene and transmitting credit investigation reporting scene characteristic data to a second message middleware when the reporting scene is determined to have reporting conditions; and consuming the information in the second message middleware through the credit reporting module, inquiring and acquiring data in the credit reporting database according to the consumption result, and reporting the information so as to finish credit reporting.
Based on the same thought, some embodiments of the present invention also provide a medium corresponding to the above method.
Some embodiments of the invention provide a storage medium storing computer executable instructions for execution by a processor to perform the steps of:
the service data of the service system is persisted into a service database, and a corresponding logic log is formed; analyzing the logic log, and transmitting an analysis result to the first message middleware; consuming the message in the first message middleware through a credit preprocessing module, storing a record corresponding to the message into a credit reporting database, and judging a reporting scene; determining a reporting scene and transmitting credit investigation reporting scene characteristic data to a second message middleware when the reporting scene is determined to have reporting conditions; and consuming the information in the second message middleware through the credit reporting module, inquiring and acquiring data in the credit reporting database according to the consumption result, and reporting the information so as to finish credit reporting.
The embodiments of the present invention are described in a progressive manner, and the same and similar parts of the embodiments are all referred to each other, and each embodiment is mainly described in the differences from the other embodiments. In particular, for the apparatus and medium embodiments, the description is relatively simple, as it is substantially similar to the method embodiments, with reference to the section of the method embodiments being relevant.
The devices and media provided in the embodiments of the present invention are in one-to-one correspondence with the methods, so that the devices and media also have similar beneficial technical effects as the corresponding methods, and since the beneficial technical effects of the methods have been described in detail above, the beneficial technical effects of the devices and media are not repeated here.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process article or method that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process article or method. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process method article or method comprising the element.
The foregoing is merely exemplary of the present invention and is not intended to limit the present invention. While the invention has been described in detail in the foregoing general description and with reference to specific embodiments thereof, it will be apparent to one skilled in the art that modifications and improvements can be made thereto. Accordingly, such modifications or improvements may be made without departing from the spirit of the invention and are intended to be within the scope of the invention as claimed.
Claims (10)
1. The credit information data reporting method is characterized by comprising the following steps:
the service data of the service system is persisted into a service database, and a corresponding logic log is formed;
analyzing the logic log, and transmitting an analysis result to a first message middleware;
consuming the message in the first message middleware through a credit preprocessing module, storing a record corresponding to the message into a credit reporting database, and judging a reporting scene;
determining a reporting scene and transmitting credit investigation reporting scene characteristic data to a second message middleware when the reporting scene is determined to have reporting conditions;
and consuming the information in the second information middleware through the credit reporting module, inquiring and acquiring the data in the credit reporting database according to the consumption result, and carrying out reporting processing so as to finish credit reporting.
2. The method according to claim 1, wherein the storing the record corresponding to the message in the credit reporting database and performing credit reporting scene judgment specifically includes:
after the credit preprocessing module consumes the message in the insurance policy theme of the first message middleware, converting the message into a corresponding record and storing the record into an insurance policy main table of a credit reporting database;
if the credit investigation preprocessing module determines that the consumed message contains a policy number, inquiring whether records related to the policy number exist in a policy applicant table and a policy applicant table sub-table in the credit investigation report database according to the policy number contained in the message; each insurance policy number corresponds to one insurance policy;
after determining that the record related to the insurance policy number is stored in the credit reporting database, determining that the required business action and element record in the current reporting scene meet the reporting condition.
3. The method according to claim 1, wherein the storing the record corresponding to the message in the credit reporting database and performing credit reporting scene judgment specifically includes:
after the credit investigation preprocessing module consumes the message in the insurance policy relation subject of the first message middleware, converting the message into a corresponding record and storing the record into a credit investigation report database insurance policy relation table;
when the fact that the information does not comprise the insurance policy number field is determined, inquiring an insurance policy main table in the credit reporting database according to the insurance policy number included in the record;
if a record related to the insurance policy number is found in the insurance policy master table, judging whether the insurance policy number corresponding to the record in the insurance policy master table has a value or not;
if the policy number has a value, inquiring whether a record related to the policy number is stored in a policy relation people table, and if so, determining that the service action and element record required in the current reporting scene accord with reporting conditions;
if the policy number has no value, continuing to consume the next message.
4. The method according to claim 1, wherein the storing the record corresponding to the message in the credit reporting database and performing credit reporting scene judgment specifically includes:
after the credit investigation preprocessing module consumes the message in the insuring list relational person sub-theme of the first message middleware, converting the message into a corresponding record and storing the record into a credit investigation report database insuring list relational person table;
when the fact that the information does not comprise the insurance policy number field is determined, inquiring an insurance policy main table in the credit reporting database according to the insurance policy number included in the record;
if a record related to the insurance policy number is found in the insurance policy master table, judging whether the insurance policy number corresponding to the record in the insurance policy master table has a value or not;
if the policy number has a value, inquiring whether records related to the policy number are stored in a policy relation person table, and if so, determining that the service action and element records required in the current reporting scene accord with reporting conditions;
if the policy number has no value, continuing to consume the next message.
5. The method according to claim 1, wherein when the reporting scene is determined and the reporting condition is determined to be met in the reporting scene, transmitting the credit reporting scene feature data to the second message middleware specifically includes:
when the report condition is determined to be met under the specific report scene, generating a credit reporting feature message corresponding to the specific report scene through the credit reporting preprocessing module;
and transmitting the credit reporting feature message to a second message middleware.
6. The method according to claim 1, wherein the consuming the message in the second message middleware by the credit reporting module queries and obtains the data in the credit reporting database according to the consumption result to perform the reporting process, so as to complete the credit reporting, and specifically includes:
consuming the message in the credit feature theme of the second message middleware through a credit reporting module, and determining a reporting scene and a service main key corresponding to the message;
inquiring service elements required by reporting in the credit reporting database according to the reporting scene and the service primary key;
and generating a corresponding text file by the service element, encrypting the text file, and reporting the encrypted text file by credit on a browser side.
7. The method of claim 1, wherein the credit reporting database and the service database are in a homogeneous subset relationship, and only a data table involved in credit reporting is maintained.
8. A credit data reporting device, comprising:
the service database is used for persisting service data of the service system into the service database and forming a corresponding logic log;
the first transmission module is used for analyzing the logic log and transmitting an analysis result to the first message middleware;
the credit investigation preprocessing module is used for consuming the messages in the first message middleware, storing records corresponding to the messages into a credit investigation report database and judging report scenes;
the second transmission module is used for determining a reporting scene and transmitting the characteristic data of the reporting scene with the credit to the second message middleware when the reporting scene is determined to have reporting conditions;
and the credit reporting module is used for consuming the information in the second information middleware, inquiring and acquiring the data in the credit reporting database according to the consumption result and carrying out reporting processing so as to finish credit reporting.
9. A credit data reporting apparatus, comprising:
at least one processor; the method comprises the steps of,
a memory communicatively coupled to the at least one processor via a bus; wherein,,
the memory stores instructions executable by the at least one processor to implement the method of any one of claims 1-7.
10. A non-volatile storage medium storing computer executable instructions for execution by a processor to implement the method of any one of claims 1 to 7.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202310665200.8A CN116823436A (en) | 2023-06-06 | 2023-06-06 | Credit data reporting method, device and equipment |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202310665200.8A CN116823436A (en) | 2023-06-06 | 2023-06-06 | Credit data reporting method, device and equipment |
Publications (1)
Publication Number | Publication Date |
---|---|
CN116823436A true CN116823436A (en) | 2023-09-29 |
Family
ID=88142125
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202310665200.8A Pending CN116823436A (en) | 2023-06-06 | 2023-06-06 | Credit data reporting method, device and equipment |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN116823436A (en) |
-
2023
- 2023-06-06 CN CN202310665200.8A patent/CN116823436A/en active Pending
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109034993A (en) | Account checking method, equipment, system and computer readable storage medium | |
US9053112B2 (en) | Automated data validation | |
CN111506559A (en) | Data storage method and device, electronic equipment and storage medium | |
US20040194112A1 (en) | Entity linking system | |
CN113010542B (en) | Service data processing method, device, computer equipment and storage medium | |
JP2003178222A (en) | Data converting method and device between business protocols and its processing program | |
CN112749167B (en) | Method and device for determining broken link data and nonvolatile storage medium | |
CN107451301B (en) | Processing method, device, equipment and storage medium for real-time delivery bill mail | |
CN111753015B (en) | Data query method and device of payment clearing system | |
CN101964710A (en) | Digital signature and signature authenticating method | |
CN115168400A (en) | External data management system and method | |
CN111666344A (en) | Heterogeneous data synchronization method and device | |
US11768954B2 (en) | System, method and computer-accessible medium for capturing data changes | |
WO2024131091A1 (en) | Information association method and apparatus, device, and storage medium | |
CN111400187A (en) | Parameter dynamic verification system and method based on customized data source | |
CN116823436A (en) | Credit data reporting method, device and equipment | |
CN115757642A (en) | Data synchronization method and device based on filing log file | |
CN115658753A (en) | Method and device for inquiring electronic receipt and related equipment | |
CN113934729A (en) | Data management method based on knowledge graph, related equipment and medium | |
CN110297842B (en) | Data comparison method, device, terminal and storage medium | |
CN114090686A (en) | Account-out acceleration method and device | |
TWI830610B (en) | How to manage cross-system audit logs | |
CN115423595B (en) | File information processing method and device, computer equipment and storage medium | |
US11829343B2 (en) | Generating a business object | |
CN118170760A (en) | Efficient data storage and retrieval method for SaaS system |
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 |