Tags: des style HTTP color OS Java strong File
Powerdesigner Conceptual Model Description
Environment
Powerdesigner 12.5
Windows XP Chinese Version
I. Importance of conceptual models
Powerdeigner is the most powerful and excellent data modeling tool and is the greatest product of Sybase. At present, the latest version is 12.5, which has been used since 9, and the understanding of PD is gradually deepened.
Usually at work, we can see that PD is used to create several tables. In fact
% default %][[Constraint % constname %] Check (% constraint %)]
% Colnname % indicates the column name value (which can be Chinese)
---------------------------------------------------------------------------------
Settings of powerdesigen auto-increment Columns
In PDM, view the table attributes. On the columns tab, select the entire column and view the column attributes. Click the properties icon in the upper-left corner (the one with a hand-shaped p
codeWhen you create an entity in CDM, the name and Code do not automatically match
Set tools -- gerneral options ---> dialog ----> name to code signing ing
-------------------------------------
How to display the name column in scrip
Modify the field generation rule. To add a comment for each field, expand the value of script-> Object-> column-> Add in the same window:
% 20: column % [% compute %? As (% compute %): % 20: datatype % [% identity %? % Identity %: [% null %] [% notnull %] [Default
Label: Style Color: SP strong file Div on Background: The latest version of the ibank. PDM file is incorrect. The version number is 5051. I want to submit the modification on version 5050 and overwrite the modification on version 5051, that is, the modified version 5050 overwrites the modification on version 5051, submitted successfully and becomes the latest version 5052. Use tortoisesvn for version 1.6.10. The steps are as follows: 1. Update the cu
. 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 o
plms Components
The original model construction definition for product lifecycle is supported.
Ing policy and automatic conversion technology for data models of distributed heterogeneous products
Hierarchical cross-stage Collaborative Working Process Modeling Technology
XML-based Open Information Integration and dynamic process Alliance Technology
Multi-dimensional view Product Data Organization Based on Semantic Network. Management and Operation Technology
Collaborative engineering and project
1. Install PD v11.0
2. When the table creation script is generated by PDM, an error occurs when the field exceeds 15 characters (Oracle)Unknown cause. The solution is to open the PDM, And the menu bar of the database appears. Go to database-edit current DBMS-script-objects-column-maxlen and increase the value (Originally 30 ), for example, change to 60. If the length of a table or other objects is incorrect
"OK ".3. Generating ER diagramThird, the use of PowerDesigner Export database er diagram, PDM diagramThis article is useful in the following two scenarios:1. When the database description document is synchronized with the structure of the actual database.2. When generating its explanatory documents based on the existing database structure.I usually do this to generate the "Database documentation":Method One (this is done when SQL Server 2000)Using th
the default code=name, can you change it?◇ Solution:Set tools--gerneral options--->dialog---->name to code mirroring8, Power Desienger Self-growth column settings◇ Problem Description:How do I implement a self-growing column in Power Desienger?◇ Solution:In PDM, view the properties of the table, the Columns tab, select the whole column, view the column properties, click the property icon (the one with the hand pattern) at the top left, and then open
Label:PowerDesigner Generating an Access database Since the use of PD has been known to support access but has not figured out how to create Access data tables from scripts. Finally, the answers found in the PD tools are in the C:\Program files\sybase\powerdesigner 12\tools directory. Currently, only access97 and access2000 databases are supported. ACCESS2007 database is not supported, but no matter, as long as the generation of access2000 database upgrade on the line, but the trouble is to get
How to set the self-growth primary key in CDM◇Problem Description:How can cmd make the primary key grow from it? such as MySQL primary key use Auto_increment and Oracle primary key use sequence etc?◇Workaround:Set the primary key column data type is serial, then generate PDM will be based on different databases generated corresponding self-growth primary key mode, such as MySQL corresponding auto_increment,oracle corresponding sequenceHow do I rename
, but in CDM, there are three other attributes that can be set: mandatory (mandatory contact) and dependent (dependency contact/calibration Association) and dominant ). These attributes have a great impact on the subsequent production of PDM, so we need to know them one by one. They are all set in the contact property control panel, see:1. MandatoryWhether a connection is mandatory means whether such a connection is inevitable between entities. Or, in
process.
The PLM system fully supports conception, evaluation, development, management, and support of products in the entire digital product value chain. It integrates multiple unconnected product information islands into a digital record system, together with ERP, SCM, and CRM, a complete enterprise information collaboration system is formed.
Iii. PLM Selection
For enterprises, it is necessary to call appropriate professional development teams to develop their own PLM systems. On the one han
Powerdesigner generates an Access database
Since using PD, you have always known that access is supported, but you have never figured out how to create access data tables through scripts. The answer found in PD's tools is found in the C: \ Program Files \ Sybase \ powerdesigner 12 \ tools directory. Currently, only Access97 and Access2000 databases are supported. Access2007 databases are not supported yet, but it does not matter. You only need to generate an Access2000 Database Upgrade, but th
/calibration Association) and dominant ). These attributes have a great impact on the subsequent production of PDM, so we need to know them one by one. They are all set in the contact property control panel, see:1. MandatoryWhether a connection is mandatory means whether such a connection is inevitable between entities. Or, in other words, when we talk about an application scenario of a connection, the number of physical instances corresponding to the
contact/calibration Association) and dominant ). These attributes have a great impact on the subsequent production of PDM, so we need to know them one by one. They are all set in the contact property control panel, see:1. MandatoryWhether a connection is mandatory means whether such a connection is inevitable between entities. Or, in other words, when we talk about an application scenario of a connection, the number of physical instances correspondin
1. When the table creation script is generated by PDM, an error occurs when the field exceeds 15 characters (Oracle)Unknown cause. The solution is to open the PDM, And the menu bar of the database appears. Go to database-edit current DBMS-script-objects-column-maxlen and increase the value (Originally 30 ), for example, change to 60. If the length of a table or other objects is incorrect, you can select the
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.