公开(公告)号：US11120021B2

公开(公告)日：2021-09-14

申请号：US15404118

申请日：2017-01-11

Applicant: Facebook, Inc.

Inventor： Kevin Alan Schaeffer ,  Wojciech Galuba

IPC: G06F16/00 ,  G06F16/2453

Abstract: Systems, methods, and non-transitory computer-readable media can receive a query that includes at least one operation for aggregating data stored in one or more database tables. A determination is made that at least a portion of the data being aggregated by the operation has been pre-computed. The query is optimized so that the operation uses the pre-computed data when executed.

公开(公告)号：US20180196850A1

公开(公告)日：2018-07-12

申请号：US15404118

申请日：2017-01-11

Applicant: Facebook, Inc.

Inventor： Kevin Alan Schaeffer ,  Wojciech Galuba

IPC: G06F17/30

CPC classification number: G06F16/24539 ,  G06F16/24542

Abstract: Systems, methods, and non-transitory computer-readable media can receive a query that includes at least one operation for aggregating data stored in one or more database tables. A determination is made that at least a portion of the data being aggregated by the operation has been pre-computed. The query is optimized so that the operation uses the pre-computed data when executed.

公开(公告)号：US09972025B2

公开(公告)日：2018-05-15

申请号：US13906313

申请日：2013-05-30

Applicant: FACEBOOK, INC.

Inventor： Michael Nowak ,  Ye Lu ,  Breno Roberto ,  Flavio Oliveira ,  Brent Bannon ,  Wojciech Galuba

IPC: G06Q30/02 ,  G06Q50/10 ,  G06Q50/00

CPC classification number: G06Q30/0203 ,  G06Q50/01

Abstract: An embodiment of a system and method of surveying users on a social networking system is described which limits the frequency in which any one user is surveyed. Users are assigned into a multi-layered survey pool based on a hash value derived from a user identification number for the online social network that is assigned to the user. Users are randomly offered the opportunity to take a survey, and the subject matter of the survey is at least partially determined by the layer from which the survey obtains its sample populace.