Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

A database parallelism control method and device

A control method and technology of a control device, which are applied in the field of data processing, can solve the problems of running out of control of database parallelism, unstable SQL execution time, and inability to dynamically adjust parallelism, and achieve the effect of reasonable and efficient parallelism.

Active Publication Date: 2020-12-18
BANK OF CHINA
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In database-based online analytical processing OLAP applications, it has become an effective means to shorten the execution time by executing SQL involving massive amounts of data in parallel. In this case, SQL can only be executed serially or enter the parallelism use queue. In this scenario, the application’s use of database parallelism is out of control, and the parallelism required by each SQL cannot be dynamically adjusted. This makes SQL The execution time is unstable, how to reasonably and efficiently control the parallelism of the database is an urgent problem to be solved

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 more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • A database parallelism control method and device
  • A database parallelism control method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0051] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0052] For the parallel execution system of the existing database, take the Oracle 11.2.0.1 version of the Oracle database as an example. In Oracle 11gR2, the automatic parallel control is realized through the PARALLEL_DEGREE_POLICY parameter. The three methods of changing object-level parallelism, parallel hint, and session command use parallelism. When automatic parallelism is not enabled, the Oracle database has no available parallelism and can only execute...

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

No PUM Login to View More

Abstract

The invention provides a control method and device for the database parallelism degree. The control method includes the steps that when the target storage process needs to be executed, whether a parallel waiting switch is pre-configured for the target storage process or not is judged, and if the parallel waiting switch is pre-configured for the target storage process, the priority pre-configured for the storage process and the parallelism degree required by target storage process execution are obtained; whether the database parallelism degree prepared to be used by the storage process with thehigh parallelism exists or not is judged, and if the database parallelism degree prepared to be used by the storage process with the high parallelism exists, preset time intervals are waited; if thedatabase parallelism degree prepared to be used by the storage process with the high parallelism does not exist, whether the residual parallelism degree of the database conforms to the parallelism degree required by target storage process execution or not is judged, and if the residual parallelism degree of the database conforms to the parallelism degree required by target storage process execution, according to the parallelism degree required by target storage process execution, the parallelism degree is distributed for the target storage process so that the target storage process can be executed with the distributed parallelism degree. According to the control method and device for the database parallelism degree, the parallel waiting switch, the parallel degree and the priority are pre-configured for the storage process, the configured parallelism degree can be obtained according to the priority when the storage process is executed, and therefore the obtained parallelism degree is stably executed.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a database parallelism control method and device. Background technique [0002] Nowadays, the data scale of IT systems is getting larger and larger, how to obtain the required data from the massive data and deal with it in a timely manner has become a big problem. In databases such as Oracle database, parallel execution is an effective means to solve this problem. The so-called parallel execution is to open multiple threads or processes at the same time to jointly complete a task. The use of multi-threads or processes actually consumes more hardware resources such as CPU, memory, and IO channels to achieve the purpose of shortening the execution time, that is, by maximizing the use of hardware resources in exchange for more efficient program execution. [0003] In database-based online analytical processing OLAP applications, it has become an effective means to shorten ...

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
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/23G06F16/22
CPCG06F16/22G06F16/2315G06F16/2343
Inventor 黄志鸿易金华裴炜裕钟剑标李进学
Owner BANK OF CHINA
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com