Database Cursor Control Method and Database System

A control method and database technology, applied in the database field, can solve problems such as insufficient system memory resources and the system cannot run normally, and achieve the effect of solving memory leakage

Active Publication Date: 2022-01-04
SHENZHEN TCL NEW-TECH CO LTD
View PDF14 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The main purpose of the present invention is to provide a database cursor control method and a database system, aiming to solve the technical problem that the database system cannot operate normally due to insufficient system memory resources caused by the cursor not being closed

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 Cursor Control Method and Database System
  • Database Cursor Control Method and Database System
  • Database Cursor Control Method and Database System

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0047] It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0048] A database system implementing various embodiments of the present invention will now be described with reference to the accompanying drawings. In the following description, use of suffixes such as 'module', 'part' or 'unit' for denoting elements is only for facilitating description of the present invention and has no specific meaning by itself. Therefore, "module" and "component" may be mixedly used.

[0049] The cursor is a data buffer set up by the database system for the user to store the execution result of the database execution statement. In a database system, a cursor can be opened or closed to implement an object reference. Through the use of the cursor, the database system can conveniently obtain the specific data records mapped to the cursor. In the actual use of the database system, after the use ...

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 discloses a database cursor control method and database system. The database cursor control method comprises: when a database activated cursor is detected, recording the activated cursor and its cursor level to obtain a sorted list of all activated cursors; When an activated and idle low-level cursor is detected in the sorted list, the memory resources occupied by the low-level cursor are released. When the memory resource is insufficient, the invention closes the cursor according to the cursor level to release the resource, and effectively solves the memory leakage caused by the database cursor.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a database cursor control method and a database system. Background technique [0002] In the database system, there are often memory resources that cannot be reclaimed or too many memory resources are being used, resulting in less and less available memory in the system, causing the system to run unsmoothly. [0003] Cursors are usually used in database systems. When the cursor is not closed in time after being referenced, it is easy to increase the probability of memory overflow, which will cause the system to run slower and slower until it crashes. At present, memory leak tools generally use memory checking tools to analyze the static memory errors of the system, but they cannot monitor and close the cursor in real time, which will cause the database system to freeze due to lack of memory resources when the memory resources are insufficient. , downtime or even system crashes...

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/21
CPCG06F16/217
Inventor 刘远凤
Owner SHENZHEN TCL NEW-TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap