Av rating:
Total votes: 52
Total comments: 12


Phil Factor
The Data Dialog
30 January 2007
Boss: Phil, this strategy paper that you've written on our corporate data integration policy. Look, I'm the IT director and even for me it's pretty opaque. Damned difficult to read, in fact!
Phil [blushing modestly]: Why, thank you. I try to do my best.
Boss: But damn it, Phil, we can't present this to the board for signoff! What is it actually trying to say?
Phil: Well, in essence, it says that our new data systems will cost twice as much as we predicted, and take twice as long to implement. And, by the way, our last project that promised to take an integrated approach to the problem of corporate data management crashed and burned without trace.
Boss: What!? I never read about any of that!
Phil: [pointing]: It's right there on page 3, tucked into that long paragraph near the end…
Boss: Damn it again, Phil. How often do I have to tell you that we senior staff only like to read the first page of these documents?
Phil: Precisely! We just need to make sure they can't claim that they were never informed about the outcome of our IT initiatives. We don't want them to actually read it…that would be disastrous.
Boss: …and what about all these terms in the document…MDM, BI, CDI, PIM, ERP, ETL, EAI, EII, EIS, ST, SOA and SDM?
Phil: They are all examples of IDC (Initials Designed to Confuse), also known as ADH (Acronyms Designed to Humiliate). They are very useful ammunition against the Geeks when they try the same tactics with their .NET and J2EE jargon but, as is the case here, they are mainly used to browbeat Business managers with our knowledge and intellect.

Many IT initiatives are so complex as to be mystical quasi-religions. They are difficult to criticize because their proponents can always sorrowfully shake their heads and protest that you simply don't understand enough about them.
Boss: [sighing wearily]: What about this part here…the analysis of the current system. What does this mean? [pointing]
Phil: [peering over his shoulder]:
'Diverse system architectures' means that the bloody computer systems can't communicate; 'diverse business functions' means that even the business can't communicate; a 'meta-data abstraction layer' is the database equivalent of Harvester Tape. Referring to a 'consistent information framework' means that at least the column names in the databases are the same and mean the same thing. Where I refer to people as 'stakeholders', it means I don't know what the heck they contribute to the business, or can't remember the right word for it. If an IT system 'gives micro and macro business process capabilities', it means that it 'does stuff'
Boss: You are going at it pretty strong on the past failings and mistakes of IT! Aren't you overdoing it?
Phil: Curiously, any business is only too ready to believe that IT makes mistakes; I sprinkle in these confessions to give the whole document verisimilitude.
Boss: OK but why then leave out the two biggest mistakes of all…the Business Re-Engineering project and the Data-Warehousing project?
Phil: Because the business management still remember how much they paid IT to implement them. It may have a negative impact if we confess they were blind alleys. Also, if we mention those, they may also spot that this new MDM (Master Data Management) strategy is just a re-arrangement of the furniture to sell the same old apartment.
Boss: So what is the purpose of this document? It doesn't provide information.
Phil: [shocked]: Thank goodness! IT business documents aren't there to provide "information"! They are there to provide cover and concealment for our real activities
Boss: Come on Phil, don't be so silly, and just rephrase the entire document so that ordinary mortals like me can understand it. Tell me what it means as though I was a chum at the golf club
Phil: [apprehensively]: Are you absolutely sure you want that?
Boss: Of course, get on with it man!
Phil: [gulping nervously]:

OK…

Once upon a time, IT departments used to appoint someone to keep tabs on what data was held by the company, what the business understood about that data and the sort of processes that happened to that data. This person, usually a grizzled Systems Analyst (or Data Architect), would ensure that there was a common understanding of all the real entities involved, such as customers, products, employees, and the processes that acted upon them, such as releases, recalls, invoices, and so on. He would maintain a document, usually called a Data Dictionary or Data Model, which could be read and understood by anyone, and provided a basis for each individual IT project. Any misunderstandings were soon ironed out, and the activity was an essential part of strategic planning.

When the cyclic downturns in IT happened, it became tempting to get rid of this chore. The Data Architect, or whatever he was called, was packed off with an ornamental mantel clock under his arm, and there seemed to be no dire consequences. It all seemed painless. The integrity, and shared understanding, of Corporate data didn't seem to be an important asset after all.

However, with mergers, acquisitions and restructurings, many enterprises, including our own, have struggled to keep a consistent culture and nomenclature. The first sign of the disease is the increasing number of anomalies that seem to slip in to the company reports. Often, the root cause of such anomalies is laughably crude, such as the case when one division of a major bank counted a customer as a person who had one or more accounts, whereas another counted a customer as an account-holder.

