EDW

Catching up on the backlog of papers – I’ve added my 2010 EDW presentation on generating XML Schemas from models

George McGeachieLeave a comment

Looking at the amount of material I prepared for this 2010 presentation, I do wonder how I possibly thought I could do it justice in just one hour, including two live product demonstrations 

When I first came across XML Schemas, I was struck by their simplicity and versatility. When I saw how some people use them, I realised that the days of unmanaged COBOL copybooks had returned to haunt me.

This was my attempt to exorcise the XML demon. For this relaunch on my blog I’ve added back the hidden slides, and added a few notes – it’s still essentially the 2010 presentation, so it’s likely that some of my comments on tool capabilities are out of date.

Click here to view – Papers

“Making It Real” – Establishing the Interdependence of Data Governance and Your Data Models #mdmdg

George McGeachieLeave a comment

“Data governance is at the heart of all data management activities and is heavily reliant on effective data modelling. This is a two-way interdependency. Neither can work effectively without the other.”

In May 2018, Chris Bradley (@inforacer) and I will be running a full-day seminar on this topic at “Data Governance Conference Europe” in London. If you want to find out more, click on this link – https://irmuk.co.uk/events/data-governance-conference-europe – and we’ll see you there.

In the workshop, we describe real-world data governance processes, based upon years of experience with major clients, and the accompanying data modelling practices and additional information required to manage change effectively, including data lineage. Then it will be time for you to put those processes to the test, pushing proposed changes through the data governance pipeline, in which you are a key participant. Will our apparently perfect processes and data modelling practices hold up?

 

“Making It Real” – Establishing the Interdependence of Data Governance and Your Data Models #edw2018

George McGeachieLeave a comment

“Data governance is at the heart of all data management activities and is heavily reliant on effective data modelling. This is a two-way interdependency. Neither can work effectively without the other.”

In April 2018, Chris Bradley (@inforacer) and I will be running a half-day seminar on this topic at Enterprise Data World in San Diego. If you want to find out more, click on this link – https://edw2018.dataversity.net/sessionPop.cfm?confid=121&proposalid=9515 – and we’ll see you there.

In the workshop, we describe real-world data governance processes, based upon years of experience with major clients, and the accompanying data modelling practices and additional information required to manage change effectively, including data lineage. Then it will be time for you to put those processes to the test, pushing proposed changes through the data governance pipeline, in which you are a key participant. Will our apparently perfect processes and data modelling practices hold up?

 

Joining the dots – mapping expectations to reality #EDW14

George McGeachieLeave a comment

I had some good news today – my speaking proposal for EDW next year was accepted. My topic this time is “Joining the dots – mapping expectations to reality“.

Data models are often developed in total isolation, resulting in islands of disconnected metadata. Those data models could describe the transition of data from web form to database, from requirements to implementation, from ERP system to Data Warehouse, from Data Warehouse to data mart to report, from messaging standard to SOA messages, but they can’t do that unless you join them together. Call the connections what you like, you need to create them to make sense of the context of your data.

Most of the places I go to have data models (even if only a few data models), but they’re very rarely connected to anything else, not even to each other, so I’m going to talk about how you decide what to connect, and how to connect them. I’m going to use my ‘metadata archipelago‘ analogy to illustrate this, and cover the following points.

•             the whys and wherefores of data model mappings
•             how the data model pyramid can help you determine the mappings you need
•             automating the creation of model mappings
•             how to prioritize your efforts
•             how to exploit those mappings
•             who you need to have on your side

If you have any personal experiences you’d like to share with me about what has or hasn’t made a difference for you, please contact me using the link at the top of the blog screen.