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

Database statistical information updating method and device, equipment and medium

A statistical information and database technology, applied in the field of database statistical information update, can solve problems such as lock conflicts, database performance and resource waste, and achieve the effects of avoiding lock conflicts, improving use efficiency, and saving computing resources

Pending Publication Date: 2022-03-29
北京人大金仓信息技术股份有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, since the hash table needs to be locked when updating or reading statistical information, in the case of high concurrency in the database, lock conflicts are serious, resulting in a waste of database performance and resources

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
  • Database statistical information updating method and device, equipment and medium
  • Database statistical information updating method and device, equipment and medium
  • Database statistical information updating method and device, equipment and medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] In order to more clearly understand the above objects, features and advantages of the present disclosure, the solutions of the present disclosure will be further described below. It should be noted that, in the case of no conflict, the embodiments of the present disclosure and the features in the embodiments can be combined with each other.

[0031] In the following description, many specific details are set forth in order to fully understand the present disclosure, but the present disclosure can also be implemented in other ways than described here; obviously, the embodiments in the description are only some of the embodiments of the present disclosure, and Not all examples.

[0032] As the complexity of the database business becomes higher and higher, more and more statistical information is generated during the operation of the system, even reaching the order of tens of thousands per second. The traditional statistical information update method is to use shared memo...

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 relates to a database statistical information updating method and device, equipment and a medium. The method comprises the steps that a session process caches statistical information generated in the process of executing a user command in a local statistical information base; when a preset condition is met, the session process gathers the statistical information in the local statistical information base into a data packet, and sends the data packet to a statistical process; and the statistical process receives the data packet sent by the session process, and updates statistical information in the data packet to a local memory. According to the method, the statistical information generated in the session process is cached in the local statistical information base, the statistical process is further introduced, and the local memory is allocated for the statistical process, so that locking is not needed when the statistical information in the local memory is updated according to the statistical information in the local statistical information base; lock conflicts during updating of the statistical information in the database are effectively avoided, system resources are saved, and the use efficiency of the database is effectively improved.

Description

technical field [0001] The present disclosure relates to the technical field of databases, and in particular to a method, device, device and medium for updating statistical information of a database. Background technique [0002] Statistical information plays a very important role in relational databases. It can not only provide the basis for the optimizer to choose access paths, but also assist the database administrator (Database Administrator, DBA) to analyze possible problems in the database. [0003] As the complexity of the database business increases, more and more statistical information is generated during system operation. The traditional statistical information update method is to directly update the statistical information to the global shared memory in real time. The statistical information exists in the form of elements in the in the hash table. [0004] However, since the hash table needs to be locked when updating or reading statistical information, when the...

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
IPC IPC(8): G06F16/23G06F16/2455G06F16/2458
CPCG06F16/2308G06F16/24552G06F16/2462
Inventor 王胜利尹强
Owner 北京人大金仓信息技术股份有限公司
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