Feeds

Access isn’t a relational database

We're all related somehow

Secure remote control for conventional and virtual desktops

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.

Top 5 reasons to deploy VMware with Tegile

More from The Register

next story
New 'Cosmos' browser surfs the net by TXT alone
No data plan? No WiFi? No worries ... except sluggish download speed
iOS 8 release: WebGL now runs everywhere. Hurrah for 3D graphics!
HTML 5's pretty neat ... when your browser supports it
Mathematica hits the Web
Wolfram embraces the cloud, promies private cloud cut of its number-cruncher
Mozilla shutters Labs, tells nobody it's been dead for five months
Staffer's blog reveals all as projects languish on GitHub
'People have forgotten just how late the first iPhone arrived ...'
Plus: 'Google's IDEALISM is an injudicious justification for inappropriate biz practices'
SUSE Linux owner Attachmate gobbled by Micro Focus for $2.3bn
Merger will lead to mainframe and COBOL powerhouse
iOS 8 Healthkit gets a bug SO Apple KILLS it. That's real healthcare!
Not fit for purpose on day of launch, says Cupertino
prev story

Whitepapers

Secure remote control for conventional and virtual desktops
Balancing user privacy and privileged access, in accordance with compliance frameworks and legislation. Evaluating any potential remote control choice.
Intelligent flash storage arrays
Tegile Intelligent Storage Arrays with IntelliFlash helps IT boost storage utilization and effciency while delivering unmatched storage savings and performance.
WIN a very cool portable ZX Spectrum
Win a one-off portable Spectrum built by legendary hardware hacker Ben Heck
High Performance for All
While HPC is not new, it has traditionally been seen as a specialist area – is it now geared up to meet more mainstream requirements?
Beginner's guide to SSL certificates
De-mystify the technology involved and give you the information you need to make the best decision when considering your online security options.