I doubt you can really develop a program that can do this ... it really depends on what you're building. Normalization does not determine "good" design.
It'll help you find some issues with your design, but it's not a magic bullet either. Other than TOAD I haven't seen any other tool that comes close to being useful as opposed to manual auditing of the schema. Any other ideas?
发布评论
评论（2）
我怀疑你真的可以开发一个可以做到这一点的程序......这实际上取决于你正在构建的内容。规范化并不能决定“好的”设计。
I doubt you can really develop a program that can do this ... it really depends on what you're building. Normalization does not determine "good" design.
TOAD 是最流行的工具（抱歉，不是 OSS）。
http://www.quest.com/toad-for-oracle/
它'它将帮助您发现设计中的一些问题，但这也不是灵丹妙药。除了 TOAD 之外，我还没有看到任何其他工具比手动审核模式更有用。还有其他想法吗？
TOAD is the most popular tool for this (sorry, not OSS).
http://www.quest.com/toad-for-oracle/
It'll help you find some issues with your design, but it's not a magic bullet either. Other than TOAD I haven't seen any other tool that comes close to being useful as opposed to manual auditing of the schema. Any other ideas?