System and method for translating data from a source schema to a target schema

Number of patents in Portfolio can not be more than 2000

United States of America Patent

APP PUB NO 20040199905A1
SERIAL NO

10404752

Stats

ATTORNEY / AGENT: (SPONSORED)

Importance

Loading Importance Indicators... loading....

Abstract

See full text

The present system imports data from a source schema into a target schema while keeping the semantics, structure, and constraints of the data intact. The system is driven by user inputs that define a set of correspondences between the source schema and the target schema. The system meets the requirement that data produced at the target not violate the schema of the target; rather, the data must conform to the target schema. The system can be applied in both target materialization and query unfolding, producing all the meaningful queries required in data translation by finding all the associations that exist in the schemas. Each query maps from a source association to a target association. The user selects a subset of those queries that match the desired data translation. Target constraints are taken into account by the present system to infer the user intention and to guarantee that the generated data satisfies the structure and constraints of the target schema. Fields required by the target schema that are not provided by the source schema are automatically populated by the present system. The target instance is guaranteed to be in partition normal form.

Loading the Abstract Image... loading....

First Claim

See full text

Family

Loading Family data... loading....

Patent Owner(s)

Patent OwnerAddress
INTERNATIONAL BUSINESS MACHINES CORPORATIONNEW ORCHARD ROAD ARMONK NY 10504

International Classification(s)

  • [Classification Symbol]
  • [Patents Count]

Inventor(s)

Inventor Name Address # of filed Patents Total Citations
Fagin, Ronald Los Gatos, CA 16 927
Hernandez-Sherrington, Mauricio Antonio Gilroy, CA 15 572
Miller, Renee J Toronto, CA 6 187
Popa, Lucian San Jose, CA 36 664
Velegrakis, Ioannis Toronto, CA 4 78

Cited Art Landscape

Load Citation

Patent Citation Ranking

Forward Cite Landscape

Load Citation