>Concerning the use of floats for monetary quantities (which is an >obvious non-starter, no doubt), they talk about "developers, who >clearly forgot to attend CS 101 classes". > >Well, in my "CS 101 for non computer scientists" class they taught me >certain things that the developers behind Tryton obviously ignore. >And at least one of those issues is critical to data integrityWould be great if you can be more concrete and share the issues with the comunity.I have already done that, see: Message-Id: <[email protected]> The "response" from the developers was an obscene exhibition of their total cluelessness and carelessness for such critical issues as data integrity.
According to Ralph Kimball:
« Actually, a surrogate key in a data warehouse is more than just
a substitute for a natural key. In a data warehouse, a surrogate
key is a necessary generalization of the natural production key
and is one of the basic elements of data warehouse design. »
Or Bogdan Czejdo:
« In addition to providing a means to maintain the identity of
entities, surrogate keys are also useful for representing
relationships. »
And you can find thousands of papers discussing the pros and cons of
surrogate keys vs natural keys.
>Well, in my "CS 101 for non computer scientists" class they taught >me certain things that the developers behind Tryton obviously >ignore. And at least one of those issues is critical to data >integrity
Data integrity can be enforced by other means than purely relying on the database to do this job. It's above all a question of choosing the good trade-off. Moreover, I would like to say that uttering your certainties from your "CS 101 for non computer scientists" without even trying to understand that the issue is more complicated than what it seems to be is a recipe for being marked a troll. -- Nicolas Évrard B2CK SPRL 4, rue de Rotterdam 4000 Liège Belgium Tel: +32 472 54 46 59 E-mail/Jabber: [email protected] Website: http://www.b2ck.com/
signature.asc
Description: Digital signature
