Hbase database real-time query achieving method and system

A data query and database technology, applied in the field of database query, to achieve the effect of improving development efficiency

Active Publication Date: 2015-05-20
BOYAA ONLINE GAME DEV SHENZHEN
View PDF4 Cites 17 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Based on this, it is necessary to address the problem that the Hbase database does not support the real-time query of the SQL language, ...

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
  • Hbase database real-time query achieving method and system
  • Hbase database real-time query achieving method and system
  • Hbase database real-time query achieving method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0056] like figure 1 Shown, in one embodiment, a kind of method that realizes Hbase database real-time inquiry, this method comprises the steps:

[0057] Step S110, acquiring structured query language text.

[0058] In this embodiment, a structured query language (Structured Query Language, SQL for short) text input by a user is acquired, and the structured query language text is a query statement for performing data query on the Hbase database.

[0059]Step S120, parsing the structured query language text to obtain query elements, where the query elements include the first table to be queried.

[0060] In this embodiment, the acquired structured query language text is split into several query elements according to the syntax of the structured query language. For example, a structured query language text is: "select name, birthday from table1where student number=201012323". By splitting, two columns named name and birthday can be obtained. The first table to be queried is 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 discloses an Hbase database real-time query achieving method. The method comprises the steps that a structured query language (SQL) text is obtained; the SQL text is analyzed to obtain an element to be queried, wherein the element to be queried comprises a first table to be queried; the element to be queried is packaged to be an object to be queried corresponding to the first table to be queried; according to the object to be queried, a first index is built for the first table to be queried; data query is carried out on the first table to be queried in the Hbase database through the object to be queried and the first index, a result set is obtained and comprises row records, and the row records are used for storing query data. By means of the method, the SQL query function is provided for the Hbase database, a user does not need to be concerned about the index structure, the user can still query relevant data through the SQL text even being completely unfamiliar with the Hbase database, the user can concentrate time and energy on the service logic development, and the development efficiency is improved.

Description

technical field [0001] The invention relates to database query technology, in particular to a method and system for realizing real-time query of Hbase database. Background technique [0002] The Hbase database is a column-oriented, scalable and high-performance distributed database. Due to its column-oriented storage characteristics, it has more advantages in storing massive data than relational databases, so it is widely favored by users. [0003] However, the Hbase database is a noSQL database, that is, the data query in the Hbase database cannot be realized directly through the (Structured Query Language, SQL for short) language, and can only be realized through the rowkey (index). For the Hbase database, although Hive can be used to build a data warehouse to provide SQL data query, Hive cannot perform real-time query on the Hbase database. SUMMARY OF THE INVENTION [0004] Based on this, it is necessary to address the problem that the Hbase database does not support ...

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
CPCG06F16/221G06F16/951
Inventor 刘德志
Owner BOYAA ONLINE GAME DEV SHENZHEN
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