Introduction to powerdesigner [reprinted]

Source: Internet
Author: User
Tags sybase powerdesigner
1. Introduction to powerdesigner

Powerdesigner 15 is a case (Computer-Aided Software Engineering) tool integrated with Enterprise Architecture Analysis, UML (Unified Modeling Language), and data modeling launched by Sybase. It can be used in different stages of system design and development (namely, business analysis, conceptual model design, logical model design, physical model design, and object-oriented development ), it can also be used by management, system design, development, and other personnel. It is the first modeling software in the industry that provides business analysis, database design, and application development.

Powerdesigner is a powerful and easy-to-use tool set that provides a complex interaction environment that supports all stages of the development lifecycle, from process modeling to object and component generation. The models and applications generated by powerdesigner can grow constantly and adapt to and change with the changes in your organization.


Powerdesigner consists of six tightly integrated modules that allow individuals and developers to meet their needs in a cost-effective manner. The six modules are:

(1) powerdesigner process analyst: used for data discovery.

(2) powerdesigner data Architect: used for two-layer, interactive database design and construction.

(3) powerdesigner app modeler: used to generate physical modeling and application objects and data-sensitive components.

(4) powerdesigner meta works: used for advanced team development, information sharing, and model management.

(5) powerdesigner warehouse Architect: used for data warehouse design and implementation.

(6) powerdesigner Viewer: used to access model information of the entire enterprise in read-only and graphical mode.


Powerdesigner mainly includes the following functions:

(1) dataeffecect:

This is a powerful database design tool. With data‑ect, you can create a "conceptual data model"-CDM (Conceptual Data Model) for an information system using the entity-relational diagram ). You can also generate a "Physical Data Model"-PDM (physicaldata model) based on a specific database management system (for example, Sybase system 11) based on CDM ).

You can also optimize PDM, generate SQL statements for creating databases for specific DBMS, and store them in the form of files so that you can run these SQL statements to create databases at other times. In addition, data‑ect can reverse generate PDM, CDM, and SQL scripts for creating databases based on existing databases.


(2) processanalyst:

This part is used to create a functional model and a data flow diagram, and create a "processing level ".


(3) appmodeler:

Create an application model for customer/server applications.


(4) ODBC Administrator:

This part is used to manage various data sources of the system.


(5) XML files

You can use a tool to generate an XML file or an XML file to generate a model.


Ii. description by powerdesigner

Wang Xiaoyu went to Peking University in 1978 and spent only three months studying in France in 1979. After graduating from college in 1986, he worked in the SDP software company in Paris, at that time, I was engaged in software development and design. During my work, I always wanted to find a good modeling design tool, but I didn't. I thought I could not develop such a software myself. So I started to develop it in 1988. In 1989, I developed the first version called AMC * designor, which was sold well in France.

All the software in the company was developed using the tool PD, which has been in use until now. Later, I continued to develop and improve this product and expanded the market to the United States. In 1991, I began to sell it in the United States. The product name was S-designor.

In 1995, powersoft bought our SDP company. In the same year, Sybase bought powersoft, S-designor and AMC * designor again, and changed their names to powerdesigner and poweramc.

We have been responsible for the design and development of powerdesigner since 1995.


Iii. powerdesigner15 model description 3.1 concept of Data Model

Data is a symbolic record describing a thing. A model is an abstraction of the real world. Data Model (datamodel) is an abstraction of data features and a teaching framework of database management.


The data model describes three parts: data structure, data operations, and data constraints:

1) Data Structure: The data structure in the data model mainly describes the data type, content, nature, and connection between data. Data structure is the basis of the data model, and data operations and constraints are built on the data structure. Different data structures have different operations and constraints.

2) Data Operations: Data Operations in the data model mainly describe the operation types and operation methods on the corresponding data structure.

3) Data constraints: Data constraints in a data model mainly describe the syntaxes, word meanings, constraints and dependencies between data in a data structure, and the rules for dynamic data changes, to ensure that the data is correct, valid, and compatible.


3.2 functional modules of powerdesigner 15


Knowledge Base (repository)

Plugin (addins & plug-in)


Enterprise Architecture Model (EAM)

Requirement model (requirementsmodel, rqm)

Information Flow Model (ILM)

Business Process Model (BPM)

Concept data model (CDM)

Logical Data Model (LDM)

