US 12,743,441 B1Granted

Detection of links among tabular data

AssigneeDatasetLinks Inc.

InventorsFrancisco Ferreira, Andrzej Grzesik, Juan Garcia, Tomasz Wylezek, Dominik Wiernicki, Rui Lopes

Life of this patent

Estimating the term…

Loading patent…

Abstract

Detection of links among tabular data is disclosed, including: obtaining a set of source data; extract portions from the set of source data to store in cells within a source dataset according to a source schema determined for the set of source data; determining a link between a first data value stored in a first cell of the source dataset to a second data value stored in a second cell of a destination dataset of stored tabular data; and in response to a search that matches the first data value stored in the first cell, returning the first data value stored in the first cell and the second data value stored in the second cell based at least in part on the link.

Claims18

Dependent claims

A system, comprising:

a storage device configured to store tabular data comprising a plurality of tables;
and
one or more processors configured to:
obtain a set of source data;
extract portions from the set of source data to store in cells within a source dataset according to a source schema determined for the set of source data, wherein the source dataset comprises a source table;
determine a link between a first data value stored in a first cell of the source dataset to a second data value stored in a second cell of a destination dataset of stored tabular data, wherein the destination dataset comprises a destination table, wherein the first cell is included in a first row of the source dataset, wherein the first data value comprises a first set of global positioning data (GPS) data, wherein the second cell is included in a second row of the destination dataset, wherein the second data value comprises a second set of GPS data, wherein to determine the link between the first data value stored in the first cell of the source dataset to the second data value stored in the second cell of the destination dataset of the stored tabular data comprises to:
compare the first set of GPS data to the second set of GPS data to determine a proximity;
and
in response to a determination that the proximity is less than a threshold, determine that the link is detected between the first row of the source dataset and the second row of the destination dataset, wherein the link comprises a geographical match type of link;
store data associated with the link in a link index, wherein the data associated with the link describes the first cell of the source dataset and the second cell of the destination dataset;
obtain a tabular data-specific query language query;
search at least the source dataset using the tabular data-specific query language query;
and
in response to a determination that the tabular data-specific query language query matches the first data value stored in the first cell of the source dataset, return the first data value stored in the first cell of the source dataset and the second data value stored in the second cell of the destination dataset based at least in part on the link stored in the link index.

11 more elements

A method, comprising:

obtaining a set of source data;
extracting portions from the set of source data to store in cells within a source dataset according to a source schema determined for the set of source data, wherein the source dataset comprises a source table;
determining a link between a first data value stored in a first cell of the source dataset to a second data value stored in a second cell of a destination dataset of stored tabular data, wherein the destination dataset comprises a destination table, wherein the first cell is included in a first row of the source dataset, wherein the first data value comprises a first set of global positioning data (GPS) data, wherein the second cell is included in a second row of the destination dataset, wherein the second data value comprises a second set of GPS data, wherein determining the link between the first data value stored in the first cell of the source dataset to the second data value stored in the second cell of the destination dataset of the stored tabular data comprises:
comparing the first set of GPS data to the second set of GPS data to determine a proximity;
and
in response to a determination that the proximity is less than a threshold, determining that the link is detected between the first row of the source dataset and the second row of the destination dataset, wherein the link comprises a geographical match type of link;
storing data associated with the link in a link index, wherein the data associated with the link describes the first cell of the source dataset and the second cell of the destination dataset;
obtaining a tabular data-specific query language query;
searching at least the source dataset using the tabular data-specific query language query;
and
in response to a determination that the tabular data-specific query language query matches the first data value stored in the first cell of the source dataset, returning the first data value stored in the first cell of the source dataset and the second data value stored in the second cell of the destination dataset based at least in part on the link stored in the link index.

8 more elements

Dependencies are inferred from the claim text.