Combined inquiring method oriented to Hbase database

A compound query and database technology, applied in database query, electronic digital data processing, structured data retrieval, etc., can solve the problems of inability to realize real-time response to user query requirements, achieve the effect of improving retrieval efficiency and reducing retrieval time

Active Publication Date: 2014-10-22
CHINA UNIONPAY
View PDF4 Cites 26 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0020] Although Hive software overcomes certain limitations of the HBase database in terms of query functions, due to the limitations of its internal implementation mechanism, its retrieval response time is as high as several minutes or even hours, and it is impossible to achieve real-time response to user query requirements, especially is a compound query applied when

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
  • Combined inquiring method oriented to Hbase database
  • Combined inquiring method oriented to Hbase database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0047] The following introduces some of the possible embodiments of the present invention, which are intended to provide a basic understanding of the present invention, but are not intended to identify key or decisive elements of the present invention or limit the scope of protection. It is easy to understand that, according to the technical solution of the present invention, those skilled in the art may propose other alternative implementation manners without changing the essence and spirit of the present invention. Therefore, the following specific embodiments and drawings are only exemplary descriptions of the technical solution of the present invention, and should not be regarded as the entirety of the present invention or as a limitation or restriction on the technical solution of the present invention.

[0048]In the following embodiments, the compound query method is exemplarily described by taking the HBase database formed by storing the data of the user's credit card t...

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 provides a combined inquiring method oriented to an Hbase database and belongs to the technical field of data inquiry. The combined inquiring method includes creating an index table, namely defining Key and Value of the index table, wherein factors of the Key of the index table include N of M combining conditions, factors of the Value of the index table at least include Key corresponding to a main record table, the N is larger than or equal to 2 and smaller than or equal to the M, and the M is an integer larger than or equal to 2; creating indexes; retrieving data, namely performing main key inquiry in the index table according to first Key generated by extracting the N combining conditions, and performing main key inquiry in the main record table at least according to second Key defined by a factor of the Key of the main record table. The combined inquiring method is high in inquiring efficiency and especially suitable for data inquiry of a mass database.

Description

technical field [0001] The invention belongs to the technical field of data query, and relates to a compound query method oriented to an Hbase database. Background technique [0002] In recent years, the amount of data in enterprise IT systems has grown explosively, and it has become difficult for traditional databases to effectively manage data scales up to billions of records or even more. As an emerging data management technology, NoSQL database has achieved good scalability by simplifying the data model and weakening the data consistency requirements, providing an option for managing massive data. The HBase database is one of the NoSQL databases that are currently widely used. It is a distributed, column-oriented open source database with good scalability and is very suitable for massive data storage. [0003] Usually, each record in the HBase database is a simple byte array with a relatively fixed Key-Value (primary key-key value) structure, that is, each record has a ...

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/24G06F16/245G06F16/2228
Inventor 刘磊何东杰王海冰才华
Owner CHINA UNIONPAY
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