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

Database index optimization method and distributed database query method and device

An optimization method and database technology, applied in the computer field, can solve problems such as low query efficiency, and achieve the effects of improving system availability, improving query efficiency, and simplifying query operations

Active Publication Date: 2021-08-24
ALIBABA GRP HLDG LTD
View PDF8 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Each query needs to query all nodes and summarize the results, which will lead to low query efficiency

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 index optimization method and distributed database query method and device
  • Database index optimization method and distributed database query method and device
  • Database index optimization method and distributed database query method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0122] Hereinafter, exemplary embodiments of the present disclosure will be described in detail with reference to the accompanying drawings so that those skilled in the art can easily implement them. Also, for clarity, parts not related to describing the exemplary embodiments are omitted in the drawings.

[0123] In the present disclosure, it should be understood that terms such as "comprising" or "having" are intended to indicate the existence of labels, numbers, steps, acts, components, parts or combinations thereof disclosed in this specification, and are not intended to exclude one or multiple other labels, numbers, steps, acts, parts, parts or combinations thereof exist or are added to the possibility.

[0124] In addition, it should be noted that, in the case of no conflict, the embodiments in the present disclosure and the labels in the embodiments can be combined with each other. The present disclosure will be described in detail below with reference to the accompanyi...

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 embodiment of the invention discloses a database index optimization method and a distributed database query method and device. The database index optimization method comprises the steps of determining whether a database index accessed by a query request of a distributed database is optimized based on routing or not, wherein the route is used for determining a node where a database index fragment of the database index is located in the distributed database; if it is determined that a database index accessed by a query request of the distributed database has been optimized based on routing, setting a route field of the route in the query request so as to optimize the database index; and optimizing the query request on the basis of the database index based on routing optimization, so that the query efficiency is improved.

Description

technical field [0001] The present disclosure relates to the field of computer technology, in particular to a database index optimization method, a distributed database query method and a device. Background technique [0002] With the development of technologies such as the Internet and big data, it is becoming more and more common for various systems to use distributed databases. Distributed databases can use smaller computer systems, each computer can be placed in a separate place as a node, each computer may have a complete copy of the database management system, or a partial copy of the copy, and has its own local database. Many nodes located in different locations are connected to each other through the network to form a complete and global logically centralized and physically distributed large database. [0003] In a distributed database, if the data is distributed directly according to the primary key in a way such as hashing, then all the data of a user may be dist...

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): G06F16/22G06F16/27G06F16/2453
CPCG06F16/22G06F16/27G06F16/2453
Inventor 石磊敬少强周赵锋
Owner ALIBABA GRP HLDG 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