Re: Pizza Example
Date: Sun, 18 Apr 2004 23:46:30 +0100
Message-ID: <CbzHNpBGVwgAFwaa_at_thewolery.demon.co.uk>
In message <pan.2004.04.18.01.32.20.45299_at_erols.com>, Jerry Gitomer
<jgitomer_at_erols.com> writes
>>>You still persist in believing that nonsense about "losing information"
>>>by decomposing data? This just reflects your ignorance of how an RDBMS
>>>works, and it is time you rectified that.
>>
>> It happens in the scientific world all the time. Why should the data world
>> be any different?
>>
>Because data integrity standards are much more rigorous in the commercial
>world than in the world of science. For example, it is not at all unusual
>for a scientist to be pleased that 90% of the sample data collected on a
>project is good data and only 10% is bad data that will be discarded
>and/or ignored. When it comes to dealing with payroll data, payables and
>receivables, and inventories anything less than 100% is unacceptable and
>checks and balances are built into commercial systems to insure that all
>of the data is collected and that, before it goes into the database,
>all is valid.
The standard version of the law is basically "in any closed system, any change will increase entropy". A physicist would also recognise and accept the following paraphrase - "in any closed system, any change will destroy information" - the terms "entropy" and "information" are recognised as a sort of opposite (I can't remember the detail, it's too long ago).
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 Mon Apr 19 2004 - 00:46:30 CEST