Power Designer is the Sybase's Case toolset, which is easy to analyze the management information system, which has almost included the entire process of database model design. Using Power Designer to make data flow charts, concept data models, physical data models, can generate applications for multiple client development tools, and can also create structural models for data warehouses, and can also control team design models. 4 models of Power Designer: Conceptual Data Model (CDM) Physical Data Model (PDM) Object-Oriented Model (OOM) Business Program Model (BPM) I mainly introduce the physical implementation of PDM: PDM narrative database, help you consider real physics Detail of the implementation. You can fit your performance or physical constraint by fixing PDM. The main purpose is to generate a specific DBMS script established in the CDM to generate a storage structure for saving information in the database, ensuring the integrity and consistency of data in the database. PDM is a tool suitable for system design stages. Simply said: PDM can automatically generate SQL scripts such as 'create table'. In the data modeling process, we establish a conceptual data model to generate a physical data model through a forward engineering, generate a database construction library script, and finally Data model generates a relational database. System database designers want to generate seamlessly integration of database design and relational databases, how to ensure that the physical data model is a critical synchronization between the two-way synchronization between its corresponding databases. As a powerful Case tool, PowerDesigner provides us with convenient reverse engineering characteristics. Structure information of all popular backend databases (including Sybase, DB2, Oracle, etc.) can be added to the physical data model and concept data model of PowerDesigner by reverse engineering, including tables, indexes, triggers, views, etc. Let's talk about how to use PowerDesigner to reverse engineering .1. I used the database is Oracle9i, I have installed the Oracle client on my machine (providing the Oracle client driver, and the thin client is not Yes, configure a name that is MYLCL: MYLCL = (deScription = (address = (protocol = tcp) (host = 192.168.3.106)) (connect_data = (SID = PWSC)) The username is: Testuser, the password is Test. 2. In the PD, create a new PDM, select the database to Oracle9i3. Select Database-> Configure Connections, go to the System DSN tab, click "Add", select the driver, because I The database is ORACLE, so I chose "Oracle in Oraclient10G_Home1" (there is this driver installed in the Oracle client, and the streamlined client doesn't drive) 4. In Data Source Name, you can name an "Ora-Test", Select the service name in the first step in TNS-Server Name: MYLCL. Click "Test Connection", enter the username password, CONNECTION OK! 5. Click Database-> Reverse Engineer Database, select ODBC Datasource: ORA-TEST. And Click OK, I saw anything. I don't say it. How is the chart of PDM? In fact, PD can also be reverse engineering through SQL, I will not say this archive. At the same time, I hope to help everyone.
