A statistical data query method and device

Abstract

The invention discloses a statistical data query method and device, relates to the technical field of data processing, and mainly aims to pre-process data and take a processing result as basic data ofquery so as to reduce the data calculation amount and improve the query response speed. The method comprises the following steps: analyzing a query request according to a preset query dimension to obtain a plurality of query conditions under different dimensions; Judging whether the query condition is the minimum query granularity in the preset query dimension one by one; If yes, querying a firstquery result corresponding to the query condition from a first data table; If not, determining a query range of the query condition, and querying a second query result corresponding to the query condition from a second data table; And determining a third query result responding to the query request according to the first query result and / or the second query result. The method is mainly used for data query.

Description

technical field [0001] The present invention relates to the technical field of data processing, and in particular, to a method and device for querying statistical data. Background technique [0002] With the popularity of the Internet, online media releases media data to netizens through the Internet, and determines the status of information release according to the viewing situation of the media data, and then counts the viewing data of the information. For example, the viewing statistics of online videos are based on the Video analysis of video, in general, video analysis is to divide the video into several segments according to the length of the video, and the user will record the viewing results of each segment in the database each time they watch it. For example, the stored data is [2,1,3, 0,4,0,...,0], which means that the first segment was played twice by the user (caused by the user moving the progress bar), and the second segment was played by the user once. ……And ...

AI Technical Summary

Problems solved by technology

However, in the query process, the objects of the query are all viewing result records in the database, and the amount of data to be queried and screened is huge, requiring a long query time, and after obtaining the data information from the database, it is also necessary to These data information are further merged and calculated according to the statistical requirements. For the case of high concurrent requests, a large amount of system computing resources will be consumed. In the case of limited resources, the response time for users will undoubtedly be delayed, thereby reducing the user's operating experience.

Images