DATABASE RELATIONSHIP DISCOVERY

DATABASE RELATIONSHIP DISCOVERY

A computer implemented method of identifying one or more relationships between columns in a database by determining a subset of a set of all columns of all tables in the database, the columns in the subset satisfying predetermined primary key characteristics, each predetermined characteristic being...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: KERN, Mathias, OWUSU, Gilbert, MCCALL, John, LACROIX, Benjamin, CORSAR, David, OGUNSEMI, Akinola
Format: Patent
Sprache:eng
Schlagworte:
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung:A computer implemented method of identifying one or more relationships between columns in a database by determining a subset of a set of all columns of all tables in the database, the columns in the subset satisfying predetermined primary key characteristics, each predetermined characteristic being defined by a rule for identifying a column as a potential primary key; identifying one or more relationships between columns in the subset and columns in the set of all columns based on each of: primary key and foreign key relationships between columns; and relationships between columns indicated in one or more scripts, each script including instructions for accessing the database.