Microsoft Technology Licensing, LLC

Stephen Charles Hecht

Adam Bosworth

Allen Reiter

Stephen Albert Brandli

Matthew Bellew

Ketan K Dalal

A database normalizing system for transparently normalizing a record source in a database wherein the record source contains a plurality of records and each of the records contains at least one field that is common across each of the records. The database normalizing system includes evaluating data from the record source and suggesting a relational split of the record source in response to evaluating the data therein. Evaluating the data further includes generating a hierarchy of fields organized by field distinctiveness of each field in the record source, adjusting the hierarchy based on field distinctiveness, and promoting fields among levels of the hierarchy based on a data correlation among the fields in each level of the hierarchy.

Database normalizing system

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 for accessing a database server using pass-through queries includes parsing a database query to separate a pass-through string, and then sending a pass-through string to retrieve information regarding the structure of a remote table. The method further includes fetching data as needed from the remote table, and caching the remote data in a temporary table in memory of the local computer system. The system includes a query processor to compile the database query, a remote engine to retrieve table structure information and fetch data as needed, and a temporary table manager to manage caching of the fetched data.

Method and system for accessing a remote database using pass-through

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

Seattle, WA, United States of America

Stephen Charles Hecht