Feeds

Multivalue datatypes

What a lot of people like repeating groups...

Choosing a cloud hosting partner with confidence

Editors blog Mark Whitehorn's recent article on multivalue data types in Access (here) sure attracted some comments.

No, multivalue fields (non-atomic fields or repeating groups as I think I remember them) are not new. I didn't like them when I was an IMS DBA back in the eighties - and I met most of the arguments in favour of them back then. But, whatever Oracle does, they aren't part of a "proper" relational database.

To set the matter straight and to avoid unnecessary email traffic:

  • Yes, we have heard of Dick Pick;
  • yes, we do realise that multivalued datatypes can sometimes be used safely if you're careful; or your DBMS is (a bit like GoTos, and with similar caveats);
  • yes, we do realise that databases like U2, ADABAS etc have their uses and that Cache is actually a very interesting database, which is much more than just a modern implementation of Pick or Mumps...

However, I still think that Relational Theory (as in Codd's ACM paper) is a "good thing" and that it simplifies the delivery of reliable, resilient systems in the "real world"; and that XML columns, fields containing sets, Blobs and similar modern non-relational additions, while expedient, re-introduce some of the issues which lead to IMS (which I know very well), say, being replaced with DB/2 or other RDBMSs - in general.

And, FWIW, I do also realise that IMS, as well as IDMS, CA Datacom and other legacy databases are still in active use, because the benefits from keeping them (and, as well as the simple replacement and regression-testing costs, there are sometimes resource/performance benefits from using unnormalised data for specific access opaths; there are also consequences) outweigh the possible benefits from replacing them.

A longer article justifying these positions in detail will take a little time to prepare - but watch this space...®

Intelligent flash storage arrays

More from The Register

next story
Netscape Navigator - the browser that started it all - turns 20
It was 20 years ago today, Marc Andreeesen taught the band to play
Sway: Microsoft's new Office app doesn't have an Undo function
Content aggregation, meet the workplace ... oh
Sign off my IT project or I’ll PHONE your MUM
Honestly, it’s a piece of piss
Return of the Jedi – Apache reclaims web server crown
.london, .hamburg and .公司 - that's .com in Chinese - storm the web server charts
NetWare sales revive in China thanks to that man Snowden
If it ain't Microsoft, it's in fashion behind the Great Firewall
Chrome 38's new HTML tag support makes fatties FIT and SKINNIER
First browser to protect networks' bandwith using official spec
Admins! Never mind POODLE, there're NEW OpenSSL bugs to splat
Four new patches for open-source crypto libraries
prev story

Whitepapers

Forging a new future with identity relationship management
Learn about ForgeRock's next generation IRM platform and how it is designed to empower CEOS's and enterprises to engage with consumers.
Cloud and hybrid-cloud data protection for VMware
Learn how quick and easy it is to configure backups and perform restores for VMware environments.
Three 1TB solid state scorchers up for grabs
Big SSDs can be expensive but think big and think free because you could be the lucky winner of one of three 1TB Samsung SSD 840 EVO drives that we’re giving away worth over £300 apiece.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.
Security for virtualized datacentres
Legacy security solutions are inefficient due to the architectural differences between physical and virtual environments.