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

Methods for establishing and inquiring index of distributed column storage database, device and system thereof

A column storage and database technology, applied in the field of index establishment of distributed column storage database, data query method and corresponding device and system, can solve the problem that other column fields cannot be quickly and efficiently query, and achieve the effect of fast and efficient index query

Active Publication Date: 2010-06-09
CHINA MOBILE SUZHOU SOFTWARE TECH CO LTD +2
View PDF0 Cites 74 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0023] The present invention provides a distributed column storage database index establishment method, query method, device and system to solve the problem that the existing distributed column storage database cannot perform fast and efficient query according to other column fields except the Row field

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
  • Methods for establishing and inquiring index of distributed column storage database, device and system thereof
  • Methods for establishing and inquiring index of distributed column storage database, device and system thereof
  • Methods for establishing and inquiring index of distributed column storage database, device and system thereof

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0056] An embodiment of the present invention provides a distributed column storage database index establishment method, the implementation process is as follows figure 2 shown, including:

[0057] Step S201, obtaining column fields in the distributed column storage database.

[0058] Step S202, generating a column index file with the obtained column field as a key, and the column index file includes a mapping relationship between the value of the column field in the distributed column storage database and the corresponding Row field value.

[0059] In the step S202, a corresponding column index file may be generated for each acquired column field (or column family).

[0060] In practical applications, in order to facilitate user queries, theoretically, a corresponding column index file can be generated for each column field in the distributed column storage database except the Row field. Of course, if some column fields are basically of no query value, and the field is har...

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 methods for establishing and inquiring index of a distributed column storage database, a device and a system thereof. The method for establishing index of a distributed column storage database comprises the steps of obtaining the column fields in the distributed column storage database to generate a column index file with the column fields as keywords, wherein the column index file contains the mapping relation between the values of the column fields in the distributed column storage database and the values of the corresponding Row fields; storing the column index file into the index directory corresponding to the column fields in the distributed column storage database. The method for inquiring index is implemented by matching corresponding index files to obtain corresponding values of Row fields when a client launches an inquiry request with the column fields as inquiry condition and result. By adopting the invention, fast inquiry of other column fields except for the Row fields can be realized in the prior distributed column storage database.

Description

technical field [0001] The present invention relates to a distributed column storage database, in particular to a method for establishing an index of a distributed column storage database, a data query method, and a corresponding device and system. Background technique [0002] Distributed column storage database is an excellent distributed solution suitable for fast query. While providing massive data storage, it can also effectively improve the query speed of data. [0003] The characteristics of a distributed column storage database are: there must be a Row field in the data table, and the Row field is a keyword, that is, it cannot be repeated, and it is sorted. If the original table has N column fields, the entire table is stored in (N-1) tables in the distributed column storage database; that is, except for the Row field, a corresponding table is stored for the remaining column fields. [0004] Examples are as follows: [0005] Table 1: GNTABLE [0006] Row ...

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): G06F17/30
CPCG06F17/30315G06F17/30321G06F16/2228G06F16/221
Inventor 徐萌钱岭罗治国郭磊涛赵鹏
Owner CHINA MOBILE SUZHOU SOFTWARE TECH CO 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