公开(公告)号：US20240311356A1

公开(公告)日：2024-09-19

申请号：US18183925

申请日：2023-03-14

Applicant: Google LLC

Inventor： Haoyu Huang ,  Vincent Zhuang ,  Sam Idicula ,  Gaurav Jain

IPC: G06F16/22 ,  G06F16/2453 ,  G06F16/2455

CPC classification number: G06F16/221 ,  G06F16/24542 ,  G06F16/2455

Abstract: A method for workload-driven index selections includes receiving a request for a recommended index configuration. The method includes obtaining a plurality of queries executed at the database. The method also includes selecting a set of candidate indexes from the plurality of indexes. The method includes for each respective candidate index of the set of candidate indexes, determining, based on the plurality of queries, a respective workload cost for the respective candidate index. The method also includes selecting, based on the respective workload cost, a first candidate index from the set of candidate indexes for the recommended index configuration. The method includes selecting one or more additional candidate indexes from the set of candidate indexes for the recommended index configuration. The method includes determining that a size of the selected candidate indexes satisfies a size threshold and transmitting the recommended index configuration.

公开(公告)号：US20200265460A1

公开(公告)日：2020-08-20

申请号：US16865813

申请日：2020-05-04

Applicant: Google LLC

Inventor： Samir Goel ,  Gaurav Jain

IPC: G06Q30/02 ,  G06Q30/04

Abstract: Methods, systems and apparatus for identifying illegitimate selections of content items. In some implementations, one or more servers can receive display data specifying a display state of a web page in a viewport. The web page includes a content item. Display instances are identified. A display instance is a display of at least a portion of the content item in the viewport. Selection instances of the content item are identified. A selection instance is a selection of the content item. The server(s) determines whether a selection of the content item occurred during a display of at least a portion of the content item in the viewport based on the display instances and the selection instances. A selection of the content is defined as an illegitimate selection if the selection did not occur during a display of at least a portion of the content item in the viewport.

公开(公告)号：US11354699B2

公开(公告)日：2022-06-07

申请号：US16865813

申请日：2020-05-04

Applicant: Google LLC

Inventor： Samir Goel ,  Gaurav Jain

IPC: G06Q30/02 ,  G06Q30/04

Abstract: Methods, systems and apparatus for identifying illegitimate selections of content items. In some implementations, one or more servers can receive display data specifying a display state of a web page in a viewport. The web page includes a content item. Display instances are identified. A display instance is a display of at least a portion of the content item in the viewport. Selection instances of the content item are identified. A selection instance is a selection of the content item. The server(s) determines whether a selection of the content item occurred during a display of at least a portion of the content item in the viewport based on the display instances and the selection instances. A selection of the content is defined as an illegitimate selection if the selection did not occur during a display of at least a portion of the content item in the viewport.

公开(公告)号：US20230141891A1

公开(公告)日：2023-05-11

申请号：US17523520

申请日：2021-11-10

Applicant: Google LLC

Inventor： Haoyu Huang ,  Gaurav Jain ,  Xun Cheng ,  Viral Shah ,  Eugene Brevdo ,  Lyric Pankaj Doshi

IPC: G06F16/2453 ,  G06F16/22 ,  G06F16/2455

CPC classification number: G06F16/24539 ,  G06F16/2264 ,  G06F16/24552 ,  G06F16/221

Abstract: Aspects of the disclosure are directed to generating cache configurations for caching data for a database. A database management system (DBMS) can search for column data to cache in a database cache to improve performance of the DBMS in resolving queries. Column data selection can be performed automatically and in the background of a deployed DBMS. Periodically, the DBMS can assess the performance benefit of having certain data cached in the database cache and select data for caching based on the assessed performance benefit. The DBMS can also determine the performance benefit of cached data when not cached, as well as select some portions of data to cache over others. The DBMS can also select data for caching based on different degrees of compression, to further improve query resolution performance.

公开(公告)号：US10713682B2

公开(公告)日：2020-07-14

申请号：US15468969

申请日：2017-03-24

Applicant: Google LLC

Inventor： Samir Goel ,  Gaurav Jain

IPC: G06Q30/02 ,  G06Q30/04

Abstract: Methods, systems and apparatus for identifying illegitimate selections of content items. In some implementations, one or more servers can receive display data specifying a display state of a web page in a viewport. The web page includes a content item. Display instances are identified. A display instance is a display of at least a portion of the content item in the viewport. Selection instances of the content item are identified. A selection instance is a selection of the content item. The server(s) determines whether a selection of the content item occurred during a display of at least a portion of the content item in the viewport based on the display instances and the selection instances. A selection of the content is defined as an illegitimate selection if the selection did not occur during a display of at least a portion of the content item in the viewport.