Runtime Generation of a Mapping Table for Uploading Data into Structured Data Marts
AssigneeSap SE
InventorsUnmesh Gandhi, Ives Toe, Evelyna Holban, GuoTai Chen, Tim Gast
Life of this patent
Estimating the term…
Abstract
Techniques are described for mapping supplemental data from a data delivery package into data marts that are accessible to a software application. In some embodiments, new mappings can be dynamically generated for a mapping table when the data delivery package includes fields which do not have a corresponding mapping in the mapping table. The new mappings can be generated at runtime while the data delivery package is being processed. Once generated, the mapping table can be used to store the supplemental data into the data marts.
Claims20
A computer-implemented method, comprising:
- receiving, by a processor, a data delivery package that includes a first content file storing incoming data in a plurality of fields and a meta file configured to identify the plurality of fields stored in the first content file;
- and
- processing, by the processor, the data delivery package to store the incoming data in at least one data mart, wherein processing the data delivery package comprises:
- identifying, by the processor, a field from the plurality of fields that is missing from a mapping table configured to map the incoming data to the at least one data mart;
- creating, by the processor, a mapping configured to map the field to a data mart;
- and
- updating, by the processor, the mapping table to include the mapping.
A non-transitory computer readable storage medium storing one or more programs, the one or more programs comprising instructions for:
- receiving a data delivery package that includes a first content file storing incoming data in a plurality of fields and a meta file configured to identify the plurality of fields stored in the first content file;
- and
- processing the data delivery package to store the incoming data in at least one data mart, wherein processing the data delivery package comprises:
- identifying a field from the plurality of fields that is missing from a mapping table configured to map the incoming data to the at least one data mart;
- creating a mapping configured to map the field to a data mart;
- and
- updating the mapping table to include the mapping.
A computer implemented system, comprising:
- one or more computer processors;
- and
- a non-transitory computer-readable storage medium comprising instructions, that when executed, control the one or more computer processors to be configured for:
- receiving a data delivery package that includes a first content file storing incoming data in a plurality of fields and a meta file configured to identify the plurality of fields stored in the first content file;
- and
- processing the data delivery package to store the incoming data in at least one data mart, wherein processing the data delivery package comprises:
- identifying a field from the plurality of fields that is missing from a mapping table configured to map the incoming data to the at least one data mart;
- creating a mapping configured to map the field to a data mart;
- and
- updating the mapping table to include the mapping.
Dependencies are inferred from the claim text.