Power Designer is a CASE tool set of Sybase. It can be used to conveniently analyze and design management information systems. It covers almost the whole process of database model design.
Using Power Designer, you can create data flowcharts, conceptual data models, and physical data models, generate applications with various client development tools, and create data warehouses.
As a structure model, you can also control the team design model.
Four models of Power Designer:
Concept data model (CDM)
Physical Data Model (PDM)
Object-Oriented model (OOM)
Business Program Model (BPM)
I will mainly introduce PDM:
PDM describes the physical implementation of databases, helping you consider the details of physical implementation. You can modify PDM to suit your performance or physical constraints.
The main purpose is to generate a specific DBMS script for the real-world model established in CDM, generate a storage structure for storing information in the database, and ensure the integrity and consistency of data in the database.
PDM is a tool suitable for the system design stage. Simply put, PDM can automatically generate SQL scripts such as 'create Table.
In the data modeling process, we establish a conceptual data model, generate a physical data model through a forward project, generate a database creation script, and finally generate a relational database from the physical data model.
System database designers hope to seamlessly integrate database design and relational database generation. How to ensure two-way synchronization between physical data models and their corresponding databases becomes a key aspect of data modeling.
As a powerful case tool, powerdesigner provides us with convenient reverse engineering features. The structure information of all popular backend databases (including Sybase, DB2, and Oracle) can be reversed through
The project is added to the physical data model and conceptual data model of powerdesigner, including tables, indexes, triggers, and views.
The following describes how to use powerdesigner for reverse engineering.
1. the database I used is Oracle9i. To access the Oracle database, I installed the Oracle client on my machine (the driver of the Oracle client is provided, but not the thin client ), configure a service named mylcl:
Mylcl =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = 192.168.3.106) (Port = 1521 ))
)
(CONNECT_DATA =
(SID = PWSC)
)
)
Username: testuser, password: test.
2. In PD, create a PDM and select Oracle9i as the database.
3. Select database-> Configure connections, go to the system DSN tag, click "add", and select the driver. Because my database is Oracle, I chose "oracle in your lient10g_home1"
(This driver is available only when the Oracle client is installed, but not the thin client)
4. in data source name, you can name a "ora-test" randomly. In TNS-server name, select the service name in Step 1: mylcl. click "test connection" and enter the user name and password. Connection OK!
5. Click database-> reverse engineer database, select ODBC datasource: ora-test. then click OK.
Haha, I don't want to talk about anything.
What are PDM charts?
In fact, PD can use SQL for reverse engineering, so I won't talk about it anymore.
This document is for record. We also hope to help you.