The DAMA Dictionary of Data Management Enterprise Server

by Steve Hoberman

Overview

Data Modeling Made Simple with PowerDesigner 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 PowerDesigner. You'll build many PowerDesigner data models along the way, increasing your skills first with the fundamentals and later with more advanced feature of PowerDesigner. This book combines real-world experience and best practices to help you master the following ten objectives:

This book has ten key objectives for you, the reader:

1. You will know when a data model is needed and which PowerDesigner models are the most appropriate for each situation
2. You will be able to read a data model of any size and complexity with the same confidence as reading a book
3. You will know when to apply and how to make use of all the key features of PowerDesigner
4. You will be able to build, step-by-step in PowerDesigner, a pyramid of linked data models, including a conceptual data model, a fully normalized relational data model, a physical data model, and an easily navigable dimensional model
5. You will be able to apply techniques such as indexing, transforms, and forward engineering to turn a logical data model into an efficient physical design
6. You will improve data governance and modeling consistency within your organization by leveraging features such as PowerDesigner’s reference models, Glossary, domains, and model comparison and model mapping techniques
7. You will know how to utilize dependencies and traceability links to assess the impact of change
8. You will know how to integrate your PowerDesigner models with externally-managed files, including the import and export of data using Excel and Requirements documents
9. You will know where you can take advantage of the entire PowerDesigner model set, to increase the success rate of corporate-wide initiatives such as business intelligence and enterprise resource planning (ERP)
10. You will understand the key differentiators between PowerDesigner and other data modeling tools you may have used before

Product Details

ISBN-13:	9780977140091
Publisher:	Technics Publications, LLC
Publication date:	04/28/2009
Edition description:	TECHNICS PUBLICATIONS LLC
Pages:	600
Product dimensions:	8.50(w) x 10.90(h) x 1.30(d)

Table of Contents

CHAPTER 1: What is a data model? 27
CHAPTER 2: Why do we need a data model? 35
SECTION II: Data Model Components 41
CHAPTER 3: What are entities? 43
CHAPTER 4: What are data elements? 49
CHAPTER 5: What are relationships? 53
CHAPTER 6: Why are names and definitions important? 63
CHAPTER 7: What are keys? 71
SECTION III: Data Modeling in PowerDesigner 79
CHAPTER 8: Why do we need a data modeling tool? 81
CHAPTER 9: What can PowerDesigner do for me? 87
CHAPTER 10: How can we work within the PowerDesigner environment? 103
CHAPTER 11: How do I create entities in PowerDesigner? 205
CHAPTER 12: How do I create data elements in PowerDesigner? 213
CHAPTER 13: How do I create relationships in PowerDesigner? 255
CHAPTER 14: How do I create keys in PowerDesigner? 287
SECTION IV: Subject Area, Logical, and Physical Data Models 307
CHAPTER 15: What are subject area models? 311
CHAPTER 16: What are logical data models? 333
CHAPTER 17: What are physical data models? 385
CHAPTER 18: How can we connect these models in PowerDesigner? 425
SECTION V: Consolidating What We've Learned 435
CHAPTER 19: How do we put all of the pieces together? 437
SECTION VI: More Great Stuff in PowerDesigner for Data Modelers 445
CHAPTER 20: What other data modeling features exist in PowerDesigner? 447
CHAPTER 21: How do we get information in and out of PowerDesigner? 457
CHAPTER 22: How can PowerDesigner help me improve data model quality? 467
CHAPTER 23: What other components in PowerDesigner can be leveraged by data modelers? 475
SECTION VII: Beyond Data Modeling in PowerDesigner 493
CHAPTER 24: What's different about the XML Physical Data Model? 495
CHAPTER 25: What other models are available in PowerDesigner? 499