V
V
VVizard2020-12-11 17:18:06
Database design
VVizard, 2020-12-11 17:18:06

Where can I describe the adjacency list (connections between objects) in order to quickly and interactively get answers to the questions: Who influences? Who is affected?

Actually the task is this, there are many entities (temporary tables) and a large process that creates them in its work.
For example
, "T3" reads data from "T4" and "T6", from "TK" data is read into "T10", "T11", "T12".
"T4" reads data from "T1", is used in "T3", "T8"

Next, you need to get a fairly clear answer to question
1. "Where is "T4" used (what tables does it affect?"
Answer
Directly: "T3", "T8"
Indirectly: "T10", "T11", "T12" (Through "T3").

2. What tables does "T11" consist of (who influences)?
Answer:

I tried Xmind but they are not very suitable for this. Ideally, all objects would be displayed on the screen and when selected, the influencing/dependent, direct/indirect ones would be highlighted.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question