Solid state disk based database optimization method and system

A technology of solid-state hard disk and optimization method, which is applied in the computer field and can solve problems such as practical inconvenience

Active Publication Date: 2013-01-09
RAMAXEL TECH SHENZHEN
View PDF5 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In summary, the existing database access methods based on solid-state disks obvi

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
  • Solid state disk based database optimization method and system
  • Solid state disk based database optimization method and system
  • Solid state disk based database optimization method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] In order to make the object, technical solution and advantages of the present invention more clear, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0035] see figure 2 , the present invention provides a solid-state disk-based database optimization system, the system 100 specifically includes an information acquisition module 10, a mapping processing module 20 and an access processing module 30, wherein:

[0036] The information obtaining module 10 is used for obtaining database information parameters, and the database information parameters include the length of data records in the database.

[0037] The mapping processing module 20 is used to recalculate the storage location of the data record according to the Flash page size in the soli...

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 is applicable for the technical field of a computer, and provides a solid state disk based database optimization method. The solid state disk based database optimization method comprises the steps of: A, obtaining information parameters of a database, wherein the information parameters include a length of a data record in the database; B, recalculating a storage position of the data record based on the size of the Flash page in the solid state disk and the length of the data record in the database, remapping the data record which needs to be stored across the Flash page to the same Flash page, and recording a mapping relationship between the original logic address and the new logic address of the data record; and C, calculating the new logic address of the data record based on the address mapping relationship of the database and sending the new logic address to the solid state disk in the reading-writing process of the data record. The invention also correspondingly provides a database optimization system for realizing the method. Therefore, the solid state disk based database optimization method and system, disclosed by the invention, have the advantages of optimizing the database, improving the database reading-writing access rate and further improving durability of the solid state disk.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a database optimization method and system based on a solid state disk. Background technique [0002] A solid state disk (Solid State Disk, IDE FLASH DISK) is a hard disk made of a solid state electronic memory chip array, consisting of a control unit and a storage unit (FLASH chip). The interface specifications and definitions, functions and usage methods of SSDs are exactly the same as those of ordinary hard disks, and the product shape and size are also completely consistent with ordinary hard disks. Widely used in military, vehicle, industrial control, video surveillance, network monitoring, network terminals, electric power, medical, aviation, navigation equipment and other fields. The characteristics of the Flash medium of the solid-state hard disk determine: 1) The reading and writing of the Flash is in units of pages; 2) The number of erasing and writing of the Flash is...

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
Inventor 李明星
Owner RAMAXEL TECH SHENZHEN
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