Feeds

Access isn’t a relational database

We're all related somehow

High performance access to file storage

Of course they are.

No, you just associate them with the model because most relational engines provide transactional control. I agree that transactions are an essential part of building databases for business applications, but they aren’t part of the relational model itself. They are an add-on to the model. You don’t have to believe me, Chris Date also thinks so: “[Transaction theory] doesn’t have much to do with the relational model as such” - Databases in Depth, P. 121, Chris Date, May 2005, O’Reilly – the book’s reviewed here.

OK, but there are other things that Access doesn’t have that are part of the relational model – like full support for all flavours of referential integrity.

Well, we can digress and argue about whether the different implementations of referential integrity are part of the relational model, but I accept the principle that Access doesn’t support the entire relational model. However, every mainstream database engine on the planet has bits and pieces of the relational model that it doesn’t support. For a start, they all use SQL which is not a particularly good match to the relational model. Chris Date again, from the interview quoted:

“So yes, I do think SQL is pretty bad. But you explicitly ask what its major flaws are. Well, here are a few:

  • “Duplicate rows;
  • “Nulls;
  • “Left-to-right column ordering;
  • “Unnamed columns and duplicate column names;
  • “Failure to support "=" properly;
  • “Pointers;
  • “High redundancy.”

So all mainstream database engines fail to support the model properly which means that Access is no different from the others, such as Oracle, that you happily classify as relational.

But what about…

And so on and so on and so on... The argument will still be raging at closing time because it’s a database argument and, by definition, no-one ever updates their views.

We are all entitled to an opinion about this myth (since it depends so much on your definition of "relational"), but at least we can try to pare the discussion down to some fundamental points.

High performance access to file storage

More from The Register

next story
Android engineer: We DIDN'T copy Apple OR follow Samsung's orders
Veep testifies for Samsung during Apple patent trial
Microsoft: Windows version you probably haven't upgraded to yet is ALREADY OBSOLETE
Pre-Update versions of Windows 8.1 will no longer support patches
OpenSSL Heartbleed: Bloody nose for open-source bleeding hearts
Bloke behind the cockup says not enough people are helping crucial crypto project
Half of Twitter's 'active users' are SILENT STALKERS
Nearly 50% have NEVER tweeted a word
Windows XP still has 27 per cent market share on its deathbed
Windows 7 making some gains on XP Death Day
Internet-of-stuff startup dumps NoSQL for ... SQL?
NoSQL taste great at first but lacks proper nutrients, says startup cloud whiz
US taxman blows Win XP deadline, must now spend millions on custom support
Gov't IT likened to 'a Model T with a lot of things on top of it'
Microsoft TIER SMEAR changes app prices whether devs ask or not
Some go up, some go down, Redmond goes silent
prev story

Whitepapers

Mainstay ROI - Does application security pay?
In this whitepaper learn how you and your enterprise might benefit from better software security.
Five 3D headsets to be won!
We were so impressed by the Durovis Dive headset we’ve asked the company to give some away to Reg readers.
3 Big data security analytics techniques
Applying these Big Data security analytics techniques can help you make your business safer by detecting attacks early, before significant damage is done.
The benefits of software based PBX
Why you should break free from your proprietary PBX and how to leverage your existing server hardware.
Mobile application security study
Download this report to see the alarming realities regarding the sheer number of applications vulnerable to attack, as well as the most common and easily addressable vulnerability errors.