Unlock instant, AI-driven research and patent intelligence for your innovation.

Database cluster, data query method and data synchronism method and device

A data query and data synchronization technology, applied in the field of database clusters, can solve the problems of low data query efficiency and achieve the effect of improving data query efficiency

Active Publication Date: 2014-12-10
GUANGZHOU HUADUO NETWORK TECH
View PDF4 Cites 22 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] In order to solve the problem of low data query efficiency of the system in the prior art, the embodiment of the present invention provides a database cluster, a data query method, a data synchronization method and a device

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0054] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, rather than all embodiments . Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0055] Please refer to figure 1 , which shows a schematic structural diagram of a database cluster provided by an embodiment of the present invention, the database cluster 100 includes a first partition set 110 and a second partition set 120 storing the same data.

[0056]When the system needs to store data in the database cluster 100, the system may divide the data into at least one primary key partition according to the primary key accor...

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 database cluster, a data query method and a data synchronism method and device, and belongs to the technical field of data processing. The database cluster comprises a first partition set and a second partition set, both of which store the same data. The first partition set comprises at least one main key partition partitioned according to main keys, and the main key partitions store the data according to the main keys. The second partition set comprises at least one index partition partitioned according to the overall index, the index partitions store the data according to the indexes, and the data with the same index are stored in the same index partition. The problem that the data query efficiency in the prior art is low is solved. The effects that requested data can be directly inquired according to the index field of the inquire statement and at least one index partition obtained according to the indexes in a partition mode, and the data query efficiency is improved are achieved.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a database cluster, a data query method, a data synchronization method and a device. Background technique [0002] In order to improve the storage capacity of the database, currently a database cluster is usually used to jointly provide storage services. The database cluster stores the data in the original data table into multiple partitions in the database cluster according to the primary key, that is, stores a part of the data in the original data table in each partition to realize large-scale data storage. [0003] In order to quickly query the data stored in the database cluster, the system can also create a secondary index in each partition and store the created secondary index. Afterwards, when the system receives a data query statement based on the index field, the system can first query the index that matches the index field in the data query statement in the sec...

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
CPCG06F16/2453G06F16/24553
Inventor 喻先兵
Owner GUANGZHOU HUADUO NETWORK TECH