CN111444073A - Method, device and system for testing performance of financial database - Google Patents
Method, device and system for testing performance of financial database Download PDFInfo
- Publication number
- CN111444073A CN111444073A CN202010222348.0A CN202010222348A CN111444073A CN 111444073 A CN111444073 A CN 111444073A CN 202010222348 A CN202010222348 A CN 202010222348A CN 111444073 A CN111444073 A CN 111444073A
- Authority
- CN
- China
- Prior art keywords
- transaction
- database
- testing
- performance
- 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
- 238000012360 testing method Methods 0.000 title claims abstract description 80
- 238000000034 method Methods 0.000 title claims abstract description 52
- 238000012546 transfer Methods 0.000 claims description 18
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 claims description 7
- 238000010586 diagram Methods 0.000 description 7
- 238000004891 communication Methods 0.000 description 6
- 230000006870 function Effects 0.000 description 6
- 238000004590 computer program Methods 0.000 description 4
- 238000012545 processing Methods 0.000 description 4
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000002955 isolation Methods 0.000 description 2
- 238000011056 performance test Methods 0.000 description 2
- 230000002688 persistence Effects 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002085 persistent effect Effects 0.000 description 1
- 230000002441 reversible effect Effects 0.000 description 1
- 230000036962 time dependent Effects 0.000 description 1
- 230000001052 transient effect Effects 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/34—Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of user activity, e.g. usability assessment
- G06F11/3452—Performance evaluation by statistical analysis
-
- 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
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/38—Payment protocols; Details thereof
- G06Q20/389—Keeping log of transactions for guaranteeing non-repudiation of a transaction
-
- 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
-
- 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
-
- 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/06—Asset management; Financial planning or analysis
-
- 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/08—Insurance
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Development Economics (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Technology Law (AREA)
- Economics (AREA)
- General Engineering & Computer Science (AREA)
- Probability & Statistics with Applications (AREA)
- Bioinformatics & Computational Biology (AREA)
- Evolutionary Biology (AREA)
- Bioinformatics & Cheminformatics (AREA)
- Computer Hardware Design (AREA)
- Life Sciences & Earth Sciences (AREA)
- Quality & Reliability (AREA)
- Entrepreneurship & Innovation (AREA)
- Game Theory and Decision Science (AREA)
- Human Resources & Organizations (AREA)
- Operations Research (AREA)
- Debugging And Monitoring (AREA)
Abstract
The application relates to the technical field of server performance testing, and discloses a method for testing performance of a financial database. The method for testing the performance of the financial database comprises the following steps: and sequentially operating a plurality of test services of the financial institution, counting the related indexes, and outputting a statistical result. The statistical result obtained by adopting the method for testing the performance of the financial database can more accurately reflect the performance of the tested database. The application also discloses a device and a system for testing the performance of the financial database.
Description
Technical Field
The present application relates to the technical field of server performance testing, and for example, to a method, an apparatus, and a system for testing performance of a financial database.
Background
At present, the financial institution has high requirements on the performance of the database, however, the financial institution has difficulty in opening a real system to a database manufacturer for testing, and in this case, special testing tools are required for testing the database of the financial institution. The relevant organizations have introduced a series of criteria for database performance testing, such as for testing the performance of databases in the wholesale sale of goods.
In the process of implementing the embodiments of the present disclosure, it is found that at least the following problems exist in the related art:
the existing database performance test model cannot completely simulate the actual business of a financial institution, and further cannot accurately test the performance of the database.
Disclosure of Invention
The following presents a simplified summary in order to provide a basic understanding of some aspects of the disclosed embodiments. This summary is not an extensive overview nor is intended to identify key/critical elements or to delineate the scope of such embodiments but rather as a prelude to the more detailed description that is presented later.
The embodiment of the disclosure provides a method, a device and a system for testing the performance of a financial database, which are used for solving the technical problem that the existing database performance test model cannot completely simulate the actual business of a financial institution.
In some embodiments, a method for testing performance of a financial database comprises:
sequentially operating a plurality of test services of the financial institution;
carrying out statistics on related indexes;
and outputting a statistical result.
In some embodiments, an apparatus for testing performance of a financial database includes a processor and a memory storing program instructions, the processor being configured to, when executing the program instructions, perform the method for testing performance of a financial database provided by the foregoing embodiments.
In some embodiments, a system for testing the performance of a financial database includes the apparatus for testing the performance of a financial database provided by the foregoing embodiments.
The method, the device and the system for testing the performance of the financial database provided by the embodiment of the disclosure can realize the following technical effects:
most of related businesses of financial institutions relate to fund flow, and when the performance of a financial database is tested, a plurality of testing businesses of the financial institutions are operated in sequence, relevant indexes are counted, and a counting result is output. By adopting the test model, the actual business process of the financial institution is conformed, the simulated actual business of the financial institution is closer to the actual business, the statistical correlation index of the measured database is more accurate, and the statistical result can more accurately reflect the performance of the measured database.
The foregoing general description and the following description are exemplary and explanatory only and are not restrictive of the application.
Drawings
One or more embodiments are illustrated in drawings corresponding to, and not limiting to, embodiments in which elements having the same reference number designation are illustrated as similar elements and in which:
FIG. 1 is a schematic diagram of a method for testing performance of a financial database provided by an embodiment of the present disclosure;
fig. 2 is a schematic diagram of a service per operation test provided by the embodiment of the present disclosure;
fig. 3 is a schematic diagram of an apparatus for testing performance of a financial database according to an embodiment of the disclosure.
Detailed Description
So that the manner in which the features and elements of the disclosed embodiments can be understood in detail, a more particular description of the disclosed embodiments, briefly summarized above, may be had by reference to the embodiments, some of which are illustrated in the appended drawings. In the following description of the technology, for purposes of explanation, numerous details are set forth in order to provide a thorough understanding of the disclosed embodiments. However, one or more embodiments may be practiced without these details. In other instances, well-known structures and devices may be shown in simplified form in order to simplify the drawing.
The terms "first," "second," and the like in the description and in the claims, and the above-described drawings of embodiments of the present disclosure, are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It should be understood that the data so used may be interchanged under appropriate circumstances such that embodiments of the present disclosure described herein may be made. Furthermore, the terms "comprising" and "having," as well as any variations thereof, are intended to cover non-exclusive inclusions.
The term "plurality" means two or more unless otherwise specified.
In the embodiment of the present disclosure, the character "/" indicates that the preceding and following objects are in an "or" relationship. For example, A/B represents: a or B.
In the disclosed embodiments, the financial database refers to a database of a financial institution. The financial institutions include banks, securities companies, insurance companies, trust companies, fund management companies, and the like, unless otherwise specified.
Referring to fig. 1, a method for testing performance of a financial database provided by an embodiment of the present disclosure includes:
and S101, sequentially operating a plurality of test services of the financial institution.
Optionally, the testing service includes one or more of a transfer service, a deposit service, a withdrawal service, an inquiry service, and an offer service. Wherein, the transfer business, the deposit business and the withdrawal business relate to the fund flow between two accounts, and the payment brokerage business relates to the fund flow between one account and a plurality of accounts.
And S102, carrying out statistics on the related indexes.
The related indexes refer to indexes related to the measured database of the financial institution, and the related indexes can reflect the performance of the measured database.
Optionally, the correlation index is counted, including one or more of: and counting the total test time, counting the number of services completed per second, counting the total running time of each service, counting the average time consumption of each service, and counting the maximum time consumption of each service except for asset inventory. Or after all the test services are operated, before the related indexes are counted, the assets are checked. In this case, the statistics of the correlation indicators include one or more of: and counting the total test time, counting the number of services completed per second, counting the total running time of each service, counting the average time consumption of each service except for asset inventory, and counting the maximum time consumption of each service except for asset inventory.
Optionally, statistics are performed on the related data, and atomicity, consistency, isolation and durability of the measured database are measured. I.e., verifying the atomicity, consistency, isolation, and durability of the database.
And S103, outputting a statistical result.
The statistical result may reflect the performance of the database under test.
In the statistical results, the less time-dependent indices, the better the measured database performance. For example, in the case where the statistical result includes the following data: the total testing time, the total running time of each service, the average time consumption of each service or the average time consumption of each service except for asset inventory, the maximum time consumption of each service or the maximum time consumption of each service except for asset inventory are less, and the performance of the tested database is better; the less the total running time is, the better the performance of the tested database is; the less the average time consumption, the better the performance of the measured database; the less the maximum time consumption, the better the measured database performance.
In the statistical result, the larger the number of services completed per second is, the stronger the processing capability per second of the measured database is, and the better the performance is.
In the statistical result, whether the tested database is atomicity, whether the tested database is consistent, whether the tested database is isolated and whether the tested database is persistent can be reflected.
Most of related businesses of financial institutions relate to fund flow, and when the performance of a financial database is tested, a plurality of testing businesses of the financial institutions are operated in sequence, relevant indexes are counted, and a counting result is output. By adopting the test model, the actual business process of the financial institution is conformed, the simulated actual business of the financial institution is closer to the actual business, the statistical correlation index of the measured database is more accurate, and the statistical result can more accurately reflect the performance of the measured database.
In some application scenarios, the type of the test service may be configured, for example, only any one of a transfer service, a deposit service, a withdrawal service, an inquiry service, and an issuing payroll service is operated; or only operating any two of transfer business, deposit business, withdrawal business, inquiry business and payment agency business; or only operating any three of transfer business, deposit business, withdrawal business, inquiry business and payment agency business; or only operating any four of transfer business, deposit business, withdrawal business, inquiry business and payment agency business; or, running a transfer service, a deposit service, a withdrawal service, an inquiry service, and an offer service. And the running times of each test service can be configured independently, for example, 200 thousands of transfer services, 100 thousands of deposit services, 100 thousands of withdrawal services, 400 thousands of query services, 1000 surrogate payroll services and the like. Further, the number of threads running each test service may be individually configured, and the number of threads may be 1, 2, 3 … … 100 and more.
In some application scenarios, firstly, a test number is input, secondly, the configuration of a test service is read, then, a related service is tested, afterwards, asset checking is carried out, and finally, a statistical result is output.
As shown in fig. 2, each time the test service is run, the method includes:
and S201, updating the serial number.
Optionally, updating the serial number comprises: determining the network points and the serial numbers thereof for testing, locking the related records of the network points, and forbidding other programs/threads to operate the network points. In other existing database test models, a data is not locked, because in the test model of the database, the operation of locking a data is contrary to the basic idea of the existing database test model, which requires the speed of processing data and modifying data by the test database. However, in the financial field, after a serial number is updated at a website, the related records of the website are locked, so that the method for testing the financial database can simulate the actual business of the financial institution more truly, and further obtain a more accurate statistical result. Specifically, when the test service is operated each time, the account is searched to determine the website, after the current running water of the website is read, 1 is added on the basis of the current running water number, the updated running water number is obtained, and the updated running water number is locked.
In transfer business, deposit business or withdrawal business, a debit account and a credit account are determined; then determining the transaction amount; when the debit account does not exist, or the state of the debit account is abnormal, or the balance of the debit account is insufficient, recording a transaction log, and when the debit account exists and has a normal state, and the balance of the debit account is sufficient, checking whether a credit account exists and has a normal state; if not, recording the transaction log, and if so, updating the serial number. Wherein, in the transfer business, the debit account and the credit account are different; in both deposit and withdrawal transactions, the debit and credit accounts are the same.
In the inquiry service, checking whether an account exists and whether the state is normal, and if not, recording a transaction log; and if so, updating the serial number.
S202, executing relevant processes of the test service and inserting transaction records into the flow meter.
Wherein inserting a transaction record into the flow sheet comprises: in a business involving the flow of funds, recorded debit account information and credit account information are inserted into a flow sheet. The business related to fund flow comprises the following steps: services that involve the flow of funds between two accounts (e.g., transfer, withdrawal, and deposit services), and services that involve the flow of funds between an account and multiple accounts (e.g., a brokerage payroll service). For example, in a transfer transaction, account a transfers a specific amount to account B, records account a and account B in a flow meter, and records that account a debits account B by a specific amount, and that account B credits account a by a specific amount. This facilitates verification of the consistency of the database under test. Wherein, in the deposit business and the withdrawal business, the debit account and the credit account are the same.
Specifically, in the transfer service, the deposit service or the withdrawal service, the account balance and the account balance of the debit party are updated, the flow meter of the debit party is filled, and the flow meter of the debit party is filled.
In the inquiry service, the transaction details in the flow meter are inquired according to the account.
In the surcharge business, trying to read the employee account, and if the employee account cannot be successfully read and the balance of the company account is less than or equal to zero, re-acquiring the company account; if the employee account is successfully read and the status of the employee account is normal, updating the balance of the company account, filling a running list corresponding to the employee account, transferring accounts from the company account to the employee account, then trying to read the employee account, if the employee account cannot be successfully read and the balance of the company account is greater than zero, updating the balance of the company account, filling the running list corresponding to the company account, and then recording a transaction log.
And S203, recording a transaction log.
Optionally, logging the transaction comprises: inserting a transaction log into a local database; and the transaction log inserted into the local database is the same as the transaction log inserted into the tested database.
Through the steps, the operation of the financial institution in handling related services can be simulated more truly, the related indexes of the tested database can be counted more accurately, and then the statistical result which can reflect the performance of the tested database more accurately is output.
Optionally, the counting the relevant indexes includes: and verifying the consistency of the tested database. Before running a test service, verifying the consistency of a primary tested database; after the test service is operated, the consistency of the once tested database is verified.
Optionally, the measured database has consistency when one or more of the following are satisfied: after the test is finished, the total amount of the accounts is equal to the total amount of the accounts before the test plus the deposit and withdrawal difference; the sum of the lending parties in the flow meter is consistent; the serial number of the network point corresponds to the number of the transaction logs; the transaction quantity in the flow meter of the network point corresponds to the transaction log quantity; wherein each time a fund transaction occurs, two transaction records are inserted into the water flow table. For example, if one of the three conditions is met, the tested databases have consistency, otherwise, the tested databases do not have consistency; or, if the two conditions are met, the tested databases have consistency, otherwise, the tested databases do not have consistency; or, if the three conditions are simultaneously met, the tested data base has consistency, otherwise, the tested data does not have consistency.
Optionally, the serial number of the website corresponds to the number of the transaction logs, and the method includes: the change of the transaction log quantity and the serial number is equal, for example, the change of the transaction log quantity and the serial number in the service where the loan relation occurs is equal, and the change of the transaction log quantity and the serial number in the payment service is equal, wherein the service where the loan relation occurs includes a transfer service, a deposit service and a withdrawal service;
optionally, the transaction amount in the flow meter of the network point corresponds to the transaction log amount, and the method includes: in the business of generating loan relation, the transaction quantity in the flow meter is twice of the transaction log quantity, and in the business of generating salary, the transaction quantity in the flow meter is the sum of the transaction log quantity and the total number of employees; the transaction quantity in the flow meter of the branch refers to the quantity of the transaction records inserted after the business is successfully executed, for example, the quantity of the transaction records inserted in the flow meter after the transfer is successfully executed, the quantity of the transaction records inserted in the flow meter after the deposit/withdrawal is successfully executed, and the quantity of the transaction records inserted in the flow meter after the payment is successfully issued.
The consistency of the tested database can be verified through the steps.
Optionally, the statistics of the relevant indexes further includes verifying the persistence of the tested database. For example, the number of the transaction logs in the local database is read, and the number of the transaction logs in the tested database is read, if the two numbers are the same, the tested database has consistency, otherwise, the tested database does not have consistency. In this way, the persistence of the database under test can be verified.
An embodiment of the present disclosure provides an apparatus for testing performance of a financial database, the apparatus including a processor and a memory storing program instructions, the processor being configured to perform the following steps when executing the program instructions:
sequentially operating a plurality of test services of the financial institution;
carrying out statistics on related indexes;
and outputting a statistical result.
Referring to fig. 3, an apparatus for testing performance of a financial database according to an embodiment of the present disclosure includes:
a processor (processor)31 and a memory (memory)32, and may further include a Communication Interface (Communication Interface)33 and a bus 34. The processor 31, the communication interface 33, and the memory 32 may communicate with each other through the bus 34. The communication interface 33 may be used for information transfer. The processor 31 may invoke logic instructions in the memory 32 to perform the method for testing the performance of a financial database provided by the foregoing embodiments.
Furthermore, the logic instructions in the memory 32 may be implemented in software functional units and stored in a computer readable storage medium when sold or used as a stand-alone product.
The memory 32 is a computer readable storage medium, and can be used for storing software programs, computer executable programs, such as program instructions/modules corresponding to the methods in the embodiments of the present disclosure. The processor 31 executes the functional application and data processing by executing the software program, instructions and modules stored in the memory 32, that is, implements the method in the above-described method embodiment.
The memory 32 may include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function; the storage data area may store data created according to the use of the terminal device, and the like. Further, the memory 32 may include high speed random access memory and may also include non-volatile memory.
The embodiment of the disclosure provides a system for testing the performance of a financial database, which comprises the device for testing the performance of the financial database provided by the previous embodiment.
The disclosed embodiments provide a computer-readable storage medium storing computer-executable instructions configured to perform the method for testing performance of a financial database provided by the foregoing embodiments.
The disclosed embodiments provide a computer program product comprising a computer program stored on a computer readable storage medium, the computer program comprising program instructions which, when executed by a computer, cause the computer to perform the method for testing the performance of a financial database as provided by the preceding embodiments.
The computer-readable storage medium described above may be a transitory computer-readable storage medium or a non-transitory computer-readable storage medium.
The technical solution of the embodiments of the present disclosure may be embodied in the form of a software product, where the computer software product is stored in a storage medium and includes one or more instructions to enable a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method in the embodiments of the present disclosure. And the aforementioned storage medium may be a non-transitory storage medium comprising: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes, and may also be a transient storage medium.
The above description and drawings sufficiently illustrate embodiments of the disclosure to enable those skilled in the art to practice them. Other embodiments may incorporate structural, logical, electrical, process, and other changes. The examples merely typify possible variations. Individual components and functions are optional unless explicitly required, and the sequence of operations may vary. Portions and features of some embodiments may be included in or substituted for those of others. Furthermore, the words used in the specification are words of description only and are not intended to limit the claims. As used in the description of the embodiments and the claims, the singular forms "a", "an" and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise. Similarly, the term "and/or" as used in this application is meant to encompass any and all possible combinations of one or more of the associated listed. Furthermore, the terms "comprises" and/or "comprising," when used in this application, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method or device comprising the element. In this document, each embodiment may be described with emphasis on differences from other embodiments, and the same and similar parts between the respective embodiments may be referred to each other. For methods, products, etc. of the embodiment disclosures, reference may be made to the description of the method section for relevance if it corresponds to the method section of the embodiment disclosure.
Those of skill in the art would appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware or combinations of computer software and electronic hardware. Whether such functionality is implemented as hardware or software may depend upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the disclosed embodiments. It can be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working processes of the system, the apparatus and the unit described above may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the embodiments disclosed herein, the disclosed methods, products (including but not limited to devices, apparatuses, etc.) may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, a division of a unit may be merely a division of a logical function, and an actual implementation may have another division, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form. Units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to implement the present embodiment. In addition, functional units in the embodiments of the present disclosure may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit.
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). In some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. Each block of the block diagrams and/or flowchart illustrations, and combinations of blocks in the block diagrams and/or flowchart illustrations, can be implemented by special purpose hardware-based systems that perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
Claims (14)
1. A method for testing the performance of a financial database, comprising:
sequentially operating a plurality of test services of the financial institution;
carrying out statistics on related indexes;
and outputting a statistical result.
2. The method of claim 1, wherein each time the test service is run, comprising:
updating the serial number;
executing the relevant flow of the test service and inserting the transaction record into the flow meter;
and recording a transaction log.
3. The method of claim 2, wherein updating the serial number comprises:
determining the mesh points and the serial numbers thereof for testing;
and locking the related records of the mesh point, and prohibiting other programs/threads from operating the mesh point.
4. The method of claim 2, wherein inserting transaction records into the flow sheet comprises:
in the business related to fund flow, debit account information and credit account information are inserted into the water flow table.
5. The method of claim 4 wherein the debit account and the credit account are the same in the deposit transaction and the withdrawal transaction.
6. The method of claim 3, wherein recording a transaction log comprises:
inserting a transaction log into a local database; and the transaction log inserted into the local database is the same as the transaction log inserted into the tested database.
7. The method of claim 1, wherein the counting the correlation indicators comprises:
and verifying the consistency of the tested database.
8. The method of claim 7, wherein the measured database is consistent when one or more of the following are satisfied:
after the test is finished, the total amount of the accounts is equal to the total amount of the accounts before the test plus the deposit and withdrawal difference;
the sum of the lending parties in the flow meter is consistent;
the serial number of the network point corresponds to the number of the transaction logs;
the transaction quantity in the flow meter of the network point corresponds to the transaction log quantity.
9. The method of claim 8, wherein the serial number of the network point corresponds to the number of transaction logs, comprising: the change of the transaction log quantity and the serial number is equal;
the transaction quantity in the flow water meter of the network point corresponds to the transaction log quantity, and the method comprises the following steps: in the business where the loan relationship occurs, the transaction amount in the flow chart is twice as much as the transaction log amount; in the generation wage service, the transaction quantity in the flow meter is the sum of the transaction log quantity and the total number of the staff.
10. The method of claim 1, wherein before performing statistics on the correlation indicators, further comprising:
and performing asset inventory.
11. The method of claim 9, wherein the statistics of correlation indicators include one or more of:
counting the total testing time;
counting the number of services completed per second;
counting the total running time of each service;
counting the average consumed time of each service except for the inventory of the assets;
and counting the maximum time consumption of each service except for the inventory of the assets.
12. The method of any one of claims 1 to 11, wherein the test transaction comprises one or more of a transfer transaction, a deposit transaction, a withdrawal transaction, an inquiry transaction and an initiated payroll transaction.
13. An apparatus for testing the performance of a financial database, comprising a processor and a memory having stored thereon program instructions, wherein the processor is configured to perform a method for testing the performance of a financial database as claimed in any one of claims 1 to 12 when executing the program instructions.
14. A system for testing the performance of a financial database, comprising the apparatus for testing the performance of a financial database according to claim 13.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010222348.0A CN111444073A (en) | 2020-03-26 | 2020-03-26 | Method, device and system for testing performance of financial database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010222348.0A CN111444073A (en) | 2020-03-26 | 2020-03-26 | Method, device and system for testing performance of financial database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111444073A true CN111444073A (en) | 2020-07-24 |
Family
ID=71648042
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010222348.0A Pending CN111444073A (en) | 2020-03-26 | 2020-03-26 | Method, device and system for testing performance of financial database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111444073A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112882883A (en) * | 2021-02-25 | 2021-06-01 | 中国工商银行股份有限公司 | Shutdown test method and apparatus, electronic device, and computer-readable storage medium |
| CN113064837A (en) * | 2021-05-07 | 2021-07-02 | 中国工商银行股份有限公司 | Database benchmark test method and device based on transaction scene |
| CN113159967A (en) * | 2021-05-07 | 2021-07-23 | 中国工商银行股份有限公司 | Data processing method and device based on financial core online transaction scene |
| CN113342680A (en) * | 2021-06-29 | 2021-09-03 | 中国农业银行股份有限公司 | Asynchronous transaction performance testing method and system |
| CN113468052A (en) * | 2021-06-30 | 2021-10-01 | 建信金融科技有限责任公司 | Dynamic baffle testing method and device |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO1999008242A1 (en) * | 1997-08-05 | 1999-02-18 | British Telecommunications Public Limited Company | Providing a transaction record |
| CN1648874A (en) * | 2005-03-18 | 2005-08-03 | 中国工商银行 | Bank host operation pressure test system |
| CN101625686A (en) * | 2008-07-08 | 2010-01-13 | 阿里巴巴集团控股有限公司 | Method and system for monitoring data consistency between plurality of databases |
| CN102158373A (en) * | 2011-05-12 | 2011-08-17 | 哈尔滨工业大学 | Performance evaluation system of high-end server for intermediary business of bank |
| CN103810196A (en) * | 2012-11-09 | 2014-05-21 | 阿里巴巴集团控股有限公司 | Method for testing performance of database on basis of business model |
| CN105183794A (en) * | 2015-08-24 | 2015-12-23 | 用友网络科技股份有限公司 | Business serial number generation apparatus and method |
| CN106095688A (en) * | 2016-06-23 | 2016-11-09 | 微梦创科网络科技（中国）有限公司 | A kind of software performance testing method and device |
| CN106407085A (en) * | 2016-11-24 | 2017-02-15 | 中国银行股份有限公司 | Performance monitoring method and apparatus |
| CN110428325A (en) * | 2019-07-31 | 2019-11-08 | 中国工商银行股份有限公司 | Transaction tracking and device |
-
2020
- 2020-03-26 CN CN202010222348.0A patent/CN111444073A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO1999008242A1 (en) * | 1997-08-05 | 1999-02-18 | British Telecommunications Public Limited Company | Providing a transaction record |
| CN1648874A (en) * | 2005-03-18 | 2005-08-03 | 中国工商银行 | Bank host operation pressure test system |
| CN101625686A (en) * | 2008-07-08 | 2010-01-13 | 阿里巴巴集团控股有限公司 | Method and system for monitoring data consistency between plurality of databases |
| CN102158373A (en) * | 2011-05-12 | 2011-08-17 | 哈尔滨工业大学 | Performance evaluation system of high-end server for intermediary business of bank |
| CN103810196A (en) * | 2012-11-09 | 2014-05-21 | 阿里巴巴集团控股有限公司 | Method for testing performance of database on basis of business model |
| CN105183794A (en) * | 2015-08-24 | 2015-12-23 | 用友网络科技股份有限公司 | Business serial number generation apparatus and method |
| CN106095688A (en) * | 2016-06-23 | 2016-11-09 | 微梦创科网络科技（中国）有限公司 | A kind of software performance testing method and device |
| CN106407085A (en) * | 2016-11-24 | 2017-02-15 | 中国银行股份有限公司 | Performance monitoring method and apparatus |
| CN110428325A (en) * | 2019-07-31 | 2019-11-08 | 中国工商银行股份有限公司 | Transaction tracking and device |
Non-Patent Citations (2)
| Title |
|---|
| 何宗耀等: "数据库原理及应用", 30 September 2014, 中国矿业大学出版社, pages: 142 * |
| 高艺;赵成;张毓森;: "基于TPC-C基准的ACID验证工具的实现", 军事通信技术, no. 02, pages 92 - 95 * |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112882883A (en) * | 2021-02-25 | 2021-06-01 | 中国工商银行股份有限公司 | Shutdown test method and apparatus, electronic device, and computer-readable storage medium |
| CN112882883B (en) * | 2021-02-25 | 2024-06-21 | 中国工商银行股份有限公司 | Shutdown test method and device, electronic equipment and computer readable storage medium |
| CN113064837A (en) * | 2021-05-07 | 2021-07-02 | 中国工商银行股份有限公司 | Database benchmark test method and device based on transaction scene |
| CN113159967A (en) * | 2021-05-07 | 2021-07-23 | 中国工商银行股份有限公司 | Data processing method and device based on financial core online transaction scene |
| CN113064837B (en) * | 2021-05-07 | 2024-04-09 | 中国工商银行股份有限公司 | Database benchmark test method and device based on transaction scene |
| CN113342680A (en) * | 2021-06-29 | 2021-09-03 | 中国农业银行股份有限公司 | Asynchronous transaction performance testing method and system |
| CN113468052A (en) * | 2021-06-30 | 2021-10-01 | 建信金融科技有限责任公司 | Dynamic baffle testing method and device |
| CN113468052B (en) * | 2021-06-30 | 2022-07-26 | 建信金融科技有限责任公司 | Dynamic baffle testing method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11961067B2 (en) | Splittable security token | |
| CN111444073A (en) | Method, device and system for testing performance of financial database | |
| US5390113A (en) | Method and electronic apparatus for performing bookkeeping | |
| CN106294125B (en) | Core banking system data processing method | |
| US8522202B2 (en) | System and method for managing computer environment setup requests | |
| US20200051067A1 (en) | Self-enforcing security token implementing smart-contract-based compliance rules consulting smart-contract-based global registry of investors | |
| WO2006124135A2 (en) | Centralized payment processing system | |
| CN108256113A (en) | The method for digging and device of data genetic connection | |
| CN113205402A (en) | Account checking method and device, electronic equipment and computer readable medium | |
| CN115409590A (en) | Unified account checking method, device, equipment and storage medium | |
| CN114219321A (en) | Information system production preparation method and device | |
| Černius et al. | Financial information and management decisions: Impact of accounting policy on financial indicators of the firm | |
| CN117435630B (en) | Rule preposition-based data verification method and system | |
| US20060143232A1 (en) | Computer-implemented method for data management | |
| CN110020795A (en) | The method and device of risk control is provided for mutual fund earnings | |
| US20220188279A1 (en) | Systems and methods for creating and tracking implementation of a consolidation of data during a migration from one or more source systems to one target system | |
| US20060129594A1 (en) | Computer-implemented method for management of electronic data | |
| US7716092B2 (en) | Use of separate rib ledgers in a computerized enterprise resource planning system | |
| CN112597165A (en) | Supervision data quality verification method and device, electronic equipment and storage medium | |
| CN117194242A (en) | Log playback method and device for transaction system, electronic equipment and storage medium | |
| CN113034275A (en) | Management system and method based on block chain network and terminal equipment | |
| CN111563082B (en) | Report generation method and device | |
| CN113159968A (en) | Data processing method and device based on financial core batch transaction scene | |
| CN113469801A (en) | Method and device for determining audit result | |
| CN111178826A (en) | Consumption financial risk management method based on block chain and cloud platform |
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 |