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

Control method of database cursors, 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: 2017-09-08
SHENZHEN TCL NEW-TECH CO LTD
View PDF14 Cites 2 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
  • Control method of database cursors, and database system
  • Control method of database cursors, and database system
  • Control method of database cursors, 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 control method of database cursors, and a database system. The control method of the database cursor comprises the steps that when database activation cursors are detected, the activated cursors and corresponding cursor grades will be recorded, so that a sequence list of all the activated cursors can be obtained; and when the detection result indicates that the activated and idle low-grade cursors exist in the sequence list, memory resources occupied by the low-grade cursors will be released. According to the invention, the cursors can be closed according to the cursor grades and the resources can be released when memory resources are insufficient, so that memory leak caused by the database cursors can be solved effectively.

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
IPC IPC(8): G06F17/30
CPCG06F16/217
Inventor 刘远凤
Owner SHENZHEN TCL NEW-TECH CO LTD
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