powerdesigner逆向工程（PowerDesigner reverse engineering）.docVIP

powerdesigner逆向工程（PowerDesigner reverse engineering） 1: uses PowerDesigner to reverse generate PDM. 2:, according to the database annotation, replaces the English name with the Chinese characters of commit Generating PDM using reverse engineering of Powerdesigner Source: 51CMM.COM Author: Xu Yijie In the process of data modeling, we build conceptual data model, generate physical data model through forward engineering, generate database building script, and finally generate physical database model of relational database. System database designers hope to be able to generate the database design and database seamlessly integrated, how to maintain the physical data model and its corresponding database become a two-way synchronous data modeling is the key. Powerdesigner, as a powerful Case tool, provides us with convenient reverse engineering features. Can be all current popular database (including Sybase, DB2, Oracle etc.) the structure information through reverse engineering to the physical data model of PowerDesigner and conceptual data model, including tables, indexes, triggers, views, etc.. This article covers only reverse engineering of PDM (physical data model). Reverse engineering in PDM refers to the process of generating PDM from an existing DBMS user database or an existing database SQL script. There are two objects in reverse engineering: 1) connect to database 2 through the ODBC data source) existing database SQL scripts. The system environment for this example is as follows: 1, the database has been created, access users and password settings completed. The database is Oracle9i. The 2 and ODBC data sources have been created by Oracles Net Configuration Assistant, the local network naming service Database. 3, SQL script sample crebas.sql. 4, Powerdesigner9.5 installed completed. First, the data source is connected to the database reverse engineering to generate PDM 1, configure user database connection parameters Select Database-configure connections and go