Method and device for inquiring data

A data query device and data query technology, which are applied in the fields of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as reducing the query performance of the overall system, achieve fine-grained query optimization, improve query performance, and avoid repeated execution. Effect

Active Publication Date: 2014-10-29
ZHEJIANG TMALL TECH CO LTD
View PDF9 Cites 47 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Undoubtedly, this reduces the quer

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
  • Method and device for inquiring data
  • Method and device for inquiring data

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0058] In order to make the objectives, technical solutions, and advantages of the present application clearer, the embodiments of the present application will be described in detail below in conjunction with the accompanying drawings. It should be noted that the embodiments in the application and the features in the embodiments can be combined with each other arbitrarily if there is no conflict.

[0059] In a typical configuration of this application, the computing device includes one or more processors (CPUs), input / output interfaces, network interfaces, and memory.

[0060] The memory may include non-permanent memory in computer readable media, random access memory (RAM) and / or non-volatile memory, such as read only memory (ROM) or flash memory (flashRAM). Memory is an example of computer readable media.

[0061] Computer-readable media includes permanent and non-permanent, removable and non-removable media, and information storage can be realized by any method or technology. Th...

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 a method and device for inquiring data. The method comprises the steps that an inquiry statement is decomposed into one or more inquiry clauses; traversal is carried out on the inquiry clauses, the inquiry clauses are matched with metadata, and the inquiry clauses are replaced with execution results stored in the metadata; otherwise, the inquiry clauses are executed, and the metadata are updated; the final execution result is used for main inquiry to obtain an inquiry result. The executed inquiry clauses and the execution results of the executed inquiry clauses are used as the metadata to be managed, the identical inquiry clauses in the current session or different sessions are directly replaced with the execution results stored in the metadata, the inquiry clauses are prevented from being executed repeatedly, and therefore the inquiry performance of the whole system is improved to a greater extent. Meanwhile, compared with optimization of the existing inquiry clause level, the inquiry optimization granularity is thinner, the method and device are more suitable for inquiring large data in data warehouse application, and therefore the inquiry performance of the whole system is further improved.

Description

technical field [0001] This application relates to data storage and analysis technology, especially to a data query method and device for massive data with more reads and fewer writes in data warehouse applications. Background technique [0002] In scientific research, computer simulation, Internet applications, e-commerce and many other application fields, the amount of data is growing at an extremely fast rate. The information explosion in the era of big data, especially the explosive growth of unstructured data, is profoundly affecting the entire field of data storage and analysis. [0003] In order to meet emerging business needs, traditional data processing methods have been gradually abandoned, and new models have been tried to access, process and analyze various types of data, including unstructured data. In the field of data storage and analysis, MapReduce is undoubtedly the most concerned new-generation technology. Using the MapReduce programming framework, develop...

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/2453
Inventor 乔平夏晨傅跃兵
Owner ZHEJIANG TMALL TECH CO LTD
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