July 24, 2006

Multivalue in Access triggers religious war

The Register managed to inflame the faithful on all sides with its comments on the addition of multivalue datatypes to Access. Trying to soothe(?) matters, Mark Whitehorn makes some astute comments about data models in general. One of my favorite parts is some armchair psychology about people who, having learned one complex system, grow attached to it, regard it as the One True Way, and regard all alternatives as the work of the Devil. My other favorite part is this analogy:

Asking for my opinion on, for example, the multi-valued data type (MVDT) is like asking whether I approve of dynamite or not. I don’t have a view either way until I know the context.

“So, Mark, you think it is appropriate to carry dynamite in a crowded street do you?” No, of course not. The urban environment provides a very poor context for explosives. What about using it in controlled conditions to remove tree-stumps from the ground? Fine. …

In other words, neither dynamite nor MVDTs inherently display any “good” or “bad” qualities whatsoever. Such attributes depend entirely upon context.

Comments

One Response to “Multivalue in Access triggers religious war”

  1. DBMS2 — DataBase Management System Services»Blog Archive » Tom Kyte said it more concisely on July 24th, 2006 4:38 am

    […] Mark Whitehorn had a good article on the importance of horses-for-courses context. But Tom Kyte said the same thing more concisely: I believe strongly – and more strongly every day – that there are only two possible answers to a “first question”. They are: […]

Leave a Reply




Feed: DBMS (database management system), DW (data warehousing), BI (business intelligence), and analytics technology Subscribe to the Monash Research feed via RSS or email:

Login

Search our blogs and white papers

Monash Research blogs

User consulting

Building a short list? Refining your strategic plan? We can help.

Vendor advisory

We tell vendors what's happening -- and, more important, what they should do about it.

Monash Research highlights

Learn about white papers, webcasts, and blog highlights, by RSS or email.