Patent ID: 11860910
Assignee: NEC CORPORATION
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 4:
5. A non-transitory computer-readable recording medium storing an information provision program executable by a processor to perform processing comprising:
displaying a plurality of tables within a graphical user interface (GUI);
displaying a GUI element by which a table join method is selected as a Similarity-Join method, a Temporal-Join method, or a Spatial-Join method;
receiving user selection of a first column of a first table and a second column of a second table displayed within the GUI;
receiving user selection of the Similarity-Join method, via the GUI element displayed within the GUI, as the table join method to join the first and second tables;
in response to determining that the first and second columns have a predetermined type and satisfy a first condition, identifying that the first and second columns are in a combinable relationship, and combine the first and second tables using the Similarity-Join method that has been selected, wherein the predetermined type is such that the first and second columns comprise attribute values indicating that the first and second columns correspond to a row of an arbitrary table and indicating that the first and second columns have a property of being a primary key, and wherein the first condition is that a number of combinations of the attribute values for which an edit distance is less than or equal to a threshold value is greater than or equal to a predetermined number;
receiving user selection of a third column of a third table and a fourth column of a fourth table displayed within the GUI;
receiving user selection of the Temporal-Join method, via the GUI element displayed within the GUI, as the table join method to join the third table and fourth tables;
in response to determining that the third and fourth columns have a “Time” type and satisfy a second condition, identifying that the third and fourth columns are in the combinable relationship, and combine the third and fourth tables using the Temporal-Join method that has been selected;
receiving user selection of a fifth column of a fifth table and a sixth column of a sixth table displayed within the GUI;
receiving user selection of the Spatial-Join method, via the GUI element displayed within the GUI, as the table join method to join the fifth and sixth tables;
in response to determining that the fifth and sixth columns have a “Location” type, identifying, by the processor, that the fifth and sixth columns are in the combinable relationship, and combining, by the processor, the fifth and sixth tables using the Spatial-Join method that has been selected; and
outputting a combination table including the first and second tables as have been combined, the third and fourth tables as have been combined, and the fifth and sixth tables as have been combined.