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

Data access method for all-memory database

A data access and database technology, which is applied in the data access field of full memory database, can solve problems such as the inability to automatically clean up historical data, great impact on database performance, and database performance degradation, so as to avoid processing performance degradation and improve processing Speed, cost reduction effects

Inactive Publication Date: 2007-10-17
NANJING ZHONGXING XIN SOFTWARE CO LTD
View PDF0 Cites 17 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The existing in-memory database improves the processing speed of the system through memory access, but due to the volatile nature of the memory, when the application exits, the data in the memory cannot be saved, so it still needs to be backed up synchronously with the disk
[0005] In addition, in ordinary databases and in-memory databases, the function of automatically cleaning historical data cannot be realized. Historical data can only be deleted by calling the delete operation of the database, or the old historical records can be overwritten by using table space recycling.
In this way, with the growth of time, more and more historical data, and the increase in the amount of data, has a great impact on the performance of the database, resulting in a further decline in the performance of the database

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
  • Data access method for all-memory database
  • Data access method for all-memory database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] The present invention will be described in further detail below in conjunction with the accompanying drawings.

[0021] The core idea of ​​the present invention is to use the shared memory provided by the system itself to establish a full-memory database, and the data in this database is recycled, and the information has a validity period. For expired records, the full-memory database clears the record and notifies the application to perform corresponding deal with.

[0022] Fig. 1 shows the flow chart when the present invention is implemented, comprising the following steps:

[0023] Step 1. Configure a full-memory database.

[0024] Calculate the scale of the full-memory database based on business traffic, record validity period, and networking, so as to obtain primary key information and indexes; configure the record validity period and the cycle of full-memory database scanning records according to business requirements.

[0025] When the network adopts the load s...

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

A data access method of whole memory database, belongs to a data access method. In the method, a whole memory database information is arranged firstly, and is initialized then, a corresponding operation of database is carried out according to a upper application professional operation at last,and a corresponding operated result is returned towards the upper application. The invention is especially suitable for a system in which the requirement for the data access effect is high and the lifecycle of database is in a certain range, accordingly the operated speed of system is improved, and the operated ability of system is enlarged, the cost of syatem and the maintenance of system are reduced.

Description

technical field [0001] The invention belongs to a data access method, in particular to a data access method of a full memory database. Background technique [0002] In the database system, the I / O speed of the disk is still the key to limit the processing speed of the system. [0003] In ordinary databases, disk I / O operations are unavoidable. Only when the data accessed by applications concentrates on certain records within a period of time, ordinary databases can use the cache mechanism of the database itself to improve part of the performance of the system. [0004] The existing in-memory database improves the processing speed of the system through memory access, but due to the volatile nature of the memory, when the application program exits, the data in the memory cannot be saved, so it still needs to be backed up synchronously with the disk. [0005] In addition, in ordinary databases and in-memory databases, the function of automatically cleaning historical data cann...

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/30H04L29/06H04L12/54
Inventor 周翔屠要峰王景祥李世亮高洪
Owner NANJING ZHONGXING XIN SOFTWARE 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