On-line number of people distribution calculation method and device

Abstract

The invention discloses an on-line number of people distribution calculation method and device, and belongs to the field of on-line live broadcast. The method includes the steps: obtaining on-line time periods of each user corresponding to different types of client sides in an Internet product; for the on-line time periods of each user corresponding to different types of clients which intersect, splitting according to intersection endpoints to obtain split time periods of each user under different on-line types; and according to the split time periods of each user under different on-line types, calculating on-line number of people statistical data corresponding to a certain type of clients. The method solves the problems that when on-line number of people statistical data corresponding to different types of clients are calculated, the calculation quantity is enormous, and calculation is time-consuming; and the effects of avoiding a Cartesian product and a large amount of duplicate removing calculation in a calculation process, simplifying data when distribution situations of the on-line number of people on different types of client is calculated, reducing the calculated amount of calculation data, and improving algorithm operation efficiency are achieved.

Description

Technical field [0001] The embodiment of the present invention relates to the field of online live broadcasting, and in particular to a method and device for calculating the number of online people. Background technique [0002] In Internet products, user clients are generally divided into three types: computer clients, mobile clients and web clients. After the highest number of online users of Internet products are counted, in order to better observe the distribution of users, it is also necessary to count the number of people online at the same time every second and the distribution of the number of people online at the same time every second on the three clients. [0003] In the prior art, a fact table is used to store online data of users. Each record in the fact table includes at least Internet product name, date, user name, client, start time and end time, and a time dimension table is used to store the time of one day. In the time dimension table, the time from 00:00:00 to ...

AI Technical Summary

Problems solved by technology

[0004] In the process of realizing the present invention, the inventor found that the prior art has at least the following problems: since the connection between the fact table and the time dimension table is a Cartesian product, the size of the data set after the connection between the fact table and the time dimension table is N *86400, and every calculation of the number of simultaneous online users for one second requires de-duplication statistics. Completing N*86400 calculations is equivalent to performing N*86400 de-duplication statistics, resulting in a large amount of data in the calculation process, and the calculation process is relatively complicated. time consuming

Images