Data speedup query method based on file system caching

A file system and query method technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve the problem of limited speedup of large data volume queries, and achieve the goal of avoiding repeated query requests, improving efficiency, and improving hit rate. Effect

Inactive Publication Date: 2008-01-23
INSPUR TIANYUAN COMM INFORMATION SYST CO LTD
View PDF0 Cites 79 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

For this reason, more funds need to be invested in upgrading software and hardware to improve the processing capacity of the system and reduce the waiting time of users, and the speed-up for large-scale data queries is also very limited.

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 speedup query method based on file system caching
  • Data speedup query method based on file system caching
  • Data speedup query method based on file system caching

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0043] For example, for the report query of the performance system, the specific execution steps are as follows:

[0044] Step 1. The user queries report A, sets the conditions to be queried on the page and submits a query request. For example, the query conditions are 2006-11-21 10:00:00, 2006-11-21 20:00:00, 2006 -11-2117:00:00, the range is: all the districts and counties, Zibo, and Tai'an of Jinan are arranged in descending order of column X.

[0045] Step 2. The query request is forwarded to the query analyzer, and the submitted query conditions are analyzed, and the query is divided into two parts: database operation processing and data processor processing.

[0046] ●The calculation condition of the database is: the date is from 2006-11-21 10:00:00 to 2006-11-21 20:00:00, and the range is: Jinan, Tai'an, Zibo.

[0047] ●The processing conditions of the data processor are arranged in the descending order of the X column.

[0048] Step 3. Normalize the query conditions,...

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 an accelerated data query method in a query system, which provides an accelerated data query method based on a cache of document system according to the features of unchanged saved historical data and frequent query of same data. The invention saves the historical query data and takes it as the cache data for query, so as to accelerate the query. Upon receiving the query quest from user, the system will first of all turn to the query analyzer; the principal function of the query analyzer is to analyze and plan the query condition; then, after passing through a document buffer, the system analyzes whether the data document in the result satisfies the present query need; if not, the query will be carried out in the database and the final result will be fed back to a data processor; then, the data processor will filter and sort the data according to the final query demand and finally feed back the result document to a super stratum application system. Therefore, without increasing the investment on hardware, this query method is able to greatly reduce the occupation of database and system resource, so as to improve the query speed.

Description

1. Technical field [0001] The invention relates to the field of computer application technology and communication technology, in particular to a data acceleration query method in a telecommunication query system. It is suitable for data acceleration query based on file system cache for historical data that does not change after storage and has a large number of repeated queries. 2. Technical Background [0002] With the continuous development of society, enterprises are building more and more supporting systems, and information sharing has become particularly important. Information sharing has increased the number of users visiting the software system, but with the increasing number of users, the amount of data queries will inevitably increase greatly , and the system will become slower and slower, which requires more investment in equipment and software upgrades. The reason for this is that for each query request by the user, the system performs corresponding search, data ...

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 Applications(China)
IPC IPC(8): G06F17/30
Inventor 张明
Owner INSPUR TIANYUAN COMM INFORMATION SYST 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