CN103955516B - Host resource access information optimization method and device in on-line transaction - Google Patents
Host resource access information optimization method and device in on-line transaction Download PDFInfo
- Publication number
- CN103955516B CN103955516B CN201410186938.7A CN201410186938A CN103955516B CN 103955516 B CN103955516 B CN 103955516B CN 201410186938 A CN201410186938 A CN 201410186938A CN 103955516 B CN103955516 B CN 103955516B
- Authority
- CN
- China
- Prior art keywords
- information
- resource
- transaction
- data
- accesses
- 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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Abstract
The invention provides a kind of on-line transaction resource access information optimization method and device, this method includes：Receive the demand information of user；Resource accesses data according to corresponding to determining the demand information；Determine that the resource accesses the resource to be optimized in data and accesses data according to pre-stored suspicious optimization information；Data are accessed according to the resource to be optimized and pre-stored Optimizing Suggestions data generate resource access information optimum results, to solve the problems, such as that the test of on-line transaction can only verify that the resource transfer relation to occur merchandising is inconsistent with designing by checking implementing result.The present invention automatically analyzes the resource access situation for excavating out suspicious optimization, and proposes expert's Optimizing Suggestions, greatlys save human input.
Description
Technical field
The present invention relates to microcomputer data processing, is concretely host resource access information in a kind of on-line transaction
Optimization method and device.
Background technology
At present, in large-scale on-line Application system, it is unreasonable that main frame application resource failure is frequently due to on-line transaction
Access cause.For example usually occur on-line Application resource in production and access the lack of standardization or resource in production environment of merchandising
Call relation is asked with designing inconsistent situation so as to cause that the resource of redundance accesses and resource access order is inconsistent etc.
Topic, these increased the expense of host system resources, so that jeopardizing the safety and stability of production run.
Because the operation of mainframe on-line transaction needs to have access to various interface routine and table resources, different transaction flows is just
It is to be combined to form by a variety of online dictionaries.The design rank of resource transfer relation in one on-line transaction in application and development
Section determines, is record in the form of transaction flow design drawing (or using design), the exploitation of on-line transaction program code according to
Carried out according to design, and the test of on-line transaction can only be verified by checking implementing result, it is online due to that cannot collect and grasp
The resources relationship situation that transaction actual motion is accessed.Simultaneously as an on-line transaction generally involves many programs and table
Resource, different resource module are related to different developers, so when production environment because the situation of these unreasonable access goes out
During existing operation exception, analysis personnel are difficult to clear all resource access informations of transaction at once.
With the continuous development of banking, mainframe on-line class of business is increasing, the resource that on-line transaction is accessed
Relation will also be become increasingly complex, and in order to better ensure that main frame production safety is stable, host resource is accessed there is an urgent need to a kind of
The system and method that information carries out analysis optimization.
The content of the invention
To solve to access data to collected resource to the deficiency of online trading host access information processing in the prior art
Carry out reasonability optimization analysis.
The invention provides a kind of online middle host transaction resource access information optimization method, method includes：
Receive the demand information of user；
Resource accesses data according to corresponding to determining the demand information；
Determine that the resource accesses the resource to be optimized in data and accesses data according to pre-stored suspicious optimization information；
Data and the generation resource access information optimization of pre-stored Optimizing Suggestions data are accessed according to the resource to be optimized
As a result.
In addition, the invention also discloses a kind of online middle host transaction resource access information optimization device, device includes：
Receiving module, for receiving the demand information of user；
Resource accesses data determining module, and data are accessed for the resource according to corresponding to demand information determination；
Resource to be optimized accesses data determining module, for determining that the resource is visited according to pre-stored suspicious optimization information
Ask that the resource to be optimized in data accesses data；
Optimum results generation module, for accessing data and pre-stored Optimizing Suggestions data according to the resource to be optimized
Generate resource access information optimum results.
The present invention realizes collects the trading resources path of transaction actual motion in test environment, and generates relationship trading flow
Figure, the test for solving on-line transaction can only be verified the resource transfer relation that occurs merchandising and design by checking implementing result
The problem of inconsistent.The resource access situation for excavating out suspicious optimization is automatically analyzed, and proposes expert's Optimizing Suggestions, is greatlyd save
Human input.
For the above and other objects, features and advantages of the present invention can be become apparent, preferred embodiment cited below particularly,
And coordinate institute's accompanying drawings, it is described in detail below.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is the required accompanying drawing used in technology description to be briefly described, it should be apparent that, drawings in the following description are only this
Some embodiments of invention, for those of ordinary skill in the art, without having to pay creative labor, may be used also
To obtain other accompanying drawings according to these accompanying drawings.
Fig. 1 is a kind of flow chart of on-line transaction resource access information optimization method of the present invention；
Fig. 2 is that resource corresponding to information determination accesses the flow chart of data according to demand in the embodiment of the present invention；
Fig. 3 is that resource to be optimized accesses data and corresponding pre-stored Optimizing Suggestions data generation in the embodiment of the present invention
The flow chart of resource access information optimum results；
Fig. 4 is the block diagram that a kind of online middle host transaction resource access information of the present invention optimizes device；
Fig. 5 is the block diagram that resource accesses data determining module in the embodiment of the present invention；
Fig. 6 is the block diagram of optimum results generation module in the embodiment of the present invention；
Fig. 7 is the method flow diagram that host resource access information disclosed in the embodiment of the present invention carries out analysis optimization；
Fig. 8 is the block diagram of the resource access collection device in the embodiment of the present invention；
Fig. 9 is the block diagram of the resource access analysis device in the embodiment of the present invention；
Figure 10 is the flow chart of the method that suspicious optimization checks the pretreatment of items for information storehouse in the embodiment of the present invention；
Figure 11 is the flow chart of the method for Optimizing Suggestions data prediction in the embodiment of the present invention；
Figure 12 is that resource accesses collection step in the embodiment of the present invention；
Figure 13 is resource Access Optimization analytical procedure in the embodiment of the present invention.
Embodiment
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
Site preparation describes, it is clear that described embodiment is only part of the embodiment of the present invention, rather than whole embodiments.It is based on
Embodiment in the present invention, those of ordinary skill in the art are obtained every other under the premise of creative work is not made
Embodiment, belong to the scope of protection of the invention.
The invention provides host resource access information optimization method in a kind of on-line transaction, as shown in figure 1, the present invention
Method includes：
Step S101, receive the demand information of user；
Step S102, resource accesses data according to corresponding to determining the demand information；
Step S103, determine that the resource accesses the resource to be optimized in data and visited according to pre-stored suspicious optimization information
Ask data；
Step S104, data are accessed according to the resource to be optimized and corresponding pre-stored Optimizing Suggestions data generate money
Source access information optimum results.
Wherein, resource corresponding to information determination accesses data according to demand in step S102, and resource, which accesses data, to be included：Hand over
The online call number of program, repetition recalls information of the transaction to same interface in easily, transaction duplicate block recalls information, transaction make
Vernier reading manner information, the SQL numbers information of transaction and the repetition merchandised to same table are used with dynamic sql information, transaction
Access information, specific steps as shown in Fig. 2 including：
Step S201, the on-line transaction test environment of corresponding demand information is determined according to the demand information of the user received
With time segment information；
Step S202, according to transaction test environment and time segment information determine on-line transaction operation when routine call and
SQL access informations；
Step S203, the resource according to corresponding to determining routine call and SQL access informations access data.
Step S103, determine that the resource accesses the resource to be optimized in data and visited according to pre-stored suspicious optimization information
Ask that data include：The transaction internal program online (LINK) that resource access data are compared according to pre-stored suspicious optimization information calls
Number, repetition recalls information of the transaction to same interface, transaction duplicate block recalls information, transaction use dynamic sql information, transaction
(OPEN FETCH) mode information, the SQL numbers information of transaction and transaction are read using vernier to believe the repeated accesses of same table
Breath, determine that the resource accesses the resource to be optimized in data and accesses data.
As shown in figure 3, step S104 accesses data and corresponding pre-stored Optimizing Suggestions data according to resource to be optimized
Generation resource access information optimum results include：
Step S301, optimize according to corresponding to resource to be optimized accesses data and pre-stored Optimizing Suggestions data determine and build
Discuss data；
Step S302, data generation trading resources call graph is accessed according to resource to be optimized；
Step S303, resource to be optimized is accessed into data, corresponding Optimizing Suggestions data and trading resources call graph
Exported as resource access information optimum results.
Meanwhile the invention also discloses a kind of online middle host transaction resource access information optimization device, as shown in figure 4,
Device includes：
Receiving module 501, for receiving the demand information of user；
Resource accesses data determining module 502, and data are accessed for the resource according to corresponding to demand information determination；
Resource to be optimized accesses data determining module 503, for determining the money according to pre-stored suspicious optimization information
The resource to be optimized that source is accessed in data accesses data；
Optimum results generation module 504, for accessing data and pre-stored Optimizing Suggestions according to the resource to be optimized
Data generate resource access information optimum results.
In addition, also including memory module, data, resource access information optimum results are accessed for storing described resource
As shown in figure 5, the resource access data of the online middle host transaction resource access information optimization device of the present embodiment are true
Cover half block 502 includes：
Demand information determining unit 5021, for determining the corresponding demand letter according to the demand information of the user received
The on-line transaction test environment and time segment information of breath；
On-line information determining unit 5022, for determining on-line transaction according to the transaction test environment and time segment information
Routine call and SQL access informations during operation；
Data determination unit 5023 is accessed, for the resource according to corresponding to being called described program and SQL access informations determine
Access data.
As shown in fig. 6, optimum results generation module 504 includes：
Optimizing Suggestions generation unit 5041, data and pre-stored Optimizing Suggestions number are accessed according to described resource to be optimized
According to Optimizing Suggestions data corresponding to determination；
Call graph generation unit 5042, adjusted for accessing data generation trading resources according to described resource to be optimized
Use graph of a relation；Realize and collect the trading resources path of transaction actual motion in test environment, and generate relationship trading flow chart, solve
Certainly the test of on-line transaction can only verify that the resource transfer relation to occur merchandising differs with design by checking implementing result
The problem of cause.
Optimum results output unit 5043, for the resource to be optimized to be accessed into data, corresponding Optimizing Suggestions data
Exported with trading resources call graph as resource access information optimum results.
Technical scheme is described in further details with reference to specific embodiment：
As shown in fig. 7, the method that host resource access information disclosed in the embodiment of the present invention carries out analysis optimization, this method
It is to access collection device 100, resource access analysis device 200 and data storage device 300 by resource using the present invention to be formed
Online dictionary access information collection, association, filtering, typing, analysis, Optimizing Suggestions and the patterned processing of flow.Resource
Access collection device 100 and resource access analysis device 200 is linked in sequence, and be all connected with data storage device 300.Specifically
, the method for the host resource access information progress analysis optimization of the present embodiment is as follows：
Step 1：Optimization analysis information pre-processing step：Entry letter is checked the suspicious optimization in data storage device 300
Breath storehouse 303 and Optimizing Suggestions database 304 are pre-processed；
Step 2：Resource, which accesses, collects processing step：Resource accesses collection device 100 according to the user's request of reading, to
Family demand specifies online version environment to carry out the collection of online dictionary access information, associates and filters by resource information, typing
To resource access information database；
Step 3：Resource access analysis processing step：Resource access analysis device 200 checks entry letter according to suspicious optimization
Storehouse is ceased, the data of resource access information lane database are checked, problematic online dictionary is excavated out and accesses situation, then
Related Optimizing Suggestions are proposed to these doubtful problems according to Optimizing Suggestions database, and generate trading resources call graph, most
Doubtful problem, related Optimizing Suggestions and trading resources call graph are saved in data storage device 300 afterwards.
As shown in figure 8, the block diagram of collection device 100 is accessed for the resource in the embodiment of the present invention.
Resource access collection device 100 be used for receive customer analysis demand and on-line transaction resource access information collection,
Association, overanxious and typing processing, it includes five parts：Analysis demand receiving module 101, resource information capture module 102,
The overanxious module 104 of transaction association module 103, data and data recording module 105.Resource information captures module 102 according to analysis
The on-line environment and time segment information of information are collected in user's input that demand receiving module 101 receives, have collected according to
The resource information that the on-line transaction of test environment operation specified by the demand of family is accessed, and give the information of collection to transaction and close
Gang mould block 103 is handled, and transaction association module 103 associates the resource information of same transaction, forms trading resources path data, so
After give data filtering module 104, data filtering module 104 is according to trading resources browsing process, with data storage device 300
Resource path unique index information 301 carries out unique key assignments contrast, filters out the trading resources access stream collected, repeated
Journey, data inputting module 105 is by the resource access information database of the data inputting after filtering to data storage device 300
302 are stored.
As shown in figure 9, resource access analysis device 200 is used to carry out reasonability point to collected resource access information
Analysis, proposes related Optimizing Suggestions, and generates trading resources call graph, and it includes four parts：Resource accesses reasonability point
Analyse module 201, Optimizing Suggestions module 202, transaction flow graphical module 203 and analysis result output module 204.Resource accesses
Analysis on its rationality module 201 checks items for information storehouse 303 to resource access information according to the suspicious optimization of data storage device 300
Data in database 302 are checked, are excavated out problematic online dictionary and are accessed situation, the basis of Optimizing Suggestions module 202
The Optimizing Suggestions database 304 of data storage device 300 proposes related Optimizing Suggestions, transaction flow figure to these doubtful problems
Change module 203 be used for generate correlation trading resources call graph, analysis result output module 204 by these doubtful problems,
Related Optimizing Suggestions and trading resources call graph is saved in the analysis result memory module 305 of data storage device 300.
Data storage device 300 be used for prestore analyzed before and Optimizing Suggestions need related data, it includes：Money
Source path unique index information storage module 301, resource access information database storage module 302, suspicious optimization check entry
Information bank 303, Optimizing Suggestions database 304 and analysis result memory module 305.Resource path unique index information storage module
301 are used to store online dictionary access path unique index information；Resource access information database storage module 302 is used to store
On-line transaction resource access information after associating and be overanxious；Suspicious optimization checks that items for information repository 303 is used for
The relevant check item that the analysis of storage resource Access Optimization uses；Optimizing Suggestions database is used to store 304 pairs of suspicious optimizations
Entry proposes associated specialist Optimizing Suggestions information；Analysis result memory module 305 is used to store doubtful problem, related Optimizing Suggestions
And trading resources call graph.Realize and collect the trading resources path of transaction actual motion in test environment, and generate correlation
Transaction flow figure, the test for solving on-line transaction can only verify that the resource transfer to occur merchandising closes by checking implementing result
System is with designing the problem of inconsistent.
In above-mentioned step 1 optimization analysis information pre-processing step, to the suspicious optimization inspection in data storage device 300
The method of items for information storehouse pretreatment is specifically, as shown in Figure 10：
Step S1101：Suspicious optimization checks that items for information concludes generation of deducing；
Step S1102：Suspicious optimization checks items for information typing；
Step S1103：Check items for information storage into data storage device 300 suspicious optimization.
In step 1 optimization analysis information pre-processing step, to the Optimizing Suggestions data prediction in data storage device 300
Method specifically, as shown in figure 11：
Step S1201：Optimizing Suggestions Data induction, which is deduced, to be generated；
Step S1202：Optimizing Suggestions data inputting；
Step S1203：By in Optimizing Suggestions data Cun Chudao data storage devices 300.
Described suspicious optimization checks that the data of items for information library storage include：
1) the online LINK call numbers of internal program of merchandising are unreasonable
LINK number illustrates to there may be transaction flow excessively complicated significantly more than average value, easily has influence at transaction
Manage efficiency.
2) transaction repeats to call to same interface
Same interface is carried out repeating to call accessing, illustrates to there may be Interface design unreasonable.
3) transaction repeats across subregion calling
Transaction repeats across subregion calling, illustrates to there may be Interface design unreasonable.
4) transaction uses dynamic sql
There is following problem using dynamic sql：CPU overhead is higher；Access path is not known；It can easily install and rush with version
It is prominent.
5) transaction reads OPEN/FETCH modes using vernier, but only reads a record
The SQL of a record is only read for OPEN/FETCH, the consumption of DB2 either on or off verniers can be increased or do not selected
Select optimal database access path and increase DB2 consumption.
6) the SQL numbers of transaction are unreasonable
7) transaction is to same table repeated accesses
The suspicious optimization that the system uses at present checks that items for information and optimization analysis and suggestion are exemplified below：
1) LINK number of merchandising is unreasonable, hence it is evident that more than average time
Case study：Interface communication area limits, and the data of single treatment are limited, result in the need for repeatedly calling；
Optimizing Suggestions：Expansion interface communicates area.
2) transaction uses dynamic sql
Case study：Obtained or calculation date using database functions；
Optimizing Suggestions：Programming for the multiple condition entries of simplification uses dynamic sql.
3) transaction uses OPEN/FETCH modes, but only reads a record
Case study：Do not observe program norm；
Optimizing Suggestions：Accessed using wall scroll query statement (SINGLE SELECT)；Access for no unique key, and
As long as reading any one, optimized using the first line statement (FETCH FIRST ONE ROW ONLY) is only taken.
4) transaction repeats across subregion calling
Case study：Repeatedly across subregion calling is not provided with the interface of related integration function；
Optimizing Suggestions：Integrate the interface of correlation function.
5) single on-line transaction repeated accesses one open table or call SQL more than 200
Case study：Access result before transaction to table, which is not transmitted, to be shared, and causes subsequently to need identical Information Number
According to when need access table again.；
Optimizing Suggestions：The result of first time table access is made in program variable or by communicating block transitive for further interface
With avoiding repeated accesses table in a transaction flow.
The specific steps that the resource of step 2 accesses collection step are as shown in figure 12：
Step 1301：Associated user's demand information is read in, including collects online testing environment and period of information etc.；
Step 1302：Routine call accesses related to SQL when recording every on-line transaction operation in chronological order automatically
Information；
Step 1303：The resource accessed same transaction is associated integration；
Step 1304：Generate trading resources path data；
Step 1305：Transaction searching route uniquely retrieves filtering, is specially：
Unique key assignments contrast is carried out with the resource path unique index information of data storage device；
Judge that the resource path unique index whether there is, if there is being filtered, branch to step 1306；
If it does not, information is just inserted into resource path unique index information 301；
Step 1306：The resource access information database 302 that is entered into after filtering is stored.
The specific steps of the resource Access Optimization analytical procedure of step 3 are as shown in figure 13：
Step 1401：Items for information storehouse is checked according to suspicious optimization, the data of resource access information lane database are carried out
Check, excavate out problematic online dictionary and access situation；
Step 1402：Related Optimizing Suggestions are proposed to these doubtful problems according to Optimizing Suggestions database；
Step 1403：Generate trading resources call graph；
Step 1404：Doubtful problem, related Optimizing Suggestions and trading resources call graph are saved in data storage dress
Put 300 li.
Due to using the above method and structure, a kind of of the present invention carries out analysis optimization system to host resource access information
System and method have the advantages that：
Production online dictionary can be at once provided and access situation, quick positioning question reason：
The present invention realizes that the transaction that transaction actual motion is collected in test environment accesses resource information, is entered into database,
When production goes wrong, analysis personnel can be inquired about at once, quick positioning question reason.
The transaction flow figure of actual motion is generated, is verified whether consistent with design：
The present invention realizes collects the trading resources path of transaction actual motion in test environment, and generates relationship trading flow
Figure, the test for solving on-line transaction can only be verified the resource transfer relation that occurs merchandising and design by checking implementing result
The problem of inconsistent.
The resource access situation for excavating out suspicious optimization is automatically analyzed, and proposes expert's Optimizing Suggestions, greatlys save manpower
Input：
The present invention realizes that the resource for excavating out various suspicious optimizations is automatically analyzed according to Expert Rules information accesses situation, right
In the large-scale application system that on-line transaction is complicated, it is ensured that carry out resource Access Optimization analysis to each on-line transaction, and carry
Go out expert's Optimizing Suggestions, greatly save the human input of optimizing application, it is possible to achieve the resource that on-line transaction optimizes accesses, most
Big reduction mainframe program resource consumption, takes Optimized Measures to avoid relevant issues from occurring in time, so as to ensure that program is run
Performance, ensured production safe operation.
Effect in terms of business impact analysis：
The system personnel of data center's production environment can pass through the on-line transaction resource access information collected by the present invention
Understand and be familiar with the flow using transaction, the reason for enabling system personnel quickly to position production problem, more accurately hold and ask
The service impact scope of topic.Such as：
(1) quickly determine that some table structure becomes the transaction further related to；
(2) number of deals influenceed when disabling some program or table in production environment is quickly determined.
In the effect of application architecture design aspect：
On-line transaction resource access information collected by the present invention is saved in database, forms the platform of whole application flow
Account database, there is provided conveniently technological means counts on the various resource service conditions of transaction, so that architecture design personnel
Can more accurately it grasp using actual conditions, it is more preferable to carry out related application architecture transformation.
Apply specific embodiment in the present invention to be set forth the principle and embodiment of the present invention, above example
Explanation be only intended to help understand the present invention method and its core concept；Meanwhile for those of ordinary skill in the art,
According to the thought of the present invention, there will be changes in specific embodiments and applications, in summary, in this specification
Appearance should not be construed as limiting the invention.
Claims (8)
1. host resource access information optimization method in a kind of on-line transaction, it is characterised in that described method includes：
Receive the demand information of user；
Resource accesses data according to corresponding to determining the demand information；
Determine that the resource accesses the resource to be optimized in data and accesses data according to pre-stored suspicious optimization information；
Data are accessed according to the resource to be optimized and corresponding pre-stored Optimizing Suggestions data generation resource access information is excellent
Change result；
The pre-stored suspicious optimization information of described basis determines that the resource accesses the resource to be optimized in data and accesses data
Including：
The online calling of program in the transaction of the resource access data is compared according to described pre-stored suspicious optimization information
Number, repetition recalls information of the transaction to same interface, transaction duplicate block recalls information, transaction use dynamic sql information, transaction
Using vernier reading manner information, the SQL numbers information of transaction and transaction to the repeated accesses information of same table, the money is determined
The resource to be optimized that source is accessed in data accesses data；
Described is excellent according to the resource access data to be optimized and pre-stored Optimizing Suggestions data generation resource access information
Changing result includes：
The Optimizing Suggestions data according to corresponding to described resource to be optimized accesses data and pre-stored Optimizing Suggestions data determine；
Data generation trading resources call graph is accessed according to described resource to be optimized；
The resource to be optimized is accessed into data, corresponding Optimizing Suggestions data and trading resources call graph to visit as resource
Ask that Advance data quality result exports.
2. host resource access information optimization method in on-line transaction as claimed in claim 1, it is characterised in that described root
Accessing data according to resource corresponding to demand information determination includes：
On-line transaction test environment and the period of the corresponding demand information are determined according to the demand information of the user received
Information；
Routine call and SQL when determining that on-line transaction is run according to the transaction test environment and time segment information access letter
Breath；
Resource accesses data according to corresponding to being called described program and SQL access informations determine.
3. host resource access information optimization method in on-line transaction as claimed in claim 1, it is characterised in that described money
Source, which accesses data, to be included：Repetition recalls information to same interface of the online call number of program in transaction, transaction, transaction repeat
Area's recalls information, transaction use vernier reading manner information, the SQL numbers information of transaction and friendship using dynamic sql information, transaction
Easily to the repeated accesses information of same table.
4. host resource access information optimization method in on-line transaction as claimed in claim 1, it is characterised in that described side
Method also includes：
The described resource of storage accesses data, resource access information optimum results.
5. host resource access information optimizes device in a kind of on-line transaction, it is characterised in that described device includes：
Receiving module, for receiving the demand information of user；
Resource accesses data determining module, and data are accessed for the resource according to corresponding to demand information determination；
Resource to be optimized accesses data determining module, for determining that the resource accesses number according to pre-stored suspicious optimization information
Resource to be optimized in accesses data；
Optimum results generation module, for accessing data and corresponding pre-stored Optimizing Suggestions number according to the resource to be optimized
According to generation resource access information optimum results；
Described resource to be optimized, which accesses data determining module, to be included：
The online calling of program in the transaction of the resource access data is compared according to described pre-stored suspicious optimization information
Number, repetition recalls information of the transaction to same interface, transaction duplicate block recalls information, transaction use dynamic sql information, transaction
Using vernier reading manner information, the SQL numbers information of transaction and transaction to the repeated accesses information of same table, the money is determined
The resource to be optimized that source is accessed in data accesses data；
Described optimum results generation module includes：
Optimizing Suggestions generation unit, data and the determination pair of pre-stored Optimizing Suggestions data are accessed according to described resource to be optimized
The Optimizing Suggestions data answered；
Call graph generation unit, for accessing data generation trading resources call relation according to described resource to be optimized
Figure；
Optimum results output unit, provided for the resource to be optimized to be accessed into data, corresponding Optimizing Suggestions data and transaction
Source call graph exports as resource access information optimum results.
6. host resource access information optimizes device in on-line transaction as claimed in claim 5, it is characterised in that described money
Source, which accesses data determining module, to be included：
Demand information determining unit, for determining the online of the corresponding demand information according to the demand information of the user received
Transaction test environment and time segment information；
On-line information determining unit, for according to the transaction test environment and time segment information determine on-line transaction operation when
Routine call and SQL access informations；
Data determination unit is accessed, data are accessed for the resource according to corresponding to being called described program and SQL access informations determine.
7. host resource access information optimizes device in on-line transaction as claimed in claim 6, it is characterised in that described money
Source, which accesses data, to be included：Repetition recalls information to same interface of the online call number of program in transaction, transaction, transaction repeat
Area's recalls information, transaction use vernier reading manner information, the SQL numbers information of transaction and friendship using dynamic sql information, transaction
Easily to the repeated accesses information of same table.
8. host resource access information optimizes device in on-line transaction as claimed in claim 5, it is characterised in that described dress
Putting also includes：
Memory module, data, resource access information optimum results are accessed for storing described resource.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410186938.7A CN103955516B (en) | 2014-05-05 | 2014-05-05 | Host resource access information optimization method and device in on-line transaction |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410186938.7A CN103955516B (en) | 2014-05-05 | 2014-05-05 | Host resource access information optimization method and device in on-line transaction |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103955516A CN103955516A (en) | 2014-07-30 |
| CN103955516B true CN103955516B (en) | 2018-01-26 |
Family
ID=51332791
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410186938.7A Active CN103955516B (en) | 2014-05-05 | 2014-05-05 | Host resource access information optimization method and device in on-line transaction |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103955516B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106681909A (en) * | 2016-12-02 | 2017-05-17 | 中国工商银行股份有限公司 | Online transaction fault locating method and device |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101425091A (en) * | 2008-12-05 | 2009-05-06 | 中国工商银行股份有限公司 | Database access path efficiency analyzing and processing method, server and system |
| CN103440196A (en) * | 2013-07-11 | 2013-12-11 | 大连交通大学 | Resource problem detection method for novel operation system |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| GB0523115D0 (en) * | 2005-11-12 | 2005-12-21 | Ibm | A resource optimisation component |
-
2014
- 2014-05-05 CN CN201410186938.7A patent/CN103955516B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101425091A (en) * | 2008-12-05 | 2009-05-06 | 中国工商银行股份有限公司 | Database access path efficiency analyzing and processing method, server and system |
| CN103440196A (en) * | 2013-07-11 | 2013-12-11 | 大连交通大学 | Resource problem detection method for novel operation system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103955516A (en) | 2014-07-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Pan et al. | Refactoring software packages via community detection in complex software networks | |
| CN103473672A (en) | System, method and platform for auditing metadata quality of enterprise-level data center | |
| CN106547766A (en) | A kind of data access method and device | |
| CN106096870A (en) | A kind of performance data treating method and apparatus | |
| CN107423911A (en) | Software Evaluating Degree of Success method/system, computer-readable recording medium and equipment | |
| CN112181955B (en) | Data standard management method for information sharing of heavy haul railway comprehensive big data platform | |
| CN110189220A (en) | A kind of risk analysis decision-making technique, device, system and storage medium | |
| CN106484709A (en) | A kind of auditing method of daily record data and audit device | |
| US20160154840A1 (en) | Avoid double counting of mapped database data | |
| CN106803799A (en) | A kind of performance test methods and device | |
| CN108694448A (en) | PHM platforms | |
| CN107153702A (en) | A kind of data processing method and device | |
| CN108897686A (en) | It is complete to record separately automated testing method and device | |
| CN106156170B (en) | The analysis of public opinion method and device | |
| CN114817022A (en) | Railway electronic payment platform test method, system, equipment and storage medium | |
| CN103198146B (en) | Real-time event filtering method and real-time event filtering system oriented to network stream data | |
| CN110363662A (en) | A kind of personal credit points-scoring system | |
| CN103955516B (en) | Host resource access information optimization method and device in on-line transaction | |
| CN206497498U (en) | A kind of integrated system of credit rating information data based on enterprise's reference business | |
| van der Aalst et al. | Conformance checking | |
| CN112882956A (en) | Method and device for automatically generating full-scene automatic test case through data combination calculation, storage medium and electronic equipment | |
| CN106469105A (en) | A kind of monitoring rules screening technique and device | |
| CN112181962A (en) | Report form checking method, device, equipment and storage medium | |
| CN102999324B (en) | The method for building up and system of a kind of Rete network | |
| CN109597706B (en) | Detection method, device and system for checking difference data |
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 |