公开(公告)号：US20250117372A1

公开(公告)日：2025-04-10

申请号：US18983339

申请日：2024-12-17

Applicant: Microsoft Technology Licensing, LLC

Inventor： Yuanyuan TIAN ,  Hanxian HUANG ,  Rana ALOTAIBI ,  Tarique Ashraf SIDDIQUI ,  Jyoti LEEKA ,  Jesus CAMACHO RODRIGUEZ ,  Carlo Aldo CURINO

IPC: G06F9/50 ,  G06F8/41

Abstract: Systems and methods for characterizing and forecasting evolving query workloads. The method includes receiving a query, the received query including a parameter value and an arrival time; identifying the query as a recurrent query; extracting a query template from the received query by parsing the received query; based at least on the identifying, generating a feature vector for the received query, the feature vector generated based on the extracted template and the parameter value; and forecasting a future query based on the generated feature vector by applying a neural network.

公开(公告)号：US20240370421A1

公开(公告)日：2024-11-07

申请号：US18335928

申请日：2023-06-15

Applicant: Microsoft Technology Licensing, LLC

Inventor： Yuanyuan TIAN ,  Hanxian HUANG ,  Rana ALOTAIBI ,  Tarique Ashraf SIDDIQUI ,  Jyoti LEEKA ,  Jesus CAMACHO RODRIGUEZ ,  Carlo Aldo CURINO

IPC: G06F16/21 ,  G06F16/2455

Abstract: Systems and methods for characterizing and forecasting evolving query workloads. The method includes receiving a query, the received query including a parameter value and an arrival time; identifying the query as a recurrent query; extracting a query template from the received query by parsing the received query; based at least on the identifying, generating a feature vector for the received query, the feature vector generated based on the extracted template and the parameter value; and forecasting a future query based on the generated feature vector by applying a neural network.

公开(公告)号：US20240289818A1

公开(公告)日：2024-08-29

申请号：US18332118

申请日：2023-06-09

Applicant: Microsoft Technology Licensing, LLC

Inventor： Jesus CAMACHO RODRIGUEZ ,  Kwanghyun PARK ,  Fotios PSALLIDAS ,  Xiaoyong ZHU ,  Jinghui MO ,  Rathijit SEN ,  Matteo INTERLANDI ,  Yuanyuan TIAN ,  Rui LIU ,  Konstantinos KARANASOS

IPC: G06Q30/0201 ,  G06N20/00

CPC classification number: G06Q30/0201 ,  G06N20/00

Abstract: The described technology provides a method including receiving a new feature definition; the new feature definition specifying parameters of the feature, comparing the new feature definition with a plurality of computed feature definitions stored in a feature store, and in response to determining that the new feature definition is at least partially contained in a matched feature definition of the plurality of computed feature definitions, generating an alternative feature definition based on the new feature definition and the matched feature definitions, and selecting an execution alternative from an execution of a PIT join using the alternative feature definition and an execution of a PIT join using the new feature definition.