Thomas Patrick Conlon

US Patent:

6411313, Jun 25, 2002

Filed:

Jun 14, 1999

Appl. No.:

09/332720

Inventors:

Thomas P. Conlon - Redmond WA
Paul A. Hagger - Redmond WA

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 300

US Classification:

345769, 345840, 707503

Abstract:

A drag-and-drop form displayed directly on a spreadsheet enables a user to drag-and-drop fields to create a PivotTable data display directly on the spreadsheet. Fields of data selected by a user are displayed within a field well (an array) included with a PivotTable Button Bar. The user can select a field with a mouse, drag the selected field over a desired region, and drop the field to insert it in the desired region. The drag-and-drop form identifies a page region, a row region, a column region, and a data region on the spreadsheet. If the data is of the OLAP type, the field well also includes icons indicating whether the fields in rows to the right of the icons are of the dimension type or the measure type. Since the PivotTable Button Bar is optionally displayed on the spreadsheet at all times, the user can readily add a selected field to one of the regions of the PivotTable data display by dragging and dropping the selected field. Changes can also be made to a PivotTable data display by dragging fields within a region or between different regions.

US Patent:

6626959, Sep 30, 2003

Filed:

Jun 14, 1999

Appl. No.:

09/332958

Inventors:

Wesner P. Moise - Redmond WA
Thomas P. Conlon - Redmond WA
Michelle Lee Thompson - Woodinville WA

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 1500

US Classification:

715522, 715503, 715517, 715523, 715906

Abstract:

Automatically formatting a spreadsheet pivot table using one of a plurality of predefined formats that include banded report formats and tabular report formats. The pivot table is reformatted automatically, based on a user selection of a predefined banded table or tabular format. Alternatively, the format of an original pivot table or a reformatted pivot table may be changed based on user choices made from a plurality of formatting dialogs. The automatically and modified formats include field emphasis, positioning of group totals, and insertion of blank lines. The predefined formats include a variety of different font styles, colors, backgrounds and borders. A reformatted pivot table has an enhanced appearance, while maintaining the full-functionality associated with a spreadsheet pivot table. The underlying format of a reformatted pivot table is maintained, allowing a user to move, add, or delete fields and add or remove calculated data without altering the overall format of the reformatted pivot table.

US Patent:

7328207, Feb 5, 2008

Filed:

Aug 20, 2004

Appl. No.:

10/922517

Inventors:

Marius Dumitru - Issaquah WA, US
Mosha Pasumansky - Redmond WA, US
Raman Iyer - Redmond WA, US
Thomas P. Conlon - Redmond WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 17/30
G06F 15/16

US Classification:

707 3, 707 4, 707 5, 709217

Abstract:

A method is described herein for causing an analytical database server to store query results in a memory. In the method, a first header element and a request to query an analytical database is received. The first header element indicates that a query result should be stored. The analytical database is queried according to the request, and the query result is stored. An identifier associated with the query result and a second header element corresponding to the identifier is then transmitted.

US Patent:

7562086, Jul 14, 2009

Filed:

Jun 27, 2005

Appl. No.:

11/167413

Inventors:

Akshai M. Mirchandani - Redmond WA, US
Alexander Berger - Sammamish WA, US
Thomas P. Conlon - Redmond WA, US
Edward Melomed - Kirkland WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 7/00

US Classification:

707101

Abstract:

Custom grouping for dimension members of an On-Line Analytical Processing (OLAP) cube is facilitated by an interface component that receives a grouping from a user. A modification component alters an attribute of a session OLAP data cube or a virtual OLAP multi-dimensional data cube so that the change becomes readily available without the time-consuming delay associated with rebuilding or reprocessing the underlying structure. A data scheme generation component produces a data definition language (DDL) definition of a user defined attribute executed by an execution component to affect the change to a data cube. Custom groupings can provide an intermediate dimension level for drill down and/or drill up or roll-up between a level with few members and a level with numerous members. A separate dimensional attribute or level can be created and a group defined comprising or mapping a set or collection of discrete members.

