Method and device for generating database partition execution plan
An execution plan and database technology, applied in the database field, can solve problems such as low reliability, low processing efficiency, and impracticality, and achieve the effect of enhancing operation stability, avoiding chain problems, and reducing maintenance costs.
Active Publication Date: 2012-10-10
CHINA MOBILE GROUP ZHEJIANG
View PDF0 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
For such a large-scale database system, the above method of setting up each SQL related to a data object requires manual processing of each SQL that accesses this type of data object. However, due to the current complex and changeable For application databases, the number of SQL entries for accessing the database has far exceeded imagination. It is impractical to manually process each SQL statement involving such data objects in a targeted manner, and the processing efficiency is low, and there are many blind spots. , Vulnerabilities and uncertainties make the execution reliability not high; Further, modifying SQL requires large-scale modification of database applications, which increases database maintenance costs
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
[0035] In order to make the purpose, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.
[0036] In practical applications, when the database parameter CURSOR_SHARING is set to FORCE, since the database shares the execution plan of the partition by default, for the small partition and the initial partition, if the execution plan of the shared index scan is used, the execution cost is the same as that of using a single partition The cost of full table scan is about milliseconds. For example, for a small partition or initial partition with only a few records, the cost of using a single partition full table scan is 3, and the actual processing time is about 0.01 seconds. Using index scan The cost is 5, the actual processing time is about 0.015 seconds, and the perceived difference in execution efficiency is small; for large partit...
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 invention discloses a method and a device for generating a database partition execution plan, wherein the method comprises the following steps of: obtaining the partition count information content of the database and using the partition satisfying a preset premise as a nonstandard partition; selecting a data object with a preset ratio from a standard partition with an index scanning executionplan according to the partition count information content and the preset premise of the nonstandard partition; renewing the fields with a main key or unique restriction in the selected data object with preset ratio and generating a virtualized data object; embedding the virtualized data object into the nonstandard partition and renewing the partition count information of the nonstandard partitions stored in the database; and generating an execution plan according to the partition count information content of the data object of the partition. By using the method and the device for generating the database partition execution plan, the maintenance cost of the database can be reduced, and the execution efficiency of the database can be increased as well.
Description
technical field [0001] The invention relates to database technology, in particular to a method and device for generating a database partition execution plan. Background technique [0002] The current database, whether it is used for data warehouse or operational data storage, contains a wealth of massive data object information. Therefore, the performance of the database plays a very important role in the timely search and display of the information users need. Among them, The execution plan is a key factor affecting the performance of the database. The execution plan is automatically generated by the cost-based optimizer (CBO, Cost-basedOptimizer) in the database based on the parsed parameters entered by the user to query the structured query language of the data object. (SQL, Structured Query Language), according to the pre-stored data object statistical information in the SQL query database, select the access path with the least cost, find the corresponding data object ac...
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 Patents(China)
IPC IPC(8): G06F17/30
Inventor 王晓征肖爱元李杰毅
Owner CHINA MOBILE GROUP ZHEJIANG