Microsoft Technology Licensing, LLC

Stephen Albert Brandli

Adam Bosworth

Allen Reiter

Stephen Charles Hecht

Matthew Bellew

William P Jones

A method and system for displaying results of multiple level aggregation queries and providing hierarchical table sets in response to multiple level aggregation queries. In a preferred embodiment, a database engine program receives multiple-level aggregation queries from a database front-end program. A multiple level aggregation query defines two or more data aggregation levels. In response to a multiple-level aggregation query, the engine creates a hierarchical table set, which contains a separate table for each level of aggregation specified by the multiple-level aggregation query. Each table in the hierarchical table set contains the aggregation information for one level of the multiple-level aggregation query. In a preferred embodiment, the front-end uses the tables in the hierarchical table set to generate a hierarchical window display that the user can view. The engine preferably also generates a crosstab table having row and column headers which are derived from the data in the source tables by converting a crosstab query into a multi-level aggregation query, executing the multi-level aggregation query, and then retrieve the data for the crosstab table using the hierarchical table set.

Method and system for generating database queries containing multiple

A method and system for generating accurate search results using a content-index is provided. In a preferred embodiment, a content-index search system is invoked in response to a query on a collection of objects. The collection of objects is indexed by the content-index and may, for example, be a corpus of documents indexed by the terms contained in the documents. The content-index search system uses the content-index to generate and store an initial search result in response to the query. Because the content-index is typically out of date with respect to a dynamically changing collection of objects, the content-index search system invokes search result correction routines to remove from the stored search result references that were incorrectly included and to add to the stored search result references that were incorrectly excluded. References that were incorrectly included include those that refer to objects that no longer exist and those that refer to objects that have been modified since the content-index was last updated and that no longer match the search criteria. References that were incorrectly excluded include those that refer to new objects that were not indexed and match the search criteria and those that refer to objects that have been modified since the content-index was last updated and that now match the search criteria.

Method and system for generating accurate search results using a

A method and system for supporting scrollable, updatable database queries is provided. In a preferred embodiment, a database engine receives a query request specifying the retrieval of data from a source table stored by the engine. The engine then generates a query table that contains references to rows of a source table that satisfy the query request. The engine then receives one or more retrieve requests requesting that data specified by the query be provided by the engine. For each retrieval request, the engine retrieves data from the source table using one Or more references from the query table.

Growing community of inventors

Bothell, WA, United States of America

Stephen Albert Brandli