Transforming data between first organization in a data store and hierarchical organization in a dataset

• US 6,704,745 B2
• Filed: 12/11/2000
• Issued: 03/09/2004
• Est. Priority Date: 12/11/2000
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Shewchuk, John P., Hejlsberg, Anders, Della-Libera, Giovanni M., Lovering, Bradford H., Dengler, Patrick M.
• Primary Examiner(s): Mizrahi, Diane D.
• Application Number:
  US09/734,385
• Publication Number:
  US 20030023609A1
• Time in Patent Office: 1,184 Days
• Field of Search: 707/1, 707/2, 707/6, 707/100, 707/101, 707/102, 707/103.R, 707/103.Z
• US Class Current: 707/796
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
• CPC Class Codes: Y10S 707/956 Hierarchical
• CPC Class Codes: Y10S 707/966 Distributed
• CPC Class Codes: Y10S 707/99936 Pattern matching access
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

Data is separated from source. Datasets store tables of data and a graph of the relationships between the tables. The relationship can change at any time. The relationships are described by metadata that describe primary key, foreign key, and lookups, and other relationships between tables. In one embodiment, the tables of data are typed columns of data. The dataset also includes information on the rowstate and differential preservation, therefore, the source does not need to manage states of the data access. Adapters abstract the interface to datasets. More specifically, adapters manage the input/output to the datasets of the tables of data and the relationships. Adapters can be specialized in their purpose, such as an adapter for OLE data or XML data or generalized in their purpose. Furthermore, a composite adapter is specialized for the purpose of interacting with other adapters. Adapters manage the connection to the dataset and the name of the server that hosts the dataset. Data hoisting is implemented, in which the fluid relationship of data is changed in response to current data needs.

Claims

1. A computerized system comprising:

a data store, having data in a first organization;

a first adapter operably coupled to the data store, for retrieving and sending data to the data store; and

a dataset operably coupled to the first adapter, the dataset having data in a hierarchical organization, the first adapter having information on the data store and the dataset, whereby the dataset need not have any of the information on the data store and the data store need not have any of the information on the dataset;

wherein the first adapter transforms the data between the first organization and the hierarchical organization;

wherein the data store has no information on the dataset; and

wherein the data is retrieved from the data store by the first adapter, and the data is pushed from the first adapter to the dataset.

2. The computerized system as in claim 1, wherein the data store further comprises a database management system and the first organization further comprises a schema.

3. The computerized system as in claim 1, further comprising:

a second adapter operably coupled between the first adapter and the data store; and

wherein the first adapter is operably coupled to the data store through the second adapter, for retrieving and sending data to the second adapter; and

wherein the second adapter transforms the data between the first organization and a native organization of the second adapter; and

wherein the first adapter transforms the data between the native organization of the second adapter and the hierarchical organization.