Pawel T Terlecki

US Patent:

20110167056, Jul 7, 2011

Filed:

Jan 4, 2010

Appl. No.:

12/651634

Inventors:

Nimish S. Khanolkar - Bellevue WA, US
Pawel Terlecki - Bellevue WA, US
Cesar A. Galindo-Legaria - Redmond WA, US
Yavor V. Angelov - Redmond WA, US
Mostafa Elhemali - Seattle WA, US
Pooja N. Darera - Redmond WA, US

Assignee:

MICROSOFT CORPORATION - Redmond WA

International Classification:

G06F 17/30

US Classification:

707718, 707E17014

Abstract:

A query configured according to a query template is received. The query includes values for a plurality of parameters. A key is generated for the query that indicates a selectivity region in a selectivity space determined for the included parameter values. Whether the generated key matches any key of a plurality of keys is determined. Each key of the plurality of keys is associated with a corresponding query plan. If the generated key is determined to not match any of the keys, the query is compiled to generate a new query plan, and the generated query plan is executed with respect to the query. If the key is determined to match any key of the plurality of keys, a query plan associated with the matched key is selected, and the query plan associated with the matched key is executed with respect to the query.

US Patent:

20220309066, Sep 29, 2022

Filed:

Jun 14, 2022

Appl. No.:

17/840546

Inventors:

- Seattle WA, US
Ross Bunker - Seattle WA, US
Marianne Shaw - Seattle WA, US
Pawel Terlecki - Seattle WA, US

International Classification:

G06F 16/2453
G06F 16/248
G06F 16/2455
G06F 16/28
G06F 16/9535

Abstract:

A user selects a first group of one or more dimension fields that specifies a primary aggregation for a data visualization, where the one or more dimension fields are in a first data source. When one or more first dimension fields in the first group are not dimension fields in a second data source, a client device joins the first data source with the second data source at a first level of detail that is more granular than the primary aggregation to form a single combined data set that includes the one or more dimension fields specified in the first group and one or more measure data fields aggregated according to the first group. The client device rolls up the combined data set, including the one or more measure data fields, to form a final data set and displays the data visualization using the data from the final data.

US Patent:

20230037619, Feb 9, 2023

Filed:

Jul 6, 2022

Appl. No.:

17/858957

Inventors:

Pawel Terlecki - Miami FL, US
Geert Bosch - Brooklyn NY, US
James Wahlin - Queens NY, US
Eric Cox - Brooklyn NY, US
Edward Tuckman - New York NY, US
Bora Beran - New York NY, US

International Classification:

G06F 16/22
G06F 16/2458

Abstract:

In some implementations, events measured at various points in time may be organized in a data structure that defines an event represented by a document. In particular, events can be organized in columns of documents referred to as buckets. These buckets may be indexed using B-trees by addressing metadata values or value ranges. Buckets may be defined by periods of time. Documents may also be geoindexed and stored in one or more locations in a distributed computer network. One or more secondary indexes may be created based on time and/or metadata values within documents.

US Patent:

20230040530, Feb 9, 2023

Filed:

Jul 6, 2022

Appl. No.:

17/858950

Inventors:

Pawel Terlecki - Miami FL, US
Geert Bosch - Brooklyn NY, US
James Wahlin - Queens NY, US
Eric Cox - Brooklyn NY, US
Edward Tuckman - New York NY, US
Bora Beran - New York NY, US

International Classification:

G06F 16/22

Abstract:

In some implementations, events measured at various points in time may be organized in a data structure that defines an event represented by a document. In particular, events can be organized in columns of documents referred to as buckets. These buckets may be indexed using B-trees by addressing metadata values or value ranges. Buckets may be defined by periods of time. Documents may also be geoindexed and stored in one or more locations in a distributed computer network. One or more secondary indexes may be created based on time and/or metadata values within documents.

US Patent:

20230041129, Feb 9, 2023

Filed:

Jul 6, 2022

Appl. No.:

17/858951

Inventors:

Pawel Terlecki - Miami FL, US
Geert Bosch - Brooklyn NY, US
James Wahlin - Queens NY, US
Eric Cox - Brooklyn NY, US
Edward Tuckman - New York NY, US
Bora Beran - New York NY, US

International Classification:

G06F 16/2458
G06F 16/22

Abstract:

In some implementations, events measured at various points in time may be organized in a data structure that defines an event represented by a document. In particular, events can be organized in columns of documents referred to as buckets. These buckets may be indexed using B-trees by addressing metadata values or value ranges. Buckets may be defined by periods of time. Documents may also be geoindexed and stored in one or more locations in a distributed computer network. One or more secondary indexes may be created based on time and/or metadata values within documents.

US Patent:

20150032723, Jan 29, 2015

Filed:

Oct 14, 2014

Appl. No.:

14/514259

Inventors:

- Redmond WA, US
Pawel Terlecki - Bellevue WA, US
Cesar A. Galindo-Legaria - Redmond WA, US
Yavor V. Angelov - Redmond WA, US
Mostafa Elhemali - Seattle WA, US
Pooja N. Darera - Redmond WA, US

International Classification:

G06F 17/30

US Classification:

707718

Abstract:

A query is received. The query comprises a plural number of efficiency expressions. A key is generated for the query indicating a first selectivity region in multi-dimensional selectivity space comprising an array of selectivity regions arranged according to a grid with a number of dimensions equal to the plural number. The generated key is used to look up a stored query plan among a plurality of stored query plans. A stored query plan is executed for the query that is associated with a stored key determined to match the generated key.