Data query method and device based on HBase and computer equipment

A data query and computer program technology, applied in the field of big data, can solve problems such as low efficiency of full table scan query, failure to meet business query needs, and failure to meet actual needs, so as to avoid network bandwidth waste, enrich usage scenarios, and improve accuracy Effect

Inactive Publication Date: 2022-02-25
INSPUR SUZHOU INTELLIGENT TECH CO LTD
View PDF6 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Multi-condition combined query is relatively common in big data application scenarios. When it comes to the application of multi-condition combined query, a single row key cannot meet the business query requirements, and it is usually queried through full table scan. However, full table scan query Inefficient and unable to meet actual needs

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
  • Data query method and device based on HBase and computer equipment
  • Data query method and device based on HBase and computer equipment
  • Data query method and device based on HBase and computer equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0036] In order to make the purpose, technical solution and advantages of the present application clearer, the present application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present application, and are not intended to limit the present application.

[0037] HBase, an open source NoSQL database, is suitable for the storage and management of various unstructured and semi-structured loose data. Using HBase database technology, large-scale storage clusters can be built on server clusters to meet the storage needs of big data. . The row key (RowKey) in the HBase database can uniquely identify a row of records.

[0038] ES (ElasticSearch) is an open source, distributed Restful search engine based on Lucence, which supports data indexing using JSON over HTTP.

[0039] In related technologies, the following methods are usual...

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 data query method and device based on HBase and computer equipment, and relates to the technical field of big data. According to the method, creating a secondary index table for columns, needing index creation, of a target data table in advance in an ES search engine; acquiring a combined query command line input by a user through an indexer, analyzing the combined query command line to obtain a combined query condition and a specified output column, outputting the combined query condition to an ES search engine, querying from a pre-established secondary index table through the ES search engine to obtain a target line key conforming to the combined query condition, and screening out target data from the target HBase data table according to the target row key and the specified output column. According to the technical scheme, multi-combination-condition query based on HBase can be realized, the query efficiency of multi-condition combination query is improved, and the use scene of combination query is greatly enriched.

Description

technical field [0001] The present application relates to the technical field of big data, in particular to an HBase-based data query method, device and computer equipment, and also to a computer-readable storage medium. Background technique [0002] As a commonly used distributed database in the field of big data, HBase supports data storage of hundreds of billions of rows and millions of columns, but HBase itself only provides queries based on row keys and full table scans. Multi-condition combined query is relatively common in big data application scenarios. When it comes to the application of multi-condition combined query, a single row key cannot meet the business query requirements, and it is usually queried through full table scan. However, full table scan query Inefficient and unable to meet actual needs. Contents of the invention [0003] Based on this, it is necessary to provide an HBase-based data query method, device, computer equipment, and storage medium cap...

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/242G06F16/2453
CPCG06F16/22G06F16/2282G06F16/242G06F16/2453
Inventor 宋文豪
Owner INSPUR SUZHOU INTELLIGENT TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap