Patent · US Active

Detecting multi-column composite key column sets

US9104784B2 · kind B2 · utility

2Cited by

16References

20Claims

0Family size

Assignee

International Business Machines Corporation · US

Inventors

Sebastian Nelke · Schenefeld, DE
Martin Oberhofer · Nagold, DE
Yannick Saillet · Stuttgart, DE
Jens Seifert · Schrobenhausen, DE

Key dates

Filing date	Jul 22, 2013
Grant date	Aug 11, 2015
Priority date	—
Expiry date	Jan 7, 2034

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/2272
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

An aspect includes a computer-implemented method for detecting one or more multi-column composite key column sets. The method includes accessing a plurality of first columns, each first column representing a parameter, each first column including a set of distinct parameter values of its respective parameter, each distinct parameter value being stored in association with one or more object identifiers. Two or more of the first columns are selected for use as a current candidate column set, the current candidate column set including at least a first and a second candidate column, the current candidate column set being of a current cardinality. The method also includes determining, by comparing object-identifiers, whether for the current candidate column set at least one tuple of parameter values exists with parameter values respectively stored in association with two or more shared ones of the object identifiers to identify a multi-column composite key column set.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.