Method for interval and paging query of time-intensive B/S (Browser/Server) with large data size

Abstract

The invention discloses a method for interval and paging query of a time-intensive B / S (Browser / Server) with large data size. The method comprises the steps as follows: inputting an initial query condition by a user through the browser end to request one page or one interval; querying the interval for the first time, obtaining all time points of the interval at the server end, obtaining the total pages of the interval according to the number of the time points and sequentially writing start time and end time of each page into a cache file in an appending way, obtaining data of the page according to the start time and the end time of the first page, and returning the total pages of the interval and the data of the first page to a front desk; for the queried interval, only reading out the start time and the end time of the page to be queried from the cache file, querying the data of the page from a database according to the time condition and returning; and querying the database by dividing a table and combining by the time points to obtain a final result. According to the method, the result sets in each query are reduced, the response time for database query is shortened, and little memory space of a client and an application server is occupied.

Description

technical field [0001] The invention belongs to the field of computer data analysis, and in particular relates to a time-intensive and large data volume B / S inter-partition paging query method. Background technique [0002] Business data in many fields such as finance, telecommunications, and large-scale system automation testing are stored in databases. With the development of enterprise informatization, these data have the following characteristics: [0003] Large amount of data: data entries can usually reach millions or even tens of millions, and occupy storage space up to TB level; [0004] Time correlation of data: In the database, business data takes time as the primary key; logically, data has time correlation, that is, when querying and analyzing data, time is used as the retrieval condition, emphasizing the time at each time point within a period of time data situation; [0005] The time density of the data is high: the time interval between two adjacent pieces o...

AI Technical Summary

Problems solved by technology

[0011] The problem to be solved by the present invention is: for the massive time series data stored in the database, in the query results, each time point corresponds to a piece of result data, and multiple database tables need to be queried for a specified longer time interval. The query method of B / S architecture cannot return query results within a reasonable response time

Images