SQL SQL中的反向工程和正向工程有什么区别
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/32318183/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
What is the difference between reverse and forward engineering in SQL
提问by Sharan Duggirala
I am currently learning to use SQL and I am confused about the fundamentals of the difference between these two. I am currently using the MYSQL Workbench.
我目前正在学习使用 SQL，我对这两者之间差异的基本原理感到困惑。我目前正在使用 MYSQL 工作台。
Thank you for your answers!
谢谢您的回答！
回答by Stavr00
Forward EngineeringGoing from a logical data model to a physical data model. This is easy because the design includes all dependencies, indexes and relationships between the components of the data model.
正向工程从逻辑数据模型到物理数据模型。这很容易，因为设计包括数据模型组件之间的所有依赖项、索引和关系。
Reverse EngineeringAttempting to reconstruct the logical data model from a physical data model. This is hard because not every database engine has the means to store the interdependencies between objects in a logical model, and sometimes these relationships are lost altogether. This information has to be somehow recovered by analyzing the data and inferring the missing relationships.
逆向工程试图从物理数据模型重建逻辑数据模型。这很困难，因为并非每个数据库引擎都有办法将对象之间的相互依赖性存储在逻辑模型中，有时这些关系会完全丢失。必须通过分析数据并推断缺失的关系以某种方式恢复这些信息。
Compare this to compiling source code VS decompiling binary code.
将此与编译源代码 VS 反编译二进制代码进行比较。
回答by Kyle Willoughby
Forward engineering in SQL is using a script or database model to create or alter a new database: https://dev.mysql.com/doc/workbench/en/wb-forward-engineering.htmlReverse engineering in SQL is creating a script or model based on an existing database: https://dev.mysql.com/doc/workbench/en/wb-reverse-engineering.html
SQL 中的正向工程是使用脚本或数据库模型来创建或更改新数据库：https: //dev.mysql.com/doc/workbench/en/wb-forward-engineering.htmlSQL 中的反向工程正在创建脚本或基于现有数据库的模型：https: //dev.mysql.com/doc/workbench/en/wb-reverse-engineering.html
