Your browser version is outdated. We recommend that you update your browser to the latest version.

 

ALBERTA DATA ARCHITECTURE

PRESENTATIONS 2016


 

  2017  Presentations

 

2015  Presentations 

 

2014  Presentations 

 

 2013  Presentations 

 

 Home Page

 

 

DATA VAULT: An In-Depth Look  -  Sept 2016

Our September (2016) presenter was Juraj (Yuri) Pivovarov. Juraj has spent the last 20 years working in data related disciplines in the oil and gasindustry. These include data warehousing, data architecture, metadata management, and data modeling. He has worked at Oilfield Accounting Service (now Zedi), Divestco, CWD Inc, Nexen Cnooc Ltd, and Alberta Energy Regulator.

Data Vault is a new, agile, and scalable methodology and data modeling paradigm for designing data warehouses. The design is rooted in integration based on business keys and three simple constructs. Due to this conceptual simplification, a data vault becomes easier to load, maintain, and understand. And it's designed to accommodate changing requirements and act as an auditable system of record.

This detailed presentation will discuss what the Data Vault is, some history behind it, and explain how it fits in to a data architecture. The presentation will cover the nuts and bolts of Hubs, Links and Satellites. Going beyond the basics, there will be a discussion of peg-leg links, same-as links, hierarchical links, multi-active sats, effectivity sats and more. Also, there will be mention of some of the hidden costs and pitfalls of a data vault implementation. By the end of the talk, attendees should have a good working knowledge of Data Vault and its vocabulary and guidelines for when and when not to use it.

 

The Journey to Create a New Standard, PRODML - Nov 2016

Our November (2016) presenter was Richard Tummers. Richard is the guy who says "I’m from IT and I’m here to help”. And then actually does help. 

He has been working with DAS (Distributed Acoustic Sensing) longer than most of the patents. If you like longer summaries, there are a bunch of true words about him on LinkedIn. As technology evolves, new types of data are created. And data standards need to be extended to handle them.This presentation is a case study about developing standards for a new type of data, namely Distributed Acoustic Sensing (DAS).

 It will provide a very brief description of the currently-proposed standard, then describe the journey from pre-charter, through the development of the standard (member companies, their roles, the project charter, the project), to post-publication (support, updates). Also discussed, a perspective on the correlation between innovation, data standards and business value.

 

The Business value of Data Modeling - Jan 2016

Our January presenter was Ron Huizenga. Ron is the lead Product Manager for ER/Studio at Embarcadero. Ron has over 30 years of experience as an IT executive and consultant in Enterprise Data Architecture, Governance, Business Process Reengineering and Improvement, Program/Project Management, Software Development and Business Management. His experience spans multiple industries including: manufacturing, supply chain, pipelines, natural resources, retail, health care, insurance and transportation.

With changes in software development methodologies, the role of the data modeler has changed significantly. In order to participate fully, modelers must not only adapt to an Agile work style, but must also be able to communicate and deliver business value through model-driven development. With content from a real case study, Ron Huizenga will show the contrast in metrics and cost when utilizing skilled data modelers versus a development-only approach.

 

Approach to Implementing a Canadian Well Master Header -  May 2016

A Well Header Master is a central system to store, manage, and make available ‘master’ well data for all your company's wells and interest wells. Having gone live in January, Devon Canada will present the process, decisions, and approach to building a business case, prioritizing requirements and selecting a solution partner to implement a Well Header Master for the Canadian asset teams.