John Giles - The Power of Using Data Model Patterns
May 31, 2023
auto_awesome
John Giles, a legendary figure in data modeling, discusses the power of using data model patterns, enterprise data modeling, and 'data town plans' with the host. They explore the evolution of data modeling, the importance of clear terminology, and the efficiency gained from applying data model patterns in projects. An insightful conversation that delves into the intricacies of data modeling and its impact on business analysis.
Data modeling enables efficient data sharing on a larger scale, crucial for integrated information exchange.
Standardized data models are essential to prevent miscommunication and ensure consistent information exchange, especially in critical situations.
Deep dives
Value of Data Modeling in the Current Environment
Data modeling remains valuable in today's landscape, transitioning from physical relational table design to shared and integrated data. Examples like the National Information Exchange Model in the US showcase the need for effective data sharing beyond single projects, emphasizing the importance of data modeling for efficient and consistent information exchange on a larger scale.
Impacts of Ineffective Data Sharing
The consequences of inadequate data sharing were illustrated through a tragic real-life incident involving wildfires. Miscommunication due to different terminologies led to confusion during a crisis, highlighting the critical need for standardized data models to ensure efficient and consistent exchange of information, particularly in life-threatening situations.
Challenges in Defining Data Concepts Across Different Scenarios
Defining data concepts like 'customer' can pose challenges, as illustrated by examples from insurance companies and healthcare facilities. Identifying and agreeing on definitions, such as who qualifies as a customer or how products are classified, is crucial for accurate and meaningful data analysis, necessitating collaborative efforts between technical experts and business stakeholders to reach consensus.
Data Town Planning and the Value of Established Patterns
The concept of 'data town planning' emphasizes the importance of having a strategic overview of data structures and interactions across different processes and domains. Utilizing established data modeling patterns offers a structured approach to designing data models, facilitating effective communication between technical and business teams and enabling streamlined data integration and analysis.
John Giles is a legend in the data modeling world, having authored "Nimble Elephant" and "The Elephant in the Fridge," and written extensively on the topic. John and I discuss the power of using data model patterns, enterprise data modeling, "data town plans," and much more. It was an honor to chat with John, and I felt like I was conversing with someone who comes from a more advanced dimension than most data practitioners. You'll learn a ton from this discussion.
John's website: https://www.countrye.com.au/
Books: Nimble Elephant (https://www.amazon.com/Nimble-Elephant-Delivery-Pattern-based-Approach/dp/1935504258), The Elephant in the Fridge (https://www.amazon.com/Elephant-Fridge-Success-Building-Business-Centered/dp/1634624890)