Unlock instant, AI-driven research and patent intelligence for your innovation.

Data query method and device and server

A data query and server technology, which is applied in the Internet field, can solve the problems of long time consumption and long query time, and achieve the effect of reducing query time consumption

Inactive Publication Date: 2019-07-05
BEIJING QIYI CENTURY SCI & TECH CO LTD
View PDF8 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Kylin can be understood as a platform that provides big data query. Due to the influence of kylin storage method and query engine, for example, in the query method based on kylin (kylin), data is stored in the distributed database Hbase, and all data files in HBase are stored On the distributed system infrastructure Hadoop Distributed File System (Hadoop Distributed File System, HDFS), and one of the storage formats is HFile, and HFile is a binary format file of Hadoop. When querying data, it needs to obtain data from HDFS, and needs Parsing the data in Hfile format takes a long time, which leads to a long query time when querying statistical data through the existing kylin-based query method

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 query method and device and server
  • Data query method and device and server
  • Data query method and device and server

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0061] The technical solutions in the embodiments of the present invention will be described below with reference to the drawings in the embodiments of the present invention.

[0062] After a user uploads a video, there is a need to understand the status of the uploaded video. If you want to query the uploaded video's playback volume and / or recommendation volume within a week, etc., the playback volume and recommendation volume can be understood as the video's Video data, playback volume and / or recommendation volume within a week can be understood as statistical data.

[0063] In some scenarios, the user queries the statistical data of a fixed time range, such as the statistical data of yesterday / 1 week / 2 weeks / 1 month / 3 months. In this way, the statistical data of the user yesterday / 1 week / 2 weeks / 1 month / nearly months can be pre-calculated, and the pre-calculated results can be saved. When receiving the user's query request, the server can directly obtain the statistical da...

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 embodiment of the invention provides a data query method and device and a server, and the method comprises the steps of receiving a query request which comprises a user identifier and a to-be-queried time range identifier; obtaining the target statistical data corresponding to the user identifier and the to-be-queried time range identifier from a pre-stored data table, wherein the storage medium for storing the data table is embedded in the server; aiming at each preset time range in the data table, correspondingly storing the statistical data corresponding to the predetermined time rangeand the predetermined time range, distinguishing each predetermined time range through the corresponding time range identifier, wherein the target statistical data is obtained by counting the video corresponding to the user identifier and the video data in the predetermined time range corresponding to the to-be-queried time range identifier. Through the data query method and device and the serverprovided by the embodiment of the invention, the query time consumption can be reduced.

Description

technical field [0001] The invention relates to the technical field of the Internet, in particular to a data query method, device and server. Background technique [0002] After uploading a video, the user will check the statistical data of the uploaded video, such as the playback volume of the video within a week, and so on. In the prior art, the statistic data of videos uploaded by users are queried through a kylin-based query method, and the statistic data obtained from the query are returned to the user. [0003] However, the inventor found in the process of realizing the present invention that the prior art has at least the following problems: [0004] Kylin can be understood as a platform that provides big data query. Due to the influence of kylin storage method and query engine, for example, in the query method based on kylin (kylin), data is stored in the distributed database Hbase, and all data files in HBase are stored On the distributed system infrastructure Had...

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): G06F16/245G06F16/2458
Inventor 康林段效晨秦占明赵艳杰易帆
Owner BEIJING QIYI CENTURY SCI & TECH CO LTD