I have a legacy system I need to plan a migration for. It’s mainly developed in Ingres+4GL (an old Ingres based form system).

I have the following information:

• Data Structures (data base relations and their relationships)
• All programs accessing the underlying Ingres Data Structure

I coded a parser for Ingres and 4GL programs using ANTLR4 and using that I also extracted the following information:

• What program access which data structures (tables)
• What program run which stored procedure
• What stored procedure access with data structures (tables)
• What tables are accessed together (from the same programs)
• What tables have READ and/or WRITE access from which programs

My question is:

What can I use to graphically represent all these relationships? Is there a Software/Standard that may help me on this?

I was thinking of running a clustering algorithm on the gathered data to see if there are any clusters that might be migrated together?

Thanks a lot.