Enhanced data conversion framework
AssigneeSap SE
InventorsHong-Hai Do, Gregor Hackenbroich
Life of this patent
Estimating the term…
Abstract
An enhanced data conversion framework, in which a data record in each of first and second data sources is populated with manually selected, representative sample data, the first and second data sources using different data storage schemas to store the representative sample data as instance values of instance elements. Parameters for a CONCATENATE function or an EXTRACT function are automatically determined based on a selected succession graph, and non-sample data is converted between the different data storage schemas of the first and second data sources, using the CONCATENATE function or the EXTRACT function.
Claims20
A computer-implemented method comprising:
- populating a data record in each of first and second data sources with manually selected, representative sample data, the first and second data sources using different data storage schemas to store the representative sample data as instance values of instance elements;
- selecting an instance value of the data record of the first data source;
- selecting instance elements of the data record of the second data source whose associated instance values form a substring of the selected instance value of the data record of the first data source;
- generating one or more succession graphs using the selected instance elements of the data record of the second data source, according to a succession defined by the selected instance value of the data record of the first data source;
- selecting a succession graph whose combined instance values, when traced from root node to leaf node, matches the selected instance value of the data record of the first data source;
- automatically determining parameters for a CONCATENATE function or an EXTRACT function based on the selected succession graph;
- and
- converting non-sample data between the different data storage schemas of the first and second data sources, using the CONCATENATE function or the EXTRACT function.
A system comprising:
- one or more computers;
- and
- a computer-readable medium coupled to the one or more computers having instructions stored thereon which, when executed by the one or more computers, cause the one or more computers to perform operations comprising:
- populating a data record in each of first and second data sources with manually selected, representative sample data, the first and second data sources using different data storage schemas to store the representative sample data as instance values of instance elements,
- selecting an instance value of the data record of the first data source,
- selecting instance elements of the data record of the second data source whose associated instance values form a substring of the selected instance value of the data record of the first data source,
- generating one or more succession graphs using the selected instance elements of the data record of the second data source, according to a succession defined by the selected instance value of the data record of the first data source,
- selecting a succession graph whose combined instance values, when traced from root node to leaf node, matches the selected instance value of the data record of the first data source,
- automatically determining parameters for a CONCATENATE function or an EXTRACT function based on the selected succession graph, and
- converting non-sample data between the different data storage schemas of the first and second data sources, using the CONCATENATE function or the EXTRACT function.
A computer-readable medium encoded with a computer program comprising instructions that, when executed, operate to cause a computer to perform operations comprising:
- populating a data record in each of first and second data sources with manually selected, representative sample data, the first and second data sources using different data storage schemas to store the representative sample data as instance values of instance elements;
- selecting an instance value of the data record of the first data source;
- selecting instance elements of the data record of the second data source whose associated instance values form a substring of the selected instance value of the data record of the first data source;
- generating one or more succession graphs using the selected instance elements of the data record of the second data source, according to a succession defined by the selected instance value of the data record of the first data source;
- selecting a succession graph whose combined instance values, when traced from root node to leaf node, matches the selected instance value of the data record of the first data source;
- automatically determining parameters for a CONCATENATE function or an EXTRACT function based on the selected succession graph;
- and
- converting non-sample data between the different data storage schemas of the first and second data sources, using the CONCATENATE function or the EXTRACT function.
Dependencies are inferred from the claim text.