CN106126542B - A kind of management method of access path - Google Patents
A kind of management method of access path Download PDFInfo
- Publication number
- CN106126542B CN106126542B CN201610424517.2A CN201610424517A CN106126542B CN 106126542 B CN106126542 B CN 106126542B CN 201610424517 A CN201610424517 A CN 201610424517A CN 106126542 B CN106126542 B CN 106126542B
- Authority
- CN
- China
- Prior art keywords
- access path
- environment
- target
- source
- stored
- 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.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/13—File access structures, e.g. distributed indices
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Debugging And Monitoring (AREA)
Abstract
The present invention provides a kind of management methods of access path, environment is tested with the source that target environment matches by establishing one, and the correlation table data of the target environment are imported create in source test environment first using table, later, according to the correlation table data imported in the first application table, business simulating and simulation are carried out in source environment, the first statistical information is generated after amendment, so that metastable statistical information can adapt to the continuous variation of data in table, and the update that statistical information is carried out in source test environment can reduce target environment system operating time, reduce the consumption of system resource, source routine access path and target program access path are generated respectively according to first statistical information again, it is saved after comparison and compares inconsistent result data, and then facilitate manual analysis and amendment , solve the problems, such as the hysteresis quality of access path management.
Description
Technical field
The present invention relates to field of computer technology, and more specifically, it relates to a kind of management methods of access path.
Background technique
DB2 is a set of Relational DBMS of IBM Corporation, U.S. exploitation, is mainly used in large-scale application system
System calculates by query optimizer and provides access path, and then improves program and the data query performance of user, and support more
Task parallel query.
Currently, the existing method using DB2 calculating, generation and maintenance access path is to first pass through RUNSTAT etc.
UTILITY tool carries out the calculating and collection of statistical information to correlation table, and charges in DB2CATALOG；Later, for static state
SQL then carries out BIND or REBIND operation, generates the access path of program, while by the optimizer of DB2 according to CATALOG
Statistical information theoretical optimal access path is calculated in program BIND, and in user's caller or operation SQL, utilize
The access path of generation accesses to correlation table, at this point, if it is calculated theory access path be not it is optimal, there is performance
Problem, and then need to carry out manual analysis and correct this access path；For dynamic sql, then it is called in program or SQL is executed
When, the optimizer of DB2 accesses the determination in path according to CATALOG information, and is accessed using this access path to table.
However, when DB2 is calculated and generates access path, since the statistical information of table in DB2CATALOG information cannot be real
Shi Gengxin, but the data of table may then change at any time, so that for calculating the statistical information tool of access path in CATALOG
There is time point, the CATALOG collected in a certain time point is caused to be difficult to be universally adapted to the continually changing table of data, causes originally good
Access path can deteriorate suddenly with the variation of data in table；Secondly, passing through when statistical information in collecting CATALOG
The mode of RUNSTAT can make the system resource overheads such as CPU larger, cannot frequently execute；And at maintenance access path, due to
Manual analysis can only be carried out again when there is performance issue and is intervened to correct, and cause the extensive management of access path, there is lag
Property.
Summary of the invention
In view of this, the present invention provides a kind of management method of access path, and then realize metastable statistics letter
Breath can adapt to the continuous variations of data in table, and can quick and low consumed updates CATALOG information, and solve to access
The hysteresis quality problem of the management in path, reach prevents in advance.
To achieve the above object, the invention provides the following technical scheme:
A kind of management method of access path, comprising:
Source test environment is established, the source test environment matches with target environment；
Table is applied in creation first in source test environment, and imports the correlation table data of the target environment,
In, the correlation table data are to need to calculate the data of the table of access path；
According to the correlation table data imported in the first application table, the first statistical information is generated, and be stored in the first letter
Cease table；
According to first statistical information, source routine access path is generated in source test environment, and is saved
In the first correlation table；
First statistical information is imported into the target environment；
According to first statistical information imported, target program access path is generated in the target environment, and protect
There are in the second correlation table；
First correlation table and second correlation table are compared, and saves and compares inconsistent result data.
It is preferably, described that first statistical information is imported into the target environment, comprising:
First statistical information is extracted from the first information table；
First statistical information is stored in the first file, first file is built in source test environment
It is vertical；
First file is imported into the target environment；
First statistical information being stored in first file is imported into the target environment.
Preferably, described that first statistical information being stored in first file is imported into the target ring
Border, comprising:
When judging to establish the second application table corresponding with the first application table in the target environment, by described the
One statistical information imports the second information table in the target environment；
When judging not setting up the second application table corresponding with the first application table in the target environment, according to described in
Described first in source test environment applies table, establishes in the target environment and the first application table is corresponding described
Second applies table, and first statistical information is imported to second information table in the target environment.
Preferably, the second application corresponding with the first application table is established in the target environment in the judgement
When table, first statistical information is imported before second information table in the target environment, further includes:
When judging that the structure of the second application table and the first application table is inconsistent, rebuild in the target environment
Described second applies table.
Preferably, comparison first correlation table and second correlation table, and save and compare inconsistent result
Data, comprising:
The first temporary visit routing table, the second temporary visit routing table and access path are established in the target environment
Contrast table；
Source routine access path is collected, and is stored in the first temporary visit routing table；
The target program access path is collected, and is stored in the second temporary visit routing table；
Compare the first temporary visit routing table and the second temporary visit routing table；
Inconsistent result data will be compared and be stored in the access path contrast table.
Preferably, the collection source routine access path, and it is stored in the first temporary visit routing table, it wraps
It includes:
Obtain the source program listing in source test environment, wherein the source program listing includes and needs
Source program corresponding to the source routine access path compared；
Third temporary visit routing table is established in source test environment, wherein third temporary visit path
Table is identical as the structure of the first temporary visit routing table；
The source routine access path in the source program listing is parsed, and is stored in third temporary visit path
Table；
The source routine access path being stored into the third temporary visit routing table is stored in the second file,
Second file is established in source test environment；
Source routine access path in second file is imported into the first temporary visit routing table.
Preferably, described to collect the target program access path, and it is stored in the second temporary visit routing table, it wraps
It includes:
Obtain the target program inventory in the target environment, wherein the target program inventory includes and needs to carry out
Target side program corresponding to the target program access path of comparison；
The target program access path in the target program inventory is parsed, and is stored in second temporary visit path
Table.
Preferably, it will be compared after inconsistent result data is stored in the access path contrast table described, further includes:
Access path comparing result table is established in the target environment；
Result data in the access path contrast table is stored in the access path comparing result table.
It can be seen via above technical scheme that compared with prior art, the present invention provides a kind of management of access path
Method tests environment with the source that target environment matches by establishing one, and created in source test environment
The correlation table data of the target environment are imported in first application table, later, according to the correlation imported in the first application table
Table data carry out a series of business simulating and simulation in source environment, and constantly amendment generates the first statistics letter on this basis
Breath so that metastable statistical information can adapt to the continuous variation of data in table, and tests environment in the source
The middle update for carrying out statistical information can reduce system operating time, reduce the consumption of system resource, then according to first system
It counts information and generates source routine access path, be stored in the first correlation table, and first statistical information is imported into the target
Environment generates target program access path, is stored in the second correlation table, and it is related to described second to compare first correlation table
Table, and save and compare inconsistent result data, and then facilitate manual analysis and amendment, solve the lag of access path management
Property problem.
Detailed description of the invention
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
The embodiment of invention for those of ordinary skill in the art without creative efforts, can also basis
The attached drawing of offer obtains other attached drawings.
Fig. 1 is a kind of management method flow chart of access path provided in an embodiment of the present invention；
Fig. 2 is a kind of method flow diagram of first statistical information of importing provided in an embodiment of the present invention to target environment；
Fig. 3 is a kind of method flow diagram for comparing the first correlation table and the second correlation table provided in an embodiment of the present invention；
Fig. 4 is the method flow diagram in a kind of collection provided in an embodiment of the present invention and preservation source routine access path；
Fig. 5 is the method flow diagram of a kind of collection provided in an embodiment of the present invention and preservation target program access path.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, it is obtained by those of ordinary skill in the art without making creative efforts every other
Embodiment shall fall within the protection scope of the present invention.
The embodiment of the invention provides a kind of management methods of access path, refer to attached drawing 1, the method specifically includes
Following steps:
Step 101: establishing source test environment, the source test environment matches with target environment；
Specifically, being acted by using environmental structure identical with the target environment, produce and the target environment
The source test environment to match, wherein source test environment possesses ZPARM ginseng identical with the target environment
It counts setting, the setting of the POOL such as BUFFER POOL, SORT POOL, RID POOL, CPU parameter and table structure and applies frame
Structure.
Step 102: table is applied in creation first in source test environment, and imports the correlation table of the target environment
Data, wherein the correlation table data are to need to calculate the data of the table of access path；
Specifically, the correlation table data for the first application table importeding into the source test environment are the target environment
Need to calculate the existing total data of correlation using table of access path, the real data respectively arranged such as each row existing in table.
Step 103: according to the correlation table data imported in the first application table, generating the first statistical information, and save
In first information table；
Specifically, by the related data of the table for needing to calculate access path imported in the first application table, described
Source tests environment and carries out a large amount of simulation and emulation, so realize carried out in the source test environment mock trading,
The operation such as simulation of bulk；After dry run after a period of time, operated by RUNSTAT carry out statistical information collection,
It updates, to obtain first statistical information, and in the first information table being stored in the source test environment, described the
One information table can be CATALOG table, finally realize the simulation of the statistical information to the development trend estimated.
Step 104: according to first statistical information, generating source routine access road in source test environment
Diameter, and be stored in the first correlation table；
Specifically, generating the visit of static embeded SQL by BIND or the REBIND operation of program in source test environment
Diameter of asking the way carries out the generation of the access path of dynamic sql through first statistical information when program is run or SQL is executed.
Step 105: first statistical information is imported into the target environment；
It, can will be described specifically, run first statistical information in a manner of executing SQL in the target environment
First statistical information is imported into the target environment.
Step 106: according to first statistical information imported, generating target program in the target environment and access road
Diameter, and be stored in the second correlation table；
Specifically, generating the access road of static embeded SQL by BIND or the REBIND operation of program in the target environment
Diameter carries out the generation of the access path of dynamic sql through first statistical information when program is run or SQL is executed.
Step 107: comparison first correlation table and second correlation table, and save and compare inconsistent number of results
According to；
Specifically, by being saved in the source routine access path saved in first correlation table and second correlation table
Target program access path compare the inconsistent access path obtained and saved, so as to also not according to the life
At access path search corresponding resource before, realize artificial control and analysis.
In the management method of access path disclosed by the embodiments of the present invention, matched by foundation with the target environment
The source tests environment, and according to the correlation table data imported from the target environment, generates the first statistical information, and protect
There are first information tables, so that both having realized metastable statistical information adapts to the continually changing table of data, also achieve fast
Statistical information is updated to fast and low consumption, first statistical information is imported into the target environment later, generates corresponding mesh
Beacon course sequence access path, and be stored in second correlation table, first correlation table and second correlation table are compared, and
Save and compare inconsistent result data, so conveniently also not according to the access path of the generation search corresponding resource it
Before, it realizes artificial control and analysis, solves the problems, such as the hysteresis quality of access path.
Please refer to attached drawing 2, the specific implementation process of the step 105 provided in above-described embodiment the following steps are included:
Step 201: first statistical information is extracted from the first information table.
Step 202: first statistical information being stored in the first file, first file is tested in the source
It is established in environment.
Step 203: first file is imported into the target environment；
Specifically, the first statistical information in the first information table in the source test environment will can not be directly stored in
It imported into the target environment, it is therefore desirable to first statistical information that will first be extracted from the first information table
It is stored in the first file, then first file is dumped in the target environment.
Step 204: judging the second application corresponding with the first application table whether is established in the target environment
Table thens follow the steps 205a, if not setting up, thens follow the steps 205b if establishing；
Specifically, the source test environment is mutually matched with the related application table initial configuration in the target environment,
But after a section business analogue simulation, it is understood that there may be the case where related application table structure changes, or because business development is fixed
The new related application table of justice, thus need first to judge in institute when importing first statistical information in the target environment
It states and second application identical with the first application table corresponding to the first information table whether has had been established in target environment
Table；Only in the case where the first application table and the second application table exact matching, it could be stored in second information table
First statistical information imported, wherein second information table can be CATALOG table.
Step 205a: judging whether the second application table is consistent with the structure of the first application table, if inconsistent,
Step 206 is executed, if unanimously, thening follow the steps 207；
Specifically, the source test environment is mutually matched with the related application table initial configuration in the target environment,
But after a section business analogue simulation, it is understood that there may be the case where related application table structure changes, thus also need to judge
When the second application table structure established in the target environment is identical as the first application table structure, just it can be carried out described
The importing of first statistical information.
Step 205b: table is applied according to described first in source test environment, is established in the target environment
Table is applied with the first application table corresponding described second, and executes step 207.
Step 206: rebuilding described second in the target environment using table, and execute step 207；
It is answered specifically, having been had been established in the target environment to first statistical information relevant first to be imported
Second applies table corresponding to table, but when the structure of the second application table and the not identical structure of the first application table,
Existing described second is deleted using table, later the structure according to the first application table again, establishes one and same answer
With table, table is applied as described second；Only in the first application table and completely the same the second application table structure, second letter
Breath table could be used to store first statistical information.
Step 207: first statistical information being stored in first file is imported into the target environment
Second information table.
In the embodiment of the present invention, by when first statistical information is imported the target environment, first from described the
First statistical information is extracted in one information table, and is saved it in first file, thus described in smoothly importing
In target environment, successively judge that first statistical information whether established to imported in the target environment is relevant again later
Second applies table corresponding to first application table, and judges whether the structure of the second application table and the first application table
Unanimously, first statistical information in first file is imported again after meeting condition, and then meets the target ring
The condition that border and source test environment match, and subsequent count in the target environment using described first is facilitated to believe
Breath generates target program access path.
Please refer to attached drawing 3, the specific implementation process of the step 107 provided in above-described embodiment the following steps are included:
Step 301: established in the target environment the first temporary visit routing table, the second temporary visit routing table and
Access path contrast table；
Specifically, the first temporary visit routing table is consistent with the structure of the second temporary visit routing table, but the institute of table
The person of having is different, can store different data；The access path contrast table for be stored in the first temporary visit routing table with
The different data entry of access path in second temporary visit routing table, and the result being stored in the access path contrast table
Data entry can with the variation of the first temporary visit routing table and the content in the second temporary visit routing table and it is automatic
Variation.
Step 302: collecting source routine access path, and be stored in the first temporary visit routing table；
Specifically, being stored in the target after the source is tested the source routine access Path-collection in environment
In the first temporary visit routing table established in environment.
Step 303: collecting the target program access path, and be stored in the second temporary visit routing table.
Step 304: comparison the first temporary visit routing table and the second temporary visit routing table；
Specifically, by comparing five in the first temporary visit routing table and the second temporary visit routing table
Whether field is completely the same to obtain whether to record in the first temporary visit routing table and the second temporary visit routing table
Same program SQL statement access path, wherein five fields be respectively as follows: QUERYNO, QBLOCKNO, PROGNAME,
PLANNO,MIXOPSEQ；If what is recorded in the first temporary visit routing table and the second temporary visit routing table is same
Program SQL statement access path, then again by 14 corresponding to the comparison same program SQL statement access path
Whether field is completely the same finally to obtain same in the first temporary visit routing table and the second temporary visit routing table
The inconsistent result data of program SQL statement access path, wherein 14 fields be respectively as follows: METHOD,
ACCESSTYPE、MATCHCOLS、ACCESSNAME、INDEXONLY、TSLOCKMODE、SORTN_UNIQ、SORTN_JOIN、
SORTN_ORDERBY、SORTN_GROUPBY、SORTC_UNIQ、SORTC_JOIN、SORTC_ORDERBY、SORTC_
GROUPBY。
Step 305: inconsistent result data will be compared and be stored in the access path contrast table；
Specifically, being obtained in the first temporary visit routing table and the second temporary visit routing table not when in comparison
When consistent result data entry, the content in the access path contrast table also can be with the first temporary visit routing table
Variation with the inconsistent result data entry in the second temporary visit routing table and be automatically updated into newest access path
Inconsistent result data entry.
Step 306: the result data in the access path contrast table is stored in the access path comparing result table, institute
Access path comparing result table is stated to establish in the target environment；
Specifically, the result data entry due to the deposit in the access path contrast table can be with described first temporarily
The variation of access path table and the content in the second temporary visit routing table and change automatically, for convenience of subsequent manual analysis,
Need to establish the access path comparing result table in the target environment, for saving the access at a certain moment at any time
Inconsistent result data in the contrast table of path facilitates the analysis and amendment for carrying out the later period.
In the embodiment of the present invention, road is accessed by collecting source routine access path and the target program respectively
Diameter, and respectively it is stored in the first temporary visit routing table and the second temporary visit routing table established in the target environment
In, and the access path that the inconsistent result data deposit obtained after comparison is established in the target environment is compared
Table, checks the inconsistent result data at a certain moment for the ease of the later period at any time, then by the inconsistent number of results
According to being stored in the access path comparing result table, and then early warning problem is realized, the purpose intervened in advance.
Please refer to attached drawing 4, the specific implementation process of the step 302 provided in above-described embodiment the following steps are included:
Step 401: obtaining the source program listing in the source test environment, the source program listing includes and needs
Source program corresponding to the source routine access path to be compared；
Specifically, source routine access path is stored in first correlation table in source test environment
In, and the source program listing is then a series of collection of source program listings of this Comparative Analysis on Tracks that needs to access
It closes, can select from first correlation table and match with it by the database name of such as program, COLLID of program etc.
Entry access path；At the same time it can also according to the needs of present analysis, customization database name DBNAME and COLLID
Value DCOLLID.
Step 402: establishing third temporary visit routing table, third temporary visit road in source test environment
Diameter table is identical as the structure of the first temporary visit routing table.
Step 403: parsing the source routine access path in the source program listing, and be stored in the third and temporarily visit
Ask routing table；
Specifically, using EXPLAIN SQL statement, by the number of program COLLID and program in the source program listing
It according to library name, is filled into stsndard SQL template, specifies the deposit third temporary visit routing table, then after SQL execution, meeting
The access path of current given COLLID and the program of name are resolved in the third temporary visit routing table.
Step 404: the source routine access path being stored into the third temporary visit routing table is stored in
In two files, second file is established in source test environment；
Specifically, being stored into the access road in the third temporary visit routing table using UNLOAD UTILITY tool
Diameter downloads in second file.
Step 405: the source routine access path in second file is imported into first temporary visit road
Diameter table；
Specifically, using LOAD tool, by the access path data in the file, according to specified format, a line a line
Importing the first temporary visit routing table.
In the embodiment of the present invention, by being tested in environment in the source, to comprising having gathered the source for needing to compare
The source program listing of source program corresponding to the routine access path of end is parsed, and the source routine access is acquired
Path, and be deposited into the third temporary visit routing table identical with the structure of the first temporary visit routing table,
The source routine access path in the deposit third temporary visit routing table is downloaded later to second file, and then is led again
Enter source routine access path to the first temporary visit routing table, thus facilitate it is subsequent in the same environment to two
The access path generated in a different environment compares and analyzes.
Please refer to attached drawing 5, the specific implementation process of the step 303 provided in above-described embodiment the following steps are included:
Step 501: obtaining the target program inventory in the target environment, the target program inventory includes to need to carry out
Target side program corresponding to the target program access path of comparison；
Specifically, the target program access path is stored in second correlation table in the target environment, and
The target program inventory is then a series of set of target side program listings of this Comparative Analysis on Tracks that needs to access,
It can be selected from second correlation table matched by the database name of such as program, COLLID of program etc.
The access path of entry；At the same time it can also according to the needs of present analysis, customization database name DBNAME and COLLID value
DCOLLID。
Step 502: parsing the target program access path in the target program inventory, and be stored in the described second interim visit
Ask routing table；
Specifically, using EXPLAIN SQL statement, by the number of program COLLID and program in the target program inventory
It according to library name, is filled into stsndard SQL template, specifies deposit the second temporary visit routing table, then after SQL execution, meeting
The access path of current given COLLID and the program of name are resolved in the second temporary visit routing table.
In the embodiment of the present invention, by the target environment, to comprising having gathered the target journey for needing to compare
The target program inventory of target side program corresponding to sequence access path is parsed, and target program access road is acquired
Diameter, and it is stored in the second temporary visit routing table, and then convenient for the later period to the access path generated in two different environment
It compares and analyzes.
The foregoing description of the disclosed embodiments enables those skilled in the art to implement or use the present invention.
Various modifications to these embodiments will be readily apparent to those skilled in the art, as defined herein
General Principle can be realized in other embodiments without departing from the spirit or scope of the present invention.Therefore, of the invention
It is not intended to be limited to the embodiments shown herein, and is to fit to and the principles and novel features disclosed herein phase one
The widest scope of cause.
Claims (8)
1. a kind of management method of access path, which is characterized in that the described method includes:
Source test environment is established, the source test environment matches with target environment；
Table is applied in creation first in source test environment, and imports the correlation table data of the target environment, wherein institute
Stating correlation table data is to need to calculate the data of the table of access path；
According to the correlation table data that import in the first application table, business simulating and simulation are carried out in source environment, generates the
One statistical information, and it is stored in first information table；
According to first statistical information, source routine access path is generated in source test environment, and is stored in the
In one correlation table；
First statistical information is imported into the target environment；
According to first statistical information imported, target program access path is generated in the target environment, and be stored in
In second correlation table；
First correlation table and second correlation table are compared, and saves and compares inconsistent result data.
2. the method according to claim 1, wherein described import the target ring for first statistical information
Border, comprising:
First statistical information is extracted from the first information table；
First statistical information is stored in the first file, first file is established in source test environment；
First file is imported into the target environment；
First statistical information being stored in first file is imported into the target environment.
3. according to the method described in claim 2, it is characterized in that, described first will be stored in first file
Statistical information imported into the target environment, comprising:
When judging to establish the second application table corresponding with the first application table in the target environment, described first is united
Meter information imports the second information table in the target environment；
When judging not setting up the second application table corresponding with the first application table in the target environment, according to the source
Described first tested in environment applies table, establishes in the target environment and applies table corresponding described second with described first
Using table, and first statistical information is imported to second information table in the target environment.
4. according to the method described in claim 3, it is characterized in that, being established in the target environment and institute in the judgement
When stating first the second application table corresponding using table, first statistical information is imported to described second in the target environment
Before information table, further includes:
When judging that the structure of the second application table and the first application table is inconsistent, rebuild described in the target environment
Second applies table.
5. the method according to claim 1, wherein comparison first correlation table is related to described second
Table, and save and compare inconsistent result data, comprising:
The first temporary visit routing table, the second temporary visit routing table and access path comparison are established in the target environment
Table；
Source routine access path is collected, and is stored in the first temporary visit routing table；
The target program access path is collected, and is stored in the second temporary visit routing table；
Compare the first temporary visit routing table and the second temporary visit routing table；
Inconsistent result data will be compared and be stored in the access path contrast table.
6. according to the method described in claim 5, it is characterized in that, the collection source routine access path, and being stored in
The first temporary visit routing table, comprising:
Obtain the source program listing in the source test environment, wherein the source program listing includes and needs to carry out
Source program corresponding to the source routine access path of comparison；
The source test environment in establish third temporary visit routing table, wherein the third temporary visit routing table with
The structure of the first temporary visit routing table is identical；
The source routine access path in the source program listing is parsed, and is stored in the third temporary visit routing table；
The source routine access path being stored into the third temporary visit routing table is stored in the second file, described
Second file is established in source test environment；
Source routine access path in second file is imported into the first temporary visit routing table.
7. according to the method described in claim 5, it is characterized in that, described collect the target program access path, and being stored in
The second temporary visit routing table, comprising:
Obtain the target program inventory in the target environment, wherein the target program inventory includes to compare with needs
Target program access path corresponding to target side program；
The target program access path in the target program inventory is parsed, and is stored in the second temporary visit routing table.
8. according to the method described in claim 5, it is characterized in that, will be compared described in inconsistent result data deposit described
After access path contrast table, further includes:
Access path comparing result table is established in the target environment；
Result data in the access path contrast table is stored in the access path comparing result table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610424517.2A CN106126542B (en) | 2016-06-15 | 2016-06-15 | A kind of management method of access path |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610424517.2A CN106126542B (en) | 2016-06-15 | 2016-06-15 | A kind of management method of access path |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106126542A CN106126542A (en) | 2016-11-16 |
| CN106126542B true CN106126542B (en) | 2019-10-18 |
Family
ID=57469546
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610424517.2A Active CN106126542B (en) | 2016-06-15 | 2016-06-15 | A kind of management method of access path |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106126542B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110866031B (en) * | 2019-11-08 | 2022-07-08 | 中国工商银行股份有限公司 | Database access path optimization method and device, computing equipment and medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101316185A (en) * | 2007-06-01 | 2008-12-03 | 阿里巴巴集团控股有限公司 | Method for positioning system resource bottleneck by analysis result based on log file |
| CN101425091A (en) * | 2008-12-05 | 2009-05-06 | 中国工商银行股份有限公司 | Database access path efficiency analyzing and processing method, server and system |
| CN103136260A (en) * | 2011-11-30 | 2013-06-05 | 国际商业机器公司 | Method and device for applying filtration factor assessment in optimization of access path in database |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8938430B2 (en) * | 2012-02-22 | 2015-01-20 | International Business Machines Corporation | Intelligent data archiving |
-
2016
- 2016-06-15 CN CN201610424517.2A patent/CN106126542B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101316185A (en) * | 2007-06-01 | 2008-12-03 | 阿里巴巴集团控股有限公司 | Method for positioning system resource bottleneck by analysis result based on log file |
| CN101425091A (en) * | 2008-12-05 | 2009-05-06 | 中国工商银行股份有限公司 | Database access path efficiency analyzing and processing method, server and system |
| CN103136260A (en) * | 2011-11-30 | 2013-06-05 | 国际商业机器公司 | Method and device for applying filtration factor assessment in optimization of access path in database |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106126542A (en) | 2016-11-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11829360B2 (en) | Database workload capture and replay | |
| CN109460349B (en) | Test case generation method and device based on log | |
| US10303702B2 (en) | System and method for analysis and management of data distribution in a distributed database environment | |
| US11429584B2 (en) | Automatic determination of table distribution for multinode, distributed database systems | |
| US6581052B1 (en) | Test generator for database management systems | |
| CN103473260B (en) | Concurrency OLAP (On-Line Analytical Processing)-oriented test data hierarchy cluster query processing system and method | |
| CN110300963A (en) | Data management system in large-scale data repository | |
| US20160378826A1 (en) | Caching views on historical data | |
| CN111782265B (en) | Software resource system based on field-level blood-relation and establishment method thereof | |
| WO2017183065A1 (en) | Device and method for tuning relational database | |
| CN104205039A (en) | Interest-driven business intelligence systems and methods of data analysis using interest-driven data pipelines | |
| CN109408493A (en) | A kind of moving method and system of data source | |
| CN110175163A (en) | More library separation methods, system and medium based on business function intelligently parsing | |
| CN101593203A (en) | The database compound query system and method that has pre-treatment and aftertreatment | |
| Rabl et al. | Just can't get enough: Synthesizing Big Data | |
| Kersten et al. | Cracking the database store | |
| CN106803799A (en) | A kind of performance test methods and device | |
| CN109241104A (en) | The resolver and its implementation of AISQL in decision type distributed data base system | |
| CN108255852B (en) | SQL execution method and device | |
| Vakharia et al. | Shared foundations: Modernizing meta’s data lakehouse | |
| CN106126542B (en) | A kind of management method of access path | |
| CN107798007A (en) | A kind of method, apparatus and relevant apparatus of distributed data base data check | |
| Bonteanu et al. | Multi-platform performance analysis for CRUD operations in relational databases from Java programs using hibernate | |
| CN110222032A (en) | A kind of generalised event model based on software data analysis | |
| CN104361090A (en) | Data query method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |