In message
<f22433e8895313419b41ba386c0fdeea02125...@planomail.corp.tylertechnologie
s.com>, "Bessel, Karen" <[email protected]> writes
I'm with you there, Harold.
I don't agree that U2 is a match for any "real" RDBMS like SQL. It just
doesn't have the same capabilities. For example, referential integrity.
In SQL, it's there, it's built in, it's an integral part of the system
and you can't create "orphan records" if you set up your relationships
properly. In U2, you can do that too, with application programming -
lots and lots of programming, which can be (and often is) flawed. This
is just one example of WHY you can't compare U2 to other RDBMS on the
market - you're comparing pomegranates and pineapples, and when you are
done with your comparison, U2 comes up lacking.
Please - define "referential integrity". In a MV database, for the most
part, orphan records don't happen because MV *does* enforce integrity.
It just does it completely differently - it stores related attributes
together so they can't get orphaned, rather than scattering them across
multiple tables. As has been pointed out before, it's easy to make a
mistake when defining your relational database. Those sort of mistakes
just don't tend to happen with an MV database.
Don't get me wrong --- I love U2, and my career STARTed in a Pick shop.
I'm sorry to see where it's gone over the years.
Plus, to all the people out there who keep saying that it's us to list
members to convince our companies to stay with U2 instead of migrating
away, I say "Hogwash". In anything other than a small "mom & pop" shop,
programmers do not have ANY input into these kinds of decisions.
Management looks at a new and pretty system with lots of bells &
whistles, and they don't really care what platform is running on - "We
have to have it".
I'm inclined to agree with you about PHBs ... but as for MV not having
things like referential integrity, why not? It's easy enough to enforce
it. Just like all the alleged advantages relational has, it's EASY to do
in MV. You just have to think a little, and it's a shame it's not part
of the basic system.
But that gives us flexibility, which relational doesn't. How often do
you hear of relational shops mired in concrete. And the MV shops run
rings around them - projects ON time, ON budget, and ON target!
Cheers,
Wol
--
Anthony W. Youngman <[email protected]>
'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the
thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man
lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998
Visit the MaVerick web-site - <http://www.maverick-dbms.org> Open Source Pick
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