The problems quickly became endemic and the only solution was to perform a major business-re-engineering. This suited the hotheads, but led to several high-profile disasters. The idea of 'Data Warehousing' was an attractive panacea, as it meant that nobody had to confront the essential problem of 'data-confusion' within the business. One could fiddle with the messy data and pummel it into a logical state, from which one could gather all that vital business information and reporting. Most bought into the dream.

Many a silver-haired ex-Data Architect will have smiled as he sat in his deck-chair, reading about the vast cost and wasted effort involved in implementing a dream that couldn't live up to its promise. If data is fundamentally unsound, no manipulation can help it. As they say in Essex, 'you can't turn turds into plum pudding'.

With this company's adoption of distributed architectures and complex messaging, the opportunities for confusion have increased. Whereas, one once had just to keep a consensus on what business entities comprised at the data layer, now one has to browbeat anyone who has the wit to nail an XML message together.

So we now come to the point where what this paper is suggesting is a type of Master Data Management initiative. We once more realise the importance of understanding the 'corporate metadata', the consensus on how the corporate entities are understood and accounted, and the nature of the processes that act on them. We understand a service-based approach to data and we now have the technology to integrate this model into our IT systems. And, ironically, it is only now that we have come to realize the importance of that ancient Systems analyst poring over his obscure diagrams of boxes and arrows. His prolonged absence is the reason why this new data system will now cost so much, and take so long to implement. And we still might not get it right…

Boss: Hmm. On second thoughts, I doubt if the business is really ready for the truth. Perhaps we'll go back to your original three-pager.
Phil: [relieved] I think it will have the effect that we want.


This article has been viewed 3969 times.
Phil Factor

Author profile: Phil Factor

Phil Factor (real name withheld to protect the guilty), aka Database Mole, has 20 years of experience with database-intensive applications. Despite having once been shouted at by a furious Bill Gates at an exhibition in the early 1980s, he has remained resolutely anonymous throughout his career.

Search for other articles by Phil Factor

Rate this article:   Avg rating: from a total of 52 votes.


Poor

OK

Good

Great

Must read
 
Have Your Say
Do you have an opinion on this article? Then add your comment below:
You must be logged in to post to this forum

Click here to log in.


Subject: Bad, bad, bad.
Posted by: nigelrivett (view profile)
Posted on: Tuesday, February 06, 2007 at 11:10 AM
Message: Bit concerned.
Too true to life.
Articles like this should be classified before they start jeopardising the high value projects.

I always think it's fun when companies get rid of highly paid but capable staff.
Last company the boss said (not about me) "I'm not worried about losing you just concerned about the head count". As long as they were fully staffed they didn't worry if the people had the skills to do the job things were getting slower as they were building on things that didn't really work.

Subject: Yes, Minister?
Posted by: jtklopcic (view profile)
Posted on: Wednesday, February 07, 2007 at 12:29 PM
Message:
Did anyone else have flashbacks to a Sir Humphrey monologue in the old "Yes, Minister" series?

Subject: data dollars
Posted by: Anonymous (not signed in)
Posted on: Wednesday, February 07, 2007 at 6:04 PM
Message: This goes back to a very old saying, that applies directly to this..."Pay me now or pay me later". We so rarely get, something for nothing.

Subject: on the money
Posted by: bernblack (view profile)
Posted on: Thursday, February 08, 2007 at 7:59 AM
Message: I've been asked to report amount billed and amount collected on 3 different systems. No one can tell what this is on 2 of them....I'll guess ....and since noone will look at the report anyway..........we're doomed.

Subject: Don't worry, be Agile
Posted by: Anonymous (not signed in)
Posted on: Thursday, February 08, 2007 at 1:24 PM
Message: Don't worry, the "old guard" aren't really needed anymore, not with our spiffy, new, "Agile" processes. Just do that "Agile" stuff, whatever it is, and you'll never have to worry about documentation or design. (snicker)

Subject: reminds me
Posted by: nigelrivett (view profile)
Posted on: Friday, February 09, 2007 at 6:16 PM
Message: Reminds me of when a company was bringing in performance metrics. They counted the lines of code people wrote.
They spotted that comments should be omitted - so the guy who put a 20 line header on each module (mostly 4-5 lines of code) lost out.

