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

Database management method, system and device and storage medium

A management method and database technology, applied in the fields of systems, database management methods, devices, and storage media, can solve problems such as the increase in the number of sessions and database paralysis, and achieve the effect of avoiding crashes and ensuring good operation

Active Publication Date: 2020-04-17
北京北龙云海网络数据科技有限责任公司
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

During the table lock period, if a large number of sessions continue to access this table, the number of sessions of related applications will continue to increase until it is stuck, and the related database will also be paralyzed

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 management method, system and device and storage medium
  • Database management method, system and device and storage medium
  • Database management method, system and device and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0048] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of embodiments of the present invention, but not all embodiments. 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.

[0049] Such as figure 1 As shown, a database management method provided by the embodiment of the present invention. refer to figure 1 , the management method includes the following steps:

[0050] S11. After the database table is locked, acquire the table lock duration at the current moment and the number of table lock times of the databas...

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 management method, system and device and a storage medium. The management method comprises the steps that after a database table is locked, the table locking duration of the current moment and the table locking frequency of the database table within the first preset duration before the current moment are obtained; whether the table locking duration is greater than a preset table locking duration threshold and whether the table locking frequency is greater than a preset table locking frequency threshold are judged; and if the table locking duration is greaterthan a preset table locking duration threshold, and / or the table locking frequency is greater than a preset table locking frequency threshold, the database table is unlocked. According to the embodiment of the invention, the database table is locked; obtaining the table locking duration of the database table and the table locking times of the database table within the preset duration, when the table locking duration is long or the table locking frequency exceeds the corresponding preset threshold value, the database table of the locked table is unlocked, the situation that the whole databasecrashes due to overstock of data requests of the database table of the locked table is avoided, and then good operation of the system is guaranteed.

Description

technical field [0001] The present invention relates to the technical field of information security, in particular to a database management method, system, device and storage medium. Background technique [0002] With the development of information technology, the number of applications and websites in various industries is also increasing. Relevant government agencies and units have launched relevant "sharing service networks" according to the requirements of the state, and relevant project or achievement sharing information has been published on relevant websites. [0003] With the development of IT technology, the number of applications built on "databases" in various industries is gradually increasing, and the interaction between applications and databases is also quite frequent, which often leads to lock tables in the database. After the lock table appears, related applications are locked when they access again. After the table, it will be in a waiting state until the r...

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/21G06F16/22
CPCG06F16/217G06F16/2282
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