数据库模式归一化检查器？ [英] Database schema normalization checker?

问题描述

我有兴趣学习如下所示的工具：

I'm interested in learning about tools that operate like this:

给定一个数据库模式和一些数据，建议该模式是否可能在任何特定的正常

Given a database schema and some data, suggest whether the schema is likely structured in any particular normal form, and then tell how the schema might be factored to produce further normalization.

基本上是一个用于数据库模式设计的静态分析工具。

Basically, a static analysis tool for database schema design.

与其他静态分析工具一样，这样的数据库工具不需要生成完美的结果（我怀疑这样的完美工具在计算上是可行的），或适用于所有数据库系统，或自由/开源，还要别的吗。该工具不需要是独立的;它可以捆绑作为一些复杂的IDE功能。

Like other static analysis tools, such a database tool need not generate perfect results (I doubt such a "perfect" tool is computationally feasible), or applicable to all database systems, or free/open source, or anything else. The tool need not be stand-alone; it could be bundled as some sophisticated IDE feature. I'm just wondering what's out there.

推荐答案

这可以做到，并且至少有两个可用的工具做归一化为你：GeneXus和DeKlarit。
他们使用名为 NormalizationBySynthesis 的过程

It can be done, and there are at least 2 commecially available tools that can do normalization for you: GeneXus and DeKlarit. They use a process named NormalizationBySynthesis

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