CN106126542A - A kind of management method of access path - Google Patents
A kind of management method of access path Download PDFInfo
- Publication number
- CN106126542A CN106126542A CN201610424517.2A CN201610424517A CN106126542A CN 106126542 A CN106126542 A CN 106126542A CN 201610424517 A CN201610424517 A CN 201610424517A CN 106126542 A CN106126542 A CN 106126542A
- Authority
- CN
- China
- Prior art keywords
- access path
- environment
- statistical information
- source
- target environment
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
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
Abstract
nullThe invention provides the management method of a kind of access path，By setting up a source test environment matched with target environment，And the correlation table data of described target environment are imported the first application table created in described source test environment，Afterwards，According to the correlation table data imported in described first application table，Business simulating and simulation is carried out at source environment，The first statistical information is generated after correction，So that metastable statistical information can adapt to being continually changing of data in table，And the renewal carrying out statistical information in described 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 is generated respectively again according to described first statistical information，The result data that contrast is inconsistent is preserved after contrast，And then facilitate manual analysis and correction，Solve the hysteresis quality problem of access path management.
Description
Technical field
The present invention relates to field of computer technology, in particular, relate to the management method of a kind of access path.
Background technology
DB2 is a set of Relational DBMS of American I BM company exploitation, is mainly used in large-scale application system
System, is calculated and provides access path, and then improve program and the data query performance of user, and support many by query optimizer
Tasks in parallel is inquired about.
At present, the method in the existing DB2 of utilization calculating, generation and maintenance access path is to first pass through RUNSTAT etc.
UTILITY instrument carries out calculating and the collection of statistical information to correlation table, and charges in DB2CATALOG；Afterwards, for static state
SQL, then carry out BIND or REBIND operation, generates the access path of program, simultaneously by the optimizer of DB2 according to CATALOG
Statistical information calculate theoretical optimum access path when program BIND, and at user's caller or when running SQL, utilize
Correlation table is conducted interviews by the access path generated, and now, if the theoretical access path calculated is not optimum, then performance occurs
Problem, and then need carry out manual analysis and revise this access path；For dynamic sql, then called in program or SQL performs
Time, the optimizer of DB2 conducts interviews according to CATALOG information the determination in path, and uses this access path to conduct interviews table.
But, when DB2 calculates and generates access path, owing in DB2CATALOG information, the statistical information of table can not be real
Shi Gengxin, but the data of table then may change at any time so that for calculating the statistical information tool of access path in CATALOG
There is time point, cause the CATALOG collected at a certain time point to be difficult to be universally adapted to the table that data are continually changing, cause the best
Access path can along with in table the change of data and deteriorate suddenly；Secondly, in collecting CATALOG during statistical information, pass through
The mode of RUNSTAT can make the system resource overhead such as CPU bigger, it is impossible to frequently executes；And when maintenance access path, due to
Manual analysis can only be carried out when performance issue occurs again and revise with intervening, cause the extensive management of access path, exist delayed
Property.
Summary of the invention
In view of this, the invention provides the management method of a kind of access path, and then realize metastable statistics letter
Breath can adapt to being continually changing of data in table, and can quick and low consumed renewals CATALOG information, and solve access
The hysteresis quality problem of the management in path, reaches to prevent in advance.
For achieving the above object, the present invention provides following technical scheme:
A kind of management method of access path, including:
Setting up source test environment, described source test environment matches with target environment；
Establishment the first application table in described source test environment, and import the correlation table data of described target environment, its
In, described correlation table data are the data needing to calculate the table of access path；
According to the correlation table data imported in described first application table, generate the first statistical information, and be saved in the first letter
Breath table；
According to described first statistical information, described source test environment generates source routine access path, and preserves
In the first correlation table；
Described first statistical information is imported described target environment；
According to described first statistical information imported, described target environment generates target program access path, and protects
Exist in the second correlation table；
Contrast described first correlation table and described second correlation table, and preserve the result data that contrast is inconsistent.
Preferably, described by described first statistical information import described target environment, including:
Described first statistical information is extracted from described first information table；
Being saved in the first file by described first statistical information, described first file is built in described source test environment
Vertical；
Described first file is imported to described target environment；
Described first statistical information being saved in described first file is imported to described target environment.
Preferably, described described first statistical information being saved in described first file is imported to described target ring
Border, including:
When judging to establish the second application table corresponding with described first application table in described target environment, by described
One statistical information imports the second information table in described target environment；
When judging not set up the second application table corresponding with described first application table in described target environment, according to described
In source test environment described first application table, in described target environment set up with described first apply table corresponding described in
Second application table, and described first statistical information is imported described second information table in described target environment.
Preferably, in described target environment, second application corresponding with described first application table is established in described judgement
During table, before described first statistical information is imported described second information table in described target environment, also include:
Judge, when described second application table is inconsistent with the structure of described first application table, to rebuild in described target environment
Described second application table.
Preferably, described first correlation table of described contrast and described second correlation table, and preserve the result that contrast is inconsistent
Data, including:
The first temporary visit routing table, the second temporary visit routing table and access path is set up in described target environment
Contrast table；
Collect described source routine access path, and be stored in described first temporary visit routing table；
Collect described target program access path, and be stored in described second temporary visit routing table；
Contrast described first temporary visit routing table and described second temporary visit routing table；
It is stored in described access path contrast table by contrasting inconsistent result data.
Preferably, described collection described source routine access path, and it is stored in described first temporary visit routing table, bag
Include:
Obtaining the source program listing in described source test environment, wherein, described source program listing comprises and needs
Carry out the source program corresponding to described source routine access path contrasted；
The 3rd temporary visit routing table, wherein, described 3rd temporary visit path is set up in described source test environment
Table is identical with the structure of described first temporary visit routing table；
Resolve the source routine access path in described source program listing, and be stored in described 3rd temporary visit path
Table；
The described source routine access path being stored in described 3rd temporary visit routing table is saved in the second file,
Described second file is set up in described source test environment；
Described source routine access path in described second file is imported described first temporary visit routing table.
Preferably, described collection described target program access path, and it is stored in described second temporary visit routing table, bag
Include:
Obtaining the target program inventory in described target environment, wherein, described target program inventory comprises and carries out with needs
The destination end program corresponding to target program access path of contrast；
Resolve the target program access path in described target program inventory, and be stored in described second temporary visit path
Table.
Preferably, will contrast after inconsistent result data is stored in described access path contrast table described, also include:
Access path comparing result table is set up in described target environment；
Result data in described access path contrast table is stored in described access path comparing result table.
Understand via above-mentioned technical scheme, compared with prior art, the invention provides the management of a kind of access path
Method, by setting up a source test environment matched with target environment, and create in described source test environment
The correlation table data of described target environment are imported in first application table, afterwards, relevant according to what described first application table imported
Table data, carry out a series of business simulating and simulation at source environment, constantly revise on this basis and generate the first statistics letter
Breath, so that metastable statistical information can adapt to being continually changing of data in table, and at described source test environment
In carry out the renewal of statistical information and can reduce system operating time, reduce the consumption of system resource, then according to described first system
Meter information generates source routine access path, is saved in the first correlation table, and described first statistical information is imported described target
Environment, generates target program access path, is saved in the second correlation table, contrasts described first correlation table second relevant to described
Table, and preserve the result data that contrast is inconsistent, and then facilitate manual analysis and correction, solve the delayed of access path management
Sex chromosome mosaicism.
Accompanying drawing explanation
In order to be illustrated more clearly that the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
In having technology to describe, the required accompanying drawing used is briefly described, it should be apparent that, the accompanying drawing in describing below is only this
Inventive embodiment, for those of ordinary skill in the art, on the premise of not paying creative work, it is also possible to according to
The accompanying drawing provided obtains other accompanying drawing.
The management method flow chart of a kind of access path that Fig. 1 provides for the embodiment of the present invention；
A kind of importing the first statistical information that Fig. 2 provides for the embodiment of the present invention is to the method flow diagram of target environment；
A kind of contrast the first correlation table and the method flow diagram of the second correlation table that Fig. 3 provides for the embodiment of the present invention；
A kind of method flow diagram collected and preserve source routine access path that Fig. 4 provides for the embodiment of the present invention；
A kind of method flow diagram collected and preserve target program access path that Fig. 5 provides for the embodiment of the present invention.
Detailed description of the invention
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clear, complete
Describe, it is clear that described embodiment is only a part of embodiment of the present invention rather than whole embodiments wholely.Based on
Embodiment in the present invention, it is every other that those of ordinary skill in the art are obtained under not making creative work premise
Embodiment, broadly falls into the scope of protection of the invention.
Embodiments providing the management method of a kind of access path, refer to accompanying drawing 1, described method specifically includes
Following steps:
Step 101: set up source test environment, described source test environment matches with target environment；
Concrete, by using the environmental structure action identical with described target environment, produce and described target environment
The described source test environment matched, wherein said source test environment has the ZPARM ginseng identical with described target environment
Number is arranged, the setting of the POOL such as BUFFER POOL, SORT POOL, RID POOL, CPU parameter and list structure and application frame
Structure.
Step 102: create the first application table in described source test environment, and import the correlation table of described target environment
Data, wherein, described correlation table data are the data needing to calculate the table of access path；
Concrete, the correlation table data importing to the first application table in described source test environment are described target environment
Need to calculate the relevant existing total data of the application 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 described first application table, generate the first statistical information, and preserve
At first information table；
Concrete, the related data of the table needing calculating access path that will import in described first application table, described
Source test environment carries out substantial amounts of simulation and emulation, so achieve be simulated in described source test environment transaction,
Simulation of bulk etc. operate；After dry run after a while, by RUNSTAT operation carry out statistical information collection,
Update, thus obtain described first statistical information, and be saved in the first information table in described source test environment, described the
One information table can be CATALOG table, finally achieves the simulation of statistical information to the development trend estimated.
Step 104: according to described first statistical information, generates source routine access road in described source test environment
Footpath, and be saved in the first correlation table；
Concrete, in described source test environment, operated the visit generating static embeded SQL by BIND or REBIND of program
Ask the way footpath, by described first statistical information when program is run or SQL performs, carry out the generation of the access path of dynamic sql.
Step 105: described first statistical information is imported described target environment；
Concrete, in described target environment, in the way of performing SQL, run described first statistical information, can be by described
First statistical information imports in described target environment.
Step 106: according to described first statistical information imported, generates target program in described target environment and accesses road
Footpath, and be saved in the second correlation table；
Concrete, in described target environment, operated the access road generating static embeded SQL by BIND or REBIND of program
Footpath, by described first statistical information when program is run or SQL performs, carries out the generation of the access path of dynamic sql.
Step 107: contrast described first correlation table and described second correlation table, and preserve the number of results that contrast is inconsistent
According to；
Concrete, will the source routine access path that preserve in described first correlation table and described second correlation table preserve
Target program access path carry out contrasting the inconsistent access path drawn and preserve, in order to also not according to described life
Before the access path become searches corresponding resource, it is achieved manually controlling and analyzing.
In the management method of access path disclosed in the embodiment of the present invention, matched by foundation and described target environment
Described source test environment, and according to the correlation table data imported from described target environment, generate the first statistical information, and protect
There is first information table, thus both achieved metastable statistical information and adapted to the table that data are continually changing, also achieve fast
Speed and low consumption ground update statistical information, afterwards described first statistical information are imported described target environment, generate corresponding mesh
Beacon course sequence access path, and be saved in described second correlation table, contrast described first correlation table and described second correlation table, and
Preserve the inconsistent result data of contrast, so convenient also access path not according to described generation search corresponding resource it
Before, it is achieved manually control and analysis, solve the hysteresis quality problem of access path.
Referring to accompanying drawing 2, the process that implements of the step 105 provided in above-described embodiment comprises the following steps:
Step 201: extract described first statistical information from described first information table.
Step 202: be saved in the first file by described first statistical information, described first file is tested in described source
Environment is set up.
Step 203: described first file is imported to described target environment；
Concrete, it is impossible to directly will be stored in the first statistical information in the first information table in described source test environment
Import in described target environment, it is therefore desirable to described first statistical information that first will extract from described first information table
It is saved in the first file, more described first file is dumped in described target environment.
Step 204: judge whether establish second application corresponding with described first application table in described target environment
Table, if setting up, then performs step 205a, if not setting up, then performs step 205b；
Concrete, described source test environment is mutually matched with the related application table initiating structure in described target environment,
But after a section business analogue simulation, it is understood that there may be the situation that related application list structure changes, or because business development is fixed
The new related application table of justice, thus will described first statistical information import in described target environment time need first to judge in institute
State and target environment has established described second application the most identical with the first application table corresponding to described first information table
Table；Only in the case of described first application table and the second application table mate completely, could store in described second information table
Described first statistical information imported, wherein, described second information table can be CATALOG table.
Step 205a: judge that described second application table is the most consistent with the structure of described first application table, if inconsistent, then
Perform step 206, if unanimously, then perform step 207；
Concrete, described source test environment is mutually matched with the related application table initiating structure in described target environment,
But after a section business analogue simulation, it is understood that there may be the situation that related application list structure changes, thus also need to judge
When the described second application list structure set up in described target environment applies list structure identical with described first, just can carry out described
The importing of the first statistical information.
Step 205b: according to the described first application table in described source test environment, set up in described target environment
The described second application table corresponding with described first application table, and perform step 207.
Step 206: rebuild the described second application table in described target environment, and perform step 207；
Concrete, having established first relevant to described first statistical information to be imported in described target environment should
Table is applied with second corresponding to table, but when the structure of the structure of described second application table and described first application table differs,
Delete existing described second application table, the most again according to the structure of described first application table, set up same answering
With table, as described second application table；Only when the first application table and the second application list structure are completely the same, described second letter
Breath table could be used for storing described first statistical information.
Step 207: described first statistical information being saved in described first file is imported in described target environment
Described second information table.
In the embodiment of the present invention, by when described first statistical information is imported described target environment, first from described the
One information table extracts described first statistical information, and saves it in described first file, thus import described smoothly
In target environment, judge that described first statistical information whether set up in described target environment to import is relevant the most successively
First application the second application table corresponding to table, and judge whether the structure of described second application table and described first application table
Unanimously, more described first statistical information in described first file is imported after meeting condition, and then meet described target ring
The condition that border matches with described source test environment, and facilitate follow-up utilize in described target environment described first statistics letter
Breath generates target program access path.
Referring to accompanying drawing 3, the process that implements of the step 107 provided in above-described embodiment comprises the following steps:
Step 301: set up in described target environment the first temporary visit routing table, the second temporary visit routing table and
Access path contrast table；
Concrete, the structure of described first temporary visit routing table and the second temporary visit routing table is consistent, but the institute of table
The person of having is different, can deposit different data；Described access path contrast table be used for being stored in described first temporary visit routing table with
The Data Entry that access path in second temporary visit routing table is different, and the result being stored in described access path contrast table
Data Entry can be automatic along with the change of the content in described first temporary visit routing table and the second temporary visit routing table
Change.
Step 302: collect described source routine access path, and be stored in described first temporary visit routing table；
Concrete, after the described source routine access Path-collection in described source test environment, it is stored in described target
In the described first temporary visit routing table set up in environment.
Step 303: collect described target program access path, and be stored in described second temporary visit routing table.
Step 304: contrast described first temporary visit routing table and described second temporary visit routing table；
Concrete, by contrasting described first temporary visit routing table and five in described second temporary visit routing table
Field is the most completely the same draws whether record in described first temporary visit routing table and the second temporary visit routing table
Same program SQL statement access path, wherein said five fields be respectively as follows: QUERYNO, QBLOCKNO, PROGNAME,
PLANNO、MIXOPSEQ；If record is same in described first temporary visit routing table and the second temporary visit routing table
Program SQL statement access path, then again by 14 contrasted corresponding to described same program SQL statement access path
Field is the most completely the same finally draws same in described first temporary visit routing table and the second temporary visit routing table
The result data that program SQL statement access path is inconsistent, wherein said 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: be stored in described access path contrast table by contrasting inconsistent result data；
Concrete, in drawing described first temporary visit routing table and described second temporary visit routing table in contrast not
During consistent result data entry, the content in described access path contrast table is as well as described first temporary visit routing table
Change with the inconsistent result data entry in the second temporary visit routing table and be automatically updated into up-to-date access path
Inconsistent result data entry.
Step 306: the result data in described access path contrast table is stored in described access path comparing result table, institute
State access path comparing result table to set up in described target environment；
Concrete, owing to the result data entry being stored in described access path contrast table can be along with described first interim
The change of the content in access path table and the second temporary visit routing table and automatically change, for convenience of follow-up manual analysis,
Need in described target environment, set up described access path comparing result table, be used for preserving at any time the described access in a certain moment
Inconsistent result data in path contrast table, conveniently carries out analysis and the correction in later stage.
In the embodiment of the present invention, access road by collecting described source routine access path respectively with described target program
Footpath, and each it is stored in described target environment the described first temporary visit routing table and the second temporary visit routing table set up
In, and the inconsistent result data obtained after contrast is stored in described target environment the described access path contrast set up
Table, checks the described inconsistent result data in a certain moment at any time for the ease of the later stage, then by described inconsistent number of results
According to being saved in described access path comparing result table, and then achieve early warning problem, the purpose intervened in advance.
Referring to accompanying drawing 4, the process that implements of the step 302 provided in above-described embodiment comprises the following steps:
Step 401: obtain the source program listing in described source test environment, described source program listing comprises and needs
Carry out the source program corresponding to source routine access path contrasted；
Concrete, in described source test environment, described source routine access path is saved in described first correlation table
In, described source program listing is then for the collection of a series of source program listings of this Comparative Analysis on Tracks that needs to conduct interviews
Close, the data base's name such as program, the COLLID etc. of program can be passed through, select from described first correlation table and match with it
The access path of entry；At the same time it can also be according to the needs of present analysis, customization data base's name DBNAME and COLLID
Value DCOLLID.
Step 402: set up the 3rd temporary visit routing table, described 3rd temporary visit road in described source test environment
Footpath table is identical with the structure of described first temporary visit routing table.
Step 403: resolve the source routine access path in described source program listing, and be stored in the described 3rd and visit temporarily
Ask routing table；
Concrete, utilize EXPLAIN SQL statement, by program COLLID in described source program listing and the number of program
According to library name, be filled in stsndard SQL template, it is intended that be stored in described 3rd temporary visit routing table, then after SQL performs, meeting
To currently give the access path of the program of COLLID and name, be resolved in described 3rd temporary visit routing table.
Step 404: the described source routine access path being stored in described 3rd temporary visit routing table is saved in
In two files, described second file is set up in described source test environment；
Concrete, utilize UNLOAD UTILITY instrument, be stored into the access road in described 3rd temporary visit routing table
Footpath downloads in described second file.
Step 405: the described source routine access path in described second file is imported described first temporary visit road
Footpath table；
Concrete, utilize LOAD instrument, by the access path data in described file, according to specified format, a line a line
The described first temporary visit routing table of importing.
In the embodiment of the present invention, by, in described source test environment, having gathered, to comprising, the source that needs contrast
The source program listing of end source program corresponding to routine access path resolves, and acquires described source routine access
Path, and be deposited in the described 3rd temporary visit routing table identical with the structure of described first temporary visit routing table,
The source routine access path being stored in the 3rd temporary visit routing table described in downloading afterwards is to described second file, and then leads again
Enter described source routine access path to described first temporary visit routing table, thus facilitate follow-up in same environment to two
The access path generated in individual different environment is analyzed.
Referring to accompanying drawing 5, the process that implements of the step 303 provided in above-described embodiment comprises the following steps:
Step 501: obtain the target program inventory in described target environment, described target program inventory comprises needs to be carried out
The destination end program corresponding to target program access path of contrast；
Concrete, in described target environment, described target program access path is saved in described second correlation table, and
Described target program inventory then for the set of a series of destination end program listings of this Comparative Analysis on Tracks that needs to conduct interviews,
Can select from described second correlation table and match with it by such as data base's name of program, the COLLID etc. of program
The access path of entry；At the same time it can also be according to the needs of present analysis, customization data base's name DBNAME and COLLID value
DCOLLID。
Step 502: resolve the target program access path in described target program inventory, and be stored in described second and visit temporarily
Ask routing table；
Concrete, utilize EXPLAIN SQL statement, by program COLLID in described target program inventory and the number of program
According to library name, be filled in stsndard SQL template, it is intended that be stored in described second temporary visit routing table, then after SQL performs, meeting
To currently give the access path of the program of COLLID and name, be resolved in described second temporary visit routing table.
In the embodiment of the present invention, by described target environment, gather, to comprising, the target journey that needs contrast
The target program inventory of destination end program corresponding to sequence access path resolves, and acquires described target program and accesses road
Footpath, and it is stored in described second temporary visit routing table, and then it is easy to the later stage access path to generating in two different environment
It is analyzed.
Described above to the disclosed embodiments, makes professional and technical personnel in the field be capable of or uses the present invention.
Multiple amendment to these embodiments will be apparent from for those skilled in the art, as defined herein
General Principle can realize without departing from the spirit or scope of the present invention in other embodiments.Therefore, the present invention
It is not intended to be limited to the embodiments shown herein, and is to fit to and principles disclosed herein and features of novelty phase one
The widest scope caused.
Claims (8)
1. the management method of an access path, it is characterised in that described method includes:
Setting up source test environment, described source test environment matches with target environment；
Establishment the first application table in described source test environment, and import the correlation table data of described target environment, wherein, institute
Stating correlation table data is the data needing to calculate the table of access path；
According to the correlation table data imported in described first application table, generate the first statistical information, and be saved in first information table；
According to described first statistical information, described source test environment generates source routine access path, and is saved in the
In one correlation table；
Described first statistical information is imported described target environment；
According to described first statistical information imported, described target environment generates target program access path, and is saved in
In second correlation table；
Contrast described first correlation table and described second correlation table, and preserve the result data that contrast is inconsistent.
Method the most according to claim 1, it is characterised in that described by the described first statistical information described target ring of importing
Border, including:
Described first statistical information is extracted from described first information table；
Being saved in the first file by described first statistical information, described first file is set up in described source test environment；
Described first file is imported to described target environment；
Described first statistical information being saved in described first file is imported to described target environment.
Method the most according to claim 2, it is characterised in that described will be saved in described first file described first
Statistical information imports to described target environment, including:
When judging to establish the second application table corresponding with described first application table in described target environment, by described first system
Meter information imports the second information table in described target environment；
When judging not set up the second application table corresponding with described first application table in described target environment, according to described source
Described first application table in test environment, sets up described second corresponding with described first application table in described target environment
Application table, and described first statistical information is imported described second information table in described target environment.
Method the most according to claim 3, it is characterised in that establish in described target environment and institute in described judgement
When stating the second application table corresponding to the first application table, described first statistical information is imported described second in described target environment
Before information table, also include:
Judging when the structure of described second application table and described first application table is inconsistent, that rebuilds in described target environment is described
Second application table.
Method the most according to claim 1, it is characterised in that described first correlation table of described contrast is second relevant to described
Table, and preserve the result data that contrast is inconsistent, including:
The first temporary visit routing table, the second temporary visit routing table and access path contrast is set up in described target environment
Table；
Collect described source routine access path, and be stored in described first temporary visit routing table；
Collect described target program access path, and be stored in described second temporary visit routing table；
Contrast described first temporary visit routing table and described second temporary visit routing table；
It is stored in described access path contrast table by contrasting inconsistent result data.
Method the most according to claim 5, it is characterised in that described collection described source routine access path, and be stored in
Described first temporary visit routing table, including:
Obtaining the source program listing in described source test environment, wherein, described source program listing comprises and carries out with needs
The source program corresponding to described source routine access path of contrast；
In described source test environment, set up the 3rd temporary visit routing table, wherein, described 3rd temporary visit routing table with
The structure of described first temporary visit routing table is identical；
Resolve the source routine access path in described source program listing, and be stored in described 3rd temporary visit routing table；
The described source routine access path being stored in described 3rd temporary visit routing table is saved in the second file, described
Second file is set up in described source test environment；
Described source routine access path in described second file is imported described first temporary visit routing table.
Method the most according to claim 5, it is characterised in that described collection described target program access path, and be stored in
Described second temporary visit routing table, including:
Obtaining the target program inventory in described target environment, wherein, described target program inventory comprises and contrasts with needs
The destination end program corresponding to target program access path；
Resolve the target program access path in described target program inventory, and be stored in described second temporary visit routing table.
Method the most according to claim 5, it is characterised in that be stored in described by contrasting inconsistent result data described
After access path contrast table, also include:
Access path comparing result table is set up in described target environment；
Result data in described access path contrast table is stored in described 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 true CN106126542A (en) | 2016-11-16 |
| CN106126542B 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) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110866031A (en) * | 2019-11-08 | 2020-03-06 | 中国工商银行股份有限公司 | Database access path optimization method and device, computing equipment and medium |
Citations (4)
| 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 |
| US20130218843A1 (en) * | 2012-02-22 | 2013-08-22 | International Business Machines Corporation | Intelligent data archiving |
-
2016
- 2016-06-15 CN CN201610424517.2A patent/CN106126542B/en active Active
Patent Citations (4)
| 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 |
| US20130218843A1 (en) * | 2012-02-22 | 2013-08-22 | International Business Machines Corporation | Intelligent data archiving |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110866031A (en) * | 2019-11-08 | 2020-03-06 | 中国工商银行股份有限公司 | Database access path optimization method and device, computing equipment and medium |
| CN110866031B (en) * | 2019-11-08 | 2022-07-08 | 中国工商银行股份有限公司 | Database access path optimization method and device, computing equipment and medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106126542B (en) | 2019-10-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105808284B (en) | A kind of method for updating increment and the server using it | |
| US11475001B1 (en) | Quantifying complexity of a database query | |
| US11294869B1 (en) | Expressing complexity of migration to a database candidate | |
| CN103514166B (en) | SQL inspection method and device | |
| US9436734B2 (en) | Relative performance prediction of a replacement database management system (DBMS) | |
| CN107451126A (en) | A kind of near synonym screening technique and system | |
| CN111782265B (en) | Software resource system based on field-level blood-relation and establishment method thereof | |
| CN106202207A (en) | A kind of index based on HBase ORM and searching system | |
| CN108197306A (en) | SQL statement processing method, device, computer equipment and storage medium | |
| CN105589706B (en) | A kind of upgrade package generation method and device | |
| CN107577436A (en) | A kind of date storage method and device | |
| CN106227788A (en) | Database query method based on Lucene | |
| CN105138621A (en) | Configuration optimization system and method for Sybase ASE database | |
| Wylot et al. | Executing provenance-enabled queries over web data | |
| CN109241104A (en) | The resolver and its implementation of AISQL in decision type distributed data base system | |
| CN107291770A (en) | The querying method and device of mass data in a kind of distributed system | |
| CN109376153A (en) | System and method for writing data into graph database based on NiFi | |
| CN110457333A (en) | Data real time updating method, device and computer readable storage medium | |
| CN111126461B (en) | Intelligent auditing method based on machine learning model interpretation | |
| CN105446824B (en) | Table increment acquisition methods and long-distance data backup method | |
| CN108363660A (en) | A kind of method of generating test program and device | |
| CN110321446A (en) | Related data recommended method, device, computer equipment and storage medium | |
| CN106126542A (en) | A kind of management method of access path | |
| US20060218174A1 (en) | Method for coordinating schema and data access objects | |
| CN105975258A (en) | Data dictionary management method and system |
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 |