Reverse Engineering of Power Designer

Source: Internet
Author: User
Tags sybase powerdesigner

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.