CN112967035A - Cross-database service system account tracking/evaluation method and system - Google Patents
Cross-database service system account tracking/evaluation method and system Download PDFInfo
- Publication number
- CN112967035A CN112967035A CN202110277119.3A CN202110277119A CN112967035A CN 112967035 A CN112967035 A CN 112967035A CN 202110277119 A CN202110277119 A CN 202110277119A CN 112967035 A CN112967035 A CN 112967035A
- Authority
- CN
- China
- Prior art keywords
- production
- transaction
- data
- message
- service
- 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
- 238000011156 evaluation Methods 0.000 title claims abstract description 38
- 238000004519 manufacturing process Methods 0.000 claims abstract description 119
- 238000012545 processing Methods 0.000 claims abstract description 27
- 238000007781 pre-processing Methods 0.000 claims abstract description 25
- 238000000034 method Methods 0.000 claims abstract description 22
- 230000005540 biological transmission Effects 0.000 claims abstract description 12
- 238000004088 simulation Methods 0.000 claims abstract description 11
- 238000006243 chemical reaction Methods 0.000 claims description 9
- 230000008569 process Effects 0.000 claims description 9
- 238000012423 maintenance Methods 0.000 claims description 4
- 230000009466 transformation Effects 0.000 claims 2
- 238000012360 testing method Methods 0.000 abstract description 4
- 238000012795 verification Methods 0.000 description 6
- 230000002354 daily effect Effects 0.000 description 4
- 238000010586 diagram Methods 0.000 description 3
- 230000007246 mechanism Effects 0.000 description 3
- 238000012550 audit Methods 0.000 description 2
- 230000003203 everyday effect Effects 0.000 description 2
- 238000011056 performance test Methods 0.000 description 2
- 230000004044 response Effects 0.000 description 2
- 230000006978 adaptation Effects 0.000 description 1
- 230000004075 alteration Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000013524 data verification Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000001915 proofreading effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 1
Images
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
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- 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
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
-
- 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/04—Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- General Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- Databases & Information Systems (AREA)
- Development Economics (AREA)
- Educational Administration (AREA)
- Data Mining & Analysis (AREA)
- Operations Research (AREA)
- Tourism & Hospitality (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Quality & Reliability (AREA)
- Game Theory and Decision Science (AREA)
- Technology Law (AREA)
- General Engineering & Computer Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention discloses a method and a system for performing business system account tracking/evaluation across databases, wherein the method comprises the following steps: the collection step comprises: acquiring service message information on a production core service system to obtain message data of production transaction; message processing steps: preprocessing the message data to obtain production data; a scheduling step: carrying out grouping scheduling on the production data according to a strategy to prepare for the transmission of a simulation production link; a sending step: sending the grouped production data to a newly built system/production standby system to be evaluated; and (3) checking: and checking the returned processed transaction result message in real time, and performing daily and final check on the processed service data. The invention can objectively and truly evaluate the applicability of the newly-built system without influencing the operation of the original service system under the real service environment, and can automatically test by using the real service.
Description
Technical Field
The invention relates to the technical field of bank IT, in particular to a method and a system for performing transaction system reconciliation/evaluation across databases.
Background
In the bank system, if a new database is evaluated to be used in the business system, the business system code needs to be transplanted and docked to the new database, then business personnel carry out business test and confirm the correctness of the result, and performance test is carried out by selecting part of transactions to see whether the requirements of the business are met on the response time and the throughput capacity of the system. Under the condition, the service system is applied to the new database, the test is carried out in a manual or simulation mode, and only after the service system is really on line can the adaptation condition of the service system to the new database under the real service scene be reflected, and the real service scene cannot be operated in advance, so that more uncontrollable risks exist when the new database is used for carrying out on-line service.
The performance evaluation of the database is generally performed by designing the operation of SQL statements and repeatedly running the SQL statements to test, and the performance of the database is evaluated according to the running times of the SQL statements in unit time. However, the evaluation index of the database can reflect the performance of the database, but cannot be intuitively converted into the evaluation of the service system, for example, the TPCC index of the database cannot be intuitively converted into the TPS index of the service system, and the evaluation of the performance of the service system is the transaction response time and the TPS per second transaction processing data.
In a banking system, the tracking of business is generally performed in the same business application system in a manual or message manner, but cannot be performed in a system that uses the same database but different databases, or even in a system that uses different databases but achieves the same function. The general situation of the banking business scene does not exist, and the tracking is performed on the completely same application system and database, but after a new database is adopted or when a new business system is adopted, if the parallelism of a new system and an old system can be realized, namely under the condition that the original system is not influenced, the real reappearance of the original business is realized in the new system, and the correctness of the new system is checked with the old system, more verification can be performed on the new system and the database before the new system is on line, so that the possibility of problems after the new system is on line is reduced; the real operation of the service can also intuitively reflect the difference of the new system and the old system in all aspects.
Disclosure of Invention
The technical problem to be solved by the embodiments of the present invention is to provide a method and a system for performing business system tracking/evaluation across databases, so as to evaluate the applicability of a new database to a business system more objectively and truly.
In order to solve the above technical problem, an embodiment of the present invention provides a method for performing business system ledger-tracking/evaluation across databases, including:
the collection step comprises: acquiring service message information on a production core service system to obtain message data of production transaction;
message processing steps: preprocessing the message data to obtain production data;
a scheduling step: carrying out grouping scheduling on the production data according to a strategy to prepare for the transmission of a simulation production link;
a sending step: sending the grouped production data to a newly built system/production standby system to be evaluated; in the sending process, the production link is simulated to send in a mode of multi-transaction parallel sending, synchronization control according to time slices and sending time sequence control according to timestamps;
and (3) checking: and checking the processed transaction result message returned by the newly built system/the production standby system in real time, and performing daily and final check on the processed service data.
Correspondingly, the embodiment of the invention also provides a system for performing business system account tracking/evaluation across databases, which comprises:
an acquisition module: acquiring service message information on a production core service system to obtain message data of production transaction;
a message processing module: preprocessing the message data to obtain production data;
a scheduling module: carrying out grouping scheduling on the production data according to a strategy to prepare for the transmission of a simulation production link;
a sending module: sending the grouped production data to a newly built system/production standby system to be evaluated; in the sending process, the production link is simulated to send in a mode of multi-transaction parallel sending, synchronization control according to time slices and sending time sequence control according to timestamps;
a checking module: and checking the processed transaction result message returned by the newly built system/the production standby system in real time, and performing daily and final check on the processed service data.
The invention has the beneficial effects that: the invention realizes the operation of the new database of the newly-built service system to be tested under the real service environment without influencing the operation of the original service system, can objectively and truly evaluate the applicability of the new database to the service system, and can realize the service switching between the new database and the original database; the account-following function also compares the performance difference of the new service system with the performance difference of the original service system, which originally needs to be tested by manpower or use cases, and can be automatically tested by the real service through the account-following/evaluating system.
Drawings
Fig. 1 is a schematic flow chart of a method for performing transaction system reconciliation/evaluation across databases according to an embodiment of the present invention.
Fig. 2 is a schematic diagram of a synchronization processing mechanism controlled by time slices according to an embodiment of the present invention.
Fig. 3 is a schematic structural diagram of a system for performing business system posting/evaluation across databases according to an embodiment of the present invention.
Fig. 4 is a schematic diagram of a transaction scheduling packet time-in-sequence processing mechanism according to an embodiment of the present invention.
Fig. 5 is a TPS graph of a production core services system and a newly built system of example 1 of the present invention.
Fig. 6 is a TPS graph of a production core services system and a newly built system of example 2 of the present invention.
Detailed Description
It should be noted that the embodiments and features of the embodiments in the present application can be combined with each other without conflict, and the present invention is further described in detail with reference to the drawings and specific embodiments.
If directional indications (such as up, down, left, right, front, and rear … …) are provided in the embodiment of the present invention, the directional indications are only used to explain the relative position relationship between the components, the movement, etc. in a specific posture (as shown in the drawing), and if the specific posture is changed, the directional indications are changed accordingly.
In addition, the descriptions related to "first", "second", etc. in the present invention are only used for descriptive purposes and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one such feature.
Referring to fig. 1, the method for performing business system reconciliation/evaluation across databases according to the embodiment of the present invention includes an acquisition step, a message processing step, a scheduling step, a transmission step, and a checking step.
The collection step comprises: and collecting service message information on the production core service system to obtain message data of production transaction. The acquisition of the embodiment of the invention comprises 2 modes: collecting message flow water meters (namely transaction data) from a production core service system database; and collecting (i.e., collecting transaction data) from the message log file. The production core service system consists of a production database and a core service system.
Message processing steps: and preprocessing the message data to obtain production data.
A scheduling step: and carrying out grouping scheduling on the production data according to a strategy, and preparing for the transmission of the simulation production link.
A sending step: sending the grouped production data to a newly-built system to be evaluated (namely, a newly-built production core service system which consists of a production database and a core service system)/a production standby system; in the sending process, the production link is simulated to send in a mode of multi-transaction parallel sending, synchronization control according to time slices and sending time sequence control according to time stamps.
And (3) checking: and checking the processed transaction result message returned by the newly built system/production standby system to be evaluated in real time, and performing final-day check on the processed service data.
In the sending step, a time slice parameter T is set, all transactions are divided into n batches at a time interval of T, and are sent from morning to evening in batches according to time;
and when the transaction data of each time slice batch is processed, the transaction data are transmitted in parallel, and the transmission sequence is sequenced and forwarded according to the original receiving time stamp of the transaction.
As shown in fig. 2, the embodiment of the present invention sets a time slice parameter T (milliseconds), and all transactions occurring in the production environment are divided into n batches by the platform at time intervals of T and forwarded in a strict time sequence. The size of T can be adjusted, and the smaller the unit time slice is, the closer the real pressure of the processing system and the production system is.
As one embodiment, the preprocessing includes key field preprocessing and message conversion.
Preprocessing a key field: and preprocessing the key field to ensure that the final transaction result is consistent with the production core service system, wherein the key field is important service data generated when the production core service system completes the transaction, such as an account serial number, a newly-opened account number/card number of a customer and the like. After the related transactions related to the key fields are forwarded to the newly built system/production standby system to be evaluated, the newly built system/production standby system is required to generate the same business data, and the normal operation of the subsequent business can be ensured. In order to realize the point, the embodiment of the invention analyzes, processes and stores the key field returned by the original production transaction, transmits the key field to a newly-built system/production standby system (namely a target system) through various channels, and performs specialized processing by the target system to ensure that the final transaction result is consistent with the original production core service system.
Message conversion: and converting the message format according to the transaction application interface specification of the newly-built system/the production standby system to be evaluated. Because the transaction application interface specification of the new system/production standby system to be evaluated is different from that of the production core service system, the conversion between the two message formats has to be carried out. And finally, the message conversion ensures that the input service elements are the same when the systems of the two parties process.
In the floor practice of the project, in the account tracking mode, because the systems of the two parties are generally the same and only the databases are different, the preprocessing of the message data only needs to use the key field preprocessing function. In the evaluation mode, because the newly built system/production standby system (i.e. the target system) to be evaluated is generally a newly built system, not only the databases are different, but also the application system and the message format specification are different from those of the original production core service system, and therefore, a message conversion function is required.
As an embodiment, the checking step comprises the operation and maintenance step: and performing performance analysis on the database of the newly built system/the production standby system to be evaluated, wherein the performance analysis comprises the time consumption of processing a single SQL statement used in the business transaction and the time consumption of the whole business transaction.
Referring to fig. 3, the cross-database business system reconciliation/evaluation system according to the embodiment of the present invention includes an acquisition module, a message processing module, a scheduling module, a sending module, and a checking module.
An acquisition module: acquiring service message information on a production core service system to obtain message data of production transaction;
a message processing module: preprocessing the message data to obtain production data;
a scheduling module: carrying out grouping scheduling on the production data according to a strategy to prepare for the transmission of a simulation production link;
a sending module: sending the grouped production data to a newly built system/production standby system to be evaluated; in the sending process, the production link is simulated to send in a mode of multi-transaction parallel sending, synchronization control according to time slices and sending time sequence control according to timestamps;
a checking module: and checking the processed transaction result message returned by the newly built system/production standby system to be evaluated in real time, and performing final-day check on the processed service data.
The result verification is generally performed by adopting a key field comparison method, in the development process, a developer sets a return interface key field verification list according to different transactions, after the transaction forwarding obtains a result when the cross-database transaction system audit/evaluation system formally operates, the cross-database transaction system audit/evaluation system can perform item-by-item verification between two systems according to the list, for example, the verification fields can be as follows: success-failure flag, transaction amount, account balance, customer name, etc.
After result proofreading, when the returned result field value is not consistent with the original service returned field value of the production core service system, according to the set service rule, carrying out the next processing, wherein the processing comprises the following steps: retransmit, stop, skip, etc. For example, the following steps are carried out: for the public customer accounting type transaction, the transaction can be done again when the transaction results are inconsistent; the method comprises the following steps that personal client accounting type transactions, such as deposit, are inconsistent in transaction results, an original production core business system is successful, a newly-built system/production standby system (namely a target system) to be evaluated fails, the situation needs to be suspended, and after the problem is solved, the personal client is restarted until the new system/production standby system fails, so that failure caused by insufficient balance in subsequent withdrawal of the personal client is avoided; and the query transaction can be directly skipped even if the results are inconsistent because the influence is not great.
As an implementation mode, a time slice parameter T is set in the sending module, and all transactions are divided into n batches at time intervals of T and sent in batches from morning to evening according to time;
and when the transaction data of each time slice batch is processed, the transaction data are transmitted in parallel, and the transmission sequence is sequenced and forwarded according to the original receiving time stamp of the transaction.
As one embodiment, the preprocessing includes key field preprocessing and message conversion, wherein,
preprocessing a key field: preprocessing a key field to ensure that a final transaction result is consistent with a production core service system, wherein the key field is important service data generated when the production core service system completes transaction;
message conversion: and converting the message format according to the transaction application interface specification of the newly-built system/the production standby system to be evaluated.
As an implementation manner, the system for performing business system reimbursement/evaluation across databases further comprises an operation and maintenance module: and performing performance analysis on the database of the newly built system/the production standby system to be evaluated, wherein the performance analysis comprises the time consumption of processing a single SQL statement used in the business transaction and the time consumption of the whole business transaction.
Referring to fig. 4, after a business occurs, data acquisition and transaction scheduling are performed by a business system tracking/evaluation system across a database, a real scene of a production environment at that time is simulated, transactions are regrouped according to organizations, tellers and the like, and the transactions are concurrently initiated to a newly-built system/production standby system.
Example 1: in the evaluation mode, a certain bank original production core service system normally operates, a newly-built system uses a new certain country production distributed database, and the cross-database transaction/evaluation system is used for performing service system account tracking/evaluation, so that all core real services are operated in the newly-built system, and the core real services are checked with the operation result of the original production core service system every day, thereby achieving continuous operation and achieving the same result with 99.999% of the original core service system.
The embodiment of the invention reads the service message information from the production core service system, converts the service message information into the service message information of a new system, then performs sending time sequence control according to the occurrence time of the original service message, adopts time slice control to synchronously send or asynchronously send the time sequence control information to the new system at real time, and checks the returned result information with the result information returned by the production core service system. In addition to the online service, the embodiment of the invention can synchronously operate the online batch service and the daily and final batch service. After the business is completed every day, the cross-database business system tracking/evaluation system of the embodiment of the invention can also be used for verifying and verifying the business data between the newly-built system and the production core business system, and is used for evaluating whether the business processing logic of the new core business is correct or not and whether the data processing of the database is correct or not.
When the embodiment of the invention is used for carrying out on-line service transaction forwarding, due to the high concurrency of the core service and the high correlation with the time sequence, the platform adopts the time slice to control the sending of the service message for full scene simulation and performance test, analyzes the service type, the transaction teller and the like in the same time slice, ensures the sequence of the service sent to a newly-built system, carries out the next time slice processing after the time slice service is processed, and also ensures the synchronization of the service in the same time slice. The size of the time slice is controlled by parameters, and the actual operation of the time slice can be elongated or compressed; this allows control to be sent faster than the original production core service system, which allows observation of the actual service under greater pressure on the new system/database.
The embodiment of the invention can evaluate the simulation condition of the full-service scene of the core service system and the performance of the newly-built system through TPS analysis.
Example 1 illustrates: as shown in fig. 5, in the embodiment of the present invention, after forwarding a 24-hour service of the production core service system, the new system and the production core service system show that the TPS (transaction amount per second) line graphs are basically consistent, which indicates that the processing capabilities of the new system and the database are not lower than the capability of the existing production core service system. (the delay on the time axis of the new system curve is due to the delay required by the data acquisition mechanism.)
Example 2 illustrates: as shown in fig. 6, after forwarding a 24-hour service of the production core service system, the embodiment of the present invention analyzes that TPS (transaction amount per second) broken line graphs expressed by the newly built system and the production core service system are inconsistent during a peak time of the service occurrence, and the newly built system is lower than the production core service system, which indicates that peak processing capabilities of the newly built system and the database are lower than the capability of the existing production core service system.
The embodiment of the invention can verify the online service processing accuracy of the newly-built system by analyzing the online service result, and the analysis condition is shown in table 1:
TABLE 1
The account tracking/evaluation system of the embodiment of the invention can verify the accuracy of the service data of the newly-built system through the service data verification performed after the end of the day, and a verification content list is shown in table 2 as follows:
TABLE 2
After the construction is completed, after the new database of the newly-built system is tested and matured by running for a period of time, the production core service system and the newly-built system can realize online parallel switching operation, namely, a double-system double-database parallel scheme is realized by using the account tracking/evaluation system of the embodiment of the invention.
Example 2: and in the mode of tracking accounts, a certain bank newly builds a production standby system, uses foreign databases, synchronously and parallelly uses the foreign databases, and can switch between the two databases after running for a period of time and being stable.
The account-following mode of the account-following/evaluation system of the embodiment of the invention is a deeper application of the evaluation mode, and in the mode, an original evaluated system which is butted by the account-following/evaluation system is also used as a part of production, becomes a production standby system and runs in parallel with a main system. In daily operation, the requirements of the tracking/evaluation system on the scene simulation of the main system can be reduced, but in principle, the consistency and accuracy of the service processing of the main system and the standby system are both guaranteed to reach 100%, and on the basis, the two systems or the database can be switched to be used according to the requirements.
Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that changes, modifications, substitutions and alterations can be made in these embodiments without departing from the principles and spirit of the invention, the scope of which is defined in the appended claims and their equivalents.
Claims (8)
1. A method for performing business system account tracking/evaluation across databases is characterized by comprising the following steps:
the collection step comprises: acquiring service message information on a production core service system to obtain message data of production transaction;
message processing steps: preprocessing the message data to obtain production data;
a scheduling step: carrying out grouping scheduling on the production data according to a strategy to prepare for the transmission of a simulation production link;
a sending step: sending the grouped production data to a newly built system/production standby system to be evaluated; in the sending process, the production link is simulated to send in a mode of multi-transaction parallel sending, synchronization control according to time slices and sending time sequence control according to timestamps;
and (3) checking: and checking the processed transaction result message returned by the newly built system/the production standby system in real time, and performing daily and final check on the processed service data.
2. The method for conducting business system reimbursement/evaluation across databases as claimed in claim 1, wherein in the sending step, a time slice parameter T is set, and all transactions are divided into n batches at intervals of T, and sent from morning to evening in time;
and when the transaction data of each time slice batch is processed, the transaction data are transmitted in parallel, and the transmission sequence is sequenced and forwarded according to the original receiving time stamp of the transaction.
3. The method for conducting business system reimbursement/evaluation across databases as in claim 1 wherein said preprocessing comprises key field preprocessing and message transformation, wherein,
preprocessing a key field: preprocessing a key field to ensure that a final transaction result is consistent with a production core service system, wherein the key field is important service data generated when the production core service system completes transaction;
message conversion: and converting the message format according to the transaction application interface specification of the newly-built system/the production standby system.
4. The method of claim 1, wherein the reconciliation/evaluation step comprises the operation and maintenance step, after the reconciliation step: and performing performance analysis on the database of the newly built system/the production standby system, wherein the performance analysis comprises the time consumption of single SQL statement processing and the time consumption of the whole business transaction used in the business transaction.
5. A system for conducting business system reimbursement/evaluation across databases, comprising:
an acquisition module: acquiring service message information on a production core service system to obtain message data of production transaction;
a message processing module: preprocessing the message data to obtain production data;
a scheduling module: carrying out grouping scheduling on the production data according to a strategy to prepare for the transmission of a simulation production link;
a sending module: sending the grouped production data to a newly built system/production standby system to be evaluated; in the sending process, the production link is simulated to send in a mode of multi-transaction parallel sending, synchronization control according to time slices and sending time sequence control according to timestamps;
a checking module: and checking the processed transaction result message returned by the newly built system/the production standby system in real time, and performing daily and final check on the processed service data.
6. The system for conducting business system reimbursement/evaluation across databases as claimed in claim 5, wherein a time slice parameter T is set in the sending module, and all transactions are divided into n batches at intervals of T and sent from morning to evening in time;
and when the transaction data of each time slice batch is processed, the transaction data are transmitted in parallel, and the transmission sequence is sequenced and forwarded according to the original receiving time stamp of the transaction.
7. The system for conducting business system reimbursement/evaluation across databases as in claim 5 wherein said preprocessing comprises key field preprocessing and message transformation, wherein,
preprocessing a key field: preprocessing a key field to ensure that a final transaction result is consistent with a production core service system, wherein the key field is important service data generated when the production core service system completes transaction;
message conversion: and converting the message format according to the transaction application interface specification of the newly-built system/the production standby system.
8. The system for conducting business system reimbursement/evaluation across a database according to claim 5, further comprising an operation and maintenance module: and performing performance analysis on the database of the newly built system/the production standby system, wherein the performance analysis comprises the time consumption of single SQL statement processing and the time consumption of the whole business transaction used in the business transaction.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110277119.3A CN112967035A (en) | 2021-03-15 | 2021-03-15 | Cross-database service system account tracking/evaluation method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110277119.3A CN112967035A (en) | 2021-03-15 | 2021-03-15 | Cross-database service system account tracking/evaluation method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112967035A true CN112967035A (en) | 2021-06-15 |
Family
ID=76279116
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110277119.3A Pending CN112967035A (en) | 2021-03-15 | 2021-03-15 | Cross-database service system account tracking/evaluation method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112967035A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113641455A (en) * | 2021-08-18 | 2021-11-12 | 北京融信致远科技有限公司 | Message conversion method and platform |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080140692A1 (en) * | 2006-12-11 | 2008-06-12 | Scott Gehring | System and method of data movement between a data source and a destination |
| CN104461863A (en) * | 2014-10-29 | 2015-03-25 | 中国建设银行股份有限公司 | Service system testing method, device and system |
| CN106844220A (en) * | 2017-03-09 | 2017-06-13 | 北京融信易安信息技术有限公司 | A kind of method of testing and system of simulation computer web application real running environment |
| CN107179995A (en) * | 2017-03-09 | 2017-09-19 | 北京融信易安信息技术有限公司 | A kind of performance test methods of application program of computer network |
| CN109165153A (en) * | 2018-09-06 | 2019-01-08 | 华泰证券股份有限公司 | A kind of performance test methods of high emulation securities business transaction class system |
| CN110647534A (en) * | 2019-09-19 | 2020-01-03 | 中国银行股份有限公司 | Cross-database platform synchronous data checking method, device and system |
-
2021
- 2021-03-15 CN CN202110277119.3A patent/CN112967035A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080140692A1 (en) * | 2006-12-11 | 2008-06-12 | Scott Gehring | System and method of data movement between a data source and a destination |
| CN104461863A (en) * | 2014-10-29 | 2015-03-25 | 中国建设银行股份有限公司 | Service system testing method, device and system |
| CN106844220A (en) * | 2017-03-09 | 2017-06-13 | 北京融信易安信息技术有限公司 | A kind of method of testing and system of simulation computer web application real running environment |
| CN107179995A (en) * | 2017-03-09 | 2017-09-19 | 北京融信易安信息技术有限公司 | A kind of performance test methods of application program of computer network |
| CN109165153A (en) * | 2018-09-06 | 2019-01-08 | 华泰证券股份有限公司 | A kind of performance test methods of high emulation securities business transaction class system |
| CN110647534A (en) * | 2019-09-19 | 2020-01-03 | 中国银行股份有限公司 | Cross-database platform synchronous data checking method, device and system |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113641455A (en) * | 2021-08-18 | 2021-11-12 | 北京融信致远科技有限公司 | Message conversion method and platform |
| CN113641455B (en) * | 2021-08-18 | 2024-04-09 | 卢知白 | Message conversion method and platform |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106294125B (en) | Core banking system data processing method | |
| CN109165153B (en) | Performance test method of high-simulation securities trade system | |
| CN106649500A (en) | Data verification method and system | |
| CN109656999A (en) | Method of data synchronization, equipment, storage medium and the device of big data quantity | |
| CN112668303A (en) | Data processing method, device, equipment and storage medium | |
| CN113360393B (en) | Continuous verification method and device based on production environment flow monitoring | |
| CN102497435A (en) | Data distributing method and device of data service | |
| CN111127009A (en) | Wrong account positioning method and device applied to self-service equipment | |
| CN110223201A (en) | One kind being based on visual intellectual property operation management system | |
| US7376708B2 (en) | Systems and methods relating to the establishment of EDI trading partner relationships | |
| CN114579654B (en) | Unified operation management method and platform system for multi-payment settlement system of bank | |
| CN112967035A (en) | Cross-database service system account tracking/evaluation method and system | |
| CN112506771A (en) | Message comparison method and device | |
| CN109617755B (en) | Acceptance method and device of access system | |
| CN113641455A (en) | Message conversion method and platform | |
| CN114168682A (en) | Data auditing method, device, equipment and storage medium | |
| CN110336791A (en) | A kind of breakpoint data transmission method, device, equipment and computer storage medium | |
| CN110502529B (en) | Data processing method, device, server and storage medium | |
| CN112419052B (en) | Transaction testing method, device, electronic equipment and readable storage medium | |
| CN112215705B (en) | International credit card clearing platform | |
| CN115481116A (en) | Data quality inspection method and device | |
| CN113469801A (en) | Method and device for determining audit result | |
| CN111625455A (en) | Program testing method, device, equipment and medium | |
| CN112596806A (en) | Data lake data loading script generation method and system | |
| CN114997977B (en) | Data processing method, device, electronic equipment and computer readable medium |
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 |