1. Download powerDesigner
The link address is http://soft.onlinedown.net/soft/577763.htm
2. Open the software, file -> new project, create a new project; then create a new entity to bui
Category: Power Designer
PowerDesigner was originally developed by Xiao-Yun Wang in SDP Technologies. PowerDesigner is Sybase’s enterprise modeling and design solution. It uses a model-driven approach to combine business and IT. It can help deploy an effective enterprise architecture and provide powerful analysis and design techniques for R&D lifecycle management. PowerDesigner uniquely integrates a variety of standard data modeling technologies (UML, business process modeling, and market-leading data modeling), and integrates with mainstream development platforms such as .NET, WorkSpace, PowerBuilder, Java™, and Eclipse, thereby Provide business analysis and standardized database design solutions for traditional software development cycle management. In addition, it supports more than 60 relational database management systems (RDBMS)/versions. PowerDesigner runs on the Microsoft Windows platform and provides an Eclipse plug-in.
PowerDesigner connects Mysql, establishing a reverse engineering diagram – Mysql’s ODBC establishment
anywhere else Solved, there was a problem in the last step, and an exception was prompted:
In the legend, programmers like to use powerDesign for database modeling. Usually, the physical mode
PowerDesigner (5) – Concept Data Model (CDM Generate LDM, PDM and OOM)
The original text is from: http://www.voidcn.com/article/p-avzfndrz-oy.html
Conceptual Data Model (CDM): expresses the overall logical structure of data, which is independent of any software
Name and Comment interchange in PowerDesigner
Reproduced from: http://blog.csdn.net/xuxile/article/details/49817385
Execution method: Open PDM – Tools – Execute Commands – Run Script
Vb script code:
Add a code display in the table display in PowerDesigner
1.”Tools”->”Display Preferences…”
2. Select “Table” and click “Advanced”
3. Select “Columns”, Click the search icon to the right of “List columns”
4. Select “Code”, move it to the top, and click “OK”. Don’t forget to click “OK” on the other parent pages.
PowerDesigner appears in the process of generating a script appears on a Constraint Name Uniqueness Reference solution
An error occurred as shown below:
The reason for the problem: the constraint name was repeated during the script generation process
Solution:
1. Double-click error
2. Select Integrity
4. Modify the constraint name in Constraint name Save the name and confirm
PowerDesigner15 Connect Oracle Database and Export Oracle’s Table Structure Steps
Reference: http://wenku.baidu.com/view/ 4f819a24af45b307e87197ea.html
PowerDesigner (6) – Physical Data Model (PDM Reverse Engineering)
The original text is from: http://www.voidcn.com/article/p-vudrzoeb-oy.html
Physical Data Model (PDM): After the logical structure of the database is designed, its physical design needs to be
PowerDesigner use method summary
PowerDesigner is mostly used for database model design and has functions such as automatic generation of SQL statements. Of course, there are also many shortcomings, such as team sharing.
1.
Automatically generates annotations when PowerDesigner exports SQL
Reproduced:
powerdesigner16 is also applicable
Create a new Physical Data Model in powerBuilder, and create a new user table in it. The information is as shown in the figure below:
<