TABLE OF CONTENTS
Conceptual Data Modelling: A Practitioner's Pocket Handbook · Volume 1
Introduction Foreword- About this handbook and how to use it
- The align, refine, and design framework
- 1.1 Definition and Purpose
- 1.2 Where Conceptual Modelling Sits in the Lifecycle
- 1.3 The Align Phase
- 1.4 What Is and Is Not In Scope
- 2.1 An Iterative Approach
- 2.2 Step 1: Identify Stakeholders
- 2.3 Step 2: Extract Key Concepts
- 2.4 Step 3: Use Business Language
- 2.5 Step 4: Define Entities Clearly
- 2.6 Step 5: Validate Regularly
- 2.7 Managing Stakeholder Collaboration
- 3.1 The Entity Relationship Diagram (ERD)
- 3.2 The Business Glossary
- 3.3 The Data Dictionary
- 4.1 GDPR and the Data Modeller
- 4.2 Classifying Personal Data
- 4.3 Encryption and Masking: Practical Examples
- 4.4 The Modeller's Governance Contributions
- 4.5 Common Governance Challenges
- 5.1 Overview of the Debate
- 5.2 The Case for Conceptual Modelling
- 5.3 The Graduated View
- 5.4 The Full Logical Business Model Approach
- 5.5 Synthesis and Practical Guidance
- 6.1 The Problem
- 6.2 The Ownership Dispute
- 6.3 The Proposed Solution: A Two-Tier Ownership Model
- 6.4 Making the Case to Product Owners
- 6.5 What Was Not Fully Resolved
- 6.6 A Practical Path Forward
- 6.7 Lessons from the Enterprise
- 7.1 Technical Skill Is Necessary but Not Sufficient
- 7.2 The Stakeholder Access Problem
- 7.3 The Danger of Agreeing to Unrealistic Targets
- 7.4 Stakeholder Management and Upward Management Are Equal Skills
- 7.5 The Human Side Is the Hard Side
- 7.6 A Reflection for Practitioners
- The Align Phase Checklist
- ERD: What to Include at Conceptual Stage
- GDPR Data Classification Summary
- Glossary of Key Terms
- A final word for practitioners
- Connect with the author on LinkedIn
Volume 1 of the Data Modelling Series · By Inderjit Thind, MRes (Computer Science), TOGAF Certified
www.linkedin.com/in/inderjit-thind
TABLE OF CONTENTS
Conceptual Data Modelling: A Practitioner's Pocket Handbook · Volume 1
Introduction Foreword- About this handbook and how to use it
- The align, refine, and design framework
- 1.1 Definition and Purpose
- 1.2 Where Conceptual Modelling Sits in the Lifecycle
- 1.3 The Align Phase
- 1.4 What Is and Is Not In Scope
- 2.1 An Iterative Approach
- 2.2 Step 1: Identify Stakeholders
- 2.3 Step 2: Extract Key Concepts
- 2.4 Step 3: Use Business Language
- 2.5 Step 4: Define Entities Clearly
- 2.6 Step 5: Validate Regularly
- 2.7 Managing Stakeholder Collaboration
- 3.1 The Entity Relationship Diagram (ERD)
- 3.2 The Business Glossary
- 3.3 The Data Dictionary
- 4.1 GDPR and the Data Modeller
- 4.2 Classifying Personal Data
- 4.3 Encryption and Masking: Practical Examples
- 4.4 The Modeller's Governance Contributions
- 4.5 Common Governance Challenges
- 5.1 Overview of the Debate
- 5.2 The Case for Conceptual Modelling
- 5.3 The Graduated View
- 5.4 The Full Logical Business Model Approach
- 5.5 Synthesis and Practical Guidance
- 6.1 The Problem
- 6.2 The Ownership Dispute
- 6.3 The Proposed Solution: A Two-Tier Ownership Model
- 6.4 Making the Case to Product Owners
- 6.5 What Was Not Fully Resolved
- 6.6 A Practical Path Forward
- 6.7 Lessons from the Enterprise
- 7.1 Technical Skill Is Necessary but Not Sufficient
- 7.2 The Stakeholder Access Problem
- 7.3 The Danger of Agreeing to Unrealistic Targets
- 7.4 Stakeholder Management and Upward Management Are Equal Skills
- 7.5 The Human Side Is the Hard Side
- 7.6 A Reflection for Practitioners
- The Align Phase Checklist
- ERD: What to Include at Conceptual Stage
- GDPR Data Classification Summary
- Glossary of Key Terms
- A final word for practitioners
- Connect with the author on LinkedIn
Volume 1 of the Data Modelling Series · By Inderjit Thind, MRes (Computer Science), TOGAF Certified
www.linkedin.com/in/inderjit-thind