After PDM is completed, it will eventually be converted into a database entity.1. Check whether the DBMS set by powerdesigner is correct, that is, whether it is the database type we want to generate. Here I use sqlserver2000:Powerdesigner-> database-> change the current DBMS and select your database type.
2. Configure the connection between powerdesigner and the data sourcePowerdesigner-> database-> Configure connection-> User DSN (or system DSN)-> se
After PDM is completed, it will eventually be converted into a database entity.1. Check whether the DBMS set by powerdesigner is correct, that is, whether it is the database type we want to generate. Here I use sqlserver2000:Powerdesigner-> database-> change the current DBMS and select your database type.
2. Configure the connection between powerdesigner and the data sourcePowerdesigner-> database-> Configure connection-> User DSN (or system DSN)-> se
First, the PDM model design:1, p is the primary key, M is non-null.2. Link Association3, reference foreign keytwo . powerdesign configuration MySQL ODBC1, official website: http://dev.mysql.com/downloads/connector/odbc/download ODBC driver installation;2, Database---Configure Connections---ADD DataSource (Ctrl + N)--Configure connection Properties--OK.three . PDM to SQL file:1. Database-->chang Current DBMS
How to Use the PDM (Physical Data Model) of powerdesigner to generate databases and reverse engineering (to generate PDM for existing databases)
After PDM is completed, it will eventually be converted into a database entity.1. Check whether the DBMS set by powerdesigner is correct, that is, whether it is the database type we want to generate. Here I use sqlserve
Option ExplicitValidationmode = TrueInteractivemode = Im_batchDim MDL ' current model' Get the current active modelSet mdl = ActivemodelIf (MDL is Nothing) thenMsgBox "There is no current Model"ElseIf not MDL. IsKindOf (Pdpdm.cls_model) Then ' if it's processing PDM, here's Pdpdm.cls_modelMsgBox "The current model isn't an physical Data model."ElseProcessFolder MDLEnd If' This routine copy name to comment for each table, each column and each view' of
IntroductionThe PDM represents the pulse density modulation. However, a better abbreviation is "1-bit oversampling audio" because it is simply a high-sample-rate, single bitrate digital system. If you are looking for an advantage, it is that the sample rate is several times the audio CD, and a proper way to reduce the word length from 16bit to 1bit, which will be the basis of a PDM system.Most modern digita
I. Overview of PDMPDM (physical data model), generally understood, is to display and design the database graphically in PowerDesigner.The basic concepts involved in PDM include:
Table
Column
View
Primary key;
Candidate Key;
Foreign key;
stored procedures;
Trigger
Index
Integrity check constraints;
These are the concepts of the database, not suitable for powerdesigner inside the statement.Second, create
1. Introduction to PDM
The physical data model (Physical Data Model) PDM provides the basic elements required for the initial design of the system and the relationship between related elements; the physical design stage of the database must be detailed on the basis of the background design, including the database stored procedures, operations, triggers, views and index tables;
Powerdesigner can be us
1. Introduction to PDM
The Physical Data Model (Physical Data Model) PDM provides the basic elements required for the initial design of the system and the relationship between related elements; the physical design stage of the database must be detailed on the basis of the background design, including the database stored procedures, operations, triggers, views and index tables;
PowerDesigner can be used to c
The Chinese name of PDM is productdatamanagement ). PDM is used to manage all product-related information.
(Including part information, configuration, documentation, CAD files, structures, permission information, etc.) and all technologies related to product-related processes (including process definition and management.
Background of PDM generation In the S
Conceptual Data ModelThe conceptual data Model (conceptual data MODEL,CDM): Expresses the overall logical structure of the data, which is independent of any software and data storage structure, that is, it is just a common language for system analysts, application designers, maintenance personnel and users to understand each other. does not target specific database platforms (such as Oracle or SQL Server) and tools (PowerBuilder). The objects contained in the CDM are not usually implemented in t
used, sometimes we call it a static D/A converter. However, due to the composition of the static D/A converter, it determines that it must occupy a certain amount of space and consume a certain amount of power in the system. Therefore, in system solutions that require convenient portability, the static D/A converter has to be replaced with [1].So people choose the so-called "Digital basis" D/A converter. There are two methods for digital D/A conversion: PWM (P Ulse Width Modulation) Pulse Width
Physical Data Model PDMPhysical data MODEL,PDM: After the logical structure of the database has been designed, the physical design needs to be completed, and PDM is designed to achieve this goal.The physical data model is based on the common DBMS (Database management System) theory, and the real-world model established in CDM/LDM generates the corresponding DBMS's SQL language script. The SQL script is used
1. Introduction to PDM
The Physical Data Model (Physical Data Model) PDM provides the basic elements required for the initial design of the system and the relationship between related elements; the physical design stage of the database must be detailed on the basis of the background design, including the database stored procedures, operations, triggers, views and index tables;
PowerDesigner can be used to c
Forward Engineering: PDM ---> in SQL or database projects, we often need to generate SQL scripts based on PDM and execute them together in the database. If there are many tables in PDM, it will take a lot of time for us to build one by one. We can also directly generate PDM to the database as needed.
Reverse Engineerin
Label:Some time ago with the next powerdesigner do some auxiliary work, here specifically summarized: For the migration of the SQL between the CDM, PDM, SQL and database tables between different databases, the first thing to know is what they are used for, a simple description here, not a detailed explanation. CDM: Conceptual data Model. CDM is to describe the E-r diagram in its own way.It does not take into account the physical implementation details
Label: For the migration of the SQL between the CDM, PDM, SQL and database tables between different databases, the first thing to know is what they are used for, a simple description here, not a detailed explanation. CDM: Conceptual data Model. CDM is to describe the E-r diagram in its own way. It does not take into account the physical implementation details, only represents the overall logical structure of the database, independent of any software a
Use the reverse engineering of powerdesigner to generate PDM
Source: 51cmm. com Author: Xu yixiao
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 desi
After PDM is done, the final goal is to convert it into a database entity. Here PDM presumably everybody knows is what file, right, English is PHYSIYC data model is also the physical datum models.1. Confirm that the current PowerDesigner is set to the correct DBMS, that is, whether it is the type of database we want to build, and I am using sqlserver2000 here:powerdesigner-> database-> Change the current DB
What is PDM:
Product Data Management manages design, R D, manufacturing, and other data. The Design and R D data must be synchronized with the manufacturing data, which must be paperless.
Data managed by PDM includes:
Design Information of CAD, cam, and CAE-bom, configuration file, and design File
MRP and CAD Synchronization
Process Information: workflow, approval relationship, etc.
What do
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.