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

Secondary index construction method, device and equipment

A secondary index and construction method technology, applied in the field of distributed databases, can solve problems such as service resource occupation, and achieve the effect of avoiding interference

Active Publication Date: 2020-06-02
ALIBABA GRP HLDG LTD
View PDF9 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] This application provides a method for building a secondary index to solve the existing problem of occupying original service resources when building a secondary index

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
  • Secondary index construction method, device and equipment
  • Secondary index construction method, device and equipment
  • Secondary index construction method, device and equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0056] In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present invention. However, the present invention can be implemented in many other ways different from those described here, and those skilled in the art can make similar extensions without violating the connotation of the present invention, so the present invention is not limited by the specific implementations disclosed below.

[0057] The first embodiment of the present application provides a method for constructing a secondary index, which is combined below figure 1 , figure 2 , image 3 Describe in detail.

[0058] Such as figure 1 As shown, in step S101, the original data in the service node is read through the mapping task, and the non-primary key column in the original data is selected as the primary key column of the secondary index table, according to the primary key column structure of the secondary index table The data of the secondary...

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 secondary index construction method, which comprises the steps of reading original data in a service node through a mapping task, selecting a non-primary key column in the original data as a primary key column of a secondary index table, and constructing data of the secondary index table according to the primary key column of the secondary index table; and writing the data of the secondary index table into the secondary index table. By the adoption of the method, the problem that original service resources are occupied when a secondary index is constructed in the prior art is solved.

Description

technical field [0001] The present application relates to the technical field of distributed databases, in particular to a method, device, electronic device and storage device for constructing a secondary index. Background technique [0002] In a distributed database, each product usually provides the best query method in a certain scenario. Take HBase (an open source distributed non-relational storage system) as an example: HBase is a NoSQL (non-relational storage system) that supports KV queries. Relational database) database, supports primary key (rowkey) query, range (scan) query and full table query. The most commonly used of these are queries based on primary keys. Each business needs to determine the primary key in advance. This primary key needs to be specified when writing and querying. Such a query mode is relatively limited. If you want to query based on non-primary key columns, HBase can only use full table scanning, which consumes a lot of resources and has ext...

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): G06F16/22G06F16/242
CPCG06F16/22G06F16/2433Y02D10/00
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

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