Physical Data Model (PDM)

Object-oriented model (OOM)

XML model (XML model, Xsm)

Document (report)


Model document Editor:

Generate relevant documents in RTF or HTML format from various models

You can customize the document generation items and set the document format.


Powerdesigner currently supports the following modules:



The relationships between modules and their functions are as follows:



Concept data model (CDM ):

Modeling of data and information, using the form of Entity Relationship Diagram (E-R diagram) to organize data

Test the effectiveness and rationality of data design


Physical Data Model (PDM ):

Design Based on the conceptual data model and Logical Data Model Based on specific DBMS

Generate a database from the physical data model, or reverse engineer the database to obtain the physical data model.


Object-Oriented model (OOM ):

An OOM contains a series of packages, classes, interfaces, and their relationships. These objects form a class structure of all (or part) the logic of a software system design view. An oom is essentially a static conceptual model of a software system.

Use UML to describe the system structure

Generate source files in different languages (such as Java, C #, and PowerBuilder) using class diagrams, or convert source files of different types into corresponding class diagrams using reverse engineering.


Business Program Model (BPM ):

BPM describes different internal tasks and internal processes of the business, and how the customer interacts with these tasks and processes.

BPM is a conceptual model of business logic and rules from the perspective of business partners. It uses a chart to describe the interaction between programs, processes, information and cooperation protocols.


Information Flow Model (ILM ):

ILM is a high-level information flow model used for data replication between distributed databases.


Enterprise Architecture Model (EAM ):

Describes the enterprise's architecture from the business layer, application layer, and technology layer.


Organization chart

Business Communication Diagram

Process Diagram

City Plan

Application Architecture

Service-oriented Diagram

Technical Framework


Iv. General features of powerdesigner

Requirement management:

Powerdesigner can convert requirement definitions into any number of analysis and design models, record requirements and change history of all analysis and design models, and keep track of them.


Document generation:

Powerdesigner provides the wizard Wizard to help you create multi-model documentation reports in RTF and HTML formats.


Impact analysis:

Powerdesigner models are fully integrated using unique links and synchronization technologies to support enterprise-level or project-level comprehensive impact analysis. This technology is supported in business process model, UML object-oriented model, and data model, which greatly improves the strain capability of the entire organization.


Data ing:

Powerdesigner provides a drag-and-drop visual ing tool to conveniently, quickly, and accurately record data dependencies. Establish a complete ing definition supporting impact analysis between any data and data model, data and UML object-oriented model, and data and XML model, and generate persistent code and data warehouse ETL files.


Open support:

Powerdesigner supports all mainstream development platforms: supports more than 60 (Version) relational database management systems, including the latest Oracle, IBM, Microsoft, Sybase, NCR teradata, MySQL, etc, supports various mainstream application development platforms, such as Java J2EE and Microsoft. net (C # and VB. net), Web Services, and PowerBuilder, supporting all mainstream application servers and process execution languages, such as ebXML and BPEL4WS.



Powerdesigner supports customization from the user interface to Modeling Behavior and code generation. Supports custom conversions for model-driven development, including: advanced Support for UML configuration files, customizable menus and toolbar, automatic model conversion through scripting, access through com api and DDL, and code generation through templates and script code generators.


Enterprise Knowledge Base:

Powerdesigner's enterprise knowledge base is a fully integrated design-time Knowledge Base stored in relational databases. It is highly scalable and easy to use by remote users.

This knowledge base provides the following functions: Role-based model and sub-model access control, version control and configuration management, model and version change reports, and comprehensive knowledge base search functions. Powerdesigner's knowledge base can also store and manage any document, including Microsoft, office and project files, images, and other types of documents.








Organized from Network

Bytes -------------------------------------------------------------------------------------------------------




Dba1 group: 62697716 (full); dba2 group: 62697977 (full) dba3 group: 62697850 (full)

Super DBA group: 63306533 (full); dba4 group: 83829929 (full) dba5 group: 142216823 (full)

Dba6 group: 158654907 (full) dba7 group: 69087192 (full) dba8 group: 172855474

DBA super group 2: 151508914 dba9 group: 102954821 chat group: 40132017 (full)

-- Add the group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, the application is rejected.

  • Previous Article: Oracle length and lengthb Functions
  • Next article: powerdesigner tool Panel Association, inheritance, Association link unavailable Solution

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: 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.