You are previewing Data Modeling Made Simple with CA ERwin Data Modeler r8.
O'Reilly logo
Data Modeling Made Simple with CA ERwin Data Modeler r8

Book Description

Data Modeling Made Simple with CA ERwin Data Modeler r8 will provide the business or IT professional with a practical working knowledge of data modeling concepts and best practices, and how to apply these principles with CA ERwin Data Modeler r8. You'll build many CA ERwin data models along the way, mastering first the fundamentals and later in the book the more advanced features of CA ERwin Data Modeler. This book combines real-world experience and best practices with down to earth advice, humor, and even cartoons to help you master the following ten objectives:

  • 1. Understand the basics of data modeling and relational theory, and how to apply these skills using CA ERwin Data Modeler

  • 2. Read a data model of any size and complexity with the same confidence as reading a book

  • 3. Understand the difference between conceptual, logical, and physical models, and how to effectively build these models using CA ERwin's Data Modelers Design Layer Architecture

  • 4. Apply techniques to turn a logical data model into an efficient physical design and vice-versa through forward and reverse engineering, for both top down and bottom-up design

  • 5. Learn how to create reusable domains, naming standards, UDPs, and model templates in CA ERwin Data Modeler to reduce modeling time, improve data quality, and increase enterprise consistency

  • 6. Share data model information with various audiences using model formatting and layout techniques, reporting, and metadata exchange

  • 7. Use the new workspace customization features in CA ERwin Data Modeler r8 to create a workflow suited to your own individual needs

  • 8. Leverage the new Bulk Editing features in CA ERwin Data Modeler r8 for mass metadata updates, as well as import/export with Microsoft Excel

  • 9. Compare and merge model changes using CA ERwin Data Modelers Complete Compare features

  • 10. Optimize the organization and layout of your data models through the use of Subject Areas, Diagrams, Display Themes, and more

Section I provides an overview of data modeling: what it is, and why it is needed. The basic features of CA ERwin Data Modeler are introduced with a simple, easy-to-follow example.

Section II introduces the basic building blocks of a data model, including entities, relationships, keys, and more. How-to examples using CA ERwin Data Modeler are provided for each of these building blocks, as well as 'real world' scenarios for context.

Section III covers the creation of reusable standards, and their importance in the organization. From standard data modeling constructs such as domains to CA ERwin-specific features such as UDPs, this section covers step-by-step examples of how to create these standards in CA ERwin Data Modeling, from creation, to template building, to sharing standards with end users through reporting and queries.

Section IV discusses conceptual, logical, and physical data models, and provides a comprehensive case study using CA ERwin Data Modeler to show the interrelationships between these models using CA ERwin's Design Layer Architecture. Real world examples are provided from requirements gathering, to working with business sponsors, to the hands-on nitty-gritty details of building conceptual, logical, and physical data models with CA ERwin Data Modeler r8.

From the Foreword by Tom Bilcze, President, CA Technologies Modeling Global User Community:

Data Modeling Made Simple with CA ERwin Data Modeler r8 is an excellent resource for the ERwin community. Through the liberal use of illustrations, the inexperienced data modeler is graphically walked through the components of data models and how to create them in CA ERwin r8. As an experienced data modeler, Steve and Donna give me a handbook for effectively using the new and enhanced features of r8 to bring my art form to life.

