Data Modeling Made Simple with erwin DM

Master erwin DM to deliver robust and precise designs for both operational and analytical projects.

Steve and Jeff start from the basics, explaining data modeling concepts and how to get up and running with erwin DM (erwin DM). Through a hands-on approach, business analysts, data professionals, and project managers will learn step-by-step how to build effective conceptual, logical, and physical data models. Complete the stages in identifying essential business requirements, designing the logical data model, transposing those logical modeling objects into physical tables and columns, and even generating the implementation database scripts.

This book contains seven parts. Part I provides a foundation in data modeling and Part II a foundation in erwin DM. Part III covers the design layer technique and its application using erwin DM, distinguishing conceptual, logical, physical, and operational data models. Part IV covers entities, domains, attributes, key groups, validation rules, default rules, and subject areas, along with how to implement them using erwin DM. Part V explains the physical data model and how to convert a logical data model to a physical data model in erwin DM. Become confident creating tables, columns, indexes, and views. Part VI reveals advanced features available within erwin DM, including user defined properties, naming standards, forward engineering, reverse engineering, complete compare, report designer, and the bulk editor. Part VII explains several important tools to use in combination with erwin DM, including erwin DM NoSQL, erwin Data Catalog, and erwin Data Literacy.

Jeff Harris is Principal Data Architect for a Fortune 200 company. He has over 30 years of IT experience and has specialized in data modeling and data architecture for over 20 years. His experience has led him to work on erwin DM projects for large corporations in South Africa, New Zealand, Europe, UK, and the USA, in banking, government, logistics, retail, freight, and petroleum. His expertise includes the implementation of data warehouses, operational data stores, and enterprise data architectures.

Steve Hoberman has trained more than 10,000 people in data modeling since 1992. Steve is known for his ability to translate from business requirements to technical specifications. Steve is the author of nine books on data modeling, including the bestsellers Data Modeling Made Simple and The Rosedata Stone. One of Steve's frequent data modeling consulting assignments is to review data models using his Data Model Scorecard® technique. He is the creator of the Data Modeling Institute's Data Modeling Certification exam, Data Modeling Zone Conference Chair, lecturer at Columbia University, and recipient of the Data Administration Management Association International Professional Achievement Award.