Mass data querying method

A technology of massive data and query methods, applied in the information field to achieve the effect of improving query efficiency

Active Publication Date: 2009-09-16
RUN TECH CO LTD BEIJING
View PDF0 Cites 41 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0020] This method aims at the situation that the traditional methods in the massive data query can no longer meet the performance requirements, effectivel

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
  • Mass data querying method
  • Mass data querying method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0043] The present invention will be further described below through specific embodiments in conjunction with the accompanying drawings.

[0044] Assume that the following three massive data entity tables exist in the system of this embodiment, and the names are Food, Clothes, and Device respectively. The data structures of these three entity tables are shown in Table 1-3 below:

[0045] Table 1: Food - food category

[0046] trade

ID

commodity

ID

client

ID

when trading

between

price

grid

number

quantity Sellers

ID

That

he

production day

Expect

shelf life

Expect

That

he

... ... ... ... ... ... ... ... ... ... ...

[0047] Table 2: Clothes - clothing category

[0048] trade

ID

commodity

ID

client

ID

when trading

between

price

grid

number

quantity

Sellers

ID

Production

land

B...

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 mass data querying method, belonging to the information technology field. The method comprises: a) dividing the mass data entity table according to the given time spans into sub-areas; b) establishing a two-dimensional statistical table for attribute names in the entity table, wherein one dimension represents all the given time spans in the time interval, the other dimension represents the attribute data in the attribute column of the attribute names, and the contents in the statistical table represent the name of entity table of certain attribute data existing in certain time span; c) during querying, acquiring a collection of the entity table sub-areas in the time interval according to the statistical table for the attribute name and the time interval given in the querying condition, if the querying condition comprises the statistically treated attribute name; and d) narrowing the mass data scope according to the collection and then carrying out query. The method of the invention can be used for mass data query in large-scale systems such as charging query systems of telecommunications industry, large website transaction platform and the like.

Description

technical field [0001] The invention relates to database data query, in particular to a massive data query method with improved query performance, and belongs to the field of information technology. Background technique [0002] Query is the only way for users to obtain information from the database, and it is also the main function of general application systems, and the query efficiency of the system is also one of the key indicators to measure its practicability. In industries such as telecommunications and the Internet, with the development of informatization, the data to be processed by enterprises has grown explosively, and the amount of data has reached terabytes and petabytes. As the amount of data increases, the load on the system is increasing. Without increasing the cost of hardware, the performance of user query data decreases accordingly. How to give full play to the maximum performance of the existing system so that the query speed can meet the practical requi...

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
Inventor 储院生
Owner RUN TECH CO LTD BEIJING
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