Our privacy is protected by massively inefficient enterprise IT systems...

Our privacy is protected by massively inefficient enterprise IT systems...

Summary: Corporate databases are huge, and hugely inefficient -- which translates into built-in personal data privacy. Oracle is your best friend...

SHARE:

There continues to be lots of chatter about personal data privacy, and it is an important issue. But what is missing from the debates is that we have a large measure of built-in protection – the ineptitude of IT systems is a huge protective factor.

Let me explain, with this amusing tale from my ZDNet colleague Dennis Howlett.

Dennis is an Englishman living in Spain. He tells of trying to make changes to his account at Vodafone Spain. Vodafone Spain saps my will to live

Each time you call, it seems necessary to go through a grinding series of questions that include the number you are calling from (they don't have caller ID?), providing your passport or residency number, your password and bank name. Then you have to slowly and carefully explain the problem. At least twice.

... Vodafone claimed they have no record of my landline number or that I have requested that service. Duh? I have SMS messages telling me they activated the service on my mobile. I"m staring at them. 'We have no record.'

...Knowing what it is like dealing with anything that smacks of government or utilities, I pack every piece of paper I can think that will successfully identify me as the person I say I am. At the Vodafone shop I get the same answer. No record.

Thinking laterally, I ask if there is anything registered to the new DSL service and oh by the way, can you search against THAT phone number? Bingo! Up pops the details Vodafone said it didn't have.

It turns out that when I acquired my Vodafone mobile, I gave my passport number. When I applied for DSL etc, I gave my NIE (resident's) number because that is what it asked for. Vodafone doesn't match these and cannot alter what it now sees as the master identifying record locator. So now it seems I have two accounts.

It's a frustrating story but in a way, it is uplifting in the context of data privacy. Vodafone is a large IT user with massive data centers, yet its databases can't handle a simple match between just two pieces of data.

The dirty little secret of enterprise IT systems is that while they do store a lot of data, they are terrible at using that data. Relational database systems are extremely difficult to query, it can take weeks to design and run set of queries against the data. All major corporations have these relational database systems.

We thus have a large measure of protection from egregious uses of our personal data because of the inefficiency of corporate IT systems.

And this situation won't change anytime soon, even though far more efficient database technologies are available (such as Mark Logic). No company wants to mess with its core database systems -- a lucrative secret that Oracle discovered a long time ago.

Companies will rip out and replace servers but they will do everything they can to keep their databases intact -- it's core to their business.

Facebook, Google, and many others, are using specialist databases, some that they've developed themselves to overcome the limitations of relational database systems. But, because those databases are customized for their unique uses, it is very difficult to map their data against data in other types of databases. Using people's personal data to sell products and services is very difficult.

So, while we do need to be concerned about the commercialization of our personal data, and campaign for tougher controls, the likelihood that corporations will be able to use all that personal data in a meaningful way is very low. Data goes in, but getting it out in a useful way is shockingly difficult.

There is even more good news: inefficient database systems will continue to dominate the Fortune 1000 for many years. Database architectures have to remain the same because they have to maintain backward compatibility.

It could be said that the biggest defender of our data privacy is Oracle and its massive installed base of relational database systems.


Topics: Software, Data Centers, Data Management, Enterprise Software, Hardware, Legal, Storage

Kick off your day with ZDNet's daily email newsletter. It's the freshest tech news and opinion, served hot. Get it.

Talkback

1 comment
Log in or register to join the discussion
  • Seriously?

    Comparing a database platform that has to handle unstructured media data to one that has to keep track of the day-to-day business of a telecom company? Seriously?<br><br>noSQL DBs are far from a silver bullet. Not every business is trying to implement their own private version of Facebook or Twitter. For the record, I feel that noSQL databases, just like hierarchical data storage systems, have their uses.<br><br>The Vodafone example you cite is case of bad design, something that can be achieved with just about any data/information management technology. Unless, of course, the developers at Facebook are deities; in which case, I should probably re-assess my religious beliefs.<br><br>Let's just hope that in the interest of fairness that you come back with an equally critical blog post denouncing whatever large corporation quadruple-bills 2/3 of their customers as a result of their choice to implement their accounting system with BigTable.<br><br>Haven't you heard of "horses for courses"? Sometimes you need comprehensive data durability and transactional consistency, sometimes you don't.<br><br>"yet its databases cant handle a simple match between just two pieces of data"<br><br>Seriously? Isn't it more than plausible that the people working on the project made horrid decisions? Are we really supposed to believe "the RDBMS made me do it"?<br><br>Have you ever even worked with a RDBMS since 1982? What is your basis for "Relational database systems are extremely difficult to query, it can take weeks to design and run set of queries against the data."? Sure, it's not something that can be implemented as quickly as performing a search on the ZDNet blogs for "hack journalist". Those who can, do. Those who can't, criticize. <br><br>RDBMS = closed? Seriously? A data management platform whose core data access language is defined by both ISO and ANSI standards? A data storage platform that has countless vendor tools with which to access data? In fact, you'd be hard pressed to come up with a list of less than 10 data access tools that can access data from Oracle or SQL Server.<br><br>I have my own distaste for Oracle, let's at least be fair here. You didn't mention Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL. Holy cannoli? Did I just cite open source software? If you really want old, inefficient data silos, at least try looking up some real culprits like PICK or MUMPS/Cache.<br><br>Maybe it's just time you go back to updating your MySpace page and leave the authoritative declarations to people who base their conclusions on a little more than anecdotes.
    philhelmer@...