Schema contracts for data integration
US8799299B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | May 27, 2010 |
| Grant date | Aug 5, 2014 |
| Priority date | — |
| Expiry date | Jul 18, 2031 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/835
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A system and method for extracting data from an input source, transforming the data, and loading the transformed data to an output destination. A schema contract including constraints is used to validate a set of input data column types and translate them into a set of actual types. Mapping data in the schema contract enable mapping input data columns to data columns used by data integration components. The constraints and mapping data provide flexibility in transforming sets of data having different sets of input data column types, while providing a fixed set of types for use during dataflow executions. Flexibility may enable optional columns, sets of one or more columns, varying arrangements of columns, and variations in type definitions of each column.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.