Back to results
US 11,030,224 B2Granted
Data import and reconciliation
AssigneeSap SE
InventorsXing Jin, Sumedha Sharma, Jonathan Tiu, Mohsen Asadi, Sae-Won Om, Anna Chen
Life of this patent
Estimating the term…
Abstract
In one embodiment, the present disclosure pertains to data import and reconciliation. In one embodiment, a location field is compared against alternative geo-descriptors to link the location fields to areaIDs and geospatial shapes. A similarity search is performed against unmatched location fields. In one example embodiment, a table is generated with unique location IDs, areaIDs, and metadata describing the results of the comparison.
Claims20
A method comprising:
- storing a plurality of unique area identifications each associated with a corresponding geospatial shape of geospatial shapes, wherein the plurality of unique area identifications are stored in a first field in one or more tables and the geospatial shapes are stored in a second field in the one or more tables;
- storing a plurality of master geo-descriptors each associated with one of the unique area identifications, wherein the plurality of master geo-descriptors are stored in a third field in the one or more tables and the unique area identifications are stored in a fourth field in the one or more tables;
- storing a plurality of alternative geo-descriptors in association with the unique area identifications, wherein each unique area identification is associated with a plurality of the alternative geo-descriptors, the plurality of alternative geo-descriptors are alternate representations of each of the master geo-descriptors, the plurality of alternative geo-descriptors and the master geo-descriptors are stored in a fifth field in the one or more tables, and the unique area identifications are stored in a sixth field in the one or more tables;
- receiving a data set comprising at least one location field to be mapped to the unique area identifications;
- joining the one or more tables;
- and
- comparing data elements in the at least one location field to the plurality of alternative geo-descriptors, wherein
- when particular data elements match one of the plurality of alternative geo-descriptors, determining the unique area identification associated with the matched one of the plurality of alternative geo-descriptors and associating the unique area identification with the matching data elements;
- and
- when a particular data element does not match any of the plurality of alternative geo-descriptors:
- performing a similarity search of the particular data element against the plurality alternative geo-descriptors to return a result set comprising one or more of the plurality alternative geo-descriptors having a likelihood greater than a threshold;
- presenting the result set to a user for selection;
- and
- determining the unique area identification associated with the user selected result.
11 more elements
A non-transitory machine-readable medium storing a program executable by at least one processing unit of a device, the program comprising sets of instructions for:
- storing a plurality of unique area identifications each associated with a corresponding geospatial shape of geospatial shapes, wherein the plurality of unique area identifications are stored in a first field in one or more tables and the geospatial shapes are stored in a second field in the one or more tables;
- storing a plurality of master geo-descriptors each associated with one of the unique area identifications, wherein the plurality of master geo-descriptors are stored in a third field in the one or more tables and the unique area identifications are stored in a fourth field in the one or more tables;
- storing a plurality of alternative geo-descriptors in association with the unique area identifications, wherein each unique area identification is associated with a plurality of the alternative geo-descriptors, the plurality of alternative geo-descriptors are alternate representations of each of the master geo-descriptors, the plurality of alternative geo-descriptors and the master geo-descriptors are stored in a fifth field in the one or more tables, and the unique area identifications are stored in a sixth field in the one or more tables;
- receiving a data set comprising at least one location field to be mapped to the unique area identifications;
- joining the one or more tables;
- and
- comparing data elements in the at least one location field to the plurality of alternative geo-descriptors, wherein
- when particular data elements match one of the plurality of alternative geo-descriptors, determining the unique area identification associated with the matched one of the plurality of alternative geo-descriptors and associating the unique area identification with the matching data elements;
- and
- when a particular data element does not match any of the plurality of alternative geo-descriptors:
- performing a similarity search of the particular data element against the plurality alternative geo-descriptors to return a result set comprising one or more of the plurality alternative geo-descriptors having a likelihood greater than a threshold;
- presenting the result set to a user for selection;
- and
- determining the unique area identification associated with the user selected result.
11 more elements
A computer system comprising:
- a processor;
- a memory;
- and
- computer program code comprising instructions, executable on said one or more processors, the computer program code configured to:
- store a plurality of unique area identifications each associated with a corresponding geospatial shape of geospatial shapes, wherein the plurality of unique area identifications are stored in a first field in one or more tables and the geospatial shapes are stored in a second field in the one or more tables;
- store a plurality of master geo-descriptors each associated with one of the unique area identifications, wherein the plurality of master geo-descriptors are stored in a third field in the one or more tables and the unique area identifications are stored in a fourth field in the one or more tables;
- store a plurality of alternative geo-descriptors in association with the unique area identifications, wherein each unique area identification is associated with a plurality of the alternative geo-descriptors, the plurality of alternative geo-descriptors are alternate representations of each of the master geo-descriptors, the plurality of alternative geo-descriptors and the master geo-descriptors are stored in a fifth field in the one or more tables, and the unique area identifications are stored in a sixth field in the one or more tables;
- receive a data set comprising at least one location field to be mapped to the unique area identifications;
- joining the one or more tables;
- and
- compare data elements in the at least one location field to the plurality of alternative geo-descriptors, wherein
- when particular data elements match one of the plurality of alternative geo-descriptors, determine the unique area identification associated with the matched one of the plurality of alternative geo-descriptors and associate the unique area identification with the matching data elements;
- and
- when a particular data element does not match any of the plurality of alternative geo-descriptors:
- perform a similarity search of the particular data element against the plurality alternative geo-descriptors to return a result set comprising one or more of the plurality alternative geo-descriptors having a likelihood greater than a threshold;
- present the result set to a user for selection;
- and
- determine the unique area identification associated with the user selected result.
15 more elements
Dependencies are inferred from the claim text.