Method For Dynamically Finding Relations Between Database Tables
A method and system are provided for dynamically relating tables in a federated database based upon a data manipulation language in a query transaction. After the start of a transaction has been detected, a data manipulation language from the transaction is extracted and evaluated to determine the t...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Patent |
| Sprache: | eng |
| Schlagworte: | |
| Online-Zugang: | Volltext bestellen |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| Zusammenfassung: | A method and system are provided for dynamically relating tables in a federated database based upon a data manipulation language in a query transaction. After the start of a transaction has been detected, a data manipulation language from the transaction is extracted and evaluated to determine the table(s) and column(s) referenced by the transaction language. The data relation output unit determines the relationship(s) between the extracted table(s) and column(s) in real-time and conveys this information through a visual display. |
|---|