Table of Contents

  1. Contents at a Glance
  2. Contents
  3. Foreword
  4. Acknowledgements
    1. From Donna
    2. From Steve
  5. Read me first!
  6. SECTION I
  7. Overview
  8. CHAPTER 1
  9. Data Model Overview
    1. Wayfinding
    2. A Data Model Represents an Information Landscape
    3. Modeling Business Cards
    4. Catering for Difference Audiences and Purposes
  10. CHAPTER 2
  11. Data Model Tools Overview
    1. Data Modeling Tool Benefits
      1. Visual Simplicity
      2. Automation
      3. Reuse
      4. Governance and Audits
      5. Error-Checking and Validation
    2. Data Modeling Tool Features
  12. CHAPTER 3
  13. CA ERwin Data Modeler Overview
    1. Key Features
      1. Database Reverse Engineering and Discovery
      2. Database Forward Engineering and Design Generation
      3. Design Layer Architecture
      4. Reusable Design Standards
      5. Complete Compare
      6. Diagramming and Visualization
      7. Large Model Management
      8. Reporting and Publication
      9. Personalization and Customization
      10. Integration and Metadata Exchange with Other Tools
    2. Starting with a Sample Model – the eMovies Model
    3. Navigating the eMovies Model
    4. Creating a Model
    5. Saving Your Model
  14. SECTION II
  15. Components
  16. CHAPTER 4
  17. Entities
  18. CHAPTER 5
  19. Data Elements
  20. CHAPTER 6
  21. Relationships
  22. CHAPTER 7
  23. Keys
  24. CHAPTER 8
  25. Optimizing Model Presentation
    1. Subject Areas
    2. Diagrams
    3. Formatting Themes
    4. Drawing Objects
  26. CHAPTER 9
  27. Personalizing Your Workspace
    1. Personalizing the Workspace
    2. Customizing Toolbars
    3. Customizing Keyboard Shortcuts
    4. Using the Action Log and Undo/Redo
  28. SECTION III
  29. Standards
  30. CHAPTER 10
  31. Domains
    1. Creating Domains
  32. CHAPTER 11
  33. Validation Rules
    1. Creating Validating Rules
  34. CHAPTER 12
  35. Naming Standards
    1. Enforcing Naming Standards
    2. Using Naming Standards in a Model
    3. Checking Naming Standards Compliance
    4. Name Hardening Wizard
  36. CHAPTER 13
  37. Datatype Standards
    1. Creating Datatype Standards
  38. CHAPTER 14
  39. User-Defined Properties (UDPs)
    1. Creating UDPs
  40. CHAPTER 15
  41. Model Templates
    1. Creating Templates
  42. CHAPTER 16
  43. Reporting, Querying, and Editing
    1. Reporting using SAP Business Objects Crystal Reports
    2. Reporting and Editing using the Bulk Editor
    3. Using the Query Tool
    4. Using Metadata Bridges
  44. SECTION IV
  45. Conceptual, Logical, and Physical Data Models
  46. CHAPTER 17
  47. Conceptual Data Models
    1. Business Concept Explanation
    2. Conceptual Data Model Explanation
    3. Types of Conceptual Data Models
      1. Relational Conceptual Model
      2. Dimensional Conceptual Model
    4. How to Build a Conceptual Model
    5. Creating a Conceptual Data Model
  48. CHAPTER 18
  49. Logical Data Models
    1. Logical Data Model Explanation
    2. Comparison of Relational with Dimensional Logical Models
    3. Normalization
      1. Initial Chaos
      2. First Normal Form (1NF)
      3. Second Normal Form (2NF)
      4. Third Normal Form (3NF)
    4. Creating a Logical Data Model
  50. CHAPTER 19
  51. Physical Data Models
    1. Physical Data Model Explanation
    2. Denormalization
      1. Standard
      2. FUBES
      3. Repeating Groups
      4. Repeating Data Elements
      5. Summarization
    3. Views
    4. Indexing
    5. Partitioning
    6. Creating a Physical Data Model
      1. Reverse Engineer
      2. Complete Compare
      3. Subtyping Resolution
      4. Views
      5. Physical Naming Standards
      6. Forward Engineer
  52. Suggested Reading
    1. Books
    2. Web Sites
      1. ERwin-Specific Resources
      2. Industry Sites
  53. APPENDIX A: CA ERwin Data Modeler Toolbars
  54. APPENDIX B: Keyboard Navigations and Shortcuts
  55. Glossary
  56. Index