CN105279276A - Database index optimization system - Google Patents
Database index optimization system Download PDFInfo
- Publication number
- CN105279276A CN105279276A CN201510767926.8A CN201510767926A CN105279276A CN 105279276 A CN105279276 A CN 105279276A CN 201510767926 A CN201510767926 A CN 201510767926A CN 105279276 A CN105279276 A CN 105279276A
- Authority
- CN
- China
- Prior art keywords
- index
- database
- module
- operand
- communication port
- 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/90—Details of database functions independent of the retrieved data types
- G06F16/901—Indexing; Data structures therefor; Storage structures
Abstract
The invention discloses a database index optimization system. Firstly, database operation log files and database indexes are extracted by an operation object extraction module. After that, the database operation log files and the database indexes are classified by an operation object classification module and then are submitted to an operation object analysis module for analyzing and processing, wherein statements of high occurrence frequency and large volume of data query are tested by an index analysis module. Secondly, based on an obtained test result, indexes are generated dynamically by an index optimization module, wherein indexes of low usage frequency and low test performance are deleted. Meanwhile, by means of the index optimization module, the above indexes are periodically submitted to different databases according to the requirements of the databases. An index cache is also configured, so that the overall query performance of databases is improved. The system can be directly connected with the databases, so that indexes can be searched and optimized quickly. At the same time, different strategies can be set to control the index generation rules of the databases, and the indexes of databases are optimized. The database query performance is improved.
Description
Technical field
The present invention relates to database field, particularly relate to a kind of database index optimization system.
Background technology
Database index is the data structure of a kind of sequence in database, to assist fast query, to upgrade data in database table.The catalogue that database index is exactly search efficiency in order to improve table and sets up the value in some field.
The foundation of database index is for often needing on the row of search, the speed of searching for can be accelerated, as on the row of major key, force the arrangement architecture of data in the uniqueness of these row and organization table, on the row through being commonly used in connection, these row mainly some external keys, the speed connected can be accelerated, often needing the row of sequence create index, because index sorts, such inquiry can utilize the sequence of index, accelerates the sorting query time.Database index directly can affect database performance, and before and after configuration optimization, database performance gap may reach several times even tens times.Due to the complicacy of system, if adopt manual configuration, it is high that database index optimizes difficulty, and workload is large.How promoting data base querying performance, reduce the optimiged index time, is the key issue needing in database index Optimization Work to solve.
Summary of the invention
In view of this, fundamental purpose of the present invention is to provide a kind of database index optimization system, can optimization data storehouse index, promotes data base querying performance.
For achieving the above object, the invention provides a kind of database index optimization system, comprising:
Operand extraction module, operand sort module, operand analysis module, index analysis module, optimiged index module and control desk module;
Described operand extraction module is used for from database, extract database manipulation journal file and database index file, and carries out operand extraction to described database manipulation journal file and described database index;
Described operand sort module is used for the classification described operation being carried out predetermined registration operation object type, and is recorded to by sorted operand in corresponding sort file;
Described operand analysis module is used for analyzing according to sorted operand, goes out to use enquiry frequency higher than predeterminated frequency and inquire about the SQL statement of quantity higher than predetermined number according to the optimiged index Policy Filtering preset;
Described index analysis module is used for performing inquiry plan operation to described SQL statement, carry out search efficiency analysis, data throughput component analysis according to the Query Result obtained, IO analyzes and internal memory detects, and obtains the target index information of database efficiency higher than default efficiency;
Described optimiged index module is used for setting up index rule according to described target index information, carries out database index optimization and configuration index buffer memory;
Described control desk module is used for setting data storehouse optimiged index strategy.
Preferably, the first communication port of described control desk module is connected with database, and the second communication port of described control desk module is connected with the first communication port of described optimiged index module;
The second communication port of described optimiged index module is connected with database, and the third communication port of described optimiged index module is connected with the first communication port of described index analysis module;
The second communication port of described index analysis module is connected with the first communication port of described operand analysis module;
The second communication port of described operand analysis module is connected with the first communication port of described operand extraction module, and the third communication module of described operand analysis module is connected with the first communication port of described operand sort module;
The second communication port of described operand extraction module is connected with the second communication port of described operand sort module, and the third communication port of described operand extraction module is connected with database;
3rd port of described operand sort module is connected with database.
Preferably, described predetermined registration operation object type comprises:
SQL statement classification, database index classification and storing process classification.
Preferably, described operand analysis module comprises analysis submodule and screening module;
Described analysis submodule comprises:
SQL statement analytic unit, for analyzing SQL statement critical field, SQL frequency of utilization and where condition;
Database index analytic unit, optimizes record for analytical database index frequency of utilization and database index;
Storing process analytic unit, the SQL statement for analyzing stored process frequency of utilization and storing process is extracted.
Preferably, described optimiged index module comprises:
Index rule sets up submodule, for calling situation definition database index create-rule according to database SQL statement, storage;
Database index optimizes submodule, for setting up new index according to described rule and/or deleting straight index;
Configuration index cache sub-module, for being configured target cache.
Preferably, described target cache comprises: indexed cache, order buffer, query caching and table descriptor buffer memory.
Preferably, described database index optimisation strategy comprises preset rules order, optimization time and optimization frequency.
Preferably, described preset rules order is the rule ordering of frequency of utilization, search efficiency, inquiry quantity and resource consumption.
Apply a kind of database index optimization system provided by the invention, by database manipulation journal file, database index is extracted by operand extraction module, then classified by operand sort module, and be submitted to operand analysis module analyzing and processing, by index analysis module, the frequency of occurrences is high, the statement that data query amount is large is tested, optimiged index module is passed through by dynamic generating indexes according to test result, and it is low to delete frequency of utilization, the index that test performance is low, can according to Database Requirements by optimiged index module, characteristic hands over different rule bases surely, also can configuration index buffer memory, thus improve the overall query performance of database.Directly can be connected with database, can inquire about index fast, optimize and different policy control database index create-rules can be set, optimizing database index, improve data base querying performance.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, be briefly described to the accompanying drawing used required in embodiment or description of the prior art below, apparently, accompanying drawing in the following describes is only embodiments of the invention, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to the accompanying drawing provided.
Fig. 1 is the structural representation of a kind of database index optimization system of the present invention embodiment;
Fig. 2 is the detailed construction schematic diagram of a kind of database index optimization system of the present invention embodiment.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, be clearly and completely described the technical scheme in the embodiment of the present invention, obviously, described embodiment is only the present invention's part embodiment, instead of whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtained under creative work prerequisite, belong to the scope of protection of the invention.
The invention provides a kind of database index optimization system, Fig. 1 shows database index optimization system example structure schematic diagram of the present invention, comprising:
Control desk module (1), optimiged index module (2), index analysis module (3), operand analysis module (4), operand extraction module (5), operand sort module (6), wherein control desk module (1) first communication module port is connected with database second communication port, and control desk module (1) second communication module port is connected with optimiged index module first communication port.Optimiged index module (2) second communication port is connected with database third communication module port, and optimiged index module (2) third communication port is connected with index analysis module (3) first communication port.Index analysis module (3) second communication port is connected with operand analysis module (4) first communication port.Operand analysis module (4) second communication port is connected with operand extraction module (5) first communication port, and operand analysis module (4) third communication module is connected with operand sort module (6) first communication port.Operand extraction module (5) second communication port is connected with operand sort module (6) second communication port, and operand extraction module (5) third communication port also database port is connected.Operand sort module (6) the 3rd port is connected with database port.
Described operand extraction module (5) for extracting database manipulation journal file and database index file from database, and carries out operand extraction to described database manipulation journal file and described database index;
Database manipulation journal file record application system is to the information such as use of DataBase combining, database object operation, database table operation and database index.Database manipulation journal file and database index file are database index dynamic optimization instrument Back ground Informations.Operand extraction step is as follows:
1) operand extraction module port and DataBase combining port are established a communications link by ICP/IP protocol;
2) database manipulation journal file and database index file are sent to operand extraction module by connectivity port;
3) operand extraction module receives database manipulation journal file and database index file;
4) operand extraction module parse operation journal file and database index file;
5) operand extraction module carries out data object extraction to Operation Log file and database index file.
Sorted operand for described operation being carried out the classification of predetermined registration operation object type, and is recorded in corresponding sort file by described operand sort module (6);
Predetermined registration operation object type comprises: SQL statement classification, database index classification and storing process classification.Operand classifying step is as follows:
1) operand sort module port and operand extract port and Database communicates to connect;
2) data object that operand extraction module extracts is sent to operand analysis module by port;
3) operand sort module is analyzed one by one database operand and is determined affiliated operand type (operand is divided into operation SQL statement, database index, storing process three class);
4) operand sort module by classified service data object record in sort file.
Described operand analysis module (4), for analyzing according to sorted operand, goes out to use enquiry frequency higher than predeterminated frequency according to the optimiged index Policy Filtering preset and inquires about the SQL statement of quantity higher than predetermined number;
Database manipulation object is undertaken classifying by SQL statement, database index, storing process and is stored in different sort files by all objects of classification by operand analysis module, analysis of key field, frequency of utilization, where condition, optimization history, analyzing stored process SQL statement etc.Operand analytical procedure is as follows:
1) operand analysis module port and operand extract port operation object classification module port and establish a communications link;
2) object of activity classification is sent to operand analysis module by port by operand analysis module;
3) operand analysis module is analyzed database SQL statement, and analysis indexes comprises SQL statement critical field, SQL statement frequency of utilization, where condition.Operand analysis module is analyzed database index, and analysis indexes comprises database index frequency of utilization, database index optimizes record.Operand analysis module is analyzed storing process, comprises storing process frequency of utilization, storing process SQL statement is extracted;
4) operand analysis module analyze according to optimiged index Policy Filtering go out to use enquiry frequency high, inquire about a fairly large number of SQL statement.
Described index analysis module (3) is for performing inquiry plan operation to described SQL statement, carry out search efficiency analysis, data throughput component analysis according to the Query Result obtained, IO analyzes and internal memory detects, and obtains the target index information of database efficiency higher than default efficiency;
Index analysis module is according to the relevant SQL statement of the analysis result of operand analysis module screening index and perform inquiry plan, is analyzed and data throughout, system IO, internal memory are monitored several aspect and comprehensively analyzed index by search efficiency.Index analytical procedure is as follows:
1) index analysis module port and operand analysis port establish a communications link;
2) SQL statement filtered out is sent to index analysis module by port by operand analysis module;
3) index analysis module performs inquiry plan to SQL statement;
4) index analysis module carries out search efficiency analysis, data throughput component analysis, IO analysis, internal memory monitoring to executive plan;
5) index analysis module analyzes the higher index information of database efficiency.
Described optimiged index module (2), for setting up index rule according to described target index information, carries out database index optimization and configuration index buffer memory;
The executive plan analysis result that optimiged index module draws according to index analysis module, can to indexes dynamic optimization in conjunction with index rule base dependency rule, this module improves storehouse search index efficiency by configuration index buffer memory, allocating cache can effectively reduce data base querying reading times, thus alleviate database server pressure, reach the object of optimization.Configurable buffer memory comprises indexed cache (key_buffer), order buffer (sort_buffer), query caching (query_buffer), table descriptor buffer memory (table_cache).
Optimiged index module is set up index rule base rule and is comprised the following aspects:
1) rule set up in index: consider that from four aspects rule set up in index successively, comprise frequency of utilization, search efficiency, inquiry quantity, resource consumption, can by control desk module index optimisation strategy functional module manual modification rule, system default rule is followed successively by frequency of utilization (first considering), search efficiency (secondly considering), inquiry quantity (again considering), resource consumption (finally considering);
2) database index dynamic optimization: according to regular dynamic optimization database index, comprises and sets up new index, deletes straight index;
3) configuration index buffer memory: allocating cache can effectively reduce data base querying reading times, thus alleviate database server pressure, reach the object of optimization.
Described control desk module (1) is for setting data storehouse optimiged index strategy.
Control desk module is the operation layer of database index optimization system, by control desk module can Query Database index, configuration index optimisation strategy, timing upgrade database index.Above control desk module index optimisation strategy Main Basis, already described index is set up rule and is defined, frequency of utilization, search efficiency, inquiry quantity, resource consumption four kinds of rules in the console can by successively sorting smoothly, after rule has defined, index has been optimized smoothly according to this.Namely control desk module timing index upgrade can optimize time, optimization frequency by the robotization of control desk configuration index, the optimization time can regular timing optimization, optimization frequency can daily be optimized, by Zhou Youhua, monthly optimize, optimize per year, and after timing index upgrade rule optimization completes, index is optimized database automatically according to corresponding time rule.
A kind of database index optimization system that application the present embodiment provides, by database manipulation journal file, database index is extracted by operand extraction module, then classified by operand sort module, and be submitted to operand analysis module analyzing and processing, by index analysis module, the frequency of occurrences is high, the statement that data query amount is large is tested, optimiged index module is passed through by dynamic generating indexes according to test result, and it is low to delete frequency of utilization, the index that test performance is low, can according to Database Requirements by optimiged index module, characteristic hands over different rule bases surely, also can configuration index buffer memory, thus improve the overall query performance of database.Directly can be connected with database, can inquire about index fast, optimize and different policy control database index create-rules can be set, optimizing database index, improve data base querying performance.
It should be noted that, each embodiment in this instructions all adopts the mode of going forward one by one to describe, and what each embodiment stressed is the difference with other embodiments, between each embodiment identical similar part mutually see.For system class embodiment, due to itself and embodiment of the method basic simlarity, so description is fairly simple, relevant part illustrates see the part of embodiment of the method.
Finally, also it should be noted that, in this article, term " comprises ", " comprising " or its any other variant are intended to contain comprising of nonexcludability, thus make to comprise the process of a series of key element, method, article or equipment and not only comprise those key elements, but also comprise other key elements clearly do not listed, or also comprise by the intrinsic key element of this process, method, article or equipment.When not more restrictions, the key element limited by statement " comprising ... ", and be not precluded within process, method, article or the equipment comprising described key element and also there is other identical element.
Be described in detail system provided by the present invention above, apply specific case herein and set forth principle of the present invention and embodiment, the explanation of above embodiment just understands method of the present invention and core concept thereof for helping; Meanwhile, 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.
Claims (8)
1. a database index optimization system, is characterized in that, comprising:
Operand extraction module, operand sort module, operand analysis module, index analysis module, optimiged index module and control desk module;
Described operand extraction module is used for from database, extract database manipulation journal file and database index file, and carries out operand extraction to described database manipulation journal file and described database index;
Described operand sort module is used for the classification described operation being carried out predetermined registration operation object type, and is recorded to by sorted operand in corresponding sort file;
Described operand analysis module is used for analyzing according to sorted operand, goes out to use enquiry frequency higher than predeterminated frequency and inquire about the SQL statement of quantity higher than predetermined number according to the optimiged index Policy Filtering preset;
Described index analysis module is used for performing inquiry plan operation to described SQL statement, carry out search efficiency analysis, data throughput component analysis according to the Query Result obtained, IO analyzes and internal memory detects, and obtains the target index information of database efficiency higher than default efficiency;
Described optimiged index module is used for setting up index rule according to described target index information, carries out database index optimization and configuration index buffer memory;
Described control desk module is used for setting data storehouse optimiged index strategy.
2. database index optimization system according to claim 1, it is characterized in that, first communication port of described control desk module is connected with database, and the second communication port of described control desk module is connected with the first communication port of described optimiged index module;
The second communication port of described optimiged index module is connected with database, and the third communication port of described optimiged index module is connected with the first communication port of described index analysis module;
The second communication port of described index analysis module is connected with the first communication port of described operand analysis module;
The second communication port of described operand analysis module is connected with the first communication port of described operand extraction module, and the third communication module of described operand analysis module is connected with the first communication port of described operand sort module;
The second communication port of described operand extraction module is connected with the second communication port of described operand sort module, and the third communication port of described operand extraction module is connected with database;
3rd port of described operand sort module is connected with database.
3. database index optimization system according to claim 1, is characterized in that, described predetermined registration operation object type comprises:
SQL statement classification, database index classification and storing process classification.
4. database index optimization system according to claim 3, is characterized in that, described operand analysis module comprises analyzes submodule and screening module;
Described analysis submodule comprises:
SQL statement analytic unit, for analyzing SQL statement critical field, SQL frequency of utilization and where condition;
Database index analytic unit, optimizes record for analytical database index frequency of utilization and database index;
Storing process analytic unit, the SQL statement for analyzing stored process frequency of utilization and storing process is extracted.
5. database index optimization system according to claim 1, is characterized in that, described optimiged index module comprises:
Index rule sets up submodule, for calling situation definition database index create-rule according to database SQL statement, storage;
Database index optimizes submodule, for setting up new index according to described rule and/or deleting straight index;
Configuration index cache sub-module, for being configured target cache.
6. database index optimization system according to claim 5, is characterized in that, described target cache comprises: indexed cache, order buffer, query caching and table descriptor buffer memory.
7. database index optimization system according to claim 1, is characterized in that, described database index optimisation strategy comprises preset rules order, optimization time and optimization frequency.
8. database index optimization system according to claim 7, is characterized in that, described preset rules order is the rule ordering of frequency of utilization, search efficiency, inquiry quantity and resource consumption.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510767926.8A CN105279276B (en) | 2015-11-11 | 2015-11-11 | A kind of database index optimization system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510767926.8A CN105279276B (en) | 2015-11-11 | 2015-11-11 | A kind of database index optimization system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105279276A true CN105279276A (en) | 2016-01-27 |
| CN105279276B CN105279276B (en) | 2018-09-18 |
Family
ID=55148290
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510767926.8A Active CN105279276B (en) | 2015-11-11 | 2015-11-11 | A kind of database index optimization system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105279276B (en) |
Cited By (20)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106202403A (en) * | 2016-07-11 | 2016-12-07 | 浪潮通用软件有限公司 | A kind of by dynamically analyzing the method creating database index |
| CN106598862A (en) * | 2016-12-19 | 2017-04-26 | 济南浪潮高新科技投资发展有限公司 | SQL semantic extensibility-based performance diagnosis and optimization method |
| CN106599130A (en) * | 2016-12-02 | 2017-04-26 | 中国银联股份有限公司 | Method and device for selectively interfering with multiple indexes of relational database management system |
| CN106649584A (en) * | 2016-11-18 | 2017-05-10 | 北京奇虎科技有限公司 | Index processing method and device in master-slave database system |
| CN106844497A (en) * | 2016-12-26 | 2017-06-13 | 努比亚技术有限公司 | The check device and method of a kind of database code |
| CN107480199A (en) * | 2017-07-17 | 2017-12-15 | 深圳先进技术研究院 | Query Reconstruction method, apparatus, equipment and the storage medium of database |
| WO2018120171A1 (en) * | 2016-12-30 | 2018-07-05 | 华为技术有限公司 | Method, device and system for executing stored procedure |
| CN108614826A (en) * | 2016-12-12 | 2018-10-02 | 中国移动通信集团公司 | A kind of data query method and device |
| CN108694175A (en) * | 2017-04-05 | 2018-10-23 | 郑州博信知识产权代理有限公司 | A method of electric energy detection big data is analyzed based on data mining algorithm |
| CN108932339A (en) * | 2018-07-12 | 2018-12-04 | 浪潮软件集团有限公司 | Method for obtaining parameter values necessary for checking query plan in Impala database |
| CN109800240A (en) * | 2018-12-13 | 2019-05-24 | 平安科技（深圳）有限公司 | SQL statement classifying method, device, computer equipment and storage medium |
| CN110083600A (en) * | 2019-04-04 | 2019-08-02 | 网宿科技股份有限公司 | A kind of method, apparatus, calculating equipment and the storage medium of log collection processing |
| WO2019153550A1 (en) * | 2018-02-12 | 2019-08-15 | 平安科技（深圳）有限公司 | Automatic sql optimization method and apparatus, and computer device and storage medium |
| CN110309171A (en) * | 2018-02-26 | 2019-10-08 | 华为技术有限公司 | Data base query method, server and system |
| CN110674142A (en) * | 2019-10-12 | 2020-01-10 | 南京我爱我家信息科技有限公司 | Oracle database index optimization method |
| CN111427631A (en) * | 2020-04-01 | 2020-07-17 | 中电万维信息技术有限责任公司 | Dynamic configuration method of diversified mobile application function module |
| CN112347100A (en) * | 2020-10-27 | 2021-02-09 | 杭州安恒信息技术股份有限公司 | Database index optimization method and device, computer equipment and storage medium |
| WO2021169094A1 (en) * | 2020-02-28 | 2021-09-02 | 周永东 | Commodity transaction method and system for transaction platform |
| CN116737522A (en) * | 2023-06-21 | 2023-09-12 | 山东日照发电有限公司 | System performance optimization method |
| WO2023241246A1 (en) * | 2022-06-16 | 2023-12-21 | 中兴通讯股份有限公司 | Index establishment method, and electronic device and computer-readable storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070118574A1 (en) * | 2005-11-22 | 2007-05-24 | Franklin William J | Reorganizing data with update activity |
| CN103390066A (en) * | 2013-08-08 | 2013-11-13 | 上海新炬网络技术有限公司 | Database overall automation optimizing early warning device and processing method thereof |
| CN104714984A (en) * | 2013-12-17 | 2015-06-17 | 中国移动通信集团湖南有限公司 | Database optimization method and device |
-
2015
- 2015-11-11 CN CN201510767926.8A patent/CN105279276B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070118574A1 (en) * | 2005-11-22 | 2007-05-24 | Franklin William J | Reorganizing data with update activity |
| CN103390066A (en) * | 2013-08-08 | 2013-11-13 | 上海新炬网络技术有限公司 | Database overall automation optimizing early warning device and processing method thereof |
| CN104714984A (en) * | 2013-12-17 | 2015-06-17 | 中国移动通信集团湖南有限公司 | Database optimization method and device |
Non-Patent Citations (4)
| Title |
|---|
| 肖辉辉等: "关系数据库索引的优化设计研究", 《广西轻工业》 * |
| 韩超: "从浅究SQL Server索引出发谈浙江铁通大型数据库查询优化问题", 《上海铁道科技》 * |
| 魏威等: "基于索引的关系数据查询优化", 《洛阳大学学报》 * |
| 龚维荣等: "浅谈Oracle数据库基于索引的SQL语句优化方法", 《计算机工程与应用》 * |
Cited By (29)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106202403A (en) * | 2016-07-11 | 2016-12-07 | 浪潮通用软件有限公司 | A kind of by dynamically analyzing the method creating database index |
| CN106202403B (en) * | 2016-07-11 | 2020-03-20 | 浪潮通用软件有限公司 | Method for creating database index through dynamic analysis |
| CN106649584A (en) * | 2016-11-18 | 2017-05-10 | 北京奇虎科技有限公司 | Index processing method and device in master-slave database system |
| CN106649584B (en) * | 2016-11-18 | 2020-04-24 | 北京奇虎科技有限公司 | Index processing method and device in master-slave database system |
| CN106599130A (en) * | 2016-12-02 | 2017-04-26 | 中国银联股份有限公司 | Method and device for selectively interfering with multiple indexes of relational database management system |
| CN106599130B (en) * | 2016-12-02 | 2020-05-01 | 中国银联股份有限公司 | Method and apparatus for selectively intervening multiple indexes of relational database management system |
| CN108614826A (en) * | 2016-12-12 | 2018-10-02 | 中国移动通信集团公司 | A kind of data query method and device |
| CN106598862A (en) * | 2016-12-19 | 2017-04-26 | 济南浪潮高新科技投资发展有限公司 | SQL semantic extensibility-based performance diagnosis and optimization method |
| CN106844497A (en) * | 2016-12-26 | 2017-06-13 | 努比亚技术有限公司 | The check device and method of a kind of database code |
| WO2018120171A1 (en) * | 2016-12-30 | 2018-07-05 | 华为技术有限公司 | Method, device and system for executing stored procedure |
| US11182353B2 (en) | 2016-12-30 | 2021-11-23 | Huawei Technologies Co., Ltd. | Stored-procedure execution method and device, and system |
| CN108694175A (en) * | 2017-04-05 | 2018-10-23 | 郑州博信知识产权代理有限公司 | A method of electric energy detection big data is analyzed based on data mining algorithm |
| CN107480199B (en) * | 2017-07-17 | 2020-06-12 | 深圳先进技术研究院 | Query reconstruction method, device, equipment and storage medium of database |
| CN107480199A (en) * | 2017-07-17 | 2017-12-15 | 深圳先进技术研究院 | Query Reconstruction method, apparatus, equipment and the storage medium of database |
| WO2019153550A1 (en) * | 2018-02-12 | 2019-08-15 | 平安科技（深圳）有限公司 | Automatic sql optimization method and apparatus, and computer device and storage medium |
| CN110309171B (en) * | 2018-02-26 | 2021-08-20 | 华为技术有限公司 | Database query method, server and system |
| CN110309171A (en) * | 2018-02-26 | 2019-10-08 | 华为技术有限公司 | Data base query method, server and system |
| CN108932339A (en) * | 2018-07-12 | 2018-12-04 | 浪潮软件集团有限公司 | Method for obtaining parameter values necessary for checking query plan in Impala database |
| CN109800240B (en) * | 2018-12-13 | 2024-03-22 | 平安科技（深圳）有限公司 | SQL sentence classifying method, device, computer equipment and storage medium |
| CN109800240A (en) * | 2018-12-13 | 2019-05-24 | 平安科技（深圳）有限公司 | SQL statement classifying method, device, computer equipment and storage medium |
| CN110083600A (en) * | 2019-04-04 | 2019-08-02 | 网宿科技股份有限公司 | A kind of method, apparatus, calculating equipment and the storage medium of log collection processing |
| CN110674142A (en) * | 2019-10-12 | 2020-01-10 | 南京我爱我家信息科技有限公司 | Oracle database index optimization method |
| WO2021169094A1 (en) * | 2020-02-28 | 2021-09-02 | 周永东 | Commodity transaction method and system for transaction platform |
| CN111427631A (en) * | 2020-04-01 | 2020-07-17 | 中电万维信息技术有限责任公司 | Dynamic configuration method of diversified mobile application function module |
| CN111427631B (en) * | 2020-04-01 | 2022-03-15 | 中电万维信息技术有限责任公司 | Dynamic configuration method of diversified mobile application function module |
| CN112347100A (en) * | 2020-10-27 | 2021-02-09 | 杭州安恒信息技术股份有限公司 | Database index optimization method and device, computer equipment and storage medium |
| CN112347100B (en) * | 2020-10-27 | 2024-03-26 | 杭州安恒信息技术股份有限公司 | Database index optimization method, device, computer equipment and storage medium |
| WO2023241246A1 (en) * | 2022-06-16 | 2023-12-21 | 中兴通讯股份有限公司 | Index establishment method, and electronic device and computer-readable storage medium |
| CN116737522A (en) * | 2023-06-21 | 2023-09-12 | 山东日照发电有限公司 | System performance optimization method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105279276B (en) | 2018-09-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105279276A (en) | Database index optimization system | |
| US20230041672A1 (en) | Enterprise data processing | |
| CN106982150B (en) | Hadoop-based mobile internet user behavior analysis method | |
| US9569492B2 (en) | Coalescing operation for query processing | |
| US8949222B2 (en) | Changing the compression level of query plans | |
| WO2015184762A1 (en) | Database query method and device | |
| CN106970929B (en) | Data import method and device | |
| CN113360554B (en) | Method and equipment for extracting, converting and loading ETL (extract transform load) data | |
| CN104714984A (en) | Database optimization method and device | |
| KR20130049111A (en) | Forensic index method and apparatus by distributed processing | |
| US20200089674A1 (en) | Executing conditions with negation operators in analytical databases | |
| CN106815260B (en) | Index establishing method and equipment | |
| CN114691786A (en) | Method and device for determining data blood relationship, storage medium and electronic device | |
| CN106156047B (en) | A kind of SNAPSHOT INFO processing method and processing device | |
| CN105138621A (en) | Configuration optimization system and method for Sybase ASE database | |
| CN105630566A (en) | Application page loading duration determining method and application page loading duration determining device | |
| CN102915344B (en) | SQL (structured query language) statement processing method and device | |
| CN106407442A (en) | Massive text data processing method and apparatus | |
| CN104636368A (en) | Data retrieval method and device and server | |
| CN112445776B (en) | Presto-based dynamic barrel dividing method, system, equipment and readable storage medium | |
| CN104881475A (en) | Method and system for randomly sampling big data | |
| CN103714144A (en) | Device and method for information retrieval | |
| CN112631754A (en) | Data processing method, data processing device, storage medium and electronic device | |
| CN107291938A (en) | Order Query System and method | |
| CN110825729A (en) | Data query method and device, storage medium and electronic device |
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 |