Method and device for evaluating database index efficiency
A database and index location technology, applied in the field of database management, can solve the problem of not being able to evaluate index efficiency, affecting the overall efficiency of batch processing tasks, etc., to achieve the effect of improving efficiency
Inactive Publication Date: 2015-01-21
IBM CORP
View PDF4 Cites 2 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
For a single query task, which index to query based on multiple indexes may not significantly affect the query efficiency; however, when executing a sequence of batch processing tasks including tens of thousands or more queries, in The cumulative response delay during each query may affect the overall efficiency of the batch task, so it is expected to be able to evaluate the efficiency of the index
[0004] Although a technical solution to evaluate index efficiency based on the relationship between the index and the tables in the database has been proposed, this technical solution cannot evaluate the efficiency of the index in executing batch tasks
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0023] Preferred embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although preferred embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.
[0024] Those skilled in the art know that the present invention can be implemented as a system, method or computer program product. Therefore, the present disclosure can be specifically implemented in the following forms, that is: it can be complete hardware, it can also be complete software (including firmware, resident software, microcode, etc.), and it can also be a combination of hardware and software. Called a "circuit", "module" or "s...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The embodiment of the invention provides a method and device for evaluating the database index efficiency. In one embodiment, a method for evaluating the database index efficiency is provided. The method includes the steps that the sequence of batch processing tasks having access to a database is received; an indicator for indicating the times of having access to the database during the period of executing the batch processing tasks in the sequence based on a database index is estimated; the efficiency of the database index relative to the sequence is evaluated based on the indicator, and the batch processing tasks in the sequence are tasks for executing the same type of operation for a database. In another embodiment, a method for executing the batch processing tasks in the sequence in the database. The method includes the steps that methods for evaluating the database index efficiency are executed respectively for a plurality of database indexes so as to calculate the efficiency of each database index in the multiple database indexes; the database index with the highest efficiency is selected to execute the batch processing tasks in the sequence.
Description
technical field [0001] Embodiments of the invention relate to database management, and more particularly, to methods and apparatus for evaluating the efficiency of database indexing. Background technique [0002] With the development of computer hardware technology and database technology, while providing more and more data storage capacity, the response efficiency of the database to external access is also getting higher and higher. For example, by using database indexing technology, the access efficiency to the database can be improved to a certain extent. A database index is a data structure that sorts the values of one or more columns in a table in a database. One or more indexes can be established. By using the index to access the database, it is not necessary to search all the data rows in the data table, which helps to improve query efficiency. [0003] On the other hand, as the complexity of the application program increases, the current application program more ...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F11/3612G06F16/22
Inventor 李硕杨新颖周祥
Owner IBM CORP