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

Database data slice storage method and device, data query method and device

A data query and data sharding technology, applied in the database field, can solve problems such as extending response speed, and achieve the effects of improving response speed, speeding up query speed, and speeding up data query speed

Active Publication Date: 2018-10-12
SANGFOR TECH INC
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] Based on this, it is necessary to provide a database data fragment storage method and device for the above-mentioned problem that the entire data table may need to be traversed to prolong the response speed when querying data
[0007] In addition, it is also necessary to provide a database data query method and device based on data fragmentation storage for the above-mentioned problem that it may be necessary to traverse the entire data table to prolong the response speed when querying data

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
  • Database data slice storage method and device, data query method and device
  • Database data slice storage method and device, data query method and device
  • Database data slice storage method and device, data query method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0086] Such as Figure 1A As shown, a database data fragmentation storage method includes the following steps:

[0087] Step S102, generating a plurality of sub-tables corresponding to each data table stored in the database host.

[0088] Wherein, the data of all sub-tables corresponding to each data table covers the corresponding data table, and the data between the sub-tables does not overlap.

[0089] The multiple mentioned in this application document can be understood as two or more.

[0090] In one embodiment, each sub-table stores data corresponding to a range of continuous primary key values ​​in the corresponding data table. For example, sub-table 1 stores records whose primary key values ​​are 1-500, and sub-table 2 stores records whose primary key values ​​are 501-1000.

[0091] In one embodiment, the generated data volume of each sub-table does not exceed a preset size.

[0092] In one embodiment, the data table stored in the database host can be copied to obtai...

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 database data fragmentation storage method, comprising the following steps of: generating a plurality of sub-tables corresponding to each data table stored in a database host, wherein data of all the sub-tables corresponding to each data table covers the corresponding data table, and the data in the sub-tables is not overlapped; storing the sub-tables corresponding to each data table stored in the database host to a plurality of database standby machines, so that the data table with the corresponding sub-tables distributed to the database standby machines exists in the data tables stored in the database host; and maintaining distribution information, in the database standby machines, of the sub-tables of each data table in the database host. According to the method, the response speed of a data reading request is increased. In addition, a database data fragmentation storage apparatus is further provided and a data fragmentation storage based database data query method and apparatus are provided.

Description

technical field [0001] The present invention relates to the technical field of databases, in particular to a database data slice storage method and device, and to a database data query method and device based on data slice storage. Background technique [0002] In recent years, with the development of Internet technology, Internet applications have become more and more popular. With the increase in the number of customers of Internet applications, the amount of data accumulated by Internet applications is also increasing, and due to fierce competition among products, user experience is crucial to Internet applications. These responses to data queries for Internet applications Speed ​​and concurrent processing capabilities put forward higher requirements. [0003] In order to adapt to user needs and gain advantages in Internet competition, Internet application providers are committed to improving the response speed of data queries and concurrent processing capabilities. In ...

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/30G06F11/14
CPCG06F11/1464G06F16/24532G06F16/2471G06F16/27
Inventor 吴利斌刘少东黄茂彪
Owner SANGFOR TECH INC
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