解密数据库模式 [英] Decipher database schema

问题描述

我最近继承了维护一个设计不好的数据库的工作，设计人员无法提出任何问题。我有一对夫妇在不久的将来我的方式。

I've recently inherited the job of maintaining a database that wasn't designed very well and the designers aren't available to ask any questions. And I have a couple more coming my way in the near future.

尝试找出表之间的关系，没有任何视觉帮助或数据库图是很难的。

It's been tough trying to figure out the relationships between the tables without any kind of visual aid or database diagram.

我想知道为此推荐什么工具。我知道Visio，但我希望有一些很好的开源/免费软件应用程序。我不需要它来改变数据库。只需阅读它，并创建一些视觉帮助，以帮助我了解事情如何布局，并设法想出设计师如何考虑数据如何关联。

I was wondering what tools are recommended for this. I know about Visio, but I was hoping there were some good open source/freeware applications out there. I don't need it to change the database at all. Just read it and create some kind of visual aid to help me understand how things are laid out and try to figure out what the designer was thinking about how the data should relate.

额外的答案数据：SchemaSpy是我正在寻找的东西，但是在命令行中没有做很多事情，我选择使用 SchemaSpyGUI 。还有一些配置要使用，因为我不使用Java很多，但最终的结果是我正在寻找（在开源替代Visio的ER图）。

Additional answer data: SchemaSpy was the kind of thing I was looking for, but having not done a lot with the command line in ages, I opted to use SchemaSpyGUI. There was also some configuration to get used to since I don't work with Java much, but the end result was what I was looking for (on open-source replacement for Visio's ER diagrams).

推荐答案

尝试 SchemaSpy 。我对一个相当复杂的数据库运行它，我非常高兴的结果，有关优化的建议。

Try SchemaSpy. I ran it against a rather complex database and I was quite pleased by the result, with advice on optimization.

这篇关于解密数据库模式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！