CN113010443A - Database test data generation method and device based on financial core transaction scene - Google Patents
Database test data generation method and device based on financial core transaction scene Download PDFInfo
- Publication number
- CN113010443A CN113010443A CN202110493712.1A CN202110493712A CN113010443A CN 113010443 A CN113010443 A CN 113010443A CN 202110493712 A CN202110493712 A CN 202110493712A CN 113010443 A CN113010443 A CN 113010443A
- Authority
- CN
- China
- Prior art keywords
- account
- transaction
- information
- deposit
- executive
- 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.)
- Granted
Links
- 238000012360 testing method Methods 0.000 title claims abstract description 67
- 238000000034 method Methods 0.000 title claims abstract description 59
- 238000012545 processing Methods 0.000 claims abstract description 90
- 230000007246 mechanism Effects 0.000 claims description 26
- 230000008520 organization Effects 0.000 claims description 20
- 238000003860 storage Methods 0.000 claims description 18
- 238000004590 computer program Methods 0.000 claims description 16
- 230000008569 process Effects 0.000 claims description 16
- 230000006870 function Effects 0.000 description 14
- 238000004891 communication Methods 0.000 description 12
- 238000010586 diagram Methods 0.000 description 11
- 238000009826 distribution Methods 0.000 description 7
- 239000000872 buffer Substances 0.000 description 4
- 238000007667 floating Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000002159 abnormal effect Effects 0.000 description 2
- 230000000977 initiatory effect Effects 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 238000004088 simulation Methods 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000009662 stress testing Methods 0.000 description 1
- 238000006467 substitution reaction Methods 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/36—Preventing errors by testing or debugging software
- G06F11/3668—Software testing
- G06F11/3672—Test management
- G06F11/3684—Test management for test design, e.g. generating new test cases
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- 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
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Software Systems (AREA)
- Economics (AREA)
- General Business, Economics & Management (AREA)
- Computer Hardware Design (AREA)
- Quality & Reliability (AREA)
- Technology Law (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Development Economics (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention provides a database test data generation method and device based on a financial core transaction scene, which can be used in the financial field or other fields. The method comprises the following steps: each thread in the at least two threads obtains a plurality of accounts through account opening transaction processing; storing the initial account opening information of each account into an account information table, an account balance table, an account serial number table and a deposit protocol table which respectively correspond to the initial account opening information; each thread in the at least two threads performs account deposit transaction processing on at least one account in the plurality of accounts, and the amount information processed by each account deposit transaction is stored in an account balance table and an account detail table corresponding to the account processed by the account deposit transaction; and determining the data in the account information table, the account serial number table, the deposit agreement table, the account balance table and the account detail table of all the accounts as the test data of the batch transaction scene database. The method and the device can improve the accuracy of the generated data, and further improve the accuracy of the database test based on the generated data.
Description
Technical Field
The invention relates to the technical field of database testing, in particular to a method and a device for generating database testing data based on a financial core transaction scene.
Background
In the field of database benchmark, it is necessary to simulate traffic load to perform transaction processing on data stored in a database so as to evaluate the performance and capacity that can be supported by a database product. For example, simulation is required to generate a data set equivalent to the production environment for performance stress testing and simulation commissioning testing of the application system. Data sets meeting certain quantity and quality conditions need to be generated for functional verification and benchmark performance testing of database products.
Data stored in an existing database generally adopts a random number making mode, and common database benchmark testing tools such as Sysbench, BanchmarkSQL and the like all adopt the random number making mode in a test data generation stage.
However, data obtained by random number generation is completely random in distribution, and cannot reflect the association relationship between data and the characteristics of financial account data. For example, the data of the financial system requires that the amount of money of various transactions of the same account in different data tables, such as an account balance table, an account detail table, a service registration table, and the like, should satisfy the reconciliation balance relationship, and the time stamps and the service numbers of the same transaction in different data tables are kept consistent.
Disclosure of Invention
Aiming at the problems in the prior art, the invention provides a database test data generation method and device based on a financial core transaction scene, which specifically comprises the following technical scheme:
in a first aspect, the present invention provides a method for generating database test data based on a financial core transaction scenario, including:
each thread in the at least two threads obtains a plurality of accounts through account opening transaction processing; storing the initial account opening information of each account into an account information table, an account balance table, an account serial number table and a deposit protocol table which respectively correspond to the initial account opening information;
each thread in the at least two threads performs account deposit transaction processing on at least one account in the plurality of accounts, and the amount information processed by each account deposit transaction is stored in an account balance table and an account detail table corresponding to the account processed by the account deposit transaction;
and determining the data in the account information table, the account serial number table, the deposit agreement table, the account balance table and the account detail table of all the accounts as the test data of the batch transaction scene database.
Wherein each thread of the at least two threads obtains a plurality of accounts through account opening transaction processing; storing the initial account opening information of each account into an account information table, an account balance table, an account serial number table and a deposit protocol table which respectively correspond to the initial account opening information, wherein the method comprises the following steps:
determining the transaction date of the account opening transaction processing and generating an account number corresponding to the account based on a preset serial number table;
acquiring a service unique number corresponding to the transaction processing of the account opening from a global unique ID server of a transaction channel;
acquiring the number of an executive teller and the number of an executive mechanism corresponding to each thread;
storing the amount, currency, transaction date, unique service number, executive counter number and executive mechanism number of the transaction processing of the account opening into an account information table, an account balance table, an account sequence number table and a deposit protocol table based on the account number;
wherein the initial account opening information includes: account number, amount, currency, transaction date, unique serial number of service, serial number of executive counter and serial number of executive organization.
After obtaining the number of the executive teller and the number of the executive organization corresponding to each thread, the method further comprises the following steps:
checking the initial account opening information; and after the checking process is passed, storing the amount, currency, transaction date, unique service number, executive counter number and executive mechanism number of the transaction process of the account opening into an account information table, an account balance table, an account sequence number table and a deposit agreement table based on the account number.
Wherein, the checking the initial account opening information includes:
checking whether the teller corresponding to the executive teller number and the institution corresponding to the executive institution number exist or not;
checking whether the currency supports;
and checking whether the account opening transaction processing is in a business protection mode or not.
Wherein, each thread of the at least two threads performs account deposit transaction processing on at least one account of a plurality of accounts, and the amount information processed by each account deposit transaction is stored in an account balance table and an account detail table corresponding to the account processed by the account deposit transaction processing, and the method comprises the following steps:
determining the transaction date of the account deposit transaction processing and acquiring a service unique number corresponding to the account opening transaction processing from a global unique ID server of a transaction channel;
acquiring the number of an executive teller, the number of an executive organization and the service information of account deposit transaction corresponding to each thread;
storing the transaction date, the account unique number teller number, the execution mechanism number and the service information of the account deposit transaction in an account balance table and an account detail table based on the account number and registering the account information detail table;
the service information comprises a service occurrence account number, a service occurrence currency and a service processing amount.
In a second aspect, the present invention provides a database test data generating apparatus based on financial core transaction scenarios, including:
the account opening module is used for processing each thread of at least two threads through account opening transactions to obtain a plurality of accounts; storing the initial account opening information of each account into an account information table, an account balance table, an account serial number table and a deposit protocol table which respectively correspond to the initial account opening information;
the account transaction module is used for performing account deposit transaction processing on at least one account in the plurality of accounts by each thread in at least two threads, and storing the amount information processed by each account deposit transaction into an account balance table and an account detail table corresponding to the account processed by the account deposit transaction;
and the test data module is used for determining that the data in the account information table, the account serial number table, the deposit agreement table, the account balance table and the account detail table of all the accounts are the test data of the batch transaction scene database.
Wherein the account opening module comprises:
the first determining unit is used for determining the transaction date of the account opening transaction processing and generating an account number corresponding to the account based on a preset serial number table;
the acquisition unit is used for acquiring a service unique number corresponding to the transaction processing of the account opening from a global unique ID server of a transaction channel;
the first acquisition unit is used for acquiring the number of an executive teller and the number of an executive mechanism corresponding to each thread;
the first storage unit is used for storing the amount, currency, transaction date, unique service number, executive counter number and executive mechanism number of the transaction processing of the account opening based on the account number into an account information table, an account balance table, an account sequence number table and a deposit protocol table;
wherein the initial account opening information includes: account number, amount, currency, transaction date, unique serial number of service, serial number of executive counter and serial number of executive organization.
Wherein the account transaction module comprises:
the second determining unit is used for determining the transaction date of the account deposit transaction processing and acquiring a service unique number corresponding to the account opening transaction processing from a global unique ID server of a transaction channel;
the second acquisition unit is used for acquiring the number of an executive teller, the number of an executive organization and the service information of account deposit transaction corresponding to each thread;
the second storage unit is used for storing the transaction date of the account deposit transaction processing, the teller number with the unique service number, the number of an execution mechanism and the service information of the account deposit transaction into an account balance table and an account detail table and registering the account information detail table based on the account number;
the service information comprises a service occurrence account number, a service occurrence currency and a service processing amount.
In a third aspect, the present invention provides an electronic device, comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the steps of the method for generating database test data based on financial core transaction scenarios when executing the program.
In a fourth aspect, the present invention provides a computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements the steps of the method for generating database test data based on financial core transaction scenarios.
According to the technical scheme, the invention provides the database test data generation method and device based on the financial core transaction scene, and a plurality of accounts are obtained through account opening transaction processing of each of at least two threads; storing the initial account opening information of each account into an account information table, an account balance table, an account serial number table and a deposit protocol table which respectively correspond to the initial account opening information; each thread in the at least two threads performs account deposit transaction processing on at least one account in the plurality of accounts, and the amount information processed by each account deposit transaction is stored in an account balance table and an account detail table corresponding to the account processed by the account deposit transaction; and determining the data in the account information table, the account serial number table, the deposit agreement table, the account balance table and the account detail table of all the accounts as the test data of the batch transaction scene database. The method can meet the relevance requirements of financial data on account balance and the like, the information such as the amount, the number, the date and the like stored in different data tables in the same account and the same transaction can keep consistency, the generated data better accords with the characteristics of the financial data in the aspects of data distribution, data relevance and the like, the accuracy of the generated data is improved, and the accuracy of database testing based on the generated data is further improved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without creative efforts.
Fig. 1 is a flowchart illustrating a database test data generation method based on a financial core transaction scenario according to an embodiment of the present invention.
Fig. 2 is a schematic flowchart of step S101 in the database test data generation method based on the financial core transaction scenario according to the embodiment of the present invention.
Fig. 3 is a flowchart illustrating step S102 of the database test data generation method based on the financial core transaction scenario according to an embodiment of the present invention.
Fig. 4 is a schematic structural diagram of a database test data generation apparatus based on a financial core transaction scenario according to an embodiment of the present invention.
Fig. 5 is a schematic structural diagram of an electronic device in an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The invention provides an embodiment of a database test data generation method based on a financial core transaction scenario, which specifically comprises the following contents in reference to fig. 1:
s101: each thread in the at least two threads obtains a plurality of accounts through account opening transaction processing; storing the initial account opening information of each account into an account information table, an account balance table, an account serial number table and a deposit protocol table which respectively correspond to the initial account opening information;
s102: each thread in the at least two threads performs account deposit transaction processing on at least one account in the plurality of accounts, and the amount information processed by each account deposit transaction is stored in an account balance table and an account detail table corresponding to the account processed by the account deposit transaction;
s103: and determining the data in the account information table, the account serial number table, the deposit agreement table, the account balance table and the account detail table of all the accounts as the test data of the batch transaction scene database.
In this embodiment, initial parameters are configured, and the initial parameters include the number of concurrent threads, the total number of accounts, the number of tellers, and the number of service agencies. After configuring the initial parameters, initializing a relevant system table, comprising: sequence number meter, organization meter, teller meter, currency meter.
A plurality of threads (at least two threads) are started to simulate a transaction teller to generate initial account opening information of accounts with the total number of accounts through 'account opening' transaction, and transaction data are inserted into an account information table, an account serial number table, a deposit protocol table and other related data tables in the process.
A plurality of threads are started to simulate a transaction teller to generate initial amount information of accounts with the total amount of the accounts through 'account deposit' transaction, and the process inserts and updates transaction data into an account balance table, an account detail table and other related data tables.
Thus, the required data is generated in the relevant data tables.
Further, for convenience of expression, the following variable names are used to represent parameters of batch transactions in the present embodiment:
thus, the required data is generated in the relevant data tables.
Initializing a correlation system table comprising:
(1) initializing a sequence number table:
the sequence number table is used to assign and continue the various sequence numbers used by the current system. The following SQL statement is executed to insert the initialization value:
wherein, the serial number type value 1 represents the serial number of the account; the function get system date represents taking the system current timestamp.
(2) Initializing a mechanism table:
for organization number i, which takes values from 1 to i _ instruction _ num, the following SQL statement is executed in a loop:
(3) initializing a teller table:
for teller number i, which takes values from 0 to i _ tell _ num, the following SQL statement is executed in a loop:
wherein: ,// denotes floating point divide,// denotes integer divide rounded down, and math. ceil () function denotes integer rounded up. This assigns to each teller an associated institution, i.e. i _ tell _ num tellers to i _ instruction _ num service institutions.
(4) Initializing currency tables:
for each currency supported by the system, relevant information is inserted into the currency table. Example SQL is as follows:
according to the technical scheme, the invention provides the database test data generation method based on the financial core transaction scene, and a plurality of accounts are obtained through account opening transaction processing of each of at least two threads; storing the initial account opening information of each account into an account information table, an account balance table, an account serial number table and a deposit protocol table which respectively correspond to the initial account opening information; each thread in the at least two threads performs account deposit transaction processing on at least one account in the plurality of accounts, and the amount information processed by each account deposit transaction is stored in an account balance table and an account detail table corresponding to the account processed by the account deposit transaction; and determining the data in the account information table, the account serial number table, the deposit agreement table, the account balance table and the account detail table of all the accounts as the test data of the batch transaction scene database. The method can meet the relevance requirements of financial data on account balance and the like, the information such as the amount, the number, the date and the like stored in different data tables in the same account and the same transaction can keep consistency, the generated data better accords with the characteristics of the financial data in the aspects of data distribution, data relevance and the like, the accuracy of the generated data is improved, and the accuracy of database testing based on the generated data is further improved.
In an embodiment of the present invention, referring to fig. 2, a specific implementation manner of step S101 in the foregoing example is provided, which includes the following steps:
s1011: determining the transaction date of the account opening transaction processing and generating an account number corresponding to the account based on a preset serial number table;
in this step, the transaction system time is obtained as the transaction date v _ workdate of the account opening transaction process. And generating an account number corresponding to the account from a serial number table of the transaction system. As shown in the following SQL statement:
it should be noted that, the sequence number in the system sequence number table may be increased in a jump manner when executing the UPDATE statement once, in order to avoid the transaction system sequence number table becoming a hot spot, one thread may take multiple sequence numbers at a time (as in the above example, 100 numbers are taken at a time in SQL), and the sequence numbers are allocated for use in the thread as required.
S1012, acquiring a service unique number corresponding to the current account opening transaction processing from a global unique ID server of a transaction channel;
in this step, the service unique number v _ seq is acquired from the globally unique ID server of the transaction channel.
S1013: acquiring the number of an executive teller and the number of an executive mechanism corresponding to each thread;
in this step, the execution teller number v _ teller and the execution organization number v _ instruction of each thread in the account opening process are acquired.
Each thread represents a teller executing the transaction, corresponds to a teller number and an affiliated institution number, and is set as an executive teller number and an executive institution number of the transaction.
S1014: storing the amount, currency, transaction date, unique service number, executive counter number and executive mechanism number of the transaction processing of the account opening into an account information table, an account balance table, an account sequence number table and a deposit protocol table based on the account number;
wherein the initial account opening information includes: account number, amount, currency, transaction date, unique serial number of service, serial number of executive counter and serial number of executive organization.
It is understood that the account currency v _ currency is obtained as 1. The currency of the account requested by the customer may be any one of the currencies (currency tables) supported by the trading system (random).
Further, after acquiring the number of the executive teller and the number of the executive organization corresponding to each thread, the method further comprises the following steps:
checking the initial account opening information; and after the checking process is passed, storing the amount, currency, transaction date, unique service number, executive counter number and executive mechanism number of the transaction process of the account opening into an account information table, an account balance table, an account sequence number table and a deposit agreement table based on the account number.
Wherein, the checking process of the initial account opening information comprises the following steps:
checking whether the teller corresponding to the executive teller number and the institution corresponding to the executive institution number exist or not;
checking whether the currency supports;
and checking whether the account opening transaction processing is in a business protection mode or not.
In the present embodiment, it is preferred that,
it is checked whether the mechanism is present. Example SQL is as follows:
an error is reported if the record does not exist.
The presence of a teller is checked. Example SQL is as follows:
an error is reported if the record does not exist.
Check if the currency supports. Example SQL is as follows:
an error is reported if the record does not exist.
And (5) service anti-replay control. Example SQL is as follows:
if the record already exists, an error prompt is given: and repeatedly initiating the service.
An account v _ account is taken. And (4) account number anti-replay control. Example SQL is as follows:
if the record exists, an error is reported to prompt that the account is used.
Storing the amount, currency, transaction date, unique service number, executive counter number and executive mechanism number of the transaction processing of the account opening based on the account number into an account information table, an account balance table, an account sequence number table and a deposit protocol table, wherein the account information table comprises the following steps:
and adding a record to the account information table. Example SQL is as follows:
wherein: the logoff date indicates a null assignment, i.e., no logoff, with a special value of '1900-01-01'.
A record is inserted into the account balance table. Example SQL is as follows:
the initial amount of the user in the account opening transaction is set to 0.
A record is inserted in the deposit agreement table. Example SQL is as follows:
it is understood that the interest-bearing date is the date of the beginning of the interest-bearing transaction, and the last interest-bearing date in the account opening transaction is the current day of the transaction. The interest rate value multiplies the true interest rate by a multiple of 10 (100000000 in the SQL example above), by which the error caused by the floating point number processing of the computer is circumvented.
And adding related records in the account number table. Example SQL is as follows:
the transaction is registered in the business registry table. Example SQL is as follows:
in an embodiment of the present invention, referring to fig. 3, a specific implementation manner of step S102 in the foregoing example is provided, which includes the following steps:
s1021: determining the transaction date of the account deposit transaction processing and acquiring a service unique number corresponding to the account opening transaction processing from a global unique ID server of a transaction channel;
in this step, the transaction system time is obtained as the transaction date v _ workdate of the account opening transaction process. And acquiring the service unique number v _ seq from a global unique ID server of the transaction channel.
S1022: acquiring the number of an executive teller, the number of an executive organization and the service information of account deposit transaction corresponding to each thread;
in this step, the execution teller number v _ teller and the execution organization number v _ instruction of each thread in the account opening process are acquired.
Each thread represents a teller executing the transaction, corresponds to a teller number and an affiliated institution number, and is set as an executive teller number and an executive institution number of the transaction. The service information comprises a service occurrence account number v _ account, a service occurrence currency v _ current and a service processing amount v _ account.
It should be noted that in the real scenario, especially in the online transaction channel, from the financial institution perspective, the account ID, the currency and the amount of the next incoming customer may be considered as random, so that v _ account, v _ current and v _ account may adopt randomly generated values within the value range. Compared with the prior art that tools such as Sysbench, BanchmarkSQL and the like determine a possible value range of a random value according to data types, the value range of a business generation account is a set of opened accounts, the value range of a business generation currency is a set of supported currency in a currency table, and the value range of business processing money can be set according to the requirement of data generation, for example, the value range of [1,10000000000] represents 0.01 yuan to 1 billion yuan.
Further, step S1022 is followed by:
it is checked whether the mechanism is present. Example SQL is as follows:
an error is reported if the record does not exist.
The presence of a teller is checked. Example SQL is as follows:
an error is reported if the record does not exist.
Check if the currency supports. Example SQL is as follows:
an error is reported if the record does not exist.
And (5) service anti-replay control. Example SQL is as follows:
if the record already exists, an error prompt is given: and repeatedly initiating the service.
S1023: storing the transaction date, the account unique number teller number, the execution mechanism number and the service information of the account deposit transaction in an account balance table and an account detail table based on the account number and registering the account information detail table;
the method specifically comprises the following steps:
and inquiring an account information table. Example SQL is as follows:
if the account does not exist, an error is reported to prompt that the account does not exist.
If the account exists, but the status field of the account is abnormal, an error is reported to indicate that the account is abnormal.
And inquiring an account balance table. Example SQL is as follows:
if the record does not exist, an error is reported.
And if the record exists, acquiring the account balance value and assigning the value to v _ balance.
And querying the account detail sequence number v _ seq _ account. Example SQL is as follows:
and assigning the query result to an account detail sequence number v _ seq _ account.
Inquiring the information detail sequence number v _ seq _ interest _ account:
and assigning the query result to the information detail sequence number v _ seq _ interest _ acquiral.
Registering account information detail list:
if the last transaction date field5 of the account balance table does not equal the current transaction date v _ workdate, then an account statement is registered. Example SQL is as follows:
it should be noted that: the interest list only needs to register one stroke. If the last transaction date field5 of the account balance table equals the current transaction date v _ workdate, indicating that the balance has been changed on this date, no more information details need to be inserted or updated.
And updating the account balance:
let the current balance v _ balance be v _ balance + v _ amount.
If the last transaction date FIELD5 of the account balance table is not equal to the current transaction date v _ workdate, then the current balance needs to be updated to the current balance FIELD.
If the last transaction date FIELD5 of the account balance table is equal to the current transaction date v _ workdate, the current balance is unchanged;
updating the current balance to be the current balance plus the service processing amount:
an account statement is inserted. Example SQL is as follows:
a record is inserted in the service registry table. Example SQL is as follows:
it should be noted that: the depositor is the lender, and the borrower and the lender have to be in the same currency amount.
In this embodiment, specific formats of the account information table, the account balance table, the account deposit agreement table, the institution table, the teller table, and the currency table in the above embodiments are provided:
an account information table:
(1) and field definition:
(2) and (3) index definition:
| index name | Index field | Properties |
| IDX1 | FIELD1 | UNIQUE |
(3) Table illustrates that:
FIELD 4-an account password (optionally set in the account opening process or separately applied before account opening) needs to be reserved during account opening, and the password is used during subsequent ticket purchasing and other credentials and is used as an auxiliary means for verifying the identity of a client, so that the fund security of the client is better ensured.
Account balance table:
(1) and field definition:
| name of English | Name of Chinese | Data type | Note description |
| FIELD1 | Account number | UNSIGNED BIGINT(19) | |
| FIELD2 | Coin kind | UNSIGNED INT(3) | |
| FIELD3 | Current balance | BIGINT(17) | |
| FIELD4 | Balance of previous period | BIGINT(17) | |
| FIELD5 | Last day of trade | DATE | YYYY-MM-DD |
(2) And (3) index definition:
| index name | Index field | Properties |
| IDX1 | FIELD1+FIELD2 | UNIQUE |
(3) Table illustrates that:
the account balance table does not require a timestamp field.
Account deposit agreement table:
(1) and field definition:
| name of English | Name of Chinese | Data type | Note description |
| FIELD1 | Account number | UNSIGNED BIGINT(19) | |
| FIELD2 | Coin kind | UNSIGNED INT(3) | |
| FIELD3 | Reference interest rate | INT(9) | |
| FIELD4 | Last rest date | DATE | |
| FIELD5 | Final modification mechanism | UNSIGNED BIGINT(10) | |
| FIELD6 | Last modification teller | UNSIGNED BIGINT(11) | |
| FIELD7 | Last modified date | DATE |
(2) And (3) index definition:
| index name | Index field | Properties |
| IDX1 | FIELD1+FIELD2 | UNIQUE |
(3) Table illustrates that:
note that the type of baseline interest rate is INT. And the actual interest rate is assigned as 108, so that the condition of small amount is processed, and the precision loss of floating point operation is avoided.
An organization meter:
(1) and field definition:
(2) and (3) index definition:
| index name | Index field | Properties |
| IDX1 | FIELD1 | UNIQUE |
Teller table:
(1) and field definition:
(2) and (3) index definition:
| index name | Index field | Properties |
| IDX1 | FIELD1 | UNIQUE |
The currency table:
(1) and field definition:
(2) and (3) index definition:
| index name | Index field | Properties |
| IDX1 | FIELD1 | UNIQUE |
It should be noted that all tables must define primary keys. In practical application, a unique index in the data model can be used as a main key, and a ROWID column without service significance can be added as the main key.
All fields need to define NOT NULL attributes, and NULL values can be represented by special values outside the normal service value domain.
As can be seen from the above description, in the transaction system based on real financial accounting according to the present embodiment, based on the financial core transaction scenarios of bank account opening and deposit, the data generated through the transaction processing flows of "account opening" and "account deposit" meets the association requirements such as financial data balance, the information such as the amount, number, and date stored in different data tables of the same account and the same transaction can be kept consistent, and the generated data better conforms to the characteristics of the financial data in the aspects of data distribution, data association, and the like.
An embodiment of the present invention provides a specific implementation manner of a database test data generation apparatus based on a financial core transaction scenario, which is capable of implementing all contents in the database test data generation method based on a financial core transaction scenario, and referring to fig. 4, the database test data generation apparatus based on a financial core transaction scenario specifically includes the following contents:
an account opening module 10, configured to process each of at least two threads through an account opening transaction to obtain a plurality of accounts; storing the initial account opening information of each account into an account information table, an account balance table, an account serial number table and a deposit protocol table which respectively correspond to the initial account opening information;
the account transaction module 20 is configured to perform, by each of the at least two threads, account deposit transaction processing on at least one account of the multiple accounts, and store amount information of each account deposit transaction processing into an account balance table and an account detail table corresponding to the account of the account deposit transaction processing;
the test data module 30 is configured to determine that data in the account information table, the account serial number table, the deposit agreement table, the account balance table, and the account detail table of all the accounts is test data of the batch transaction scenario database.
Wherein the account opening module comprises:
the first determining unit is used for determining the transaction date of the account opening transaction processing and generating an account number corresponding to the account based on a preset serial number table;
the acquisition unit is used for acquiring a service unique number corresponding to the transaction processing of the account opening from a global unique ID server of a transaction channel;
the first acquisition unit is used for acquiring the number of an executive teller and the number of an executive mechanism corresponding to each thread;
the first storage unit is used for storing the amount, currency, transaction date, unique service number, executive counter number and executive mechanism number of the transaction processing of the account opening based on the account number into an account information table, an account balance table, an account sequence number table and a deposit protocol table;
wherein the initial account opening information includes: account number, amount, currency, transaction date, unique serial number of service, serial number of executive counter and serial number of executive organization.
Wherein the account transaction module comprises:
the second determining unit is used for determining the transaction date of the account deposit transaction processing and acquiring a service unique number corresponding to the account opening transaction processing from a global unique ID server of a transaction channel;
the second acquisition unit is used for acquiring the number of an executive teller, the number of an executive organization and the service information of account deposit transaction corresponding to each thread;
the second storage unit is used for storing the transaction date of the account deposit transaction processing, the teller number with the unique service number, the number of an execution mechanism and the service information of the account deposit transaction into an account balance table and an account detail table and registering the account information detail table based on the account number;
the service information comprises a service occurrence account number, a service occurrence currency and a service processing amount.
According to the technical scheme, the invention provides the database test data generation device based on the financial core transaction scene, and a plurality of accounts are obtained through account opening transaction processing of each of at least two threads; storing the initial account opening information of each account into an account information table, an account balance table, an account serial number table and a deposit protocol table which respectively correspond to the initial account opening information; each thread in the at least two threads performs account deposit transaction processing on at least one account in the plurality of accounts, and the amount information processed by each account deposit transaction is stored in an account balance table and an account detail table corresponding to the account processed by the account deposit transaction; and determining the data in the account information table, the account serial number table, the deposit agreement table, the account balance table and the account detail table of all the accounts as the test data of the batch transaction scene database. The method can meet the relevance requirements of financial data on account balance and the like, the information such as the amount, the number, the date and the like stored in different data tables in the same account and the same transaction can keep consistency, the generated data better accords with the characteristics of the financial data in the aspects of data distribution, data relevance and the like, the accuracy of the generated data is improved, and the accuracy of database testing based on the generated data is further improved.
The application provides an embodiment of an electronic device for implementing all or part of contents in the financial core transaction scenario-based database test data generation method, where the electronic device specifically includes the following contents:
a processor (processor), a memory (memory), a communication Interface (Communications Interface), and a bus; the processor, the memory and the communication interface complete mutual communication through the bus; the communication interface is used for realizing information transmission between related devices; the electronic device may be a desktop computer, a tablet computer, a mobile terminal, and the like, but the embodiment is not limited thereto. In this embodiment, the electronic device may be implemented with reference to the embodiment for implementing the method for generating database test data based on a financial core transaction scenario and the embodiment for implementing the device for generating database test data based on a financial core transaction scenario, which are incorporated herein, and repeated details are not repeated herein.
Fig. 5 is a schematic block diagram of a system configuration of an electronic device 9600 according to an embodiment of the present application. As shown in fig. 5, the electronic device 9600 can include a central processor 9100 and a memory 9140; the memory 9140 is coupled to the central processor 9100. Notably, this FIG. 5 is exemplary; other types of structures may also be used in addition to or in place of the structure to implement telecommunications or other functions.
In one embodiment, the database test data generation functionality based on financial core transaction scenarios may be integrated into the central processor 9100. The central processor 9100 may be configured to control as follows:
each thread in the at least two threads obtains a plurality of accounts through account opening transaction processing; storing the initial account opening information of each account into an account information table, an account balance table, an account serial number table and a deposit protocol table which respectively correspond to the initial account opening information; each thread in the at least two threads performs account deposit transaction processing on at least one account in the plurality of accounts, and the amount information processed by each account deposit transaction is stored in an account balance table and an account detail table corresponding to the account processed by the account deposit transaction; and determining the data in the account information table, the account serial number table, the deposit agreement table, the account balance table and the account detail table of all the accounts as the test data of the batch transaction scene database.
As can be seen from the above description, in the electronic device provided in the embodiments of the present application, a plurality of accounts are obtained through the account opening transaction processing by each of at least two threads; storing the initial account opening information of each account into an account information table, an account balance table, an account serial number table and a deposit protocol table which respectively correspond to the initial account opening information; each thread in the at least two threads performs account deposit transaction processing on at least one account in the plurality of accounts, and the amount information processed by each account deposit transaction is stored in an account balance table and an account detail table corresponding to the account processed by the account deposit transaction; and determining the data in the account information table, the account serial number table, the deposit agreement table, the account balance table and the account detail table of all the accounts as the test data of the batch transaction scene database. The method can meet the relevance requirements of financial data on account balance and the like, the information such as the amount, the number, the date and the like stored in different data tables in the same account and the same transaction can keep consistency, the generated data better accords with the characteristics of the financial data in the aspects of data distribution, data relevance and the like, the accuracy of the generated data is improved, and the accuracy of database testing based on the generated data is further improved.
In another embodiment, the database test data generation apparatus based on the financial core transaction scenario may be configured separately from the central processor 9100, for example, the database test data generation apparatus based on the financial core transaction scenario may be configured as a chip connected to the central processor 9100, and the database test data generation function based on the financial core transaction scenario may be implemented by the control of the central processor.
As shown in fig. 5, the electronic device 9600 may further include: a communication module 9110, an input unit 9120, an audio processor 9130, a display 9160, and a power supply 9170. It is noted that the electronic device 9600 also does not necessarily include all of the components shown in fig. 5; further, the electronic device 9600 may further include components not shown in fig. 5, which may be referred to in the art.
As shown in fig. 5, a central processor 9100, sometimes referred to as a controller or operational control, can include a microprocessor or other processor device and/or logic device, which central processor 9100 receives input and controls the operation of the various components of the electronic device 9600.
The memory 9140 can be, for example, one or more of a buffer, a flash memory, a hard drive, a removable media, a volatile memory, a non-volatile memory, or other suitable device. The information relating to the failure may be stored, and a program for executing the information may be stored. And the central processing unit 9100 can execute the program stored in the memory 9140 to realize information storage or processing, or the like.
The input unit 9120 provides input to the central processor 9100. The input unit 9120 is, for example, a key or a touch input device. Power supply 9170 is used to provide power to electronic device 9600. The display 9160 is used for displaying display objects such as images and characters. The display may be, for example, an LCD display, but is not limited thereto.
The memory 9140 can be a solid state memory, e.g., Read Only Memory (ROM), Random Access Memory (RAM), a SIM card, or the like. There may also be a memory that holds information even when power is off, can be selectively erased, and is provided with more data, an example of which is sometimes called an EPROM or the like. The memory 9140 could also be some other type of device. Memory 9140 includes a buffer memory 9141 (sometimes referred to as a buffer). The memory 9140 may include an application/function storage portion 9142, the application/function storage portion 9142 being used for storing application programs and function programs or for executing a flow of operations of the electronic device 9600 by the central processor 9100.
The memory 9140 can also include a data store 9143, the data store 9143 being used to store data, such as contacts, digital data, pictures, sounds, and/or any other data used by an electronic device. The driver storage portion 9144 of the memory 9140 may include various drivers for the electronic device for communication functions and/or for performing other functions of the electronic device (e.g., messaging applications, contact book applications, etc.).
The communication module 9110 is a transmitter/receiver 9110 that transmits and receives signals via an antenna 9111. The communication module (transmitter/receiver) 9110 is coupled to the central processor 9100 to provide input signals and receive output signals, which may be the same as in the case of a conventional mobile communication terminal.
Based on different communication technologies, a plurality of communication modules 9110, such as a cellular network module, a bluetooth module, and/or a wireless local area network module, may be provided in the same electronic device. The communication module (transmitter/receiver) 9110 is also coupled to a speaker 9131 and a microphone 9132 via an audio processor 9130 to provide audio output via the speaker 9131 and receive audio input from the microphone 9132, thereby implementing ordinary telecommunications functions. The audio processor 9130 may include any suitable buffers, decoders, amplifiers and so forth. In addition, the audio processor 9130 is also coupled to the central processor 9100, thereby enabling recording locally through the microphone 9132 and enabling locally stored sounds to be played through the speaker 9131.
An embodiment of the present invention further provides a computer-readable storage medium capable of implementing all the steps of the financial core transaction scenario-based database test data generation method in the above embodiment, where the computer-readable storage medium stores thereon a computer program, and when the computer program is executed by a processor, the computer program implements all the steps of the financial core transaction scenario-based database test data generation method in the above embodiment, for example, when the processor executes the computer program, the processor implements the following steps:
each thread in the at least two threads obtains a plurality of accounts through account opening transaction processing; storing the initial account opening information of each account into an account information table, an account balance table, an account serial number table and a deposit protocol table which respectively correspond to the initial account opening information; each thread in the at least two threads performs account deposit transaction processing on at least one account in the plurality of accounts, and the amount information processed by each account deposit transaction is stored in an account balance table and an account detail table corresponding to the account processed by the account deposit transaction; and determining the data in the account information table, the account serial number table, the deposit agreement table, the account balance table and the account detail table of all the accounts as the test data of the batch transaction scene database.
As can be seen from the above description, the computer-readable storage medium provided in the embodiment of the present invention obtains a plurality of accounts through the account opening transaction processing by each of at least two threads; storing the initial account opening information of each account into an account information table, an account balance table, an account serial number table and a deposit protocol table which respectively correspond to the initial account opening information; each thread in the at least two threads performs account deposit transaction processing on at least one account in the plurality of accounts, and the amount information processed by each account deposit transaction is stored in an account balance table and an account detail table corresponding to the account processed by the account deposit transaction; and determining the data in the account information table, the account serial number table, the deposit agreement table, the account balance table and the account detail table of all the accounts as the test data of the batch transaction scene database. The method can meet the relevance requirements of financial data on account balance and the like, the information such as the amount, the number, the date and the like stored in different data tables in the same account and the same transaction can keep consistency, the generated data better accords with the characteristics of the financial data in the aspects of data distribution, data relevance and the like, the accuracy of the generated data is improved, and the accuracy of database testing based on the generated data is further improved.
Although the present invention provides method steps as described in the examples or flowcharts, more or fewer steps may be included based on routine or non-inventive labor. The order of steps recited in the embodiments is merely one manner of performing the steps in a multitude of orders and does not represent the only order of execution. When an actual apparatus or client product executes, it may execute sequentially or in parallel (e.g., in the context of parallel processors or multi-threaded processing) according to the embodiments or methods shown in the figures.
As will be appreciated by one skilled in the art, embodiments of the present description may be provided as a method, apparatus (system) or computer program product. Accordingly, embodiments of the present description may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. It should be noted that the embodiments and features of the embodiments may be combined with each other without conflict. The present invention is not limited to any single aspect, nor is it limited to any single embodiment, nor is it limited to any combination and/or permutation of these aspects and/or embodiments. Moreover, each aspect and/or embodiment of the present invention may be utilized alone or in combination with one or more other aspects and/or embodiments thereof.
Finally, it should be noted that: the above embodiments are only used to illustrate the technical solution of the present invention, and not to limit the same; while the invention has been described in detail and with reference to the foregoing embodiments, it will be understood by those skilled in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; such modifications and substitutions do not depart from the spirit and scope of the present invention, and they should be construed as being included in the following claims and description.
Claims (10)
1. A database test data generation method based on financial core transaction scenarios is characterized by comprising the following steps:
each thread in the at least two threads obtains a plurality of accounts through account opening transaction processing; storing the initial account opening information of each account into an account information table, an account balance table, an account serial number table and a deposit protocol table which respectively correspond to the initial account opening information;
each thread in the at least two threads performs account deposit transaction processing on at least one account in the plurality of accounts, and the amount information processed by each account deposit transaction is stored in an account balance table and an account detail table corresponding to the account processed by the account deposit transaction;
and determining the data in the account information table, the account serial number table, the deposit agreement table, the account balance table and the account detail table of all the accounts as the test data of the batch transaction scene database.
2. The financial core transaction scenario-based database test data generation method of claim 1, wherein each of the at least two threads obtains a plurality of accounts through account opening transaction processing; storing the initial account opening information of each account into an account information table, an account balance table, an account serial number table and a deposit protocol table which respectively correspond to the initial account opening information, wherein the method comprises the following steps:
determining the transaction date of the account opening transaction processing and generating an account number corresponding to the account based on a preset serial number table;
acquiring a service unique number corresponding to the transaction processing of the account opening from a global unique ID server of a transaction channel;
acquiring the number of an executive teller and the number of an executive mechanism corresponding to each thread;
storing the amount, currency, transaction date, unique service number, executive counter number and executive mechanism number of the transaction processing of the account opening into an account information table, an account balance table, an account sequence number table and a deposit protocol table based on the account number;
wherein the initial account opening information includes: account number, amount, currency, transaction date, unique serial number of service, serial number of executive counter and serial number of executive organization.
3. The database test data generation method based on financial core transaction scenario as claimed in claim 2, further comprising, after obtaining the executive teller number and the executive organization number corresponding to each thread:
checking the initial account opening information; and after the checking process is passed, storing the amount, currency, transaction date, unique service number, executive counter number and executive mechanism number of the transaction process of the account opening into an account information table, an account balance table, an account sequence number table and a deposit agreement table based on the account number.
4. The method for generating database test data based on financial core transaction scenario as claimed in claim 3, wherein the checking the initial account opening information comprises:
checking whether the teller corresponding to the executive teller number and the institution corresponding to the executive institution number exist or not;
checking whether the currency supports;
and checking whether the account opening transaction processing is in a business protection mode or not.
5. The database test data generation method based on financial core transaction scenario as claimed in claim 1, wherein each of the at least two threads performs account deposit transaction processing on at least one account of the plurality of accounts, and stores the amount information of each account deposit transaction processing into the account balance table and the account detail table corresponding to the account processed by the account deposit transaction, including:
determining the transaction date of the account deposit transaction processing and acquiring a service unique number corresponding to the account opening transaction processing from a global unique ID server of a transaction channel;
acquiring the number of an executive teller, the number of an executive organization and the service information of account deposit transaction corresponding to each thread;
storing the transaction date, the account unique number teller number, the execution mechanism number and the service information of the account deposit transaction in an account balance table and an account detail table based on the account number and registering the account information detail table;
the service information comprises a service occurrence account number, a service occurrence currency and a service processing amount.
6. A database test data generating apparatus based on a financial core transaction scenario, comprising:
the account opening module is used for processing each thread of at least two threads through account opening transactions to obtain a plurality of accounts; storing the initial account opening information of each account into an account information table, an account balance table, an account serial number table and a deposit protocol table which respectively correspond to the initial account opening information;
the account transaction module is used for performing account deposit transaction processing on at least one account in the plurality of accounts by each thread in at least two threads, and storing the amount information processed by each account deposit transaction into an account balance table and an account detail table corresponding to the account processed by the account deposit transaction;
and the test data module is used for determining that the data in the account information table, the account serial number table, the deposit agreement table, the account balance table and the account detail table of all the accounts are the test data of the batch transaction scene database.
7. The financial core transaction scenario-based database test data generation apparatus of claim 6, wherein the account opening module comprises:
the first determining unit is used for determining the transaction date of the account opening transaction processing and generating an account number corresponding to the account based on a preset serial number table;
the acquisition unit is used for acquiring a service unique number corresponding to the transaction processing of the account opening from a global unique ID server of a transaction channel;
the first acquisition unit is used for acquiring the number of an executive teller and the number of an executive mechanism corresponding to each thread;
the first storage unit is used for storing the amount, currency, transaction date, unique service number, executive counter number and executive mechanism number of the transaction processing of the account opening based on the account number into an account information table, an account balance table, an account sequence number table and a deposit protocol table;
wherein the initial account opening information includes: account number, amount, currency, transaction date, unique serial number of service, serial number of executive counter and serial number of executive organization.
8. The financial core transaction scenario-based database test data generation apparatus of claim 6, wherein the account transaction module comprises:
the second determining unit is used for determining the transaction date of the account deposit transaction processing and acquiring a service unique number corresponding to the account opening transaction processing from a global unique ID server of a transaction channel;
the second acquisition unit is used for acquiring the number of an executive teller, the number of an executive organization and the service information of account deposit transaction corresponding to each thread;
the second storage unit is used for storing the transaction date of the account deposit transaction processing, the teller number with the unique service number, the number of an execution mechanism and the service information of the account deposit transaction into an account balance table and an account detail table and registering the account information detail table based on the account number;
the service information comprises a service occurrence account number, a service occurrence currency and a service processing amount.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor when executing the program implements the steps of the method of generating database test data based on financial core transaction scenarios of any one of claims 1 to 5.
10. A computer-readable storage medium having stored thereon a computer program, wherein the computer program, when executed by a processor, implements the steps of the method for generating database test data based on financial core transaction scenarios according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110493712.1A CN113010443B (en) | 2021-05-07 | 2021-05-07 | Database test data generation method and device based on financial core transaction scene |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110493712.1A CN113010443B (en) | 2021-05-07 | 2021-05-07 | Database test data generation method and device based on financial core transaction scene |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113010443A true CN113010443A (en) | 2021-06-22 |
| CN113010443B CN113010443B (en) | 2024-02-20 |
Family
ID=76380666
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110493712.1A Active CN113010443B (en) | 2021-05-07 | 2021-05-07 | Database test data generation method and device based on financial core transaction scene |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113010443B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116483689A (en) * | 2023-03-13 | 2023-07-25 | 深圳华锐分布式技术股份有限公司 | Method, device, equipment and medium for testing option brokerage quick trading system |
| CN116561018A (en) * | 2023-07-12 | 2023-08-08 | 天津金城银行股份有限公司 | Service system counting method, device, terminal equipment and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111159020A (en) * | 2019-12-20 | 2020-05-15 | 武汉达梦数据库有限公司 | Method and device applied to synchronous software test |
| US20210011838A1 (en) * | 2019-07-09 | 2021-01-14 | International Business Machines Corporation | Partial-results post-silicon hardware exerciser |
| CN112685288A (en) * | 2020-12-03 | 2021-04-20 | 福建亿能达信息技术股份有限公司 | Method, device, equipment and medium for generating test data of association table |
-
2021
- 2021-05-07 CN CN202110493712.1A patent/CN113010443B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20210011838A1 (en) * | 2019-07-09 | 2021-01-14 | International Business Machines Corporation | Partial-results post-silicon hardware exerciser |
| CN111159020A (en) * | 2019-12-20 | 2020-05-15 | 武汉达梦数据库有限公司 | Method and device applied to synchronous software test |
| CN112685288A (en) * | 2020-12-03 | 2021-04-20 | 福建亿能达信息技术股份有限公司 | Method, device, equipment and medium for generating test data of association table |
Non-Patent Citations (1)
| Title |
|---|
| 田甜: "并发程序变异测试研究综述", 《电子学报》, vol. 48, no. 11, 30 November 2020 (2020-11-30) * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116483689A (en) * | 2023-03-13 | 2023-07-25 | 深圳华锐分布式技术股份有限公司 | Method, device, equipment and medium for testing option brokerage quick trading system |
| CN116483689B (en) * | 2023-03-13 | 2024-01-05 | 深圳华锐分布式技术股份有限公司 | Method, device, equipment and medium for testing option brokerage quick trading system |
| CN116561018A (en) * | 2023-07-12 | 2023-08-08 | 天津金城银行股份有限公司 | Service system counting method, device, terminal equipment and storage medium |
| CN116561018B (en) * | 2023-07-12 | 2023-09-01 | 天津金城银行股份有限公司 | Service system counting method, device, terminal equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113010443B (en) | 2024-02-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109716707B (en) | Server apparatus and method for distributed electronic recording and transaction history | |
| US20220215354A1 (en) | Method and system for multi-account check processing via blockchain | |
| US20190213584A1 (en) | Method and system for tokenized replacement of crypto currency addresses | |
| CN115907760A (en) | Method and system for transaction processing with full password verifiability | |
| CN113010443B (en) | Database test data generation method and device based on financial core transaction scene | |
| CN112163946A (en) | Accounting processing method and device based on distributed transaction system | |
| US20180181954A1 (en) | Configuring a transaction device | |
| CN109146444B (en) | Virtual account creating method and device and account information updating method and device | |
| CN112837000A (en) | Banknote distribution auxiliary method and device | |
| US11663610B2 (en) | Method and system for providing a service node within a blockchain | |
| CN115427996A (en) | System and method for transaction settlement | |
| KR101737559B1 (en) | Apparatus and method for generating identification information for replacing account number, and computer program for the same | |
| CN113159968A (en) | Data processing method and device based on financial core batch transaction scene | |
| US20170098193A1 (en) | Flexible and prioritized multi-purse tables for multi-account benefit plan management and processing | |
| CN110442375B (en) | Mobile payment product channel integration method, device, equipment and storage medium | |
| CN111598539A (en) | CICS online program service processing method and system based on service modeling | |
| CN113298631A (en) | Bearing processing method and device | |
| CN113159967A (en) | Data processing method and device based on financial core online transaction scene | |
| CN112734543A (en) | Accounting processing method and device, computer equipment and storage medium | |
| CN113055401B (en) | Enterprise business authorization processing method and device | |
| CN111932368B (en) | Credit card issuing system and construction method and device thereof | |
| CN117493156A (en) | Payment system testing method and device, electronic equipment and readable storage medium | |
| CN115248697A (en) | System gray scale upgrading method and device, electronic equipment and storage medium | |
| CN113222733A (en) | Loan transaction processing method, device, equipment and storage medium | |
| CN113448990A (en) | Quasi-real-time multi-dimensional data query method and device for unitized system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |