blogs.conchango.com

Browse by Tags

• best practice
• Business Intelligence
• Data Architect
• Data Integration
• Master Data Management
• MDM
• Oil and Gas
• PPDM
• SOA
• SOBI
• user experience

• MDM axioms

  This week The Galloping Data Architect and I are attending the Gartner MDM conference in Hollywood, Florida. As the week has gone on I've been making a note of quotes that I hear or conclusions that I draw myself whilst listening to the various speakers Read More... Posted 20 September 2007 23:07 by jamie.thomson | 3 Comments Filed under: Data Architecture, Data Integration, MDM, Master Data Management

• Are you balanced or unbalanced?

  I was recently asked by a colleague about my opinions on unbalanced (sometimes called ragged) versus balanced hierarchies in data modelling. Other people have described the differences between unbalanced and balanced hierarchies before me so instead of Read More... Posted 30 August 2007 23:23 by jamie.thomson | 6 Comments Filed under: Data Architecture, MDM

• The power of schema abstraction

  Gert Drapers has posted a really good article today which you can read here . In it he suggests a best practice of always putting a view layer in between your database tables and the consumers of your data. He explains some scenarios where this technique Read More... Posted 12 July 2007 18:02 by jamie.thomson | 2 Comments Filed under: Data Architecture, best practice

• Service Orientation in Oil and Gas (Part 5) - Attempting to solve the Master Data problem

  In my last post I explained a little about the Master Data Management (MDM) problem that we have faced on my current project. At its very core building an MDM system is a data modelling exercise and in this post I'm going to talk about the data model Read More... Posted 08 February 2007 06:32 by jamie.thomson | 6 Comments Filed under: Oil and Gas, SOBI, Data Architecture, Data Integration, Data Architect, MDM, Master Data Management Attachment(s): Generic_MDM_Model.zip

• Service Orientation in Oil and Gas (Part 4) - The Master Data problem

  So far in this series I have introduced you (somewhat) to SoBI and now I'd like to introduce you to one of the enabling initiatives that we have undertaken. First, a bit of history. In the summer of 2005 the purveyors of SoBI realised that in order Read More... Posted 07 February 2007 05:04 by jamie.thomson | 2 Comments Filed under: Oil and Gas, SOBI, Data Architecture, Data Integration, SOA, Data Architect, MDM, Master Data Management

• Ensuring data quality

  Richard Wand , a colleague of mine here at Conchango , has posted an interesting article here that talks about whether a web site owner should give their browsers the ability to type in their title (e.g. Mrs, Mr, Dr...etc) or just offer them a list of Read More... Posted 07 February 2007 00:28 by jamie.thomson | 3 Comments Filed under: Data Architecture, Data Integration, user experience

• Service Orientation in Oil and Gas (Part 3) - An industry standard data model

  My last post provided a concise overview of what I think SoBI is. It talked about service facades, BI caches and data consumers, and it placed an emphasis on data quality in the Systems Of Record (SoRs). In that post I talked about how data that is required Read More... Posted 04 February 2007 19:13 by jamie.thomson | 3 Comments Filed under: Business Intelligence, Oil and Gas, SOBI, Data Architecture, PPDM