PowerDesigner is a case (computer-aided software Engineering) tool for Sybase that integrates enterprise architecture, UML (Unified Modeling Language), and databases. It can be used not only in the different stages of system design and development (i.e. business analysis, conceptual model design, physical model design and object-oriented development phase), but also in the use of management, system design, development and other related personnel. It is the first modeling software in the industry to provide business analysis, database design and application development at the same time.
PowerDesigner 15 contains projects (project), Knowledge Base (Repository), plug-ins (addins&plug-in) , and 9 models ( Enterprise Architecture model-eam, Demand model-RQM, information flow model-ilm, Business processing model-BPM, conceptual data Model-PDM, object-oriented model-oom,xml model-XSM).
The 9 modules cover all phases of the software development lifecycle.
PowerDesigner 15 also provides a model document editor for creating detailed documentation of the models for each module, giving the relevant people a clear understanding of the system as a whole.
PowerDesigner is divided into 7 types of modeling files:
1. Conceptual data Model (CDM)
Modeling data and information, using entity-Relationship diagram (e-r) Form to organize data, verify the validity and rationality of data design.
2. Logical data Model (LDM)
PowerDesigner 15 new models. The logical model is an extension of the conceptual model, which represents the logical order between concepts and is a model that belongs to the method hierarchy. In particular, the logical model shows the relationships between entities, attributes of entities, and entities on the one hand, as well as inheritance, references in entity relationships, and so forth in the attributes of entities. The logical model is between the conceptual model and the physical model, with the characteristics of the physical model, the many-to-many relationships in the conceptual model, which will be implemented by increasing the one-to-many relationship of the intermediate entities in the logical model.
The logical model is to make the whole concept model easier to understand, without relying on the specific database implementation, the logical model can be used to generate a physical model for the specific database management system. The logical model is not required throughout the step, and can be generated directly from the conceptual model.
3. Physical data Model (PDM)
Based on the specific DBMS, the design is based on the conceptual data model and logical data model. Generate a database from a physical data model, or reverse engineer a database to get a physical data model.
4. Object-oriented model (OOM)
Contains all the graphics common to UML: Class diagram, object graph, package diagrams, use case diagram, time series diagram, collaboration diagram, interaction diagram, activity diagram, state diagram, Component diagram, composite structure diagram, deployment diagram (configuration diagram). OOM is essentially a static conceptual model of a software system.
5. Business Process Model (BPM)
BPM describes the various internal tasks and internal processes of the business, and how customers interact with these tasks and processes. BPM is a conceptual model of business logic and rules from the point of view of a business partner, using a diagram to describe the interactions between programs, processes, information, and cooperation agreements.
6. Information flow model (ILM)
ILM is a high-level information flow model that is primarily used for data replication between distributed databases.
7. Enterprise Architecture Model (EAM):
From the business layer, the application layer and the technical layer of the Enterprise's architecture for a full description. Include: Organization chart, business communication diagram, process diagram, City plan diagram, application frame composition, service oriented diagram, technical framework diagram.
is the so-called "工欲善其事 its prerequisite", PowerDesigner is a powerful "artifact", if you can freely, and then body bosom "peerless martial Arts", then you basically encounter God killed the Buddha to kill God!
See how to create this database quickly with PowerDesigner.
1. Now start using PowerDesigner to create the database, first run the program, into the main interface:
2.file->new model->physical Data model->physical diagram->model Name
Set to test, the DBMS property is set to Mysql5.0:
3. First create a table template with the table tool:
1.) Click Select Table Tool 2.) and then create a new table in the blank space.
4. Double-click the table template to set the properties, we first set up the user_base_info table:
You can also change the name and add notes.
5. Set the table name, click the Columns tab, set the field properties, set:
6. Because the ID field we want to set to autogrow , so to set its advanced properties, select the ID field, click the Properties button, in the general panel tick the identity check box:
7. Preview the SQL statement.
drop tableifexists user_base_info;/*==============================================================*//*Table:user_base_info*//*==============================================================*/CREATE TABLE User_base_info (IDintNotNULLauto_increment, nickname varchar ( +), Real_name varchar ( +), cellphone varchar ( -), Status varchar ( One), primary key (ID)); ALTER TABLE User_base_info comment'remark: User basic information Table';
PowerDesigner Overview (System analysis and modeling)