type
status
date
slug
summary
tags
category
icon
password
PowerDesigner
PowerDesigner是一款能进行数据库设计的软件,是一款开发人员常用的数据库建模工具。使用它可以分别从概念数据模型和物理数据模型两个层次对数据库进行设计。概念数据模型描述的是独立于数据库管理系统的实体定义和实体关系定义;物理数据模型是在概念数据模型的基础上对目标数据库管理系统的具体化。而且PowerDesigner还可以和NET、Eclipse等主流平台进行关联,从而优化整个项目的设计方案,达到大大缩短开发时间的效果。
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2Fea8aed95-d546-4d29-a64a-08e945c3611b%2FUntitled.png?table=block&id=5c703295-6a2a-4a96-b190-199453c58808&t=5c703295-6a2a-4a96-b190-199453c58808&width=656.6640625&cache=v2)
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2F6fb80b24-4357-4516-8df4-5c9f94e6e967%2FUntitled.png?table=block&id=acbaf081-9f25-419b-ab39-5a21a47c74c3&t=acbaf081-9f25-419b-ab39-5a21a47c74c3&width=1500&cache=v2)
看官方的简介和示意图,那是非常的简洁酷炫,果然,付费产品就是香。
于是乎,果断选择放弃,去GitHub上寻找,有不有开源的,与之相类似的产品。
于是在gitee上发现了这款国人开源的数据库设计工具PDManer。
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2Fb002e161-f45b-467b-a6d7-aeb90891f1f1%2FUntitled.png?table=block&id=1db5d202-16b6-4551-a1ac-835306048f42&t=1db5d202-16b6-4551-a1ac-835306048f42&width=656.6640625&cache=v2)
PDManer
PDManer元数建模,是一款多操作系统开源免费的桌面版关系数据库模型建模工具,相对于PowerDesigner,他具备界面简洁美观,操作简单,上手容易等特点。支持Windows,Mac,Linux等操作系统,也能够支持国产操作系统,能够支持的数据库如下:
- MySQL,PostgreSQL,Oracle,SQLServer等常见数据库
- 支持达梦,GuassDB等国产数据库
- 支持Hive,MaxCompute等大数据方向的数据库
- 用户还可以自行添加更多的数据库扩展
本产品基于 ES6+React+Electron+Java构建
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2F9902482c-a876-4369-af2e-37985a666071%2FUntitled.png?table=block&id=ec3b23b7-93d9-41c7-bfca-e990f64ddc05&t=ec3b23b7-93d9-41c7-bfca-e990f64ddc05&width=1500&cache=v2)
PDManer经过了多个版本的迭代和升级,还曾进行了更名等。
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2F631263c8-0114-4cf1-ae7e-7bfa9f89313a%2FUntitled.png?table=block&id=74dcc279-8923-4ad9-9fde-6e7495f71811&t=74dcc279-8923-4ad9-9fde-6e7495f71811&width=449&cache=v2)
PDManer的使用
从官网下载压缩包,进行解压,得到下列文件。
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2Fd7d282ba-d7dd-4349-b393-8bfd7889bc40%2FUntitled.png?table=block&id=786f3989-5fbd-4822-a016-7d1be68d467b&t=786f3989-5fbd-4822-a016-7d1be68d467b&width=1225&cache=v2)
双击.exe文件,即可直接运行,进入主界面。
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2F8a4fc12d-ed06-4acd-9fb6-da70febf892a%2FUntitled.png?table=block&id=26e769d3-08c3-43f9-8777-605c327f2f10&t=26e769d3-08c3-43f9-8777-605c327f2f10&width=82&cache=v2)
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2Fa046211d-aec5-4539-88f2-f557e26f28aa%2FUntitled.png?table=block&id=cb6bb890-8d22-4fbf-8225-1fc3d89f1ea1&t=cb6bb890-8d22-4fbf-8225-1fc3d89f1ea1&width=656.6640625&cache=v2)
创建项目
创建新项目文件。
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2F9bcfb2b4-3ebf-42cd-bd85-3425835a4f97%2FUntitled.png?table=block&id=3a2a9759-2623-402b-b067-529f5c9f5b62&t=3a2a9759-2623-402b-b067-529f5c9f5b62&width=1055&cache=v2)
可以选择从不同的数据模型文件或者数据库中导入文件。
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2F526d61cb-9332-4e23-96e8-6f384240540f%2FUntitled.png?table=block&id=ce10ad65-d5e0-4b3f-a54a-60c2e93001a4&t=ce10ad65-d5e0-4b3f-a54a-60c2e93001a4&width=1500&cache=v2)
选择导入文件后,选择需要添加的数据表。
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2F0b047003-9663-44c6-8a75-0c9b06df0779%2FUntitled.png?table=block&id=4eb7abc0-cbc5-4f4f-909c-b46e47780227&t=4eb7abc0-cbc5-4f4f-909c-b46e47780227&width=1500&cache=v2)
导入完成后,就可以点开单表进行查看了。
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2F5dd0c968-ae1f-4c20-a9f7-30ce2f162072%2FUntitled.png?table=block&id=5ea42a87-48f2-4a18-b0bb-b70b1200b689&t=5ea42a87-48f2-4a18-b0bb-b70b1200b689&width=1500&cache=v2)
也可选择连接数据库,来进行导入。
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2F70713203-33cb-42a7-8b12-37f15cc78e68%2FUntitled.png?table=block&id=b551ae1d-ed5d-477e-aa8e-5bd5b2fb8e0e&t=b551ae1d-ed5d-477e-aa8e-5bd5b2fb8e0e&width=1500&cache=v2)
连接成功后 ,可以选择直接从数据库中导入导出。
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2F196c8816-9644-449a-9650-8a24c71988de%2FUntitled.png?table=block&id=c94fe931-f0f4-43a0-8b89-18dd4627a451&t=c94fe931-f0f4-43a0-8b89-18dd4627a451&width=1500&cache=v2)
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2Fe69142be-ce56-4483-9109-b071ba384d59%2FUntitled.png?table=block&id=d4e432b6-f8ab-49b1-a358-301e1cd9d212&t=d4e432b6-f8ab-49b1-a358-301e1cd9d212&width=2679&cache=v2)
数据库连接逆向解析,也可得到相应的数据表。
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2F1728ab2d-e002-493a-941b-68c6895e7d64%2FUntitled.png?table=block&id=3989be58-1095-4da8-bf49-ee61764ed25d&t=3989be58-1095-4da8-bf49-ee61764ed25d&width=1500&cache=v2)
数据表管理
右击“数据表”弹出快捷菜单,在这里可以对表进行增删修改。
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2F2b2c2c64-dbf0-4b30-a301-c2f29d2ad365%2FUntitled.png?table=block&id=66e5dae6-a34f-41ef-989f-e781e43e8fe2&t=66e5dae6-a34f-41ef-989f-e781e43e8fe2&width=656.6640625&cache=v2)
填写表的基础信息,确定后即可。
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2F887974f9-d1b5-47b1-9098-9b62e436c119%2FUntitled.png?table=block&id=9c7e5c25-bd19-45d3-9c72-520937a8c530&t=9c7e5c25-bd19-45d3-9c72-520937a8c530&width=1500&cache=v2)
对数据表中的字段进行操作,可以增删修改等。
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2F0ba5ee1e-4897-4507-b686-5b7d9bf0f076%2FUntitled.png?table=block&id=96e7ca18-35ea-47a3-bfb5-715fc8a782ff&t=96e7ca18-35ea-47a3-bfb5-715fc8a782ff&width=656.6640625&cache=v2)
如果对于该字段的大写命名不太习惯,可以直接选中一列,然后选择大小写转换,这样,字段就变成了小写了。
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2F6b90d4dc-081d-4683-b944-0cdfbf3e4dd9%2FUntitled.png?table=block&id=20f3184b-0993-4446-b79d-373e65f7f5a9&t=20f3184b-0993-4446-b79d-373e65f7f5a9&width=1500&cache=v2)
小tips:
- 单击行号选中当前行
- 按住Ctrl+单击行号,选中跳跃行
- 按住Shift+单击行号,选中连续行
- 选中行后,Ctrl+C复制,Ctrl+V粘贴
- 单元格内部使用Ctrl+Shift+U转换大小写
- 选择多行,能够批量调整数据域
对数据表完成设计后,就可以选择导出数据表结构DDL了
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2F4f2b1e51-982a-45c8-a855-16187fc030dd%2FUntitled.png?table=block&id=0b8ad5df-377d-4911-ab4b-77b269878583&t=0b8ad5df-377d-4911-ab4b-77b269878583&width=1500&cache=v2)
也可以选择导出其他格式的。比如word、html、excel等
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2F5dc96563-43cc-4f50-b977-8e626fbd67f6%2FUntitled.png?table=block&id=3eaec2be-c4f0-487a-9701-0dce38076f37&t=3eaec2be-c4f0-487a-9701-0dce38076f37&width=2409&cache=v2)
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2F05369923-c944-4bc4-9cac-3e9e011bc119%2FUntitled.png?table=block&id=3acfc78f-6fc6-413a-9878-daf5f594a22f&t=3acfc78f-6fc6-413a-9878-daf5f594a22f&width=1204&cache=v2)
维护关系图
右键关系图,可以对关系图进行操作。
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2Fecc26fab-f237-432b-b506-72d407015522%2FUntitled.png?table=block&id=8bf2d9aa-7dc4-46e9-98bc-85d08b1f3a62&t=8bf2d9aa-7dc4-46e9-98bc-85d08b1f3a62&width=623&cache=v2)
把需要关联的表拖拽到右侧的面板当中,然后按照字段进行连线,非常方便。
![notion image](https://www.notion.so/image/https%3A%2F%2Fprod-files-secure.s3.us-west-2.amazonaws.com%2F87cd7b33-b48f-404a-8322-8403322877a9%2Fd7954e82-82f3-4bd6-9f04-b700442b8033%2FUntitled.png?table=block&id=e856cff8-2768-4c49-9854-89ac87518acd&t=e856cff8-2768-4c49-9854-89ac87518acd&width=1500&cache=v2)
更多详细的操作,可以去官方网站和官方文档学习。
有关软件安装或者使用上的问题,欢迎您在底部评论区留言,一起交流~
- 作者:Nolan
- 链接:https://nolanblog.top/article/env4
- 声明:本文采用 CC BY-NC-SA 4.0 许可协议,转载请注明出处。