US Patent:

7680776, Mar 16, 2010

Filed:

Jan 11, 2006

Appl. No.:

11/329616

Inventors:

Cristian Petculescu - Redmond WA, US
Amir Netz - Bellevue WA, US
Thomas P. Conlon - Redmond WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 7/00
G06F 17/30
G06F 17/00

US Classification:

707 3, 707100

Abstract:

The present invention leverages MOLAP performance for ROLAP objects (dimensions, partitions and aggregations) by building, in a background process, a MOLAP equivalent of that object. When the background processing completes, queries are switched from ROLAP queries to MOLAP queries. When changes occur to relevant relational objects (such as tables that define content of OLAP objects), an OLAP object is switched back to a ROLAP mode, and all relevant caches are dropped while, as a background process, a new MOLAP equivalent is created.

US Patent:

7689605, Mar 30, 2010

Filed:

Jan 11, 2006

Appl. No.:

11/329446

Inventors:

Cristian Petculescu - Redmond WA, US
Amir Netz - Bellevue WA, US
Thomas P. Conlon - Redmond WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 17/30
G06F 7/00

US Classification:

707600, 707610

Abstract:

The present invention leverages MOLAP performance for ROLAP objects (dimensions, partitions and aggregations) by building, in a background process, a MOLAP equivalent of that object. When the background processing completes, queries are switched from ROLAP queries to MOLAP queries. When changes occur to relevant relational objects (such as tables that define content of OLAP objects), an OLAP object is switched back to a ROLAP mode, and all relevant caches are dropped while, as a background process, a new MOLAP equivalent is created.

US Patent:

7689703, Mar 30, 2010

Filed:

Mar 1, 2005

Appl. No.:

11/069342

Inventors:

Mosha Pasumansky - Redmond WA, US
Marius Dumitru - Issaquah WA, US
Adrian Dumitrascu - Bellevue WA, US
Cristian Petculescu - Redmond WA, US
Akshai M. Mirchandani - Redmond WA, US
Paul J. Sanders - Seattle WA, US
Thulusalamatom Krishnamurthi Anand - Redmond WA, US
Richard R. Tkachuk - Sammamish WA, US
Raman S. Iyer - Redmond WA, US
Thomas P. Conlon - Redmond WA, US
Alexander Berger - Sammamish WA, US
Sergei Gringauze - Redmond WA, US
Ioan Bogdan Crivat - Redmond WA, US
C. James MacLennan - Redmond WA, US
Rong J. Guan - Sammamish WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 15/16
G06F 17/30

US Classification:

709230, 707 10

Abstract:

The subject invention relates to systems and methods that extend the network data access capabilities of mark-up language protocols. In one aspect, a network data transfer system is provided. The system includes a protocol component that employs a computerized mark-up language to facilitate data interactions between network components, whereby the data interactions were previously limited or based on a statement command associated with the markup language. An extension component operates with the protocol component to support the data transactions, where the extension component supplies at least one other command from the statement command to facilitate the data interactions.

US Patent:

7756739, Jul 13, 2010

Filed:

Feb 12, 2004

Appl. No.:

10/777918

Inventors:

Thierry D'hers - Redmond WA, US
Thomas Conlon - Redmond WA, US
Mosha Pasumansky - Redmond WA, US
Irina Gorbach - Bellevue WA, US
Alexander Berger - Sammamish WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 17/30

US Classification:

705 10

Abstract:

A simple interface may be provided that enables the user to define parameters for aggregation of a semi-additive measure. The interface may enable the user to designate a measure as a semi-additive measure and to pair the measure with an additive aggregation function. The interface may also enable the user to select non-additive dimensions and to pair each non-additive dimension with a corresponding aggregation function. One such aggregation function is a by account aggregation function, which enables each account in an account dimension to be aggregated across a corresponding non-additive dimension according to an associated account type.