模型数据库条目的图表
您知道显示数据库条目的图表吗?我猜想类似于 UML 中的对象图。我知道有实体关系模型,但它不显示数据库的现有条目。
Do you know a diagram to show the entries of an database? I guess something like the object diagram in UML. I know there is the entity-relationship model but it does not show the existing entries of the database.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
我想在图表中显示数据库条目是很少见的,因为它们通常太多了。
实际上,它可以是特定于业务的图表,您可以将任何基于数据库的应用程序视为此类“图表”的一种形式,以用户舒适的方式显示数据库条目。
构成此类图的另一种方法是使用 ER 图的某种变体,但显示数据而不是模式,如 这篇维基百科文章。
I guess it's pretty much uncommon to show database entries in a diagram, because there are usually way too many of them.
And actually, it can be a business-specific diagram, you can think of any DB-based application as a form of such "diagram", showing database entries in a way comfortable to the user.
Another way of making up such diagram is to use some variation of the E-R diagram, but show the data instead of the schema, like in this wikipedia article.
Yacoder 提到了 ER 图。这是一个很好的起点。 ER 图比 UML 图更简单。我见过有超过一百个方框的 ER 图,方框之间的线也多得多。这张纸覆盖了整面墙。
如果您认为这太复杂了,理解一百个表仍然比理解十万行代码更容易。
Yacoder mentioned ER diagrams. That's a good place to start. ER diagrams are simpler than UML diagrams. I've seen ER diagrams with well over a hundred boxes, and way more lines between boxes. The paper covers an entire wall.
In case you think this is way too complicated, it still easier to understand a hundred tables than a hundred thousand lines of code.