Re: In an RDBMS, what does "Data" mean?
From: Anthony W. Youngman <wol_at_thewolery.demon.co.uk>
Date: Sat, 10 Jul 2004 23:46:19 +0100
Message-ID: <STaqJ8K7GH8AFwpy_at_thewolery.demon.co.uk>
Date: Sat, 10 Jul 2004 23:46:19 +0100
Message-ID: <STaqJ8K7GH8AFwpy_at_thewolery.demon.co.uk>
Let's be practical, not theoretical ... :-)
And anyway, let's contrast it with a relational database. The rdbms will have an attribute called "sort order" or similar, and it won't have a clue what to do with it. It's up to the app to update that attribute, so whether you have an MV or an R dbms, it's up to the app to control what happens when the data is changed. It's just that "order" is metadata to an MVdbms, but data to an Rdbms.
So the cost is identical, whichever dbms model you are using. But MV scores because it understands and can take advantage of order, if it's appropriate.
Cheers,
Wol
-- Anthony W. Youngman - wol at thewolery dot demon dot co dot uk HEX wondered how much he should tell the Wizards. He felt it would not be a good idea to burden them with too much input. Hex always thought of his reports as Lies-to-People. The Science of Discworld : (c) Terry Pratchett 1999Received on Sun Jul 11 2004 - 00:46:19 CEST