Supercharge Your Innovation With Domain-Expert AI Agents!

A Method of Dynamically Adjusting Memory Space to Store Data in Batches

A memory space and dynamic adjustment technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as slowing down of inserted data, limited performance, database crashes, etc.

Active Publication Date: 2018-04-20
XIAMEN YAXON NETWORKS CO LTD
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] When the amount of data stored in the database is large and frequent, the performance of the database will be severely tested, resulting in a decrease in the speed of inserting data, and even table deadlocks, memory exhaustion, and database crashes.
For this reason, the number of memory tables is usually increased according to the value of the database performance parameter to reduce the probability of table deadlock. However, the number of memory tables has been fixed. If the number is set less, it will cause performance problems when inserting a large amount of data in batches. Limited, if the number is set too much, when the amount of data inserted in batches is small, the memory space is wasted and the data is saved to the entity table for a longer period of time

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0012] A method for dynamically adjusting memory space to store data in batches in the present invention, specifically comprising the following steps:

[0013] Step 1. Divide the state setting of the memory table into two states: "the state of not transferring data to the entity table" and "the state of transferring data to the entity table";

[0014] Step 2. Initialize the number of memory tables and the maximum number of rows allowed to be stored in the memory table;

[0015] Initialize the number of memory tables table_num to 2, and set the number of memory tables from table_num_0 to table_num_3;

[0016] Initially set the maximum number of rows row_num allowed to save in the memory table to 50;

[0017] Step 3. Determine the size of the current number of memory tables num and the number of memory tables per_num initialized last time. If it is smaller than the number of memory tables per_num initialized last time, first unused num+1 to per_num Transfer the data in the mem...

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 method for dynamically adjusting batch stored data in memory space. When batch data are inserted into a database, according to a feature that read-write speed of database memory tables is higher than the speed of entity tables, the data are firstly stored in the memory tables, the data can be timely stored in the database, then the data are written in the entity tables from the memory tables, thereby, the data can be timely and rapidly stored, the corresponding relation between the memory tables and the entity tables is set to n: 1, in order to control memory space occupied by the memory tables, the number of rows of the stored data in the memory tables and the number of memory tables are required to be controlled, and memory space is indirectly adjusted.

Description

technical field [0001] The invention relates to a method for dynamically adjusting memory space to store data in batches. technical background [0002] When the amount of data stored in the database is large and frequent, the performance of the database will be severely tested, resulting in a slowdown in the speed of inserting data, and even table deadlocks, memory exhaustion, and database crashes. For this reason, the number of memory tables is usually increased according to the value of the database performance parameter to reduce the probability of table deadlock. However, the number of memory tables has been fixed. If the number is set less, it will cause performance problems when inserting a large amount of data in batches. Restricted, if the number is set too much, when the amount of data inserted in batches is small, the memory space is wasted, and the data is saved to the entity table for an extended period of time. Contents of the invention [0003] The purpose o...

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): G06F17/30
CPCG06F16/258
Inventor 詹友陆傅建记余建成张屿
Owner XIAMEN YAXON NETWORKS CO LTD
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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