All geek questions in one place

600 tables in DDBB

I am a very young software architect. Now I work a lot, and I have to lead the development team to rewrite the entire mortgage system of the bank.

I look at database tables and I understand that there is no data model or documentation. Worst of all, there are about 1000 tables and about 600 in production among the developers. I trust the production environment more, but anyway, what can I do? I mean, can I suicide me or something like that, but is there a good tool for reverse engineering, so at least I could get a schema definition with the relationships between tables and comments extracted from fields? Can you advise me something?

Thanks in advance.

+3
source share
4 answers

If you are lucky and the database uses primary and foreign keys, you can get excellent documentation with SchemaSpy , a nice command written in Java.

Update: I just remembered that Oracle SQL Developer has a similar tool (create a connection, right click on its icon and select “Generate DB Doc”), although it does not draw graphs.

+1
source

Unfortunately, this is an oracle. There is a pretty good tool for mysql called Mysql Workbench .

0
source

TOAD - , , IIRC , , , , . , , .

0

:

select * from dba_tab_comments 
 where owner not in ('SYS', 'SYSTEM')


select * from dba_col_comments 
 where owner not in ('SYS', 'SYSTEM')

: ERD 600 , () . "" , .

Obviously, you want to make sure that the whole circuit has foreign keys. You can see

select * from dba_constraints 
 where constraint_type = 'R' and 
       owner not in ('SYS', 'SYSTEM')

to see if all foreign keys.

0
source

Source: https://habr.com/ru/post/1783602/

More articles:


All Articles