Reverse engineering of power designer

  Power Designer is the case tool set of Sybase, which can be used to analyze and design the management information system, which almost includes the whole process of database model design. Power designer can be used to produce data flow chart, concept data model, physical data model, can generate a variety of client development tools applications, but also for the Data warehouse production structure model, can also control the team design model. 4 Models of Power Designer: Conceptual data Model (CDM) Physical data Model (PDM) object-oriented model (OOM) Business Program model (BPM) I'll introduce you to the physical implementation of the PDM:PDM narrative database to help you consider the details of the actual physical implementation. You can modify the PDM to suit your performance or physical constraints. The main purpose is to generate a specific DBMS script from the real world model established in CDM, to generate the storage structure of the information stored in the database, and to ensure the integrality and consistency of the data in the database. PDM is a tool suitable for the system design phase. Simply put: PDM can automatically generate SQL scripts such as ' CREATE table '. In the process of data modeling, we set up the conceptual data model, generate the physical data model by forward engineering, generate database script, and finally generate the relational database with the physical data model. The system Database Designer wants to be able to integrate the database design and relational database generation seamlessly, how to ensure the bidirectional synchronization between the physical data model and its corresponding database becomes the key point of data modeling. As a powerful case tool, PowerDesigner provides us with convenient reverse engineering features. All current popular back-end databases (including Sybase, DB2, Oracle, etc.) can be added to the PowerDesigner physical data model and conceptual data model through reverse engineering, including tables, indexes, triggers, views, and so on. Here's how to use PowerDesigner for reverse engineering. 1. The database I use is oracle9i, and I have an Oracle client installed on my machine to access the Oracle database (a driver for the Oracle client, and a thin client is not available). Configure a service called MYLCL: MYLCL =  (DESCRIPTION =    (address_list =      ( Address = (PROTOCOL = TCP) (HOST = 192.168.3.106) (PORT = 1521))     (Connect_data =      (SID = PWSC)    )  ) The user name is: testuser, The password is test. 2. In PD, create a new PDM, select the database as Oracle9i3. Select Database->configure connections, go to System DSN tab, click "Add", select Driver, because my database is Oracle, So I chose Oracle in ORACLIENT10G_HOME1 (this driver is installed with the Oracle client and the Lite client does not) 4. In data source name, you can name a "Ora-test", In Tns-server name, select the service name in the first step: MYLCL. Click "Test Connection", enter username password, connection ok!5. Click Database->reverse Engineer Database, select ODBC Datasource:ora-test. Then click OK haha, see what. What about the PDM diagram? In fact, PD can also reverse-engineer through SQL, I will not say I hereby file.