CN110895542B - High-risk SQL statement screening method and device - Google Patents
High-risk SQL statement screening method and device Download PDFInfo
- Publication number
- CN110895542B CN110895542B CN201911189244.8A CN201911189244A CN110895542B CN 110895542 B CN110895542 B CN 110895542B CN 201911189244 A CN201911189244 A CN 201911189244A CN 110895542 B CN110895542 B CN 110895542B
- Authority
- CN
- China
- Prior art keywords
- execution
- execution plan
- probability
- performance problems
- sql
- 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
Images
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/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Fuzzy Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Stored Programmes (AREA)
Abstract
The invention discloses a high-risk SQL statement screening method and a high-risk SQL statement screening device, wherein the method comprises the following steps: acquiring a historical execution plan sample, and marking and classifying SQL sentences in the historical execution plan sample according to whether performance problems exist or not; acquiring an execution string generated by each execution plan in a historical execution plan sample, and taking the execution string as a feature unit; acquiring prior probability data according to marking classification results; according to a Bayesian classification algorithm, in combination with prior probability data, obtaining the probability of performance problems of SQL sentences corresponding to each feature unit in the execution plan to be processed; and screening out the SQL sentences with high risk according to the probability that the SQL sentences corresponding to the characteristic units in the execution plan to be processed have performance problems. The invention can be realized without experienced professionals, has lower requirement on workers, reduces the labor intensity of the workers, improves the working efficiency and reduces the labor cost.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a high-risk SQL statement screening method and device.
Background
The performance of an Oracle database application program depends on an execution plan of a Structured Query Language (SQL) to a great extent, in the development process of a large-scale software system, many SQL statements are often involved, and many changes may occur according to changes of transaction situations, so it is very important to regularly screen out high-risk SQL statements corresponding to the execution plan in order to avoid catastrophic performance influence of the execution plan in actual operation.
Currently, a worker generally determines whether an SQL statement corresponding to an execution plan is a high-risk SQL statement by using previous rich experience.
The inventor finds that the prior art has at least the following problems:
the requirement of the prior art on workers is high, so that the labor intensity of the workers is increased, and the labor cost is increased.
Disclosure of Invention
The embodiment of the invention provides a high-risk SQL statement screening method, which is used for reducing the requirements, labor intensity and cost of workers and comprises the following steps:
acquiring a historical execution plan sample, and marking and classifying SQL sentences in the historical execution plan sample according to whether performance problems exist;
acquiring an execution string generated by each execution plan in a historical execution plan sample, and taking the execution string as a feature unit;
obtaining prior probability data according to the marking classification result, wherein the prior probability data comprises: the probability that the SQL sentences in the historical execution plan samples have performance problems, the probability that the SQL sentences in the historical execution plan samples do not have the performance problems, the probability of each characteristic unit when the SQL sentences have the performance problems, and the probability of each characteristic unit when the SQL sentences have no performance problems;
according to a Bayesian classification algorithm, in combination with prior probability data, obtaining the probability of performance problems of SQL sentences corresponding to each feature unit in the execution plan to be processed;
and screening out the SQL sentences with high risk according to the probability that the SQL sentences corresponding to the characteristic units in the execution plan to be processed have performance problems.
Optionally, the method further includes:
and sequencing the probability of performance problems of the SQL sentences corresponding to the characteristic units in the execution plan to be processed from high to low.
Optionally, the execution plan includes a plurality of execution chains, and each execution chain includes a plurality of execution atoms;
the method further comprises the following steps:
and establishing a conversion corresponding dictionary, and appointing conversion codes for a plurality of execution atoms in the execution plan.
Optionally, obtaining an execution string generated by each execution plan in the historical execution plan sample includes:
disassembling a plurality of execution chains in each execution plan in a historical execution plan sample;
and acquiring a plurality of execution strings according to the disassembly result.
The embodiment of the invention also provides a high-risk SQL statement screening device, which is used for reducing the requirements, labor intensity and cost for workers and comprises the following components:
the classification module is used for acquiring a historical execution plan sample and marking and classifying SQL sentences in the historical execution plan sample according to whether performance problems exist or not;
the execution string acquisition module is used for acquiring execution strings generated by execution plans in a historical execution plan sample and taking the execution strings as feature units;
a data obtaining module, configured to obtain prior probability data according to the result of the marking classification, where the prior probability data includes: the probability of performance problems of SQL statements in the historical execution plan sample, the probability of no performance problems of the SQL statements in the historical execution plan sample, the probability of performance problems of all characteristic units in the SQL statements, and the probability of performance problems of all characteristic units in the SQL statements;
the probability acquisition module is used for acquiring the probability of performance problems of SQL sentences corresponding to each characteristic unit in the execution plan to be processed according to a Bayesian classification algorithm and in combination with prior probability data;
and the SQL statement screening module is used for screening out the SQL statements with high risk according to the probability of performance problems of the SQL statements corresponding to the characteristic units in the execution plan to be processed.
Optionally, the apparatus further comprises:
and the sequencing module is used for sequencing the probability of performance problems of the SQL sentences corresponding to the characteristic units in the execution plan to be processed from high to low.
Optionally, the execution plan includes a plurality of execution chains, and each execution chain includes a plurality of execution atoms;
the device further comprises:
and the format conversion module is used for establishing a conversion corresponding dictionary and appointing conversion codes for a plurality of execution atoms in the execution plan.
Optionally, the execution string obtaining module is further configured to:
disassembling a plurality of execution chains in each execution plan in a historical execution plan sample;
and acquiring a plurality of execution strings according to the disassembly result.
The embodiment of the present invention further provides a computer device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, and the processor implements the method when executing the computer program.
An embodiment of the present invention further provides a computer-readable storage medium, in which a computer program for executing the above method is stored.
In the embodiment of the invention, the historical execution plan sample is obtained, marking classification is carried out on SQL sentences in the historical execution plan sample according to whether performance problems exist or not, prior probability data is obtained according to the marking classification result, the probability that the performance problems exist in the SQL sentences corresponding to all the characteristic units in the execution plan to be processed is obtained according to the Bayesian classification algorithm and in combination with the prior probability data, the SQL sentences with high risk can be screened out, the whole process can be completed only on the basis of the statistical principle of the Bayesian classification algorithm, experienced professionals are not needed, the requirements on the workers are low, the labor intensity of the workers is reduced, the working efficiency is improved, and the labor cost is reduced.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the embodiments or the prior art descriptions will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and other drawings can be obtained by those skilled in the art without creative efforts. In the drawings:
FIG. 1 is a flowchart of a high risk SQL statement screening method in an embodiment of the present invention;
FIG. 2 is a diagram of a first specific example of a high-risk SQL statement screening method according to an embodiment of the present invention;
FIG. 3 is a diagram of a second specific example of a high-risk SQL statement screening method according to an embodiment of the invention;
FIG. 4 is a diagram illustrating an exemplary implementation plan in accordance with an embodiment of the present invention;
fig. 5 is a schematic structural diagram of a high-risk SQL statement screening apparatus in an embodiment of the present invention;
fig. 6 is a diagram illustrating a specific example of a high-risk SQL statement screening apparatus according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the embodiments of the present invention are further described in detail below with reference to the accompanying drawings. The exemplary embodiments and descriptions of the present invention are provided to explain the present invention, but not to limit the present invention.
Fig. 1 is a flowchart of a high-risk SQL statement screening method provided in an embodiment of the present invention, and as shown in fig. 1, the method includes:
In this embodiment, the historical execution plan sample can be collected by monitoring an Oracle database system table (e.g., v $ sql _ plan) in an actual environment.
Because an OLAP (Online Analytical Processing) system and an OLTP (On-Line Transaction Processing) system have obvious distinction for identifying an SQL execution plan, two different models are generally respectively constructed during engineering use, and the key difference of model construction lies in the marking standard of the problem SQL. That is, two different models respectively constructed for the OLAP system and the OLTP system need to perform marking classification on SQL statements in a historical execution plan sample according to whether performance problems exist.
And 102, acquiring an execution string generated by each execution plan in a historical execution plan sample, and taking the execution string as a characteristic unit.
In this embodiment, obtaining an execution string generated by each execution plan in a historical execution plan sample includes:
disassembling a plurality of execution chains in each execution plan in a historical execution plan sample;
and acquiring a plurality of execution chain combinations, namely execution strings according to the disassembly result.
In specific implementation, the maximum calculation length of the model execution chain is set first. The programming implements the scanning iteration of all chain combinations with the chain length less than or equal to the maximum chain length according to the execution sequence of the execution plan, and counts the repeated combinations, and for the execution plan, for example, as shown in fig. 4:
setting the maximum execution chain length to be 3, and forming an execution chain combination after disassembling
(
(TABLE ACCESS FULL,PARTITION RANGE ALL)2,
(TABLE ACCESS FULL,PARTITION RANGE ALL,HASH GROUP BY)2,
(PARTITION RANGE ALL,HASH GROUP BY)2,
(PARTITION RANGE ALL,HASH GROUP BY,VIEW)2,
(HASH GROUP BY,VIEW)2,
(HASH GROUP BY,VIEW,VIEW)1,
(VIEW,VIEW)1,
(VIEW,VIEW,HASH JOIN)2,
(VIEW,HASH JOIN)2,
(HASH GROUP BY,VIEW,HASH JOIN)1
)
And completing chain disassembly statistics on all prior samples. Where the number following each execution chain combination indicates the number of times it appears in the execution plan. Each combination of execution chains may be considered a feature element mentioned in the embodiments of the present invention.
103, obtaining prior probability data according to the marking classification result, wherein the prior probability data comprises: the probability of performance problems of SQL statements in the historical execution plan samples, the probability of no performance problems of the SQL statements in the historical execution plan samples, the probability of performance problems of the SQL statements of each characteristic unit and the probability of performance problems of the SQL statements of each characteristic unit are determined.
And 104, acquiring the probability of performance problems of SQL sentences corresponding to each feature unit in the execution plan to be processed according to a Bayesian classification algorithm and by combining prior probability data.
wherein C is a class, W n For each feature cell, in the present embodiment, C 0 For normal execution plans (i.e., execution plans without performance issues for SQL statements), C 1 For problem execution planning (i.e., execution planning for SQL statement with performance problem), W n P is the probability for n different execution chain combinations.
The selected characteristics are all execution chains, and the influence of all execution chain combinations on the SQL statement problem is set to be mutually independent. Then, conversion is carried out according to a Bayesian classification formula to obtain a first calculation formula and a second calculation formula:
therefore, only the execution chain combination characteristics of the execution plan to be processed need to be clarified when the classification is calculated, and the probability of each part of characteristic units under the current characteristics can be calculated by substituting the above equation.
Wherein, P (C) 0 )、P(C 1 )、P(w n |C 1 )、P(w n |C 0 )、P(w n ) The prior probability data can be obtained through step 103, and all the prior probability data are recorded and stored to form an algorithm classifier, so that data extraction can be performed during subsequent high-risk SQL statement screening on the execution plan to be processed.
It should be noted that the execution plan to be processed may be collected from an Oracle database system table, and dictionary mapping conversion is also required.
And 105, screening out the SQL sentences with high risk according to the probability that the SQL sentences corresponding to the characteristic units in the execution plan to be processed have performance problems.
As can be seen from fig. 1, in the high-risk SQL statement screening method provided in the embodiment of the present invention, the historical execution plan sample is obtained, the SQL statements in the historical execution plan sample are marked and classified according to whether performance problems exist, prior probability data is obtained according to the marking and classifying result, and the probability that the SQL statements corresponding to each feature unit in the execution plan to be processed have the performance problems is obtained according to the bayesian classification algorithm in combination with the prior probability data, so that the SQL statements with high risk can be screened.
In an embodiment of the present invention, in order to improve the efficiency of exhausting the high-risk SQL statements, as shown in fig. 2, the method further includes:
and 106, sequencing the probability of performance problems of the SQL sentences corresponding to the feature units in the execution plan to be processed from high to low.
In specific implementation, expert resources can be allocated according to the probability sorting condition to optimize the SQL sentences, so that the engineering hidden danger is eliminated.
In addition, in order to improve the working efficiency, the actual data generated in the engineering can be verified and then stored in the database as a new history execution plan sample, and the algorithm classifier is updated for the next calculation.
In the embodiment of the present invention, the execution plan includes a plurality of execution chains, and each execution chain includes a plurality of execution atoms;
in order to ensure the smooth proceeding of the subsequent operation, after the SQL statements in the historical execution plan sample are subjected to marking classification according to whether there is a performance problem, format conversion is performed on the execution atoms in the execution plan, as shown in fig. 3, the method further includes:
Based on the same inventive concept, the embodiment of the present invention further provides a high risk SQL statement screening apparatus, as described in the following embodiments. Because the principle of solving the problems of the high-risk SQL statement screening device is similar to that of the high-risk SQL statement screening method, the implementation of the high-risk SQL statement screening device can refer to the implementation of the high-risk SQL statement screening method, and repeated parts are not described again. As used hereinafter, the term "unit" or "module" may be a combination of software and/or hardware that implements a predetermined function. Although the means described in the embodiments below are preferably implemented in software, an implementation in hardware, or a combination of software and hardware is also possible and contemplated.
The embodiment of the invention provides a high-risk SQL statement screening device, as shown in the attached figure 5, the device comprises:
the classification module 201 is configured to obtain a historical execution plan sample, and perform marking classification on SQL statements in the historical execution plan sample according to whether a performance problem exists;
an execution string obtaining module 202, configured to obtain an execution string generated by each execution plan in a historical execution plan sample, where the execution string is used as a feature unit;
a data obtaining module 203, configured to obtain prior probability data according to the result of the marking classification, where the prior probability data includes: the probability that the SQL sentences in the historical execution plan samples have performance problems, the probability that the SQL sentences in the historical execution plan samples do not have the performance problems, the probability of each characteristic unit when the SQL sentences have the performance problems, and the probability of each characteristic unit when the SQL sentences have no performance problems;
the probability obtaining module 204 is configured to obtain, according to a bayesian classification algorithm and in combination with prior probability data, probabilities that performance problems exist in SQL statements corresponding to feature units in the execution plan to be processed;
the SQL statement screening module 205 is configured to screen out an SQL statement with a high risk according to a probability that the SQL statement corresponding to each feature unit in the execution plan to be processed has a performance problem.
In an embodiment of the present invention, as shown in fig. 6, the apparatus further includes:
and the sorting module 206 is configured to sort, from high to low, probabilities that the SQL statements corresponding to the feature units in the execution plan to be processed have the performance problem.
In the embodiment of the present invention, the execution plan includes a plurality of execution chains, and each execution chain includes a plurality of execution atoms;
the device further comprises:
and the format conversion module is used for establishing a conversion corresponding dictionary and appointing conversion codes for a plurality of execution atoms in the execution plan.
In this embodiment of the present invention, the execution string obtaining module 202 is further configured to:
disassembling a plurality of execution chains in each execution plan in a historical execution plan sample;
and acquiring a plurality of execution strings according to the disassembly result.
The embodiment of the present invention further provides a computer device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, and the processor implements the above method when executing the computer program.
An embodiment of the present invention further provides a computer-readable storage medium, where a computer program for executing the foregoing method is stored in the computer-readable storage medium.
In conclusion, the invention has the following advantages:
the method is simple to construct and convenient to implement, can be implemented without professional software assistance and professional execution plan analysis skills, is used as an early warning means to assist development, testing or operation and maintenance personnel to focus on possible problems, improves the working efficiency of the professionals, and reduces the labor cost.
According to the invention, through sequencing the probabilities, the efficiency of eliminating problems is improved, the cost can be reduced to a certain extent, and precious expert resources are saved.
The invention can provide data base for follow-up more accurate probability analysis along with the continuous accumulation and update of the historical execution plan samples.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The above-mentioned embodiments are intended to illustrate the objects, technical solutions and advantages of the present invention in further detail, and it should be understood that the above-mentioned embodiments are only exemplary embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.
Claims (8)
1. A high-risk SQL statement screening method is characterized by comprising the following steps:
acquiring a historical execution plan sample, and marking and classifying SQL sentences in the historical execution plan sample according to whether performance problems exist or not;
acquiring an execution string generated by each execution plan in a historical execution plan sample, and taking the execution string as a feature unit;
obtaining prior probability data according to the marking classification result, wherein the prior probability data comprises: the probability that the SQL sentences in the historical execution plan samples have performance problems, the probability that the SQL sentences in the historical execution plan samples do not have the performance problems, the probability of each characteristic unit when the SQL sentences have the performance problems, and the probability of each characteristic unit when the SQL sentences have no performance problems;
according to a Bayesian classification algorithm, in combination with prior probability data, obtaining the probability of performance problems of SQL sentences corresponding to each feature unit in the execution plan to be processed;
screening out SQL sentences with high risk according to the probability that the SQL sentences corresponding to the characteristic units in the execution plan to be processed have performance problems;
acquiring an execution string generated by each execution plan in a historical execution plan sample, wherein the execution string comprises:
according to the set maximum execution chain length, disassembling a plurality of execution chains in each execution plan in a historical execution plan sample;
and acquiring a plurality of execution chain combinations, namely execution strings according to the disassembly result.
2. The method of claim 1, further comprising:
and sequencing the probability of performance problems of the SQL sentences corresponding to the characteristic units in the execution plan to be processed from high to low.
3. The method of claim 1, wherein the execution plan includes a plurality of execution chains, each execution chain including a plurality of execution atoms;
the method further comprises the following steps:
and establishing a conversion corresponding dictionary, and appointing conversion codes for a plurality of execution atoms in the execution plan.
4. A high risk SQL statement screening device is characterized by comprising:
the classification module is used for acquiring a historical execution plan sample and marking and classifying SQL sentences in the historical execution plan sample according to whether performance problems exist or not;
the execution string acquisition module is used for acquiring execution strings generated by execution plans in a historical execution plan sample and taking the execution strings as feature units;
a data obtaining module, configured to obtain prior probability data according to the result of the marking classification, where the prior probability data includes: the probability that the SQL sentences in the historical execution plan samples have performance problems, the probability that the SQL sentences in the historical execution plan samples do not have the performance problems, the probability of each characteristic unit when the SQL sentences have the performance problems, and the probability of each characteristic unit when the SQL sentences have no performance problems;
the probability acquisition module is used for acquiring the probability of performance problems of SQL sentences corresponding to each characteristic unit in the execution plan to be processed according to a Bayesian classification algorithm and in combination with prior probability data;
the SQL statement screening module is used for screening out the SQL statements with high risk according to the probability of performance problems of the SQL statements corresponding to the feature units in the execution plan to be processed;
the execution string acquisition module is further to:
according to the set maximum execution chain length, disassembling a plurality of execution chains in each execution plan in a historical execution plan sample; and acquiring a plurality of execution chain combinations, namely execution strings according to the disassembly result.
5. The apparatus of claim 4, further comprising:
and the sequencing module is used for sequencing the probability of performance problems of the SQL sentences corresponding to the characteristic units in the execution plan to be processed from high to low.
6. The apparatus of claim 4, wherein the execution plan includes a plurality of execution chains, each execution chain including a plurality of execution atoms;
the device further comprises:
and the format conversion module is used for establishing a conversion corresponding dictionary and appointing conversion codes for a plurality of execution atoms in the execution plan.
7. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of any one of claims 1 to 3 when executing the computer program.
8. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program for executing the method of any one of claims 1 to 3.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201911189244.8A CN110895542B (en) | 2019-11-28 | 2019-11-28 | High-risk SQL statement screening method and device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201911189244.8A CN110895542B (en) | 2019-11-28 | 2019-11-28 | High-risk SQL statement screening method and device |
Publications (2)
Publication Number | Publication Date |
---|---|
CN110895542A CN110895542A (en) | 2020-03-20 |
CN110895542B true CN110895542B (en) | 2022-09-27 |
Family
ID=69786804
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201911189244.8A Active CN110895542B (en) | 2019-11-28 | 2019-11-28 | High-risk SQL statement screening method and device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110895542B (en) |
Families Citing this family (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111858280B (en) * | 2020-07-16 | 2024-02-27 | 中国工商银行股份有限公司 | SQL information processing method, device, equipment and system |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102053961A (en) * | 2009-10-27 | 2011-05-11 | 中兴通讯股份有限公司 | Method and device for SQL statements and system for improving database reliability |
CN105164667A (en) * | 2013-06-26 | 2015-12-16 | 惠普发展公司,有限责任合伙企业 | Modifying an analytic flow |
CN109240901A (en) * | 2018-08-28 | 2019-01-18 | 北京小度信息科技有限公司 | Method for analyzing performance, performance evaluation device, storage medium and electronic equipment |
CN110019349A (en) * | 2019-04-02 | 2019-07-16 | 深圳前海微众银行股份有限公司 | Sentence method for early warning, device, equipment and computer readable storage medium |
CN110442516A (en) * | 2019-07-12 | 2019-11-12 | 上海陆家嘴国际金融资产交易市场股份有限公司 | Information processing method, equipment and computer readable storage medium |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US10664473B2 (en) * | 2017-01-30 | 2020-05-26 | International Business Machines Corporation | Database optimization based on forecasting hardware statistics using data mining techniques |
-
2019
- 2019-11-28 CN CN201911189244.8A patent/CN110895542B/en active Active
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102053961A (en) * | 2009-10-27 | 2011-05-11 | 中兴通讯股份有限公司 | Method and device for SQL statements and system for improving database reliability |
CN105164667A (en) * | 2013-06-26 | 2015-12-16 | 惠普发展公司,有限责任合伙企业 | Modifying an analytic flow |
CN109240901A (en) * | 2018-08-28 | 2019-01-18 | 北京小度信息科技有限公司 | Method for analyzing performance, performance evaluation device, storage medium and electronic equipment |
CN110019349A (en) * | 2019-04-02 | 2019-07-16 | 深圳前海微众银行股份有限公司 | Sentence method for early warning, device, equipment and computer readable storage medium |
CN110442516A (en) * | 2019-07-12 | 2019-11-12 | 上海陆家嘴国际金融资产交易市场股份有限公司 | Information processing method, equipment and computer readable storage medium |
Also Published As
Publication number | Publication date |
---|---|
CN110895542A (en) | 2020-03-20 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
WO2021093140A1 (en) | Cross-project software defect prediction method and system thereof | |
CN108052394B (en) | Resource allocation method based on SQL statement running time and computer equipment | |
CN112181758B (en) | Fault root cause positioning method based on network topology and real-time alarm | |
CN107016018B (en) | Database index creation method and device | |
CN108491991B (en) | Constraint condition analysis system and method based on industrial big data product construction period | |
CN108614778B (en) | Android App program evolution change prediction method based on Gaussian process regression | |
CN111782460A (en) | Large-scale log data anomaly detection method and device and storage medium | |
WO2018159042A1 (en) | Analysis software management system and analysis software management method | |
US20090217246A1 (en) | Evaluating Software Programming Skills | |
EP3846034A1 (en) | Systems and methods for automated testing using artificial intelligence techniques | |
CN113221960B (en) | Construction method and collection method of high-quality vulnerability data collection model | |
CN111783818A (en) | Accurate marketing method based on Xgboost and DBSCAN | |
CN110895542B (en) | High-risk SQL statement screening method and device | |
Rathinam et al. | Rule based heuristic approach for minimizing total flow time in permutation flow shop scheduling | |
CN113743453A (en) | Population quantity prediction method based on random forest | |
CN112888008A (en) | Base station abnormity detection method, device, equipment and storage medium | |
US20190205804A1 (en) | Information processing device, information processing method and computer readable medium | |
CN104331507B (en) | Machine data classification is found automatically and the method and device of classification | |
US8189931B2 (en) | Method and apparatus for matching of bracketed patterns in test strings | |
CN113377962B (en) | Intelligent process simulation method based on image recognition and natural language processing | |
CN116258114A (en) | Circuit simulation method and device based on hypergraph division, server and storage medium | |
Wirawan et al. | Application of data mining to prediction of timeliness graduation of students (a case study) | |
CN111930815A (en) | Method and system for constructing enterprise portrait based on industry attribute and business attribute | |
CN117112857B (en) | Machining path recommending method suitable for industrial intelligent manufacturing | |
CN110309263B (en) | Semantic-based work attribute text content conflict judgment method and device |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |