CN117891746A - Host migration testing method and device - Google Patents
Host migration testing method and device Download PDFInfo
- Publication number
- CN117891746A CN117891746A CN202410130023.8A CN202410130023A CN117891746A CN 117891746 A CN117891746 A CN 117891746A CN 202410130023 A CN202410130023 A CN 202410130023A CN 117891746 A CN117891746 A CN 117891746A
- Authority
- CN
- China
- Prior art keywords
- host
- host table
- information
- migration
- test
- 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 249
- 230000005012 migration Effects 0.000 title claims abstract description 235
- 238000013508 migration Methods 0.000 title claims abstract description 235
- 230000009471 action Effects 0.000 claims abstract description 46
- 238000000034 method Methods 0.000 claims abstract description 46
- 230000000295 complement effect Effects 0.000 claims description 26
- 238000004590 computer program Methods 0.000 claims description 15
- 238000005192 partition Methods 0.000 claims description 13
- 238000012790 confirmation Methods 0.000 claims description 5
- 238000012216 screening Methods 0.000 claims description 5
- 230000008569 process Effects 0.000 description 12
- 238000010586 diagram Methods 0.000 description 10
- 238000010998 test method Methods 0.000 description 9
- 239000002699 waste material Substances 0.000 description 9
- 230000006870 function Effects 0.000 description 5
- 238000012545 processing Methods 0.000 description 5
- 230000007704 transition Effects 0.000 description 4
- 238000004364 calculation method Methods 0.000 description 3
- 230000004044 response Effects 0.000 description 3
- 238000004422 calculation algorithm Methods 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 239000000463 material Substances 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000012954 risk control Methods 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a host migration testing method and device, relates to the technical field of testing, and can be used in the financial field or other technical fields. The method comprises the following steps: responding to a first trigger action of inquiring host migration test information by a user, and calling a pre-established host migration test auxiliary model; outputting query result information which is covered by the enterprise business and corresponds to the information type through the host migration test auxiliary model according to the information type of the host migration test information; and responding to a second trigger action executed by the user according to the query result information, and acquiring test association information corresponding to a target host table name in a target host table set so as to enable the user to carry out host migration test according to the test association information and the target host table corresponding to the target host table name. The apparatus performs the above method. The method and the device provided by the embodiment of the invention give consideration to the migration test efficiency and the controllable risk of the host.
Description
Technical Field
The invention relates to the technical field of testing, in particular to a method and a device for testing migration of a host.
Background
The financial enterprise business is widely distributed and can be distributed in various areas, such as provinces, cities, towns and the like. For convenience of management, the financial enterprises define unique host table names for each host table, so that the host tables with the duplicate names cannot appear in each region of the financial enterprises.
In the process of the host migration test, a tester needs to repeatedly migrate the host data of each region. The data is used as the first step of host migration and is the basis of subsequent online test and batch test. In short, the transition is that the data table is moved from one system to another system, so that the data may be completely translated or incompletely translated in the transition process, and the consistency of the data needs to be ensured before and after the transition.
In a host system, it is common to accumulate thousands of host tables, and migration procedures for the same host table are identical. However, each host region has the characteristics, if the whole region is selected for the migration test, the coverage can be guaranteed to be comprehensive, but the time consumption is long, the manpower resource cost is high, and the repeated migration efficiency is low; if a partial area is selected for transition, time can be saved, cost can be reduced, efficiency can be improved, but omission needs to be avoided or risk control needs to be ensured. With more and more areas where host migration is completed, the migration verification range is changed continuously, and the existing method cannot be adapted to the change, so that a large amount of resource waste is caused.
Disclosure of Invention
Aiming at the problems in the prior art, the embodiment of the invention provides a host migration testing method and device, which can at least partially solve the problems in the prior art.
In one aspect, the present invention provides a method for testing migration of a host, including:
responding to a first trigger action of inquiring host migration test information by a user, and calling a pre-established host migration test auxiliary model;
outputting query result information which is covered by the enterprise business and corresponds to the information type through the host migration test auxiliary model according to the information type of the host migration test information; the inquiry result information comprises a to-be-selected host table set corresponding to the to-be-selected areas of the enterprise business respectively;
and responding to a second trigger action executed by the user according to the query result information, and acquiring test association information corresponding to a target host table name in a target host table set so as to enable the user to carry out host migration test according to the test association information and the target host table corresponding to the target host table name.
Wherein the information types comprise a first information type taking an input data set as a query mode; correspondingly, the outputting, by the host migration test auxiliary model, query result information covered by the enterprise service and corresponding to the information type according to the information type of the host migration test information includes:
and taking a preset region in the host migration test auxiliary model and a preset host table set corresponding to the region as the host table set to be selected and migration data coverage rate corresponding to each host table set to be selected respectively.
The responding to the second triggering action executed by the user according to the query result information obtains test association information corresponding to the target host table name in the target host table set, and the method comprises the following steps:
responding to the selection operation of the user according to the migration data coverage rate corresponding to each host table set to be selected, and screening the target host table set from each host table set to be selected;
and acquiring corresponding test association information according to the target host table names in the target host table set.
The information type comprises a second information type taking the coverage rate of input migration data as a query mode; correspondingly, the outputting, by the host migration test auxiliary model, query result information covered by the enterprise service and corresponding to the information type according to the information type of the host migration test information includes:
and acquiring a region to be selected corresponding to the migration data coverage rate based on the host migration test auxiliary model, and acquiring a set of host table to be selected corresponding to the region to be selected.
The responding to the second triggering action executed by the user according to the query result information obtains test association information corresponding to the target host table name in the target host table set, and the method comprises the following steps:
Responding to a confirmation operation carried out by the user according to the host table set to be selected, and taking the host table set to be selected as the target host table set;
and acquiring corresponding test association information according to the target host table names in the target host table set.
The obtaining test association information corresponding to the target host table name in the target host table set includes:
and acquiring the partition and the application name corresponding to the target host table name.
The establishing the host migration test auxiliary model comprises the following steps:
Acquiring a host table set which is covered by enterprise business and corresponds to each region respectively; each host table set comprises a host table name corresponding to each region respectively;
Acquiring a preselected host table set with the most repeated host table names in the host table complete set corresponding to all areas, and acquiring a complement set of the preselected host table set relative to the host table complete set;
And replacing the host table complete set by using the complement set, continuously executing to acquire one pre-selected host table set with the most repeated host table names in the host table complete set corresponding to all areas, and acquiring the complement set of the pre-selected host table set relative to the host table complete set until the newly acquired complement set meets the preset termination condition, and acquiring the preset area and the preset host table set corresponding to the preset area.
In one aspect, the present invention provides a host migration testing apparatus, including:
The calling unit is used for responding to a first trigger action of inquiring the host migration test information by a user and calling a pre-established host migration test auxiliary model;
The output unit is used for outputting query result information which is covered by the enterprise business and corresponds to the information type through the host migration test auxiliary model according to the information type of the host migration test information; the inquiry result information comprises a to-be-selected host table set corresponding to the to-be-selected areas of the enterprise business respectively;
And the test unit is used for responding to the second trigger action executed by the user according to the query result information, and obtaining test association information corresponding to the target host table name in the target host table set so as to enable the user to carry out host migration test according to the test association information and the target host table corresponding to the target host table name.
In still another aspect, an embodiment of the present invention provides an electronic device, including: a processor, a memory, and a bus, wherein,
The processor and the memory complete communication with each other through the bus;
The memory stores program instructions executable by the processor, the processor invoking the program instructions capable of performing the method of:
responding to a first trigger action of inquiring host migration test information by a user, and calling a pre-established host migration test auxiliary model;
outputting query result information which is covered by the enterprise business and corresponds to the information type through the host migration test auxiliary model according to the information type of the host migration test information; the inquiry result information comprises a to-be-selected host table set corresponding to the to-be-selected areas of the enterprise business respectively;
and responding to a second trigger action executed by the user according to the query result information, and acquiring test association information corresponding to a target host table name in a target host table set so as to enable the user to carry out host migration test according to the test association information and the target host table corresponding to the target host table name.
Embodiments of the present invention provide a non-transitory computer readable storage medium comprising:
the non-transitory computer readable storage medium stores computer instructions that cause the computer to perform the method of:
responding to a first trigger action of inquiring host migration test information by a user, and calling a pre-established host migration test auxiliary model;
outputting query result information which is covered by the enterprise business and corresponds to the information type through the host migration test auxiliary model according to the information type of the host migration test information; the inquiry result information comprises a to-be-selected host table set corresponding to the to-be-selected areas of the enterprise business respectively;
and responding to a second trigger action executed by the user according to the query result information, and acquiring test association information corresponding to a target host table name in a target host table set so as to enable the user to carry out host migration test according to the test association information and the target host table corresponding to the target host table name.
According to the host migration test method and device provided by the embodiment of the invention, the first trigger action of inquiring the host migration test information by the user is responded, and the pre-established host migration test auxiliary model is called; outputting query result information which is covered by the enterprise business and corresponds to the information type through the host migration test auxiliary model according to the information type of the host migration test information; the inquiry result information comprises a to-be-selected host table set corresponding to the to-be-selected areas of the enterprise business respectively; and responding to a second triggering action executed by the user according to the query result information, acquiring test association information corresponding to a target host table name in a target host table set, so that the user can carry out host migration test according to the test association information and the target host table corresponding to the target host table name, and reasonably selecting a host table and test association information used for participating in the host migration test by assisting the user, so that migration data are used in a small amount of host tables and covered as comprehensively as possible, the host migration test efficiency and risk controllability are considered, and the resource waste phenomenon in the host migration test process is reduced.
Drawings
In order to more clearly illustrate the embodiments of the invention or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, it being obvious that the drawings in the following description are only some embodiments of the invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art. In the drawings:
Fig. 1 is a flowchart of a host migration testing method according to an embodiment of the invention.
Fig. 2 is a flowchart of a method for testing host migration according to another embodiment of the present invention.
Fig. 3 is a schematic structural diagram of a host migration testing apparatus according to an embodiment of the invention.
Fig. 4 is a schematic diagram of an entity structure of an electronic device according to an embodiment of the present invention.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present application more apparent, the embodiments of the present application will be described in further detail with reference to the accompanying drawings. The exemplary embodiments of the present application and their descriptions herein are for the purpose of explaining the present application, but are not to be construed as limiting the application. It should be noted that, without conflict, the embodiments of the present application and features of the embodiments may be arbitrarily combined with each other.
Fig. 1 is a flow chart of a host migration testing method according to an embodiment of the present invention, and as shown in fig. 1, the host migration testing method according to the embodiment of the present invention includes:
step S1: and responding to a first trigger action of inquiring the host migration test information by a user, and calling a pre-established host migration test auxiliary model.
Step S2: outputting query result information which is covered by the enterprise business and corresponds to the information type through the host migration test auxiliary model according to the information type of the host migration test information; the query result information comprises a set of host tables to be selected, which correspond to the regions to be selected of the enterprise business respectively.
Step S3: and responding to a second trigger action executed by the user according to the query result information, and acquiring test association information corresponding to a target host table name in a target host table set so as to enable the user to carry out host migration test according to the test association information and the target host table corresponding to the target host table name.
In the step S1, the device responds to the first trigger action of the user for inquiring the host migration test information, and invokes the pre-established host migration test auxiliary model. The apparatus may be a computer device, for example a server, performing the method. It should be noted that, the data acquisition and analysis according to the embodiments of the present invention are authorized by the user.
The user can be specifically a tester, the tester can realize the pre-operation of inquiring the host migration test information by clicking an information type key of the host migration test information of the operation interface, and at the moment, a pre-established host migration test auxiliary model is called, and can be data modeling realized by using a greedy algorithm.
In the step S2, the device outputs query result information which is covered by the enterprise service and corresponds to the information type through the host migration test auxiliary model according to the information type of the host migration test information; the query result information comprises a set of host tables to be selected, which correspond to the regions to be selected of the enterprise business respectively. It will be appreciated that the candidate region is an enterprise business covered region and also corresponds to the information type.
Since each region has a corresponding set of host tables, the set of host tables to be selected is determined as long as the region to be selected is determined. The region to be selected and the host table set to be selected corresponding to the region to be selected provide basis for the post operation executed by the user after the pre operation.
The information types comprise a first information type taking an input data set as a query mode; correspondingly, the outputting, by the host migration test auxiliary model, query result information covered by the enterprise service and corresponding to the information type according to the information type of the host migration test information includes:
And taking a preset region in the host migration test auxiliary model and a preset host table set corresponding to the region as the host table set to be selected and migration data coverage rate corresponding to each host table set to be selected respectively. The built host migration test auxiliary model comprises migration data coverage rate, a mapping relation between a preset area and a preset host table set, wherein the migration data coverage rate is the ratio of the data of the host tables in the preset host table set corresponding to the preset area to the data of all the host tables covered by enterprise business.
For example, the enterprise business is covered with 50 regions, the minimum preset regions required for migrating data coverage to reach 100% are 34, and the preset host table set is a host table set of the 34 regions.
The minimum preset areas required for the migration data coverage rate to reach 98% are 21, and the preset host table set is a host table set of the 21 areas.
The minimum preset areas required for migrating the data coverage rate to reach 95% are 14, and the preset host table set is a host table set of the 14 areas. Other preset areas and preset host table sets corresponding to the migration data coverage rate values are not described in detail.
If the query mode of the user is the first information type, the query result information corresponding to the first information type can be automatically output through the host migration test auxiliary model.
The query result information corresponding to the first information type is:
Migrating a host table set corresponding to 100% -34 regional names of the data coverage rate;
Migration data coverage rate is 98% -21, and host table sets corresponding to the regional names-21;
And migrating the host table set corresponding to 95% -14 regional names of the data coverage rate. Because the host table names in the host table set are more, the host table names can be hidden by default, and when the user clicks to cancel the hiding, the hidden host table names are displayed again.
The information type comprises a second information type taking the coverage rate of input migration data as a query mode; correspondingly, the outputting, by the host migration test auxiliary model, query result information covered by the enterprise service and corresponding to the information type according to the information type of the host migration test information includes:
And acquiring a region to be selected corresponding to the migration data coverage rate based on the host migration test auxiliary model, and acquiring a set of host table to be selected corresponding to the region to be selected. The user inputs the expected migration data coverage rate of 98% into the host migration test auxiliary model, and the host migration test auxiliary model outputs a host table set corresponding to the 21 region names. The query result information corresponding to the second information type is:
the host table sets corresponding to the 21 regional names and the 21 regional names can be hidden by default because of more host table names in the host table sets, and the hidden host table names are displayed when the user clicks to cancel the hiding.
In the step S3, the device responds to the second trigger action executed by the user according to the query result information, and obtains the test association information corresponding to the target host table name in the target host table set, so that the user performs the host migration test according to the test association information and the target host table corresponding to the target host table name.
The responding to the second triggering action executed by the user according to the query result information obtains the test association information corresponding to the target host table name in the target host table set, and the method comprises the following steps:
Responding to the selection operation of the user according to the migration data coverage rate corresponding to each host table set to be selected, and screening the target host table set from each host table set to be selected; when all areas do not finish host migration, the data set is the total data of all areas, but after the existing areas finish the host migration task, the host migration task does not need to consider the area any more, the user can acquire the host migration task finishing condition through the detection task, determine the corresponding set of host tables to be selected according to the migration data coverage rate, then reject the set of host tables in the finished areas from the set of host tables to be selected determined according to the migration data coverage rate according to the host migration task finishing condition, and take the rest set of host tables in the rest areas as the target set of host tables.
For example, the user takes 98% as the coverage rate of expected migration data, firstly determines that the host table set to be selected is the host table set corresponding to the 21 area names, and if 3 host migration tasks are completed in the 21 area names, the host table set corresponding to the remaining 18 area names is used as the target host table set, so that resource waste in the host migration test process can be independently and flexibly controlled.
And acquiring corresponding test association information according to the target host table names in the target host table set.
The responding to the second triggering action executed by the user according to the query result information obtains the test association information corresponding to the target host table name in the target host table set, and the method comprises the following steps:
responding to a confirmation operation carried out by the user according to the host table set to be selected, and taking the host table set to be selected as the target host table set; therefore, the migration test efficiency and the risk controllability of the host can be considered without excessive operation actions of users.
And acquiring corresponding test association information according to the target host table names in the target host table set.
As shown in fig. 2, prior to a first trigger action in response to a user querying host migration test information, data set scope processing may be advanced, as follows:
The invention can build the corresponding relation between the area code and the host table name, one area code can correspond to a plurality of host table names, the host table name is globally unique in the host table generation and data input stage, and the repeated host table names can not appear.
And on the basis of the corresponding relationship, establishing the corresponding relationship between the application name and the host table name to obtain an updated corresponding relationship. One application name may correspond to multiple host table names.
And on the basis of the updated corresponding relation, establishing the corresponding relation between the partition names and the host table names to obtain the final corresponding relation. One partition name may correspond to a plurality of host table names, one partition name may correspond to a plurality of application names, and one application name may also correspond to a plurality of partition names. Partition refers to a database partition of an enterprise.
The final correspondence is shown in table 1:
TABLE 1
| Sequence number | Partition(s) | Application name | Host table name | Land area code |
| 1 | EB01 | F-XXXX | TABLE1 | XXX |
| 2 | EB01 | F-XXXX | TABLE2 | XXX |
| 3 | EB01 | F-XXXX | TABLE3 | XXX |
The obtaining the test association information corresponding to the target host table name in the target host table set includes:
and acquiring the partition and the application name corresponding to the target host table name. And obtaining the partition and the application name corresponding to the target host table name according to the final corresponding relation.
The above-mentioned obtaining of the corresponding test association information according to the target host table name in the target host table set may also be implemented according to the final correspondence represented in table 1.
Establishing the host migration test auxiliary model, which comprises the following steps:
Acquiring a host table set which is covered by enterprise business and corresponds to each region respectively; each host table set comprises a host table name corresponding to each region respectively; the complete set of host tables corresponding to all regions is denoted as U, which includes the set of host tables corresponding to each region separately.
Acquiring a preselected host table set with the most repeated host table names in the host table complete set corresponding to all areas, and acquiring a complement set of the preselected host table set relative to the host table complete set; one preselected host table set Ai with the most repeated host table names with U is selected from the host table sets corresponding to each region, and the complement set of Ai relative to U is recorded as U1.
And replacing the host table complete set by using the complement set, continuously executing to acquire one pre-selected host table set with the most repeated host table names in the host table complete set corresponding to all areas, and acquiring the complement set of the pre-selected host table set relative to the host table complete set until the newly acquired complement set meets the preset termination condition, and acquiring the preset area and the preset host table set corresponding to the preset area. The preset termination conditions may be determined based on migration data coverage, such as 100%, 98%, 95%, etc.
Using U1 to replace U, a preselected set of host tables Aj with the most duplicate host table names to U1 is obtained, with Aj being noted as U2 relative to the complement of U1.
And replacing U1 by using U2, acquiring a preselected host table set Ak with the most repeated host table names corresponding to the U2, recording the complement of the Ak relative to the U2 as U3, and the like, if the corresponding migration data coverage rate is more than 95% and less than 98% when the complement is UM, terminating the subsequent steps if the preset termination condition is the migration data coverage rate threshold value of 95%, and taking all preselected areas at the moment and the preselected host table set corresponding to the preselected areas as preset areas and the preset host table set corresponding to the preset areas.
If the preset termination condition is 98% of the migration data coverage rate threshold value, executing the complement iterative calculation until the corresponding migration data coverage rate is greater than 98% when the complement is UN, terminating the subsequent steps, and taking all the preselect areas and the preselect host table sets corresponding to the preselect areas as the preset areas and the preset host table sets corresponding to the preselect areas.
According to the invention, the greedy algorithm is used for carrying out iterative local optimal calculation, so that the global calculation amount is greatly reduced, and the resource consumption is reduced from the perspective of calculating the resource consumption.
In addition, the risk controllability of the host migration is ensured by independently and flexibly setting the preset termination condition, and the host migration test efficiency and the risk controllability can be considered by respectively corresponding to different method steps through two information types.
According to the host migration test method provided by the embodiment of the invention, a first trigger action of inquiring host migration test information by a user is responded, and a pre-established host migration test auxiliary model is called; outputting query result information which is covered by the enterprise business and corresponds to the information type through the host migration test auxiliary model according to the information type of the host migration test information; the inquiry result information comprises a to-be-selected host table set corresponding to the to-be-selected areas of the enterprise business respectively; and responding to a second triggering action executed by the user according to the query result information, acquiring test association information corresponding to a target host table name in a target host table set, so that the user can carry out host migration test according to the test association information and the target host table corresponding to the target host table name, and reasonably selecting a host table and test association information used for participating in the host migration test by assisting the user, so that migration data are used in a small amount of host tables and covered as comprehensively as possible, the host migration test efficiency and risk controllability are considered, and the resource waste phenomenon in the host migration test process is reduced.
Further, the information types comprise a first information type taking an input data set as a query mode; correspondingly, the outputting, by the host migration test auxiliary model, query result information covered by the enterprise service and corresponding to the information type according to the information type of the host migration test information includes:
And taking a preset region in the host migration test auxiliary model and a preset host table set corresponding to the region as the host table set to be selected and migration data coverage rate corresponding to each host table set to be selected respectively. The description of the embodiments may be referred to above, and will not be repeated.
The host migration test method provided by the embodiment of the invention can accurately acquire the query result information corresponding to the first information type.
Further, the responding to the second trigger action executed by the user according to the query result information obtains test association information corresponding to the target host table name in the target host table set, including:
Responding to the selection operation of the user according to the migration data coverage rate corresponding to each host table set to be selected, and screening the target host table set from each host table set to be selected; the description of the embodiments may be referred to above, and will not be repeated.
And acquiring corresponding test association information according to the target host table names in the target host table set. The description of the embodiments may be referred to above, and will not be repeated.
The host migration test method provided by the embodiment of the invention can autonomously and flexibly control the resource waste in the host migration test process.
Further, the information type comprises a second information type taking the coverage rate of input migration data as a query mode; correspondingly, the outputting, by the host migration test auxiliary model, query result information covered by the enterprise service and corresponding to the information type according to the information type of the host migration test information includes:
And acquiring a region to be selected corresponding to the migration data coverage rate based on the host migration test auxiliary model, and acquiring a set of host table to be selected corresponding to the region to be selected. The description of the embodiments may be referred to above, and will not be repeated.
The host migration test method provided by the embodiment of the invention can accurately acquire the query result information corresponding to the second information type.
Further, the responding to the second trigger action executed by the user according to the query result information obtains test association information corresponding to the target host table name in the target host table set, including:
Responding to a confirmation operation carried out by the user according to the host table set to be selected, and taking the host table set to be selected as the target host table set; the description of the embodiments may be referred to above, and will not be repeated.
And acquiring corresponding test association information according to the target host table names in the target host table set. The description of the embodiments may be referred to above, and will not be repeated.
The host migration test method provided by the embodiment of the invention can give consideration to the host migration test efficiency and controllable risk without excessive operation actions of users.
Further, the obtaining the test association information corresponding to the target host table name in the target host table set includes:
and acquiring the partition and the application name corresponding to the target host table name. The description of the embodiments may be referred to above, and will not be repeated.
According to the host migration test method provided by the embodiment of the invention, the host migration test can be assisted to be completed smoothly by comprehensively acquiring the information.
Further, establishing the host migration test auxiliary model includes:
Acquiring a host table set which is covered by enterprise business and corresponds to each region respectively; each host table set comprises a host table name corresponding to each region respectively; the description of the embodiments may be referred to above, and will not be repeated.
Acquiring a preselected host table set with the most repeated host table names in the host table complete set corresponding to all areas, and acquiring a complement set of the preselected host table set relative to the host table complete set; the description of the embodiments may be referred to above, and will not be repeated.
And replacing the host table complete set by using the complement set, continuously executing to acquire one pre-selected host table set with the most repeated host table names in the host table complete set corresponding to all areas, and acquiring the complement set of the pre-selected host table set relative to the host table complete set until the newly acquired complement set meets the preset termination condition, and acquiring the preset area and the preset host table set corresponding to the preset area. The description of the embodiments may be referred to above, and will not be repeated.
The host migration test method provided by the embodiment of the invention further considers the host migration test efficiency and the risk controllability, and further reduces the resource waste phenomenon in the host migration test process.
It should be noted that, the host migration test method provided by the embodiment of the present invention may be used in the financial field, and may also be used in any technical field other than the financial field.
Fig. 3 is a schematic structural diagram of a host migration testing apparatus according to an embodiment of the present invention, and as shown in fig. 3, the host migration testing apparatus according to an embodiment of the present invention includes a calling unit 301, an output unit 302, and a testing unit 303, where:
The calling unit 301 is configured to respond to a first trigger action of a user for querying host migration test information, and call a pre-established host migration test auxiliary model; the output unit 302 is configured to output, according to an information type of the host migration test information, query result information that is covered by the enterprise service and corresponds to the information type through the host migration test auxiliary model; the inquiry result information comprises a to-be-selected host table set corresponding to the to-be-selected areas of the enterprise business respectively; the test unit 303 is configured to obtain, in response to a second trigger action executed by the user according to the query result information, test association information corresponding to a target host table name in the target host table set, so that the user performs a host migration test according to the test association information and the target host table corresponding to the target host table name.
Specifically, the calling unit 301 in the device is configured to respond to a first trigger action of a user for querying host migration test information, and call a pre-established host migration test auxiliary model; the output unit 302 is configured to output, according to an information type of the host migration test information, query result information that is covered by the enterprise service and corresponds to the information type through the host migration test auxiliary model; the inquiry result information comprises a to-be-selected host table set corresponding to the to-be-selected areas of the enterprise business respectively; the test unit 303 is configured to obtain, in response to a second trigger action executed by the user according to the query result information, test association information corresponding to a target host table name in the target host table set, so that the user performs a host migration test according to the test association information and the target host table corresponding to the target host table name.
According to the host migration testing device provided by the embodiment of the invention, the first trigger action of inquiring the host migration testing information by a user is responded, and a pre-established host migration testing auxiliary model is called; outputting query result information which is covered by the enterprise business and corresponds to the information type through the host migration test auxiliary model according to the information type of the host migration test information; the inquiry result information comprises a to-be-selected host table set corresponding to the to-be-selected areas of the enterprise business respectively; and responding to a second triggering action executed by the user according to the query result information, acquiring test association information corresponding to a target host table name in a target host table set, so that the user can carry out host migration test according to the test association information and the target host table corresponding to the target host table name, and reasonably selecting a host table and test association information used for participating in the host migration test by assisting the user, so that migration data are used in a small amount of host tables and covered as comprehensively as possible, the host migration test efficiency and risk controllability are considered, and the resource waste phenomenon in the host migration test process is reduced.
Further, the information types comprise a first information type taking an input data set as a query mode; correspondingly, the output unit 302 is specifically configured to:
and taking a preset region in the host migration test auxiliary model and a preset host table set corresponding to the region as the host table set to be selected and migration data coverage rate corresponding to each host table set to be selected respectively.
The host migration testing device provided by the embodiment of the invention can accurately acquire the query result information corresponding to the first information type.
Further, the test unit 303 is specifically configured to:
responding to the selection operation of the user according to the migration data coverage rate corresponding to each host table set to be selected, and screening the target host table set from each host table set to be selected;
and acquiring corresponding test association information according to the target host table names in the target host table set.
The host migration testing device provided by the embodiment of the invention can autonomously and flexibly control the resource waste in the host migration testing process.
Further, the information type comprises a second information type taking the coverage rate of input migration data as a query mode; correspondingly, the output unit 302 is specifically configured to:
and acquiring a region to be selected corresponding to the migration data coverage rate based on the host migration test auxiliary model, and acquiring a set of host table to be selected corresponding to the region to be selected.
The host migration testing device provided by the embodiment of the invention can accurately acquire the query result information corresponding to the second information type.
Further, the test unit 303 is specifically configured to:
Responding to a confirmation operation carried out by the user according to the host table set to be selected, and taking the host table set to be selected as the target host table set;
and acquiring corresponding test association information according to the target host table names in the target host table set.
The host migration testing device provided by the embodiment of the invention can give consideration to the host migration testing efficiency and controllable risk without excessive operation actions of users.
Further, the test unit 303 is specifically configured to:
and acquiring the partition and the application name corresponding to the target host table name.
The host migration testing device provided by the embodiment of the invention can assist the host migration test to be successfully completed by comprehensively acquiring the information.
Further, the host migration testing device is further configured to:
Acquiring a host table set which is covered by enterprise business and corresponds to each region respectively; each host table set comprises a host table name corresponding to each region respectively;
Acquiring a preselected host table set with the most repeated host table names in the host table complete set corresponding to all areas, and acquiring a complement set of the preselected host table set relative to the host table complete set;
And replacing the host table complete set by using the complement set, continuously executing to acquire one pre-selected host table set with the most repeated host table names in the host table complete set corresponding to all areas, and acquiring the complement set of the pre-selected host table set relative to the host table complete set until the newly acquired complement set meets the preset termination condition, and acquiring the preset area and the preset host table set corresponding to the preset area.
The host migration testing device provided by the embodiment of the invention further considers the host migration testing efficiency and the risk controllability, and further reduces the resource waste phenomenon in the host migration testing process.
The embodiment of the present invention provides a process flow of the embodiment of the host migration testing device, which can be specifically used to execute the above method embodiments, and the functions thereof are not described herein again, and reference may be made to the detailed description of the above method embodiments.
Fig. 4 is a schematic diagram of an entity structure of an electronic device according to an embodiment of the present invention, as shown in fig. 4, where the electronic device includes: a processor (processor) 401, a memory (memory) 402, and a bus 403;
Wherein, the processor 401 and the memory 402 complete the communication with each other through the bus 403;
the processor 401 is configured to call the program instructions in the memory 402 to perform the methods provided in the above method embodiments, for example, including:
responding to a first trigger action of inquiring host migration test information by a user, and calling a pre-established host migration test auxiliary model;
outputting query result information which is covered by the enterprise business and corresponds to the information type through the host migration test auxiliary model according to the information type of the host migration test information; the inquiry result information comprises a to-be-selected host table set corresponding to the to-be-selected areas of the enterprise business respectively;
and responding to a second trigger action executed by the user according to the query result information, and acquiring test association information corresponding to a target host table name in a target host table set so as to enable the user to carry out host migration test according to the test association information and the target host table corresponding to the target host table name.
The present embodiment discloses a computer program product comprising a computer program stored on a non-transitory computer readable storage medium, the computer program comprising program instructions which, when executed by a computer, are capable of performing the methods provided by the above-described method embodiments, for example comprising:
responding to a first trigger action of inquiring host migration test information by a user, and calling a pre-established host migration test auxiliary model;
outputting query result information which is covered by the enterprise business and corresponds to the information type through the host migration test auxiliary model according to the information type of the host migration test information; the inquiry result information comprises a to-be-selected host table set corresponding to the to-be-selected areas of the enterprise business respectively;
and responding to a second trigger action executed by the user according to the query result information, and acquiring test association information corresponding to a target host table name in a target host table set so as to enable the user to carry out host migration test according to the test association information and the target host table corresponding to the target host table name.
The present embodiment provides a computer-readable storage medium storing a computer program that causes the computer to execute the methods provided by the above-described method embodiments, for example, including:
responding to a first trigger action of inquiring host migration test information by a user, and calling a pre-established host migration test auxiliary model;
outputting query result information which is covered by the enterprise business and corresponds to the information type through the host migration test auxiliary model according to the information type of the host migration test information; the inquiry result information comprises a to-be-selected host table set corresponding to the to-be-selected areas of the enterprise business respectively;
and responding to a second trigger action executed by the user according to the query result information, and acquiring test association information corresponding to a target host table name in a target host table set so as to enable the user to carry out host migration test according to the test association information and the target host table corresponding to the target host table name.
It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention 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 flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations 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.
In the description of the present specification, reference to the terms "one embodiment," "one particular embodiment," "some embodiments," "for example," "an example," "a particular example," or "some examples," etc., means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the invention. In this specification, schematic representations of the above terms do not necessarily refer to the same embodiments or examples. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.
The foregoing description of the embodiments has been provided for the purpose of illustrating the general principles of the invention, and is not meant to limit the scope of the invention, but to limit the invention to the particular embodiments, and any modifications, equivalents, improvements, etc. that fall within the spirit and principles of the invention are intended to be included within the scope of the invention.
Claims (10)
1. A host migration testing method, comprising:
responding to a first trigger action of inquiring host migration test information by a user, and calling a pre-established host migration test auxiliary model;
outputting query result information which is covered by the enterprise business and corresponds to the information type through the host migration test auxiliary model according to the information type of the host migration test information; the inquiry result information comprises a to-be-selected host table set corresponding to the to-be-selected areas of the enterprise business respectively;
and responding to a second trigger action executed by the user according to the query result information, and acquiring test association information corresponding to a target host table name in a target host table set so as to enable the user to carry out host migration test according to the test association information and the target host table corresponding to the target host table name.
2. The host migration testing method of claim 1, wherein the information types include a first information type having an input data set as a query; correspondingly, the outputting, by the host migration test auxiliary model, query result information covered by the enterprise service and corresponding to the information type according to the information type of the host migration test information includes:
and taking a preset region in the host migration test auxiliary model and a preset host table set corresponding to the region as the host table set to be selected and migration data coverage rate corresponding to each host table set to be selected respectively.
3. The method of claim 2, wherein the responding to the second trigger action executed by the user according to the query result information obtains test association information corresponding to the target host table name in the target host table set, and the method comprises:
responding to the selection operation of the user according to the migration data coverage rate corresponding to each host table set to be selected, and screening the target host table set from each host table set to be selected;
and acquiring corresponding test association information according to the target host table names in the target host table set.
4. The host migration testing method of claim 1, wherein the information type comprises a second information type having an input migration data coverage as a query; correspondingly, the outputting, by the host migration test auxiliary model, query result information covered by the enterprise service and corresponding to the information type according to the information type of the host migration test information includes:
and acquiring a region to be selected corresponding to the migration data coverage rate based on the host migration test auxiliary model, and acquiring a set of host table to be selected corresponding to the region to be selected.
5. The method of claim 4, wherein the responding to the second trigger action executed by the user according to the query result information obtains test association information corresponding to the target host table name in the target host table set, and the method comprises:
Responding to a confirmation operation carried out by the user according to the host table set to be selected, and taking the host table set to be selected as the target host table set;
and acquiring corresponding test association information according to the target host table names in the target host table set.
6. The method for testing host migration according to claim 1, wherein the obtaining test association information corresponding to a target host table name in the target host table set includes:
and acquiring the partition and the application name corresponding to the target host table name.
7. The method for testing host migration according to any one of claims 1 to 6, wherein establishing the host migration test auxiliary model comprises:
Acquiring a host table set which is covered by enterprise business and corresponds to each region respectively; each host table set comprises a host table name corresponding to each region respectively;
Acquiring a preselected host table set with the most repeated host table names in the host table complete set corresponding to all areas, and acquiring a complement set of the preselected host table set relative to the host table complete set;
And replacing the host table complete set by using the complement set, continuously executing to acquire one pre-selected host table set with the most repeated host table names in the host table complete set corresponding to all areas, and acquiring the complement set of the pre-selected host table set relative to the host table complete set until the newly acquired complement set meets the preset termination condition, and acquiring the preset area and the preset host table set corresponding to the preset area.
8. A host migration testing apparatus, comprising:
The calling unit is used for responding to a first trigger action of inquiring the host migration test information by a user and calling a pre-established host migration test auxiliary model;
The output unit is used for outputting query result information which is covered by the enterprise business and corresponds to the information type through the host migration test auxiliary model according to the information type of the host migration test information; the inquiry result information comprises a to-be-selected host table set corresponding to the to-be-selected areas of the enterprise business respectively;
And the test unit is used for responding to the second trigger action executed by the user according to the query result information, and obtaining test association information corresponding to the target host table name in the target host table set so as to enable the user to carry out host migration test according to the test association information and the target host table corresponding to the target host table name.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the steps of the method of any one of claims 1 to 7 when the computer program is executed by the processor.
10. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410130023.8A CN117891746A (en) | 2024-01-30 | 2024-01-30 | Host migration testing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410130023.8A CN117891746A (en) | 2024-01-30 | 2024-01-30 | Host migration testing method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117891746A true CN117891746A (en) | 2024-04-16 |
Family
ID=90648793
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202410130023.8A Pending CN117891746A (en) | 2024-01-30 | 2024-01-30 | Host migration testing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117891746A (en) |
-
2024
- 2024-01-30 CN CN202410130023.8A patent/CN117891746A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106033436B (en) | Database merging method | |
| DE112019005586T5 (en) | SCALAR PRODUCT CALCULATOR AND PROCEDURES FOR THEIR OPERATION | |
| CN106557307B (en) | Service data processing method and system | |
| CN110275889B (en) | Feature processing method and device suitable for machine learning | |
| CN113760476B (en) | Task dependency processing method and related device | |
| CN110941251A (en) | Production control method, device, equipment and medium based on digital twin body | |
| CN113553313A (en) | Data migration method and system, storage medium and electronic device | |
| CN109753573A (en) | A kind of processing method and processing device based on chart database building preset model | |
| CN113535225B (en) | Environment configuration file processing method, device, equipment and medium of application software | |
| CN104050291A (en) | Parallel processing method and system for account balance data | |
| CN110909888A (en) | Method, device and equipment for constructing generic decision tree and readable storage medium | |
| CN114239237A (en) | Power distribution network simulation scene generation system and method supporting digital twinning | |
| CN117891746A (en) | Host migration testing method and device | |
| CN113064674A (en) | Method and device for expanding state machine logic, storage medium and electronic device | |
| CN111160403B (en) | API (application program interface) multiplexing discovery method and device | |
| Stankute et al. | A data fusion system for spatial data mining, analysis and improvement | |
| CN112905720A (en) | Operation data processing method and device based on source data management model | |
| CN112015398A (en) | Data fusion method and device | |
| CN108958917A (en) | The method for scheduling task and system of cloud computing | |
| CN112506944B (en) | Data standard conversion access method, device, equipment and medium between service systems | |
| CN111858387B (en) | Data preparation method and device | |
| CN116382666B (en) | Project execution method and system based on artificial intelligence model | |
| CN111552561B (en) | Task processing method and device | |
| CN115237409A (en) | Method, device, equipment and storage medium for controlling node operation authority | |
| CN115543300A (en) | Service data processing method and device |
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 |