 |
|
|
|
|
|
 Title: |
US5272628:
Method and system for aggregating tables having dissimilar formats
[ Derwent Title ]
|
| Country: |
US United States of America
|
| |
| Inventor: |
Koss, Michael C.; Bothell, WA
|
| Assignee: |
Microsoft Corporation, Redmond, WA
other patents from MICROSOFT CORPORATION (373780) (approx. 3,197)
News, Profiles, Stocks and More about this company
|
| Published / Filed: |
1993-12-21
/ 1990-04-16
|
| Application Number: |
US1990000509470
|
| IPC Code: |
Advanced:
G06F 17/24;
Core:
more...
IPC-7:
G06F 15/00;
G06F 15/38;
|
| U.S. Class: |
Current:
715/205;
715/227;
715/255;
Original:
364/419.19;
395/146;
395/600;
|
| Field of Search: |
364/419,523,900,518,408,200
395/148,161,375,146,148,156,157
|
| Priority Number: |
| 1990-04-16 |
US1990000509470 |
|
| Abstract: |
The present invention contemplates a method and system for automatically aggregating tables having a variety of configurations or layouts into a single destination table. Specifically, tables having a variety of categories with multiple divisions within those categories may be combined wherein rows and columns are automatically created in a destination table based on the categories and divisions of one or more source tables. In accordance with the teachings of the present invention, a plurality of source tables are selected as input to the system. A template containing categories and divisions for aggregation is then manually generated by a user or automatically generated by the computer system based on the categories and divisions contained within the source tables. Once the template is generated, mapping tables for rows and columns are created wherein each mapping table comprises an array of pairs of values wherein each pair comprises a first value for identifying a source table location and a second value for identifying a template location. The system then generates a single destination table by applying the mapping tables and by performing the desired mathematical function on the values in the source and destination tables (e.g., summing the values in the appropriate locations in the source and destination tables).
|
| Attorney, Agent or Firm: |
Seed and Berry ;
|
| Primary / Asst. Examiners: |
Envall, Jr., Roy N.; Tran, Khai
|
| INPADOC Legal Status: |
Show legal status actions
|
| Family: |
None
|
First Claim:
Show all 17 claims |
I claim:
1. A method for aggregating tables in a computer system running a program, wherein the program uses tables to store and manipulate data, each table consisting of a grid of intersecting rows and columns, and where each column has a heading called a division and each row has a heading called a category, said method comprising the steps of:
- (a) specifying a plurality of source tables for aggregation, each source table having at least one category and division;
- (b) generating a destination table template, said destination table template specifying desired categories and divisions of said source tables to be aggregated into a destination table;
- (c) creating a category mapping list that maps categories of said source tables to corresponding categories of said destination table template;
- (d) creating a division mapping list that maps divisions of said source tables to corresponding divisions of said destination table template; and
- (e) applying the category mapping list and the division mapping list to said destination table.
|
| Background / Summary: |
Show background / summary
|
| Drawing Descriptions: |
Show drawing descriptions
|
| Description: |
Show description
|
| Forward References: |
Show 72 U.S. patent(s) that reference this one
|
