CN110750512A - Database performance evaluation management method and device - Google Patents
Database performance evaluation management method and device Download PDFInfo
- Publication number
- CN110750512A CN110750512A CN201910849684.5A CN201910849684A CN110750512A CN 110750512 A CN110750512 A CN 110750512A CN 201910849684 A CN201910849684 A CN 201910849684A CN 110750512 A CN110750512 A CN 110750512A
- Authority
- CN
- China
- Prior art keywords
- performance
- database
- performance evaluation
- evaluated
- preset
- 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.)
- Pending
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/21—Design, administration or maintenance of databases
-
- 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/21—Design, administration or maintenance of databases
- G06F16/217—Database tuning
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/04—Forecasting or optimisation specially adapted for administrative or management purposes, e.g. linear programming or "cutting stock problem"
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Strategic Management (AREA)
- General Physics & Mathematics (AREA)
- Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- Development Economics (AREA)
- Game Theory and Decision Science (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Educational Administration (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention discloses a database performance evaluation management method and a database performance evaluation management device, wherein the method comprises the following steps: acquiring a plurality of key performance indexes for evaluating the performance of a database to be evaluated; inputting the key performance indexes into a preset performance evaluation model, and outputting a performance evaluation result of the database to be evaluated; the preset performance evaluation model comprises a performance evaluation formula and a reference factor; and analyzing and optimizing the database to be evaluated according to the performance evaluation result. Compared with the prior art, the method has the following advantages: (1) compared with artificial experience judgment, the method is more scientific and efficient; (2) compared with a database system administrator which handles performance problems in a leaking stoppage (event triggering) mode, the comprehensive management system for realizing the performance problems not only improves the capabilities of analyzing the performance problems and solving the performance problems, but also recovers the initiative of performance management, and can actively prevent and automatically handle the performance problems.
Description
Technical Field
The embodiment of the invention relates to the technical field of computers, in particular to a database performance evaluation management method and device.
Background
At present, the performance evaluation and management of the database are mainly carried out subjectively by a professional database system administrator according to the response time of the database, the concurrency of the database and other conditions. After the performance of the database is evaluated, the management and optimization of the performance of the database are also complex and complicated work, and especially when the number of the databases reaches a certain scale, the workload of database administrators can be increased sharply. At present, the following problems exist in the performance management of the database:
(1) coverage databases are not comprehensive in kind. At present, the mainstream databases are of various types, including traditional commercial database products such as Oracle, Db2 and SQL Server, open-source relational databases such as MySQL and PostgreSQL, and other various NoSQL products such as MongoDB and Redis, and only evaluate and manage the performance of one or more databases, which is difficult to meet the requirements. The requirement for proficiency in mainstream databases is also a great challenge for professional database system administrators.
(2) Different service types are not distinguished, and the refinement degree of performance evaluation and management of the database is not high. The same database has completely different performance evaluation and management ideas and modes under different industries or different business scenes, such as OLAP and OLTP. Unified management of multiple service types is realized, different evaluation and management strategies are configured for different service types, and management with higher refinement degree is required.
(3) Database performance evaluation lacks quantification. The performance of the database lacks quantification and deep analysis of correlation, and for a large-scale database, a comprehensive and accurate database system performance report cannot be quickly formed.
(4) Database performance management is not systematic and problem prevention is difficult to achieve. At present, the mainstream of the industry manages database performance problems in an event-triggered manner, and the problem can be handled only when the performance problems cause actual negative effects on services, which often means problem-driven performance optimization, rather than problem prevention through performance optimization.
Therefore, it is desirable to provide a database performance evaluation management method that overcomes the above-mentioned problems.
Disclosure of Invention
Therefore, embodiments of the present invention provide a database performance evaluation management method and apparatus, so as to solve the problems in the prior art.
In order to achieve the above object, the embodiments of the present invention provide the following technical solutions:
in a first aspect, an embodiment of the present invention provides a database performance evaluation management method, including:
acquiring a plurality of key performance indexes for evaluating the performance of a database to be evaluated;
inputting the key performance indexes into a preset performance evaluation model, and outputting a performance evaluation result of the database to be evaluated; the preset performance evaluation model comprises a performance evaluation formula and a reference factor;
and analyzing and optimizing the database to be evaluated according to the performance evaluation result.
Further, the obtaining of the multiple key performance indicators for evaluating the performance of the database to be evaluated specifically includes:
and acquiring a plurality of key performance indexes for evaluating the performance of the database to be evaluated according to the database type and the service type of the database to be evaluated.
Further, before the plurality of key performance indicators are input into a preset performance evaluation model, the method further includes:
and acquiring the preset performance evaluation model.
Further, the obtaining of the preset performance evaluation model specifically includes:
acquiring a sample data set, wherein the sample data set comprises a preset number of sample databases with the same database type and the same service type, and a plurality of key performance indexes and corresponding performance evaluation results of the sample databases are known;
and performing correlation analysis on the sample database in the sample data set to obtain the preset performance evaluation model.
Further, the analyzing and optimizing the database to be evaluated according to the performance evaluation result specifically includes:
acquiring a performance report of the database to be evaluated according to the performance evaluation result and the corresponding key performance indexes;
and optimizing the database to be evaluated according to the performance report.
In a second aspect, an embodiment of the present invention provides a database performance evaluation management apparatus, including:
the system comprises an acquisition module, a storage module and a processing module, wherein the acquisition module is used for acquiring a plurality of key performance indexes for evaluating the performance of a database to be evaluated;
the evaluation module is used for inputting the key performance indexes into a preset performance evaluation model and outputting a performance evaluation result of the database to be evaluated; the preset performance evaluation model comprises a performance evaluation formula and a reference factor;
and the management module is used for analyzing and optimizing the database to be evaluated according to the performance evaluation result.
Further, the obtaining module is specifically configured to:
and acquiring a plurality of key performance indexes for evaluating the performance of the database to be evaluated according to the database type and the service type of the database to be evaluated.
Further, the management module is specifically configured to:
acquiring a performance report of the database to be evaluated according to the performance evaluation result and the corresponding key performance indexes;
and optimizing the database to be evaluated according to the performance report.
In a third aspect, an embodiment of the present invention provides an electronic device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, where the processor implements the steps of the database performance evaluation management method according to the first aspect when executing the program.
In a fourth aspect, an embodiment of the present invention provides a non-transitory computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the steps of the database performance evaluation management method provided in the first aspect.
Compared with the prior art, the database performance evaluation management method and the database performance evaluation management device provided by the embodiment of the invention have the following advantages:
(1) compared with manual experience judgment, a set of quantitative evaluation system for comprehensively and accurately evaluating the performance condition of the database system is more scientific and efficient through experience judgment, a large number of test summaries and scientific mathematical model analysis;
(2) compared with a database system administrator processing the performance problem in a leakage blocking (event triggering) mode, the system not only improves the capability of analyzing the performance problem and solving the performance problem, but also withdraws the initiative of performance management, and can actively prevent and automatically process the performance problem.
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 description of the embodiments or the prior art will be briefly described below. It should be apparent that the drawings in the following description are merely exemplary, and that other embodiments can be derived from the drawings provided by those of ordinary skill in the art without inventive effort.
The structures, ratios, sizes, and the like shown in the present specification are only used for matching with the contents disclosed in the specification, so that those skilled in the art can understand and read the present invention, and do not limit the conditions for implementing the present invention, so that the present invention has no technical significance, and any structural modifications, changes in the ratio relationship, or adjustments of the sizes, without affecting the functions and purposes of the present invention, should still fall within the scope of the present invention.
Fig. 1 is a schematic flowchart of a database performance evaluation management method according to an embodiment of the present invention;
fig. 2 is a block diagram of a database performance evaluation management apparatus according to an embodiment of the present invention;
fig. 3 is a schematic physical structure diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
The present invention is described in terms of particular embodiments, other advantages and features of the invention will become apparent to those skilled in the art from the following disclosure, and it is to be understood that the described embodiments are merely exemplary of the invention and that it is not intended to limit the invention to the particular embodiments disclosed. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Fig. 1 is a schematic flowchart of a database performance evaluation management method according to an embodiment of the present invention, and as shown in fig. 1, the method may include:
s101, obtaining a plurality of key performance indexes for evaluating the performance of the database to be evaluated.
The key performance index is an index capable of reflecting the performance of the database to be evaluated, and each index has a corresponding index value.
S102, inputting the key performance indexes into a preset performance evaluation model, and outputting a performance evaluation result of the database to be evaluated; the preset performance evaluation model comprises a performance evaluation formula and a reference factor.
In practice, inputting a plurality of key performance indexes into the preset performance evaluation model actually inputs a plurality of key performance indexes into the preset performance evaluation model for operation.
S103, analyzing and optimizing the database to be evaluated according to the performance evaluation result.
Compared with the prior art, the database performance evaluation management method provided by the embodiment of the invention has the following advantages:
(1) compared with manual experience judgment, a set of quantitative evaluation system for comprehensively and accurately evaluating the performance condition of the database system is more scientific and efficient through experience judgment, a large number of test summaries and scientific mathematical model analysis;
(2) compared with a database system administrator processing the performance problem in a leakage blocking (event triggering) mode, the system not only improves the capability of analyzing the performance problem and solving the performance problem, but also withdraws the initiative of performance management, and can actively prevent and automatically process the performance problem.
In an optional embodiment of the present invention, the obtaining of multiple key performance indicators for evaluating performance of a database to be evaluated specifically includes:
and acquiring a plurality of key performance indexes for evaluating the performance of the database to be evaluated according to the database type and the service type of the database to be evaluated.
Specifically, the mainstream database software is covered, and the type of service (OLAP/OLTP) of the mainstream. According to different database software and different service types, the key performance indexes capable of comprehensively reflecting the performance conditions of the database are summarized and summarized.
In an optional embodiment of the present invention, before inputting the plurality of key performance indicators into the preset performance evaluation model, the method further includes:
and acquiring the preset performance evaluation model.
Further, the obtaining of the preset performance evaluation model specifically includes:
acquiring a sample data set, wherein the sample data set comprises a preset number of sample databases with the same database type and the same service type, and a plurality of key performance indexes and corresponding performance evaluation results of the sample databases are known;
and performing correlation analysis on the sample database in the sample data set to obtain the preset performance evaluation model.
Specifically, according to the characteristics of key performance indexes, experiments are carried out in hundreds of sets of databases of the same database type and the same service type to obtain correlation analysis data of the performance state of the database and the index value, and a scoring formula and reference factors of the performance indexes are obtained through a preset performance evaluation model to obtain the preset performance evaluation model. And if the index values are the same, obtaining the same score according to a scoring formula. The better the index value reflects the database performance, the higher the score obtained.
In an optional embodiment of the present invention, the analyzing and optimizing the to-be-evaluated database according to the performance evaluation result specifically includes:
acquiring a performance report of the database to be evaluated according to the performance evaluation result and the corresponding key performance indexes;
and optimizing the database to be evaluated according to the performance report.
Specifically, through analysis of performance index values and index scores of the same type of database (the type of the database is the same as that of the service), performance differences among different database systems are distinguished through transverse comparison, and performance trends of the database systems are reflected through longitudinal comparison. The overall management of database performance issues can be achieved by several aspects:
(1) and carrying out deep correlation analysis on key performance indexes in a performance evaluation system. And analyzing relevant factors influencing the key performance indexes, finding out the root causes influencing the indexes, analyzing how to improve, and realizing comprehensive and accurate performance report of performance evaluation, performance analysis and performance optimization.
(2) And the performance evaluation, analysis and optimization are applied to practice. And analyzing common problems of the key performance indexes, summarizing the reasons of the problems and forming a performance problem prevention scheme. In practice, the performance problem prevention schemes are continuously summarized and perfected, and the problem prevention coverage is gradually enlarged. Under an ideal state, the same problem is solved, the first analysis summarizes the construction of a prevention scheme, and the second analysis can prevent the disease in the bud.
(3) In practice, the processing scheme of the problem of the key performance index is continuously optimized, the processing mode of the same problem under the same scene is standardized, and the automatic processing of the performance problem is realized.
Fig. 2 is a block diagram of a database performance evaluation management apparatus according to an embodiment of the present invention, and as shown in fig. 2, the apparatus includes: an acquisition module 201, an evaluation module 202 and a management module 203. Wherein:
the obtaining module 201 is configured to obtain a plurality of key performance indicators for evaluating performance of a database to be evaluated. The evaluation module 202 is configured to input the plurality of key performance indicators into a preset performance evaluation model, and output a performance evaluation result of the database to be evaluated; the preset performance evaluation model comprises a performance evaluation formula and a reference factor. The management module 203 is configured to analyze and optimize the database to be evaluated according to the performance evaluation result.
Compared with the prior art, the database performance evaluation management device provided by the embodiment of the invention has the following advantages:
(1) compared with manual experience judgment, a set of quantitative evaluation system for comprehensively and accurately evaluating the performance condition of the database system is more scientific and efficient through experience judgment, a large number of test summaries and scientific mathematical model analysis;
(2) compared with a database system administrator processing the performance problem in a leakage blocking (event triggering) mode, the system not only improves the capability of analyzing the performance problem and solving the performance problem, but also withdraws the initiative of performance management, and can actively prevent and automatically process the performance problem.
In an optional embodiment of the present invention, the obtaining module is specifically configured to:
and acquiring a plurality of key performance indexes for evaluating the performance of the database to be evaluated according to the database type and the service type of the database to be evaluated.
In an optional embodiment of the present invention, the management module is specifically configured to:
acquiring a performance report of the database to be evaluated according to the performance evaluation result and the corresponding key performance indexes;
and optimizing the database to be evaluated according to the performance report.
Fig. 3 is a schematic entity structure diagram of an electronic device according to an embodiment of the present invention, and as shown in fig. 3, the electronic device may include: a processor (processor)310, a communication Interface (communication Interface)320, a memory (memory)330 and a communication bus 340, wherein the processor 310, the communication Interface 320 and the memory 330 communicate with each other via the communication bus 340. The processor 310 may invoke a computer program stored on the memory 330 and executable on the processor 310 to perform the network topology detection method provided by the above method embodiments, for example, including: acquiring a plurality of key performance indexes for evaluating the performance of a database to be evaluated; inputting the key performance indexes into a preset performance evaluation model, and outputting a performance evaluation result of the database to be evaluated; the preset performance evaluation model comprises a performance evaluation formula and a reference factor; and analyzing and optimizing the database to be evaluated according to the performance evaluation result.
In addition, the logic instructions in the memory 330 may be implemented in the form of software functional units and stored in a computer readable storage medium when the software functional units are sold or used as independent products. Based on such understanding, the technical solutions of the embodiments of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the methods described in the embodiments of the present invention. And the aforementioned storage medium includes: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
An embodiment of the present invention further provides a non-transitory computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the network topology detection method provided in the foregoing method embodiments, and for example, the method includes: acquiring a plurality of key performance indexes for evaluating the performance of a database to be evaluated; inputting the key performance indexes into a preset performance evaluation model, and outputting a performance evaluation result of the database to be evaluated; the preset performance evaluation model comprises a performance evaluation formula and a reference factor; and analyzing and optimizing the database to be evaluated according to the performance evaluation result.
The above-described embodiments of the apparatus are merely illustrative, and the units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.
Through the above description of the embodiments, those skilled in the art will clearly understand that each embodiment can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware. With this understanding in mind, the above-described technical solutions may be embodied in the form of a software product, which can be stored in a computer-readable storage medium such as ROM/RAM, magnetic disk, optical disk, etc., and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the methods described in the embodiments or some parts of the embodiments.
Finally, it should be noted that: the above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (10)
1. A database performance evaluation management method is characterized by comprising the following steps:
acquiring a plurality of key performance indexes for evaluating the performance of a database to be evaluated;
inputting the key performance indexes into a preset performance evaluation model, and outputting a performance evaluation result of the database to be evaluated; the preset performance evaluation model comprises a performance evaluation formula and a reference factor;
and analyzing and optimizing the database to be evaluated according to the performance evaluation result.
2. The method according to claim 1, wherein the obtaining of the plurality of key performance indicators for evaluating the performance of the database to be evaluated specifically comprises:
and acquiring a plurality of key performance indexes for evaluating the performance of the database to be evaluated according to the database type and the service type of the database to be evaluated.
3. The method of claim 1, further comprising, prior to entering the plurality of key performance indicators into a preset performance evaluation model:
and acquiring the preset performance evaluation model.
4. The method according to claim 3, wherein the obtaining the preset performance evaluation model specifically includes:
acquiring a sample data set, wherein the sample data set comprises a preset number of sample databases with the same database type and the same service type, and a plurality of key performance indexes and corresponding performance evaluation results of the sample databases are known;
and performing correlation analysis on the sample database in the sample data set to obtain the preset performance evaluation model.
5. The method according to claim 1, wherein the analyzing and optimizing the database to be evaluated according to the performance evaluation result specifically comprises:
acquiring a performance report of the database to be evaluated according to the performance evaluation result and the corresponding key performance indexes;
and optimizing the database to be evaluated according to the performance report.
6. A database performance evaluation management apparatus, comprising:
the system comprises an acquisition module, a storage module and a processing module, wherein the acquisition module is used for acquiring a plurality of key performance indexes for evaluating the performance of a database to be evaluated;
the evaluation module is used for inputting the key performance indexes into a preset performance evaluation model and outputting a performance evaluation result of the database to be evaluated; the preset performance evaluation model comprises a performance evaluation formula and a reference factor;
and the management module is used for analyzing and optimizing the database to be evaluated according to the performance evaluation result.
7. The apparatus of claim 6, wherein the obtaining module is specifically configured to:
and acquiring a plurality of key performance indexes for evaluating the performance of the database to be evaluated according to the database type and the service type of the database to be evaluated.
8. The apparatus according to claim 6, wherein the management module is specifically configured to:
acquiring a performance report of the database to be evaluated according to the performance evaluation result and the corresponding key performance indexes;
and optimizing the database to be evaluated according to the performance report.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the steps of the database performance evaluation management method according to any one of claims 1 to 5 are implemented when the processor executes the program.
10. A non-transitory computer readable storage medium, on which a computer program is stored, wherein the computer program, when executed by a processor, implements the steps of the database performance evaluation management method according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910849684.5A CN110750512A (en) | 2019-09-09 | 2019-09-09 | Database performance evaluation management method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910849684.5A CN110750512A (en) | 2019-09-09 | 2019-09-09 | Database performance evaluation management method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110750512A true CN110750512A (en) | 2020-02-04 |
Family
ID=69276265
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910849684.5A Pending CN110750512A (en) | 2019-09-09 | 2019-09-09 | Database performance evaluation management method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110750512A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113297169A (en) * | 2021-02-26 | 2021-08-24 | 阿里云计算有限公司 | Database instance processing method, system, device and storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105373903A (en) * | 2015-12-18 | 2016-03-02 | 国网天津市电力公司 | Large-scale enterprise non-relational database performance evaluation method |
| CN105404581A (en) * | 2015-12-25 | 2016-03-16 | 北京奇虎科技有限公司 | Database evaluation method and device |
| CN106528388A (en) * | 2016-10-21 | 2017-03-22 | 网易（杭州）网络有限公司 | Database detection method and apparatus |
| CN106547860A (en) * | 2016-10-21 | 2017-03-29 | 长安通信科技有限责任公司 | A kind of localization method of distributed data base performance fault |
| CN108595502A (en) * | 2018-03-19 | 2018-09-28 | 网宿科技股份有限公司 | Assess the method, apparatus and computer readable storage medium of database service performance |
| CN109241096A (en) * | 2018-08-01 | 2019-01-18 | 北京京东金融科技控股有限公司 | Data processing method, device and system |
| CN109344201A (en) * | 2018-10-17 | 2019-02-15 | 国网江苏省电力有限公司信息通信分公司 | A kind of database performance load evaluation system and method based on machine learning |
-
2019
- 2019-09-09 CN CN201910849684.5A patent/CN110750512A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105373903A (en) * | 2015-12-18 | 2016-03-02 | 国网天津市电力公司 | Large-scale enterprise non-relational database performance evaluation method |
| CN105404581A (en) * | 2015-12-25 | 2016-03-16 | 北京奇虎科技有限公司 | Database evaluation method and device |
| CN106528388A (en) * | 2016-10-21 | 2017-03-22 | 网易（杭州）网络有限公司 | Database detection method and apparatus |
| CN106547860A (en) * | 2016-10-21 | 2017-03-29 | 长安通信科技有限责任公司 | A kind of localization method of distributed data base performance fault |
| CN108595502A (en) * | 2018-03-19 | 2018-09-28 | 网宿科技股份有限公司 | Assess the method, apparatus and computer readable storage medium of database service performance |
| CN109241096A (en) * | 2018-08-01 | 2019-01-18 | 北京京东金融科技控股有限公司 | Data processing method, device and system |
| CN109344201A (en) * | 2018-10-17 | 2019-02-15 | 国网江苏省电力有限公司信息通信分公司 | A kind of database performance load evaluation system and method based on machine learning |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113297169A (en) * | 2021-02-26 | 2021-08-24 | 阿里云计算有限公司 | Database instance processing method, system, device and storage medium |
| CN113297169B (en) * | 2021-02-26 | 2022-05-31 | 阿里云计算有限公司 | Database instance processing method, system, device and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9996558B2 (en) | Method and system for accessing a set of data tables in a source database | |
| US10642832B1 (en) | Reducing the domain of a subquery by retrieving constraints from the outer query | |
| EP3070620A1 (en) | Lightweight table comparison | |
| US20190158420A1 (en) | Mainframe migration tools | |
| CN112395325A (en) | Data management method, system, terminal equipment and storage medium | |
| US9454574B2 (en) | Bloom filter costing estimation | |
| CN111539633A (en) | Service data quality auditing method, system, device and storage medium | |
| US20130166498A1 (en) | Model Based OLAP Cube Framework | |
| US20180004781A1 (en) | Data lineage analysis | |
| US9223847B2 (en) | Using dimension substitutions in OLAP cubes | |
| CN107247811B (en) | SQL statement performance optimization method and device based on Oracle database | |
| CN112445875B (en) | Data association and verification method and device, electronic equipment and storage medium | |
| CN108052542B (en) | Multidimensional data analysis method based on presto data | |
| US20200090080A1 (en) | System and method for round trip engineering of decision metaphors | |
| US20210364999A1 (en) | System and method for analyzing cause of product defect, computer readable medium | |
| AU2013201725B2 (en) | Foreign key identification in database management systems | |
| EP3264291A1 (en) | Data block processing method and device | |
| US10108669B1 (en) | Partitioning data stores using tenant specific partitioning strategies | |
| CN114461644A (en) | Data acquisition method and device, electronic equipment and storage medium | |
| CN110377519B (en) | Performance capacity test method, device and equipment of big data system and storage medium | |
| CN105279138B (en) | A kind of information research report automatic creation system | |
| CN117271481B (en) | Automatic database optimization method and equipment | |
| CN110750512A (en) | Database performance evaluation management method and device | |
| CN116628023B (en) | Waiting event type query method and device, storage medium and electronic equipment | |
| WO2020201830A1 (en) | Systems and methods for generating, monitoring, and analyzing event networks from event data |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200204 |