Introduce the software:
Powerdesigner products provide a complete modeling solution. Business or system analysts, designers, database administrators, DBAs, and developers can crop them to meet their specific needs; its Modular structure provides great flexibility for purchase and expansion, so that developers can use the tools they need based on the scale and scope of their projects. Powerdesigner's flexible analysis and design features allow the use of a structured approach to effectively create databases or data warehouses without requiring strict adherence to a specific methodology. Powerdesigner provides intuitive symbolic representations to make it easier to create databases, standardize communication and communication within the project team, and more easily present database and application designs to non-technical personnel.
Powerdesigner not only accelerates the development process, but also provides end users with an effective structure for managing and accessing project information. It allows designers not only to create and manage data structures, but also to develop and use data structures to quickly generate application objects and data-sensitive components in a leading development tool environment. Developers can use the same physical data model to view the database structure and documents, and generate application objects and components used during development. Application Object generation helps to provide more control and higher productivity throughout the development lifecycle.
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:
Powerdesigner processanalyst for data discovery.
Powerdesigner data‑ect is used for two-layer, interactive database design and construction.
Powerdesigner appmodeler is used for physical modeling and generation of application objects and data-sensitive components.
Powerdesigner metaworks is used for advanced team development, information sharing, and model management.
Powerdesigner warehouseeffecect is used for data warehouse design and implementation.
Powerdesigner viewer is used to access model information of the entire enterprise in read-only and graphical mode.
The following describes the six modules of powerdesigner in detail:
Powerdesigner processanalyst
Used for data analysis or "data discovery ". The processanalyst model is easy to establish and maintain and can be used during the application development cycle to ensure smooth communication between all participants. This tool allows users to describe complex processing models to reflect their database models. Processanalyst can be used to describe data items in a more natural way by describing the data that they exchange in the system.
Powerdesigner data‑ect
It is used for two-layer concept layer and physical layer database design and database structure. Data‑ect provides conceptual data model design, automatic physical data model generation, and nonstandard physical design. It is used to generate databases of multiple database management systems (DBMS, development Tool support and high-quality document features. Using its reverse engineering capabilities, designers can obtain a database structure "blueprint" that can be used to document and maintain the database or port it to a different DBMS.
Powerdesigner appmodeler
It is used for the design of physical databases and the generation of application objects and data-sensitive components. By providing complete physical modeling capabilities and using those models for development, appmodeler allows developers to focus on leading development environments, including PowerBuilder, Visual Basic, delphi2.0, and power ++, quickly generate objects and components. In addition, appmodeler can generate components for creating data-driven web sites, so that developers and designers can also publish "dynamic" data from a DBMS. In addition, appmodeler provides physical database generation, maintenance, and document generation for over 30 DBMS and desktop databases.
Powerdesigner metaworks
Supports the ability of senior teams to work through model sharing. This module provides a global hierarchical view of all model objects to ensure consistency and stability throughout the entire development cycle. Metaworks provides descriptions and definitions of users and groups and manages access permissions, including model lock security mechanisms. It also contains metabrocle, a flexible dictionary browser for browsing, creating and updating all model information across projects and powersoft objectcycle, a version control system.
Powerdesigner warehouseeffecect
It is used for modeling and implementation of data warehouses and data marketplaces. Warehouseeffecect provides support for traditional DBMS and data warehouse-specific DBMS platforms, and supports both dimensional modeling and high-performance indexing modes. Warehouseeffecect allows you to introduce (reverse engineering) source information from a large number of running databases. Warehouseeffecect maintains link tracing between source and target information for third-party data extraction and query and analysis tools. Warehousegateect provides full warehouse processing support for all major traditional DBMS such as Sybase, Oracle, Informix, DB2, and data warehouse-specific DBMS such as red brick warehouse and asiq.
Powerdesigner Viewer
It is used to access modeling and metadata in a read-only and graphical manner. Viewer provides read-only access to all model information of powerdesigner, including processing, concept, physical and warehouse model. In addition, it provides a graphical view of model information, and the viewer provides a complete report and documentation function across all models.
Powerdesigner is the most integrated design tool set for creating highly optimized and powerful databases, data warehouses, and data-sensitive components.
New features and advantages of Sybase powerdesigner 11.0 include:
-- Business value:
* Conflict Analysis: evaluates the impact of business or technological changes in a simple and effective manner to achieve better agility and predictability.
* Requirement management: shortens the project completion time and obtains and regulates more effective requirements to ensure more accurate project results. It also ensures better traceability by establishing associations between design and requirements.
* Business Process Analysis: design a better business process by understanding the relationship between the business and the underlying applications and data.
-- Technical value:
* Enhanced Data Modeling: supports the latest RDBMS engines and the latest functions such as Web Services and XML in databases.
* Enhanced UML: added support for j2ee1.4 and web service models and templates.
* Enhanced Business Process Model: provides a hierarchical view of the processes designed using this tool, and provides clearer communication capabilities and better flexibility.
* New Information Flow Model: supports replication, data movement, and metadata management, and provides model-driven methods for designing mobile databases and central databases) synchronization between them. Powerdesigner tutorial Series
Target:
This document describes the basic concepts of Data Model CDM in powerdesigner.
1. Conceptual Data Model Overview
Data models are the abstraction of data features in the real world. The data model must meet the following requirements:
1) Ability to simulate the real world more realistically
2) easy to understand
3) easy to implement by Computer
The conceptual data model is also called the information model. It is based on the entity-relationship (E-R) theory and expands this theory. It models information from the user's point of view and is mainly used for Conceptual Design of databases.
Generally, people first abstract the real world into a conceptual world, and then convert the conceptual world into a machine world. In other words, objective objects in the real world are first abstracted as entities and relationship. They do not depend on a specific computer system or a DBMS system, this model is what we call CDM, and then converts CDM to the data model supported by a DBMS on the computer. This model is the physical data model, that is, PDM.
CDM is a set of strictly defined model elements that accurately describe the static characteristics, dynamic characteristics, and integrity constraints of the system, it consists of three parts: data structure, data operation, and integrity constraint.
1) Data structures are expressed as entities and attributes;
2) The data operation table is the insert, delete, modify, query, and other operations of records in the entity;
3) integrity constraints are expressed as integrity constraints of data (such as data types, checks, rules, etc.) and integrity constraints of reference between data (such as links and inheritance links );
Ii. Definitions of entities, attributes, and identifiers
Entity, also known as an instance, corresponds to "events" or "things" that can be different from other objects in the real world ". For example, each student in the school and each operation in the hospital.
Each entity can be used to describe a set of properties of entity features, which are called attributes. An entity is described by several attributes. For example, a student entity may consist of attributes such as student ID, name, gender, date of birth, department, and year of admission.
An entity set is a set of entities of the same type and nature. For example, a set of all students in a school can be defined as a "student" entity set, each entity in the "student" entity is subject to a student ID, name, gender, date of birth, department, and year of admission.
Entity type is a set of common properties of each entity in an entity set. For example, the entity type of "patient" is: Patient {outpatient number, name, gender, age, ID card No .............}. An object is an instance of the object type. When the meaning is clear, the object and object types are usually used interchangeably.
Each entity in an object type contains one or more attributes that uniquely identify it. These attributes are called identifiers of an object type. For example, a student ID is an identifier of a student entity type, "name", "Date of Birth", and "email address" form the "Citizen" entity type identifier.
Some object types can have several groups of attributes that act as identifiers. select one of these attributes as the primary identifier of the object type, and others as the secondary identifier.
3. entity, attribute, and identifier expression
Powerdesigner tutorial series (ii) Conceptual Data Model posted on kevinyin reading (5552) Comments (17) EDIT favorite category: powerdesigner
Objectives:
This document describes how to create a powerdesigner data model, an object, and an attribute.
1. Create a conceptual data model
1) Select File --> new. In the displayed dialog box, select CDM model (Conceptual Data Model) to create a model.
2) create a conceptual data model. To give a brief introduction to the current workspace. (More details later)
3) Select the newly added CDM model, right-click the model, and select the "properties" attribute in the pop-up menu. the pop-up dialog box is displayed. In the General tab, you can enter the name, code, description, creator, version, and default chart of the created model. Enter the description and description in the "Notes" tab. For more tags, click "More>.
2. Create a new object
1) in the CDM graphic window, click entity tool on the tool option edition, and then click a blank area in the graphic window. An entity symbol is displayed at the clicked position. Click the pointer tool or right-click to release the entitiy tool.
2) double-click the newly created object symbol to open the following icon window. In the "General" tab of the window, you can enter the object name, code, description, and other information.
3. Add Object Attributes
1) You can add attributes to the "attribute" option tag in the preceding window, as shown in.
Note:
The "add attribute" and "reuse existing data items" functions in the data item are related to the unique code of the data item in the model and the allow reuse option.
The P column indicates whether the property is the primary identifier; the D column indicates whether the property is displayed in the graphic window; The m column indicates whether the property is mandatory, that is, whether the column is null.
If an object property is mandatory, it must be assigned a value in each record and cannot be blank.
2) In the displayed window, click the insert attribute button to bring up the attribute dialog box, as shown in.
Note: This involves the concept of a domain, that is, a standard data structure, which can be applied to the attributes of data items or entities. In the following tutorial, we will create additional chapters for detailed description.
To be continued.
Powerdesigner tutorial series (3) Conceptual Data Model posted on kevinyin reading (5008) Comments (19) EDIT favorite category: powerdesigner
Objectives:
This document describes the standard check constraints of attributes and how to define additional checks for attributes.
I. Define standard inspection constraints for Attributes
The standard check constraint is a set of expressions that ensure the attribute is valid. In the Properties window of object properties, open the check tab.
On this tab, you can define the standard check constraints for attributes. The meanings of parameters in the window are as follows:
Parameter description: minimum acceptable value of the minimum attribute when the maximum number of acceptable values of the maximum attribute default attribute is not assigned a value, the default unit provided by the system, for example, the value assignment of the lowercase attribute in the data display format of the kilometer, Ton, and Yuan format attribute is changed to the value assignment of the lower case letter uppercase attribute, and all the values are changed to the upper case letter cannot modify. Once the value assignment of this attribute cannot be modified list attribute assignment list, except the values in the list, there cannot be tags of other values in the label attribute list.
Ii. Additional inspection of defining attributes
When standard checks or rules cannot meet the requirements of the check, you can go to the server subpage on the additional checks tab, use the variables % MINMAX %, % listval %, % rules %, % upper %, and % lower % in SQL statements to define standard and rule,
% MINMAX %, % listval %, % upper %, % lower %
Minimum and maximum, list values, uppervalues, and lowervalues defined in standard check
% Rules %
Validity rule expression defined on the Expression tab of the Rules Properties window
To be continued.
Powerdesigner tutorial series (4) Conceptual Data Model posted on kevinyin read (4869) Comments (12) EDIT favorite category: powerdesigner
Objectives:
This document describes how to define the Primary and Secondary identifiers of an object.
1. identifier
An identifier is a set of one or more attributes of an object. It uniquely identifies an instance in an object. It should be emphasized that the identifiers in CDM are equivalent to primary keys or candidate keys in PDM.
Each entity must have at least one identifier. If an object has only one identifier, it is the primary identifier of the object. If an object has multiple identifiers, one of them is specified as the primary identifier, and the other identifiers are secondary identifiers.
2. If the Primary and Secondary identifiers are defined
1) double-click an object to display the object Properties dialog box. You can define object identifiers on the identifiers tab. As shown in
2) Select "primary identifier" in the first line, click the attribute button, or double-click "primary identifier" in the first line. The Properties dialog box is displayed,
3) Select the "attributes" tab and click "add attributes". In the displayed window, select an attribute as the identifier.
To be continued.
Powerdesigner tutorial series (5) Conceptual Data Model posted on kevinyin read (4663) Comments (9) EDIT favorite category: powerdesigner
Objectives:
This section describes data items, new data items, unique code options for data items, and reuse options.
I. Data items
A data item is the smallest unit of information storage. It can be attached to an object as an attribute of an object.
Note: Data items that are not attached to any entity are allowed in the model.
2. Create a data item
1) use the "model" ---> data items menu to display the list of existing data items in the window that appears. Click "add a row" to create a new data item,
2) Of course, you can continue to set the code, ype, length, and other information for specific data items. This is not detailed here.
Iii. unique code options and reuse options for data items
Use tools ---> model options-> model settings. In the data item group box, define the unique code option (unique code) and reuse option (allow reuse) of the data item ).
Note:
If the unique code check box is selected, each data item has a unique code in the same namespace, and allow reuse is selected, a data item can act as the attribute of multiple entities.
4. Add data items to an object
1) double-click an object symbol to open the object attribute window.
2) Click the attributes tab to open the window as shown in
Note:
The difference between Add a dataitem and reuse a dataitem is that
When you add a dataitem, select an existing data item. The system automatically copies the selected data item. If the uniquecode option is set, the system automatically generates a unique number for the code of the new data item during the replication process. Otherwise, the code is exactly the same as the selected data item.
In the case of reuse a dataitem, only references do not add, that is, references existing data items as new object data items.
To be continued. Powerdesigner tutorial series (6) Conceptual Data Model posted on kevinyin read (6188) Comments (18) EDIT favorite category: powerdesigner
Objective: This article describes how to define and use a contact.
1. Contact
Relationship refers to the connection between the entity set and the instances in the entity set.
Entities can be associated by association. It corresponds to an object and an object set. A link can also be divided into a link and a contact set. A contact set is a link between an object set, and a link is a link between entities, which is oriented. A contact and a contact set can be referred to as a contact if the meaning is clear.
There are four types of links according to the number of instances in the entity type, that is, one-to-one (one-to-one) and one-to-many (one-to-many) contact, multi-to-one contact, and multi-to-one contact ).
2. Establish contacts
In addition to public tools, the CDM tool option Board also includes other object generation tools as shown in.
After creating two entities in the graphic window, click the "Create contact between entities" tool, click an entity, drag the cursor to another entity while pressing the left mouse button, and release the left mouse button, in this way, the contact is created between the two entities, right-click the graph window, and release the relationship tool. As shown in
3. Four basic connections
That is, one-to-one connections, one-to-many connections, one-to-one connections, and many-to-many connections ).
4. Other Special contacts
In addition to four basic connections, there are also identify relationship, non-standard relationship, and recursive relationship between the entity set and the entity set ).
Calibration contact:
Each object type has its own identifier. If there is a link between two entity sets, when one entity type identifier enters another entity type and forms its identifier together with the entity type identifier, this kind of contact is called a calibration contact or a dependency contact. The opposite is called non-standard or non-dependent contact.
Note:
In a non-standard relational system, some instances in an entity set depend on instances in another instance set. In this dependency relationship, each entity must have at least one identifier. In the calibration contact, all instances in one entity set depend entirely on instances in another entity set. In this dependency relationship, one entity must have at least one identifier, another entity does not have its own identifier. An entity without an identifier uses the identifier of the entity on which it depends as its own identifier.
In other words, in the calibration contact, an entity (Course Selection) depends on one entity (student), then the entity (student) must have at least one identifier, and (Course Selection) an entity may not have its own identifier. An entity without a logo identifier can use the entity (student) identifier as its own identifier.
Recursive contact:
Recursive link is a link between instances in the entity set. It is usually called an anti-link. The link between different entity sets in the same object type is also called recursive link.
For example, there are many employees in the "employees" entity, and there must be a relationship between the leaders and the leaders. Another example is that the entity in the "student" entity contains the "class monitor" and "common student" child body sets. The link between the two child body sets is a recursive link. When creating a recursive link, you only need to click the "Create link between objects" tool to drag a part of the object to another part of the object. Figure
5. define the characteristics of contact
After establishing a contact between the two entities, double-click the contact line to open the contact feature window ,.
6. Define the role name of the contact
There is a grouping box in each of the two directions of the contact. The parameter takes effect only in this direction, and the role name is the role name, which describes the role of the contact in this direction, generally, a verb or a dynamic object group table is used.
For example, in the "student to course" group box, enter "own", and in the "course to student" group box, enter "Belong ". (Here is just an example to illustrate that some words may be inappropriate ).
VII. Define mandatory contact
The mandatory relationship of the mandatory table in this direction. Select this check box to generate a vertical line on the contact line. If this check box is not selected, the contact direction is optional. A small circle is generated on the contact line.
8. Contact Base
The connection is oriented and each direction has a base.
For example,
The relationship between the "department" and "student" entities is one-to-many. In other words, the relationship between "student" and "department" is one-to-one. In addition, a student must belong to only one department and cannot belong to none. Therefore, the base from "student" to "department" is ", in another direction of contact, a department can have multiple students or have no students, that is, zero students. Therefore, the contact base in this direction is "0, N ",
To be continued.
Trackback: http://tb.blog.csdn.net/TrackBack.aspx? Postid = 1957701
Use of powerdesigner
