PowerDesigner Using Tutorials

PowerDesigner is a very powerful modeling tool software that is just as good as Rose and is one of the most famous modelling software today. Rose is a modeling tool that specializes in the UML object model before it is modeled on the database, and PowerDesigner is the opposite of it, which started as a database model and later developed into a comprehensive case tool.

PowerDesigner is divided into 7 types of modeling files:

1. Conceptual data Model (CDM)

Modeling data and information, using entity-Relationship diagram (e-r) Form to organize data, verify the validity and rationality of data design.

2. Logical data Model (LDM)

PowerDesigner 15 new models. The logical model is an extension of the conceptual model, which represents the logical order between concepts and is a model that belongs to the method hierarchy. In particular, the logical model shows the relationships between entities, attributes of entities, and entities on the one hand, as well as inheritance, references in entity relationships, and so forth in the attributes of entities. The logical model is between the conceptual model and the physical model, with the characteristics of the physical model, the many-to-many relationships in the conceptual model, which will be implemented by increasing the one-to-many relationship of the intermediate entities in the logical model.

The logical model is to make the whole concept model easier to understand, without relying on the specific database implementation, the logical model can be used to generate a physical model for the specific database management system. The logical model is not required throughout the step, and can be generated directly from the conceptual model.

3. Physical data Model (PDM)

Based on the specific DBMS, the design is based on the conceptual data model and logical data model. Generate a database from a physical data model, or reverse engineer a database to get a physical data model.

4. Object-oriented model (OOM)

Contains all the graphics common to UML: Class diagram, object graph, package diagrams, use case diagram, time series diagram, collaboration diagram, interaction diagram, activity diagram, state diagram, Component diagram, composite structure diagram, deployment diagram (configuration diagram). OOM is essentially a static conceptual model of a software system.

5. Business Process Model (BPM)

BPM describes the various internal tasks and internal processes of the business, and how customers interact with these tasks and processes. BPM is a conceptual model of business logic and rules from the point of view of a business partner, using a diagram to describe the interactions between programs, processes, information, and cooperation agreements.

6. Information flow model (ILM)

ILM is a high-level information flow model that is primarily used for data replication between distributed databases.

7. Enterprise Architecture Model (EAM):

From the business layer, the application layer and the technical layer of the Enterprise's architecture for a full description. Include: Organization chart, business communication diagram, process diagram, City plan diagram, application frame composition, service oriented diagram, technical framework diagram.

is the so-called "工欲善其事 its prerequisite", PowerDesigner is a powerful "artifact", if you can freely, and then body bosom "peerless martial Arts", then you basically encounter God killed the Buddha to kill God!

About the basic use of PowerDesigner physical data model, I do not talk about it here, give a connection, the Earth people read all know: http://www.cnblogs.com/huangcong/archive/2010/06/14/1757957.html

Here are some of the more advanced types of usage and techniques I highlighted below.

1. Generating SQL scripts

Database→generate Database

Select the file path to output, the file storage path, and modify the file name as needed, and then generate the SQL script when you click OK.

In the Options tab, you can personalize and configure SQL scripts, such as canceling foreign keys, removing drop statements, and so on.

The Selection tab allows you to select which tables to generate SQL scripts for.

On the Preview tab, you can preview the SQL script that will be generated.

2. Convert all nouns to uppercase

Tools→model Options ... →naming Convention→code→uppercase.

3. table field Design window displays comment to write comments

Double-click the table to open the Properties window of the table →columns tab → Click the second last icon in the top row (Customize Columns and Filter) → Tick Comment

4. Modify the table field name, code does not automatically follow the change

Tools→general Options ... →dialog→ uncheck name to Code mirroring

5. Conversions between different databases

Database→change current dbms→ Select the target database to convert to

6. Import SQL script to generate the corresponding database table model diagram

File→reverse engineer→database ... → Modify the module name and select the DBMS

Using script files→ Click on the icon below (add files) to add the SQL script file → OK

7. Generate the object model from the physical model and generate the corresponding get, set method

Tools→generate object-oriented Model ... → select language → modify name and code→ (selection tab → Select table to generate the object model) → OK

Double-click the generated table's class diagram to open the Properties window → select all fields → change the field visibility all to private→ click the add ... button → Select Get/set operations→ ok

Then generate the code: Language→generate Java Code ...

"Note: Different languages add ... The content under the button is different, such as C # is the property "

6. Generating Database Documents

Report→generate Report ... → Select generate rtf→ Modify Repor namet→ language selection chinese→ Select file storage location → OK

PowerDesigner also provides document editing features: Report→reports ... → Click the new report icon → Modify repor namet→ language selection chinese→report Template Select Full Physical report

You can then open the Document editing window, but the space is not detailed here to explain how to edit, let's see for yourselves.

8. How to build a self-increment primary key

Double-click the table to open the Properties window → Tick the P primary key check box → Double-click the field that is set as the primary key (double-click on the row's head) or click the Properties icon button above → under the open window (note that different databases, SQL Server is the Identity check box) Select Sequence, If not, click the New button next to create a sequence.

9. How to build a view

toolbar click view button → create view → Double-click the view to open the Properties window, where usage indicates whether the view is read-only or updatable. If we only create a generic view, then select the query only option.

Switch to the SQL Query tab, where you can set up SQL queries that define the view, preferably not using * when defining the view, and instead use each of the column names you want, so that each column is visible in the columns of the view properties. Click the Edit with SQL Editor button in the lower right corner to eject the SQL Editor editor and write the SQL statement. SQL statements can also be generated using other SQL statement generators.

10. How to build an index

Double-click the table to open the Properties window → select indexes tab → new index → Double-click the index to open the Properties window

Select the Columns tab → Click the Add Columns icon button → Select the field to be indexed → OK

The column definition is not selected here, and it conflicts with the primary key.

11. How to create a stored procedure

toolbar, click Procedure button → create stored procedure → Double-click the stored procedure to open the Properties window → Select the Definition tab, where in the drop-down list box, there are two options, default Procedure, default function, which are defined procedures , the latter is an attribute function, and the system creates a template of the SQL statement based on the type of selection → Edit the stored procedure script.

PowerDesigner Using Tutorials