The coder who looked really good was the one who, if he had to do something 10 times, instead of a loop would copy the code 10 times.
We had to convert out code to catch up with him.

We came out well in the company because we were working in assembler which always means a lot of code to do anything. Those poor people who could add two numbers in one statement.
And the C coders who put the whole program on one line.

Subject: when is an SSN and SSN field?
Posted by: Anonymous (not signed in)
Posted on: Sunday, February 11, 2007 at 9:24 PM
Message: I worked on a project to build user account records from a Franchies data base. The franchise analyst owning the database could not understand the concept of data integrity. They had a employer ID that they kept putting into the SSN field which failed the edits in my system which foolishly expected a valid SSN. This was in addition to the company name with numbers, imbedded blanks, and special characters getting put into the Last Name field for a person. They did not think this was a problem because it worked in their system. Of course that worked, but not if you want to integerate with any other system! Imagine how our Data Wharehousing/Data Mining projects will fare with this garbage.

Subject: Data Dictionary - Too inflexible
Posted by: Anonymous (not signed in)
Posted on: Friday, February 23, 2007 at 4:45 PM
Message: The idea of everyone having a common understanding of a piece of data is outdated. It constrains what you might personally want to use it for.

Subject: re: Data Dictionary - Too inflexible
Posted by: Anonymous (not signed in)
Posted on: Sunday, May 06, 2007 at 4:52 PM
Message: [quote]The idea of everyone having a common understanding of a piece of data is outdated. It constrains what you might personally want to use it for.[/quote]

that depends how you define "common understanding" - you can always define what a piece of data is - this is separate from defining how it will be used.

Subject: Harvester Tape
Posted by: Anonymous (not signed in)
Posted on: Friday, May 11, 2007 at 3:32 PM
Message: I must be getting old. Or not old enough. I had to look up the word proem the other day because I'd never seen it before. Now I am completely befuddled by the the Harvester Tape reference. Can someone help me feel like there's something else I clearly should already have known?

Subject: Re: Harvester Tape
Posted by: Phil Factor (view profile)
Posted on: Saturday, May 12, 2007 at 5:24 AM
Message: Actually I call it Duct Tape, but the editor keeps berating me for being too 'British'. Harvester Tape is very strong sticky tape used by farmers in particular to hold machinery together when bits drop off. It is great for temporarily sticking things together when they fall apart or blocking off holes. Every toolbox should have a roll. I even use it for clamping wood whilst the glue sets, as it has quite a bit of flexibility.
I didnt know what a proem is either (it is a prelude or preface)

Subject: Duct tape
Posted by: Anonymous (not signed in)
Posted on: Tuesday, May 15, 2007 at 5:38 PM
Message: Also known as gaffer tape.
And somehow, I suspect the comment about a data dictionary being too inflexible was irony in action;-)

 









Phil Factor
The Wrong Fabia
 There is often more than a twinge of embarrassment when an Email goes astray, and is received by the wrong person.... Read more...



 View the blog
Ziggurats, Batman and the Town Crier
 We asked Brian for a description of the Help System for the software he's working on and ends up... Read more...

SQL Toolbelt 2008: Predominantly an Engineering Task
 The conversion of the Red-Gate tools to be compatible with SQL Server 2008 might not seem, on first... Read more...

Audit Crosschecks
 In this short article, the second of a 2-part series, William suggests a solution, using SQL Data... Read more...

Discovering Security Uses for SQL Compare
 Much of the security of SQL Server is implemented as part of the database schema. This provides some... Read more...

XML Jumpstart Workbench
 In which Robyn and Phil decide that the best way of starting to learn XML is to jump in and take a ride... Read more...

Beginning SQL Server 2005 Reporting Services Part 1
 Steve Joubert begins an in-depth tour of SQL Server 2005 Reporting Services with a step-by-step guide... Read more...

Ten Common Database Design Mistakes
 Database design and implementation is the cornerstone of any data centric project (read 99.9% of... Read more...

SQL Server Full Text Search Language Features
 SQL Full-text Search (SQL FTS) is an optional component of SQL Server 7 and later, which allows fast... Read more...

Beginning SQL Server 2005 Reporting Services Part 2
 Continuing his in-depth tour of SQL Server 2005 Reporting Services, Steve Joubert demonstrates the most... Read more...

Executing SSIS Packages
 Nigel Rivett demonstrates how to execute all SSIS packages in a given folder using either an SSIS... Read more...

Over 150,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.

Join Simple Talk