Feeds

Multivalue datatypes

What a lot of people like repeating groups...

Security and trust: The backbone of doing business over the internet

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...®

Security and trust: The backbone of doing business over the internet

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
'Windows 9' LEAK: Microsoft's playing catchup with Linux
Multiple desktops and live tiles in restored Start button star in new vids
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
Google extends app refund window to two hours
You now have 120 minutes to finish that game instead of 15
Intel: Hey, enterprises, drop everything and DO HADOOP
Big Data analytics projected to run on more servers than any other app
Mozilla shutters Labs, tells nobody it's been dead for five months
Staffer's blog reveals all as projects languish on GitHub
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

Providing a secure and efficient Helpdesk
A single remote control platform for user support is be key to providing an efficient helpdesk. Retain full control over the way in which screen and keystroke data is transmitted.
WIN a very cool portable ZX Spectrum
Win a one-off portable Spectrum built by legendary hardware hacker Ben Heck
Saudi Petroleum chooses Tegile storage solution
A storage solution that addresses company growth and performance for business-critical applications of caseware archive and search along with other key operational systems.
Protecting users from Firesheep and other Sidejacking attacks with SSL
Discussing the vulnerabilities inherent in Wi-Fi networks, and how using TLS/SSL for your entire site will assure security.
Security for virtualized datacentres
Legacy security solutions are inefficient due to the architectural differences between physical and virtual environments.