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

SQL interpreter of HBase and optimization method

An interpreter and lexical technology, applied in HBase's SQL interpreter and optimization field, can solve problems such as poor performance and inability to compile, and achieve the effect of improving execution performance and reducing the difficulty of use.

Active Publication Date: 2020-06-19
深圳市赢时胜信息技术股份有限公司
View PDF9 Cites 12 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

While mode b and mode c interpret the intermediate code or source code one by one into machine language for the computer to execute when executing the program, so the performance is not as good as mode a
SQL is also a programming language, which also needs to be compiled or interpreted to execute. Most databases use SQL to process SQL. Figure 4 In the method c, the SQL statement is directly executed by the interpreter, and SQL is a declarative programming language (only expressing the calculation logic without describing its control flow). Without the control logic, it cannot be compiled, but can only be interpreted and executed.

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
  • SQL interpreter of HBase and optimization method
  • SQL interpreter of HBase and optimization method
  • SQL interpreter of HBase and optimization method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0065] Below with the accompanying drawings ( Figure 1-Figure 26 ) to illustrate the present invention.

[0066] figure 1 It is a schematic diagram of the equivalent description of SQL statements and relational algebra. figure 1 The SQL statement in: SELECT A,B,CFROM T WHERE A > 0. The semantics of this SQL statement means that the data satisfying the condition A > 0 is retrieved from the data table T, and the three columns A, B, and C of the data are returned. The semantics are described by relational algebra. Assume that the T table has columns A, B, and C Column, D column, a total of 4 columns. In relational algebra, projection: A, B, C; selection: A>0; relation: T[A, B, C, D]. T is the name of the data table. figure 2 It is a schematic diagram of the structure and flow of SQL statements and relational databases. The process refers to the internal execution process in the relational database. figure 2 The internal execution process in includes: step 1, generating ...

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 SQL interpreter of HBase and an optimization method. A combination of a lexical analyzer, a syntactic analyzer, a semantic analyzer and an actuator is arranged; according tothe method, the logic operator in the SQL statement can be analyzed, the logic operator can be converted into the physical operator directly executed in the HBase database, and therefore the use difficulty of the HBase database is lowered for a large number of SQL language users.

Description

technical field [0001] The present invention relates to the SQL data operation technology of HBase database, particularly a kind of SQL interpreter and optimization method of HBase, by setting the combination of lexical analyzer, syntax analyzer, semantic analyzer and executor, the logic in the SQL statement can be The analysis of the operator is beneficial to convert the logical operator into a physical operator directly executed in the HBase database, thereby reducing the difficulty of using the HBase database for the majority of SQL language users. Background technique [0002] With the increase of business scale, especially the increase of data scale, relational databases cannot cope with the actual needs of massive data storage and high concurrent access. Because of this, many alternatives and systems have emerged in the field of big data, and HBase is a database that is completely different from relational databases. HBase is a distributed, column-oriented database. I...

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/242G06F16/2453G06F16/27G06F16/22
CPCG06F16/221G06F16/2433G06F16/24547G06F16/27
Inventor 赵欣其他发明人请求不公开姓名
Owner 深圳市赢时胜信息技术股份有限公司
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