Dynamic data discovery of a source data schema and mapping to a target data schema
US7720873B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Jun 21, 2007 |
| Grant date | May 18, 2010 |
| Priority date | — |
| Expiry date | Apr 16, 2028 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/213
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A computerized method, program product, and a service that discovers trace data inserted into a source database having an unknown schema. Once the trace data is found by a dynamic data discovery engine, the tables, the fields, and the attributes of the fields in the source schema in which the trace data were located can be evaluated to determine if the data in the fields are pertinent to a target database. If so, then the data in those fields can be mapped and transferred to a target database. The dynamic data discovery engine generates the commands in both the source and the target database command language to find all pertinent data, map and transfer the data from the source database to a target database. The dynamic data discovery engine generates commands to create the target database and/or fields within an existing target database for the mapped and transferred data.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.