Determining a database signature
AssigneeInternational Business Machines Corporation
InventorsTomasz Hanusiak, Grzegorz Szczepanik, Jaroslaw Osinski, Konrad Wojciech Komnata
Life of this patent
Estimating the term…
Abstract
A method, a computer program product, and a data processing system for determining a database signature of a database includes determining a set of characteristics of the database; identifying at least one unique characteristic of the database that is unique among characteristics of other databases, which characteristics of other databases are stored in a signature data store; generating the database signature from the at least one unique characteristic; and storing the database signature and the unique characteristic in the signature data store.
Claims15
A method for determining a database signature of a database, the method comprising:
- determining a first set of characteristics of the database;
- identifying at least one unique characteristic of the first set of characteristics compared to a second set of characteristics of one or more other databases, wherein the second set of characteristics of the one or more other databases are stored in a signature data store, wherein the identifying the at least one unique characteristic includes:
- assigning a confidence value to a particular characteristic that matches a possible unique characteristic of the database;
- searching in the signature data store for the particular characteristic that matches the possible unique characteristic, and
- reducing the confidence value of the database signature when the particular characteristic is found for at least a second database;
- generating the database signature based on the at least one unique characteristic, wherein the at least one unique characteristic is unique among corresponding characteristics of the one or more other databases, the generating the database signature comprising:
- mapping a database identity of the database to associated structural information about the database, the associated structural information including the at least one unique characteristic;
- and
- storing the database signature and the at least one unique characteristic to the signature data store.
A computer program product for determining a database signature of a database, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a computer to cause the computer to perform a method, the method comprising:
- determining a first set of characteristics of the database;
- identifying at least one characteristic of the first set of characteristics that is unique compared to a second set of characteristics of one or more other databases, wherein the second set of characteristics of the one or more other databases are stored in a signature data store, wherein the identifying the at least one unique characteristic includes:
- assigning a confidence value to a particular characteristic that matches a possible unique characteristic of the database,
- searching in the signature data store for the particular characteristic that matches the possible unique characteristic, and
- reducing the confidence value of the database signature when the particular characteristic is found for at least a second database;
- generating the database signature from the at least one unique characteristic, wherein the at least one unique characteristic is unique among corresponding characteristics of the one or more other databases, the generating the database signature comprising:
- mapping a database identity of the database to associated structural information about the database, the associated structural information including the at least one unique characteristic;
- and
- storing the database signature and the at least one unique characteristic in the signature data store.
A data processing system for execution of a data processing program, the data processing system having one or more computer processors and a memory, the data processing system configured to:
- determine a first set of characteristics of the database;
- identify at least one characteristic of the first set of characteristics that is unique compared to a second set of characteristics of one or more other databases, wherein the second set of characteristics of the one or more other databases are stored in a signature data store, wherein the identifying the at least one unique characteristic includes:
- assigning a confidence value to a particular characteristic that matches a possible unique characteristic of the database,
- searching in the signature data store for the particular characteristic that matches the possible unique characteristic, and
- reducing the confidence value of the database signature when the particular characteristic is found for at least a second database;
- generate a database signature from the at least one unique characteristic, wherein the at least one unique characteristic is unique among corresponding characteristics of the one or more other databases, the generating the database signature comprising:
- mapping a database identity of the database to associated structural information about the database, the associated structural information including the at least one unique characteristic;
- and
- store the database signature and the at least one unique characteristic in the signature data store.
Dependencies are inferred from the claim text.