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

Data query method and device, electronic device and storage medium

A data query and data technology, applied in the database field, can solve problems such as low efficiency, and achieve the effect of improving efficiency, purpose and advantages in a concise and easy-to-understand manner

Pending Publication Date: 2021-07-16
杭州粒子文化科技有限公司
View PDF4 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The embodiment of the present application provides a data query method, device, electronic device and storage medium, to at least solve the problem of low efficiency when performing multi-condition query in the HBase database in the related art

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, electronic device and storage medium
  • Data query method and device, electronic device and storage medium
  • Data query method and device, electronic device and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] In order to make the purpose, technical solutions and advantages of the present application clearer, the present application will be described and illustrated 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. Based on the embodiments provided in the present application, all other embodiments obtained by persons of ordinary skill in the art without creative efforts shall fall within the protection scope of the present application. In addition, it can also be understood that although such development efforts may be complex and lengthy, for those of ordinary skill in the art relevant to the content disclosed in this application, the technology disclosed in this application Some design, manufacturing or production changes based on the content are just conventional technical means, and...

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, an electronic device and a storage medium, and is applied to an HBase database, the method comprises the steps that a first data record is acquired from the HBase database, the first data record comprises a primary key and data corresponding to the primary key, and the data corresponding to the primary key comprises a plurality of columns; the first data record is converted into a second data record of the relational database, and the second data record takes a primary key and a column name of at least one column as fields; generating an index of a field corresponding to each column name on the relational database; performing data query in the relational database based on the index to obtain a third data record hitting a preset query condition in the second data record; and acquiring a data record corresponding to the primary key of the third data record from the HBase database. Through the method and the device, the problem of low efficiency when multi-condition query is carried out in the HBase database in related technologies is solved, and the technical effect of improving the efficiency when the multi-condition query is carried out in the HBase database is realized.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a data query method, device, electronic device and storage medium. Background technique [0002] HBase is a distributed, column-oriented open source database. Unlike general relational databases, HBase database is suitable for unstructured data storage. [0003] The RowKey in the HBase database can uniquely identify a row of records. There are three ways to retrieve data in HBase: 1. Through the get method, specify the RowKey to obtain a unique record; 2. Through the scan method, set the startRow and stopRow parameters for range matching; 3. , Full table scan, that is, directly scan all row records in the entire table. [0004] At present, HBase is mainly used in semi-structured big data storage. It has extremely high performance in inserting and reading, which is closely related to its data organization method. Logically, HBase table data follows RowKey performs di...

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): G06F16/22G06F16/23G06F16/2458G06F16/27G06F16/28
CPCG06F16/221G06F16/2358G06F16/2471G06F16/27G06F16/284
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