Is there a standard file format for Physical Data Models Representations?

Question

Is there a standard file format for Physical Data Models Representations? And with that I mean files from where i can see graphically the relations between the data tables.

For example in my work we use 'Toad Data Modeler' to create physical data models from existing data bases. These files are XML with 'txp' extension. Because I can't use Toad anywhere (license cost $) I look how to export the model to other formats but the only option that it has is image, and that is problematic because I cannot search text in and image, and for big databases is impossible to find something fast.

If that file format doesn't exist, is there at least some kind of defacto standard that can be interpreted from multiples software?

If you can find a script to convert sql to a dot file, then graphviz would be great. This python tool looks promising to me: http://www.sqlalchemy.org/trac/wiki/UsageRecipes/SchemaDisplay — Brian Maltzan, Apr 23 '12 at 18:53

score 3 · Accepted Answer · edited May 23 '17 at 11:55

3

There is no such standard, unfortunatelly, for Entity Relationship Model.

There is some work to create a standard for UML with XMI.

By the way if your problem is that Toad Data Modeler is proprietary you can use the freeware version. Maybe it'll be enough to fit your needs.

edited May 23 '17 at 11:55

Community

1
1

answered Apr 23 '12 at 09:21

alain.janinm

19,951
10
65
112

score 1 · Answer 2 · answered Apr 23 '12 at 12:35

As far as I know, there is no standard for graphical representation of database models (as alain janinm writes). That's probably ok - it's too detailed a thing for the standards bodies to be concerned with.

There is, of course, a standard for defining database models: SQL DDL does a pretty decent job. So, one thing you could do is export the DDL from TOAD, and import that into another tool.

You'd lose a lot of information - annotations, layout-decisions, etc - and you would definitely not have "round trip" capabilities (where you modify the design in some other tool, and re-import it back into TOAD).

I think you're subject to market forces here - if you want to use the features of TOAD, you have to use TOAD; either free or paid for.

Is there a standard file format for Physical Data Models Representations?

2 Answers2