PowerDesigner OLAIS  

Sample Class

Go to:

Views

Generating DDL and DML

• Selecting objects
• Selecting object types
• Setting RI preferences
• Output options

Technical keys and identity options

• Synonyms: artificial key, serial key, synthetic key, pseudo key, counter
• Criteria for deciding between "natural" keys versus technical keys
  • Avoiding embedded business rules
  • Keeping sensitive natural keys private
  • Uniform key structure
  • Easy SQL and applications code writing
  • Understandability to users
  • Stability vs likilhood of system controlled update
  • Join skipping levels
  • Minimum physical I/O
  • Conservation of storage space
• The Identity feature for technical keys

Reporting and printing

Reviewing PowerDesigner's forward generation

• Top to bottom - down only
• Preservation options
• The OID problem with MetaWorks
• DEF and CDF files
• DDL script post processing
• Generating laterally into other target platforms

Putting it all together in a modeling lifecycle

• Partitioning tasks
• Sharing models
• Consolidating multiple models
• Reconciling changes
• Version control
• Version promotion

See Also

© © 1997-2000 Applied Information Science