Query processing device and method

A technology of a processing device and a processing method, applied in the field of data query, can solve the problems of large amount of data, inability to effectively filter data, reduced efficiency, etc., and achieve the effect of efficient data query

Active Publication Date: 2015-01-21
YONYOU NETWORK TECH CO LTD
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] 1. The amount of data in the table is large, generally above tens of millions;
[0006] 2. The dimension of the query cannot effectively filter the data, causing the database system to scan the entire table to search for relevant data;
This brings about the biggest problem. Although the efficiency of querying extreme values ​​is improved, the query table must be maintained for each business table operation (addition, deletion, and modification), and the efficiency of using online transaction processing is reduced instead. is worth the candle

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
  • Query processing device and method
  • Query processing device and method
  • Query processing device and method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0044] In order to understand the above-mentioned purpose, features and advantages of the present invention more clearly, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0045] In the following description, many specific details are set forth in order to fully understand the present invention. However, the present invention can also be implemented in other ways different from those described here. Therefore, the protection scope of the present invention is not limited by the specific implementation disclosed below. Example limitations.

[0046] The present invention will be further described below in conjunction with the accompanying drawings and embodiments. It should be noted that, in the case of no conflict, the embodiments of the present application and the features in the embodiments can be combined with each other.

[0047] figure 1 A block diagram of a query processing device acc...

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 provides a query processing device, which comprises a device for extracting data from a service table according to a query dimension and a time dimension, generating a query table and recording the data, a device for executing extreme value query operation by at least partially taking the query table as a query data source, and a device for updating the query table at specific time according to the service table. The invention also provides a query processing method. By the technical scheme, data can be queried accurately and efficiently.

Description

technical field [0001] The present invention relates to the technical field of data query, in particular, to a query processing device and a query processing method. Background technique [0002] In a large data volume OLTP (online transaction processing) system, querying a certain extreme value data according to certain given dimensions, such as the latest value and the minimum value, is an operation that consumes a lot of system resources and is likely to cause efficiency problems. Especially when the given dimension cannot filter the data in the database table well, the efficiency problem will be very obvious. [0003] For example, in an ERP system, there are 10 million records in a table storing purchase order data. In a certain business operation, it is necessary to query the latest one (according to the order date) according to the three dimensions of material, supplier, and purchasing organization. For purchase price records, the execution time of query SQL statement...

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 Patents(China)
IPC IPC(8): G06F17/30
Inventor 赵玉行
Owner YONYOU NETWORK 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