CN103955516A - Method and device for optimizing host computer resource access information in on-line transaction - Google Patents
Method and device for optimizing host computer resource access information in on-line transaction Download PDFInfo
- Publication number
- CN103955516A CN103955516A CN201410186938.7A CN201410186938A CN103955516A CN 103955516 A CN103955516 A CN 103955516A CN 201410186938 A CN201410186938 A CN 201410186938A CN 103955516 A CN103955516 A CN 103955516A
- Authority
- CN
- China
- Prior art keywords
- information
- resource access
- transaction
- access data
- optimized
- 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/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 device and method for optimizing on-line transaction resource access information. The method comprises the following steps: receiving demand information of a user; determining corresponding resource access data according to the demand information; determining resource access data to be optimized in the resource access data according to prestored doubtfully-optimized information; generating a resource access information optimization result according to the resource access data to be optimized and prestored optimization suggestion data so as to solve the problem that the resource call relation is not consistent with a design as the test of the on-line transaction only can be verified through the execution result examination. According to the invention, the access situation of doubtfully-optimized resource can be automatically analyzed and found out and expert optimization suggestions are proposed, so that human input can be saved greatly.
Description
Technical field
The present invention relates to microcomputer data processing, is host resource visit information optimization method and device in a kind of on-line transaction concretely.
Background technology
At present, in large-scale on-line Application system, host application faulty resource is usually because the irrational access of on-line transaction causes.Such as, in production, usually there is on-line Application resource access is lack of standardization or conclude the business in production environment resource transfer relation and the inconsistent situation of design, thereby cause the problems such as the resource access of redundance and resource access order be inconsistent, these have increased the expense of host system resources, to such an extent as to jeopardize the safety and stability of production run.
Because the operation of main frame on-line transaction need to have access to various interface program and table resource, different transaction flows is made up of various online combination of resources exactly.Resource transfer in an on-line transaction closes the design phase that ties up to application and development to be determined, taking the form of transaction flow design drawing (or application design proposal) as record, the exploitation of on-line transaction program code is carried out according to design, and the test of on-line transaction can only be by checking that execution result verifies, due to the resources relationship situation that cannot collect and grasp on-line transaction actual motion and access.Simultaneously, because an on-line transaction is usually directed to a lot of programs and table resource, different resource module relates to different developers, so in the time that production environment occurs operation exception due to the situation of these unreasonable access, analyst is difficult to put in order at once all resource access information of transaction.
Along with the development of banking, the online class of business of main frame is increasing, the resources relationship that on-line transaction is accessed also will become increasingly complex, in order to ensure that better main frame production safety is stable, in the urgent need to a kind of system and method that host resource visit information is carried out to analysis optimization.
Summary of the invention
For solving the deficiency to on-line transaction host access information processing in prior art, collected resource access data are carried out to rationality optimization analysis.
The invention provides a kind of online middle host transaction resource access Method for Information Optimization, method comprises:
Receive user's demand information;
Determine corresponding resource access data according to described demand information;
Determine the resource access data to be optimized in described resource access data according to the suspicious optimization information of pre-stored;
Generate resource access information optimum results according to the Optimizing Suggestions data of described resource access data to be optimized and pre-stored.
In addition, the invention also discloses a kind of online middle host transaction resource access information optimization device, device comprises:
Receiver module, for receiving user's demand information;
Resource access data determination module, for determining corresponding resource access data according to described demand information;
Resource access data determination module to be optimized, for determining the resource access data to be optimized of described resource access data according to the suspicious optimization information of pre-stored;
Optimum results generation module, for generating resource access information optimum results according to the Optimizing Suggestions data of described resource access data to be optimized and pre-stored.
The present invention realizes the trading resources path of collecting transaction actual motion at test environment, and generate relationship trading process flow diagram, can only there is the resource transfer relation of transaction and design inconsistent problem by checking that execution result is verified in the test that solves on-line transaction.Automatic analysis is excavated out the resource access situation of suspicious optimization, and proposes expert's Optimizing Suggestions, greatly saves human input.
For above and other object of the present invention, feature and advantage can be become apparent, preferred embodiment cited below particularly, and coordinate appended graphicly, be described in detail below.
Brief description of the drawings
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, to the accompanying drawing of required use in embodiment or description of the Prior Art be briefly described below, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skill in the art, do not paying under the prerequisite of creative work, can also obtain according to these accompanying drawings other accompanying drawing.
Fig. 1 is the process flow diagram of a kind of on-line transaction resource access of the present invention Method for Information Optimization;
Fig. 2 be in the embodiment of the present invention according to demand information determine the process flow diagram of corresponding resource access data;
Fig. 3 is the process flow diagram that in the embodiment of the present invention, the Optimizing Suggestions data of resource access data to be optimized and corresponding pre-stored generate resource access information optimum results;
Fig. 4 is the block diagram of a kind of online middle host transaction resource access information optimization device of the present invention;
Fig. 5 is the block diagram of resource access data determination 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 the disclosed host resource visit information of the embodiment of the present invention carries out analysis optimization;
Fig. 8 is the block diagram of the resource access gathering-device in the embodiment of the present invention;
Fig. 9 is the block diagram of the resource access analytical equipment in the embodiment of the present invention;
Figure 10 is the process flow diagram that in the embodiment of the present invention, suspicious optimization checks the pretreated method in items for information storehouse;
Figure 11 is the process flow diagram of the pretreated method of Optimizing Suggestions data in the embodiment of the present invention;
Figure 12 is that in the embodiment of the present invention, resource access is collected step;
Figure 13 is that in the embodiment of the present invention, resource access is optimized analytical procedure.
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 clearly and completely described, obviously, described embodiment is only the present invention's part embodiment, instead of whole embodiment.Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtaining under creative work prerequisite, belong to the scope of protection of the invention.
The invention provides host resource visit information optimization method in a kind of on-line transaction, as shown in Figure 1, method of the present invention comprises:
Step S101, reception user's demand information;
Step S102, determines corresponding resource access data according to described demand information;
Step S103, determines the resource access data to be optimized in described resource access data according to the suspicious optimization information of pre-stored;
Step S104, generates resource access information optimum results according to the Optimizing Suggestions data of described resource access data to be optimized and corresponding pre-stored.
Wherein, in step S102, information is determined corresponding resource access data according to demand, resource access data comprise: the online call number of program, repetition recalls information, transaction duplicate block recalls information, the transaction of transaction to same interface in transaction are used dynamic sql information, transaction to use the SQL of vernier reading manner information, transaction to count information and the repeated accesses information of transaction to same table, concrete steps as shown in Figure 2, comprising:
Step S201, determines on-line transaction test environment and the time period information of corresponding demand information according to the user's who receives demand information;
Step S202, routine call and SQL visit information while determining on-line transaction operation according to transaction test environment and time period information;
Step S203, determines corresponding resource access data according to routine call and SQL visit information.
Step S103, determine that according to the suspicious optimization information of pre-stored the resource access data to be optimized in described resource access data comprise: according to transaction internal program online (LINK) call number of the suspicious optimization information comparison resource access data of pre-stored, the repetition recalls information of transaction to same interface, transaction duplicate block recalls information, transaction is used dynamic sql information, transaction is used vernier to read (OPEN FETCH) mode information, the SQL of transaction counts information and the repeated accesses information of transaction to same table, determine the resource access data to be optimized in described resource access data.
As shown in Figure 3, step S104 generates resource access information optimum results according to the Optimizing Suggestions data of resource access data to be optimized and corresponding pre-stored and comprises:
Step S301, determines corresponding Optimizing Suggestions data according to the Optimizing Suggestions data of resource access data to be optimized and pre-stored;
Step S302, generates trading resources call graph according to resource access data to be optimized;
Step S303, exports resource access data to be optimized, corresponding Optimizing Suggestions data and trading resources call graph 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 comprises:
Receiver module 501, for receiving user's demand information;
Resource access data determination module 502, for determining corresponding resource access data according to described demand information;
Resource access data determination module 503 to be optimized, for determining the resource access data to be optimized of described resource access data according to the suspicious optimization information of pre-stored;
Optimum results generation module 504, for generating resource access information optimum results according to the Optimizing Suggestions data of described resource access data to be optimized and pre-stored.
In addition, also comprise memory module, for storing described resource access data, resource access information optimum results
As shown in Figure 5, the resource access data determination module 502 of the online middle host transaction resource access information optimization device of the present embodiment comprises:
Demand information determining unit 5021, for determining on-line transaction test environment and the time period information of corresponding described demand information according to the user's who receives demand information;
On-line information determining unit 5022, routine call and SQL visit information when determine on-line transaction operation according to described transaction test environment and time period information;
Visit data determining unit 5023, for determining corresponding resource access data according to described routine call and SQL visit information.
As shown in Figure 6, optimum results generation module 504 comprises:
Optimizing Suggestions generation unit 5041, determines corresponding Optimizing Suggestions data according to the Optimizing Suggestions data of described resource access data to be optimized and pre-stored;
Call graph generation unit 5042, for generating trading resources call graph according to described resource access data to be optimized; Realize the trading resources path of collecting transaction actual motion at test environment, and generate relationship trading process flow diagram, the test that solves on-line transaction can only be verified the resource transfer relation and the inconsistent problem of design that occur transaction by inspection execution result.
Optimum results output unit 5043, for exporting described resource access data to be optimized, corresponding Optimizing Suggestions data and trading resources call graph as resource access information optimum results.
Below in conjunction with concrete embodiment, technical scheme of the present invention is described in further details:
As shown in Figure 7, the disclosed host resource visit information of the embodiment of the present invention carries out the method for analysis optimization, and the method is to utilize the collection of the online resource access information that the present invention is made up of resource access gathering-device 100, resource access analytical equipment 200 and data storage device 300, associated, filtration, typing, analysis, Optimizing Suggestions and the patterned processing of flow process.Resource access gathering-device 100 and resource access analytical equipment 200 are linked in sequence, and are all connected with data storage device 300.Concrete, the method that the host resource visit information of the present embodiment carries out analysis optimization is as follows:
Step 1: optimize analytical information pre-treatment step: the suspicious optimization in data storage device 300 is checked to items for information storehouse 303 and Optimizing Suggestions database 304 carry out pre-service;
Step 2: resource access collection and treatment step: resource access gathering-device 100 is according to the user's request of reading in, specify online version environment to carry out the collection of online resource access information to user's request, through resource information, associated and filtration, is entered into resource access information database;
Step 3: resource access analyzing and processing step: resource access analytical equipment 200 checks items for information storehouse according to suspicious optimization, data in resource access information database are checked, excavate out problematic online resource access situation, then according to Optimizing Suggestions database, these doubtful problems are proposed to relevant Optimizing Suggestions, and generate trading resources call graph, finally doubtful problem, relevant Optimizing Suggestions and trading resources call graph are saved in to 300 li of data storage devices.
As shown in Figure 8, be the block diagram of the resource access gathering-device 100 in the embodiment of the present invention.
Resource access gathering-device 100 is for receiving the collection, association of customer analysis demand and on-line transaction resource access information, the processing of overanxious and typing, and it comprises five parts: analyze demand receiver module 101, resource information is captured module 102, transaction relating module 103, the overanxious module 104 of data and data typing module 105.Resource information is captured module 102 according to on-line environment and the time period information of analyzing user that demand receiver module 101 receives and input the information of will collecting, collect the resource information of accessing according to the on-line transaction of the specified test environment of user's request operation, and give transaction relating module 103 by the information of collection and process, the resource information of transaction relating module 103 associated same transactions, form trading resources path data, then give data filtering module 104, data filtering module 104 is according to trading resources browsing process, carry out unique key assignments contrast with the resource path unique index information 301 of data storage device 300, filter out and collected, the trading resources browsing process repeating, the resource access information database 302 that the data after filtering are entered into data storage device 300 by data typing module 105 is stored.
As shown in Figure 9, resource access analytical equipment 200 carries out analysis on its rationality for the resource access information to collected, relevant Optimizing Suggestions is proposed, and generating trading resources call graph, it comprises four parts: resource access analysis on its rationality module 201, Optimizing Suggestions module 202, transaction flow graphical module 203 and analysis result output module 204.Resource access analysis on its rationality module 201 checks that according to the suspicious optimization of data storage device 300 items for information storehouse 303 checks the data of 302 li of resource access information databases, excavate out problematic online resource access situation, Optimizing Suggestions module 202 proposes relevant Optimizing Suggestions according to the Optimizing Suggestions database 304 of data storage device 300 to these doubtful problems, transaction flow graphical module 203 is for generating relevant trading resources call graph, analysis result output module 204 is by these doubtful problems, relevant Optimizing Suggestions and trading resources call graph are saved in the analysis result memory module 305 of data storage device 300.
Data storage device 300 for pre-stored analysis before and Optimizing Suggestions need related data, it comprises: resource path unique index information storage module 301, resource access information database memory module 302, suspicious optimization check items for information storehouse 303, Optimizing Suggestions database 304 and analysis result memory module 305.Resource path unique index information storage module 301 is for storing online resource access path unique index information; Resource access information database memory module 302 is for storing the on-line transaction resource access information after associated and overanxious; Suspicious optimization checks the coherence check project that items for information repository 303 uses for the analysis of storage resources Access Optimization; Optimizing Suggestions database is used for storing 304 pairs of suspicious optimization entries and proposes relevant expert's Optimizing Suggestions information; Analysis result memory module 305 is for storing doubtful problem, relevant Optimizing Suggestions and trading resources call graph.Realize the trading resources path of collecting transaction actual motion at test environment, and generate relationship trading process flow diagram, the test that solves on-line transaction can only be verified the resource transfer relation and the inconsistent problem of design that occur transaction by inspection execution result.
Above-mentioned step 1 is optimized in analytical information pre-treatment step, and the suspicious optimization in data storage device 300 is checked to the pretreated method in items for information storehouse is specially, as shown in figure 10:
Step S1101: suspicious optimization checks that items for information conclusion deduction generates;
Step S1102: suspicious optimization checks items for information typing;
Step S1103: suspicious optimization is checked to items for information stores in data storage device 300.
Step 1 is optimized in analytical information pre-treatment step, the pretreated method of Optimizing Suggestions data in data storage device 300 is specially, as shown in figure 11:
Step S1201: Optimizing Suggestions Data induction is deduced and generated;
Step S1202: Optimizing Suggestions data typing;
Step S1203: Optimizing Suggestions data are stored in data storage device 300.
Described suspicious optimization checks that the data of items for information library storage comprise:
1) the online LINK call number of transaction internal program is unreasonable
LINK time number obviously exceedes mean value, and explanation may exist transaction flow too complicated, easily has influence on transaction processing efficiency.
2) transaction repeats to call to same interface
Same interface is repeated to call access, and explanation may exist Interface design unreasonable.
3) transaction repeats to call across subregion
Transaction repeats to call across subregion, and explanation may exist Interface design unreasonable.
4) transaction is used dynamic sql
Use dynamic sql to have following problem: CPU expense is higher; Access path is uncertain; Easily meeting and version are installed conflict.
5) transaction is used vernier to read OPEN/FETCH mode, but only reads a record
Only read the SQL of a record for OPEN/FETCH, can increase DB2 open close the consumption of vernier or do not select best database access path and increase DB2 consume.
6) the SQL number of transaction is unreasonable
7) transaction is to same table repeated accesses
The suspicious optimization that this system uses at present checks items for information and optimizes analysis and suggestion and is exemplified below:
1) LINK number of transaction is unreasonable, obviously exceedes average time
Case study: the restriction of interface communication district, the data of single treatment are limited, cause repeatedly calling;
Optimizing Suggestions: expansion interface communication district.
2) transaction is used dynamic sql
Case study: usage data built-in function obtains or calculation date;
Optimizing Suggestions: for the programming of simplifying multiple condition entries is used dynamic sql.
3) transaction is used OPEN/FETCH mode, but only reads a record
Case study: do not observe programming specification;
Optimizing Suggestions: use wall scroll query statement (SINGLE SELECT) access; For the access that there is no unique key, as long as and read any one, use and only get the first row statement (FETCH FIRST ONE ROW ONLY) optimization.
4) transaction repeats to call across subregion
Case study: repeatedly call across subregion the interface that relevant integration function is provided;
Optimizing Suggestions: the interface of integrating correlation function.
5) one of single on-line transaction repeated accesses is table or calls SQL to exceed 200
Case study: the access result of his-and-hers watches of concluding the business above is not transmitted shared, needs access list again while causing the identical information data of follow-up needs.；
Optimizing Suggestions: the result of table access is for the first time transmitted for follow-up interface at program variable or by communication district, avoided this table of repeated accesses in a transaction flow.
The concrete steps that the resource access of step 2 is collected step are as shown in figure 12:
Step 1301: read in associated user's demand information, comprise online testing environment and the time period etc. of collection information;
Step 1302: the relevant information of routine call and SQL access while automatically recording in chronological order every on-line transaction operation;
Step 1303: the resource that same transaction is accessed is carried out association and integrated;
Step 1304: generate trading resources path data;
Step 1305: the unique retrieval of transaction searching route is filtered, and is specially:
Carry out unique key assignments contrast with the resource path unique index information of data storage device;
Judge whether this resource path unique index exists, filter if existed, just forward step 1306 to;
If there is no, just information is 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 concrete steps that the resource access of step 3 is optimized analytical procedure are as shown in figure 13:
Step 1401: check items for information storehouse according to suspicious optimization, the data in resource access information database are checked, excavate out problematic online resource access situation;
Step 1402: these doubtful problems are proposed to relevant Optimizing Suggestions according to Optimizing Suggestions database;
Step 1403: generate trading resources call graph;
Step 1404: doubtful problem, relevant Optimizing Suggestions and trading resources call graph are saved in to 300 li of data storage devices.
Owing to adopting said method and structure, a kind of system and method that host resource visit information is carried out to analysis optimization of the present invention has following beneficial effect:
Can provide at once the online resource access situation of producing, quick positioning question reason:
The present invention realizes the transaction access resources information of collecting transaction actual motion at test environment, is entered into database, and in the time that production goes wrong, analyst can inquire about at once, quick positioning question reason.
Generate the transaction flow figure of actual motion, whether checking is consistent with design:
The present invention realizes the trading resources path of collecting transaction actual motion at test environment, and generate relationship trading process flow diagram, can only there is the resource transfer relation of transaction and design inconsistent problem by checking that execution result is verified in the test that solves on-line transaction.
Automatic analysis is excavated out the resource access situation of suspicious optimization, and proposes expert's Optimizing Suggestions, greatly saves human input:
The present invention realizes the resource access situation of excavating out various suspicious optimizations according to Expert Rules information automatic analysis, for the large-scale application system of on-line transaction complexity, can ensure each on-line transaction to carry out resource access optimization analysis, and expert's Optimizing Suggestions proposed, greatly save the human input of optimizing application, can realize the optimized resource access of on-line transaction, maximum minimizing mainframe program resource consumption, take in time Optimized Measures to avoid relevant issues to occur, thereby the performance that has ensured program operation, has ensured the safe operation of producing.
Effect aspect business impact analysis:
The flow process of application transaction can be understood and be familiar with by the collected on-line transaction resource access information of the present invention to the system personnel of data center's production environment, makes system personnel can locate quickly the reason of production problem, more accurately holds the service impact scope of problem.As:
(1) determine that fast certain list structure changes the transaction relating to;
(2) determine fast the number of deals affecting stop using certain program or table in production environment time.
Effect at application architecture design aspect:
The collected on-line transaction resource access information of the present invention is saved in database, form the account data storehouse of whole application flow, the technological means efficiently of providing convenience counts on the various resource service conditions of transaction, thereby make architecture design personnel can more accurately grasp application actual conditions, better carry out relevant application architecture transformation.
In the present invention, applied specific embodiment principle of the present invention and embodiment are set forth, the explanation of above embodiment is just for helping to understand method of the present invention and core concept thereof; , for one of ordinary skill in the art, according to thought of the present invention, all will change in specific embodiments and applications, in sum, this description should not be construed as limitation of the present invention meanwhile.
Claims (12)
1. a host resource visit information optimization method in on-line transaction, is characterized in that, described method comprises:
Receive user's demand information;
Determine corresponding resource access data according to described demand information;
Determine the resource access data to be optimized in described resource access data according to the suspicious optimization information of pre-stored;
Generate resource access information optimum results according to the Optimizing Suggestions data of described resource access data to be optimized and corresponding pre-stored.
2. host resource visit information optimization method in on-line transaction as claimed in claim 1, is characterized in that, described determines that according to described demand information corresponding resource access data comprise:
Determine on-line transaction test environment and the time period information of corresponding described demand information according to the user's who receives demand information;
Routine call and SQL visit information while determining on-line transaction operation according to described transaction test environment and time period information;
Determine corresponding resource access data according to described routine call and SQL visit information.
3. host resource visit information optimization method in on-line transaction as claimed in claim 1, it is characterized in that, described resource access data comprise: the online call number of program, repetition recalls information, transaction duplicate block recalls information, the transaction of transaction to same interface in transaction are used dynamic sql information, transaction to use the SQL of vernier reading manner information, transaction to count information and the repeated accesses information of transaction to same table.
4. host resource visit information optimization method in on-line transaction as claimed in claim 2, is characterized in that, the described suspicious optimization information according to pre-stored determines that the resource access data to be optimized in described resource access data comprise:
The online call number of program, repetition recalls information, transaction duplicate block recalls information, the transaction of transaction to same interface compared according to the suspicious optimization information of described pre-stored in the transaction of described resource access data are used dynamic sql information, transaction to use the SQL of vernier reading manner information, transaction to count information and the repeated accesses information of transaction to same table, determine the resource access data to be optimized in described resource access data.
5. host resource visit information optimization method in on-line transaction as claimed in claim 4, is characterized in that, the described Optimizing Suggestions data according to described resource access data to be optimized and pre-stored generate resource access information optimum results and comprise:
Determine corresponding Optimizing Suggestions data according to the Optimizing Suggestions data of described resource access data to be optimized and pre-stored;
Generate trading resources call graph according to described resource access data to be optimized;
Described resource access data to be optimized, corresponding Optimizing Suggestions data and trading resources call graph are exported as resource access information optimum results.
6. online middle host transaction resource access Method for Information Optimization as claimed in claim 5, is characterized in that, described method also comprises:
Resource access data, resource access information optimum results that storage is described.
7. a host resource visit information optimization device in on-line transaction, is characterized in that, described device comprises:
Receiver module, for receiving user's demand information;
Resource access data determination module, for determining corresponding resource access data according to described demand information;
Resource access data determination module to be optimized, for determining the resource access data to be optimized of described resource access data according to the suspicious optimization information of pre-stored;
Optimum results generation module, for generating resource access information optimum results according to the Optimizing Suggestions data of described resource access data to be optimized and corresponding pre-stored.
8. host resource visit information optimization device in on-line transaction as claimed in claim 7, is characterized in that, described resource access data determination module comprises:
Demand information determining unit, for determining on-line transaction test environment and the time period information of corresponding described demand information according to the user's who receives demand information;
On-line information determining unit, routine call and SQL visit information when determine on-line transaction operation according to described transaction test environment and time period information;
Visit data determining unit, for determining corresponding resource access data according to described routine call and SQL visit information.
9. host resource visit information optimization device in on-line transaction as claimed in claim 8, it is characterized in that, described resource access data comprise: the online call number of program, repetition recalls information, transaction duplicate block recalls information, the transaction of transaction to same interface in transaction are used dynamic sql information, transaction to use the SQL of vernier reading manner information, transaction to count information and the repeated accesses information of transaction to same table.
10. host resource visit information optimization device in on-line transaction as claimed in claim 9, is characterized in that, described resource access data determination module to be optimized comprises:
The online call number of program, repetition recalls information, transaction duplicate block recalls information, the transaction of transaction to same interface compared according to the suspicious optimization information of described pre-stored in the transaction of described resource access data are used dynamic sql information, transaction to use the SQL of vernier reading manner information, transaction to count information and the repeated accesses information of transaction to same table, determine the resource access data to be optimized in described resource access data.
In 11. on-line transactions as claimed in claim 10, host resource visit information optimization device, is characterized in that, described optimum results generation module comprises:
Optimizing Suggestions generation unit, determines corresponding Optimizing Suggestions data according to the Optimizing Suggestions data of described resource access data to be optimized and pre-stored;
Call graph generation unit, for generating trading resources call graph according to described resource access data to be optimized;
Optimum results output unit, for exporting described resource access data to be optimized, corresponding Optimizing Suggestions data and trading resources call graph as resource access information optimum results.
In 12. on-line transactions as claimed in claim 10, host resource visit information optimization device, is characterized in that, described device also comprises:
Memory module, for storing described resource access data, resource access information optimum results.
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 true CN103955516A (en) | 2014-07-30 |
| CN103955516B 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) |
Cited By (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 (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070112956A1 (en) * | 2005-11-12 | 2007-05-17 | Chapman Matthew P | Resource optimisation component |
| 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 |
-
2014
- 2014-05-05 CN CN201410186938.7A patent/CN103955516B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070112956A1 (en) * | 2005-11-12 | 2007-05-17 | Chapman Matthew P | Resource optimisation component |
| 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 |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106681909A (en) * | 2016-12-02 | 2017-05-17 | 中国工商银行股份有限公司 | Online transaction fault locating method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103955516B (en) | 2018-01-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20200019494A1 (en) | Method and apparatus for performing test by using test case | |
| US20210342313A1 (en) | Autobuild log anomaly detection methods and systems | |
| US8578348B2 (en) | System and method of cost oriented software profiling | |
| US20180285417A1 (en) | Intelligent query parameterization of database workloads | |
| US20220058170A1 (en) | Systems and methods for indexing and searching | |
| KR102229010B1 (en) | System and method for modelling data | |
| US20130305224A1 (en) | Rules Engine for Architectural Governance | |
| CN102279790A (en) | Distributed debugging method and system | |
| CN106559438A (en) | A kind of program method for uploading and device based on objective network platform | |
| CN103473672A (en) | System, method and platform for auditing metadata quality of enterprise-level data center | |
| US8904357B2 (en) | Dashboard for architectural governance | |
| CN107657052A (en) | A kind of data governing system based on metadata management | |
| US9311345B2 (en) | Template based database analyzer | |
| Yao et al. | Log4Perf: Suggesting and updating logging locations for web-based systems’ performance monitoring | |
| CN104050182A (en) | Configurable rule for monitoring data of in-memory database | |
| CN115335821A (en) | Offloading statistics collection | |
| Procaccianti et al. | Energy efficiency of orm approaches: an empirical evaluation | |
| US20220245125A1 (en) | Dataset multiplexer for data processing system | |
| US20160139961A1 (en) | Event summary mode for tracing systems | |
| CN116541372A (en) | Data asset management method and system | |
| US20120124428A1 (en) | Method and system for testing software on programmable devices | |
| CN109597706B (en) | Detection method, device and system for checking difference data | |
| CN103955516A (en) | Method and device for optimizing host computer resource access information in on-line transaction | |
| CN107894942B (en) | Method and device for monitoring data table access amount | |
| Butrovich et al. | Tastes great! less filling! high performance and accurate training data collection for self-driving database management systems |
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 |