Method for increasing random database data read-write speed

A technology for reading and writing speed and database, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as data loss, and achieve the effect of reducing hardware failure rate, low failure rate, and enhanced scalability

Inactive Publication Date: 2013-09-04
PEARL DIGITAL SOFTWARE DEV SHANGHAI
View PDF2 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

But because of this, if a power failure occurs, the data residing in the memory will be lost because it is not written to the hard disk in 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

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for increasing random database data read-write speed
  • Method for increasing random database data read-write speed

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] The present invention will be described in detail below in conjunction with the accompanying drawings and specific embodiments. This embodiment is carried out on the premise of the technical solution of the present invention, and detailed implementation and specific operation process are given, but the protection scope of the present invention is not limited to the following embodiments.

[0038] A method for improving the random reading and writing speed of database data, the method uses a solid-state hard disk as a cache to improve the random reading and writing speed of the database, the solid-state hard disk is connected to the hard disk of the database through a SAS interface or a PCIe interface, and the method specifically includes data writing Into sub-method and data read sub-method,

[0039] Such as figure 1 As shown, the data writing submethod includes the following steps:

[0040] a1) Obtain the corresponding sector number dbn in the hard disk of the databa...

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 relates to a method for increasing random database data read-write speed. The method is characterized in that a solid state disk is used as a cache for increasing random read-write speed of a database, and the method includes a data writing sub-method and a data reading sub-method. The data writing sub-method includes acquiring corresponding sector numbers in a database hard disk according to data needing writing, calculating corresponding data sets according to the sector numbers, writing the data in the data sets, marking data blocks as dirty data, and when the dirty data reaches a set threshold, automatically writing the dirty data in the database hard disk. The data reading sub-method includes acquiring corresponding sector numbers according to data needing reading, calculating corresponding data sets according to the sector numbers, judging whether data needing reading are included in a current data set or not, if yes, reading data from the current data set, and otherwise, reading data from the database hard disk. Compared with the prior art, the method has the advantages of low cost, high reliability, capability of effectively increasing the data read-write speed, and the like.

Description

technical field [0001] The invention relates to a technology for improving computer hardware, in particular to a method for improving the random reading and writing speed of database data. Background technique [0002] Today, the Internet is all over the world and network applications are becoming more and more extensive. The data stored on the Internet is also increasing, and the application's dependence on the database is also becoming more and more significant. According to incomplete statistics, in 2011, the total amount of data on the global Internet has reached an astonishing 10 trillion GB, and people interact with data hundreds of trillions of times every day. Traditional database storage media and solutions are increasingly unable to meet today's growing user needs. [0003] The most widely used database storage medium today is the Winchester hard disk, which has the advantages of large capacity, low price, and long data storage time. But because it seeks to rota...

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 Applications(China)
IPC IPC(8): G06F17/30
Inventor 翁杰
Owner PEARL DIGITAL SOFTWARE DEV SHANGHAI
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