Skip to Content
0
Aug 22, 2023 at 07:45 AM

Columns with different name in different tables, but containing the same information

103 Views Last edit Aug 22, 2023 at 11:11 AM 3 rev

Hi there!

I am not an expert of MAXDB databases, but I am trying to figure out the structure of a huge one, with hundreds of tables.

I have noticed (with some difficulty) that, in many cases, the tables are "sharing" columns which are named differently. For instance: in the table named "MISSIONS", the column "MISSIONS.TASKNUM" coincides with the information stored in the table "RESULTS", under the column "RESULTS.TASK_NUMBER". The two tables are updated consistently, but the relationship does NOT appear neither in the FOREIGNKEYS nor in the CROSSREFERENCES tables.

This is possibly something happening outside MAXDB, by means of the JDBC handlers. But I wonder if there is a rational, automatic way to reconstruct such mutual relationship among the tables, where "relationship among tables" means that they share a column containing the same information. I say "automatic" because there are hundreds of tables, with thousands of columns and a manual inspection is out of human reach.

Thanks for your answers!

Andrea