The DOBlog

Blog

  • Economic meltdown for Starbucks

    The Irish Times website is carrying a story today that Starbucks has experienced a downturn in coffee sales in the US in recent months and is not as economically bulletproof as they may have previously thought.

    This makes perfect sense to me. When your negative equity hell kicks in and leaves a sour and bitter taste in your mouth and curdles your stomach, the absolute last thing you need to drink is a cup of overpriced shit coffee that will only add to your intenstinal woes.

    And for the record, I’m a big coffee drinker. I gave it up for Lent once. The children of Bolivia apparently had no new shoes for Easter Mass. It’s just that what American’s call coffee I, erm… um… don’t.

  • Ex-Python possibly maybe to write for Obama

    So, according to the Irish Examiner, John Cleese has hinted that he may offer his services as a speech-writer to Barrack Obama should Obama get the Democratic nomination.

    Oh good grief.

    Hilary Clinton has no option now but to go after Eric Idle to counteract the gag-meistery of Cleese. I’m looking forward to her speech to the Democratic Convention where she reminds delegates that Obama “Isn’t the Messiah, he’s a very naughty boy!” and other choice quotes from The Life of Brian.

  • On the great big Bertie Bye Bye

    From time to time the DoBlog allows honoured guests to write posts (well I would if anyone asked). When I’m stuck for honoured guests, sometimes I invite family, and I even let them get a byline on the piece. No cuttypasty-and-claim-as-my-own here thanky much.

    This post is penned by the brother. If he would actually get off his backside and do a proper blog hisself (he lives over at “Another Crying Shame“) I’m sure the O Brien clan would soon be festooned with Obsessive Blogger badges from Fergal Crehan.

    So… here’s the brother’s take on the Great Big Bertie Bye Bye:

    While it’s certainly good news in a visceral ‘Death to my Enemies’ kind of way I think it will in the long run mean very little or even be a bad thing for the Irish body politic
    (more…)

  • The Electoral Register (Here we go again)

    The Irish Times today carries a story on page five which details a number of proposed changes to the management of the Electoral Register arising from the kerfuffle of the past two years about how totally buggered it is. For those of you who don’t know, I’ve written a little bit about this in the past (earning an Obsessive Blogger badge in the process donchaknow). It was just under two years ago that I opened this blog with a post on this very topic…

    A number of points raised in the article interest me, if for no other reason than they sound very familiar – more on that anon. Other interest me because they still run somewhat counter to the approach that is needed to finally resolve the issue.

    I’ll start with the bits that run counter to the approach required. The Oireachtas Committee has been pretty much consistent in its application of the boot to Local Authorities as regards the priority they give to the management of the Electoral Register. According to the Irish Times article, the TDs and Senators found that:

    “Running elections is not a core function of local authorities. Indeed, it is not a function that appears to demand attention every year. It can, therefore, be questioned if it gets the priority it warrants under the array of authorities”

    I must humbly agree and disagree with this statement. By appearing to blame Local Authorities for the problem and for failing to prioritise the management of the Electoral Register, the Committee effectively absolves successive Ministers for the Environment and other elected officials from failing to ensure that this ‘information asset’ was properly maintained. Ultimately, all Local Authorities fall under the remit of the Minister for Environment, Heritage and Local Government. As the ‘supreme being’ in that particular food chain, the Minister (and their department) is in a position to set policy, establish priorities and mandate adequate resourcing of any Local Authority function, from Water Services to Electoral Franchise.

    The key issue is that Franchise section was not seen as important by anyone. A key information asset was not managed, no continual plans were put in place for the acquisition of information or the maintenance of information. Only when there were problems applying the information did anyone give a darn. This, unfortunately, is a problem that is not confined to Local Government and Electoral data however – a large number of companies world wide have felt the pain of failing to manage the quality of their information assets in recent times.

    Failing to acknowledge that the lack of management priority was systemic and endemic within the entire hierarchy of Central and Local Government means that a group of people who probably tried to do their best with the resources assigned to them are probably going to feel very aggrieved. “The Register is buggered. It’s your fault. We’re taking it away from you” is the current message. Rather it should be “The system we were operating is broken. Collectively there was a failure to prioritise the management of this resource. The people tried to make it work, but best efforts were never enough. It needs to be replaced.”

    W. Edward’s Deming advised people seeking to improve quality to ‘drive out fear’. A corollary of that is that one should not engage in blame when a system is broken unless you are willing to blame all actors in the system equally.

    However, I’m equally guilty as I raised this issue (albeit not in as ‘blaming’ a tone) back in… oh 2006.:

    “Does the current structure of Local Authorities managing Electoral Register data without a clear central authority with control/co-ordination functions (such as to build the national ‘master’ file) have any contribution to the overstatement of the Register?“

    Moving on to other points that sound very familiar…

    1. Errors are due to a “wide variety of practices” within Local Authorities. Yup, I recall writing about that as a possible root cause back in 2006. Here and here and here and here and here in fact.
    2. The use of other data sources to supplement the information available to maintain the Register is one suggestion. Hmmm… does this sound like it covers the issue?

      3. Could the Electoral Register process make use of a data source of people who are moving house (such as An Posts’s mail redirection service or newaddress.ie)? How can that be utilised in an enhanced process to manage & maintain the electoral register? These are technically surrogate sources of reality rather than being ‘reality’ itself, but they might be useful.

      That’s from a post I wrote here on the 24th April 2006.

      And then there’s this report, which was sent to Eamon Gilmore on my behalf and which ultimately found its way to Dick Roche’s desk while he was still the Minister in the DOELG. Pages 3 to 5 make interesting reading in light of the current proposals. Please note the negatives that I identified with the use of data from 3rd party organisations that would need to be overcome for the solution to be entirely practicable. These can be worked around with sound governance and planning, but bumbling into a solution without understanding the potential problems that would need to be addressed will lead to a less than successful implementation.

    3. The big proposal is the creation of a ‘central authority’ to manage the Electoral Register. This is not new. It is simply a variation on a theme put forward by Eamon Gilmore in a Private Member’s Bill which was debated back in 2006 and defeated at the Second Stage(The Electoral Registration Commissioner Bill, 2005). This is a proposal that I also critiqued in the report that wound its way to Dick Roche… see pages 3 to 5 again. I also raise issues of management and management culture at page 11.
    4. The use of PPS numbers is being considered but there are implications around Data Protection . Hmm… let’s see… I mentioned those issues in this post and in this post.

      5. And it further assumes that the PPS Identity is always accurate (it may not be, particularly if someone is moving house or has moved house. I know of one case where someone was receiving their Tax Certs at the address they lived in in Dublin but when they went to claim something, all the paperwork was sent to their family’s home address down the country where they hadn’t lived for nearly 15 years.)

      In my report in 2006 (and on this blog) I also discussed the PPS Number and the potential for fraud if not linked to some form of photographic ID given the nature of documents that a PPS number can be printed on in the report linked to above. This exact point was referenced by Senator Camillus Glynn at a meeting of the Committee last week

      “I would not have a difficulty with using the PPS card. It is logical, makes sense and is consistent with what obtains in the North. The PPS card should also include photographic evidence. I could get hold of Deputy Scanlon’s card. Who is to say that I am not the Deputy if his photograph is not on the card? Whatever we do must be as foolproof as possible.”

      This comment was supported by a number of other committee members.

    So, where does that leave us? Just under two years since I started obsessively blogging about this issue, we’ve moved not much further than when I started. There is a lot of familiarity about the sound-bites coming out at present – to put it another way, there is little on the table at the moment (it seems) that was not contained in the report I prepared or on this blog back in 2006.

    What is new? Well, for a start they aren’t going to make Voter Registration compulsory. Back in 2006 I debated this briefly with Damien Blake… as I recall Damien had proposed automatic registration based on PPS number and date of birth. I questioned whether that would be possible without legislative changes or if it was even desirable. However, the clarification that mandatory registration is now off the table is new.

    The proposal for a centralised governance agency and the removal of responsibility for Franchise /Electoral Register information from the Local Authorities sounds new. But it’s not. It’s a variation on a theme that simply addresses the criticism I had of the original Labour Party proposal. By creating a single agency the issues of Accountability/Responsibility and Governance are greatly simplified, as are issues of standardisation of forms and processes and information systems.

    One new thing is the notion that people should be able to update their details year round, not just in a narrow window in November. This is a small but significant change in process and protocol that addresses a likely root cause.

    What is also new – to an extent – is the clear proposal that this National Electoral Office should be managed by a single head (one leader), answerable to the Dail and outside the normal Civil Service structures (enabling them to hire their own staff to meet their needs). This is important as it sets out a clear governance and accountability structure (which I’d emphasised was needed – Labour’s initial proposal was for a Quango to work in tandem with Local Authorities… a recipe for ‘too many cooks’ if ever I’d heard one). That this head should have the same tenure as a judge to “promote independence from government” is also important, not just because of the independence and allegiance issues it gets around, but also because it sends a very clear message.

    The Electoral Register is an important Information Asset and needs to be managed as such. It is not a ‘clerical’ function that can be left to the side when other tasks need to be performed. It is serious work for serious people with serious consequences when it goes wrong.

    Putting its management on a totally independent footing with clear accountability to the Oireachtas and the Electorate rather than in an under-resourced and undervalued section within one of 34 Local Authorities assures an adequate consistency of Governance and a Constancy of Purpose. The risk is that unless this agency is properly funded and resourced it will become a ‘quality department’ function that is all talk and no trousers and will fail to achieve its objectives.

    As much of the proposals seem to be based on (or eerily parallel) analysis and recommendations I was formulating back in 2006, I humbly put myself forward for the position of Head of the National Elections Office 😉

  • A memoir in 6 words

    Darren over at the Crabbling Otter has laid down a challenge to me, which was in turn given to him by GrannyMar. The challenge is to write my memoir in six words. It is harder then you think. I normally take 20 words to say hello and forty eight to say goodbye.

    Worked diligently, invested time, achieved joy.

    That’s my starter for 10. But if I was allowed 10 there’d be four more words to play with… bugger.

  • Information Society – be careful what you wish for… it might come true

    Simon over at Tuppenceworth shared his thoughts yesterday on comments by our Minister for the Information Society and another Public Servant on bloggers at a conference that had nothing to do with blogging (’twas about Software Quality and testing).

    [Update – Imagine my shock when I found the speech on the Dept of the Taoiseach website…scroll down to the section on Innovation and see the exact terms used by the Minister responsible for the Information Society. On one hand he has a point, but it could have been phrased a lot more… politically]

    As usual, bloggers have shaken their fists or slapped their foreheads in disbelief at what it seems was said.

    Now now children. Comparing a Junior Minister to a scooby doo villain is impolite if chucklesomely accurate. Also, it is just possible that they may having been having a go at BOGGERS – an equally maligned group that is misunderstood and misrepresented by ‘traditional’ media. (Just watch Killnascully for the evidence). [Sadly that was not the case, as evidenced by the text of the speech]

    I was at the conference in question and having thought about it overnight I think the Local Government Computing Services person’s comments should probably be taken in the context of decisions to adopt open standards or not… bloggers are all for mashups and open standards based solutions as it is the “Web2.0 thing”. However if it all falls apart because the person making the widget that holds it together stops maintaining their stuff then you get kicked. If you are a blogger your site goes down or comments don’t work or your google maps mashup goes on its arse.

    If you’re a government organisation you end up on the front page of the Irish Times… “Government IT investment fiasco”. The we bloggers chip in and the spin and bluster gets questioned and then your day goes from ‘challenging’ to ‘fricking nightmare’ in a matter of hours. But guess what… project managers in the private sector have to put up with that stuff too. I have no sympathy. Lots of empathy though.

    Looking back at notes from that presentation, at the time he made the comments about bloggers he was discussing Open Source solutions. His point was simply that Open Source solutions bring a degree of risk with them, particularly if they are being adapted for use in a given context – if an Open Source solution falls in the forest and there is no developer community to hear it, is your solution f*cked?

    That is a risk that all companies have to balance between Open Source and Proprietary solutions. His mistake, as I would see it, has been to take criticism from bloggers about decisions a little bit too personally. Of course, if the bloggers turned out to be right in their criticisms then that might make things sting even more.

    Another presenter on the day gave a good insight into how to pick Open Source tools though.. he recommended only picking stuff from SourceForge with 90% or higher activity showing a maintained and managed piece of software, not a hobby project.

    Also bloggers are not synonymous with Open Standards/Open Source developers. We’re just as screwed if someone moves the cheese and useful piece of software or useful standard stops being supported (PHP4 vs PHP5 for example… too many webhosts are still running PHP4 while Open Source developers are moving to PHP5 based apps – I think of Drupal and CiviCRM as examples. Hosting providers who can’t support PHP5 leave organisations using Open Source tools like civicrm stuck on less effective or efficient and unsupported versions of the applications. A bit like a proprietary vendor end-of-lifing an application).

    I’ve written extensively on this blog over the past two years about information management/information quality issues in government processes (PPARS, Electoral Register, IBTS etc) so I think I might fall in to the category of annoying and obsessive bloggers. However, and I’m open to correction, I do believe that I’ve ‘played the ball and not the man’ at each turn, with my focus being on leadership (ie Ministers) and on sound practices (many people I spoke to yesterday who had happened on my blog said nice things about my IBTS posts). And I’ve never shied away from debating the point to build a better understanding of issues.

    Importantly, I believe that my posts and comments have been fairly balanced. I did my best to argue that the problem in PPARs wasn’t the software or the project team but the sheer mind numbing complexity of consoldiating non-standard data and divergent processes into a system that requires standards and standardisation. Each ‘custom’ work calendar represented a ‘customisation’ in the application – ergo the cost. The project team did a great job to achieve anything with the mess they were given to start with. The electoral register… I put the blame were it needed to be – on the Minister who is responsibile for defining strategy and allocating resources. I analysed the root causes and issues and criticsed the door to door clean up because it wasn’t a solution and it wasn’t operated consistently. I won’t mention the IBTS in detail but to say… harrumph – and watch this space (I’m not finished there).

    Tom Kitt’s comments, however, baffle me as it did seem to be a throw away remark triggered by some deep seated frustration. Perhaps my focus on Dick Roche’s bumbling mis-management of the Electoral Register issue and John Gormely’s apparent lack of a sense of urgency to implement the legislative changes required to correct the processes (rather than pissing around on the edges doing scrap and rework and working with a marketing company to design a new logo for the department that looks like three snails in an orgy) have irked the political classes? Perhaps the blogger commentary on the Mahon Tribunal have peeved the Fianna Fail leadership?

    Perhaps some blogger has written something nasty about Minister Kitt’s offsprung, the folksy crooner David Kitt? (Twenty – if you did … tut tut). Maybe he read some comments about the car in the re-invented Knightrider TV show and took them out of context?

    Who knows.

    What I do know is that an Information Society starts with an informed community that shares information. Blogs and blogging provides an opportunity for informed people with experience and insights into niche areas and obscure disciplines to share their thoughts and views on things.

    Occassionally that means that the type of person who, in the Service would never be left alone in the same timezone as a Minister because they are hard-core techie (beard, jumper and sandals with socks – and that’s just the wimmin) and are passionate about a solution or approach that is not ‘status quo’, can find a platform to make their opinion known. An occasionally a newspaper picks up on that (not, sadly, in the case of the Electoral Register) and it gets a broader airing.

    More often, it means that people who have experience in a particular industry, process or discipline but might otherwise have no access to media can peer behind the spin and bluster put out by the political classes and their handlers and by public sector organisations to raise questions about what might have happened really or suggest alternative approaches for consideration. If that makes people uncomfortable then tough. An informed society requires higher standards.

    However, Marshall McLuhan’s view that ‘the medium is the message’ has gone the way of the dodo. The medium is not the message. Not all bloggers are good. Not all bloggers are informed. Not all bloggers want to criticise constructively. But to dismiss all bloggers and their opinions with a frustrated sigh is to miss the point completely (a bit like Mr Waters did).

    The blog is the medium. The message comes from each blogger as an individual member of society.

    An Information Society. (tada!)

    Of course, to counter the criticism bloggers need to up their game and take a moment’s pause to engage their brains a bit before letting their fingers to the talking. The right speak does not guarantee you the right to be heard. But speaking well, clearly and appropriately, with sound ideas that you are willing to accept critique on (as long as that critique likewise plays the ball and not the man) increases the chance that people will want to listen to you.

    By improving the quality of your personal blogging you improve the quality of the Information Society. By ensuring that you have checked your facts (or are willing to correct errors quickly) you improve the Information Quality in this Information Society. Then we will find ourselves in a functioning, citizen supported, Information Society.

    Another aspect of Tom Kitt’s alleged comments might also relate to the fact that there are a sizeable proportion of the population who aren’t bloggers (yet). Government needs to manage for the needs of the State as a whole, not just the needs of lobby groups or hobby groups or bloggers. (I’m shitting myself laughing as I write this)

    Informed lobby groups (trade unions, IBEC, the SFA, even the late lamented IrelandOffline) influence Government policy to various extents. The media affects government policy (if it gets criticised in the media the Minister may hold off pushing the policy, particularly around election time). Grumpy old men walking around outside Leinster House with placards on their backs… well they don’t really achieve anything on their own (perhaps they should blog).

    Whether you blog or not does not deprive you of your right as a citizen to seek to affect and effect change in government. So, you can seek to influence through an established media fair play.. get your op ed piece in The Irish Times, go on Questions and Answers and rip the token politician a new one (or punch right wing columnists who haven’t got a clue about the real world), write your letters to the editor, or start a pressure group and doorstep your elected representatives. Fair play to you.

    Or you can start a blog to raise awareness of the issue (perhaps combined with the other approaches). If the handful of bloggers who have written specifically about Information Society issues or the challenges of may government/quasi-government IT projects and performed a critique of the strategy (or lack of), best practices (or lack of) or solutions (or lack of) that were delivered can raise the frustrated ire of the Minister responsible for the Information Society then we’re a pretty darned effective group.

    If the government chooses to dismiss your opinions because you are not an established lobby group or because you are just ‘citizens’ then there is something rotten in the pre-Information Society society.

    Minister for the Information Society… we’re bloggers. We’re here. We’re informed and we want to be social, socially active, active on social issues, and to build a strong foundation for a ‘realised information society’. Some of us are already elected officials, some of us might consider running for office. Some of us might be advisors to your opposition. It’s not because we’re bloggers. It’s because we’re citizens.

    Dismiss us if you want, but like the smell of boiling cabbage on a hot summer’s day we’re not going away in a hurry. To paraphrase Al Pacino in Scent of a Woman:

    “Makers of an Information Society. Creators of an Information Society.Be careful what kind of Information Society you’re producin’ here.

    hoo hah.

    (of course, that cuts both ways – bloggers need to seek to seperate the ‘signal’ from the ‘noise’ so that good blogs and bloggers can be distinguished from waffle and bile).

    But I still can’t f**king stand David Kitt’s music and the Knightrider car is just dire (sorry).

  • Final post and update on IBTS issues

    OK. This is (hopefully) my final post on the IBTS issues. I may post their response to my queries about why I received a letter and why my data was in New York. I may not. So here we go..

    First off, courtesy of a source who enquired about the investigation, the Data Protection Commissioner has finished their investigation and the IBTS seems to have done everything as correct as they could, in the eyes of the DPC with regard to managing risk and tending to the security of the data. The issue of why the data was not anonymised seems to be dealt with on the grounds that the fields with personal data could not be isolated in the log files. The DPC finding was that the data provided was not excessive in the circumstances.

    [Update: Here’s a link to the Data Protection Commissioner’s report. ]

    This suggests to me that the log files effectively amounted to long strings of text which would have needed to be parsed to extract given name/family name/telephone number/address details, or else the fields in the log tables are named strangely and unintuitively (not as uncommon as you might think) and the IBTS does not have a mapping of the fields to the data that they contain.

    In either case, parsing software is not that expensive (in the grand scheme of things) and a wide array of data quality tools provide very powerful parsing capabilities at moderate costs. I think of Informatica’s Data Quality Workbench (a product originally developed in Ireland), Trillium Software’s offerings or the nice tools from Datanomic.

    Many of these tools (or others from similar vendors) can also help identify the type of data in fields so that organisations can identify what information they have where in their systems. “Ah, field x_system_operator_label actually has names in it!… now what?”.

    If the log files effectively contained totally unintelligible data, one would need to ask what the value of it for testing would be, unless the project involved the parsing of this data in some way to make it ‘useable’? As such, one must assume that there was some inherent structure/pattern to the data that information quality tools would be able to interpret.

    Given that according to the DPC the NYBC were selected after a public tender process to provide a data extraction tool this would suggest that there was some structure to the data that could be interpreted. It also (for me) raises the question as to whether any data had been extracted in a structured format from the log files?

    Also the “the data is secure because we couldn’t figure out where it was in the file so no-one else will” defence is not the strongest plank to stand on. Using any of the tools described above (or similar ones that exist in the open source space, or can be assembled from tools such as Python or TCL/TK or put together in JAVA) it would be possible to parse out key data from a string of text without a lot of ‘technical’ expertise (Ok, if you are ‘home rolling’ a solution using TCL or Python you’d need to be up to speed on techie things, but not that much). Some context data might be needed (such as a list of possible firstnames and a list of lastnames, but that type of data is relatively easy to put together. Of course, it would need to be considered worth the effort and the laptop itself was probably worth more than irish data would be to a NYC criminal.

    The response from the DPC that I’ve seen doesn’t address the question of whether NYBC failed to act in a manner consistent with their duty of care by letting the data out of a controlled environment (it looks like there was a near blind reliance on the security of the encryption). However, that is more a fault of the NYBC than the IBTS… I suspect more attention will be paid to physical control of data issues in future. While the EU model contract arrangements regarding encryption are all well and good, sometimes it serves to exceed the minimum standards set.

    The other part of this post relates to the letter template that Fitz kindly offered to put together for visitors here. Fitz lives over at http://tugofwar.spaces.live.com if anyone is interested. I’ve gussied up the text he posted elsewhere on this site into a word doc for download ==> Template Letter.

    Fitz invites people to take this letter as a starting point and edit it as they see fit. My suggestion is to edit it to reflect an accurate statement of your situation. For example… if you haven’t received a letter from the IBTS then just jump to the end and request a copy of your personal data from the IBTS (it will cost you a few quid to get it), if you haven’t phoned their help-line don’t mention it in the letter etc…. keep it real to you rather than looking like a totally formulaic letter.

    On a lighter note, a friend of mine has received multiple letters from the Road Safety Authority telling him he’s missed his driving test and will now forfeit his fee. Thing is, he passed his test three years ago. Which begs the question (apart from the question of why they are sending him letters now)… why the RSA still has his application details given that data should only be retained for as long as it is required for the stated purpose for which it was collected? And why have the RSA failed to maintain the information accurately (it is wrong in at least one significant way).

  • IBTS… returning to the scene of the crime

    Some days I wake up feeling like Lt. Columbo. I bound out of bed assured in myself that, throughout the day I’ll be niggled by, or rather niggle others with, ‘just one more question’.

    Today was not one of those days. But you’d be surprised what can happen while going about the morning ablutions. “Over 171000 (174618 in total) records sent to New York. Sheesh. That’s a lot. Particularly for a sub-set of the database reflecting records that were updated between 2nd July 2007 and 11th October 2007. That’s a lot of people giving blood or having blood tests, particularly during a short period. The statistics for blood donation in Ireland must be phenomenal. I’m surprised we can drag our anaemic carcasses from the leaba and do anything; thank god for steak sandwiches, breakfast rolls and pints of Guinness!”, I hummed to myself as I scrubbed the dentation and hacked the night’s stubble off the otherwise babysoft and unblemished chin (apologies – read Twenty Major’s book from cover to cover yesterday and the rich prose rubbed off on me).

    “I wonder where I’d get some stats for blood donation in Ireland. If only there was some form of Service or agency that managed these things. Oh.. hang on…, what’s that Internet? Silly me.”

    So I took a look at the IBTS annual report for 2006 to see if there was any evidence of back slapping and awards for our doubtlessly Olympian donation efforts.

    According to the the IBTS, “Only 4% of our population are regular donors” (source: Chairperson’s statement on page 3 of the report). Assuming the population in 2006 (pre census data publication) was around 4.5 million (including children), this would suggest a maximum regular donor pool of 180,000. If we take the CSO data breaking out population by age, and make a crude guess on the % of 15-24 year olds that are over 18 (we’ll assume 60%) then the pool shrinks further… to around 3.1 million, giving a regular donor pool of 124000 approx.

    Hmm… that’s less than the number of records sent as test data to New York based on a sub-set of the database. But my estimations could be wrong.

    The IBTS Annual Report for 2006 tells us (on page 13) that

    The average age of the donors who gave blood
    in 2006 was 38 years and 43,678 or 46% of our
    donors were between the ages of 18 and 35
    years.

    OK. So let’s stop piddling around with assumptions based on the 4% of population hypothesis. Here’s a simpler sum to work out… If X = 46% of Y, calculate Y.

    (43678/46)X100 = 94952 people giving blood in total in 2006. Oh. That’s even less than the other number. And that’s for a full year. Not a sample date range. That is <56% of the figure quoted by the IBTS. Of course, this may be the number of unique people donating rather than a count of individual instances of donation… if people donated more than once the figure could be higher.

    The explanation may also lie with the fact that transaction data was included in the extract given to the NYBC (and record of a donation could be a transaction). As a result there may be more than one row of data for each person who had their data sent to New York (unless in 2007 there was a magical doubling of the numbers of people giving blood).

    According to the IBTS press release:

    The transaction files are generated when any modification is made to any record in Progesa and the relevant period was 2nd July 2007 to 11th October 2007 when 171,324 donor records and 3,294 patient blood group records were updated.

    (the emphasis is mine).

    The key element of that sentence is “any modification is made to any record”. Any change. At all. So, the question I would pose now is what modifications are made to records in Progresa? Are, for example, records of SMS messages sent to the donor pool kept associated with donor records? Are, for example, records of mailings sent to donors kept associated? Is an audit trail of changes to personal data kept? If so, why and for how long? (Data can only be kept for as long as it is needed). Who has access rights to modify records in the Progresa system? Does any access of personal data create a log record? I know that the act of donating blood is not the primary trigger here… apart from anything else, the numbers just don’t add up.

    It would also suggest that the data was sent in a ‘flat file’ structure with personal data repeated in the file for each row of transaction data.

    How many distinct person records were sent to NYBC in New York? Was it

    • A defined subset of the donors on the Progresa system who have been ‘double counted in the headlines due to transaction records being included in the file? ….or
    • All donors?
    • Something in between?

    If the IBTS can’t answer that, perhaps they might be able to provide information on the average number of transactions logged per unique identified person in their database during the period July to October 2007?

    Of course, this brings the question arc back to the simplest question of all… while production transaction records might have been required, why were ‘live’ personal details required for this software development project and why was anonymised or ‘defused’ personal data not used?

    To conclude…
    Poor quality information may have leaked out of the IBTS as regards the total numbers of people affected by this data breach. The volume of records they claim to have sent cannot (at least by me) be reconciled with the statistics for blood donations. They are not even close.

    The happy path news here is that the total number of people could be a lot less. If we assume ‘double dipping’ as a result of more than one modification of a donor record, then the worst case scenario is that almost their entire ‘active’ donor list has been lost. The best case scenario is that a subset of that list has gone walkies. It really does boil down to how many rows of transaction information were included alongside each personal record.

    However, it is clear that, despite how it may have been spun in the media, the persons affected by this are NOT necessarily confined to the pool of people who may have donated blood or had blood tests peformed between July 2007 and October 2007. Any modification to data about you in the Progresa System would have created a transaction record. We have no information on what these modifications might entail or how many modifications might have occured, on average, per person during that period.

    In that context the maximum pool of people potentially affected becomes anyone who has given blood or had blood tests and might have a record on the Progressa system.

    That is the crappy path scenario.

    Reality is probably somewhere in between.

    But, in the final analysis, it should be clear that real personal data should never have been used and providing such data to NYBC was most likely in breach of the IBTS’s own data protection policy.

  • So what did the IBTSB do right?

    In the interests of a bit of balance, and prompted by some considered comment by Owen O’Connor on Simon’s post over on Tuppenceworth, I thought it might be worth focussing for a moment on what the IBTSB did right.

    1. They had a plan that recognised data security as a key concern.
    2. They specified contract terms to deal with how the data was to be handled. (these terms may have been breached by the data going on an unexpected tour of New York)
    3. They made use of encryption to protect the data in transit (there is no guarantee however that the data was in an encrypted state at all times)
    4. They notified promptly and put their hands up rather than ignoring the problem and hoping it would go away. That alone is to be commended.

    So they planned relatively well and responded quickly when shit hit the fan. The big unknown in all of this is whether the data has been compromised. If we assume happy path, then the individual in an organisation which had a contractual obligation to protect the security of the data but took it home anyway kept the data encrypted on the laptop. This may indeed be the case. I

    t could also be the case that this person didn’t appreciate the obligations owed and precautions required and, apart from removing the data from a controlled and securable environment, had decrypted the data to have a poke around at it. That is the crappy path.

    Ultimately it is a roll of the dice as to which you put your trust in.

    In previous posts I have asked why production data was being used for a test event and why it had not been anonymised or tweaked to reduce its ability to identify real individuals. In his comment over on Tuppenceworth, Owen O’Connor contends that

    the data being examined was to do with the actual usage and operation of the IBTS system

    If the data that was being examined was log files for database transactions then one might query (no pun intended) why personal identifying data was included. If it was unavoidable but to send sample records (perhaps for replication of transaction events?) then this might actually be in accordance with the IBTSB’s data protection policy. But if the specifics of names etc. were not required for the testing (ie if it was purely transactional processing that was being assesed and not, for example, the operation of parsing or matching algorithms) then they should have and could have been mangled to make them anonymous with out affecting the validity of any testing that was being done.

    If a sound reason for using real data exists that is plausible and warranted the level of risk involved then (having conducted similar testing activities myself during my career) I’d be happy that the IBTSB had done pretty much everything they could reasonably have been asked to do to ensure security of the data. The only other option I would possibly have suggested would be remote access to data held on a server in Ireland which would have certainly meant that no data would have been on a laptop in New York (but latency on broadband connections etc. might have mitigated against accurate test results perhaps).

    In the Dail, the IBTSB has come in for some stick for their sloppy handling. Owen O’Connor is correct however – the handling of the spin has been quite good and most of the risk planning was what would be expected. If anyone is guilty of sloppy handling it is the NYBC who acted in breach of their agreement (most likely) by letting the data out of the controlled environment of their offices.

    So, to be clear, I feel for the project manager and team in the IBTSB who are in the middle of what is doubtless a difficult situation. But for the grace of god (and a sense of extreme paranoia in the planning stages of developer test events) go I. The response was correct. Get it out in the open and bring in the Data Protection commissioner as soon as possible. The planning was at least risk-aware. They learned from Nixon (it’s the cover up that gets you)

    However, if there was not a compelling reason for real data about real people being used in the testing that could not have been addressed with either more time or mor money then I would still contend that the use of the production data was ill-advised and in breach of the IBTSB’s own policies.

  • More thoughts on the IBTS data breach

    One of the joys of having occasional bouts of insomnia is that you can spend hours in the dead of night pondering what might have happened in a particular scenario based on your experience and the experience of others.

    For example, the IBTS has rushed to assure us that the data that was sent to New York was encrypted to 256bit-AES standard. To a non-technical person that sounds impressive. To a technical person, that sounds slightly impressive.

    However, a file containing 171000+ records could be somewhat large, depending on how many fields of data it contained and whether that data contained long ‘free text’ fields etc. When data is extracted from database it is usually dumped to a text file format which has delimiters to identify the fields such as commas or tab characters or defined field widths etc.

    When a file is particularly large, it is often compressed before being put on a disc for transfer – a bit like how we all try to compress our clothes in our suitcase when trying to get just one bag on Aer Lingus or Ryanair flights. One of the most common software tools used (in the microsoft windows environment) is called WinZip. It compresses files but can also encrypt the archive file so that a password is required to open it. When the file needs to be used, it can be extracted from the archive, so long as you have the password for the compressed file. winzip encryption screenshot.
    So, it would not be entirely untrue for the IBTS to say that they had encrypted the data before sending it and it was in an encrypted state on the laptop if all they had done was compressed the file using Winzip and ticked the boxes to apply encryption. And as long as the password wasn’t something obvious or easily guessed (like “secret” or “passw0rd” or “bloodbank”) the data in the compressed file would be relatively secure behind the encryption.

    However, for the data to be used for anything it would need to be uncompressed and would sit, naked and unsecure, on the laptop to be prodded and poked by the application developers as they went about their business. Where this to be the case then, much like the fabled emperor, the IBTS’s story has no clothes. Unencrypted data would have been on the laptop when it was stolen. Your unencrypted, non-anonymised data could have been on the laptop when it was stolen.

    The other scenario is that the actual file itself was encrypted using appropriate software. There are many tools in the market to do this, some free, some not so free. In this scenario, the actual file is encrypted and is not necessarily compressed. To access the file one would need the appropriate ‘key’, either a password or a keycode saved to a memory stick or similar that would let the encryption software know you were the right person to open the file.

    However, once you have the key you can unencrypt the file and save an unencrypted copy. If the file was being worked on for development purposes it is possible that an unencrypted copy might have been made. This may have happened contrary to policies and agreements because, sometimes, people try to take shortcuts to get to a goal and do silly things. In that scenario, personal data relating to Irish Blood donors could have wound up in an unencrypted state on a laptop that was stolen in New York.

    [Update**] Having discussed this over the course of the morning with a knowledgable academic who used to run his own software development company, it seems pretty much inevitable that the data was actually in an unencrypted state on the laptop, unless there was an unusual level of diligence on the part of the New York Blood Clinic regarding the handling of data by developers when not in the office.

    The programmer takes data home of an evening/weekend to work on some code without distractions or to beat a deadline. To use the file he/she would need to have unencrypted it (unless the software they were testing could access encrypted files… in which case does the development version have ‘hardened’ security itself?). If the file was unencrypted to be worked on at home, it is not beyond possiblity that the file was left unencrypted on the laptop at the time it was stolen.

    All of which brings me back to a point I made yesterday….

    Why was un-anonymised production data being used for a development/testing activity in contravention to the IBTS’s stated Data Protection policy, Privacy statement and Donor Charter and in breach of section 2 of the Data Protection Act?

    If the data had been fake, the issue of encryption or non-encryption would not be an issue. Fake is fake, and while the theft would be embarrassing it would not have constituted a breach of the Data Protection Act. I notice from Tuppenceworth.ie that the IBTSB were not quick to respond to Simon’s innocent enquiry about why dummy data wasn’t used.