Relational data cache and inquiry method and device

A technology of relational data and data, which is applied in the field of relational data caching and query methods and devices, and can solve problems such as waste of storage space, inability to realize relational data search, and degradation of reading performance

Active Publication Date: 2017-05-17
HANGZHOU HIKVISION DIGITAL TECH
View PDF5 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the HBase database is a database based on external memory, and the carrier of the database cache data is still disk. Although a small amount of data can be cached in the memory, when the read data exceeds the amount of data cached in the memory, the read performance will decrease. significantly decreased
In addition, for the Hbase database, when caching relat

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
  • Relational data cache and inquiry method and device
  • Relational data cache and inquiry method and device
  • Relational data cache and inquiry method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0063] In order to improve the caching efficiency of relational data and make full use of memory resources, the embodiments of the present invention provide a method and device for caching and querying relational data.

[0064] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0065] figure 1 A relational data caching process provided by an embodiment of the present invention, the process includes the following steps:

[0066] S101: Receive relational data to be cached, wherein the relational data includes at least one ...

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

An embodiment of the invention discloses a relational data cache and inquiry method and device. The cache method includes the steps: receiving relational data to be cached and then caching each of associated sub-data into a corresponding column according to the corresponding relation between each of the associated sub-data and each column in a column cluster; updating bitmap identifiers of corresponding lines in a bitmap index according to the condition whether relational data are cached in each column or not. As the relational data are cached based on the corresponding relation table of the bitmap index and each column and divided into a plurality of associated sub-data to be respectively cached, the cache efficiency of the relational data is improved. Moreover, the method is applied to a memory of an electronic device, and the use ratio of the memory is increased.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a relational data cache and query method and device. Background technique [0002] The data exchange buffer of computer hardware technology is generally a storage module between the memory and the CPU, prior to the memory, so that the CPU can quickly access the required data. Cache in software technology generally opens up an area in the memory and solid-state hard disk to store some frequently accessed data to supplement the difference in memory and the problem of slow disk access. [0003] The current mainstream caching systems include Memcache d system and Redis system. The Memcached system caches data based on Key-Value. Key-Value is a storage and access method for Key and data Value. For example, <1, a>, <2, b> can access data a through key values ​​1 and 2. and b. In addition to supporting Key-Value for data caching, the Redis system can also 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/24552
Inventor 邓长春郭峰陈国栋
Owner HANGZHOU HIKVISION DIGITAL TECH
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