1. Personnel organization structure
2, conceptual model
New conceptual model
< /p> 650) this.width=650;” src=”/wp-content/uploadshttp:/img.voidcn.com/vcimg/static/loading.png “tit
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 common skill
PowerDesigner is a very powerful database design software. Skilled use of PowerDesigner can make database design efficient and concise. The specific operations of PowerDesign are described in detai
Generate a table structure to the Word document using PowerDesigner
Sometimes, when writing various system-related documents, you need to add the structure of the database table to the document. If you manually If you add it, it’s very ridiculous.
There are m
PowerDesigner exports data table structure to Excel all table structure in the same sheet
Option Explicit
Dim rowsNum
rowsNum = 0
‘————————————————- —————————-
‘Main function
‘————————————————- —–
PowerDesigner imports PowerDesigner in accordance with the Excel design data table structure
Option Explicit
Dim shet, cnt
‘————————————————- –
‘For each shet in array(“Sheet1”, “Sheet2”, “Sheet3″…)
‘————————————————- –
Dim
PowerDesigner generates an Excel version of the database file
To convert the database design to an excel version, Baidu will publish a script file, which is easy to use and find out, keep a memorial
In pd, shift+ctrl+X, open the script to run, the scrip
Several common modeling tools (Rose, PowerDesigner, Visio)
1, ROSE
< /span> ROSE is directly developed from UML The birth of the design tool, it appeared to support UML modeling, ROSE did not support the database-side modeling at the beginning, but the
PowerDesigner (8) – Model Document Editor (Generate Project Documentation)
The original text is from: http://www.voidcn.com/article/p-uoilqgur-oy.html
The Model Report of PowerDesigner is a model-based, project-oriented overview document. It provides a flexible and
SQL file in PowerDesigner, database table reverse generation PDM
1 Reverse PDM generation 1) Create an empty PDM model (select the corresponding DBMS) :
2) Select [Database]–[Update Model from Database…] menu:
1) In the new window, select the cor
PowerDesigner generates automatic identification of mysql statements, Name, and comments
When using PowerDesigner to design the ORACLE library table in the past, it is very convenient to generate the SQL statement to build the table. There is an option, which means that when the COMMEN